topic split an excel file into nodes in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/split-an-excel-file-into-nodes/m-p/279348#M232478 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I've already posted here </SPAN><A href="http://forums.alfresco.com/forum/end-user-discussions/alfresco-share/xls-multi-pdf-03202014-0844" rel="nofollow noopener noreferrer">http://forums.alfresco.com/forum/end-user-discussions/alfresco-share/xls-multi-pdf-03202014-0844</A><SPAN> but maybe this place is more appropriated.</SPAN><BR /><BR /><SPAN>I have a .xlsx file that I use as a database. Each line contains information for 1 document: Name, date, and some custom datas. I don't want to upload the documents; I however want to add the datas to Alfresco so I can use the search function.</SPAN><BR /><BR /><SPAN>I was considering creating 1 .pdf or .doc for each document containing the datas and then uploading them to Alfresco so people could search, download, and print them.</SPAN><BR /><SPAN>I have however been told to create a type that contains the metadata I'm interested in. Then add an action that splits the xlsx file into multiple nodes of the type.</SPAN><BR /><BR /><SPAN>Unfortunately, I'm not sure how to split the xlsx with an action…</SPAN><BR /><SPAN>Also, do you know if there is a way to create pdf from a node that would contain only metadatas?</SPAN><BR /><SPAN>Last, do you know if there is a way to have a form allowing people to add nodes from this particular type? A form that would be used in order to add metadatas to the "empty" nodes newly created, when they are created, so the "dabatase" could be maintained up to date.</SPAN><BR /><BR /><SPAN>PS: I'm running Community atm.</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Thu, 27 Mar 2014 14:32:16 GMT noobfreso 2014-03-27T14:32:16Z split an excel file into nodes https://connect.hyland.com/t5/alfresco-archive/split-an-excel-file-into-nodes/m-p/279348#M232478 Hi,I've already posted here http://forums.alfresco.com/forum/end-user-discussions/alfresco-share/xls-multi-pdf-03202014-0844 but maybe this place is more appropriated.I have a .xlsx file that I use as a database. Each line contains information for 1 document: Name, date, and some custom datas. I don Thu, 27 Mar 2014 14:32:16 GMT https://connect.hyland.com/t5/alfresco-archive/split-an-excel-file-into-nodes/m-p/279348#M232478 noobfreso 2014-03-27T14:32:16Z Re: split an excel file into nodes https://connect.hyland.com/t5/alfresco-archive/split-an-excel-file-into-nodes/m-p/279349#M232479 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Well. Do you know if the Alfresco PDF Toolkit may help me in this case?</SPAN><BR /><BR /><SPAN>Thank-you.</SPAN></BODY></HTML> Tue, 01 Apr 2014 07:59:36 GMT https://connect.hyland.com/t5/alfresco-archive/split-an-excel-file-into-nodes/m-p/279349#M232479 noobfreso 2014-04-01T07:59:36Z