Hi,

I am not expert of MySQL and spent a lot of time trying to integrate data from RSform database to ARI Data Table, unfortunately, unsuccessfully.
Could you please help me with the SQL Querry?
I tried to import data from MySQL database, but the structure of RSForm tables is very confused and I don't know how to find there the necessary columns.

After, I tried to import data from joomla database. Here at least I can see all columns in submissions table, example:

DateSubmitted surname Name country E-mail membership_type ...

FormID=5

I studied the forum materials on this topic, but still cannot solve this problem.
The idea is, I want to make a membership table with all data of the members, and with possibility to filter by date, country, membership type... The table will have many columns, for this reason, I bought today you new ARI Data Table, as it has horizontal scrolling. My ARI Smart Content doesn't have this function.

Hello,

Read this post.

Regards,
ARI Soft

admin wrote:
Hello,

Read this post.

Regards,
ARI Soft

Id did in this way, but the table is strange
See it here please dzogchen.ro/reports

Could you specify what's wrong and what do you want to achieve? Could you also provide a temporary access to your J! backend by email so we can help to configure the module?

Regards,
ARI Soft

admin wrote:
Could you specify what's wrong and what do you want to achieve? Could you also provide a temporary access to your J! backend by email so we can help to configure the module?

Regards,
ARI Soft

I want to have in my ARI data table the same columns as in RSForm submissions table and the data in ARI table should correspond to the columns.
The number of fields per page should correspond to "Show ... entries". Now, if I specify 100, it shows just 25.
I will send you by email more details.

Set "Server side pagination" parameter to "No" because it doesn't work when "Graph transformation" is used. Server side pagination works with normalized data.

Regards,
ARI Soft