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.

[Former Member]

It is the practice to do in 2 info paks.

The error you are getting is due to the fact you have some characters that are not recognised by BW.

Check your file and see what do you have.

Also go to SPRO in BW - general settings and there is a place to place the characters that you wish the system to recognise. Check whar all you have and what you have in your file.

If you have a characteristic in your file and thats is not there in SPRO, you have 2 options, either to correct your file or to make a change in SPRO. Better to correct the file.

Ravi Thotahdri

[Former Member]

Hi Ravi,

It is definitely not the direction you are suggestion. After all it was the same file the was saved and instead of 3 columns, separated into 2.

The common column is the one which the system is reporting an error on. If it worked for the Attrib file, definitely is consists of acceptable characters. Even after your suggestion, I copied from the first over it, it still failed.

There must be some other logic here so let’s see what the other experts suggest.

Thanks

[Former Member]

Check the Custcde1 value in the file that has been loaded sucessfully. Copy that name and paste in the second file and load.

Dont have any other characteters in the name and text associated with it.

Ravi Thothadri

[Former Member]

Hi,

I had tried that before but after your post I tried again and got:

"Value 'CustCde1' for characteristic GGG_10 contains invalid characters"

Basically it works for the Attrib infopackage but fails for the Text infopackage.

Shouldn't there be a way to load this as one file instead of my approach i.e. breaking the file into 2? Or, were there a very standard reason why the designer created 2 infopackages?

Thanks