topic Re: bookmarks in a shared file on server in QlikView

bookmarks in a shared file on server

Thu, 19 Nov 2015 11:16:44 GMT

Hi,

We have created a new version of a qlikview document and copied the old shared file to the new file and renamed it. The bookmark names are appearing in the bookmark list but it is not applying the same selections that it applies in the older version. Both documents have same data model and has only couple of layout related changes in the new version

Can someone please tell me what are the things that could cause a bookmark to not work. I would imaging that a field name change or if the value in the field changes which the bookmark is trying to select, then it will not wrok

However, in my case, both document have the same fields and the filter that it is trying to apply also exists in the new version but the bookmark is still not working

Also, I want to copy a couple of customers bookmarks to my user so that I could test them using my user. I have tried to open the shared file using powertool. However, I dont know how to copy someone else's bookmark to my name. Can someone please guide me how to do that

Regards

Re: bookmarks in a shared file on server

Peter_Cammaert — Thu, 19 Nov 2015 12:40:20 GMT

The Shared File Viewer Power tool can export anyone's shared/not shared bookmarks to XML. In the XML representation, you can check what particular Bookmark properties don't fit your new document anymore.

To copy server bookmarks, let the creator share them and import them to your AP session through the repository. You can only exchange bookmarks this way within the same document.

For Document and User bookmarks, there is an Import/Export facility in QV Desktop. But I don't think such a feature exists for Server bookmarks.

Peter

Re: bookmarks in a shared file on server

Fri, 20 Nov 2015 07:41:26 GMT

When I try to export the bookmarks to an xml, it gives me the below information but I cannot find any property that I could check in the document to compare if anything has changed

<SharedFile FileName="\\storageserver1\qvdocs\UserDocuments\Cust_sales.QVW.Shared">
  <DocumentContent Owner="Custhosting\user1">
    <Length>7</Length>
    <Offset>422400</Offset>
    <Sheets />
    <Reports />
    <Bookmarks />
  </DocumentContent>
  <DocumentContent Owner="user1">
    <Length>51</Length>
    <Offset>3072</Offset>
    <Sheets />
    <Reports />
    <Bookmarks>
      <String>Server\BM08</String>
      <String>Server\BM28-147</String>
      <String>Server\BM29-147</String>
    </Bookmarks>
  </DocumentContent>
  <MetaData Id="BM08" Owner="user1">
    <Length>18</Length>
    <Offset>8704</Offset>
    <Shared>false</Shared>
    <UtcModifyTime>double[41170.2773148148, 18.9.2012 6:39:20]</UtcModifyTime>
    <SheetId />
    <Temporary>false</Temporary>
    <RestrictedAccess>false</RestrictedAccess>
    <AccessList />
    <PersonalEditionHash_OBSOLETE />
  </MetaData>
  <MetaData Id="BM28-147" Owner="user1">
    <Length>20</Length>
    <Offset>417280</Offset>
    <Shared>false</Shared>
    <UtcModifyTime>double[42013.3687962963, 9.1.2015 8:51:04]</UtcModifyTime>
    <SheetId />
    <Temporary>false</Temporary>
    <RestrictedAccess>false</RestrictedAccess>
    <AccessList />
    <PersonalEditionHash_OBSOLETE />
    <Hidden>false</Hidden>
    <LinkedTo />
  </MetaData>
  <MetaData Id="BM29-147" Owner="user1">
    <Length>20</Length>
    <Offset>421888</Offset>
    <Shared>false</Shared>
    <UtcModifyTime>double[42013.3709259259, 9.1.2015 8:54:08]</UtcModifyTime>
    <SheetId />
    <Temporary>false</Temporary>
    <RestrictedAccess>false</RestrictedAccess>
    <AccessList />
    <PersonalEditionHash_OBSOLETE />
    <Hidden>false</Hidden>
    <LinkedTo />
  </MetaData>
</SharedFile>

Can you please guide me how to use this xml to see what properties do not fit in the new document

Re: bookmarks in a shared file on server

Peter_Cammaert — Fri, 20 Nov 2015 08:45:52 GMT

There are two types of information you can export for every shared object: object definition and object metadata. You exported the metadata (in addition to some general document info) which is pretty much useless for what you intend to do. Export the object definition and check again.

Re: bookmarks in a shared file on server

Fri, 20 Nov 2015 09:08:49 GMT

I only can see these options. I cannot see object definitions. I tried to export the Dcoumentcontent but it also does not have any info. it only has the tag part that was also given above


<DocumentContent Owner="Custhosting\user1"> 
    <Length>7</Length> 
    <Offset>422400</Offset> 
    <Sheets /> 
    <Reports /> 
    <Bookmarks /> 
  </DocumentContent>

Re: bookmarks in a shared file on server

Peter_Cammaert — Fri, 20 Nov 2015 09:19:57 GMT

If you filter by User, you won't see any object definitions listed because they have no user information. User information is stored in the metadata. Disable your filters and try again. Bookmarks will end up at the top of your 700-item list anyway.

Re: bookmarks in a shared file on server

Fri, 20 Nov 2015 09:40:12 GMT

excellent, this worked. Now I have a question. Suppose a bookmark has stored five different selections for different fields. If support two of the selections are such that the selected values no longer exists in the document but the three other selections are still valid, will it still apply those other three valid selections or does it break the whole bookmark if any of the selection is not longer valid?

Regards

Re: bookmarks in a shared file on server

Peter_Cammaert — Fri, 20 Nov 2015 10:40:43 GMT

No idea. But you can easily test a situation like that:

Create a document with an INLINE table with two fields. Add easily discernible values to these fields. Reload
Create a bookmark with a selection in each field. Store the document
Change the INLINE table to omit one of these two values. Reload.
Clear all selections and select the original bookmark.

Best,

Peter