Flat File Upload

[Former Member]

Hi All,

I am trying to upload a ASCII file.

The problem I am facing is

the last column which is key figure type Number( DEC) is not being picked up. If I try to adjust it, its showing up with the first key figure in the first key figure's column. So please let me know what I'm doing wrong.

Also can somebody give me the basics of creating a ASCII file.

Thanks,

Harini

[Former Member]

Hi Harini,

The decimal and Integer values should be specified in the ASCII file with preceding zeros.

For example if your field is an interger of length 7 then the values should be like

0004000

0000300

And for Decimals the values should be like

004000.00

002300.45

Regards,

Prema

[Former Member]

Hi Premalatha,

The question I have here is when you define a keyfigure you can only specify the data type, there is no place where you can specify the length. so can you please tell me the length i should take for integer and number fields.

Appreciate help.

Thanks,

Harini

[Former Member]

Hi Harini,

the length follows from your source file. If e.g. in your source file the range of keyfigure ABCD is character 7 to 15, you specify length 9 characters.

Best regards,

Björn

[Former Member]

Hi Björn,

I know that characteristics length can be determined by the source file but how about the keyfigure length for the data types number and integer.

Thanks,

Harini

[Former Member]

Hi Harini,

you don't have to specify length for numeric key figures. If you are loading from flat file, you only have to specify the position of the key figures in source file.

If it is still not clear, you might give an example of your source file?

Best regards,

Björn

[Former Member]

Björn please give em your email address I'll send you the sample file.Mine is harini_mb@yahoo.com

Thanks,

Harini

[Former Member]

Hi Harini,

please send your file to

I hope then I will be able to better understand your concern!

Thanks,

Björn

[Former Member]

Harini, I just tried to load your file myself and got some odd characters in second row. Did you place the blanks between with TAB key? You have to place the blanks by using SPACE...

Best regards,

Björn

[Former Member]

Hi Björn,

I did not use Tabs I am using spaces. I tried your file and still it does not load.

Appreciate help,

Thanks,

Harini

[Former Member]

Thanks All, for the replies. I figured out the problem is not with the file but some custom code that I have in the background.

Appreciate all the help.

Thanks,

Harini

[Former Member]

Hello Harini,

When you load data directly from ASCII you need to take care of data type of the associated objects.

say you have 2 objects in your structure one with CHAR20 and other is Char 10 then make sure in your file first 20 character will be object one i.e. make the value as right aligned and from character 21 your value for next object will start, so if you have say "Upload" as your value for the second object put this value from 25 th place upto 30.

-Ashish

[Former Member]

Thanks Ashish,

Can you please tell me how I should handle numeric data types like Number (DEC) and Integer(INT 4).

Appreciate Help,

Thanks,

Harini

[Former Member]

Hi Harini

As per Ashish's suggestion & depending upon the length of your fields , you have to format your flat file (Ashish has already explained this with example )

Alternatively use CSV file and then you don't have to count the spaces as required.

Hope this helps

Regards

Pradip

(Friends : Don't forget to assign points !!)