InfoPath Dev

Hey JappieJ! OK, the reason is that the data types aren't roundtripped with list forms. The InfoPath list forms save the data to a table on SharePoint. That table is stored in SQL so the data types must be converted to SQL and then roundtripped. So, you are seeing this problem. If you use an InfoPath Form Library, it will save the data as XML ...

Both work for me. I took an XML file I had created and added the utf-8 encoding and saved (via notepad). Then, I double clicked and it opened fine. I did file->saveAs and called it fileB.xml. I examined this in notepad and the utf-8 encoding marker had roundtripped. Next, I added the encoding="ISO-8859-1" and did the same - no ...

Hi Ben, I'm guessing that you designed the form in IP2007. There was a weird bug where if you designed the form in IP2007 you couldn't get the view to display in IP2003 email. Try to create a new form from scratch in IP2003 Designer and enable the email connector. If that sends the view, you will have to compare the manifest.xsf (in the ...

Hi Zhen, You can't easily copy repeating nodes from one area to another unless you use code (or qRules). Since you are already a DBXL customer, we'll give you a copy of qRules. The CopyTable command won't work without qRules. We could send you code in place of qRules, but qrules is a better value since you won't have to maintain ...

Hi Loma2, My guess is that IPFS doesn't allow for this at runtime. Why not just crate a secondary data source and concat the values together in a repeating node there. Then you can just use a plain dropdown to display the values. To create the concatenated values, you will need some way of repeating through the items. You could use code to do ...

I'm in Japan until Jan 12th. Mel is in the Philippines. I have asked her to investigate a technique that would not require code and prepare a sample for you. Copying repeating section from SDS usually requires code, but there might be an way to do it if the main data source comes with default rows already inserted (but conditionally ...

Hi again, Are you using a SharePoint List Form or an InfoPath Form Library form? The former will likely convert the values to SQL data types on submit since the SharePoint List Forms do not store XML. The latter, however, should roundtrip the XML data types correctly.

Hi Zhen Yuan, I'm going to reply since it's still Sunday in the US where Jim is. If you are querying the values from your DB they will show up in your secondary data source as strings. The secondary data source schema won't have the msoImage attributes on it that InfoPath needs to treat it as an image and that's why Jim suggests ...

You can set a value using xpath filtering on the row but the row has to exist. In addition the filtering can be tricky and doesn't work in all cases. A simpler solution (which would also simplify your previous challenge) would be just to use qRules. qRules comes with a SubmitToSharePointList command as well as Insert and SetValue ...

Hi again, Can you look at the following document and let us know if you have questions: http://www.infopathdev.com/files/folders/miscellaneous/entry42096.aspx Thanks!