Hi, I think it is not explicitly necessary to generate the id in the import file. I understand that joget, in any generation of records, generates it automatically and is also by default the primary key. What I have done before to use this feature successfully is:
1. Create the form and put it as FORM in a userview
2. Publish and through the link in the userview fill out a test record. With this, Joget creates the table for the first time.
3. Review and adjust directly in the BD the fields of the table created by Joget to what is needed to preserve data integrity and its nature (for example to make the BD more efficient the type of field is very important, create indexes of search or additional restrictions).
4. Verify, with another test record, that Joget is able to include a new record with the modifications in the BD.
5. Create the Import Menu in the userview and use in the file only the fields that the form requires explicitly, without the control fields like the Id, the dates and the usernames. Mark validation as necessary.
