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

[tomekszy]

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 Alfresco to read from my database and put data in that field by itself. How can I do that? And is it possible, that Alfresco will do that import for example every hour? If it is not possible to do that directly from database, is it possible to do that otherwise? From file for example? Maybe I need to write some application, that will took data from database, put it into XML file formatted as Alfresco model, and send it to Data Dictionary/Model directory? Or maybe there is some add-on to Alfresco, which will do that? Please show me the right direction to do that.

[kaynezhang]

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.

[cesarista]

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.

[openpj]

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.