---
# System prepended metadata

title: Location importation

---

# Location importation

@Adam Cashman

As your idea, client send us the csv file with the Area ID column. How client know the Area ID value? It could be the name of Area, but it not exactly. Look at the below mock:


```
└── Root
    └── Area1
        ├── AreaA
        │     ├── Location1
        │     └── Location2
        └── AreaB
              ├── Location3
              └── Location4
    └── Area2
        ├── AreaA
        │     ├── Location5
        │     └── Location6
        └── AreaB
              ├── Location7
              └── Location8
```

If the Area ID of location5 is AreaA. We can find the Id of AreaA, but it can be a the Id of AreaA from the Area1.

I have some suggestions as below:
Suppose we have the csv file below:

| Area | Region | District | Location | Location Name              |
| ---- | ------ | -------- | -------- | -------------------------- |
| 00   | 80     | 00       | 00186    | 00186 - CVS Pharmacy, Inc. |
| 00   | 80     | 00       | 00391    | 00391 - CVS Pharmacy, Inc. |
| 00   | 80     | 00       | 02410    | 02410 - CVS Albany, L.L.C. |

1. The level of area from left to right: 
- Add new the Area Type constant to Import As
- As above Table: the Area is parent of Region, Region is parent of Distict, District is parent of Location ... (from left to right)

![](https://i.imgur.com/jIFwVwu.png)


2. Add more Area Level constants into the Import As:
- At Confirm Headers section. For the Import As column. We add more five constants (Area Level1, Area Level 2...Area Level 5)
- And user has to specify which column is mapping to Which level. 

![](https://i.imgur.com/wYP9dgA.png)

3. User config which column is Area/Location and which is its parent.
![](https://i.imgur.com/UfGgybn.png)
