Importing external data

Model requirements

There are three columns that are required for zajModel database rows:

• id – a 13-character unique id
• time_create – a creation timestamp
• ordernum – an incremental order number used for ordering

Importing external data

When importing external data, you may not have these required fields available in your data source. However, you can easily generate these values via simple MySQL.

First import your data into a MySQL table that you create temporarily.

Next, select all necessary data from that table, and create the required columns programatically via SQL:

We recommend creating an externalid field for all external data sources so you can always connect the data with its source row if needed.