TOPIC:

Integrator Insert Quick HOW-TO 12 years 5 months ago #5301

  • Topic Author
  • TheMuffinMan
  • Visitor
  • Visitor
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

Please Log in or Create an account to join the conversation.

Last edit: Post by TheMuffinMan.

Re:Integrator Insert Quick HOW-TO 11 years 7 months ago #11847

  • welcomewagon
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 1
  • Thanks: 1
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.
The following user(s) said Thank You: wartime

Please Log in or Create an account to join the conversation.

Re:Integrator Insert Quick HOW-TO 11 years 1 month ago #15749

  • aj5r1gg
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 8
  • Thanks: 1
Does the integrator work across databases? That is, will it insert data into a second Joomla database on the same server?

Regards,
Andrew
The following user(s) said Thank You: wartime

Please Log in or Create an account to join the conversation.

Last edit: Post by aj5r1gg.

Re:Integrator Insert Quick HOW-TO 9 years 7 months ago #68498

  • loviss
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 4
  • Thanks: 1
Video for the integrator including database updates is coming soon!
The following user(s) said Thank You: wartime

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: ForumSupport
Time to create page: 0.048 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!