I have a customer who has a few years’ worth of historical metering data in an SQL database. They would like to remove all of the data from the SQL database in csv format and store everything in tridium. The Kodaro driver looks like the best option to be doing this with. I have downloaded and played around with the demo station but cannot get an example file of the data to be read successfully as described in the online video.
I have a few questions about the driver before purchasing:
Is the demo station a full working demo without restrictions for 2 hours or are there restrictions that are preventing me from running my sample file? (I’ve tried running it from the station file system and my local C: drive without success).
Are there any limits on the file size/amount of data that can be run in one instance (some of my client’s files are between 30-90mb which is massive for a basic csv file)?
Can the histories that the driver creates be added to from a numeric point after creation? – Basically, if I create a history from a csv file, I would then like to assign more data from a numeric point going forward to that history using the same history identifier.
Can the driver be moved from one supervisor to another as once this job is complete the driver will no longer be needed by the client so we would like to reclaim it and use it elsewhere if possible?
Can the history name be formatted from the unique identifier within a column or row of the csv file?