How to access values from form

[mat1010]

Hi,

could you provide an example on how to access the values of a forms input fields with this module?
When I submit my form with the postProcessor WebVision\WvFormDbInsert\Form\PostProcessor\DbInsert the values in the database are always the names of the for field since it seems the fields can't be proplery accessed. Here's a rough example of my form:

postProcessor {
    1 = mail
    1 {
        [...]
    }
    2 = WebVision\WvFormDbInsert\Form\PostProcessor\DbInsert
    2 {
        tableName = fooBar
        columns {
                        pid = 42
                        field1 = firstName
                        field2 = surName
        }
    }
}
10 = FIELDSET
10 {
    10 = TEXTLINE
    10 {
        type = text
        name = firstName
        label {
            value = Firstname
        }
    }
    20 = TEXTLINE
    20 {
        type = text
        name = surName
        placeholder = Surname
        label {
            value = Surname
        }
    }
}
[...]
30 = SUBMIT
30 {
    type = submit
    class = button
    name = 11
    value = Submit
}

Content of my typo3conf/ext/wv_form_db_insert/Configuration/TCA/fooBar.php:

<?php
if (!defined ('TYPO3_MODE')) {
        die ('Access denied.');
}

$GLOBALS['TCA']['fooBar'] = array(
        'ctrl' => array(
                'label' => '',
                'hideTable' => 0,
        ),
        'columns' => array(
                'uid' => array(
                        'label' => '',
                        'config' => array(
                                'type' => 'input',
                                'default' => 0,
                                'eval' => 'int,required'
                        )
                ),
                'pid' => array(
                        'label' => '',
                        'config' => array(
                                'type' => 'input',
                                'default' => 0,
                                'eval' => 'int,required'
                        )
                ),
               'field1' => array(
                        'label' => '',
                        'config' => array(
                                'type' => 'input',
                        )
                ),
                'field2' => array(
                        'label' => '',
                        'config' => array(
                                'type' => 'input',
                        )
                ),
);
?>

Content in database - instead of field values only the field names are inserted:

mysql> SELECT * FROM `fooBar`;
+-----+-----+------------+---------------+
| uid | pid | field1 | field2|
+-----+-----+------------+---------------+
|   1 |  42 | firstName       | surName | 
|   2 |  42 | firstName       | surName |
|   3 |  42 | firstName       | surName |
+-----+-----+------------+---------------+

Thanks in advance

[DanielSiepmann]

Our documentation is not that huge at the moment. I can't promise to change that in the near future.

You don't have to configure the fields. Only fields with fixed values like pid or hidden.

All other fields have to be named like the column. So if your form has a field field1 and field2 their values will be inserted into the column.

By providing the configuration

field1 = firstName
field2 = surName

you're telling the extension to insert this values into the columns.

Best would be to change the column names to firstName and surName to match naming full names already used in your form.

We have tried to reduce the overhead as much as possible. That's why you can't configure this.

Hopefully that will help you. If not, just answer or contact me via https://typo3.slack.com/messages/@danielsiepmann/

[DanielSiepmann]

The issue is that you are using FIELDSET around the fields.
That's currently not supported.

I'll try to add this asap.

[DanielSiepmann]

@mat1010 can you check whether it works with the fix?
You need to checkout the corresponding branch.

If so, I'll release a new version.