CRD Income Files

CRD is a standardised format in the publishing industry used to send revenue data. It’s functionality is similar to that of CWR files: a text-based file with different types of rows and different character width columns. The same royalty can be spread across multiple rows instead of singular rows as you'd see in a standard CSV style statement.

There are multiple versions. Curve currently covers version 2.00, 3.00, 4.00 and version 4.01.

CRD Visualiser Tool & Checking the Version

We have a free CRD Visualiser Tool which labels each different field within an uploaded file. This tool currently covers CRD versions 2 and 3. We can also use this to check what exact version the file is before you ingest it into your Income page:

You will see two different fields indicating the version of the file. The first field highlighted above in red is only the Standard Version Number and not the specific version. The Version Number found within the SDN line of the file is the specific version.

If you have any version 3 files, you will see that the Standard Version Number will still be 02.10 but the Version Number will be something along the lines of "00300", indicating that this is actually a version 3.00 CRD file.

If you have a version 4 file, the format is simpler and so you can open the file via a text reading software. The version will be specified towards the end of the first row:

CRD Template

The template is stored in our Library simply as CRD and can read all versions covered by Curve, by automatically selecting the correct algorithm based on the format specified within the file.

The algorithm works by reading the data from the files and then putting them into columns to mimic a regular CSV format.

For other income files, Curve would read the uploaded file's format and automatically apply a Template from our Template Library with a matching format, if available. This won't happen for any uploaded CRD files because of their more complex format.

Because of this, before you upload your CRD files to the Income page for the first time, we advise that you go to your Templates page > +Create > From Library and search for and select the "CRD" template from the dropdown, followed by saving the template.

When you do upload the CRD file to your Income page, Curve will let you know straight away that it could not apply a matching template. From there, you can open the file and select the CRD template saved on your Templates page.

These are the example lines you can see in the CRD template, which allow to still customise the Template and store certain types of data differently to the default we have set out. This can also be helpful when you want to adjust your Template for any society specific exceptions.

Because multiple Sources use CRD files, you could use a new Template for each Source to correctly store your mappings and any source-specific calculations or defaults you might want to set up. However, it is not a requirement to use a different CRD Template, only if you want to map values in a different way. You could also use the same one if you wish.

One particular thing to consider with this is the template's "Source" field at the top of its Overview page (not the other royalty-related Source field within the Defaults or Example Lines sections). When you map income to a Work using that template, Curve will take the value from that template's "Source" field and store that as the Society value, alongside your Society Identifier, within the mapped Work.

So if you receive multiple CRDs from multiple different societies, we suggest that you set up one CRD template for each different society and enter the society's name into the associated template's "Source" field at the top of the template's Overview page. Please see Adding Aliases & Society Identifiers for some extra details on how this works.