Moving data from one field to another in BMC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is anyone familiar with moving all data form one field to another field? For
example, when importing 9000 contacts, I accidentally mapped "job title" to
"title" (which turns out to be Mr., Mrs., etc.). Now I need to move all the
data in the "title" field to the "job title" field, but with 9000 contacts I
simply don't have the time to do them one by one. Does anyone have any
suggestions? Thank you.

Chris
 
If you haven't yet done anything with your imported data - ie there is no
related history yet - it may be simpler to delete all of your imported
records, and re-import, making the appropriate correction to the mapping.

Otherwise it would be technically possible to do such bulk updates in SQL
Management Studio (or similar), but you would need some programming
knowledge, and preferable a copy of the database schema, which I haven't yet
been able to find. Another thing I'm not sure of is whether having bulk
changed your fields "behind the scenes" whether they would synch (if this is
appropriate to you).

In either case, do a full backup first in case anything goes wrong.

Kevin
 
If you haven't yet done anything with your imported data - ie there is no
related history yet - it may be simpler to delete all of your imported
records, and re-import, making the appropriate correction to the mapping.

Otherwise it would be technically possible to do such bulk updates in SQL
Management Studio (or similar), but you would need some programming
knowledge, and preferable a copy of the database schema, which I haven't yet
been able to find. Another thing I'm not sure of is whether having bulk
changed your fields "behind the scenes" whether they would synch (if this is
appropriate to you).

In either case, do a full backup first in case anything goes wrong.

Kevin
Click to expand...

A couple tips.

In the past I've used tools to generate schemas from a database. I
believe Visio has something like that, and Visual Studio might too.

As far as synching goes, BCM uses the ModifiedOn field to figure out
if a record has been changed (i.e. needs synching). So if you update
that field when you change a record, the records should get synced.
 
Back
Top