Вы не вошли. Пожалуйста, войдите или зарегистрируйтесь.
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,
+1
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?
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,
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.
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)"
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.
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.
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!
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.
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...
We would also be interested in a simple export feature for Drivers especially, that exports all fields including custom fields.
+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)
Ok. We set this task to the plan.
One nuance: export will be in .csv format. It works with Excel absolutely correct.
Sounds great & thanks for the info.
V.
Hello Tata,
Could you please update this topic?
Regards,
V.
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.
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?
Hellooooooooo TATA...
I am sad, no answer to my question (today, 6 days ago)...
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.
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
Hello mars , is there any plans to do the oposite? Import drivers from csv/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!
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.
