• Registered: 02/03/2011
  • Posts: 3

Topic: Extract certain data from Joomla MySql database

Situation:
Joomla website with the RSform Pro installed.

Purpose:
Companies can become customer or member of the website and receive quote requests from individuals.
So, the companies are our customers and the individuals are the products we sell.
We collect their name, addresses and so on from forms created with RSForm Pro.

Question:
It would be very handy, if these data could be imported in Front Accounting.
Is there a way, that we can connect Front Accounting to the Joomla (MySQL)Database and collect the data mentioned
above ?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Extract certain data from Joomla MySql database

Yes, you will have to create a module (see elsewhere how to do this) that handles these operations. If you write such a module, please share it with us.

/Joe

  • Registered: 02/03/2011
  • Posts: 3

Re: Extract certain data from Joomla MySql database

Oké, i'll take a look. If i'm able to create something, i will of course share it here.

  • rodw
  • Senior Member
  • Offline
  • From: Australia
  • Registered: 03/01/2010
  • Posts: 115

Re: Extract certain data from Joomla MySql database

Mesjoggah, can you expand on what you to achieve?

I am keen on this as well and hope to eventually have full integration between a Joomla Virtuemart store. Replicating users from Joomla to FA would be part of this process so I might be able to assist in some way.

[b]RodW[/b]
Brisbane, QLD, Australia
  • Registered: 02/03/2011
  • Posts: 3

Re: Extract certain data from Joomla MySql database

This is what i would like to have:

Someone enters his name, address, email and so on,  in a form.
When he presses the submit button, the data will be pushed into the Front Accounting database and become visible in the customer section.
I choose front accounting, because of the MySql database it uses, which Joomla also uses.
So, if you (or anybody else) can give any input, ideas or kicks in the right direction, it will be more than welcome.

Mesjoggah