Conversion Program for EMIGALL File format is mandatory

[suneel_uggina]

Hi Everyone,

I am using EMIGALL for ISU Data Migration. My Legacy data is in Excel files. Is it possible to convert legacy excel file data into an EMIGALL File format without using any conversion program?

Thanks in advance.

Suneel.Uggina

[ashvinder_rana · Accepted solution]

Hi Suneel,

Simple answer to your question is No.

As Amlan has already informed you, the convert step (REMIG_FILE_TRANSFORM) needs to be executed to create the EMIGALL accepted Bin Text file for further processing.

However, the standard program REMIG_FILE_TRANSFORM cannot transform the XLS layout (single line - delimited) as you have shown above into the Data Record Layout output format (Mig Object CONNOBJ in your example shown).

There has to be some programming to be done to output your single-line data (XLS or TXT) into the data record layout - text tab delimited. This can be done outside of ABAP/SAP also. You can use MS Access/SQL tools to output the file as per the Data Record Layout. Subsequently, you can use the REMIG_FILE_TRANSFORM prior to executing data loads.

Hope this helps.

Ashvinder

[suneel_uggina]

Thank you Amlan. Here my input is in Excel as shown in the below format for connection Object.

I would like to convert into below format which will be accepted by EMIGALL without using any custom conversion program. Please confirm if it is possible through the above mentioned program (REMIG_FILE_TRANSFORM).

CO_10000005 CO_EHA Test Conn obj
CO_10000005 CO_ADR Street1 H101
CO_10000005 &ENDE

Thank you,

Suneel.uggina

[AmlanBanerjee]

Hi Suneel,

EMIGALL only accepts a file in particular format for the load process.

IMHO, irrespective of what format, you have the legacy data, you need to convert it into the EMIGALL accepted format.

Normally, you can use, REMIG_FILE_TRANSFORM report for the purpose.

However, you can write a conversion program as well to convert the excel file into binary text file accepted by EMIGALL load program;

Thanks,

Amlan