InfoPath Dev

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

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

• Video demo of this
• How to configure DB mappings
• Shredding without a key
  
• Blog entry on repeating tables

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.

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

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.

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

Hi:

 Here is the Infopath form data source.

Hi:

Here is the DB Mapping screenshot.

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.

Hi,

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

Reena