Jump to content


Photo

Card ID mass delete?

cardid database delete card id

  • This topic is locked This topic is locked
1 reply to this topic

#1 jcharriez

jcharriez

    Member

  • Members
  • PipPip
  • 16 posts

Posted 31 August 2016 - 07:24 AM

I recently imported our student file to our database, but I mapped the CARD ID field incorrectly, now I've tried to correct these records by re-importing with the correct field, but some students (over 1000) are not in the import file (and I have no access to historical student lists) so they do not get updated. Is there a way to mass delete the CARD ID field from all students so that IF they are not present on the latest import file they would be left blank. I can do this individually, but with over 1000 student records this task may be too time consuming for us. Any advice is appreciated. Thanks!

 



#2 Mon

Mon

    Administrator

  • Admin
  • PipPipPip
  • 2,612 posts
  • Gender:Male
  • Location:Orlando, FL

Posted 31 October 2016 - 03:08 PM

Hello,

This is possible by running SQL queries on your SQL Server database.  Please contact our support department for help on this issue.


Mon Nasser
AccuTrack Manager
mon@accutrack.org
(888)249-7227
http://www.accutrack.org




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users