Fuel Surcharge CSV or XML

[cspadola]

We are using OTM v5.5.3.6 on a Windows 64 bit environment.

We currently update our Fuel Surcharge accessorials every month for all but one carrier (this one is done every week). Instead of having to go through the UI and update each Rate Offering with the new fuel surcharge for the month, we would like to do this via CSV / XML upload if it is possible. If we can get all carrier fuel surcharges uploaded in one file it would be great but it is ok if we need to upload a different file for each carrier.

Is there a CSV or XML template for uploading fuel surcharges?

[LourensGlog]

Re: Fuel Surcharge CSV or XML

Are you using Rate Factor Rules for your fuel surcharge? With these you don't need to update your Rate Offerings individually.

[cspadola]

Re: Fuel Surcharge CSV or XML

Hi Lourens...we are not using Rate Factor Rules here.

Each week we update 2 FSC accessorials based on an agreement with one of the carriers we use quite often.

Then each month we create about 8 new FSC accessorials that reflect the incoming month.

Although it is not a hard task, it does take the person updating / creating these FSC accessorials more time than it would if he/she can upload them via CSV or XML.

Thanks

[LourensGlog]

Re: Fuel Surcharge CSV or XML

Hi Carm,

You may want to look into the Rate Factor option in OTM - this is especially designed to reduce maintenance for FSC.

Uploading Rate Offering Accessorials can only be done by CSV, and you should be able to put all 8 accessorials in one file. Don't forget to refresh the rate cache afterwards (OTM Servlets - OTM Wiki)

Lourens

[cspadola]

Re: Fuel Surcharge CSV or XML

Thanks Lourens...is there any documentation I can read to learn to use Rate Factors?

[LourensGlog]

Re: Fuel Surcharge CSV or XML

Other than the OTM Help, I don't think there is anything non propriety about this...
I will put my experiences with Rate Factors on the OTM Wiki soon.

[cspadola]

Re: Fuel Surcharge CSV or XML

Many thanks, Lourens.

Can you update this thread when you have finished your posting on OTM Wiki?

[Sachin]

Re: Fuel Surcharge CSV or XML

I've attached a link of SIG conference presentation which could help you in understanding and configuring rate factors.

http://www.otmfaq.com/forums/f31/otm...17/index2.html

Refer Paul Hamill's presentation.

You can also refer the below post:

http://www.otmfaq.com/forums/f15/sol...2231/#post6661

- Rajiv

[cspadola]

Re: Fuel Surcharge CSV or XML

Hi Rajiv...thanks for the info.

I do not see an attachment in your posting.

[Sachin]

Re: Fuel Surcharge CSV or XML

I'm sorry. Had some problem in uploading the document. I've mentioned the link from where you can download the same.

Rajiv

[cspadola]

Re: Fuel Surcharge CSV or XML

OK, got it.

Thanks for your help.

[LourensGlog]

Re: Fuel Surcharge CSV or XML

Article on wiki: Rate Factors - OTM Wiki