Results 1 to 1 of 1

Thread: Problem importing activities (calls) with dates and linking to contact_id

  1. #1
    nutri is offline Member
    Join Date
    Aug 2009
    Posts
    13

    Default Problem importing activities (calls) with dates and linking to contact_id

    Hello,

    I'm doing importing test from our old CRM and having some new problems with the importing of activities, like Calls:
    1.The exported format is in DDMMAA hh:mm, I config that in the importing process but it fails, I also tried MMDDAA hh:mm and also fails. It uses the default vale instead my data.
    2.I have exported and imported in Sugar previously Leads, Accounts and Contacts so I liked them and recover the id for contacts and Accounts so I can relate the activities with the Accounts+Contacts directly through the SugarCRM ids. But... in the importing process, one field in the DB (that I recovered from SugarCRM for the exporting process) is "contact_id" but when I import the data only seams that the account_id has been used so I see, after the importation, that the colum name of the contact is empty.

    After reviewing the DB tables I realize something so I think there's some problem in the importing problem:
    -When you insert a call from lead an entry in calls, calls_leads and calls_users tables are inserted.
    -When you insert a call from contact and entry in calls, calls_contacts and calls_users tables are inserted.
    -When you insert a call from account and entry in calls and calls_users tables are inserted.

    So: when you import calls when parent id is a valid account_id, parent type is account and contact_id is used, the entry in calls_contacts seams to be not inserted (I could trace the import process but I would thank help before doing this).

    Reviewing this I think I've discovered another error in the deleting process of activities -probably I'm wrong- the calls_users entries I've being deleting are deleted from calls tables but not from this other table, so the table is full of deleted calls. I think it's an error as there's a column colled deleted and the value is not set to 1, so I suppose the not deleting is not for later trace/audit or recovery processes.

    The version I'm using is 5.2.0h with the Spanish language module.

    I've found this reported bug, labeled as "corrected" and refering to 5.2.0.patch (what patch is this????):
    http://www.sugarcrm.com/crm/support/...3-4a842e8a3a97

    I understand from that bug note that is corrected but not published the patch already?

    Thanks in advance,
    Nutri A.
    Last edited by nutri; 2009-09-01 at 04:08 PM. Reason: related bug detection confirmation, no patch??

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing Activities and Linking them to Leads
    By darcy.rippon in forum Help
    Replies: 0
    Last Post: 2009-03-19, 08:30 PM
  2. Better linking of activities between accounts/contacts/ops
    By dpuryear in forum Feature Requests
    Replies: 0
    Last Post: 2008-08-21, 03:16 PM
  3. Replies: 4
    Last Post: 2008-05-30, 08:30 AM
  4. Replies: 10
    Last Post: 2006-10-27, 07:22 PM
  5. Linking a new module to Activities
    By Lwis in forum Developer Help
    Replies: 3
    Last Post: 2006-07-07, 05:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •