FrontAccounting forum — Extract certain data from Joomla MySql database

Re: Extract certain data from Joomla MySql database

2011-02-08T20:35:50Z

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

Re: Extract certain data from Joomla MySql database

2011-02-08T12:18:26Z

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.

Re: Extract certain data from Joomla MySql database

2011-02-03T15:04:56Z

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

Re: Extract certain data from Joomla MySql database

2011-02-03T13:50:54Z

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

Extract certain data from Joomla MySql database

2011-02-03T12:03:34Z

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 ?