Go to the Data Upload Button

Navigate to the Mart.

Select Data to see a list of tables.

!Image showing how to Navigate to the Data Page

Go to the Data Action Panel in the top right

Image showing the data view page for REF_COUNTRY and the location of the Edit Data Action Panel in the top right

Click on the up arrow to upload from or CSV.

Image showing the location of the Upload button

Specify the File

Image showing the Upload pop-up and the location of the box to specify the File

Image showing Upload pop-up with the file name chosen displayed and the Preview and Commit buttons in the bottom right of the pop-up. We recommend using Preview

The file that you pick must fulfil some certain criteria to ensure that the load is successful.

File format

The file must be in Excel or CSV format. The column titles should be on either the first or second row. An example of this can be found in the files which are downloaded by using the Download Process.

Image showing a typical example of the data file downloaded from xMart. The first row contains Titles and the second row contains Codes

Column Names

The column names in the file must match the column names in the table to make the link between the columns in the file and the columns in the table.

Include any Business Primary Key fields

Not all columns have to be included but you must include the ones used in the Business Primary Key so that the load process can identify whether the record is an update or a new record

Batch Preview Page

Pressing Preview will bring you to the Batch Preview page. It contains the name of the file specified, an arrow to download it

Image showing the Batch Preview page indicating the location of the file name and the down arrow to download it

From here, you can see the changes and statistics

Image showing the Batch Preview page indicating the location of the batch statistics

If you are happy with the data then press Commit otherwise you can Cancel.