I have an Ignition system up and running and storing historical data to the database.
I have a number of offline systems which generate data in CSV format and I want to import this data into the Ignition Historical data tables in the database.
This can be achieved using the SQL BULK INSERT command, so no problems there.
However, the problem is that a lot of the data pre-dates the Ignition system, so there are no entries in the sqlth_partitions table that correspond to where this data should be stored.
The entries are as follows:
sqlt_data_1_2010_09,1,1283939117220,1285926318947 sqlt_data_1_2010_10,1,1285926323155,1288608324436 sqlt_data_1_2010_11,1,1288608334240,1291200334829 sqlt_data_1_2010_12,1,1291200335771,1293878736469 sqlt_data_1_2011_01,1,1293878744155,1296557145355
Can I create entries in this table corresponding to each historical month and then store the data in the appropriate tables, or is there more to it than that? such as the sqlth_sce or sqlth_te tables?