Import file csv for create a new Form ad update the data

[Luca Martignoni]

Hi,
i’m a new user. I have this question:
I created a New Form with the import csv file.
I edited this form (delete and add some fields ).
Now I want take this form updated. Sometimes I want import another version of the file csv with some new records and/or difference values (like an update).
If I try re-import I have the duplicate-actions on all the records.
Have I any solution ?

Tnx and sorry for my english

Luca

[Luca Martignoni]

I have Tap Form HD per iPad vers. 4.0.1.

[Brendan]

Hi Luca,

You would need to export your data from Tap Forms and then edit it outside Tap Forms, then re-import your data to get an update. But only if you also have the Export Record IDs function enabled on the Import & Export Settings screen.

This is because Tap Forms will add a form_record_id column to your CSV file that will contain a unique ID for each record. When you import a file with that column, Tap Forms will look for existing records with the same ID internally in order to update them. If it finds them, it updates them, if not, it adds a new record to the form.

So that’s how you can avoid duplicates when you re-import.

Thanks,

Brendan

[Luca Martignoni]

Hi Brendan,
tnx for your answer.
I tried your solution but my problem it’s the same.
I had export the records with all the fields with the EXPORT RECORD IDs included.
I had modify the csv file with new records and any rows udpdated. The file had form_record_id as a first column.
I had import the file into my FORM but I had not a syncronization, I had a duplication.
The new records was all empty record.
The old records had a new field ‘form_record_id;Copertina’.
‘Copertina’ is the first field of my form, it’s an image’s field.

This is an example of the csv file i try to import:

form_record_id;Copertina<photo>;objectname<text>;objectid<number>;rating<rating>;numplays<text>;own<text>;fortrade<text>;want<text>;wanttobuy<text>;wanttoplay<text>;prevowned<text>;preordered<text>;wishlist<text>;wishlistpriority<text>;wishlistcomment<text>;comment<text>;conditiontext<text>;haspartslist<text>;wantpartslist<text>;collid<text>;baverage<text>;average<text>;avgweight<text>;rank<text>;numowned<text>;objecttype<text>;originalname<text>;minplayers<text>;maxplayers<text>;playingtime<text>;maxplaytime<text>;minplaytime<text>;yearpublished<text>;bggrecplayers<text>;bggbestplayers<text>;bggrecagerange<text>;bgglanguagedependence<text>
18D95F94-9F0E-4ED7-A22B-798F05B1D1C7;;12 Realms;68606;;0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
FDE01562-F020-492C-9700-CCAF8075E77E;;1655: Habemus Papam;82955;0;0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
021B070D-4C61-4703-AA79-5EA1EA10292F;;1911 Amundsen vs Scott;124847;0;0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
0891B4F7-DF84-4F5B-A5E0-B389BFAA4513;;51st State;73369;6;1;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
12D7DD19-A632-458F-B96C-1D91B313D83A;1F727970-6CBA-4A3C-9543-5B5EE7BF3566.jpg;7 Wonders;68448;6;3;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Where is my mistake ?

Tnx in advance,

Luca

[Brendan]

Hi Luca,

Did you make sure you set the Column Delimiter setting to semi-colon ; before you imported? Not having the Column Delimiter setting set correctly would definitely cause this problem.

Thanks,

Brendan

[Author]

Posts