06-05-2014, 09:54 AM
In principle you are correct but here is the deal:
1 - If I use my original database, that wont work because some contacts name were updated due to spelling errors. If I use that then I will end up with some records not being updated properly.
2 - Let's say I export the current production database so that all the names correspond when I import it back. That should work except that when I export the current database corebos seems to disagree with special characteres in some names and adds garbage instead. I am guessing utf-8 is the reason. Also, since the last name is the only mandatory field I can use I am forced to do some editing on the names.
It's not as easy as you described and one way or another I need to edit manually some contacts so that everything imports/updates properly at the end.
Anyways, seems I am seeing the end of the tunnel here. I've done moreless what you suggested while also having to edit a certain amount of name so that they can be properly identified with the production database.
EDIT: Can I actually use the ID colum as identifier and leave the whole last name colum blank?
1 - If I use my original database, that wont work because some contacts name were updated due to spelling errors. If I use that then I will end up with some records not being updated properly.
2 - Let's say I export the current production database so that all the names correspond when I import it back. That should work except that when I export the current database corebos seems to disagree with special characteres in some names and adds garbage instead. I am guessing utf-8 is the reason. Also, since the last name is the only mandatory field I can use I am forced to do some editing on the names.
It's not as easy as you described and one way or another I need to edit manually some contacts so that everything imports/updates properly at the end.
Anyways, seems I am seeing the end of the tunnel here. I've done moreless what you suggested while also having to edit a certain amount of name so that they can be properly identified with the production database.
EDIT: Can I actually use the ID colum as identifier and leave the whole last name colum blank?