Topic:
How do I format an ELD file to import into RapidLog?
File Format:
Must be saved as a .xml file.
Layout:
<RapidLog_eLogs>
<elog>
<driver/>
<duty_status_points>
<point/>
</duty_status_points>
<day_events>
<miles/>
</day_events>
</elog>
</RapidLog_eLogs>
Fields:
driver: *idnumber, *clear_from, *clear_to
duty_status_points: *timezone
point: *status, *timestamp, odometer, location, latitude, longitude, remark1, remark2
day_events: timezone
miles: timestamp, distance
*Indicates a mandatory field
Note: If using odometer values in the points RapidLog will calculate the distance on the day based on the odometer values. Do not use both the miles field and the odometer field. Pick one or the other.
Download Sample File:
Sample:
<?xml version=”1.0″?>
<RapidLog_eLogs>
<elog>
<driver idnumber=”4433″ clear_from=”11/01/2019 12:00 AM” clear_to=”11/10/2019 11:59:59 PM”/>
<duty_status_points timezone=”GMT”>
<point status=”1″ timestamp=”11/01/2019 06:00:00″ odometer=”0″ location=”” latitude=”” longitude=”” remark1=”” remark2=””/>
<point status=”4″ timestamp=”11/01/2019 15:14:00″ odometer=”0″ location=”Florence, SC” latitude=”34.216016″ longitude=”-79.798976″ remark1=”” remark2=””/>
<point status=”3″ timestamp=”11/01/2019 15:16:00″ odometer=”0″ location=”Florence, SC” latitude=”34.21604″ longitude=”-79.799″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/01/2019 21:30:00″ odometer=”0″ location=”Savannah, GA” latitude=”31.984486″ longitude=”-81.224424″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/02/2019 00:13:00″ odometer=”0″ location=”Savannah, GA” latitude=”31.984564″ longitude=”-81.224344″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/02/2019 01:27:00″ odometer=”0″ location=”Yemassee, SC” latitude=”32.800844″ longitude=”-80.770312″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/02/2019 06:00:00″ odometer=”0″ location=”” latitude=”” longitude=”” remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/02/2019 22:09:00″ odometer=”0″ location=”Warsaw, NC” latitude=”34.994248″ longitude=”-78.129352″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/02/2019 22:17:00″ odometer=”0″ location=”Warsaw, NC” latitude=”34.994456″ longitude=”-78.129184″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/02/2019 22:18:00″ odometer=”0″ location=”Warsaw, NC” latitude=”34.99388″ longitude=”-78.128992″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/02/2019 22:22:00″ odometer=”0″ location=”Warsaw, NC” latitude=”34.994852″ longitude=”-78.129624″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/03/2019 06:00:00″ odometer=”0″ location=”” latitude=”” longitude=”” remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/03/2019 13:02:00″ odometer=”0″ location=”Warsaw, NC” latitude=”34.99532″ longitude=”-78.12992″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/03/2019 13:08:00″ odometer=”0″ location=”Warsaw, NC” latitude=”34.993952″ longitude=”-78.128968″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/03/2019 21:45:00″ odometer=”0″ location=”Mebane, NC” latitude=”36.067728″ longitude=”-79.314″ remark1=”” remark2=””/>
<point status=”3″ timestamp=”11/03/2019 22:09:00″ odometer=”0″ location=”Mebane, NC” latitude=”36.067768″ longitude=”-79.313912″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/03/2019 23:45:00″ odometer=”0″ location=”Statesville, NC” latitude=”35.812604″ longitude=”-80.834392″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/04/2019 07:00:00″ odometer=”0″ location=”” latitude=”” longitude=”” remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/04/2019 15:05:00″ odometer=”0″ location=”Statesville, NC” latitude=”35.812632″ longitude=”-80.83436″ remark1=”” remark2=””/>
<point status=”4″ timestamp=”11/04/2019 22:53:00″ odometer=”0″ location=”Dandridge, TN” latitude=”36.038376″ longitude=”-83.444112″ remark1=”” remark2=””/>
<point status=”3″ timestamp=”11/04/2019 22:58:00″ odometer=”0″ location=”Dandridge, TN” latitude=”36.037668″ longitude=”-83.44448″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/05/2019 00:28:00″ odometer=”0″ location=”Crab Orchard, TN” latitude=”35.928152″ longitude=”-84.912792″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/05/2019 01:00:00″ odometer=”0″ location=”Crab Orchard, TN” latitude=”35.928212″ longitude=”-84.91288″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/05/2019 01:58:00″ odometer=”0″ location=”Lancaster, TN” latitude=”36.139584″ longitude=”-85.806456″ remark1=”” remark2=””/>
<point status=”4″ timestamp=”11/05/2019 18:42:00″ odometer=”0″ location=”Pembroke, KY” latitude=”36.679664″ longitude=”-87.404888″ remark1=”” remark2=””/>
<point status=”3″ timestamp=”11/05/2019 19:06:00″ odometer=”0″ location=”Oak Grove, KY” latitude=”36.679908″ longitude=”-87.404648″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/05/2019 20:26:00″ odometer=”0″ location=”Paducah, KY” latitude=”37.05136″ longitude=”-88.65396″ remark1=”” remark2=””/>
<point status=”3″ timestamp=”11/05/2019 21:44:00″ odometer=”0″ location=”Paducah, KY” latitude=”37.05136″ longitude=”-88.653968″ remark1=”” remark2=””/>
<point status=”4″ timestamp=”11/06/2019 01:48:00″ odometer=”0″ location=”Mountain View, MO” latitude=”37.001832″ longitude=”-91.70756″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/06/2019 01:56:00″ odometer=”0″ location=”Mountain View, MO” latitude=”37.00188″ longitude=”-91.707″ remark1=”” remark2=””/>
<point status=”3″ timestamp=”11/06/2019 21:28:00″ odometer=”0″ location=”Springfield, MO” latitude=”37.31216″ longitude=”-93.33012″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/06/2019 22:10:00″ odometer=”0″ location=”Collins, MO” latitude=”37.874824″ longitude=”-93.621528″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/06/2019 22:10:00″ odometer=”0″ location=”Collins, MO” latitude=”37.874824″ longitude=”-93.621528″ remark1=”Fueling” remark2=””/>
<point status=”3″ timestamp=”11/06/2019 22:26:00″ odometer=”0″ location=”Collins, MO” latitude=”37.874816″ longitude=”-93.621536″ remark1=”” remark2=””/>
<point status=”4″ timestamp=”11/07/2019 01:27:00″ odometer=”0″ location=”Dearborn, MO” latitude=”39.471544″ longitude=”-94.787424″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/07/2019 01:36:00″ odometer=”0″ location=”Dearborn, MO” latitude=”39.475576″ longitude=”-94.786744″ remark1=”” remark2=””/>
<point status=”3″ timestamp=”11/07/2019 02:17:00″ odometer=”0″ location=”Dearborn, MO” latitude=”39.475568″ longitude=”-94.786752″ remark1=”” remark2=””/>
<point status=”3″ timestamp=”11/07/2019 18:54:00″ odometer=”0″ location=”Elm Creek, NE” latitude=”40.692252″ longitude=”-99.381416″ remark1=”” remark2=””/>
<point status=”4″ timestamp=”11/07/2019 20:00:00″ odometer=”0″ location=”North Platte, NE” latitude=”41.098296″ longitude=”-100.682936″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/07/2019 20:51:00″ odometer=”0″ location=”Ogallala, NE” latitude=”41.119618″ longitude=”-101.603583″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/08/2019 07:00:00″ odometer=”0″ location=”” latitude=”” longitude=”” remark1=”” remark2=””/>
<point status=”4″ timestamp=”11/08/2019 13:59:00″ odometer=”0″ location=”Elk Mountain, WY” latitude=”41.630846″ longitude=”-106.285147″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/08/2019 17:30:00″ odometer=”0″ location=”Little America, WY” latitude=”41.545549″ longitude=”-109.856685″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/09/2019 07:00:00″ odometer=”0″ location=”” latitude=”” longitude=”” remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/09/2019 11:43:00″ odometer=”0″ location=”Caldwell, ID” latitude=”43.661884″ longitude=”-116.654114″ remark1=”” remark2=””/>
<point status=”1″ timestamp=”11/09/2019 14:14:00″ odometer=”0″ location=”La Grande, OR” latitude=”45.297025″ longitude=”-118.043629″ remark1=”Fueling” remark2=””/>
<point status=”1″ timestamp=”11/10/2019 07:00:00″ odometer=”0″ location=”” latitude=”” longitude=”” remark1=”” remark2=””/>
</duty_status_points>
<day_events timezone=”GMT”>
<miles timestamp=”11/01/2019 00:00:00″ distance=”251″/>
<miles timestamp=”11/02/2019 00:00:00″ distance=”372″/>
<miles timestamp=”11/03/2019 00:00:00″ distance=”261″/>
<miles timestamp=”11/04/2019 00:00:00″ distance=”413″/>
<miles timestamp=”11/05/2019 00:00:00″ distance=”385″/>
<miles timestamp=”11/06/2019 00:00:00″ distance=”34″/>
<miles timestamp=”11/06/2019 00:00:00″ distance=”378″/>
<miles timestamp=”11/07/2019 00:00:00″ distance=”327″/>
</day_events>
</elog>
</RapidLog_eLogs>