Skip to Content
avatar image
Former Member

How can I update attributes with excel imports?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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.
    Add comment
    10|10000 characters needed characters exceeded