Announcement

Collapse
No announcement yet.

Fuel Surcharge CSV or XML

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Fuel Surcharge CSV or XML

    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?

  • #2
    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.

    Comment


    • #3
      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

      Comment


      • #4
        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

        Comment


        • #5
          Re: Fuel Surcharge CSV or XML

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

          Comment


          • #6
            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.

            Comment


            • #7
              Re: Fuel Surcharge CSV or XML

              Many thanks, Lourens.

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

              Comment


              • #8
                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
                Last edited by Sachin; October 22, 2009, 14:12. Reason: missed attachment

                Comment


                • #9
                  Re: Fuel Surcharge CSV or XML

                  Hi Rajiv...thanks for the info.

                  I do not see an attachment in your posting.

                  Comment


                  • #10
                    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

                    Comment


                    • #11
                      Re: Fuel Surcharge CSV or XML

                      OK, got it.

                      Thanks for your help.

                      Comment


                      • #12
                        Re: Fuel Surcharge CSV or XML

                        Article on wiki: Rate Factors - OTM Wiki

                        Comment

                        Working...
                        X