Export/Import Product/Class/Group URLs

Utilities Menu -> Data Export/Import Utilities -> Export/Import Product/Class/Group URLs

This rate utility can be used to generate a bulk export of existing URL link information stored in the File Attachment tables for selected Product Classes, Groups or Products, which can be modified and then re-imported to update or delete URLs associated with those same Product Classes, Groups or Products.

The process sequence is:

•Generate Spreadsheet with All Existing Rates:
 Click the EXPORT option to generate a spreadsheet for the selected Classes/Groups/Products that have existing URL records, listing the Class/Group/Product number, description, and URL.

•Update the URL Information in Preparation for Import:
 The spreadsheet can be modified to reflect the updated URL information.
 Additional records of the same 'type' (class, group or product) can be added.
 Flag any URL records that should be removed from that item's File Attachment with a Y, y, Yes, yes, or YES in the "Delete" column to cause the record to be deleted on import.

•Save the Data on the Client updating the Format:
 When the spreadsheet is complete, save the updated spreadsheet on the Client machine in a tab-delimited format to give it a .txt extension.

•Move the Txt file to the Server in Preparation for Import:
 Click the UPLOAD FILE option from the radio group to open the Select a File to Upload utility that can be used to transfer the import .txt file from the Client to the Server.

•Update URL Information:
 Click the IMPORT option from the radio group to update the File Attachment table with the new URLs.

•Exit sub-menu
 Click Cancel when no further action is required.

Finished?

Click OK to initiate the action selected in the radio group.

Reports:
 The Import action will generate an error spreadsheet if there are any records that cannot be updated.

Topic Keyword: ATTACH1 (6670)