topic Re: Data will not load in Transportation Questions

Data will not load

ReneeChristian — Tue, 25 May 2010 12:50:00 GMT

Thank you for your clarification of the terms. However I am still not able to limport my data into the system. I continue to get an "arrive time nor depart time contain invalid numbers" error message.

I've enclosed the sample data I am using.

I am mapping Arrive time with bell time

Earliest drop before bell with a number which is formatted as a number. This varies by school.

Latest depart is also number and is most cases will be 10 minutes.

Please help.

R Christian

Re: Data will not load

JeffWickstrom — Tue, 25 May 2010 21:09:52 GMT

Renee,

Thank you for the sample data. That is a big help.

I imported those trip requests. Some of the first rows of the spreadsheet import OK. Then there are many errors with "Trip Request import failed ... Neither Arrive Time nor Depart Time contain a valid value."

You can either ignore these errors or try fixing the "named range" or whatever is making the spreadsheet appear to have these extra rows. It is an artifact of using a spreadsheet as a database.

The other important thing to realize is that each of these rows actually contain two trips. The trip to school and the return trip after school. That is OK for the data to be like this, but we need to import the trips twice, once for each direction. In particular,

1) Import trips, mapping
"Pick Up Add" to "From Address"
...
"School Address" to "To Address"
"Bell time" to "Arrive Time"
"Earliest drop before bell" to "Earliest Arrival"

2) Save this import profile as "To School" or similar.

3) Import trips again, this time mapping
"School Address" to "From Address"
...
"DROP From school Address" to "To Address"
"Bell time from school time" to "Depart Time"
"Latest depart from School" to "Latest Depart"

4) Save this profile as "From school" or similar.

In the step 1) mappings, you could also map these "Earliest P/U to School" and "Latest P/U to School" times to "Pickup From Time" and "Pickup To Time". By doing this, you are just overriding the time windows that ArcLogistics would compute for these pickups.

Also be sure to adjust the ride time flexibility as I mentioned in the other message. Set it to 100 to 200 (%) so we minimize the likelihood of making extra stops at the school. In other words, make the time windows as wide as are legally allowed to minimize the extra stops at the school you may need to correct in the result.

Please do let us know how well the overall solution works for you.

Jeff

EDIT: FYI, to get your trips routed I needed to fix the "DROP From school Address" column to be PM instead of AM. I also changed my Default Trip Request Properties to have "Maximum Time on Vehicle, Always at least" set to 120 mins. This widens the pickup and delivery time windows at the cost of customer service (long ride times). I also set the Load and Unload times to 0.1 (10 students per minute). After doing this I could route those trips with two buses. I didn't account for actual bus capacity.

Re: Data will not load

ReneeChristian — Wed, 26 May 2010 15:27:11 GMT

Renee,

Thank you for the sample data. That is a big help.

I imported those trip requests. Some of the first rows of the spreadsheet import OK. Then there are many errors with "Trip Request import failed ... Neither Arrive Time nor Depart Time contain a valid value."

You can either ignore these errors or try fixing the "named range" or whatever is making the spreadsheet appear to have these extra rows. It is an artifact of using a spreadsheet as a database.

The other important thing to realize is that each of these rows actually contain two trips. The trip to school and the return trip after school. That is OK for the data to be like this, but we need to import the trips twice, once for each direction. In particular,

1) Import trips, mapping
"Pick Up Add" to "From Address"
...
"School Address" to "To Address"
"Bell time" to "Arrive Time"
"Earliest drop before bell" to "Earliest Arrival"

2) Save this import profile as "To School" or similar.

3) Import trips again, this time mapping
"School Address" to "From Address"
...
"DROP From school Address" to "To Address"
"Bell time from school time" to "Depart Time"
"Latest depart from School" to "Latest Depart"

4) Save this profile as "From school" or similar.

In the step 1) mappings, you could also map these "Earliest P/U to School" and "Latest P/U to School" times to "Pickup From Time" and "Pickup To Time". By doing this, you are just overriding the time windows that ArcLogistics would compute for these pickups.

Also be sure to adjust the ride time flexibility as I mentioned in the other message. Set it to 100 to 200 (%) so we minimize the likelihood of making extra stops at the school. In other words, make the time windows as wide as are legally allowed to minimize the extra stops at the school you may need to correct in the result.

Please do let us know how well the overall solution works for you.

Jeff

EDIT: FYI, to get your trips routed I needed to fix the "DROP From school Address" column to be PM instead of AM. I also changed my Default Trip Request Properties to have "Maximum Time on Vehicle, Always at least" set to 120 mins. This widens the pickup and delivery time windows at the cost of customer service (long ride times). I also set the Load and Unload times to 0.1 (10 students per minute). After doing this I could route those trips with two buses. I didn't account for actual bus capacity.

Jeff,

Thank you. I tried all your suggestions and as you stated it will not load. I am continuing to get "Trip Request import failed ... Neither Arrive Time nor Depart Time contain a valid value."

You mentioned I could ignore these errors - how would I accomplish this?

Renee

Re: Data will not load

JeffWickstrom — Wed, 26 May 2010 16:32:23 GMT

Renee,

You are getting zero trips/orders added after running the import?

Try scrolling to the top in that results list you see after the import.

I see many "Trip Request John Doe1 imported successfully." lines at the top. One for each of the valid records/rows I presume. Do you see any of these lines?

After that I see a bunch of "Neither Arrive Time nor Depart Time contain a valid value." errors. These are all of the blank/null/garbage rows it is treating as records. These messages can be ignored. ArcLogistiocs will not have added any trips/orders for these so there is nothing more you need to do.

Here is a screen shot attached in case it helps.

If you are not seeing this result then probably our next step is to examine how you have mapped the fields.

Jeff