Universal Exports can be used to download the catalog file and photos so they can be stored or manually uploaded to a service for which Wavebid does not provide API integration. This article describes the settings that must be in place to export in this manner, the resulting export file types, and common export issues. For information on monitoring large exports, see Export Monitor.
Auctions must be set to "Universal" prior to performing a universal export.
- Navigate to the appropriate auction from the Dashboard, then select Auction > Edit Settings.
- In the Auction Attributes tab, select Universal from the Auction Software drop-down menu.
- Click the Disk icon in the top right corner of the page to save.
Creating Export Files
- Navigate to the appropriate auction from the Dashboard, then select Auction > Export Auction.
- Set the Lot Options:
- All Lots: This will export all of the lots currently in the auction. (This is the default.)
- Categories: Only the selected categories will be exported. To select multiple categories, hold down the Control (Ctrl) key on the keyboard while clicking on the categories.
- Lot Ranks: Only the specified ranks will be exported. (To enable this function, navigate to the auction on the Dashboard and select Auction > Edit Settings. Click on the Adv. Attribute Settings and check the Show Lot Rank? box. Click the Disk icon in the top right corner to save.) To select multiple ranks, hold down the Control (Ctrl) key on the keyboard while clicking on the ranks.
- Lot Range: Specify which lots to export. For example:
1, 2, 3would export lots 1, 2, and 3.
1-10would export lots 1 through 10.
- Set the Catalog Options:
- Generate Catalog: Whether to create a comma-separated values (.CSV) file containing the lot attributes and descriptions. (This is the default.) If this option is disabled, Wavebid will save the file in text (.txt) file format.
- Data Mapping: Select what column order to use when exporting the CSV file. (Proxibid is the default.) This field is irrelevant when performing a Universal Export.
- Save as .CSV: Select which file extension to use. If this option is disabled, Wavebid will save the file in text (.txt) file format. If the option is enabled, Wavebid will save the file in a comma-separated values file format (this is the default).
- Remove HTML: Wavebid will always include any HTML code entered in the lot Description or Additional Description fields. Enabling this option will strip out all of that code, leaving only plain text with HTML entities being rendered as their characters. (The default is for this option to be disabled.)
- Set the Photo Options:
- Zip Photos: Will create a ZIP file containing all of the photos from the auction, except for photos labeled as barcodes. (This is the default.)
- Add Watermark: Will enable watermark text for the photos. (The default is for this option to be disabled.) For more information on watermarks, see Watermarking Photos.
- New Photos Only: Will only include photos that have been uploaded or manipulated since the last export. If no exports have been created for the auction, Wavebid will include all of the photos. (The default is for this option to be disabled.)
- Thumbnails: Will create thumbnail versions of the photos using the pixel dimensions selected in the drop-down menu. (The default is for this option is None.)
- Since a universal export will not be sent to marketing partners, the Marketing Options can be disregarded.
- Once configuration is complete, review the current summary and click the Export Auction button.
- A confirmation window will appear. Click the Ok button. Wavebid servers will begin the export process. Catalogs with a large number of photos may take up to an hour to export. The Export Monitor page will provide a status of the export and indicate whether or not it was successful. For more information, see Export Monitor.
When the export is complete, download the files.
Newly created files will appear on the right side of the Export Auction page:
- Previous Catalogs: Results in a CSV (comma-separated values) file in plain text that can opened with spreadsheet software. Download the file by clicking on the timestamp link.
- Previous Photos: Results in a ZIP file containing all of the photos for the auction's lots except for photos labeled as barcodes. Download the photo ZIP file by clicking on the timestamp link.
Files are named according to the date and time the export server was finished creating the file. There is no limit to the number of export files that can be created.
To delete an export, click the Trashcan icon to the right of the timestamp link.
Question: What are these strange symbols after exporting my catalog?
The Lot's commas, double quotation marks or other symbols have not been read correctly from one system to another and are now showing odd results.
The catalog process can introduce some interesting and unexpected results such as strange symbols showing up in the bidding platforms or other systems. This is caused by differences in the ways technology communicates regarding special characters. Special characters are not always written the same "behind the scenes" by technology providers. This will cause users to see odd symbols.
Special characters are any symbols that is not a number or letter. Common special characters that can cause users to see unexpected or strange symbols are the comma and double quotation marks.
Once the characters are in the catalog, there are two ways to fix them.
- Export the catalog into a csv file and then use the find and replace function in Excel to correct the characters.
- Using Lot Preview, delete the impacted area and re-type.
These errors can be avoided in the future by reviewing computer settings and devices and ensuring that they do not use Smart Punctuation functions. Please refer to device manuals to see if this function is enabled on a device.