• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: RSForm table documentation

RSForm table documentation 10 years 5 months ago #29579

My second query to this forum, which is a request for documentation:

Is there any detailed documentation on the RSForm table structure? What I'm after is a description of the _rsform_* tables in the Joomla database. That is, what each table holds, and what relations there are amongst them. In particular, I need to find out which tables hold the submission data. A pointer to the requisite docs would be helpful.

I have been pointed to TFM but that doesn't hold the answer to my query. Please don't ask the reasons why I need this info - it's just too baroque and complicated to explain :(

Fred
www.fredriley.org.uk
The administrator has disabled public write access.

RSForm table documentation 10 years 5 months ago #29587

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
Submissions area saved into two database tables: rsform_submissions and rsform_submission_values. rsform_submissions stores global submission information data (like date / time, IP, form, language, etc.) and rsform_submission_values stores the actual submitted information (one row for each field).
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.
The following user(s) said Thank You: fredriley

RSForm table documentation 10 years 5 months ago #29595

Thanks for this. I eventually figured that those would be the submission tables, after looking through SQL dumps. I could still do with info on what the other tables are for, and how they're related. In one of my many installations, the tables are in the following small screenshot taken from MySQL Workbench:

imgur.com/hLN3D75

There is a reason for this forensic examination of the table structure, but it's just too long and tedious to explain here :(

Fred
www.fredriley.org.uk
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!