Uploading a Sales File

Uploading a Sales File

Now you have created your first Template, let’s use it to upload a Sales File to ingest sales data into the system. For Masters, navigate to Sales under the Sales sub-menu in the sidebar; Publishers navigate to Income in the Income sub-menu. Then hit the Create button in the top right of the page.

Uploading a Sales File


You will now be presented with a Sales File Setup page. Here you can name the file & enter any references you may need for later; stipulate the Source of the file. Then direct the system to which template to use, & lastly import a file.

Select the file, and hit Import. This will upload the file & present you with the Pre-Ingestion page. To follow our demo, upload the Curve Demo Sales file using the Template we just created.

Pre-Ingestion

The Pre-Ingestion page allows you to make any final changes before completing the ingestion. You will often use this page to set any particulars about the file, such as a specific Transaction Date or Exchange Rate. Curve also displays here a sample of the lines that you’re about to ingest, compared with your template. So you can confirm the sales file fits the template & will ingest as you expect.

For our demo, set the Exchange Rate at 0.86, then hit Ingest.  You will be taken back to the Sales page. Refresh the page to check if the import has completed, it should now be appearing at the foot of the list of ingested Sales files.

Sales Mapping

You’ll know once the ingestion is complete as the file will have a ‘thumbs up’ symbol towards the right of the row. Click on the sale file name & you’ll be taken into the page. You may then be met with the mapping pop up, like below.

This Mapping Manager asks you to complete any values unknown to Curve, and map them to the correct Territory/Channel/Configuration/Catalogue in your Curve client.

You are presented with the unique values for each of Distribution Channels, Configurations, Price Categories, Releases & Tracks. To map down, work through each row & connect the value taken from the file on the right to one of the values from your Curve database in the drop-down menus on the left. Work through each one, then hit next. Each of these values will be saved for all future uploads with this template.

When you map Releases, Tracks or Works, this is creating Aliases for those assets. You can review and manage Aliases in the catalogue area. It is much easier to create these Aliases when ingesting a sales file, rather than when creating the Release, Track or Work.

When everything is mapped, hit Revalidate & the file will remap the invalid sales lines, using all the new associations you have created.

Completed Sales File

Once you have completed mapping your Sales File, the Mapping Manager will no longer appear. At the top of the Sales File page, you have headline information to validate that your file has been imported properly.


Check the number of lines, revenue & number of units match to the file you uploaded. Invalid lines refer to ingested sales lines that, for one reason or another, have not matched down successfully to your catalogue. If everything looks correct and the system shows there are zero invalid lines, your job is done.

Below the headlines, you can also view & filter the imported sales lines. If there are any invalid lines left after using the mapping tool, you can edit any of the data across a number of lines or a single row of data here. Editing data in this field should only be used as a last resort, for sales data that could not be mapped in the previous sales mapping phase. IMPORTANT: After editing sales data like this, you need to click Revalidate for your changes to feed through. If you hit Reingest, the file would re-upload from scratch and make any manual changes you made to the statement undone.

Now you have sales ingested and mapped down, let’s add some costs in the next section.

←
→