problem with file schemas during export from 5.4.2 to 5.7

pibou_Bouvret
Elite Collaborator
Elite Collaborator

Hi still in the process of migrating from 5.4.2 to 5.7, i have a problem with documents exported : the file schema has changed : the file:content filename was used to name the content of a file now it seems that the file:filename value is used

Before that value was empty, so that imported documents have a nameless doc.

How can I export / import filenames correctly ?

  <schema xmlns:file="http://www.nuxeo.org/ecm/schemas/file/" name="file">
    <file:content>
      <encoding></encoding>
      <mime-type>image/png</mime-type>
      <filename>posix.png</filename>
      <data>437cbfc3.blob</data>
      <digest>9bb7d0695aada86cd4791077a04f4333</digest>
    </file:content>
    <file:filename><![CDATA[posix.png]]></file:filename>
  </schema>

  <schema xmlns="http://www.nuxeo.org/ecm/schemas/file/" name="file">
    <content>
      <encoding></encoding>
      <mime-type>application/pdf</mime-type>
      <filename>circulaire_jour_de_carence_20120224.pdf</filename>
      <data>ea1e9a28.blob</data>
    </content>
    <filename/>
  </schema>
6 REPLIES 6

Anahide_Tchertc
Elite Collaborator
Elite Collaborator

Hi,

pibou_Bouvret
Elite Collaborator
Elite Collaborator

Hi

pibou_Bouvret
Elite Collaborator
Elite Collaborator

The file table had indeed an empty filename field.

I updated that field using the name field of the related entry in the content table

Hi,

The SQL used to update the field is

Thanks! I'll add it soon (see https