Qdabra Database Accelerator

Re: Infopath 2007 Form Repeating table save to SQL

Reena Patel — Thu, 05 Nov 2009 19:36:02 GMT

Hi,

I changed the node path of the Infopath form to Vaccines. This resolved the issue. Thank you very much for your help.

Reena

Re: Infopath 2007 Form Repeating table save to SQL

ErnestoM — Thu, 05 Nov 2009 18:22:21 GMT

Under Table Name for Vaccine, you'll need to select the node path for my:Vaccine (not my:Vacinnes). The reason is that my:Vaccines is not a repeating node, whereas my:Vaccine is.

More information can be found in this blog entry.

Please let us know if this solves the issue.

Thanks.

Re: Infopath 2007 Form Repeating table save to SQL

Reena Patel — Thu, 05 Nov 2009 18:04:49 GMT

Hi:

Here is the DB Mapping screenshot.

Re: Infopath 2007 Form Repeating table save to SQL

Reena Patel — Thu, 05 Nov 2009 18:03:55 GMT

Hi:

Here is the Infopath form data source.

Re: Infopath 2007 Form Repeating table save to SQL

ErnestoM — Thu, 05 Nov 2009 17:28:31 GMT

To attach a file, click Reply (not Quick Reply) and then go to the Options tab.

Re: Infopath 2007 Form Repeating table save to SQL

ErnestoM — Wed, 04 Nov 2009 18:42:29 GMT

Hi Reena,

I'll be glad to help. Can you include the screenshots I indicated above? Can you check Event Viewer to see if it holds any clues?

Thanks.

Re: Infopath 2007 Form Repeating table save to SQL

Reena Patel — Wed, 04 Nov 2009 18:36:42 GMT

Thanks for the response.

I manage to correct the database configuration to store the data from the repeating table to the SQL table. But, it works only if I submit one row in the repeating table. It does not work if I do multiple rows in repeating table.

Can you help with that?

Thanks

Re: Infopath 2007 Form Repeating table save to SQL

ErnestoM — Wed, 04 Nov 2009 18:14:01 GMT

I'm not sure what you've attempted so far, so let me recommend some links to start off:

Please let me know if any of these links help.

If you continue experiencing issues, please include a screenshot of the form's data source and a screenshot of the Database mapping tab in DAT. Also check the Event Viewer on the machine where DBXL is installed, since shredding errors are logged there. These will help us identify any issues.

Thank you.

Infopath 2007 Form Repeating table save to SQL

Reena Patel — Wed, 04 Nov 2009 17:18:55 GMT

Hi:

I have a form created in Infopath 2007. The form has various fields and then a repeating table. I configured the form in DBXL Admin tool to save the form data to SQL Server database. I split the form in 2 steps:

Form fields - Saved fine in SQL Server db

Form fields + Repeating table - does not save the data in any of the database tables. The repeating table fields are mapped to second table in database. Both the tables have a primary key foreign key relationship between them.

Please help.

Thanks