I’ve exported my data into a txt-file with tab separation. When I want to import I get problem with my primary key, it says that I don’t have unique values. Does this mean that in my first column I need to have a unique id. I have about 4.000 records I have to import, but they don’t have a unique numbering, it are bloodresults form different patients (with unique patientnumber)on different dates. Do I have to make a new field in Filemaker to number all these results before I can import them into Servoy.
yes. just create an record ID number and runa script to load the id’s
I also tried to import data without making a script to number the id used in Servoy. I didn’t use the first column Servoy makes on which Servoy makes its primary key. I created the same number of columns I used in Filemaker. After importing I noticed that Servoy numbered the column with the primary key by itself.