[JayVal]

Hi :

One of our carriers has changed their Service times between Zips.
The new data is in an excel spreadsheet. How do I load these data into OTM ?

Thanks for your help in advance.

[Srivathsana]

Hi Jayval,

The source and destination Zip combination will have a X_LANE in OTM.If the data is huge,you can map the data into a CSV referring the table SERVICE_TIME and update the values against the particular lanes.
Please repost for any clarification.

[JayVal]

Thanks Srivathsana.

I looked into the table SERVICE_TIME and I understand that.

But what does your statement
"The source and destination Zip combination will have a X_LANE in OTM" mean ? Are you mentioning about some other tables or database objects ?

Just curious.

Thanks
Jay.

[Srivathsana]

Hi Jayval,

I was mentioning about the column X_LANE_GID present in the SERVICE_TIME table.This represents a source and destination combination say a source and destination zip.
This FKs into the table X_LANE where the source and destination details can be found.

[arunk]

Jayaval,

From your post i understand that you are looking to update an already exsisting carriers service time and not going to add a new one. If then you no need to worry about the x-lanes, just update the SERVICE_TIME_VALUE and SERVICE_TIME_VALUE_BASE columns with the new service times in the SERVICE_TIME table.

If the data you are going to update is of huge amount then you can make CSV file and upload it in update mode.

But if your data has some new x-lanes associated with the service time, as mentioned by Srivathsana you have to create the x-lanes before updating the service time.

Revert if you are not clear.

Reagrds
Arun.

[Srivathsana]

Hi,

I hope the X_LANES needs to be considered as the updation is only between particular zips and not all the zips where the carrier serves.
Please correct me if i am wrong.

[arunk]

Srivathsana,

Even if the updation is betweeen particular zips it will be having their own x-lanes created already unless it is a new one.

Regards
Arun.

[Srivathsana]

Hi Arun,

Yes.x-lanes will be present already.I meant to convey that in a single rate service it is possible that we have multiple lanes which are having different service times.In this case,if the updation is against only a particular set of zips(or lanes as we are considering) the CSV prepared against the SERVICE_TIME table needs to have reference to the x-lane also,by which we can ensure that the service time is updated only for the particular lanes.Hope i am clear.

[arunk]

Srivathsana,

Agreed and i understand wat you are explaining, the service time which is going to get updated should always refer to that particular lane.

Regards
Arun

[Srivathsana]

Yes Arun...