My CSV file does not work with the Import function

My CSV file does not work with the Import function

If you are attempting to import a CSV file with That's Rights! or EasyRoyalties and you find that the import function is not interpreting your source file correctly, the problem may be due to the format of your CSV file.

Background

To import a CSV file into That's Rights! or EasyRoyalties, the CSV file must use the comma as a delimiter (","), the period as a decimal separator (".") and other CSV-specific characteristics that may vary depending on circumstances.

CSV files may be generated with delimiters and/or decimal separators other than the comma and period, depending on the program that created the CSV file or the regional settings in effect when the CSV file was generated.

For example, if an Excel spreadsheet is saved as CSV on a Mac or PC set to any one of a number of non-English regional settings (including French, Italian, German, etc.), the CSV will be created with semicolon delimiters, comma decimal separators, and so on. Such CSV files cannot be imported into That's Rights! or EasyRoyalties.

Checking your CSV file

To determine the characteristics of your CSV file, open the file using any text editor, and note what character is used as the delimiter.

Example of CSV content with semicolon-separated data (not importable):



Example of CSV content with comma-separated data (importable):


Generating CSV files with the correct characteristics

Check the program you are using to generate your CSV file. If there are CSV-related options for specifying delimiters, decimal separators, etc., you can use these to generate your CSV file in the correct format.

If no options are available for specifying the delimiter, then from your computer's Control Panel you can change the regional settings of your PC to, say, English (e.g. English/United Kingdom or English/United States), and then generate the CSV file.


    • Related Articles

    • Information exchange with other applications

      To exchange information with other applications, use the Import and Export capabilities of That's Rights! / EasyRoyalties, and transfer data via Excel spreadsheets or CSV files. Common scenarios where information exchange might be useful include: ...

    • How do I import ONIX data?

      You can easily import title and product information into That's Rights! or EasyRoyalties from ONIX-formatted XML files. Compatible with ONIX 2.0 and 3.0. 1. From the main menu, go to Importing, then click "Browse..." to select the ONIX data file that ...

    • Importing licence notes

      Importing licence notes Licence notes provide a flexible way to store any kind of information on your licences. License notes can be useful for recording discussions with licensees, renewals, addenda, performance appraisals, or anything else you may ...

    • How to set up a new database

      Applies to: That's Rights!, That's Rights Agents and EasyRoyalties When using these applications, your data is stored in a database file, which can be managed independently of the application installed on each user’s PC. When first installing the ...

    • How do I send my database to Support?

      To send your database (along with supporting files such as error logs and settings files): 1. Go to Options & settings > Database management and click "Package files for support" 2. Select the items to include (database, error log, settings file, ...