I imported the wrong address

[SugarTyler]

I imported about 50 leads with the wrong address. I now have a CSV file with the correct address and I wanted to re import the leads by associating the leads to the "ID" field It didn't work because it said that the ID already exsisted. Is it possible to reimport to mass update information or do I need to fix this manually?

-tyler
xp
Version 4.5.0f (Build 1202)
Webserver ?
PHP ?
MySQL ?

[sbantz]

If they are just leads and your users haven't done anything with them yet, why not delete them all and reimport your new file? You could do an update query directly on the database, but you'd need the ODBC driver and some patience. There is no way to update existing records with another import. I guess your other option is not not match the ID (to avoid skipping) and just import the fixed records, later merging them with the existing ones. That's a pain, though.

[SugarTyler]

I should have mentioned that these records have already had many calls and meetings associated to them.

I got the problem fixed by accessing the database directly. I had to ask my tech to help, alright the tech did it and I stood behind and watched. but its fixed now. We just queried the leads and Manually made the changes to the address. I went alot faster than doing one at a time from within sugar. I was lucky that I only made this mistake with 50 leads, there is no way we would have fixed it if it was a higher count. What could I have done if there were much more than 50?

[sbantz]

I should have mentioned that these records have already had many calls and meetings associated to them.

I got the problem fixed by accessing the database directly. I had to ask my tech to help, alright the tech did it and I stood behind and watched. but its fixed now. We just queried the leads and Manually made the changes to the address. I went alot faster than doing one at a time from within sugar. I was lucky that I only made this mistake with 50 leads, there is no way we would have fixed it if it was a higher count. What could I have done if there were much more than 50?

If you were in a pinch with a lot more records, you could use MS Access, the mySQL ODBC driver, and an update query to change this info. When I migrated from MS Sharepoint to Sugar, I had forgotten the website field in the import. There were a few thousand accounts. I used an update query to match on account name and then fill in the website address from the second "correct" export csv file from Sharepoint.

If you EVER mess with update queries, TEST TEST TEST. One wrong move and your users could end up without a system. That's precisely why I have a test sugar server in addition to production.