Page 1 of 1

List Load Probelm - HELP

PostPosted: Mon Feb 04, 2008 4:39 pm
by PrimePro
I screwed up. I know the fix is probably pretty simple. I'm just not sure it's simple enough for me. :oops:

I loaded a list and mapped the last name in the both the first name and last name fields. So now agents are seeing the last name in both fields on the agent screen.

Normally I would just delete the list and reload it mapped correctly. Probelm is that this was not brought to my attention until after several sales were made, call backs scheduled and 43 DNC requests generated.

Question: How can I fix this naming problem without losing the call status information on the records?

Please keep in mind I'm a little slow.

PostPosted: Mon Feb 04, 2008 6:22 pm
by PrimePro
Fixed.

Used a really backwards way. Export list from MySQL. Sort Column. Copy phone numbers from records I did not want to reload. Added them to the phone number column in the orginal csv list. Sorted that list to easily spot duplicate numbers. Remove the records that had a duplicate number.

Wow, I really need to take a break one of these days and learn MySQL. LOL