InfoPath Dev

Hi,

I like to include a link to my form in my db tables - I use that link in reports at a later date.=  I have been calculating this in the form.  But, I need to unload/reload all my document types to upgrade DBXL from 2.3 and need to ensure that the URL stored in the DB is accurate.

I have gone into DBXL and instead of shredding my calculated value to the database I have shredded the value of DBXL::Link. (Thanks to James for telling me about this option - I missed it before.)

I have re-shredded all my documents, and this seems to work most of the time but not all the time.

I have pulled the Link and the DocID(shredded from DBXL::DocID)  from the table in the database and I get some annomolies...

Documents/2555/d0a0c5d3-55be-4073-9510-d2b8f54dc9a9.xml	2555
Documents/2556/9c15ffaa-776b-4a09-b459-40bfc62e54ce.xml	2556
Documents/2537/0.xml    2537 Documents/2557/b3705614-5eda-4803-a8a7-771add740a67.xml	2557

In 400+ documents I have 6 which have 0.xml as the link... 22 where a GUID is being used.   The DocIDs are correct.  I have reshredded the documents several times to no avail.  What can I do to fix the DBXL::Link information to be correct ?

Thank you.

Catharine

 

The filename portion of the link is determined by the "name" value when the document was submitted.  If a name was not specific in SubmitDocument, the filename in the link will become the DocID.

And just so you know, the filename portion of the link can be anything at all and it will still successfully retrieve the file, so you could use:

Documents/2555/d0a0c5d3-55be-4073-9510-d2b8f54dc9a9.xml

Documents/2555/0.xml

Documents/2555/document.xml

and they should all work for retrieving the form with DocId 2555.