Separate names with a comma.
Discussion in 'AVReporter Connection Center' started by Baracskai Attila, Feb 18, 2016.
Import CSV file: DBM_adatok.csv
First step create shema file: schema.ini
Col1=NameSpaceName Char Width 400
Col3=DeviceName Char Width 250
Col4=QunatityName Char Width 200
Col5=Unit Char Width 200
Copy to CSV file
Open AVReporter v4.0 with Administrator privilages:
Open AVR Connection Center:
Create new Job:
Shows Advanced settings:
- Set connection string
- Create new configuration
Select 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."
Define source and target data table fields:
Structure of AVReporter table:
AVReporter uses datatimeoffset. That's why first step it is necessary to convert local timestamp to type of datatimeoffset timesstamp.
Save job and after that try CSV import:
Check result in BasicReporter:
Download job example