AnsweredAssumed Answered

FM Pro Adv 16 CSV Import Issue

Question asked by mdaniel27 on Mar 27, 2018
Latest reply on Mar 27, 2018 by beverly

Environment: Windows 10 with FM Pro Adv 16

I am renaming a comma delimited ,txt file to .csv so that it imports properly.

For some reason FM is not truly using the Commas as CSV like it should in example:

FMCSVImportError1.png

here you can see that it imported commas as part of the data instead as using it as a FieldMarker.

It seems to continue on until it gets worse and imports with this message:

FMCSVImportStatusMSG.png

Problems is there are 85,000+ records.

Below is record 35,117, 35,118, 35,119;  At the bottom is a snag of the FM screen after the

import showing where it stopped at rec 35,118.

 

RED00159633,,GENWIRE CK-12 COPPERKEY COPPER PIPE PREP TOOL .5",E,28.13,0,2481,1,0,0,0,0,0056,TOOLS-CUTTERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,229987,20150901,,

RED00159634,,GENWIRE CK-34 COPPERKEY COPPER PIPE PREP TOOL .75",E,30.04,0,2481,1,0,0,0,0,0056,TOOLS-CUTTERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,229988,20150901,,

WPR00122615,,GENWIRE SUS SUPERSLICE TUBING CUTTER,E,43.57,0,2481,1,0,0,0,0,0056,TOOLS-CUTTERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,378111,20150901,,

FMrec35118.PNG

The data in the 2nd field had 5 additional records in it :

**

GENWIRE CK-34 COPPERKEY COPPER PIPE PREP TOOL .75,E,30.04,0,2481,1,0,0,0,0,0056,TOOLS-CUTTERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,229988,20150901,,

WPR00122615,,GENWIRE SUS SUPERSLICE TUBING CUTTER,E,43.57,0,2481,1,0,0,0,0,0056,TOOLS-CUTTERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,378111,20150901,,

WPR00283374,,GENWIRE D-25-2 25 HANDY WITH CABLE .25X25',E,251.06,0,2481,1,0,0,0,0,0272,TOOLS-DRAIN CLEANERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,520487,20150901,,

WPR00283376,,GENWIRE D-25-2A 25 HANDY WITH CABLE .3125X25',E,265.52,0,2481,1,0,0,0,0,0272,TOOLS-DRAIN CLEANERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,520488,20150901,,

WPR00283380,,GENWIRE D-25-8 25 HANDY WITH CABLE .25X25',E,235.72,0,2481,1,0,0,0,0,0272,TOOLS-DRAIN CLEANERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,520489,20150901,,

WPR00283382,,GENWIRE D-25-8A 25 HANDY WITH CABLE .3125X25',E,250.17,0,2481,1,0,0,0,0,0272,TOOLS-DRAIN CLEANERS,000190,GENERAL WIRE,1,1,S2018-00,20180212,,520490,20150901,,  **

 

Anyone have any idea what would cause this and if there is a better way to get this data in correctly

just with filemaker?  If I use Excel I can get it to work every time. (Guess excel has better import processes).

Outcomes