1
Older versions / BUG: Importing / Exporting Contacts / Companies
« on: August 29, 2009, 08:38:15 pm »
Dear Gooroos,
I'm afraid that not so many people have ever needed the import / Export function, right? Because it has a few serious issues.
1) export creates a csv file but doesn't enclose the text in Quotes. So the moment i have a comma in a record, all goes wrong.
2) Contacts are not related to companies, so after an export you are left with one list of companies and one list of contacts.
3) when uploading the same problem: there is no way of defining what company a contact belongs to.
4) upon importing a contact, opengoo apparently decides if a record exists and gets updated based on the email address. Not a bad idea. But it does so as well if the imported contact has no email address. Bad Idea! This means that if you import multiple contacts without an email address, only the last one is kept.
Here's a suggestion:
* when exporting, do add all company records to each contact. Even if this creates redundancies, it's the only usable format whereever you want to import it later on.
* Include the primary key number so I can re-import that dump later on without any hassles or ambiguities
* have an import function that will allow me to upload both company data and personal information in one go.
I'd like to import all of our old addresses. But that's about a few thousand if them.
I'm afraid that not so many people have ever needed the import / Export function, right? Because it has a few serious issues.
1) export creates a csv file but doesn't enclose the text in Quotes. So the moment i have a comma in a record, all goes wrong.
2) Contacts are not related to companies, so after an export you are left with one list of companies and one list of contacts.
3) when uploading the same problem: there is no way of defining what company a contact belongs to.
4) upon importing a contact, opengoo apparently decides if a record exists and gets updated based on the email address. Not a bad idea. But it does so as well if the imported contact has no email address. Bad Idea! This means that if you import multiple contacts without an email address, only the last one is kept.
Here's a suggestion:
* when exporting, do add all company records to each contact. Even if this creates redundancies, it's the only usable format whereever you want to import it later on.
* Include the primary key number so I can re-import that dump later on without any hassles or ambiguities
* have an import function that will allow me to upload both company data and personal information in one go.
I'd like to import all of our old addresses. But that's about a few thousand if them.