Export function - Bring2mind - Bring2mind Forums

Bring2mind Forums

Prev Go to previous topic

Go to next topic

Last Post 08/07/2006 3:00 PM by Peter Milliner

Export function

8 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Matthias Kühnle

New Member
Posts:9

07/25/2006 10:45 AM
Is it possible to export a list of files out of a collection and copy it to a local folder on my client PC?

Peter Donker

Veteran Member
Posts:4536

Matthias Kühnle

New Member
Posts:9

08/02/2006 10:59 AM
This is a feature our documentation department was asking for. Actually, they want to burn cd's from a document-template list (i.e. all subscribed documents of a user). Is this a feature you can imagine on your "wishes list"?

Peter Donker

Veteran Member
Posts:4536

08/02/2006 11:56 AM
I can imagine this on my wish list, yes. It would be for DMX 4.

Peter Milliner

New Member
Posts:40

08/07/2006 5:29 AM
I am looking for something similar. I was requested to have a ready made CD with all documents loaded for Business Continuity (disaster recovery). I am working on workaround that involves advanced datagrid http://www.efficionconsulting.com . I thought it might be of interest. First attempt is fairly crude but I will be refining soon. While this does no have the same structure as DMX, it gives me a quick easy way burning a cd that has all documents and titles listed in alphabetical order. The SELECT statement listed below gives me table I can export to excel. I then convert to HTML and copy docs from server and burn CD. Select statement below.... SELECT Description, 'open document' from DMX_Entries WHERE EntryType <> 'Collection' AND Version = 1 ORDER by Description Regards Peter

Peter Milliner

New Member
Posts:40

08/07/2006 5:33 AM
Posted By milliner on 08/07/2006 05:29:08 I am looking for something similar. I was requested to have a ready made CD with all documents loaded for Business Continuity (disaster recovery). I am working on workaround that involves advanced datagrid http://www.efficionconsulting.com . I thought it might be of interest. First attempt is fairly crude but I will be refining soon. While this does no have the same structure as DMX, it gives me a quick easy way burning a cd that has all documents and titles listed in alphabetical order. The SELECT statement listed below gives me table I can export to excel. I then convert to HTML and copy docs from server and burn CD. Select statement below.... SELECT Description, 'open document' from DMX_Entries WHERE EntryType <> 'Collection' AND Version = 1 ORDER by Description Regards Peter --------- Sorry select statement is SELECT Description, 'open document' from DMX_Entries WHERE EntryType <> 'Collection' AND Version = 1 ORDER by Description

Peter Milliner

New Member
Posts:40

08/07/2006 5:41 AM
I will get it right eventually where it says 'open document' should be ......href=file\\\'+Entry+'>open document...... with the html tags of course

Peter Donker

Veteran Member
Posts:4536

08/07/2006 10:42 AM
The SELECT clause: Select 'Entry' to get the current filename, 'Description' for the title, and 'OriginalFilename' for ... you guessed. To tune the WHERE-clause: If you do 'Version=1' you get all first versions of documents. If you want the last versions you need to do 'EntryId=LastVersionId'. If you want to avoid having deleted items add 'Deleted=0'. EntryTypes should not be 'Collection.' or 'Hyperlink.'. Peter

Peter Milliner

New Member
Posts:40

You are not authorized to post a reply.