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