topic Re: 'Import Multiple Files' ignores empty lines in CSV in Discussions

'Import Multiple Files' ignores empty lines in CSV

A_Zaid — Sat, 10 Jun 2023 23:15:45 GMT

Hello JMP Community,

Whilst trying to import CSV files to JMP 15, I noticed that JMP does not recognise a skipped line in the CSV file. Ideally, JMP should recognise it and translate it into a skipped row in the data table. The only two ways I found to make it recognise it is either by opening the CSV file and adding a comma to the empty/skipped line, or by unchecking both the <CR>+<LF> and <CR> boxes in the settings of the import window (File > Import Multiple Files > Settings) and only leaving the <LF> box checked (as opposed to having all three boxes checked). The first solution is laborious if I want to import many CSV files, and the second creates more issues than it solves as the CSV file uses <CR>+<LF> as well. So, I would appreciate if you could let me know how I can overcome this issue efficiently.

Thank you all in advance!

Ahmed

Re: 'Import Multiple Files' ignores empty lines in CSV

martindemel — Fri, 10 Jul 2020 11:17:51 GMT

As this question is some days old with no answer, just a short comment:
I haven't got time to investigate, but in case skipping lines works for importing one csv file but not using Import Multiple Files, you may want to send it to JMP's Technical Support (support@jmp.com) so they can investigate to see if there is a missing functionality or a bug or something else.

Re: 'Import Multiple Files' ignores empty lines in CSV

A_Zaid — Tue, 14 Jul 2020 14:54:57 GMT

Thank you for the referral, Martin.

Re: 'Import Multiple Files' ignores empty lines in CSV

martindemel — Tue, 14 Jul 2020 15:17:55 GMT

it would be great if you get an answer, you could share it here so others can benefit as well. Thanks :)

Re: 'Import Multiple Files' ignores empty lines in CSV

A_Zaid — Tue, 14 Jul 2020 15:44:29 GMT

Yes, with pleasure. Thank you for the thoughtful suggestion, Martin.

Re: 'Import Multiple Files' ignores empty lines in CSV

A_Zaid — Fri, 24 Jul 2020 07:58:55 GMT

Hi everyone,

A member of the JMP Technical Support got back to me with the following answer:

"After consulting with my colleagues we believe that this is indeed a bug with JMP's Multiple File Import tool. I have entered a Defect and let development know about MFI's inability to recognize a skipped line in a csv file. Hopefully the development team can work in a fix for an upcoming version of JMP."

Re: 'Import Multiple Files' ignores empty lines in CSV

martindemel — Mon, 31 Aug 2020 08:46:35 GMT

thanks for sharing the response from Tech Support.

Re: 'Import Multiple Files' ignores empty lines in CSV

A_Zaid — Tue, 22 Sep 2020 14:03:48 GMT

Pleasure!