At EZOfficeInventory, we are committed to providing an unmatched support experience. Here’s how to get in touch:
- Email – firstname.lastname@example.org
- Blog – https://blog.ezofficeinventory.com – great place to start off and read about our existing and upcoming features
- Feature Request – http://ezofficeinventory.uservoice.com – we want our community to be involved in helping us define the product roadmap. Placing feature requests here allow for others to view and vote on them
FAQs of EZOfficeInventory are listed below
How to troubleshoot this error “Attachment has an extension that does not match its contents” when mass importing your dropbox images via excel import in EZOfficeInventory?
To fix this error “Attachment has an extension that does not match its contents” when mass importing images via excel import functionality in EZOfficeInventory, do the following:
You need to make minor tweaks to the shared links (created via DropBox share option) for your display images. The image’s shared URL must end with ‘?raw=1’.
Note: The end must not be missing ‘raw=1’ OR contain ‘dl=0’
See the following example:
Change image’s shared URL from:
You can directly upload a maximum of 10 documents and images at a time from Items > Documents > Upload. You can also mass import documents and images and associate them to items through an Excel import. For this, you will need to first upload your documents to the cloud and then enter their hyperlinks into the excel file. One way of doing this is using Dropbox.
To learn more about how to import images and documents from Excel go here.
Step 1: Create a Free Dropbox account and upload all your documents and images to it. Make sure you create a public link for each of the documents uploaded (From Document Name > Share > Create a Link).
Step 2: Export an Excel file with a list of all your assets and their AINs. You can get this Excel file for assets from Reports > All Active Assets. Delete all the extra columns from your excel file but keep a column for asset number, name and documents.
Step 3: Populate this excel file with the Dropbox links of the documents against relevant assets. Note that Dropbox links end with “dl=0” and need to be updated to “raw=1”. 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”
Step 4: Upload your Excel file from Items > Assets > Import from Excel Sheet > Update Existing Assets. Make sure to map the column with your document URLs to ‘Document Attachments’ upon import.
To learn more about Excel imports, go here.
You can create document linkages for items right as you update or upload them via an Excel sheet. Furthermore, you can attach up to 5 public media file URLs upon item import.
But what are media file URLs? These are the web addresses that direct you to media files uploaded online. You can access these by right-clicking on an image, hitting ‘Inspect’, and viewing the source attribute (more on that below). However, it is important to note that these addresses appear differently depending on the domain. For this reason, you might have to edit your links before you can add them to your Excel file, prior to the import.
Editing Dropbox media file URLs
Dropbox links end in the code “dl=0” or “dl=1”. Update this to “raw=1” before adding them to the Excel sheet. For example, the link https://www.dropbox.com/s/buz195ijl5ct6nv/1a.PNG?dl=0 needs to be edited to https://www.dropbox.com/s/buz195ijl5ct6nv/1a.PNG?raw=1. Once you’ve edited it, it’s ready to be copied to your Excel.
Editing all other media file URLs
Web addresses for media files generally end in their extension i.e. .jpeg for JPEG image type, .png for PNG image type, .gif for GIF image type, and so on. As an example, here’s what the URL for an image on our blog looks like https://blog.ezofficeinventory.com/wp-content/uploads/2019/04/businessman-riding-rocket-launching-from-smart-phones_70921-315.jpg. Notice how the image extension is at the very end of the address. Here’s how to get this address for your image.
- Navigate to the website where the image exists.
- Once here, right-click on the media file and hit inspect to see the HTML code for this element.
- The field highlighted in yellow shows the public URL for this image. It appears as the ‘source’ attribute (src in HTML).
- Alternatively, you can right-click on the image, click on ‘Copy Image Address’, and paste this address to a text-box or text application to see what it looks like.
- If the media extension (.jpg, .png, etc) is at the very end of the address, it’s ready to be copied to your Excel. This is true for the image shown above where the URL is https://blog.ezofficeinventory.com/wp-content/uploads/2019/04/people-hold-mail_41910-353.jpg.
- If the extension comes somewhere in the middle of the address, like https://example.com/images/television.png/112/dImL/, edit it to https://example.com/images/television.png.
Once you’ve edited your public media file URLs, you can now copy them to your Excel. Add up to 5 document links – separated by commas – into a column in your excel sheet. Remember to assign them to the “Document attachments” mapping upon import. They should look something like this: https://upload.wikimedia.org/Item46.jpg, http://bizplus.net/TransferDoc.jpg
Associating documents from the Account library
You can also associate documents right from the EZOfficeInventory Document’s Library (Items –> Documents) during the import. Just 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“.
Exporting document list
Lastly, you can export a list of all your documents from Items –> Documents –> Export –> CSV. The export would include links to the URLs of each document.