3 Replies Latest reply on May 18, 2011 4:34 PM by JeffJon

    bulk location update

    pr921
      I need to update 150 locations with one row of data...I have extracted the FDM_ID's

      ...does anyone know what tables I will need to insert into?

      Jz
        • 1. Re: bulk location update
          JTF85
          Is it one row of actual data in the import or validate step or one row of a mapping? The mapping can be updated for multiple locations using one xls file, you can take an export of the mapping of one location for an example, modify it with the different partition keys and the one row of mapping, update the range that begins with UPS and import the file.

          JTF
          • 2. Re: bulk location update
            pr921
            it is only one row, three columns of values I need associated with a location, in addition to the IS and BS

            I would need three more mapping is this case...don't think I want to do that...if I don't have to.

            Jz
            • 3. Re: bulk location update
              JeffJon
              There is not really a way to bulk update a location. You can use templates to update the mapping for the location, but any changes to the settings in the location should be done within Metadata > Locations in the interface.