cancel
Showing results for 
Search instead for 
Did you mean: 

Import and Transform

joksy
Champ in-the-making
Champ in-the-making
Hi Gusy,

I have to face with this problem, I have my custom type in Alfresco, say A. and A have some property (b,c) and some association(d,e) define on it.
I have also an excel file which inside have a list of potentially A'type in my system. Is there any routine or system to parse the content of the excel file and transform it to object in Alfresco? I will to try using directly the JCR API for create my A content, sound good for you or someone will know a better strategy.

Many thanks guys Smiley Happy
2 REPLIES 2

kbonnet
Champ in-the-making
Champ in-the-making
Isn't it an option for you to store the Excel file as XML in Alfresco? You're able to access the XML with E4X from a content rule.

joksy
Champ in-the-making
Champ in-the-making
Isn't it an option for you to store the Excel file as XML in Alfresco? You're able to access the XML with E4X from a content rule.
Hi thanks for the reply unfortunately not, because the information in the excell file are 1-to-1 with one of my custom content in alfresco, but no problem i remember some script for accesssing the JCR and write the content of course i hope to remember well.

So anyway could be interesting build as a simple inmporter plug in Smiley Happy
cheers