Importing Data

Tellico offers three different actions when importing data. Replace current collection will close the current collection, and create a new one with the data from the imported file. Append to current collection tells Tellico to add all the entries in the imported collection to the current one, and to add any fields which don't currently exist. The Merge collection action is the same as appending, except that each imported entry is compared to the current ones, and any identical entries are skipped. Future plans include an improved heuristic for identifying matching entries, but currently, except for music collections, they must be identical for every field. Music collections compare the artist and album only, and the tracks are merged for matching entries. The audio file importer is able to correctly build track lists by merging entries.

Importing Tellico Data

Other Tellico data files may be imported. Replacing the current collection by importing a Tellico file is the same thing as just opening the file itself. The value of importing Tellico data is primarily for appending or merging two collections together.

Importing CSV Data

Comma-separated values (CSV) are a common way of importing and exporting tabular data. Each field value is separated by a comma, with one entry per line. The field titles may be included in the first line. The CSV importer is not limited to using a comma as the separator. Any character or string may be used.


The CSV Import Dialog

First, select the type of collection that you are importing. If you are appending or merging to your open collection, the type is limited to your current collection type. If the first line of the CSV file contains the field titles, click the check box and the importer will automatically compare the titles against the fields in the current collection. If a field title matches, the header for that column changes to show that the column has been assigned to that field. If the file uses a delimiter other than a comma, be sure to change that option accordingly.

In order for Tellico to properly import the file, it must know which field corresponds to each column. If the column only has a number in the header, the data in that column will not be imported. You should assign fields to each column by selecting a column, either by clicking in it or changing the column number itself, then selecting the field to assign from the drop down box and clicking the Assign Field button. If you need to add a new field to the collection, the last item in the drop down box opens the Collection Fields Dialog.

Only the first five lines of the imported CSV file are shown in the dialog.

Importing Audio CD Data

Tellico is able to use the freedb.org service to lookup information about a CD, including the track list. Depending on your distribution, settings for access to the service may be set in the KDE System Settings. The CD artist, title, genre, year, and track listing are all added.

In addition, if the disc contains CD-Text, that information is read and added to the imported entry.

Importing Audio File Metadata

Tellico is able to scan a folder and read the tags for common audio file formats, such as mp3 and ogg. The songs are entered in a music collection, where each entry is an album. If the song files contain the track number, the song name is inserted in the correct spot in the track list. The artist and genre information is also added to the entry. If the song tags contain comments, they are appended to the comments field in the entry, preceded by the file name.

In addition, if a folder contains a .directory file and the folder name matches an album title, the Icon entry in the desktop file is used as the cover image for the album.

The audio file metadata importer can recursively scan a folder to find all audio files in any subfolder, though symbolic links are not followed. Tellico uses the TagLib library for reading the audio file metadata, and so can import data from any file type that TagLib understands.

Importing Alexandria Libraries

Alexandria is an alternate book collection manager for the GNOME desktop environment. The importer offers a choice of importing any of the libraries found in $HOME/.alexandria/.

Importing Ant Movie Catalog Data

Ant Movie Catalog is an alternate movie collection manager.

Importing Bibtex Data

Bibtex is a bibliography format used with the LaTeX document preparation system. Various type of bibliographic references may be included in the file. Tellico imports bibtex files as a Bibliographic collection.

If the bibtex importer encounters fields in the file which are not in the default bibliography collection, they are added as Simple Text fields, with two exceptions. If the field value contains more than 100 characters, it becomes a Paragraph field. If the field value appears to contain a URL or a file reference, then a URL field is created. Tellico uses an internal copy of the btparse library for parsing the bibtex files.

Importing Bibtexml Data

Bibtexml is an XML representation of bibtex data, and the data from the imported bibtexml file is treated in the same way as bibtex data would be.

Importing Delicious Library Data

Delicious Library is an alternate collection manager for the Mac® OS X desktop. Tellico imports a subset of the data used by Delicious Library.

Importing GCstar Data

GCstar is an alternate collection manager. Importing books, movies, music, coins, games, board games and wine collections is currently supported.

Tellico can also import GCfilms data files. GCfilms is the predecessor of GCstar and was an alternate movie collection manager. Normally, GCfilms data files are found in $HOME/.local/share/gcfilms/.

Importing Griffith Data

Griffith is an alternate video collection manager. Tellico is able to import most data from a Griffith database.

Importing MODS Data

MODS is a format for representing various types of media collections. Currently, only books are imported by Tellico, as a Bibliographic collection.

Importing PDF Data

If Tellico was compiled with exempi or poppler support, metadata from PDF files can be imported. Metadata may include title, author, and date information, as well as bibliographic identifiers which are then used to update other information.

Importing Referencer Data

Referencer is a document organizer and bibliography manager for the GNOME desktop. Tellico will import most of the data found in a Referencer database.

Importing RIS Data

The RIS format is a bibliographic file format used by Reference Manager and others. Tellico imports RIS files as a Bibliographic collection.

Importing Goodreads Collection

Goodreads is an online social network for readers to track book collections. Tellico can import the list of books in a user's collection, given either the user name or user ID, as long as the collection is set to be publicly accessible.

Importing File Listings

The best way to create a File Catalog is to import the contents of a folder. The folder may be searched recursively, to add all files found within. This importer is most useful for backup listings and media cataloging, such as CD or DVD listings. In addition, image previews of the file contents may be generated, although it can take some time to read a large number of files. The file previews are same as those shown in the KDE file manager.

Importing XML Data via XSLT

Any XML file may be imported into Tellico provided an XSL stylesheet is available to convert the file to Tellico format. Tellico automatically loads the stylesheet and performs the XSLT processing needed to load the file.