Updating Qualifiers using import manager

[Former Member]

I am having difficulties with updating my data in qualified lookup tables. I have a qualified lookup table Produkt Market Data with market as a display field (hierarchical lookup).

All other fields in this table are qualifiers, most of them multi valued. I have loaded the non multi value fields in the table first, so there is an entry for eg product 4711, market Health Care.

When i try to update a field text (multi valued flat lookup) using the import manager, the record 4711-Health Care is not updated but a lot of entries 4711-Health Care are created extra, each of them containing one line of text. I used the option update all mapped fields (and have mapped only product, market and text). When I choose the option update Null fields only, nothing happens: only the lookup table for the text is updated.

can anyone tell me what i am doing wrong. It should be possible to update qualified fields using the import manager instead of creating new entries shouldn't it??

Regards,

Bert

[Former Member]

Hi Bert,

While mapping the fields in the Map fields/Values tab,

1. Select the Non-Qualified field in the Destination fields

2. Right click and select "Set Qualified Update" and then "Update".

3. In the new pop up, select the matching qualifier.

4. For New Links, set "Create"

5. For Existing Links, select "Update Mapped Qualifiers".

6. Now, in the Match Records tab, select Default Import action as "Update(All Mapped Fields)".

This should not create duplicate records.

Hope this helps....Let me know in case you still face problems...

Regards,

Rajani Kumar

[Former Member]

Hi Rajani,

Thanks for your detailed answer. Unfortunately the records are still not updated, although I precisely followed your instructions. When reading it I thought that it would solve my problem, but no. I am working with SP02 5.5.24.09. I keep on struggling, if yopu have anymore tips, please let me know.

Regards,

Bert

[Former Member]

Hi,

See the below example.

-

---

HeirarchyT [Hierrachy Table]

Name Text[5]

-

---

Data in Hierarchy Table

Hier1

-H1

--H3

-H2

--H4

-

---

MainT[Main Table]

Field1[Text5]

QField1[Lookup Qualified multivaled]

-

---

LT1 [ Flat Table 1]

NameLT1 Text[100]

CodeLT1 Text[2]

Data in this Table

LT1Val1 LT1Code1

LT1Val2 LT1Code2

LT1Val3 LT1Code3

LT1Val4 LT1Code4

-

---

LT2 [ Flat Table 2]

NameLT2 Text[100]

CodeLT2 Text[2]

Data in this Table

LT2Val1 LT2Code1

LT2Val2 LT2Code2

LT2Val3 LT2Code3

LT2Val4 LT2Code4

-

---

QualTable[Qualified Table]

QH1 Lookup[hierarchy]

No(Qualifier) Yes(DisplayField)

QMLV1 Lookup[Flat]

Yes(qualifier) LookupTable[LT1]

Yes(Multivalue)

QMLV2 Lookup[Flat]

Yes(qualifier) LookupTable[LT2]

Yes(Multivalue)

Intial data in the repository:

Record 1: N1

Qualified Data:

QH1 : H3

QMLV1: LT1Val1,LT1Val3

QMLV2: LT2Val2,LT2Val4

Record 2: N2

Qualified Data:

QH1 : H4

QMLV1: LT1Val2,LT1Val4

QMLV2: LT2Val1,LT2Val3

-

---

Lets say u have source data in Excel sheet like below.

N1 H4 LT1Val2,LT1Val4 LT2Val1,LT2Val3

N2 H3 LT1Val3,LT1Val1 LT2Val2,LT2Val4

-

---

Follow the instructions given by Rajani till step 5.

In the Step 6 selct The default import action as <b>"Replace".</b>

I hope this helps.

Thanks and Regards

Subbu

[Former Member]

Hi Subbu,

Thanks for your very detailed answer, I do appreciate it. But my problem is that I don't want to do a replace but an update. My table has 10 fields, all multi value and I want to update only one field. This is because the number of entries per record per field can differ very much. I want to leave the other fields as they are. Whan I do a replace, all other fields are blanked out, even the non mapped fields.

I will struggle some more,

Regards,

Bert

[Former Member]

Hi,

In Import manager "Configuration" menu and select Options.

Check the following settings:

Default Multi-valued update:<b>Replace</b>

Default Qualified update:<b>Appen</b>d

Default matching qualifieres:<b>All</b>

I hope the above settings will def help you in solving your problem.

for detailed explanation on the above options, you can check the Import manager Guide in page# 61.

Thanks

Subbu

[Former Member]

Hi Subbu,

Thanks for your answer and sorry for the late response, i started the new year with a small holiday.

I have found the answer to my problems, I selected too many matching qualifiers in the step where I set the qualifier update. As a result of this, new links were created.

Thanks again for your time ans answers.

Regards,

Bert

[Former Member]

Hi Subbu! Found this post and it applies to my issue. On my qualified table, I will have up to four entries for a record. There are 3 non-qualifiers A, B, C. A will remain the same and is the same for all four entries. B will all be different for each entry and, once issued will not change. C can be changed. The qualifiers are irrelevant at this point. I will be importing XML files (multi-node) from XI out of PR5.

I keep getting conflcts. Plus, my "Set Qualified Update" is greyed out. I'm close.. but frustrated

[Former Member]

Hi,

In the Import manager, Import action for "Exact" Match Type select it as "Replace".

Let me know if you want with an example.

Thanks

Subbu