# importing data from Filemaker **URL:** \ **Category:** Classic Servoy\ **Created:** [September 24, 2004, 7:53am UTC](https://forum.servoy.com/t/importing-data-from-filemaker/2766 "2004-09-24T07:53:46Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![bart](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@bart](https://forum.servoy.com/u/bart)\ **Post date:** [September 24, 2004, 7:53am UTC](https://forum.servoy.com/t/importing-data-from-filemaker/2766/1 "2004-09-24T07:53:46Z")
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. ---
**Author:** ![ebrandt](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ebrandt](https://forum.servoy.com/u/ebrandt)\ **Post date:** [September 24, 2004, 12:14pm UTC](https://forum.servoy.com/t/importing-data-from-filemaker/2766/2 "2004-09-24T12:14:22Z")
yes. just create an record ID number and runa script to load the id’s ---
**Author:** ![bart](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@bart](https://forum.servoy.com/u/bart)\ **Post date:** [September 27, 2004, 6:35am UTC](https://forum.servoy.com/t/importing-data-from-filemaker/2766/3 "2004-09-27T06:35:13Z")
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.