Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

CSV Import Issue

Hap
in Importing & Exporting

Featured Replies

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.

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.

  • 2 months later...
  • Author

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 by Guest

Create an account or sign in to comment

https://fmforums.com/topic/38615-csv-import-issue/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.