Import and Transform

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-20-2009 10:37 AM
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
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

Labels:
- Labels:
-
Archive
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2009 04:49 AM
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-24-2009 12:12 PM
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

cheers
