Data Formats

For inbound data, the same formats are generally available using Import Manager or an IIEP.

For outbound data, the same formats are generally available using Export Manager or an OIEP.

Successfully importing 'less than' and 'greater than' tags requires special formatting based on the format. Refer to the Character Tags topic in the System Setup documentation for details.

Exceptions are noted by the asterisks (*) in the table below.

Format

Description

Inbound

Outbound

Advanced STEPXML

XML that uses a template based on the STEPXML XSD. Refer to the Advanced STEPXML Format topic.

*Although Advanced STEPXML is not available for selection in inbound tools, Advanced STEPXML files can be imported successfully using the STEPXML Format option.

Yes*

Yes

Alphabetical Index - XML

XML that used with the InDesign solution to create indexes. Refer to the Alphabetical Index - XML Format topic.

No

Yes

Ariba CIF

CIF is a simple, comma-delimited list of catalog items and their attributes. Refer to the Ariba CIF Format topic.

No

Yes

Ariba CIF 3.0

CIF is a simple, comma-delimited list of catalog items and their attributes. Refer to the Ariba CIF 3.0 Format topic.

No

Yes

BMEcat

XML-based standard for electronic data transfer by electronic catalogs. Refer to the BMEcat Format topic.

Yes

Yes

BMEcat 2005

XML-based standard for electronic data transfer by electronic catalogs. Refer to the BMEcat 2005 Format topic.

Yes

Yes

BMEcat 2005.1

XML-based standard for ECLASS Advanced data. Refer to the BMEcat 2005.1 Format topic.

No

Yes

CSV

Comma-separated values (CSV) file. Refer to the CSV Format topic.

Yes

Yes

cXML

XML 'commerce eXtensible Markup Language' (cXML). Refer to the cXML Format topic.

No

Yes

ECLASS

ECLASS (formerly eCl@ss) is a hierarchical classification and product description system for grouping materials, products, and services. Refer to the ECLASS Format topic.

*This import is only available via the eCl@ss Classification Import wizard.

Yes*

No

ETIM

CSV Electro-Technical Information Model (ETIM) classification structure where each file contains a single language. Refer to the ETIM and ETIM v2 Format topic.

Yes

No

ETIM IXF

XML Electro-Technical Information Model (ETIM) classification structure that includes multiple languages. Refer to the ETIM IXF Format topic.

Yes

No

ETIM v2

CSV Electro-Technical Information Model (ETIM) classification structure where each file contains a single language. Refer to the ETIM and ETIM v2 Format topic.

Yes

No

Excel List of Values

Microsoft Excel spreadsheet file used to exchange LOV value data. Refer to the Excel List of Values topic.

*This export is only available via Export Manager.

Yes

Yes*

Excel

Microsoft Excel spreadsheet file. Refer to the Excel Format topic.

Yes

Yes

Excel Custom Template

Microsoft Excel spreadsheet file. Refer to the Excel Custom Template topic.

No

Yes

Excel Smartsheet

Smartsheet spreadsheet file. Refer to the Excel Smartsheet Format topic.

Yes

Yes

FAB-DIS Format

Excel file used as an exchange format, primarily by companies doing business in France, to share quality product information between manufacturers and distributors. Refer to the FAB-DIS Format topic.

Yes

Yes

FixedWidth

Text file with rows and columns of data, where each column has a fixed width. Refer to the FixedWidth Format topic.

Yes

No

Flatplan Excel

Excel file for publications. Refer to the Flatplan Excel Format topic.

*This export is only available via Export Manager.

Yes

Yes*

Generic JSON

JavaScript Object Notation (JSON) structure of attribute / value pairs that can be adjusted by changing the template. Refer to the Generic JSON Format topic.

Yes

Yes

Generic XML

XML with a variety of accessible formats. Refer to the Generic XML Format topic.

Yes

Yes

IDoc MATMAS 05

XML format used when exchanging information with SAP. Refer to the IDoc MATMAS 05 Format topic.

Yes

Yes

Publication Excel

Excel file for publications. Refer to the Publication Excel Format topic.

*This export is only available via Export Manager.

Yes

Yes*

SmartLabel

Generic XML-based including a pre-defined template for integrators to provide a head start in configuring a SmartLabel™ export solution for both food and non-food product data. Refer to the SmartLabel Format topic.

No

Yes

STEPXML

XML generated based on parameters displayed in a dialog. Unlike Advanced STEPXML format, no template is required. Refer to the STEPXML Format topic.

Yes

Yes

STEPXML Configuration Export

Cross-context XML file that contains the full STEP configuration (minus user objects) and the data nodes that are required for being able to import the configuration on to an empty STEP system; template required. Refer to the STEPXML Configuration Export Format topic.

No

Yes

UNSPSC

United Nations Standard Products and Services Code® (UNSPSC) multi-level classification folders. Refer to the UNSPSC Format topic.

Yes

No

xCBL

XML Common Business Library (xCBL) for business-to-business e-commerce. Refer to the xCBL Format topic.

No

Yes