topic Re: Importing a list of values to property in model/aspect from database in Alfresco Archive

Importing a list of values to property in model/aspect from database

tomekszy — Tue, 25 Oct 2016 12:19:46 GMT

I have a question, how it is possible to import a list of values to a property in aspect from a table in Oracle SQL Database? As you can see in attachment 1, I have filled list of values in property in aspect, just by copying it from my database manually. But, I want it to be automatic, and I wish A

Re: Importing a list of values to property in model/aspect from database

kaynezhang — Tue, 25 Oct 2016 13:13:33 GMT

Alfresco is a content repository which aim to store content.Although,alfresco allows to store metadata-only objects，I don't think it is a best practice,you will lose some performance than using db directly.

Alfresco do have a Bulk Import Tool which is used to import content from the file system into alfresco.

If you want to import database record into alfresco ,there is no such tool as you need ,you need to implement it your self.

Re: Importing a list of values to property in model/aspect from database

cesarista — Tue, 25 Oct 2016 14:45:35 GMT

Hi:

You can implement it yourself, but using it in model manager will be more difficult.

Custom Aspect Property reading Values from a database Field

How to get values from database and list them as properties?

Regards.

--C.

Re: Importing a list of values to property in model/aspect from database

openpj — Wed, 26 Oct 2016 08:06:55 GMT

I suggest you to implement your own batch/job procedure for importing all of your data needed to options or any other decoration pattern you need.

Consider to import/synchronize every night for example.

The imported data should be dropped inside a dedicated repository tree with a dedicated content model (with a dedicated prefix and namespace). In this way all the contents can be searched by using the Alfresco Search Service in the right way without any problem related to an external system.

Hope this helps.