<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Empty d:date fields &amp; 'Bulk Filesystem Import Tool'... in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/empty-d-date-fields-bulk-filesystem-import-tool/m-p/291680#M244810</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi, folks –&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm trying to import content using the 4.2.d "Bulk Filesystem Import Tool", but I'm having problems importing content whose corresponding metadata files contain empty values in non-mandatory metadata fields of d:date field type.&amp;nbsp; Alfresco Community 4.2.d complains that it doesn't understand how to translate these (empty) string values into dates:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;org.alfresco.error.AlfrescoRuntimeException: 08230051 org.alfresco.service.cmr.repository.datatype.TypeConversionException: The property value is not compatible with the type defined for the property: &lt;BR /&gt;&amp;nbsp;&amp;nbsp; property: Name: {&lt;A href="http://www.mayoclinic.org/mss/Test/1.0}SignatureDate" rel="nofollow noopener noreferrer"&gt;http://www.mayoclinic.org/mss/Test/1.0}SignatureDate&lt;/A&gt;&lt;BR /&gt;Title: Signature Date&lt;BR /&gt;Description: null&lt;BR /&gt;Default Value: null&lt;BR /&gt;DataType Name: {&lt;A href="http://www.alfresco.org/model/dictionary/1.0}date" rel="nofollow noopener noreferrer"&gt;http://www.alfresco.org/model/dictionary/1.0}date&lt;/A&gt;&lt;BR /&gt;ContainerClass Name: {&lt;A href="http://www.mayoclinic.org/mss/Test/1.0}ConsentForm" rel="nofollow noopener noreferrer"&gt;http://www.mayoclinic.org/mss/Test/1.0}ConsentForm&lt;/A&gt;&lt;BR /&gt;isMultiValued: false&lt;BR /&gt;isMandatory: false&lt;BR /&gt;isMandatoryEnforced: false&lt;BR /&gt;isProtected: false&lt;BR /&gt;isIndexed: true&lt;BR /&gt;isStoredInIndex: false&lt;BR /&gt;isIndexedAtomically: true&lt;BR /&gt;indexTokenisationMode: TRUE&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; value: &lt;BR /&gt;&amp;nbsp;&amp;nbsp; value type: class java.lang.String&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.domain.node.NodePropertyHelper.makeNodePropertyValue(NodePropertyHelper.java:323)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.domain.node.NodePropertyHelper.addValueToPersistedProperties(NodePropertyHelper.java:276)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.domain.node.NodePropertyHelper.convertToPersistentProperties(NodePropertyHelper.java:97)&lt;BR /&gt;[…]&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The entry for this field in the content item's corresponding metadata file is:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;lt;entry key="mssT002:SignatureDate"&amp;gt;&amp;lt;/entry&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;… and the field is defined in my metadata model as:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;lt;property name="mssT002:SignatureDate"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;title&amp;gt;Signature Date&amp;lt;/title&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;type&amp;gt;d:date&amp;lt;/type&amp;gt;&lt;BR /&gt;&amp;lt;/property&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;If I plug in a value for this field in ISO 8601 format (with timezone offset) like this:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;lt;entry key="mssT002:SignatureDate"&amp;gt;2012-02-23T12:42:00.111-05:00&amp;lt;/entry&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;… as described here …&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;A href="http://blogs.alfresco.com/wp/pmonks/2009/10/22/bulk-import-from-a-filesystem/" rel="nofollow noopener noreferrer"&gt;http://blogs.alfresco.com/wp/pmonks/2009/10/22/bulk-import-from-a-filesystem/&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;… near the end of Peter's blog post, then the import works swimmingly – though of course I had to supply a value for an item whose non-mandatory field did not have a value.&amp;nbsp; (And after the import, I can click the "none" button when editing value of this field in the properties of the imported item via Alfresco Explorer:&amp;nbsp; Alfresco accepts this field as non-mandatory.)&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Oh ye of great experience, what suggestions do you have to share regarding importing items with empty, non-mandatory d:date metadata field values?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks!&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Don&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 24 Sep 2013 17:56:16 GMT</pubDate>
    <dc:creator>oofdachile</dc:creator>
    <dc:date>2013-09-24T17:56:16Z</dc:date>
    <item>
      <title>Empty d:date fields &amp; 'Bulk Filesystem Import Tool'...</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/empty-d-date-fields-bulk-filesystem-import-tool/m-p/291680#M244810</link>
      <description>Hi, folks –I'm trying to import content using the 4.2.d "Bulk Filesystem Import Tool", but I'm having problems importing content whose corresponding metadata files contain empty values in non-mandatory metadata fields of d:date field type.&amp;nbsp; Alfresco Community 4.2.d complains that it doesn't understa</description>
      <pubDate>Tue, 24 Sep 2013 17:56:16 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/empty-d-date-fields-bulk-filesystem-import-tool/m-p/291680#M244810</guid>
      <dc:creator>oofdachile</dc:creator>
      <dc:date>2013-09-24T17:56:16Z</dc:date>
    </item>
    <item>
      <title>Re: Empty d:date fields &amp; 'Bulk Filesystem Import Tool'...</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/empty-d-date-fields-bulk-filesystem-import-tool/m-p/291681#M244811</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I've only done one or 2 bulk imports, but don't you just omit the "entry" line for the date property if its blank and that way you will get the default or a null (or possibly undefined) date?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Sep 2013 09:50:49 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/empty-d-date-fields-bulk-filesystem-import-tool/m-p/291681#M244811</guid>
      <dc:creator>rjohnson</dc:creator>
      <dc:date>2013-09-25T09:50:49Z</dc:date>
    </item>
    <item>
      <title>Re: Empty d:date fields &amp; 'Bulk Filesystem Import Tool'...</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/empty-d-date-fields-bulk-filesystem-import-tool/m-p/291682#M244812</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi, Bob –&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp; Thanks for taking the time to reply.&amp;nbsp; Your idea worked, and now I can do my import.&amp;nbsp; Hooray!&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp; It might seem inconsistent that one must remove empty date field entries from an imported item's companion metadata file, while empty text field entries can stay, but knowing what the system wants makes getting the job done possible.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp; Thanks again for your help!&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Don&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Sep 2013 12:53:40 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/empty-d-date-fields-bulk-filesystem-import-tool/m-p/291682#M244812</guid>
      <dc:creator>oofdachile</dc:creator>
      <dc:date>2013-09-25T12:53:40Z</dc:date>
    </item>
  </channel>
</rss>

