Jump to content
Sign in to follow this  
Stephen Slater

Imports FM 9

Recommended Posts

I have a csv file that I am importing as a trial.

When I open the csv file in Excel I have 4140 rows of data with 20 columns per Row

When importing into FM I have 4576 records visible and the last 120 rows are full of incorrect data.

I suspected that the issue was with commas in the csv file, 

However, If I split the csv file in Excel into 2 .xls files and import them separately every this is perfect so I don't see the problem being within the csv file

Is there an issue in FM that only allows a certain amount of data to be imported?

 

Thanks in advance

 

 

Share this post


Link to post
Share on other sites

The problem here is often the "format" of the CSV. If the data has a comma in it, the value needs to be surrounded by double quotes.

Quote

"some data",1,45.4,"some data, with a comma"

If the csv is created by Excel, or was opened in Excel, sometimes it's tries to do some conversion for you. Sometimes that helps, sometimes not. So you really need to look at the csv itself.

Share this post


Link to post
Share on other sites

Hi Josh

I understand that possibility but like I said without any other changes if I Copy out half the data into a new file and them import both files all is well.

\it seems like an quantity issue to me that FM cant handle, strange one this

Share this post


Link to post
Share on other sites

In your original post, you said you are splitting the file "into 2 .xls files". You are making a change, and then resaving them.

  1. If you are saving them as .xlsx or .xls files, you have committed a format change. This is where Excel is helping you.
  2. Even if you are resaving them as CSV, Excel is still post-processing the data.

My point is, the problem is likely the data. Once you determine what exactly is malformed in the file, then you can begin to figure out how to deal with that.

FileMaker handles CSV data really well, but that requires it to be true CSV and not pseudo-csv.

Share this post


Link to post
Share on other sites

If it's not sensitive data, you can post a sample here, and we can help you figure out the problem, and possibly suggest how to address it.

Share this post


Link to post
Share on other sites
3 hours ago, Stephen Slater said:

Is there an issue in FM that only allows a certain amount of data to be imported?

 

4000 records with 20 fields is practically nothing. The fact that you get more records than you expect suggests that some fields contain carriage returns which Filemaker interprets as record delimiters, but Excel does not.

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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