CXP Output Files

The Generic data loaders perform specific tasks to place data into CXPClosed Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions..

For each data loader, there is a Data Load Interface that includes the following information:

  • A set of extract files and their purpose.

  • Naming conventions for the extract files, with example file formats.

  • Definitions of external tables, including columns names and types, and so on.

Format

Files are comma delimited csv files with TAB delimitation between record fields. Data is in a plain text format using a single encoding scheme as agreed with CXP prior to an environment deployment. For example, Unicode or ASCII.

External tables are used as follows:

  • Missing field values are set to null.

  • Fields are trimmed of leading and trailing blanks.

  • String field sizes are measured as a number of characters (not bytes).