gast2
2016-09-26T14:58:00Z
I have downloaded the most recent evaluation version and I am trying to sync a test Access database with what I believe is an Outlook Exchange and 365 Office account. I managed to create the database and make it show up in GC eventually.
Now I am stuck in the assign table box.

When I click to import the example template I get a file import error message. How do I make the Outlook fields match up with the database column headings? Do I need to make my own configuration settings file to import? How do I make this?

When I click ok, it says 'The tabel must have at least one primary key'. It has a primary key in Access (Id). When I click the Mandatory Keys box and set the Id from Mandatory key to Primary key it says:

'A statement to retrieve a new value for each primary key/mandatory field must be specified. GeniusConnect will be unable to insert new items in the database. Store the settings anyway?'

What does this mean?

I do not know how to go forward.

also: is it possible to use GeniusConnect with a public folder? because if not, I should quit now.
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2016-09-26T15:12:00Z
Hello,

Are you using the MS Access example database (optional in installation) or your own table ? The example template works only with the example database.

'A statement to retrieve a new value for each primary key/mandatory field must be specified. GeniusConnect will be unable to insert new items in the database. Store the settings anyway?'
It means GeniusConnect will not be able to insert new records to your database, since it does not know how to generate or retrieve a value for Primary Key. For More info and example SQL statements hit F1 or Help button in the Mandatory Keys dialog.

Yes, it is possible to use GeniusConnect with Public Folders, you will need a Multi User license.

http://www.geniusconnect...es/GeniusConnect/2/3/54/ 
gast2
2016-09-27T09:19:00Z
Thank you for your quick response.

I am using my own table in a new Acces database which I've called 'Test' with a fraction of the data I would like to put in the Contacts database eventually: 9 rows and 20 columns.

I am trying to follow the video that shows how to sync an Access database with Outlook but I get stuck.
My main questions are:
How do I get configuration settings that make the Outlook Fields the same as the Column headings in Access without any error messages?
How do I click on Ok afterwards without the primary key error message? (i.e. how do I make it work?)
Will I need to buy the Multi-user license before I can test a public folder? Or is testing unnecessary because the procedure for syncing between Access and a Public folder is exactly the same?
Administrator
2016-09-27T10:31:00Z
"How do I get configuration settings that make the Outlook Fields the same as the Column headings in Access without any error messages?"
The templates are only used to Import/Export configuration. You must configure mappings to your table in the Assign Table Dialog, Please watch this video, it is about mail folder sync, but the idea is exact the same:


"How do I click on Ok afterwards without the primary key error message? (i.e. how do I make it work?)"
You must provide a SQL Statement for Primary Key value retrieval in Mandatory Keys dialog, if you will sync only in one direction DB->Outlook, you can ignore the warning

"Will I need to buy the Multi-user license before I can test a public folder? Or is testing unnecessary because the procedure for syncing between Access and a Public folder is exactly the same?"
http://www.geniusconnect...les/GeniusConnect/2/3/4/ 
gast2
2016-09-28T11:21:00Z
So I have looked at SQL statements in the Help window Primary & Mandatory keys and input this as an SQL statement:
select Iif(max(Id) is null, 0,max(Id) + 1) from Test

based on this example in the Help window:
select Iif(max(YOUR_COLUMN_NAME) is null, 0,max(YOUR_COLUMN_NAME) + 1)
from YOUR_TABLE_NAME

when I test query it says: 10
What is wrong, how do I fix it and what would need to come out of the test query to know that it is right?
Administrator
2016-09-28T11:37:00Z
Why is it wrong ? Are you getting any errors ?



If your Table primary key is defined as AutoNumber (auto increment), you can also use SELECT @@Identity and set the Identity(Auto Increment) to Yes.

From the help File:
Identity (also Auto Increment, AutoNumber etc.)
Yes=database automatically generates values during insert. (disabled when specifying mandatory keys for Attachments mapping )
No=Value must be provided with the Insert statement

For More info see Help topic: Mandatory keys
Administrator
2016-09-28T11:40:00Z
Also Please note that the help file contains only examples, the real implementation depends on your table layout, primary key datatype etc...

If you are not familiar with Data types, tables etc.., use the example tables and example mapping templates provided in the installation
gast2
2016-09-28T11:54:00Z
When I check the 'show database values' box, it shows nothing.

When I got to options to set the synchonisation settings, I cannot check any boxes - they're greyed out.

Is it because all categories from the database MUST be linked with Outlook fields? I tried to only link one for now.
gast2
2016-09-28T11:59:00Z
My understanding was that the DB datatypes had to match up with the Outlook field datatypes. The layout of my table is simply an Id column with an int datatype and varchar for the 8 other columns. That's it. I figure I can match those to Outlook fields that have the same datatype and mean about the same. Or am I missing something really important? Do the column headings (DB fields) have to have the same name as the Outlook fields or something like that?
Administrator
2016-09-28T12:05:00Z
"When I check the 'show database values' box, it shows nothing."
it will show values of a column in your table, so when this check box is ON, select a row where Outlook column is mapped to a Db column and it will show example of first X column values

"When I got to options to set the synchonisation settings, I cannot check any boxes - they're greyed out."
http://www.geniusconnect...es/GeniusConnect/2/3/54/ 


"Is it because all categories from the database MUST be linked with Outlook fields? I tried to only link one for now."
no, how many DB columns you map to Outlook columns is up to you
Administrator
2016-09-28T12:10:00Z
"My understanding was that the DB datatypes had to match up with the Outlook field datatypes. The layout of my table is simply an Id column with an int datatype and varchar for the 8 other columns. That's it. I figure I can match those to Outlook fields that have the same datatype and mean about the same. Or am I missing something really important? Do the column headings (DB fields) have to have the same name as the Outlook fields or something like that?"

No, you can use any column names, also if the Outlook datatype differs from DB Column datatype, in many cases GeniusConnect can convert it for you, for more info and supported conversions please see help topic: Conversion

Obviously certain conversions are not possible, example: Contact First Name can't be converted to a datetime DB column
gast2
2016-09-28T12:16:00Z
It works.

Thank you very much for your patience with my novice questions.

I think I will be requesting a multi-user evaluation version soon. And possibly returning here with more questions.
gast2
2016-09-28T17:29:00Z
Another question:
No matter how much I stare at the list of Outlook fields in the Assign Table dialog, I cannot find the standard 'Notes' field. Where is it? Is it there?
Administrator
2016-09-29T10:38:00Z
hello,

Please see the Body column
gast2
2016-09-29T13:49:00Z
I do not know where to find this 'Body column'
Administrator
2016-09-29T14:32:00Z