The Add or Update command for data imports using zohocreator.exe is described as follows
-------------
Add Or Update
zohocreator.exe <filepath> <username> <password> -e <appname> -au <formname> <fieldname> <columnname>
Eg : zohocreator.exe c:\myfolder\ordermanagement.csv john mypassword -e order-management -au order_form Items Products
------------
Pls provide a quick summary of how this works as the command is unclear - would like to update a Products table with addition of new records (but only if the Product does not already exist)
Questions are..
1) What does <fieldname> <columnname> refer to?
2) Is <columnname> the unique key in the target form? (eg unique Product id in my use case)
3) if the csv file contains 5 columns, do all 5 columns get updated in the target form (if the unique key exists) or is it just the <fieldname> that gets updated?
Thanks