Hi Deborah!
I don't know anything about Equella's DB schema, I'm afraid, but I just
wanted to chip in to say that if it were me, I'd be looking to see if the
data I needed was available via Equella's OAI-PMH service. Apologies if
you've already tried that!
Conal
On Mon, 28 Sep 2020 at 07:43, Fitchett, Deborah <
[log in to unmask]> wrote:
> Kia ora,
>
> On the off-chance anyone's familiar with (Open)Equella (it's essentially
> abandonware so the ex-vendor's no help, I get error messages when looking
> for the community Google Group, and the only documentation I can find
> helpfully has a page linked from the text "Why does the openEQUELLA schema
> make no sense?"<
> https://openequella.github.io/tutorials/reporting/SchemaDesign.html>
> which is at least reassuring that it's not just me!)
>
> I need to migrate out of Equella into another system. I've created a
> report in the SQL database to extract the metadata for the items I need -
> but I also need their files, so I want the filepath on the server.
>
> The files are named with the attachment name (which I have), inside a
> directory named with the item id (which I have), inside another directory
> named with a pseudo-random number - ranging from about 0 to about 160, from
> memory. I'm hoping this number is stored somewhere in the SQL database -
> but I haven't been able to find *where*. Help?
>
> (I do have other directions I could approach this from but nothing's
> obviously *easy* and I'm not sure of the capacity of the people who
> actually have server access, so, just, argh. Migrations.)
>
> Deborah
>
> ________________________________
>
> "The contents of this e-mail (including any attachments) may be
> confidential and/or subject to copyright. Any unauthorised use,
> distribution, or copying of the contents is expressly prohibited. If you
> have received this e-mail in error, please advise the sender by return
> e-mail or telephone and then delete this e-mail together with all
> attachments from your system."
>
--
Conal Tuohy
http://conaltuohy.com/
@conal_tuohy
+61-466-324297
|