I am trying (very slowly) to migrate data from a filemaker solution to my newly built servoy version. I used Excel as a broker between the two because I was having weird issues with .tab files. I didn’t know until it was way too late that Excel has a maximum character limit on cells. My data was imported but half of my notes fields were missing. In trying to fix this, I am importing again to a new related table from which I am going to loop / import the correct data if it differs. While trying to actually perform the import, I am getting (on record 230) an error: bitIndex < 0: -1
I have looked at this record in text and cannot see anything untoward about it.
I’d be grateful for any pointers on how to clean up filemaker pro text for import into a servoy field. Anyone seen that error before?
Anyone who has this trouble in the future, my solution was to export from filemaker as a tab delimited text file, open that in excel, check the lengths of the cells (which magically worked this time), save as xls and import that into servoy…
I am trying (very slowly) to migrate data from a filemaker solution to my newly built servoy version. I used Excel as a broker between the two because I was having weird issues with .tab files. I didn’t know until it was way too late that Excel has a maximum character limit on cells. My data was imported but half of my notes fields were missing. In trying to fix this, I am importing again to a new related table from which I am going to loop / import the correct data if it differs. While trying to actually perform the import, I am getting (on record 230) an error: bitIndex < 0: -1
I have looked at this record in text and cannot see anything untoward about it.
I’d be grateful for any pointers on how to clean up filemaker pro text for import into a servoy field. Anyone seen that error before?
Thanks
Bevil
As Graham noted I have had also good experience in exporting in .mer format on FileMaker side (don’t forget to change the extension to .csv as export file name) and importing that file into Servoy - no other steps between. Worked so far well for me.
An invaluable tip from Johan Compagner to replace the graphic characters that Filemaker exports instead of carriage returns in text files. Replace the ‘#’ below with the FM character as it doesn’t show up on this list.
with a simple javascript you can make then linebreaks again:
For dates fields, I set my FileMaker layout date format to mm/dd/yyyy and then when exporting check off the option to “Format output using current layout”. If there are any date problems, I can then quickly locate them by performing a sort on the exported data by the date field.