Hi all. I need to import an old CMS DB to drupal. I'm importing one content type where the old "title" is like "Rhapsodie Espagnole, Ma Mère l’Oye, Boléro ecc."
I need to transform è to "è", à to "à" and so on.
I have thinked to use html_entity_decode() but there is a problem: "è" is transformed in a strange char, and node->title are stored like "Rhapsodie Espagnole, Ma M l’Oye, Bol ecc".
Where is my error ?
Tnx.
If the charset parameter of html_entity_decode doesn't work (try UTF-8?), you might have to use regular expressions during migration.
On Tue, Aug 24, 2010 at 5:47 PM, Michel Morelli michel@ziobuddalabs.itwrote:
Hi all. I need to import an old CMS DB to drupal. I'm importing one content type where the old "title" is like "Rhapsodie Espagnole, Ma Mère l’Oye, Boléro ecc."
I need to transform è to "è", à to "à" and so on.
I have thinked to use html_entity_decode() but there is a problem: "è" is transformed in a strange char, and node->title are stored like "Rhapsodie Espagnole, Ma M l’Oye, Bol ecc".
Where is my error ?
Tnx.
-- Michel 'ZioBudda' Morelli michel@ziobuddalabs.it Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN: michel@ziobuddalabs.it JABBER: michel@ziobuddalabs.it
-- [ Drupal support list | http://lists.drupal.org/ ]
On Aug 24, 2010, at 9:03 AM, Carl Wiedemann wrote:
I have thinked to use html_entity_decode() but there is a problem: "è" is transformed in a strange char, and node->title are stored like "Rhapsodie Espagnole, Ma M l’Oye, Bol ecc".
Check the character set on the node table.
Hi all. I need to import an old CMS DB to drupal. I'm importing one content type where the old "title" is like "Rhapsodie Espagnole, Ma Mère l’Oye, Boléro ecc."
I need to transform è to "è", à to "à" and so on.
Why not do search and replace on the SQL or CSV file? Using a simple text editor. Or grep etc.
Fred