Import creating duplicate listview entries

[robertbmirth]

Hello,

I'm trying to do a mass import with a few records that need to get updated. I'm using the "Import and Update records" option, and I have all the correct IDs, etc. The import is working (mostly) as it should, its updating the records that need to be updated and its importing those that don't already exist, but a peculiar thing is happening. For the records that are being updated, they're showing up twice in my listview. The duplicates are the same record after you click through them, but in the list view one of them is missing an account name. Essentially my list view is showing more records than those that exist in the database. I've found a few old bugs dealing with duplicate team memberships, but that's not the case here.

Any ideas?

[robertbmirth]

Update: Well, I haven't found the solution, but I've found a little bit more information. The problem seems to be stemming from the accounts_contacts table in the sugarcrm database. When I do the import, this table gets filled with a lot of entries that have an "Inactive" entry for the account_id - these rows seem to directly correlate with the blank entries in the listview. When I delete these entries (on a dev instance, with a mysqldump of the database) the problem goes away for the most part (there seem to be a few that linger, but if I delete everything in the table, I get the right number). The problem is, I don't know what's creating these entries, and as I'm running the production in an OnDemand instance, I can't go in and delete these entries, nor would I feel comfortable solving the problem this way if I could.

[robertbmirth]

So I've currently found a way to get around this problem, but it doesn't seem like the best way. What I'm doing is creating a .csv with two account records, one with an ID of "Inactive" and one with an ID of "New" and importing those two records. This serves the purpose of "relating" the contacts to one of these two accounts. Once that relationship occurs, I can delete the two accounts and the entries in the database will be flagged as deleted. I can then do my import as normal and everything runs well, as far as I can tell. I'm just cautious of doing the import this way as I don't know what these entries do, or if having an account with a "reserved word" as an ID lying around in my database. Anyone able to calm my qualms?

[eitrix]

this sounds like a interesting dilema. Please post more if you get any further into the problem.

[robertbmirth]

As I solved (or think I solved) the problem with the delete, I'm putting the more theoretical questions in a new thread: http://www.sugarcrm.com/forums/showthread.php?t=65421