Home » blog » alanr's blog

Is there any way to do a mass update of data in iMIS?

Posted November 11th, 2009 by alanr

Hi,

  I need if possible to do a mass update of all the email address for each of the employees of a company which is one of our contacts in iMIS. Given the ID of the company, I could easily get a list of the IDs of it's employees, but is there any way using the iMIS front end to do a mass update of the email addresses, which are fields of a Business Object? For example, does anyone know if this could be done by an IQA or by a Report of some kind?

 Thanks in advance for any help you can give.

alanr's blog | login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Updates through IQA to excel.

On November 12th, 2009 jhull-jurkovic says:

Writing to the database through an IQA or report is not really going to work, since both of these are read only tools.

  • However, one thing you might try is to run a query to get the ID's of those people who you wanbt to update (and possibly the old email addresses also), then export to excel.

Once in excel, add a few columns around the pasted query results to say something like:-

"Update Name set email = 'newemail'' where ID = 'ID''

Then  copy the SQL statement fields down around all the results - this would produce a SQL command line for each email adress that needs to be updated. It also gives you the flexibility to manipulate data in excel.

Copy and paste the whole thing into query analyser and run to do the updates. (Test with a single line from excel first...)

  • If you're using sql2005 or higher, if you open a table in SQL management studio, you can actually copy and paste from excel into table fields en masse.
  • I did submit an SMR some time ago requesting an enhancement to IQA, to be able to cherry pick the results and perform some basic write actions, like add an activity for example.

 

login or register to post comments

Mass updates

On November 12th, 2009 alanr says:

Thanks very much for your reply - that seems like a working solution and I'll probably use something based on it to clear this job.

Thanks again for your help,

alanr.

login or register to post comments