CSV files are extensively used by electronic products and software applications to store data.
Although most data loggers export data to a CSV Format, this format has no rigid structure which means that a CSV file exported from one application is unlikely to be able to be imported in another, usually causing a lengthy manual conversion process.
DATRAN Database Import is the perfect solution to this time consuming and labour intensive problem.
An innovative user interface provides the mappings between the various columns within the CSV file and the required fields in the DATRAN database.
Importing data from third party products is now as simple as:
Create a graphical mapping file to define the relationship between the data, Click the import button, Check the result
The procedure for importing logged data from an XL4 Plus RTU is:
1. Collect the data from the RTU using Workbench (see Workbench user guide)
2. Export the node names for the RTUs associated site to a txt file
3. Run the Database Import Utility
4. Configure the tool to connect to your SQL DATRAN database
5. Create a “map file” this provides a relationship between the log file and the actual node names that you see in DATRAN browser for the Site (RTU)
6. Import the log file
7. Validate the import by looking at the data in trending
- Intuitive and easy to use user interface
- Flexible CSV column configuration for compatibility with most CSV formats, not just the ones listed above
- Support for the Data Logger’s site name embedded in the CSV file
- Support for column headings being embedded in the CSV file
- Support for records starting on a user specified row
- Support for user specified column delimiter, e.g. tab separated files
- Support for both digital and analogue points
- Analogue points can have the units and range specified to enhance the information shown by Historical Trending
- Support for multiple data columns in a single import
- Ability to combine CSV columns
- Ability to use arbitrary text as fields in the DATRAN database
- Single file import or an entire folder by a single mouse click
- A status report is generated for each CSV file that has been imported
- In the event of CSV import failure the problem is reported in the status report and all records imported from that CSV file are removed from the database leaving it in a known state