Author Topic: BUG: Importing / Exporting Contacts / Companies  (Read 1758 times)

max

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
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.

alvarotm01

  • Administrator
  • Sr. Member
  • *****
  • Posts: 335
    • View Profile
    • Email
Re: BUG: Importing / Exporting Contacts / Companies
« Reply #1 on: August 31, 2009, 12:43:41 PM »
Hi,
Points 1) and 4) are fixed.
Also added "company field" when importing and exporting contacts.
When importing, if this field is checked, the matched value will be serarched in the companies table looking for a company with that name.
If there is one, the contact is linked to it, if not then the company is created with this name and taking information from the contact's work fields.

This will be available in next release.

regards
« Last Edit: August 31, 2009, 12:47:41 PM by alvarotm01 »

max

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
Re: BUG: Importing / Exporting Contacts / Companies
« Reply #2 on: September 02, 2009, 05:11:53 AM »
Great! I guell I'll wait with the long list, then.
thank you veru much!

AnotherUser

  • Newbie
  • *
  • Posts: 9
    • View Profile
Re: BUG: Importing / Exporting Contacts / Companies
« Reply #3 on: September 10, 2009, 08:58:55 PM »
Also, when I am importing a CSV file with 3200 contacts, the loading screen is on for a bit then it is gone, no notifications or alerts.

Prior to doing this, I ran "top" to see if apache2 and mysql are still active after the loading graphic goes away; the processes are still active. Is there a 15 second timeout or something? I think this would confuse people, like it did to me before I started to monitor it, who think that the import process has failed and, like I did, start pressing buttons within opengoo only to find that nothing works and they they have to log out :)

 

anything