Automatically Importing Sales Files via an FTP Integration ✪
When sales files are provided to you via FTP or SFTP, you can direct Curve to automatically retrieve these sales files and import them to your Curve client. On a daily basis, Curve will scan for new files in this FTP folder and import these via our Bulk Upload tool. Any newly imported sales files will appear on your Sales page and will be tagged as New.
To set up such an integration, please go to Settings > FTP Integration. The below fields will need to be completed.
Name - Here you can name the FTP integration for your own reference.
Type - Here you select the type of FTP. Select the type that matches the FTP provided.
Host - The FTP's URL where your sales files will be hosted. Typically this will begin with 'ftp.' and should not contain 'http://' or 'ftp://'.
Username - Your username with the FTP.
Password - Your password with the FTP.
DSP - Select the DSP you are connecting to. Not all files on an FTP necessarily contain royalty data and should be imported to Curve. Selecting the correct DSP directs Curve to only read those sales files that are relevant to import. If the specific DSP is not listed, then you should select "Other".
Root Directory - In which folder on the FTP should Curve look for sales files? Leave blank for server root.
Port - Leave blank if unsure.
Ingest From Subfolders - Should Curve only retrieve files in the Root Directory you have specified? Or also in any of the sub folders?
Once an integration is set up, Curve will scan the FTP for all existing files. Any new files that are added to the FTP from that point in time onwards will be imported to your Sales page.
Below we provide the default setups required for some of the most common FTP Integrations.
An FTP Integration With Merlin
Of course your Username and Password will be unique. But in general, an FTP integration with Merlin will be set up as per the below example.
An FTP Integration With Amazon
Of course your Username and Password will be unique. Also your REPORTCODE, in the root directory, is unique. Other than that, an FTP integration with Amazon will be set up as per the below example.
Your REPORTCODE is the 4 or 5 digit code found on all your reports. It always starts with "ZQ" (Ex...ZQXXX_Monthly_AMU_Summary_202107_US.txt). Please note that REPORTCODE is case sensitive. It should be all upper case. Also note that the directory name is case sensitive. If "cxpreporting" contains any upper case characters you may not be able to access your file directory.
An FTP Integration With Spotify
Of course your Username and Password will be unique. But in general, an FTP integration with Spotify will be set up as per the below example.