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

Parents
  • 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.

Reply
  • 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.

Children