topic alf_data query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alf-data-query/m-p/231746#M184876 <HTML><HEAD></HEAD><BODY><SPAN>I created the table in C:\Alfresco\alf_data\mysql\alfresco with name lettere.frm.</SPAN><BR /><SPAN>I created the following file types, but instead of inserting a letter (raccomandata fax ..) as I would like to import them from the table fattto lettera.frm. How can you do?</SPAN><BR /><PRE class="language-none line-numbers"><CODE>&lt;?xml version="1.0" encoding="UTF-8" ?&gt; <BR />- &lt;!– Definition of new Model <BR />–&gt; <BR />- &lt;!– The important part here is the name - Note: the use of the ass: namespace<BR />which is defined further on in the document <BR />–&gt; <BR />- &lt;model name="ass:assnewmodel" xmlns="<A href="http://www.alfresco.org/model/dictionary/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/dictionary/1.0</A>"&gt;<BR />- &lt;!– Optional meta-data about the model <BR />–&gt; <BR />&lt;description&gt;Example assicurativa Model&lt;/description&gt; <BR />&lt;author /&gt; <BR />&lt;version&gt;1.0&lt;/version&gt; <BR />- &lt;!– Imports are required to allow references to definitions in other models <BR />–&gt; <BR />- &lt;imports&gt;<BR />- &lt;!– Import Alfresco Dictionary Definitions <BR />–&gt; <BR />&lt;import uri="<A href="http://www.alfresco.org/model/dictionary/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/dictionary/1.0</A>" prefix="d" /&gt; <BR />- &lt;!– Import Alfresco Content Domain Model Definitions <BR />–&gt; <BR />&lt;import uri="<A href="http://www.alfresco.org/model/content/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/content/1.0</A>" prefix="cm" /&gt; <BR />&lt;/imports&gt;<BR />- &lt;!– Introduction of new namespaces defined by this model <BR />–&gt; <BR />- &lt;!– NOTE: The following namespace my.new.model should be changed to reflect your own namespace <BR />–&gt; <BR />- &lt;namespaces&gt;<BR />&lt;namespace uri="ass.new.model" prefix="ass" /&gt; <BR />&lt;/namespaces&gt;<BR />- &lt;constraints&gt;<BR />- &lt;constraint name="ass:allowedStatus" type="LIST"&gt;<BR />- &lt;parameter name="allowedValues"&gt;<BR />- &lt;list&gt;<BR />&lt;value&gt;non specificato&lt;/value&gt; <BR />&lt;value&gt;raccomandata&lt;/value&gt; <BR />&lt;value&gt;fax&lt;/value&gt; <BR />&lt;value&gt;prioritaria&lt;/value&gt; <BR />&lt;/list&gt;<BR />&lt;/parameter&gt;<BR />&lt;/constraint&gt;<BR />&lt;/constraints&gt;<BR />- &lt;types&gt;<BR />- &lt;!– Definition of new Content Type:assicurativa <BR />–&gt; <BR />- &lt;type name="ass:as"&gt;<BR />&lt;title&gt;Assicurativa&lt;/title&gt; <BR />&lt;parent&gt;cm:content&lt;/parent&gt; <BR />- &lt;properties&gt;<BR />- &lt;property name="ass:cliente"&gt;<BR />&lt;type&gt;d:text&lt;/type&gt; <BR />&lt;mandatory&gt;true&lt;/mandatory&gt; <BR />&lt;/property&gt;<BR />- &lt;property name="ass:numero_Pratica_assicurativa"&gt;<BR />&lt;type&gt;d:int&lt;/type&gt; <BR />&lt;mandatory&gt;true&lt;/mandatory&gt; <BR />&lt;/property&gt;<BR />- &lt;property name="ass:lettera"&gt;<BR />&lt;type&gt;d:text&lt;/type&gt; <BR />&lt;mandatory&gt;false&lt;/mandatory&gt; <BR />&lt;default&gt;non specificato&lt;/default&gt; <BR />- &lt;constraints&gt;<BR />&lt;constraint ref="ass:allowedStatus" /&gt; <BR />&lt;/constraints&gt;<BR />&lt;/property&gt;<BR />&lt;/properties&gt;<BR />- &lt;mandatory-aspects&gt;<BR />&lt;aspect&gt;cm:versionable&lt;/aspect&gt; <BR />&lt;/mandatory-aspects&gt;<BR />&lt;/type&gt;<BR />&lt;/types&gt;<BR />&lt;/model&gt;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 12 Oct 2010 10:10:23 GMT fagiano 2010-10-12T10:10:23Z alf_data query https://connect.hyland.com/t5/alfresco-archive/alf-data-query/m-p/231746#M184876 I created the table in C:\Alfresco\alf_data\mysql\alfresco with name lettere.frm.I created the following file types, but instead of inserting a letter (raccomandata fax ..) as I would like to import them from the table fattto lettera.frm. How can you do?&lt;?xml version="1.0" encoding="UTF-8" ?&gt; Tue, 12 Oct 2010 10:10:23 GMT https://connect.hyland.com/t5/alfresco-archive/alf-data-query/m-p/231746#M184876 fagiano 2010-10-12T10:10:23Z Re: alf_data query https://connect.hyland.com/t5/alfresco-archive/alf-data-query/m-p/231747#M184877 <HTML><HEAD></HEAD><BODY><SPAN>Sorry I don't quite understand your question.&nbsp;&nbsp;&nbsp; You should not be touching anything in the alf_data folder.</SPAN></BODY></HTML> Thu, 14 Oct 2010 23:17:56 GMT https://connect.hyland.com/t5/alfresco-archive/alf-data-query/m-p/231747#M184877 mrogers 2010-10-14T23:17:56Z Re: alf_data query https://connect.hyland.com/t5/alfresco-archive/alf-data-query/m-p/231748#M184878 <HTML><HEAD></HEAD><BODY><SPAN>I'm sorry. but I have another question. it is possible that the advanced workflow does not start when starting the template show_audit.</SPAN><BR /><SPAN>What could be the problem?</SPAN></BODY></HTML> Mon, 18 Oct 2010 10:15:51 GMT https://connect.hyland.com/t5/alfresco-archive/alf-data-query/m-p/231748#M184878 fagiano 2010-10-18T10:15:51Z