InfoPath Dev

In case someone else runs into this...

I have been unable to edit the properties of certain InfoPath files in Datasheet view. The fix is to avoid using commas when passing a value to the tns:name parameter when submitting documents to DBXL.

Here's what I did that causes an error:

1. Setup a form with two fields: FormName and Field1
2. FormName will default to a value with a comma (e.g. "Form,Name")
3. Setup the DBXL submit data connection to have the tns:name parameter point to FormName
4. Either promote Field1 as editable or, later, add a field to the InfoPath Library
5. Have DBXL map the form to a SharePoint library
6. Submit a new form
7. Go to datasheet view
8. Attempt to edit the Promoted field or the Added field
9. An error will appear "An unexpected error has occurred. Changes to your data cannot be saved"

Did some troubleshooting:

1. Add the Title (link to DBXL document) field to a view
2. Go to the Datasheet view with the Title Field
3. Right-click the Title link field and select Hyperlink - Edit Hyperlink
4. Remove any commas
5. Switch to Standard View to save the change
6. Switch back to Datasheet view
7. Attempt to edit the promoted field or the added field
8. Error should be gone.

When looking closer at how Hyperlink fields are stored in SharePoint, there seems to be a comma and space that separates the title of the link from the URL. No doubt having a comma in the tns:name parameter for DBXL caused an issue.

This is probably a low priority request, but can Qdabra put in a bug fix to remove commas when updating the name parameter in the DbxlDocumentServiceEx.asmx web service and other like web services.

Actually, the correct course of action is for the Datasheet view to correctly interpret the data. It seems that double commas are used to escape the comma. In the Edit.aspx page it looks fine, but the Datasheet view doesn't escape the comma.

Where would I report such a bug?