Help on loading Master data u0096 given a flat file in this format

[Former Member]

Hello.,

..I have a file

(Test.csv)

Customer Code Display name Customer Name

CustCde1 DisplNme1 DescCustomerNme1

CustCde2 DisplNme2 DescCustomerNme2

where Customer Code is the InfoObject GGG_10 and Display name (GGG_11) is an attribute of GGG_10. Customer Name is Medium description of GGG_10.

There already exist 2 infopackages: one for text and the other for attribute. How do I go about in loading this file, Test.csv?

I separated the file into

TestAttrib.csv :

Customer Code Display name

CustCde1 DisplNme1

CustCde2 DisplNme2

and this loaded without any errors and I could browse them through Maintain Master on the InfoObject (GGG_10). Except that the Description column is blank.

On the other hand when I created a second file:

(TestDesc.csv)

Customer Code Customer Name

CustCde1 DescCustomerNme1

CustCde2 DescCustomerNme2

It fails to load …indicating that Custcde1 is invalid. Even if I change this it still fails.

Can you direct me on how best to handle the original file so that when I browse the InfoObject (GGG_10), I will be able to see all 3 columns in the original file? Please provide steps on any suggestion.

Thanks.

[Former Member · Accepted solution]

hi amanda,

Can you check the following :

1. Master data attribut is active. You shouldn't see any modified/changed version in master data.

2. When you are loading the text. Can you do preview in the infopackage . Preview will show how data is being to populated.

3. Check whether you have any spaces in the second file.

What is the delimiter you are using in the flat file ? I suggest to use any delimiter in the flat file.

If you any question , post a message back. Assign points if this is helpful.

Rgds,

Se Vu

[Former Member · Accepted solution]

Hi,

Yes...it is active

Yes... I can preview

No, there is no spaces... it was the same file as the first with a small change ... and it has been verified.

Thanks.