Import Catalog element

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

Hey,

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

PHP-Code:

---

/**
     * 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));
    } 


---

Zitat:

---

Zitat von YuriOrlovBtf

Hey,

use the contao build-in functions.

---

Perfect, thanks for the tip.

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

Zitat:

---

Zitat von Paolob

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)
Anhang 13735

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

PHP-Code:

---

/**
* 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;

} 


---

Zitat:

---

Zitat von YuriOrlovBtf

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