How do I generate a .tbl file from a .csv file while creating a flatfile mapping using AIE?

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Atrium Integration Engine


    APPLIES TO:

    BMC Atrium Integration Engine



    QUESTION:

    How do I have AIE generate a .tbl file from a .csv file so I don't have to manually create one from scratch? 


    ARServer Version: 7.1.00 Patch 006 200811280530
    AIE Version: 7.1.00 Patch 001 200711011300

    DR: Remedy Enterprise Integration Engine; Server: Windows Server 2003; Client: Windows XP



    ANSWER:

     

    Legacy ID:KA311711

      
      The .tbl file is generated when the AIE mapping is created.
      
      However you can use filehelper command to generate .tbl file from a .csv file.
      
      The file helper binary is located in <AIE_Install_dir>\service\bin.
      
        
      
      Here's a sample command on Windows platform:
      
        
      
      D:\Program Files\BMC Software\AtriumCore\aie\service\bin>filehelper -ax w3kee-sp2-20hd -ar 38000 -al "Demo" -ap "" -fn "D:\rbcreport2"
     
      
      where 
      
        -ax <AR System> server name is the name of AR System server where the EIE:VendorFieldNames form resides;
      -al <user name>ar user name used to log on to the AR System server
      -ap <password> is the user's password;
      
         [-ar <port number>]
      -fn <File Path>  Path to the File
      
        
      
      For -fn parameter, specify the absolute path of the csv file WITHOUT extension.
      
        
      
        
      
    Related Products:  
       
    1. BMC Atrium Integration Engine

     


    Article Number:

    000026117


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles