topic Document ID Question in Alfresco Archive

Document ID Question

unknown-user — Thu, 16 Apr 2009 23:41:17 GMT

If I wrote a third party component, say in .NET to associate the faxed document with an invoice in my invoice system, what database value would I use for a DocumentID? What table would I access? If all new faxes came in with a custom index value = NEW and I matched the barcode value with a value in

Re: Document ID Question

unknown-user — Sun, 19 Apr 2009 18:56:52 GMT

Not much help around here. I guess we will be going to P8. Oh Well.
I tried evaluating Open Source but the support is not there.

Re: Document ID Question

mrogers — Sun, 19 Apr 2009 21:45:27 GMT

If you are using the public forums you need to be a little more patient.    There's an element of luck whether someone will read your post and respond to it.

If you want faster support then one option is to pay for an Enterpise subscription.   Then you can have 24X7 support with a guaranteed response time.

To answer your question.   You don't access the database tables directly and should not take that approach.   Alfresco is a "black box" and you shouldn't get involved in the internals.

There's lots of options.

Each node has a unique id that can serve as a key.    You can also store "properties" for each node so you could generate your own key to link your systems.   You would probably want to store properties such as the invoice number and you could then search via invoice number.

You can retireve content either through the nodeid or searching for properties.

You could also model some sort of parent/child relationship with the faxes being children of an invoice document.