1Topic by hasan.ahmed

Drivers From Excle

Topic: Drivers From Excle

Hello there,

i have like 1000 driver this i wish to add to the system.

i have the driver code,name and phone number in excle file, is there is a way that i can add them to the system at once?

Please Advise

Fernando Brochetto

+1
2Reply by rual

Drivers From Excle

  • rual
  • rual
  • Wialon fan club
  • Offline
  • From: Minsk
  • Registered: 14/12/2016
  • Posts: 274
  • User Karma: 162

Re: Drivers From Excle

Currently there is no such possibility to do it from the interface, but any developer can parse exported csv from Excel and execute batch of resource/update_driver requests via API.

Or export few drivers, inspect their format in resulting wlp files, then convert csv to wlp format, import them.

0
3Reply by tata

Drivers From Excle

  • tata
  • tata
  • Gurtam
  • Offline
  • From: Minsk
  • Registered: 12/03/2012
  • Posts: 1,680
  • Products: Wialon Hosting
  • User Karma: 507

Re: Drivers From Excle

Here is step-by-step instruction on how to convert drivers list from .wlp to .xlsx

Tatsiana Shmihelskaya
Business Analyst, Gurtam

0
4Reply by Fernando Brochetto

Drivers From Excle

(edited by Fernando Brochetto 18/11/2019 17:11:52)
  • From: Brasil - RS
  • Registered: 28/06/2019
  • Posts: 375
  • Products: Wialon Hosting
  • User Karma: 89

Re: Drivers From Excle

Hello tata,
Does this method works with passengers too?
I have a client with 600 passengers.

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br

Fernando Brochetto's Website

0
5Reply by tata

Drivers From Excle

  • tata
  • tata
  • Gurtam
  • Offline
  • From: Minsk
  • Registered: 12/03/2012
  • Posts: 1,680
  • Products: Wialon Hosting
  • User Karma: 507

Re: Drivers From Excle

Sorry, hasan.ahmed, I've linked the way of reverse action you need. rual gave better advice smile

Fernando Brochetto, if you want to convert .wlp to .xlsx, then the method will work with passengers and trailers also.

Tatsiana Shmihelskaya
Business Analyst, Gurtam

0
6Reply by Fernando Brochetto

Drivers From Excle

  • From: Brasil - RS
  • Registered: 28/06/2019
  • Posts: 375
  • Products: Wialon Hosting
  • User Karma: 89

Re: Drivers From Excle

tata wrote:

Sorry, hasan.ahmed, I've linked the way of reverse action you need. rual gave better advice smile

Fernando Brochetto, if you want to convert .wlp to .xlsx, then the method will work with passengers and trailers also.

Actually I have the needs of the partner: importing drivers and passengers with a xlsx file.
Thanks!

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br

Fernando Brochetto's Website

0