How are fields mapped during import ? RAD- file.import.new

Hi,

We have a scripts which use the RAD file.import.new with Names: record and Values: $L.sch and in Pre RAD statements it has below lines defined:

$L.v=rtecall("rinit", $L.rci, $L.sch, "schedule")

name in $L.sch="Import - GSDNA";application in $L.sch="file.import.new"

strings in $L.sch={"/v/campus/servicecentermacfeed_na.dat", "GSDNAimport", "GSDNAimport"}

This script is used by a scheduler which runs on daily basis. 

Can someone tell me how and where are the fields mapped that imports data from the .dat file and adds to the GSDNAimport table.

Basically which table is used to map fields during scheduled import.

Currently i am getting error as: Unrecoverable error in application:  file.import.new on panel select.import

 

Thanks & Regards,

Ayushi Jain

  • 0  

    Hi  Ayushi

    Would you please to upload the dat file and unload of the table GSDNAimport with dbdict?

    Thanks 

  • 0 in reply to   

    Hi Simon, 

    Thanks for your reply. I am unable to find an option to attach. Can you tell me where to attach. 

    Meanwhile I have shared snapshot of table and below is the one sample from dat file.

    17436||D9GFPOD 1|POD 1|2Z27|2Z27 - NA - MANASSAS EDC|0||GF|D9|United States of America|NA|AMER IT ONLY|VIRGINIA|||||Technology|IT CLEARING TIER 2|Technology|IT CLEARING TIER 2|Data Center Comms Room||

    Basically, where can I find the import descriptor that is scheduled for importing data.

    Thanks.

  • 0   in reply to 

    Hi  Ayushi

    You can run db > search table: import

    click on "next" button to find out your import description

    There is no qbe list for this table.

    Thanks

  • 0 in reply to   

    Simon, I searched the import table earlier , but there is no import descriptor.

    So i am not getting how the data is getting synced in the table on daily basis.

    If you see my first post i have given few details. There is a scheduler running daily which calls a script and that script has the .dat file location. But where is the mapping done ?

    I am trying the same functionality in different env. But i am getting the error: Unrecoverable error in application:  file.import.new on panel select.import

  • 0 in reply to   

    Hi Simon/ any experts,

    Can someone help me on my below query pls. I am still getting this error: Unrecoverable error in application:  file.import.new on panel select.import

    thanks.

  • Suggested Answer

    0   in reply to 

    Hi Ayushi, when you said you have already search on import table and found no import descriptor.,did you scroll through the whole table and found no records or no records that looks like GSDN ? The import table cannot be empty. Out-of-the-box, there should be some import record like assignment.

    You can use the webclient to search thru the import table. The web client does have qbe and can display more records on the screen.

    As can be seen in the parametert used by file.import.new, the first 3 parameters is been feed by your script and should exists.

    Best Regards,

    Jason

    Although I am an OpenText employee, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button