have filename, want binaray

[mrksjs]

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 binary file? how does my sql query need to look like?

i have found the filename in alf_child_assoc.qname_localname, how do i get further?




version is v3.1.0 (142)

[afaust]

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

[mrksjs]

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?

[afaust]

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

[sam63]

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

[lissacoffey]

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>