topic Re: How to Creat Custom Table and accessing it in Alfresco Archive

How to Creat Custom Table and accessing it

koteswar — Tue, 15 May 2007 15:57:30 GMT

Hi , I need to create new table and i have to store some custom data into table , How we can Create and how we can access it ?DB is HSQL only Please let me know ASAP

Re: How to Creat Custom Table and accessing it

hbf — Thu, 06 Dec 2007 18:35:16 GMT

I need something similar. To integrate Alfresco with our caching architecture, I need an additional table within Alfresco, managed by my Alfresco Module Package which will catch node update events and alter the table within the current transaction. (I need highest performance here and therefore don't want to use Alfresco's content model.)

Is there an example around that shows how to add another table, probably using Hibernate?

Thanks,
Kaspar

Re: How to Creat Custom Table and accessing it

snig — Thu, 05 Jun 2008 18:54:52 GMT

Hi Guys

Did you find any solution for this?
My requirement is the same, and struggling to find out any clue…

Please share…

Thanks in advance.
Snig.

Re: How to Creat Custom Table and accessing it

snig — Fri, 13 Jun 2008 16:22:24 GMT

Any news on this guys…?
I am really in a road-block in this issue…

Re: How to Creat Custom Table and accessing it

hbf — Fri, 13 Jun 2008 16:50:57 GMT

If you know French (or use Google translate), take a look at this reply on the French forum: http://forums.alfresco.com/fr/viewtopic.php?f=11&t=1329&p=6086

I'd say trying to add your custom tables is the wrong approach as you need to know a lot about Alfesco's inner workings.

Re: How to Creat Custom Table and accessing it

hansraj — Sat, 18 Oct 2008 11:56:19 GMT

Hi,

could anybody please answer for how to create custom table?

Regards,
Hansraj

Re: How to Creat Custom Table and accessing it

mrogers — Sat, 18 Oct 2008 16:28:13 GMT

I quite agree with what 'hbf' has said above that this is probably the wrong approach to use with Alfresco.

But if you do need to create a database table and access it from a JSP. It's easy to do and is the type of thing they cover on the first day of a Java programming course. You can either use jdbc directly or a tool like hibernate. But of course you are not using Alfresco and are in probably in the wrong forum.

Re: How to Creat Custom Table and accessing it

asurjit — Sat, 18 Oct 2008 19:01:10 GMT

Folks,

As part of the content deployment, we can deploy files on file system quite easily using Alfresco but if I want to send Alfresco content records to database then we are unable to find any way. Our requirement is quite simple at the moment where we want to populate the content in our portal database so that portal can fetch the records at run time and render them on website.

I would like to know if Alfresco content deployment system supports content deployment to custom tables on the portal database?

Any quick feedback is appreciated.

Regards
-Amar

Re: How to Creat Custom Table and accessing it

asurjit — Sun, 19 Oct 2008 22:22:41 GMT

Folks,

We are looking on couple of features on Alfresco and

deployment to database and customizing web forms are key requirement for our client while making selection for Alfresco. These features are critical factors while making a decision on the product.

Would like to know the next steps if we need to get the confirmation on this feature set? If these are already available then instructions to implement them and if they are not available then roadmap for the same?

Regards
-Amar

Re: How to Creat Custom Table and accessing it

mabayona — Mon, 20 Oct 2008 11:56:36 GMT

If you need to store some information from Alfresco into a table (a database?) the WRONG approach it to try to add tables to Alfresco DB.

Possible CORRECT approaches are:

- Use web services
- Use web scripts

in both cases, the approach is to design the table/database (external to alfresco) to contain the information you are looking for and to extract the information to populate them using one of the above mentioned methods.

Another option is to extend Alfresco content model with your custom data model, however, it seems that what you need is just a mechanism to extract information from Alfresco as the ones expresed above.

Re: How to Creat Custom Table and accessing it

asurjit — Mon, 20 Oct 2008 13:57:07 GMT

Thanks for your reply.

Web Services or Web Scripts

I am not very clear how you are going to use your web scripts or web services to populate this content. Where will you invoke any of this service? How will you tie your file system deployment with web services to populate the content in transactional mode?

Will be good if we have any documented steps to use Web Services or Web Scripts to populate Alfresco content in portal database.

This is integral feature of a content deployment module for a content management system and detailed steps on wiki will be appreciated.

Thanks
-Amar

Re: How to Creat Custom Table and accessing it

mabayona — Mon, 20 Oct 2008 14:10:32 GMT

You can trigger the update either from inside Alfresco or from outside. My recommendation is to use Javascript/web scripts and to activate the triggers (e.g. custom behavior or custom actions) to do the update.

The Development guide is full of info about how to do it.

Anyway, you should provide a little bit more background of your use case for us to be able to give you better advice (we are not mind readers! )

Re: How to Creat Custom Table and accessing it

asurjit — Mon, 20 Oct 2008 14:29:17 GMT

Okay here comes the use case details

We have news articles in our web site and no of news articles are huge in number and appearing on different places on the site. For eg latest three news article on home page, latest 3 articles from each news category on news hub page and then list of news articles on news article page itself.

There are two ways to achieve this, One is to generate all the pages on addition of new news article in WCM or you capture the article details in the CMS and then populate article details on the portal database so that portal can fetch the information at run time.

In this scenario, we want to publish Article Title, id, date, body, summary fields in the database so that portal can display them at run time by fetching the values from news_article table.

Every article has pdf document also attached which we can deploy using File system deployment but to update the database is not working.

You mentioned lots of places in development guide this information is given but we tried to find this information and we are unable to find it anywhere.

I hope you do not need to read my mind any further and should have more detailed reply on this.

Thanks,
-Amar

Re: How to Creat Custom Table and accessing it

mabayona — Mon, 20 Oct 2008 17:48:34 GMT

"I hope you do not need to read my mind any further and should have more detailed reply on this."

Amar, please do not forget that this is a public forum and that we are not obliged to answer your questions. I would recommend you to be nicer if you want an answer.

Short. If the number of news articles is HUGE and the refresh frequency is BIG then you should go directly to a WCM-based solution.

Re: How to Creat Custom Table and accessing it

asurjit — Mon, 20 Oct 2008 17:56:04 GMT

I did not write this with hard words..it was just a funny reply..probably I forgot to put smily in rush

I do appreciate your help for sure mate..

"Short. If the number of news articles is HUGE and the refresh frequency is BIG then you should go directly to a WCM-based solution."

When you say WCM based solution..will be great if you can detail it out a bit. Do you mean to access the WCM content repository using web scripts here?

This can have definitely performance issues and apart from this our key concern is, we are definitely missing an important piece of functionality in Alfresco which put me in doubt while suggesting to use Alfresco for their implementations.

Would like to confirm if this is definitely not possible using Alfresco in the current state?

cheers,
-Amar

Re: How to Creat Custom Table and accessing it

mabayona — Mon, 20 Oct 2008 18:20:07 GMT

Basically, if you got mostly web content (e.g. stored as XML) then WCM. There you can use either java or javascript depending of your skill and performance requirements. Also you can define custom workflows to fine tune the content lifecycle.

Re: How to Creat Custom Table and accessing it

asurjit — Mon, 20 Oct 2008 18:27:41 GMT

I am not sure how do I perform this using JavaScript but only option can be to write a custom workflow using jbpm and one of the task in that will be to get the content from xml files and write them to the custom tables. This can be a workable option but this would require lots of custom coding and apart from this it will not provide transactional behaviour for the content deployment.

This is definitely a hard way to go with Alfresco!

Re: How to Creat Custom Table and accessing it

mabayona — Mon, 20 Oct 2008 18:45:15 GMT

If all you need is to extract data to a table/database, the easiest most scalable solution is to write webscripts inside Alfresco that extract the data and to call them from your external application that populates the table/database.

Look for web scripts info in the Development Guide.

Re: How to Creat Custom Table and accessing it

anupnepal — Tue, 30 Dec 2014 02:38:01 GMT

Hello

I have created a new workflow regarding payment in alfresco community edition using SDK

But in that work flow I need to display the Currency data and Department data in dropdown box

I have created a new page for currency and have also made an webscript api for it.

My problem is that I need a place to store the information, i read your discussion and found that creating new table is bad approach so can you please point me towards right direction

Thankyou

Re: How to Creat Custom Table and accessing it

anupnepal — Sun, 04 Jan 2015 12:40:02 GMT

Hello,

Well i managed to save the data in the Node. I created a custom model, with files currencyModel.xml and currency-model-context.xml. And managed to save the data in the Node by creating and new Interface CurrencyService.java and its implemented class CurrencyServiceImpl.java and saved the data in the format of the currencyModel.xml, i called the service from the API i created for Currency.

Thank You