Skip to Content

How can I update attributes with excel imports?

Dec 07, 2017 at 04:32 PM


avatar image
Former Member

PD 16.6 does not update the attributes when I import the excel sheet for the second time with changes.

1. At first I created an excel sheet with the attributes in the following style.

2. I addes the excel import extension to the LDM and added an excel import objekt.

3. I used the following mappings

and options

4. The import workes and generated this LDM

5. After this steps I changed something in the excel sheet and reimported it.

Softdrink -> Softdrink"s"

6. After the import I got a second entry in the model

I expected that only this attribute (Softrinks was updated but instead the PD generated a second attribute (Softdrink and Softdrinks)

Who can help me to solve this issue?

screenshot3.jpg (18.3 kB)
screenshot2.jpg (26.0 kB)
screenshot4.jpg (60.3 kB)
screenshot5.jpg (133.9 kB)
screenshot1.jpg (16.6 kB)
screenshot6.jpg (19.4 kB)
screenshot7.jpg (18.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
George McGeachie Dec 07, 2017 at 10:50 PM

The Excel import can handle changes to everything apart from the name or code, which it uses to match the entries in Excel to things in the model. There are two things you could try:

  1. In the import options, tell it to match on the code (not the name). In the import file, include the existing Codes for the objects. When you rename something, just change the value in the name column, leave the code as it is. When the import runs, it should match the attribute code, and apply the new name, which will then trigger the Name to Code routine.
  2. If that doesn't work, import into a different model each time, and then merge the new model into the existing one, matching the renamed things yourself. It's simpler if you only import the changed objects.
10 |10000 characters needed characters left characters exceeded