Just following up on my part of the above thread. I was able to import my data, but it was super complicated because of the structure for values (each value in a "submission", (aka record) has its own row). I had to run about 40 or 50 different GREP search/replace operations on the file to clean it up, add the correct series of submission IDs, and format it with SQL insert code.

We need a plugin to allow for this import process, please! Client's are asking for it.

If the Submissions view page...

Hmm.. this issue get even worse if you use custom fields. I managed to get all my user accounts migrated into memberships by writing queries (Which is stupid)

But then couldn't work out why the custom fields i had defined for a membership type were not showing up. Seems the custom field data is attached to the first transaction record. Which don't get created if you manually write the users. and if you tray and add the dat amanually - you cant. (WHY would you attach data about a memberships...

It would be really nice if the results of a scan could be exported as a report in some kind of document format, listing the good, the bad, and the ugly.

I purchased an unlimited domain 12 month license as an investment in my client sites security. I would like to be able to email them scan reports so that they know that their sites are secure, and as importantly, that I am providing the service of monitoring that security for them.

The report format doesn't have to be anything fancy or...

I'm searching for the same answer.

Since the form submissions data resides in the #_rsform_submission_values table and each value is an individual record, it strikes me that preparing the SQL insert file would involve quite a lot of formatting — breaking each value into it's own line on your insert statement and adding the Formid value to link them to the same form.

Time consuming as that may be, that strikes me as one way to do it.

Any other ideas?

azurelink wrote:
Alright, at the time I wrote that, I didn't have any values in my test submisisons form. Now I see they are in the _values table. But the strange thing is each value is in it's own row, instead of in a single record of all values for a single submitter. This makes importing records from an existing database file more difficult.

How do you recommend importing data? Use the Excel method you mentioned above? Is there another tool I could use?

Hi Wilco,
What database table do RSForm Pro submissions reside in? I see the following tables:

jnoc5_rsform_submissions
jnoc5_rsform_submission_columns
jnoc5_rsform_submission_values

But the columns don't match my form fields.

Thanks

I use ACESEF but i like migrate to RSseo
i have 1500 url (titles, metas, descriptions, urls redirect....)

is posible migrate this data to RSseo?

thanks

Does anybody know how to import mysql table data into RSForms!Pro submissions list.
I am new to RSFormsPro and have an sql table I wish to include in the submission list.

Looking for a suggestion to resolve an issue with the Google Sync offered by RSEvents. We have events going back to 2007, so while trying to import 9 years of data the server (GoDaddy) bails as there is simply too much data. Obvious options are to grab the calendar ICS file, BUT RSEvents only allows CSV importing. The other is to specify a date range to import, but the sync in RSEvents is rather dumb and doesn't allow you to filter events by date or any other value.

If you have managed to sync a busy Goolge Cal how did you do it?

Thank you

Is there someone willing to help me to let me know what the PHP syntax is to add RSFormPro field-values to a VAR?

This because I like to create a file that will contain some (not all) data from the form in a specific (other than in the form) order. That file will be a import file for a different app.

A tip or hint will help me a lot! Thank your very much.

Hello

If you are reffering at formatting the text when an user enters a value in a specific field than you can achieve this through CSS. Go to 'backend > Components > RSForm!Pro > Manage Forms > select your form > Properties > CSS&Javascript >' and enter this declaration for your field ID: text-transform:capitalize!important;

If you also want to save the entered value into the database with capital letters then you will need to create a custom PHP script in "Script called on form process" and...

Is there any way to automatically export the results of a form to, say, an Outlook or DPCalendar application? I am currently making a vacation request form on a Joomla website and would like to have a way to allow for a manager to approve the request and then automatically populate a calendar; whether it be Outlook or DP Calendar (installed in same Joomla site). As the data is stored in a database, I would assume there is a way to auto-export it to something like DP Calendar.

Has something like...

Also in the settings.xml add the last option:

to support...

Hey guys I'm stuck with my form joomla article. It seems that the problem is that data is not rewritten in to the articles joomla
I suppose it can not rewrite data com content bd?

Though the following video tutorial is out of date, it might provide useful tips but only explain how to create them and not update them. tutorialrsform

Ido not have many resources in PHP and MySQL. anyone has any solution.


It is extremely important that my users can change the data.

Can you help me?

My website uses SobiPro version 1.0.8. When I try to import data I receive an error that it is incompatible. What do you suggest? Is there a way to import data using MySQL?

www.planetearthfiber.com