• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 154 views
  • Users 0 members are here
Related

NSCAN offline data file upload

David Geoffrey Hall
$organization

Hello,

Has anyone imported the offline scan data from an NScan device into the T_NSCAN_OFFLINE_STAGE table? If so, how did you go about it? I've got the XML file off the device, and can save as a CSV or TXT file... any tips getting it in to the SQL table?

Cheers,

David Geoffrey Hall

Parents
  • $organization

    Hi David,

    I've done this before. In SSMS if you right click on impresario > tasks > import then the import wizard will open and you can follow the steps there. I've always had better luck saving this as a text file otherwise Excel is likely to manipulate the data as you import it from the xml file. When I first did it I think I made a copy of t_nscan_offline_stage that I imported the data into so I could truncate said table if anything went wrong, and then I inserted the rows from the copy into the actual table.

    Thanks,
    Will

Reply
  • $organization

    Hi David,

    I've done this before. In SSMS if you right click on impresario > tasks > import then the import wizard will open and you can follow the steps there. I've always had better luck saving this as a text file otherwise Excel is likely to manipulate the data as you import it from the xml file. When I first did it I think I made a copy of t_nscan_offline_stage that I imported the data into so I could truncate said table if anything went wrong, and then I inserted the rows from the copy into the actual table.

    Thanks,
    Will

Children