Skip to Content

Conversion Program for EMIGALL File format is mandatory

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 10 at 03:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 03 at 07:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 03 at 01:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded