Тема: 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?
1
30/04/2024 08:16:14Importing Drivers from Excel File
2
30/04/2024 17:03:37Importing Drivers from Excel File
- pach
- Gurtam
- Неактивен
Re: Importing Drivers from Excel File
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.
3
08/08/2024 05:24:01Importing Drivers from Excel File
Re: Importing Drivers from Excel File
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.
4
05/09/2024 09:57:23Importing Drivers from Excel File
Re: Importing Drivers from Excel File
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.