Since RSform!Pro 1.4.0 (Revision 40) the formerly known - RSform!Pro Mappings plugin - has been included in the component functionality by default and comes with new features and functionality.
The RSform!Pro Mapping feature can be accessed from within the Components > RSForm!Pro > Manage Forms > edit a form > Properties: Extras area.
Mapping configuration
1. Connect to the database you wish to map the data to
Clicking on the New button on the Mappings area will display a configuration window that will allow you to set the connection type and the method that should be used:
- Local: A local connection type implies that the table that the data will be mapped to will be inside your current Joomla! database (runs on the same database as your RSform!Pro installation).
- Remote: The remote connection type implies that the destination database table is located on a different database (different server or outside the Joomla! databse). Choosing the Remote type will need some additional configuration details: Host (connection URL), Username, Password, Database (name).
2. Mapping type
The mapping process can perform one of the following three MySQL actions: Insert, Update, Delete. So, for example, if a Insert method is used a new table row (record) will be created.
3. Table selection
After the connection type and mapping method, you should click the Connect to database button. If the connection is successful a Database table drop-down selector should be displayed (otherwise an unsuccessful connection message). This will allow you to select the destination database table (the list is automatically populated with the database tables).
4. Field mapping
Selecting a table will display a list of all columns that can be mapped for that table. This step simply implies telling the mapping tool, what RSform!Pro field should go into what column.
Clicking inside a table field will display a list of your available RSform!Pro field placeholders. One should take caution when performing the field mapping as field types are an important factor. For example, if the database column requires a numeric input, then the RSform!Pro field should only contain numeric values.
Using the RSform!Pro Mapping feature you can set multiple mapping actions with various actions (insert, update or delete), to various tables (local or remote).
As a side note, a new special placeholder has been introduced: {last_insert_id}. This returns the automatic id number generated by the most recent INSERT query.
Video tutorial:
Ep. 67: How to transform a RSform!Pro submission into a Joomla! article
Please make sure you know what you are doing when using the mappings tool. Although Mappings is a powerful tool since it helps you integrate RSform!Pro with other applications, if not configured properly, it will write data to tables and may affect the other applications(or Joomla!). We cannot be held responsible for any incorrect usage of the Mapping functionality.
