topic Re: problem with file schemas during export from 5.4.2 to 5.7 in Nuxeo Forum

problem with file schemas during export from 5.4.2 to 5.7

pibou_Bouvret — Thu, 10 Oct 2013 17:03:02 GMT

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>

Re: problem with file schemas during export from 5.4.2 to 5.7

Anahide_Tchertc — Fri, 11 Oct 2013 21:42:23 GMT

Hi,

Re: problem with file schemas during export from 5.4.2 to 5.7

pibou_Bouvret — Sat, 12 Oct 2013 10:51:39 GMT

Re: problem with file schemas during export from 5.4.2 to 5.7

pibou_Bouvret — Mon, 14 Oct 2013 10:43:22 GMT

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

Re: problem with file schemas during export from 5.4.2 to 5.7

Anahide_Tchertc — Mon, 14 Oct 2013 14:22:20 GMT

Hi,

Re: problem with file schemas during export from 5.4.2 to 5.7

pibou_Bouvret — Mon, 14 Oct 2013 14:50:01 GMT

The SQL used to update the field is

Re: problem with file schemas during export from 5.4.2 to 5.7

Anahide_Tchertc — Tue, 15 Oct 2013 09:22:12 GMT

Thanks! I'll add it soon (see https