Ideas for Implementation

• • Reply

  14 years ago

  by materialised

  Mick Walker

  Northern Ireland, United Kingdom

  Joined 14 years ago

  Hi Everyone,
  I have been given a task from work, and am wondering if anyone here could provide me with some ideas for the implementation of this project.
  

  Basically, I have been given the task of catologing our website keywords. We are a major player in the travel industry, and could have anywhere upto 100,000+ keywords at any one time. We use google adsense to manage our keywords (for google only) and from the web based interface, I can download keyword groups as a csv file. I want to write a program, which can load a csv file and insert all keywords into a MS SQL database table. This in itself is simple enough, but over our different marketing campagins, some key words may be repeated. So upon the loading of subsequent csv files, I only wish to add new enteries to the database table. (i.e enteries that do no exist in any other marketing campagin)

  I am not an experienced database programmer, and I am not sure of any way to do this, apart from loop through the whole database table checking if a single keyword already exists, so if anyone has any other suggestions on how I can do this efficiently, I would be more than grateful.

  Regards

  Report abuse
• • Reply

  14 years ago

  by jmcilhinney

  John McIlhinney

  Sydney, Australia

  Joined 15 years ago
  If you specify that your keyword column is unique and then perfrom a batch update using a DataAdapter, the default behaviour is for the update to fail if a value is inserted that already exists.  If you set the ContinueUpdateOnError property of your DataAdapter to True then rows containing existing values will simply be ignored and all the new values will be inserted successfully, assuming there are no other errors of course.  This means that you can simply insert everything without regard for whether it exists already or not.
  
  
  Report abuse