importing csv

Peter Alcibiades palcibiades-first at yahoo.co.uk
Thu Aug 28 01:07:59 MDT 2008


Robbie, yes, it was definitely the open file dialogue.  I will do a distro 
update and see if it persists.  It is only on one machine.

Another strange thing about csv imports.  I noticed that if you have a blank 
field, this version unlike earlier ones shifts all the fields over.

That is, you are importing a file which goes

a  TAB b TAB c TAB d
1 TAB 2 TAB 3 TAB 4
1 TAB 2 TAB  TAB 4

You have the field labels set up as a b c.  So you assign the fields to the 
labels and do import, and all is well.  

Suppose however that the last line reads

1 TAB 2 TAB  TAB 4

It then, in the field definition dialogue, moves all the fields over one, so 
the contents are no longer in the same columns, and this obviously screws 
everything up.

The way I had to overcome this was to replace TAB TAB in the csv file with 
TAB*TAB.  Then the import worked ok, and then I opened the xml file in a text 
editor and did search and replace, and deleted the *.  This did not happen 
with earlier versions.

Also, if you have a : in the field label, it seems not to show up on the 
detail display.  I fixed this by putting a different punctuation - spelling 
it.  I had A:B, but replaced it with A&B which works fine.

Another curious discovery.  When you have first done an import, even on the 
default template, entries will not display.  However, restart and they do....  
I do not think this used to happen either.  No big deal once you know about 
it, but it had me worried for a moment!

Al


More information about the tellico-users mailing list