CSV Import Issue

[Hap]

I'm having an issue with FM8 Advanced having an issue importing CSV.

For any database created under 8, the CSV import gets hosed. Looks great in the import dialog and I can preview every record just fine, however the actual import does not match the preview. Basically the first record imports perfectly, the second record imports the wrong data (about half way through the second record) and this just ripples through the entire file. For one of hte problem imports I get 503 records when I supposed to get 963 records. This does not happen in any of my databases upgraded from FM 7 to FM 8 - they still import fine.

Same issue occurs on both Windows or Mac no matter what I do in the import dialog. So far my only solution is to open the CSV file in Excel and save as a workbook. FM 8 import correctly then, but this really breaks the automated import ability in my delployed solutions.

I've searched the forums and googled and not found any similiar reports. Any suggestions are welcome.

[CyborgSam]

Welcome to the Forums!

I assume you tried the exact same CSV file in the created vs upgraded databases.

Can you post the first few record (including one that gets hosed)? I suspect there's a character in it causing fields to be broken. The main suspects are quotes and backslashes.

[Hap]

Sorry, I gave up on getting a response way too soon. Came back for a different reason. However, to answer your question, I cannot post the contents of the file. Propietary data. However, I am confused by the fact the import preview box shows each record properly but the actual import is so different. Basically it imports Record 1 fine, the second record contains data from the first row of the CSV file, rows 2 and 3 are completely missing and row 4 shows up as record 3. Seems like the pattern repeats.

There is a series of data in row one something like this:

Document 1, Directory/Path/To/Performance/Data,Joe,1.0889,1/15/06 10:35,"Requiment text changed","MBM.343435,MBM3535"

The MBM.343435 is where the second record starts - it is still part of the first CSV row. It should be noted that I don't import all of the data in the CSV file, it is a dump from a high-end requirements tool and I just import what I need to use.

Thanks

Edited January 31, 2006 by Guest