Search Help

FAQs / How do I import images and documents when importing from Excel?

You can create document linkages for items right as you update or upload them via an Excel sheet. You can attach up to 5 public URL documents upon item import  To do this, add the 5 document links – separated by commas – into a column in your excel sheet. Remember to assign them to the “Document attachments” mapping upon import.
e.g.https://upload.wikimedia.org/Item46.jpg, http://bizplus.net/TransferDoc.jpg”

Note: Dropbox links end with “dl=0” or “dl=1”. They need to be updated to “raw=1” for the Excel import to work. For example, the link  “https://www.dropbox.com/s/buz195ijl5ct6nv/1a.PNG?dl=0” needs to be “https://www.dropbox.com/s/buz195ijl5ct6nv/1a.PNG?raw=1”

You can also associate documents right from the EZRentOut account library during the import (Items –> Documents opens your account library). You would just have to replace one (or more) of the public URLs with the file-name of the document.
e.g. “Flowchart12.jpg, https://upload.wikimedia.org/Item46.jpg

Lastly, you can now export a list of all your documents from Documents –> Export Document Data. The export would include links to the URLs of each document.

linkages

Posted in: Dropbox, Importing Data

Share this:
Share