AnsweredAssumed Answered

alf_data query

Question asked by fagiano on Oct 12, 2010
Latest reply on Oct 18, 2010 by fagiano
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?
<?xml version="1.0" encoding="UTF-8" ?> 
- <!– Definition of new Model
–>
- <!– The important part here is the name - Note: the use of the ass: namespace
which is defined further on in the document
–>
- <model name="ass:assnewmodel" xmlns="http://www.alfresco.org/model/dictionary/1.0">
- <!– Optional meta-data about the model
–>
<description>Example assicurativa Model</description>
<author />
<version>1.0</version>
- <!– Imports are required to allow references to definitions in other models
–>
- <imports>
- <!– Import Alfresco Dictionary Definitions
–>
<import uri="http://www.alfresco.org/model/dictionary/1.0" prefix="d" />
- <!– Import Alfresco Content Domain Model Definitions
–>
<import uri="http://www.alfresco.org/model/content/1.0" prefix="cm" />
</imports>
- <!– Introduction of new namespaces defined by this model
–>
- <!– NOTE: The following namespace my.new.model should be changed to reflect your own namespace
–>
- <namespaces>
<namespace uri="ass.new.model" prefix="ass" />
</namespaces>
- <constraints>
- <constraint name="ass:allowedStatus" type="LIST">
- <parameter name="allowedValues">
- <list>
<value>non specificato</value>
<value>raccomandata</value>
<value>fax</value>
<value>prioritaria</value>
</list>
</parameter>
</constraint>
</constraints>
- <types>
- <!– Definition of new Content Type:assicurativa
–>
- <type name="ass:as">
<title>Assicurativa</title>
<parent>cm:content</parent>
- <properties>
- <property name="ass:cliente">
<type>d:text</type>
<mandatory>true</mandatory>
</property>
- <property name="ass:numero_Pratica_assicurativa">
<type>d:int</type>
<mandatory>true</mandatory>
</property>
- <property name="ass:lettera">
<type>d:text</type>
<mandatory>false</mandatory>
<default>non specificato</default>
- <constraints>
<constraint ref="ass:allowedStatus" />
</constraints>
</property>
</properties>
- <mandatory-aspects>
<aspect>cm:versionable</aspect>
</mandatory-aspects>
</type>
</types>
</model>

Outcomes