meta data

[nag0143]

hi all i have a flat file with 200 columns, i was given only meta data now....

i am to make a model of the job... i am trying to get metadata but i could'n, mata data is in excel in this format
"Data base" "Fieldname" "Fieldtype" "Field lengthin bytes" "Fractionalpart" "Value" "Field description"


MARA IDNRA CHAR 18 Material number
SART CHAR 1 A Dummy only for controls
WERKS CHAR 2 Dummy only for controls
LGONR CHAR 2 Dummy only for controls
UBUKRS CHAR 4 Dummy only for controls
UWERKS CHAR 4 Dummy only for controls
MARA MTART CHAR 4 Material type
MARA MBRSH CHAR 1 M Material application type
MARA KSP01 CHAR 2 Language indicator 1
MARA KTX01 CHAR 40 Material short text, language 1
MARA KSP02 CHAR 2 Language indicator 2
MARA KTX02 CHAR 40 Material short text, language 2
MARA KSP03 CHAR 2 Language indicator 3
MARA KTX03 CHAR 40 Material short text, language 3
IDATE CHAR 8 Marketing intro date
PGRUP CHAR 18 Product hierarchy
KLAH NORMB CHAR 9 Material class/ material group
MARA BISMT CHAR 18 Old material number
MARA MEINS CHAR 3 Basic unit of measure
MARA BSTME CHAR 3 Procurement quantity unit
MARA ZEINR CHAR 22 Document number


can any one have idea easy way to get into ascential... do't want to type all....

thank you,

nag

[ogmios]

Save the file in csv format, write a small perl script to take this file as input and generate an Ascential style .dsx file

It would require a little bit of reverse engineering and would be totally on your own risk. I don't have an example handy right now. And I would only suggest to make it yourself if you have a lot of these things to do.

Ogmios

[fabianorb]

You can use the Sequential File Definition function in the "Load..." button.
It can be acess importing the sequential file definition.

Maybe It can help you.

Fabiano

[nag0143]

Thank you fabianorb for Sequential File Definition i tryed from manager to import. but din't work. can you add some more....

thanks again

nag

[maximus]

Actualy you can import the sequential file definiton...Jus right click on the table definitions in Repository tree and import...It will list all the diff types...select sequential file definition and proceed...Set the properties accordingly...like the delimiter and other things...I think it shud help :)

Max

[vmcburney]

Take your Excel column name column and transpose it to a run from left to right. Do a search and replace to remove spaces.
Copy and paste the row into a sequential file. Import this file as a tab seperated text file with first line containing column names. The import utility will load in the column names for you. Now just go down the column and for each of the 200 columns and set to char and give it a field width using the Excel print out as the guide.

When you load this into a sequential file stage set it to a fixed width file with no column names.

[nag0143]

thank you vmcburney, i did the same but checking for a easier method.... guess not there.... thank you again..... vmcburney