First step create shema file: schema.ini [DBM_adatok.csv] ColNameHeader=True Format=Delimited( DateTimeFormat=yyyy.mm.dd. hh:nn Col1=NameSpaceName Char Width 400 Col2=TimeStamp Date Col3=DeviceName Char Width 250 Col4=QunatityName Char Width 200 Col5=Unit Char Width 200 Col6=Value Float Copy to CSV file
Define importing process position (last record): More details from AVReporter knowledgebase: "Use feature Remember processed records to avoid the need to loop through rows of the source table that have already been processed at every execution. This can save much time when dealing with large amounts of data. You need to specify a column holding incremental (but not necessarily unique) values so if another record is added to the table it will have a value in this field that is greater than those of older records. Automatically incrementing IDs (AUTO_INCREMENT, IDENTITY) or columns containing the timestamps when rows have been added usually qualify as incremental. This setting causes the plugin to record the value from the selected column of the last processed source row and will only load rows having a value equal to or greater than this in their corresponding column the next time it executes. This also means that adding new rows to the source table with a less value in this field (denoting the column isn't actually incremental) leads to the plugin never processing it as it believes it already has. The software suspends remembering records if it encounters an error during an insert operation so that on next execution it can continue working with the row that could not have been processed because of the error. This may make it reasonable to use a Retry count greater than zero or turn Stop data transfer on error on so the plugin won't spend time processing further rows as they will have to be iterated through on next run anyway beacuse they wouldn't be remembered. Clicking Reset feature clears information on the last remembered row so next time the entire source table will be loaded again. Selecting another incremental column leads to the same thing since the remembered value cannot be compared to those of another column."
AVReporter uses datatimeoffset. That's why first step it is necessary to convert local timestamp to type of datatimeoffset timesstamp.