1

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Тема: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello G-Team!

We need your help on creating the option to export list of:  Drivers, Passengers, Trailers and Geofences, to .xls  Actually the only way is trough SDK and not all of us have the knowledge and resources to do it that way, (we need the simplest way: click on a button = .xls report)

Hope other distributors are agree with me!

Best regards,

2

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

+1

Eflotta Vehicle Tracking Ltd, Hungary
www.eflotta.com
3

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Please, specify what information do you need in exported file (to make it easier, you can make the screenshot and mark required fields).
And what is the purpose of this exported information? How will you use it later?

Tatsiana Shmihelskaya
Business Analyst, Gurtam
4

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello Tata !

My customers need to get reports for any of them (drivers, trailers, geofences),to get control of all their resources.
We need to get this info:

Drivers:

Name
Code
Description
Phone number
Mobile key
Exclusive
Custom fields (ALL)


Trailers:

Name
Code
Desciption
Exclusive
Custom fields (ALL)


Geofences:

Name
Description
Type
Resource
Group



Hope you authorize this request.
Best regards,

5

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

As for  geofences, you can convert them to .xlsx right now. Export them to .kml and then use a converter, e.g., this one (you need to correct one tag in the exported file: <kml> to <kml xmlns="http://www.opengis.net/kml/2.2">).

The general idea is noted, and we will analyze it.

Tatsiana Shmihelskaya
Business Analyst, Gurtam
6

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Any news regarding this topic?
Right now we are facing to export 200+ trailers and 60+ drivers..

and the function described above would be a great solution. It's a big problem that we couldn't export them easily..

"Drivers:

Name
Code
Description
Phone number
Mobile key
Exclusive
Custom fields (ALL)

Trailers:

Name
Code
Desciption
Exclusive
Custom fields (ALL)"

Eflotta Vehicle Tracking Ltd, Hungary
www.eflotta.com
7

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Did you try to convert .csv into .xlsx as was described before? If export is not on regular base, it should be a rather appropriate solution.

Tatsiana Shmihelskaya
Business Analyst, Gurtam
8

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello tata!

Sure, we have managed to get these data.

On the other hand: for a simple enduser not the best way to get these data with some script converter. And endusers facing these kind of situations very commonly (or at least our partners).

V.

Eflotta Vehicle Tracking Ltd, Hungary
www.eflotta.com
9

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello tata...

We need to export all the information related to 120 drivers from one customer.  They need to get their information in an xls file.
Can you show me how do we do to give a solution to our customers?

Thanks for your promptly help!

10

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello, jhdeguate
I'm sorry for a rather complicated solution, but you'll get the result.
Follоw the steps:
1. Export drivers to .wlp
2. Copy the content of the file
3. Insert it to the converter from .json to .xlsx.
4. Choose the destination (.xlsx), captcha and select rendering "Hierarchy"
5. You'll get some extra rows (e.g. resource ID, position and bound unit ID). Delete them and rename the columns. There is a hint in SDK documentation what parameter corresponds the field.

I've attached an example: driver in the interface, converted table, and final table.

  • Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls
  • Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls
  • Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls
Tatsiana Shmihelskaya
Business Analyst, Gurtam
11

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

(21/04/2018 18:06:37 отредактировано jhdeguate)

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Thanks tata for your help...

This "complicated solution" is A LOT of manual work and as you correctly named: COMPLICATED, and the solution shouldn´t be to hard to do for a "normal/simple human" as ME, please consider to develop the option to get a report with a "click of a button", (remember not all of Wialon´s users are computer´s genius as the G-Team).

Cheers...

12

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

We would also be interested in a simple export feature for Drivers especially, that exports all fields including custom fields.

13

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

+1

We have already received queries from client to export their driver list (including all the fields mentioned above)

This would aid them in accounting for their drivers as well as facilitating communications with our clients when they want to add / remove drivers. Right now we do this via screenshot (which would not be practical if you have drivers more than 50 to 100 or more)

14

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Ok. We set this task to the plan.
One nuance: export will be in .csv format. It works with Excel absolutely correct.

Tatsiana Shmihelskaya
Business Analyst, Gurtam
15

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Sounds great & thanks for the info.
V.

Eflotta Vehicle Tracking Ltd, Hungary
www.eflotta.com
16

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello Tata,
Could you please update this topic?
Regards,
V.

Eflotta Vehicle Tracking Ltd, Hungary
www.eflotta.com
17

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

The task is set, but it is delayed due to its priority.

I've described before the way how to get a driver list with external tools right now. As there is a way to solve the problem, then a new feature cannot be high-priority.

Tatsiana Shmihelskaya
Business Analyst, Gurtam
18

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello Tata...

We have over seven (7) months from your last post about this request, wich is really "a must" for us...
Do you think it will be possible?

19

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hellooooooooo TATA...
I am sad, no answer to my question (today, 6 days ago)...

20

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Dear jhdeguate, I'm sorry. This is hard to answer when you have no good news. The task still has the same status. I'll try to up it and back to you with good news.

Tatsiana Shmihelskaya
Business Analyst, Gurtam
21

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

jhdeguate
it might be a little late and you might be already informed about this, but still...
we have added an ability to export resource contents to .csv.
find more info here: https://docs.wialon.com/en/hosting/cms/port/exp-csv

Maria Starikova,
Wialon Hosting Product manager, Gurtam
22

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello mars , is there any plans to do the oposite? Import drivers from csv/xls?

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br
23

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Fernando Brochetto
Fernando, this idea is noted down already, but we have not been thinking about it in details.
do you think such functionality can be useful? are there any cases you can share?
thank you!

Maria Starikova,
Wialon Hosting Product manager, Gurtam
24

Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Re: Exporting list of: Drivers, Passengers, Trailers and Geofences to .xls

Hello mars, today I don't have any case, but there was already cases that I could have used this funcionality for two clients: one with almost 300 drivers and other with about 600. Big companyes changes a lot their drivers, so is not easy for them to control drivers profiles inside Wialon. If they could just export the drivers list, inside their employes manage system, and import inside Wialon, in this cases it would be useful.

Fernando Brochetto
Technical Support, Rastreasul

fernando@rastreasul.com.br