Upload or Synchronise files from a CSV

KBP010 - Upload files from a CSV

You can bulk upload files or synchronise file changes in to Papercloud Elite by using a CSV file.  (A sample CSV can be found here watermark.csv)


1. Navigate to File Manager

Go to File Manager, then select Import Clients from CSV.

Upload or Synchronise files from a CSV 1

2. Populating the CSV

Using the sample CSV file provided, ensure the ClientRef, first name and surname fields are populated as a minimum. The import will fail if these fields are empty.

NOTE: If you do not include the 'ClientRef' for existing files you risk duplicating the file.

Upload or Synchronise files from a CSV 2

3. Upload the CSV

Upload the CSV.

Upload or Synchronise files from a CSV 3

After doing this, you will see several options.

Firstly, you can place the file in a specific cabinet if preferred. You can also bulk apply a template to all of the client files added from the CSV. Simply click the dropdown and select the option you want.

Upload or Synchronise files from a CSV 4

You can map the details from the CSV into Papercloud by matching the headers of the CSV to the details in Papercloud. For example, if your CSV uses 'Forename' instead of Papercloud's term 'First name' you can map these here.

Upload or Synchronise files from a CSV 5

5. The Results

You will now see a new file in Papercloud populated with the details from your CSV.

Upload or Synchronise files from a CSV 6

6. Synchronisation

If you have a row of data in the watermark.csv that has a 'ClientRef' that matches an 'External Reference' in an already existing file in Papercloud Elite, then the details in Papercloud Elite will be overwritten by those in the CSV.


hello world!

Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Accreditations

ISO 27001 certification highlighting information security management complianceISO 9001 certification document for quality management systems
hello world!
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram