How To Import Bulk Records That Use Unique Or System Generated Fields

[Berean]

May I ask for some advice on how to import or create bulk records using unique fields?

 

Using a datapage form is too slow if I want to add thousands of records.  But My forms have unique fields (GUID) that is system-generated (It's necessary for linking separate datapage results reports with detail reports).  They also use system-generated date-timestamp fields.

 

How can I import bulk records from a csv or spreadsheet without using datapages while at the same time meeting the unique field requirements.  When I tried importing a csv file I got the screenshot below.

[Jan]

Hi Rishiforum,

 

If I understand correctly, you have fields in your table, that are selected as "Unique". As far as I know, if this option is selected, in the section below you can specify if blank values are allowed.

You can edit your table and allow blank values.

 

I hope, it helps.

[iren]

Hello Berean,

 

I would recommend you to create new table when you import data with unique fields. You can find the screenshot in the attachment.

 

Please refer to this article for further information: http://howto.caspio.com/files-and-images/bulk-file-import-and-export/

 

Hope it helps.

[rishiforum]

I have the same question.

[Berean]

Hi Jan, thanks for the advice. Though I am no longer able to enforce a unique field in my table, it serves my purposes for now.