Location of Templates

The import templates are defined on separate worksheets in a single Excel .xls/.xlsx file.

These files are available at the following location:

opt\emptoris\apps\{timestamp}\SRC_{version_build}\LIB\import-templates

Where,
  • {timestamp} is the time stamp, when build is deployed. It is a folder with a numeric name. For example, 121109_032608_343.
  • {version_build} is the version and build that is being deployed. For example, 10.0.0.1- 129.
The sample_import.xls/sample_import.xlsx file is read only. You must copy the template that you need from sample_import.xls/sample_import.xlsx to another file before you enter any data.
Preparing an Excel spreadsheet is a relatively straightforward task. Emptoris® Sourcing helps you to prepare a spreadsheet by providing several specialized Excel templates in the sample_import.xls/sample_import.xlsx file. Each of these templates is on a separate sheet within this file. There is a template for each one of the following entities:
  • Catalog
  • Currency
  • Profile (template for updating existing supplier organizations)
  • RFx
  • Line item

As you build your database, you can reuse the spreadsheets that you create by modifying the values where appropriate and then importing the data.

Parent topic: Introduction