Hi,

I have a view in my SQL database containing details of customers from our ERP system that I am trying to insert into a public folder on Exchange. I have successfully done this with other folders (same and different item types). I have a CRM Company folder and a CRM ERPDetails folder. I can succesfully populate the CRM Company folder with all the static data in custom form types but trying the very same thing with the CRM ERPDetails items (which are of a different form class) gives the error "Cannot post this form to this public folder" after loading a certain number of items. The folders are restricted to only allow their respective forms and I have set the MessageClass field in SQL to match this. GC loads a different number of items everytime before failing and it always fails on a different item.

I have no such problem with the CRM Company folder - all items load and are complete. When I change the option on the ERPDetails folder to allow the custom form and the default forms, the load succeeds but successive store all/load all events destroy the MessageClass property. This has been driving me up the wall for days now!

Any help would be greatly appreciated.

Dan Allason

# Exported settings file of Genius@WORK OutlookConnect
# Comments are allowed on a single line only!

[Fields]
# Format: outlookfield=column,conversion
Company (Name)=OCS_COMPANYNAME,
Customer ID=OCS_CUSTOMERID,
File As=OCS_FILEAS,
Message Class(Form Description)=MessageClass,
AccNo(User Defined Type)1=AccNo,
CostLastYear(User Defined Type)14=CostLastYTD,
CostYTD(User Defined Type)14=CostYTD,
CreditLimit(User Defined Type)14=CreditLimit,
IndustryType(User Defined Type)1=IndType,
LastPaymentDate(User Defined Type)5=LastPaymentDate,
LastSaleDate(User Defined Type)5=LastInvDate,
LedgerBalance(User Defined Type)14=LedgerBal,
Open(User Defined Type)1=Open,
OpenDate(User Defined Type)5=OpenedDate,
OrderBalance(User Defined Type)14=OrderBal,
OrdersOK(User Defined Type)1=OnStop,
PaymentDays(User Defined Type)3=AvgPayDays,
Rep(User Defined Type)1=Rep,
SalesLastMonth(User Defined Type)14=SalesLastMonth,
SalesLastYear(User Defined Type)14=SalesLastYTD,
SalesMTD(User Defined Type)14=SalesMTD,
SalesYTD(User Defined Type)14=SalesYTD,

[PrimaryKeys]
# Format: column=newstatement
OCS_ID=SELECT NEWID()

[MandatoryKeys]
# Format: column=newstatement
OCS_ID=SELECT NEWID()
OCS_CUSTOMERID=

[WhereFilter]
# Format: WHERE=statement
WHERE=

[OptionsWhereFilter]
# Format: WHEREOPTIONS=X,X 0 or 1 IgnoreForUpdate,IgnoreForDelete
WHEREOPTIONS=0,0

[FolderOptions]
# Format: OPTIONS=X,X,X. 0 or 1 values slash for advanced options in format:NOPRIVATE,NOOUTLOOKUPDATE,NODBUPDATE,,,DELOUTLOOK_ITEM,DELDB_RECORD,BLOCKDELETECONFIRM,DBTIMEOUT,BLOCKDB_DELETECONFIRM\USE_LASTMODIFICATION_TIME,CONFLICT_RESOLUTION
OPTIONS=
# Format: InsertSQLCmd=statement,UpdateSQLCmd=statement,DeleteSQLCmd=statement
[InsertSQLCmd]
InsertSQLCmd=

[UpdateSQLCmd]
UpdateSQLCmd=

[DeleteSQLCmd]
DeleteSQLCmd=

Hi,

the problem is obviously related to custom form and/or permission, it is difficult to give you some hint since we have no info
about the config.

What is the Folder type? (I assume it is a Contact folder)
What is your GeniusConnect version?
Can you try to NOT link the MessageClass field to a DB field, and let Exchange decide the default form?

Sorry - preempted you a bit there. OC version is 3.0.1.1 and the folder type is contacts.

The only special handling in GeniusConnect for MessageClass values is for Mail/Post folder types.
GeniusConnect is using Folder default for all other Folder types, so it must be something in Exchange/your form.



(you can update to the latest version in third edition 3.0.1.2SP3:
http://www.geniusconnect...es/GeniusConnect/2/3/53/  )

OK - I did have my suspicions that it might not be your software. Thanks for your help.