Moving data between two identical modules

[truptinijai]

Hi all,

I have cloned the opportunities module in version 5.2a and renamed the new one as opportunities1 .
How do I simply move an entire record in opportunities to opportunities1.
Ideally would need to do this with a button click.(The duplicate button in view page clones the record within the module itself).

Regards,
Trupti Nijai

[sanjaykatiyar1]

If opportunities1 module is clone of opportunities then you can export the record as csv file from opportunities and import into opportunities1.

[truptinijai]

Hi Sanjay,

Thanks for ur reply.
But I need a button click solution, instead of a lengthy solution.
is that possible???

Thanks & regards,
Trupti Nijai

[knoop]

Hi!

Did you found a solution for this?
I've got two the same modules, I also got a custom button on both edit views. I need a code to move my record with the help of that button...

[robertbmirth]

well, there are two things you can do. If you wanted this to happen for every record, i.e. automatically, then you can write logic hooks to synchronize the two tables (note that you'd have to add an extra field in each module to keep a record of what record the current record is synchronized to). If you only wanted to do it for specific records, or at specific times, I haven't done this but you can get a pretty good idea by looking at the leads' convertlead functionality. You can add custom functionality to a button and create a special view to go to when that button is pressed. The button is added in the viewdefs file (editviewdefs.php, detailviewdefs.php; whichever view you feel it applicable to add to. You can see this being done in the following code which is pulled from modules/lLeads/metadata/detailviewdefs.php:

 $viewdefs['Leads']['DetailView'] = array (
    'templateMeta' => array (
        'form' => array (
            'buttons' => array (
                ...
                array (
                    'customCode' => '<input title="{$MOD.LBL_CONVERTLEAD_TITLE}" accessKey="{$MOD.LBL_CONVERTLEAD_BUTTON_KEY}" type="button" class="button" onClick="document.location=\'index.php?module=Leads&action=ConvertLead&record={$fields.id.value}\'" name="convert" value="{$MOD.LBL_CONVERTLEAD}">'
                ), 
  

If you look at modules/Leads/views/view.convertlead.php you can see where this button references.

Note that there's probably going to be a little more to this process than I've uncovered. There are some labels there that need to be defined and I'm guessing you might have to fiddle with the controller as well. Also, remember to put all your modifications in the custom directory so that you stay upgrade safe.

[AlexAv]

Does module works correct? I mean new records , relations ... etc.

[knoop]

Both modules are working fine.
I don't want to move records automatically. When I hit the button 'Convert', I want to move a record from the original Accounts module to my custom accounts module.

In the original module I've got all potential customers. In the new module I convert these records to Customers.

The only question is... what do I have to put behind the button?

[AlexAv]

You can do it with database query.

[knoop]

Thanks for you suggestion. They only problem is that I need some more information. I'm not yet an expert in php and MySQL. So if you've got some more information in detail it would be appreciated

[AlexAv]

Simple example you can find there