Results 1 to 3 of 3

Thread: Moving data between modules

  1. #1
    Bobhardyoyo is offline Sugar Community Member
    Join Date
    Mar 2009
    Location
    UK
    Posts
    59

    Default Moving data between modules

    Hi

    I have a custom contact module, when I export from that module the email addresses do not get exported, I would like to move the data from the custom module into the standard Sugar contact module as when data is exported from there, email addresses are exported successfully.

    How can I move data between the two modules?

    Thanks
    Ed
    Version 5.5.1
    PHP 5.3.8
    MySQL 5.5
    IIS 6 Windows 2003 R2 SP2

  2. #2
    rafael.q.g@hotmail.com's Avatar
    rafael.q.g@hotmail.com is offline Sugar Community Member
    Join Date
    Jun 2011
    Location
    Florianópolis - Brazil
    Posts
    782

    Default Re: Moving data between modules

    The most accuracy approach is make that directly over your database data following these steps:
    1. Select data from your custom module
    2. Map teh fields between modules
    3. Insert the data selected on step 1 on sugar module.

    After select the data for your custom module, you could export it to a csv file. The sugar has an import routine that you can use to map and insert these fields into sugar module.
    Rafael Queiroz Gonçalves
    Advanced OMG UML Certified Professional
    Sun Certified Enterprise Architect for the Java Platform
    Sun Certified Programmer for the Java 2 Platform
    IBM Certified Advanced Application Developer - Lotus Notes and Domino
    IBM Certified Application Developer - IBM WebSphere Portlet Factory
    Computer Science Mastering / UFSC - PPGCC

  3. #3
    Bobhardyoyo is offline Sugar Community Member
    Join Date
    Mar 2009
    Location
    UK
    Posts
    59

    Default Re: Moving data between modules

    Hi

    Thanks for the response.

    I am not sure I understand what you mean in step 1? Select in the database or from within Sugar?

    If I import the data from a CSV file how can I then map the records to the email address fields (see below)

    Also, for some reason in Sugar the email addresses are stored in a separate table in the database, if I move the data from the custom module (in the database the table for this is called f1k_contacts) to the standard contacts module (just called contacts) will the mapping of the email addresses to the table email_addresses get moved as well?

    Thanks
    Ed
    Version 5.5.1
    PHP 5.3.8
    MySQL 5.5
    IIS 6 Windows 2003 R2 SP2

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Moving data between two identical modules
    By truptinijai in forum Help
    Replies: 10
    Last Post: 2010-11-18, 09:48 AM
  2. Moving from 4.5 to 5.x - data problems
    By jabhawk in forum Installation and Upgrade Help
    Replies: 5
    Last Post: 2009-10-05, 07:01 PM
  3. Moving on from the demo data
    By ccomley in forum Installation and Upgrade Help
    Replies: 5
    Last Post: 2008-12-26, 07:41 PM
  4. Moving Sugar CE data to new version on laptop?
    By nepper in forum Installation and Upgrade Help
    Replies: 3
    Last Post: 2008-12-22, 09:25 PM
  5. Act6!: moving data -> 90% success need more help
    By gbminnock1 in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2007-07-11, 03:47 AM

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
  •