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) <[email protected] >: > 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 <[email protected]> > *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 > 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) < > [email protected]>: > > 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 > [email protected] > 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 > [email protected] > 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 [email protected] To change your delivery options, retrieve your password, or unsubscribe from this list, visit https://dev.eclipse.org/mailman/listinfo/sumo-user
