This article is for Requesters and offers guidance on how to resolve errors encountered when uploading your list as a CSV file in the Portal. Please refer to our article on how to use and upload your CSV file for guidance on the process and further information on the CSV template.
Contents
- About the CSV file upload log
- How DUNS numbers are added
- Common CSV file upload errors and their resolutions
- Organization already exists on CDP database
- Organization already exists on CDP database with a DUNS number
- DUNS number should not be null
- DUNS value is not valid
- Incorrect DUNS format
- Account already exists but no data found
- Requested organization should not be null
- Wrong columns mapping
Once you have filled out the CSV file template and attempted to upload it following the instructions in the article upload your Request list using a CSV file, you may have encountered an error message stating that ‘Your last file upload failed’, as shown below.
If this is the case, we recommend downloading the error log to identify and correct the errors, before you upload the file again. To view and download the upload logs:
- Click ‘Upload logs’,
- Click ‘Show log’ for more details,
- Download the error file/log to check for errors and warnings
Upload logs provide a history of organizations added to the Request list. The log contains the following details:
- Date: Date of upload.
- Organizations: Number of organizations uploaded. Please note that this will be 0 if the upload failed.
- Summary status: Successful, Failed, or Invalid file format.
When organizations are added using a CSV file, the DUNS numbers in the file are checked against the CDP database. If there is a match, the organization is successfully added to the Request list.
If there is no match, the system searches for the DUNS numbers in the Dun & Bradstreet (D&B) database. If D&B returns a match, a new organization is created in the CDP database using the D&B database details. Then the organization can be added to the Request list. If there is no match in the D&B database, you will see an error in the upload log.
Please visit our FAQs for further information on DUNS numbers and D&B database.
Common CSV file upload errors and resolutions
1. Organization already exists in the CDP database
Organization "XYZ" already exists in the CDP database. To prevent a duplicate record being created, remove this row from this CSV file and upload the file again. This organization must be added manually so that a DUNS number can be assigned to it. To do so, click ‘Add an organization’ to find and add it separately.
Reason: an organization with the exact name exists in the CDP database without a DUNS number.
Resolution: use the ‘Add an organization’ feature to find and add the organization in the CDP database. This will assign the DUNS number to the organization. Please see our article on adding organizations to your Request list for further information.
2. Organization already exists in the CDP database with a DUNS number
The DUNS number you entered for organization "XYZ" doesn't match the DUNS number we have associated to that organization in our database. To prevent a duplicate record being created, correct the DUNS number in this CSV file and upload the file again.
Tip: click ‘Add an organization’, search for the organization you’re trying to add, and check you've selected the correct organization.
Reason: an organization with the exact name exists in the CDP database with a different DUNS number.
Resolution: update the DUNS number for the organization in the CSV file. If you believe CDP’s records to be incorrect, raise a case via the Help Center for CDP to update the organization name or DUNS number.
3. DUNS number should not be null
Reason: You have provided a row in which the ‘DUNS’ column is blank. This is a mandatory field.
Resolution: Add the correct DUNS number that corresponds to the organization in the same row in the CSV file and upload the file again.
Reason: The DUNS number entered does not match any DUNS number in the D&B database.
Resolution: Review the DUNS number in the CSV file and ensure it is correct. If it is correct, raise a case via the Help Center.
Reason: DUNS numbers are unique nine-digit identifiers. The DUNS number in your CSV file does not match this format.
Resolution: Review the DUNS number supplied, ensure it is correct, and upload the file again.
6. Account already exists but no data found
Reason: This could indicate a possible synchronisation issue within CDP’s databases.
Resolution: Raise a case in the CDP Help Center asking for support. Please provide information of the organization you are trying to request and the error message received. The CDP team will investigate and attempt to resolve the issue. You can remove this organization and upload the remainder of the file; this organization will need adding to your list manually once the issue is resolved.
7. Requested organization name should not be null
Reason: You have provided a row in which the ‘RequestedOrganization’ column is blank. This is a mandatory field.
Resolution: Add the organization’s name in the ‘Requested Organization’ column or remove any rows with partial data and upload the file again.
Reason: The columns in your CSV file do not match the columns in the template provided exactly.
Resolution: Download the template again by navigating back to your Requester Portal. On the left bar of the navigation panel, click ‘Manage organizations’ and then click ‘Upload log’. In the pop up that appears you will find a link to download the template once more, from here paste the information into the correct columns. Ensure you do not add, remove, move, or edit any columns in the file.
If you are not able to resolve any errors or issues using the guidance in this or other articles, contact us via My Support in the Help Center.
When raising a case about a CSV file issue, choose the category ‘I am a requester and I have a query’ and the subcategory ‘I have an issue with my request list’ to ensure your case goes to the right team. Attach your CSV file and the error log in the case so the team can investigate the issue.
You must be signed in to raise a case. If you are a new user, you can register here. Once you are signed in, please return to the Help Center via the link at the top of the page.
You may also find the following articles helpful: