nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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)

Find more posts tagged with

Comments

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>