Topic: Importing Drivers from Excel File
Hello!
How can I import a list of drivers from excel sheet to wialon local?
Excel sheet is convertable to CSV format.
But, I've only seen export to CSV. How to import CSV file to wialon local?
Hello!
How can I import a list of drivers from excel sheet to wialon local?
Excel sheet is convertable to CSV format.
But, I've only seen export to CSV. How to import CSV file to wialon local?
You may use a core/create_unit API request to create units:
https://sdk.wialon.com/wiki/en/local/re … reate_unit
For example, make a script that reads your CSV and uses the core/create_unit request to create units automatically.
There are a few processes involved in importing a list of drivers from an Excel sheet into Wialon Local: data preparation, format conversion, and using Wialon's import capabilities.
First step: Get your Excel sheet ready.
Make sure your Excel sheet has all the information on the driver that is required, including name, ID, phone number, license number, and any other fields that are needed. Each column needs to have the proper headers and a legible label.
Convert Excel Sheet to CSV Format in Step Two
For import, Wialon Local normally needs data in CSV format. To change an Excel sheet to a CSV file:
Get your Excel file open.
On File > Save As, click.
Select CSV (Comma separated) (*.csv) from the drop-down menu for file format.
Conserve the file.
Step Three: Prepare the CSV file.
Make sure the format of your CSV file complies with Wialon Local's specifications.
To import a list of drivers from an Excel sheet (converted to CSV format) into Wialon Local, you need to follow a few steps, as Wialon Local doesn't have a direct "import CSV" feature for drivers in the user interface. However, you can use the Import tool under the drivers section to achieve this.