Announcement

Collapse
No announcement yet.

Loading Service Times

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

  • Loading Service Times

    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.

  • #2
    Re: Loading Service Times

    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.
    Warm Regards,
    Srivathsana

    Comment


    • #3
      Re: Loading Service Times

      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.

      Comment


      • #4
        Re: Loading Service Times

        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.
        Warm Regards,
        Srivathsana

        Comment


        • #5
          Re: Loading Service Times

          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.
          Regard's
          Arun

          Comment


          • #6
            Re: Loading Service Times

            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.
            Warm Regards,
            Srivathsana

            Comment


            • #7
              Re: Loading Service Times

              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.
              Regard's
              Arun

              Comment


              • #8
                Re: Loading Service Times

                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.
                Last edited by Srivathsana; July 31, 2008, 10:25.
                Warm Regards,
                Srivathsana

                Comment


                • #9
                  Re: Loading Service Times

                  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
                  Regard's
                  Arun

                  Comment


                  • #10
                    Re: Loading Service Times

                    Yes Arun...
                    Warm Regards,
                    Srivathsana

                    Comment

                    Working...
                    X