topic Re: have filename, want binaray in Alfresco Archive

have filename, want binaray

mrksjs — Thu, 09 Aug 2012 10:16:11 GMT

sorry, i know there are many, but i found no matching subboard for this. due to a not working backup procedure i have missing nodes, however i have the complete contentstore and a database dump.if i have the filename and path from the repository/webdav directory how can i find the corresponding bina

Re: have filename, want binaray

afaust — Thu, 09 Aug 2012 10:22:21 GMT

Hello,

you need to get the properties from alf_node_properties for the node_id that matches the child from alf_child_assoc that matched your qname_localname. One of the properties will contain an entry in the string_value column, that looks like a URL. That URL is your relative path from the content store root to the binary that belongs to the node.

Regards
Axel

Re: have filename, want binaray

mrksjs — Thu, 09 Aug 2012 11:00:52 GMT

i found some entries in alf_node_properties that match the child_node_id of the entry i'm looking for, but they contain no url to the content store. just the filename again and the path in the repository.

just a guess: might not be the database schema you have in mind?

Re: have filename, want binaray

afaust — Fri, 10 Aug 2012 20:07:35 GMT

Hello,

hmm, can you please post an example path that you found in alf_node_properties? The content URL was contained in that table in previous Alfresco versions (up to and including the 3.1.x series), so I would be quite surprised if it could not be found in there…

Regards
Axel

Re: have filename, want binaray

sam63 — Fri, 24 Jan 2014 10:55:24 GMT

Well, you can use long path tool also, it works good for such issues.

Re: have filename, want binaray

lissacoffey — Sat, 11 Jun 2016 11:05:59 GMT

One of the properties will contain an entry in the string_value column, that looks like a URL<a href="http://qwikfix.co.uk/sky-customer-services/" rel="bookmark">.</a>