The integrator (since 1.5.9 build 700) is a nice way to store the data of your forms into any database table of your joomla installation (mostly tables beginning with jos_).


The concept behind it is quite simple:

- If you just want to insert new data you choose the form, the database table where to store to and the fields to copy (guess newsletter subscriptions).

- If you need to update existing entries, you will need the information above + some sort of criteria that indicates where to save what and when (guess community builder personal info updates).


But let's start simple (insert):


1. In the Integrator screen click "New" in the upper right.

2. Choose a name, select the "SampleContactForm" and as target table "jos_users" and as "type" leave "insert".

3. Hit "save" in the upper right.

4. Now a second table appears: "Data Integration"

5. As _incoming_ element choose "cf_name (Text)" and as _outgoing_ element choose "name (varchar)".

6. Click "add".

7. Then as next choose "cf_email (Text)" and as _outgoing_ element choose "email (varchar)".

8. Click "add".

9. In each of these data integrations you see a link "Code", click on the code for the item "cf_name"!

10. In the appearing box enter this: $value = strtoupper($value);

11. Hit "save" below the codebox. What you have just done is to uppercase the incoming name on a form save/data copy

12. Now open the SampleContactForm itself, enter some data and submit.

13. Now go open phpMyAdmin and browse to the "jos_users" table and you will see the new entry.


Ok it is not complete but I think you get the point. Please delete that entry now!


For updates it is a little bit more difficult but you can play around with it, but make sure you don't test it on livesystems!


Video for the integrator including database updates is coming soon!


Regards,
Markus

I love the integrator. I was able to do in 15 minutes what another developer took all day to do.

However, I am getting stuck on one issue.

The logic that I want to execute is UPDATE data in another table if the company record already exists. However, if it doesn’t exist in the table, than I want it to INSERT.

I've gotten the UPDATE to work, however, I cannot see how to add IF statements to the INSERT option to avoid creating duplicate entries.

Can you please help to steer me in the right direction?

Thank you very much.

Does the integrator work across databases? That is, will it insert data into a second Joomla database on the same server?

Regards,
Andrew

Video for the integrator including database updates is coming soon!