Qdabra Database Accelerator

Re: RefID is capturing wrong library ID

Doreen — Wed, 05 Jun 2013 18:58:52 GMT

Ok then I misunderstood what the RefID references then. I thought the DBXL RefID was always a mirror of what the SharePoint library ID was. My mistake.

Thank you for explaining.

Re: RefID is capturing wrong library ID

ErnestoM — Wed, 05 Jun 2013 18:52:08 GMT

Sorry, I don't understand the scenario.

DocIDs increment for the entire installation of DBXL. So DocType1 can have Documents 1, 2, 3, and DocType2 can have Documents 4, 5, 6.

RefIDs increment for the specific DocType. This means DocType1 will have Documents with RefID 1, 2, 3 and DocType2 will also have Documents with RefID 1, 2, 3.

The SharePoint form library and mapping don't have any memory of the RefID or DocID; those are stored in each XML document.

So perhaps we need to look at the XML documents and their processing instructions (or the Documents tab in DAT) to see their DocID and RefID, and then compare those to what you're seeing in SQL and SharePoint. Perhaps this will tell us whether what you're seeing is expected or not.

RefID is capturing wrong library ID

Doreen — Wed, 05 Jun 2013 18:43:32 GMT

I moved an existing template/Document Type to a newSharePoint 2007 Library which I created through DAT tool. This caused all forms from the old library to show up in the new library. I have since deleted all those forms and created new ones. I am saving the library ID in the database (which isn't really necessary, but nonetheless I am) and it's still using the library id's from the old library.

How do I reassociate the DBXL RefID to the new library?