3 Replies Latest reply on Jan 31, 2013 3:00 AM by beyerch2

    Integration script for Mapping

      Is it possible to write an integration script which could connect to an excel file and get its source and target mapping values ?
        • 1. Re: Integration script for Mapping
          I'm 99.9% positive I could do this. The question would be why?
          1 person found this helpful
          • 2. Re: Integration script for Mapping
            Apparently my client seems to put so much effort in getting these mappings, that he is not ready to put that extra effort of converting it into FDM map loader format.
            So he wants me to pick up his file and get the mapping.

            Appreciate any pointers on this.

            • 3. Re: Integration script for Mapping
              I just use a simple excel formula to create a ledgerlink format file when people give me big excel files they need put into FDM.

              P.S. While I"m not going to write up entirely what you need, I'll give you some help. If you look at this thread : https://forums.oracle.com/forums/thread.jspa?threadID=2291710 I posted a script that creates a true Excel file. You can use a lot of that code to work in the opposite direction enabling you to read cells from the excel file. This will solve one of your problems, though you still need to work out how to update the map with this info.

              P.S.2 - It should be noted that Microsoft *DOES NOT* officially support Office Automation on production servers due to performance/reliability. I personally haven't had issue in the past; however, keep this in mind.


              Edited by: beyerch2 on Jan 30, 2013 6:59 PM