Qdabra Database Accelerator

Re: DBXL::Link doesn't seem to be working consistently...

Jimmy — Tue, 14 Jun 2011 05:47:44 GMT

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.

Re: DBXL::Link doesn't seem to be working consistently...

Jim Cantwell — Mon, 13 Jun 2011 15:55:20 GMT

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.

DBXL::Link doesn't seem to be working consistently...

Catharine — Mon, 13 Jun 2011 15:34:46 GMT

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