Catalog Export
A vendor’s catalog (product list) can be exported from the EDI form to an ASCII text flat file using the 'OrdersASCIIDelimited' or 'CatalogTabDelimited' export profiles. The resulting file can be saved to a removable disk or e-mailed.
To export and e-mail a catalog
1) From the <To Export> drop list, select the 'CatalogTabDelimited'
export profile.
2) Select a vendor and a price list from the respective drop lists. The path and file name for the
export file will default to the last name entered. If you want to save the file to a floppy disk, the path should begin with drive letter of your floppy drive (typically ‘A:\”.)
If you’re going to e-mail the file, save it to your local hard drive e.g. ‘C:\My Documents\Vendor Price
List.txt’
3) After selecting both a vendor and price list, click the <Export File> button. When the products have been sent to the path and file name selected, you will be notified that the export was successful and click <Ok> if you want a hyperlink created on the vendor form for the resulting file. The next dialog box will inquire whether or not a copy of the file is to be e-mailed. If you have a copy of Microsoft Outlook™ and it has been previously configured to send e-mail, click <Ok>.
A new e-mail will be created and the subject will be auto-filled as 'My Company Name, price list description, Catalog, Vendors Name.’ The email message will open with the file attached awaiting your addition to the body of the message. The e-mail is ready to send.
The original copy of the file will be retained at the path specified and can be re-sent as an attachment or otherwise referenced at a later time whether or not the e-mail option is chosen. If you do not have Microsoft Outlook™, you can use your e-mail client and attach the resulting file that was created.
To Import a Catalog with the Catalog_Excel Import Profile:
1) Select the 'Catalog_Excel' entry from the Import drop list on the EDI form
2) Select the vendor that the catalog will be imported for
3) Enter the path and file name to the file to be imported or use the <Open Folders> button to locate the file. This method will import ASCII comma delimited *.csv, *.prn,
*.txt, or Excel *.xls files.
4) Click the <Import File> button. After the file has been imported, the Catalog Field Map dialog will open.
5) Follow the directions on this form for assigning vendor catalog columns (fields) to corresponding fields names in BrokerForce™. Up to 15 columns of available data can be mapped. Note that you can add or edit BrokerForce™ price lists on this form. Check the data to import for proper formatting.
For this mapping: The drop lists for columns F1-F14 are fairly self-explanatory since the column headers will have been included with the export. However, you should select the appropriate price list column mapping e.g. 1-6 for column F8. Skip column F9 (individual cost), and select "SRP" for column F10, Select "MinQty" for column F11. Column F14 can be skipped as it is the VendorID assigned by the exporting database is will probably be irrelevant to your data.
6) Edit or delete vendor catalog records on the subform before they are imported. Use the record navigation buttons or scroll bars to review and proof the data before importing.
7) After BrokerForce™ field names have been assigned to columns, click the <Close> button on the toolbar. These assignments will be saved for future data imports.
8) Follow the remaining directions and prompts on the EDI form for removing discontinued items, adding new items, and posting other catalog changes.
Return to FAQs
Home Order BrokerForce™ FAQs Data Request Download Demos Support Contact
Copyright©1995 - 2008 DataForce, Inc. Patent 6,901,380 and Patents Pending
Windows is a registered trademark of Microsoft Corporation, BrokerForce™ is a trademark of DataForce, Inc.