Hi, I would like to map a single outlook field to 2 or more field in our slq database. how can i edit my .ini file to accomplish that?

My outlook business address field should be mapped to my mssql address1, address2 and adddress3 fields. Thanks in advance for being helpful.

Outlook Field =====DB Field
Business Address=====Address1
.ini
Business Address=address1,

Hello,

it is not possible to map 1 Outlook field to multiple DB fields. You can create a view to accomplish this.

Many thanks for your reply. Can you please post a tutorial/example to enter on db views in geniusconnect config | database | assign table | filter rows.. |. Thanks.

Please see topic:
http://support.geniusconnect.com/Posts/t59- 

Thanks once again. What I really wanted to find out, is how I can enter my sql values inside your filter rows window:
example:
my db_user_name=db_x
my db_login_user=db_x
my db_login_user=db_x
my db sql statement=SELECT * FROM vdiary

The vdiary view has already been created and tested in our mssql.

Now, could please explain what values to enter on the filter rows window?

Dynamic parameter: ?????????? [Insert]
Current param value: ?????????
Do not use WHERE keyword.
Example WHERE clause......
?????????????????????????????
?????????????????????????????
?????????????????????????????
??????????????????????????????

Thanks.

Please see also Help File topic "Filter rows"

It is possible to enter a SQL Where clause to limit the records in the result set.
Where clause can be a static SQL Statement (example: CoutryCODE= ‘US’)
Or dynamic parameter can be used.
Select the parameter in the combo box and click the Insert button, the parameter will be inserted in the edit field.
During the synchronization, GeniusConnect will replace the parameter tag with current system values:

{DB_LOGIN_USER} runtime value:
Login used to connect to the database (NT User if NT security used)

{DB_USER_NAME} runtime value:
Username returned by the database
{WINDOWS_USER} runtime value:
Current windows (NT) user

Use the "Test Query" button to check if your statement is correct!

Example WHERE:
col_User = '{DB_LOGIN_USER}'

Runtime translation:
select ... from "dbo"."Calendar" where col_User = 'sa'