Import Catalog element

[Paolob]

Hi
Should I convert a site with some archives Catalog
I created the new MataModels with the same fields, and now I have to import the data.

In the catalog I have a file field, where I have the file path. In the field MetaModels file is a Blob.
How can I convert this information also using PHP?

Thanks

[YuriOrlovBtf]

Hey,

use the contao build-in functions.
Here are the functions for your own "dirty-non-prepared-statements-import-script":

/**
     * Convert a UUID string to binary data
     *
     * @param string $uuid The UUID string
     *
     * @return string The binary data
     */
    function uuidToBin($uuid)
    {
        return pack('H*', str_replace('-', '', $uuid));
    }


/**
     * Get a UUID string from binary data
     *
     * @param string $data The binary data
     *
     * @return string The UUID string
     */
    function binToUuid($data)
    {
    return implode('-', unpack('H8time_low/H4time_mid/H4time_high/H4clock_seq/H12node', $data));
    } 

[Paolob]

Hey,

use the contao build-in functions.

Perfect, thanks for the tip.

Can I calculate the UUID of the file having the file path?

[YuriOrlovBtf]

Perfect, thanks for the tip.

Can I calculate the UUID of the file having the file path?

1. copy all your Files from Catalog/contao2 (tl_files/) to contao3 (files/)
2. in Contao3 Backend, run the Syncroutine (see attached picture)
Unbenannt.png

3. use this dirty-function to retrive the uuid by catalog-path as parameter.

/**
* return the uuid by given catalog-filepath
* usaeage: getBinUuidByPath('tl_files/john/doo/fooBar.png');
*/
function getBinUuidByPath($TLpath) {

    $picQ = mysql_query("SELECT uuid FROM tl_files WHERE path = '".substr($TLpath,3)."' 
                 AND extension != ''");
    $result = mysql_fetch_array($picQ);

    if(mysql_num_rows($picQ) == 1)
        return $result['uuid'];

    else    
        return false;

} 

[Paolob]

3. use this dirty-function to retrive the uuid by catalog-path as parameter.

I had thought about going to read the table tl_file, but I thought there was a different way.

thanks