Trying to import from CSV

[Robby Stephenson]

Hi,

On Wednesday 28 February 2007, Henk van Velden wrote:
> I hope this is the right e-mail address to ask some questions. When not,
> please stop reading and mail me back telling me what to do to put this on
> the right place.

You're in the right place!

> I try to import data about a CD collection from an old application (on
> MS-DOS 6, I didn't found an application like this one until I found
> Tellico!!). I generated a CSV file and imported it into Tellico. In
> general it works, but I have some questions:
>
> What is the character encoding that Tellico thinks the imported file has,
> I am loosing characters like ë â etc.

Tellico uses the Qt classes for reading files, and I think they default to 
the system encoding. If that's not working, you could try using iconv to 
convert the file to a different encoding before importing it.

> The data about the different tracks on a CD should go into the table
> Tracks. How do I import fields from the CSV into the different rows and
> columns of that table. Until now I succeeded only in attaching one CSV
> column to the field Tracks and then the first column of the first row of
> Tracks is filled from that CSV column.

Tracks could be separated by a semicolon. Like
  album, artist, track1;track2;track3,year
for example. That's how it's carried internally as a string.

> About de menu where to choose among the different groups you have (left
> from the Filter) I am sometimes missing some of the items. I can not
> exactly reproduce this, but it seems to happen after I append the import
> onto an empty collection.

The only fields shown in the "group by" box are those that have "allow 
grouping" turned on in the fields editor. If some of them disappear after 
importing, yeah, that's a bug.

> Thanks in advance for your time taken and I also hope this will add to
> further perfection of this wonderful application.

Sure, thanks for the email.
Robby