List Load Probelm - HELP

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

List Load Probelm - HELP

Postby PrimePro » Mon Feb 04, 2008 4:39 pm

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.
PrimePro
 
Posts: 44
Joined: Sun Dec 02, 2007 6:10 pm

Postby PrimePro » Mon Feb 04, 2008 6:22 pm

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
PrimePro
 
Posts: 44
Joined: Sun Dec 02, 2007 6:10 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 283 guests