Announcement

Collapse
No announcement yet.

Automating the Fuel Surcharge weekly updation Process

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

  • Automating the Fuel Surcharge weekly updation Process

    Dear Pals,

    On one of the presentation of SIG conference posted by Chris, I read that we can automate the weekly Fuel Surcharge process, directly by getting DOE fuel price from website and updating the required OTM tables. Could any one tell me how can we achieve this?

    Cheers,
    Lakshman
    Cheers,
    Murthy

  • #2
    Re: Automating the Fuel Surcharge weekly updation Process

    Hi Lakshman,

    FuelSurcharges can be automated using Rate Factors in OTM.Using Rate Factor, Fuel Surcharges can
    be copied into shipments,as accessorials during the planning.This can be found under Contract and Rate Management > Power Data > Rate Factor & Rate Factor Rule
    Warm Regards,
    Srivathsana

    Comment


    • #3
      Re: Automating the Fuel Surcharge weekly updation Process

      I think he is talking about the extracting the Fuel surcharge data fron DOE site directly and updaing it automatically through Rate Factor rule
      Nilabja Dey

      Comment


      • #4
        Re: Automating the Fuel Surcharge weekly updation Process

        Ya, exactly. I would like to know hoe to get the weekly fuel price from DOE website and update the Rate Factor and there by process those at some scheduled time. Without any manual intervention. Could any one help me on this?
        Cheers,
        Murthy

        Comment


        • #5
          Re: Automating the Fuel Surcharge weekly updation Process

          Which presentation from the SIG talked about this?

          Comment


          • #6
            Re: Automating the Fuel Surcharge weekly updation Process

            Rate Factors - OTM Wiki

            Comment


            • #7
              Re: Automating the Fuel Surcharge weekly updation Process

              It appears that I wasn't clear when submitting my post because I was directed to a site which delivers the basics on creating Rate Factors and Rate Factor Rules. I am aware of the setup of those and how they can be used in facilitating fuel surcharge calculations.

              What I am interested in is how I can automate the process of actually going to the eia.gov site (or via subscription email), retreiving the weekly on highway deisel price and placing that number in OTM to then be processed accordingly. From what I can tell, the eia site does not provide a webservice which can be leveraged.

              Has anyone found a way to avoid the weekly process of manually entering the index number in OTM?

              Comment


              • #8
                Re: Automating the Fuel Surcharge weekly updation Process

                Are you talking about this one?
                http://www.otmfaq.com/forums/f31/otm...1574/#post4532
                --
                Joseph Liang
                MavenWire APAC
                http://www.mavenwire.com/

                Comment


                • #9
                  Re: Automating the Fuel Surcharge weekly updation Process

                  That helps. Thanks, Joseph. I would have never found that. Sounds like the factor retrieval has been automated using Web scraping with HTTP.

                  Comment


                  • #10
                    Re: Automating the Fuel Surcharge weekly updation Process

                    Hi Joe,

                    Could you please let us know how to setup Automating the Fuel Surcharge in OTM using Web scraping with HTTP.

                    Regards
                    Arpit

                    Comment

                    Working...
                    X