Clarity

  • 1.  Has anyone worked on inbound integration via flat file into CA PPM?

    Posted Mar 13, 2019 02:05 PM

    Hi All,

    I'm wondering how inbound integration works in CA PPM where data needs to be inserted into PPM via flat file. How does this work?

     

    #inboundintegration #flatfile 



  • 2.  Re: Has anyone worked on inbound integration via flat file into CA PPM?

    Posted Mar 13, 2019 03:41 PM

    One approach is to make a gel process to convert the flat file to supported XML for XOGing and to XOG it in.



  • 3.  Re: Has anyone worked on inbound integration via flat file into CA PPM?

    Posted Mar 13, 2019 03:55 PM

    Thanks for the response. So, I would write a gel script to read the file from the FTP folder (where the flat file is located) - script handles the code that consumes the file and converts to XML for XOGin. Suggest me if I missed anything? and could you let me know do we have any tool to convert the flat file from text to XML?



  • 4.  Re: Has anyone worked on inbound integration via flat file into CA PPM?

    Posted Mar 14, 2019 10:07 AM

    Here is the generalised approach :

       - Write a gel script to read the file. Flat files can be read easily with file:readFile . This reads the file line by line

       - Use the data to form your XML

       - XOG in that XML

     

    If you dont want to go this way and it is a one time load, then you can create XML Maps in Excel to convert your flat file XOG ready input XML.