Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For example, you may use the /Type Multi-Column notation to create Locations for the Base Location “North Campus”, and the path for each new Location should include the following Location Types: “Building”, “Floor” and “Room”. For this Import, you would select the Base Location "North Campus", and the CSV file would be set up as follows: 

Action/Building/Floor/Room
CREATEA02231
CREATEA02240
CREATEA03311
CREATEB01119

The first entry in the above data file sample would be interpreted as the Location Type “Room”. It would have the name “231” under the Location Type “Floor” with name “02”, which would exist under the Location Type “Building” with the name “A”.

...

Using the Path and Name notation, your CSV file must include an Action column for the desired action “CREATE”. It must also include a column for the Location path associated with each new Location, with column header “Path”. For each new Location the “Path” field should include the entire Location path with each path segment separated by a backward slash (e.g., “Building A\Floor 02\Room 231”).

ActionPathTypeName
CREATEBuilding A\Floor 02Room231
CREATEBuilding A\Floor 02Room240
CREATEBuilding A\Floor 03Room311
CREATEBuilding B\Floor 01Room119

In the above data file sample, the first entry would be interpreted as the Location Type “Room”.  It would have the name “231” under the Location Type “Floor” with name “02”, which would exist under the Location Type “Building” with the name “A”.

...

Tip

When updating bulk records via the Import feature, Users typically start the process by exporting the applicable records from IMMS. See the Exporting Data for Update section for more information.

...