seangarcia
2006-10-19T20:43:00Z
My situation is unique, or so I think. I have a SQL Server running on SBS 2003. My POS software is where we keep all of our customer information. Our customer are renting merchandise from us. Account turnover is high, and information changes day-to-day. Here's what I want to do...
- I want to sync certain contact information from the SQL Database (RAMSYSTEM) into Outlook 2003.
- The table I am pulling from is (dbo.customer)
- Each customer has a unique 'customerid' in the database already.
- What is the SQL statement I need to use to set that Customer ID to the Primary Key?
- What is the SQL statement syntax I need to use to set each other field as a Mandatory Key?

I'm familiar with SQL Statements but I have been unsuccessful with the Initial Sync feature of your software. I am running the 30-day trial version of your software, but intend on purchasing depending on its ability to accomplish my goals.

-Thanks,
Sean Garcia
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2006-10-19T21:15:00Z
Hi,

"What is the SQL statement I need to use to set that Customer ID to the Primary Key?"
This depends on the datatype, please open the Primary/Mandatory keys dialog and hit help button.
The Helpfile contains examples.

"What is the SQL statement syntax I need to use to set each other field as a Mandatory Key?"
You need to set SQL statement for Mandatory fields only if the field is mandatory in the table and it is not linked to a Outlook column.
The syntax depends also on the datatype, see same help topic.

Initial sync function:
You don’t have to use this function if:

·Outlook folder is empty
·Database table is empty
·Outlook Items are not present in the database or can not be matched with existing records

See also help for more info:
https://www.geniusconnec...WebHelp/InitialSync.html