Data Imports: Event File Uploads

CSV formatting

This step details the formatting of the CSV files which should be written to your cloud storage destination.

The following CSV formatting is assumed:

CSV formatting property	Description
Delimiter	The character delimiting individual cells in the CSV data. This may only be a 1-character string. For tab-delimited data enter `\\t`. By default we assume this to be `,`.
Double Quote	The character delimiting individual cells in the CSV data. This may only be a 1-character string. For tab-delimited data enter '\t'.
Encoding	The character encoding of the CSV data. By default we assume this to be `utf8`.
Escape Character	The character used for escaping special characters. By default we disallow escaping.
False Values	A set of case-sensitive strings that should be interpreted as false values. By default this is set to the following set: `n`, `no`, `f`, `false`, `off`, `0`.
True Values	A set of case-sensitive strings that should be interpreted as true values. BY default this is set to the following set: `y`, `yes`, `t`, `true`, `on`, `1`.
Null Values	A set of case-sensitive strings that should be interpreted as null values. By default we interpret `NA` as a null value.
Quote Character	The character used for quoting CSV values. By default we assume this to be using double quoting `"`.

If your CSV file is formatted differently than the above, please inform us. If your CSV formatting is in line with the above, you will need to make sure your data is written into CSV files in your particular cloud storage location.

Field mapping

Overview

In Solvimon, the ingestion of events is directly associated with meters. Each event that you wish to ingest must be linked to a specific meter, and all fields associated with that meter must be accurately populated to ensure successful event ingestion.

Preparing Your CSV File

To facilitate the correct preparation of your CSV files for event ingestion, ensure that all necessary fields associated with the meter in question are included. We provide a convenient API endpoint to assist you in generating a template CSV file with the required headers, or you can download the template from our desk environment.

API Endpoint

GET https://live.api.solvimon.com/v1/meters/{meter_id}/meter-data-file

Please find the api reference of this endpoint here. This endpoint retrieves a CSV file containing all the necessary headers required for the event ingestion associated with a specific meter. The CSV file generated by this endpoint serves as a template to guide the formatting of your data for successful upload.

Desk Environment

Another option is to retrieve the template from desk. Navigate to the file tab in solvimon desk and select upload (or you can find it directly by going to https://desk.solvimon.com/files/upload. When selecting a meter a card will pop up which will allow you to download a template to ingest events for that meter.

Instructions for CSV Upload

Use the Provided CSV Template: Download the CSV template via the aforementioned API endpoint. Fill in the event data in the fields as specified in the template to ensure compatibility with our system.
Uploading Your CSV File: If you follow the template format exactly, you can upload your CSV file directly to our system without the need for additional mapping.
Custom Column Names and Ordering: If you prefer to maintain your own column names and ordering, contact us to set up a custom mapping. This will allow us to accurately process your CSV files according to your specific format.