This discussion is archived
3 Replies Latest reply: Jan 23, 2013 7:00 AM by JeffJon RSS

Import script out put as text

ravi.chalich Newbie
Currently Being Moderated
Hi All,

I want to import the data from the SQL tables into fdqm.If i write a integartion script it was loading directly into table.But my requirement was i want to write a script which will generate a text file in inbox folder.

I tried the script in befimport event it worked perfectly but when i add this script as the import script the file was not generating.

Please help me on this.

Thanks in advance.
Ravi.
  • 1. Re: Import script out put as text
    JeffJon Guru
    Currently Being Moderated
    You will need to create a process that generates the data to a .txt file prior to import and then create an import format to parse the source file.
    Or you can use a Integration script that pulls the data directly from the source table into the FDM Work Tables.
  • 2. Re: Import script out put as text
    ravi.chalich Newbie
    Currently Being Moderated
    Hi,

    Can we create a process that when user clicks on import which will create a .txt file and loads into FDM by using an import formate ?
    If we can create can you please let me know how we can achieve that.

    Thanks,
    Ravi.
  • 3. Re: Import script out put as text
    JeffJon Guru
    Currently Being Moderated
    There is not an out of the box method to do this. It may be possible with customizaztions, however I don't really see a way of doing this. You will most likely need to extract the data from the Database Table first and place the file in the inbox and then write your import format to parse the file and have users select the file from the inbox.

    Or if you are looking for a lights out process place the file in open batch and then use the batch loader to process the files.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points