InfoQube IM - Community

Submitted by jan_rifkinson on 2011/03/02 15:03

For some reason I'm having trouble with this function.

I read a # of articles in help from first 6 pages which didn't offer me any insight on my problem which goes like this:

TXT file in csv can be opened as Open Office w/o problem. The 8 table is well formed all the data is displayed which to me means the data export was properly formatted for CSV

In IQ when I File > import > select same file (as above), everything seems to be set correctly, i.e. comma delimited, " for text qualifier, etc

In step 2 only 1 row of data are displayed

I understand mapping function

import to current grid

import preview only show 1 data row which is incomplete

I must be doing something wrong but I can't figure out what unless import function has gone south.

I can't attach the exported file here because it doesn't conform to permissible file type for upload but if anyone wants it, I'm happy to send via email

Thanlks.

Comments

Sure, you can send it to me. No problem.

>I can't attach the exported file here because it doesn't conform to permissible file type for upload but if anyone wants it, I'm happy to send via email

email is fine, but you can also zip the file and add it here.

Hi Jan, @Pierre : Jan sent me his file last night. @Jan : I had a look at your file. There are two problems : 1- there's an extra delimited field in your data. The empty ",," should be just one ",". 2- Each new line is determined by a LF (line feed) and not a CR-LF as it should normally be on DOS/Windows. Did you produce that file on a Linux/OS X system ? LF (line feed) is Unix typical. I'll send you back your file with the proper adjustments. If all your files have the same problem, you'll have to do a search and replace for these ",," (replace by a single ",") and you'll have to replace are LF special characters by the CRLF special char -- this can be done with a text editor, probably with regular expression. If you tell me what text editor you use, I might be able to tell you how to do it. EDIT1 : if you use NotePad++ : - ctrl+F - Replace - Find what: \n ; Replace with: \r\n EDIT2 : note that some editor will offer to do the LF->CRLF conversion automatically when you load the file.]

Thanks Armando for looking into this.

If you send me the original file, I'll do the changes so IQ imports it correctly.

Thanks Armando..... and Pierre.

The file is the output of an Android Journal program.

Is it fair to say that the program developer needs to alter his export template vs this being an IQ problem. Is this something I should discuss with that person?

When traveling I'd like to be able to make journal notes on my phone, then eventually import them into IQ

Thanks.

Thanks for sending the file.

Version v0.9.25L now imports the file correctly (except for the missing comma in the header line)

Thanks for the fix, Pierre.

Did you mean "extra" comma instead of "missing" comma?

Hi Jan, You can either add an "extra" comma in the header or remove the double ones in the data. I chose the latest way to not have a blank field, but Pierre's way is definitely simpler... I guess I was tired. :)

Sorry, Armando. I'm being really stupid here. Where would the "extra" comma go? Thanks for your help on this issue.

No problem -- it does sound confusing. Each coma serves to separate a field. But if you count the comas in the header and in the data, you'll see that there's an extra one in the data. So either have to remove the extra one in the data, or maybe add one in the header. E.g. : you'd have to add an extra coma right before "Entry" (to match the extra coma already there in the data). So the header would look like : Date,Time,Favorite,Private,Important,,Entry

Got it, thanks again.