Thanks Jakob. As suggested, I tried changing delimiter in command line but still not getting expected route xml.
command used: csv2xml.py "C:\Users\Bhushan\Sumo\rou.csv" -d "," -t "vehicles" -x "http://sumo.dlr.de/xsd/routes_file.xsd"; -o "C:\Users\Bhushan\Sumo\rou.xml" output file: <routes> <vehicle ="0.79" ="-230604780#2 230604780#2 230604780#3 230604780#4 230604780#5 130576322#0 130576322#1 130576322#2 130576322#3 130576322#4 130576322#5 130576322#6 130576322#7 130576322#8 130576322#9 130576322#10 130576322#11 6122889#0 6122889#1 6122889#2 6122889#3 6122889#" ne="free" eed="max" ="pas1" ="60"> <route edges="MISSING_VALUE"/> </vehicle> <vehicle ="4.77" ="-6095593 6089496#2 6089496#3 6100188#1 6100188#2 -6097263#1 -6097263#0 6143547#7 6143547#8 6126772#10 6126772#11 6126772#12 6116950#0 6116950#1 6116950#2 6116950#3 6126074#0 6109854#0 6109854#1 6128264#5" ne="free" eed="max" ="pas2" ="451"> <route edges="MISSING_VALUE"/> </vehicle> </routes> Thank you. Vrinda Khirwadkar University of Memphis ________________________________ From: Jakob Erdmann <namdre.s...@googlemail.com> Sent: Monday, February 19, 2018 11:25:43 PM To: Sumo project User discussions Cc: Vrinda Khirwadkar (vkhrwdkr) Subject: Re: [sumo-user] Problem with converting csv to xml Hello, the default separator for records is ';'. You can change this using option --delimiter regards, Jakob 2018-02-20 6:05 GMT+01:00 Vrinda Khirwadkar (vkhrwdkr) <vkhrw...@memphis.edu<mailto:vkhrw...@memphis.edu>>: Hello team, Thanks for all your previous suggestions. I am able to proceed ahead in my research. However, I am again stuck at one point. I am trying to create route.xml file from pre-defined routes csv file using csv2xml.py tool. I am using below command and options for the same. This runs without any error but the output it produces is not as expected. It is putting all attributes values at one place and MISSING_VALUE in edges. Can you please suggest what should be the correct way of using csv2xml script. Thanks in advance! Command - csv2xml.py "C:\Users\Bhushan\Sumo\rou.csv" -q "," -t "routes" -x "http://sumo.dlr.de/xsd/routes_file.xsd"; -o "C:\Users\Bhushan\Sumo\rou.xml" Input File - (rou.csv): id,type,depart,departLane,departSpeed,edges 60,pas1,0.79,free,max,-230604780#2 230604780#2 230604780#3 230604780#4 230604780#5 130576322#0 130576322#1 130576322#2 130576322#3 130576322#4 130576322#5 130576322#6 130576322#7 130576322#8 130576322#9 130576322#10 130576322#11 6122889#0 6122889#1 6122889#2 6122889#3 6122889# 451,pas2,4.77,free,max,-6095593 6089496#2 6089496#3 6100188#1 6100188#2 -6097263#1 -6097263#0 6143547#7 6143547#8 6126772#10 6126772#11 6126772#12 6116950#0 6116950#1 6116950#2 6116950#3 6126074#0 6109854#0 6109854#1 6128264#5 Output File - (rou.xml): <routes> <vehicle depart,departLane,departSpeed,edges="60,pas1,0.79,free,max,-230604780#2 230604780#2 230604780#3 230604780#4 230604780#5 130576322#0 130576322#1 130576322#2 130576322#3 130576322#4 130576322#5 130576322#6 130576322#7 130576322#8 130576322#9 130576322#10 130576322#11 6122889#0 6122889#1 6122889#2 6122889#3 6122889#"> <route edges="MISSING_VALUE"/> </vehicle> <vehicle depart,departLane,departSpeed,edges="451,pas2,4.77,free,max,-6095593 6089496#2 6089496#3 6100188#1 6100188#2 -6097263#1 -6097263#0 6143547#7 6143547#8 6126772#10 6126772#11 6126772#12 6116950#0 6116950#1 6116950#2 6116950#3 6126074#0 6109854#0 6109854#1 6128264#5"> <route edges="MISSING_VALUE"/> </vehicle> </routes> Thanks and regards, Vrinda Khirwadkar University of Memphis ________________________________ From: Jakob Erdmann <namdre.s...@googlemail.com<mailto:namdre.s...@googlemail.com>> Sent: Monday, February 12, 2018 6:33 AM To: Sumo project User discussions Cc: Vrinda Khirwadkar (vkhrwdkr) Subject: Re: [sumo-user] Reading large SUMO output files Hello, you can use the tool traceExporter.py to filter sumo fcd-output on the fly and put the output into one or more target files (for each target file a bounding box, and time range can be configured). It is also possible to change the sampling interval and the percentage of vehicles that shall be exported. Read here about connecting sumo and traceExporter directly via a socket so that no large file must be written: http://sumo.dlr.de/wiki/Tools/TraceExporter#Input_Options Read here about filtering: http://sumo.dlr.de/wiki/Tools/TraceExporter#fcd http://sumo.dlr.de/wiki/Tools/TraceExporter#Processing_Options Tools/TraceExporter - Sumo<http://sumo.dlr.de/wiki/Tools/TraceExporter#Processing_Options> sumo.dlr.de<http://sumo.dlr.de> The filter file is a simple csv format giving begin;end;bounding_box;outfile where the bounding box is x1,y1,x2,y2 defining the lower left and the upper right corner ... Unfortunately, there is currently no tool to perform the same type of processing for the netstate-dump. regards, Jakob 2018-02-06 5:24 GMT+01:00 Vrinda Khirwadkar (vkhrwdkr) <vkhrw...@memphis.edu<mailto:vkhrw...@memphis.edu>>: Hello team, I ran a simulation for an area with below mentioned configurations. Total number of vehicles generated in trip.xml file were 145436 for 1 hour. Simulation took approximately 3-4 hours to complete. Now due to size of the output file (fcd and netstate dump), I am not able to analyse it. Can you please suggest any tool or python script which I can use to break the output files based on given timestamp, say output file for every 10 or 15 minutes? Also, will it be a good idea to run simulation for longer duration, for e.g. 30 days with below network file or we should take smaller area. Please suggest. Input Configuration: 1. Net file: 61 MB ; total route length: 3132 km ; No. of edges: 29332 2. Trip File: 21 MB Output Configuration: 1. Fcd Output: 27 GB 2. netstate-dump: 15 GB 3. tripinfo-output: 11 MB Thank you again for your quick suggestions. Vrinda Khirwadkar University of Memphis _______________________________________________ sumo-user mailing list sumo-user@eclipse.org<mailto:sumo-user@eclipse.org> To change your delivery options, retrieve your password, or unsubscribe from this list, visit https://dev.eclipse.org/mailman/listinfo/sumo-user _______________________________________________ sumo-user mailing list sumo-user@eclipse.org<mailto:sumo-user@eclipse.org> To change your delivery options, retrieve your password, or unsubscribe from this list, visit https://dev.eclipse.org/mailman/listinfo/sumo-user
_______________________________________________ sumo-user mailing list sumo-user@eclipse.org To change your delivery options, retrieve your password, or unsubscribe from this list, visit https://dev.eclipse.org/mailman/listinfo/sumo-user
