From Expression Engine to Serendipity

Post by **garvinhicking** » Thu Mar 16, 2006 9:34 pm

Hi!

Yes,I know that link. But that file is large. I'm sure you could tell me of a single entry where I can see the behaviour, and tell me which exact categories should be mapped how (like in your A, B, C example).

You must understand that I'm very short on time, and you need to help me out with this a bit

Best regards,
Garvin

Fabien · Post by **Fabien** » Fri Mar 17, 2006 6:23 am

Oh sorry, I didn't understand that you want only an entry. You can have it here.

In this entry, there are four categories:
CATEGORY: Spirale dynamique
CATEGORY: Bleu
CATEGORY: Orange
CATEGORY: Vert
CATEGORY: Business
CATEGORY: Individus

The first one, "Spirale dynamique", is the parent of "Bleu", "Orange" et "Vert" and is the only one that is not affected to the article in Serendipity. (It's not because it's the first one, it happens also with other entries where "Spirale dynamique" is second.)

Thanks, Fabien

Fabien · Post by **Fabien** » Fri Mar 17, 2006 6:25 am

Oooops, the link.

Post by **garvinhicking** » Fri Mar 17, 2006 10:29 am

Hi!

I used your SQL dump, and I think the problem was this: In your SQL Dump the Category name was "Spirale Dynamique", but in your MT Export the name was "Spirale dynamique". That is a difference in the string case, so the category cannot be matched!

Regards,
Garvin

Fabien · Post by **Fabien** » Fri Mar 17, 2006 11:19 am

Hi Garvin,

Apparently, it works. You are my hero!

I'll test more thoroughly this afternoon, but everything seems OK, and i'll become a Serenpidity happy user.

I'll let you know and I hope that the corrected importer will be useful for other people who whant to migrate.

Thanks, thanks, Fabien

Post by **garvinhicking** » Fri Mar 17, 2006 11:56 am

Hi Fabien!

Great to hear that! I'm really, really sorry that it took a few days to figure everything out! Sadly I'm quite busy with a project of my company, so sadly I couldn't dedicate my full attention to that.

I hope you'll have fun with Serendipity!

Best regards to France,
Garvin

Fabien · Post by **Fabien** » Fri Mar 17, 2006 1:42 pm

You have done a lot more than I have ever expected and it's seems to me that I got very quick answers.

A service like this is rare and when it comes with a wonderful product...

Warmly, Fabien

Fabien · Post by **Fabien** » Fri Mar 17, 2006 5:58 pm

Hi Garvin,

I have done all sorts of verification and I am very happy with the conversion.

I have still two small problems.

1. Because of French typography, I have to use a non-breaking space before some punctuations, like ? ! or ;. They are coded with the HTML entity &nbsp. This is correctly interprted in the text of the articles but not in the titles, nor in the comments. You can see that here for the title and here for the comments.
Is this normal? (It's not a very big work to manually modify the titles.)

2. The accentued names of the months are incorrect (as if they were not coded in UTF8). You can seethis on the main page.

Thanks, Fabien

Fabien · Post by **Fabien** » Fri Mar 17, 2006 6:03 pm

I suppose that the answer to my second problem is in the FAQ.

Post by **garvinhicking** » Fri Mar 17, 2006 6:12 pm

Hi Fabien"!

You are right about the second issue; you should see that in the FAQ. The problem is that your server is missing the UTF-8 french locale (fr_FR.UTF-8). You'll need to contact your provider to task him to add that locale!

Is it true that in french there are spaces before punctuation characters? In every other language I know, a space like "hello ?" is grammatically wrong?

HTML entities in titles are not allowed, so you'll need to use a propper character set there. The reason for this is that usually people just straight input characters like "&" in the title, which would then lead to a wrong HTML entity - so we need to encode special characters to HTML because of that.

If you are absolutely sure you want HTML entities in the title, you would need to patch the core include/functions_entries.inc.php file and replace occurences of htmlspecialchars($entry['title'])...

HTH,
Garvin

Fabien · Post by **Fabien** » Fri Mar 17, 2006 6:22 pm

Hi Garvin,

garvinhicking wrote:You are right about the second issue; you should see that in the FAQ. The problem is that your server is missing the UTF-8 french locale (fr_FR.UTF-8). You'll need to contact your provider to task him to add that locale!

The language file is coded in Latin1 and define the local as Latin 1 also. Probably I only have to correct this.

garvinhicking wrote:Is it true that in french there are spaces before punctuation characters? In every other language I know, a space like "hello ?" is grammatically wrong?

Yes, it's mandatory in French! (in French !)

garvinhicking wrote:If you are absolutely sure you want HTML entities in the title....

I'll correct the titles by hand, not a huge problem.
It's more annoying for comments. Is there something to do?

Cheers, Fabien

Post by **garvinhicking** » Fri Mar 17, 2006 6:33 pm

Hi Fabien!

No, if you use the UTF-8 charset you need to look inside the lang/UTF-8/serendipity_lang_fr.inc.php file! There it's defined as UTF-8, not latin.

Yes, it's mandatory in French! (in French !)

Wow, I didn't know. Actually it looks like a mess to me, if I see spaces before "?" or "!".

It's more annoying for comments. Is there something to do?

Because of security issues, no HTML is ever allowed in comments, so the output will always be htmlspecialchar()ed.

I'm really sorry, I don't know a good solution to that. This is probably one of the reasons why the rest of the world does not put a space before punctiation characters

)

Best regards,
Garvin

Fabien · Post by **Fabien** » Sat Mar 18, 2006 6:10 am

Hi Garvin,

Garvin wrote:
Fabien wrote:Yes, it's mandatory in French! (in French !)
Wow, I didn't know. Actually it looks like a mess to me, if I see spaces before "?" or "!".

Yes, but french people are soooooooo special!

Because of security issues, no HTML is ever allowed in comments.

In a lot of software, for example phpBB used here, it's possible to define a subset of HTML, called SafeHTML, that visitors can used. Perhaps an idea for a future realase of Serendipity.

Another thing that would be useful: in the WYSIWYG editor, a button to insert easily special characters not on standard keyboards (as in tinyMCE for example).

Garvin wrote:I don't know a good solution to that.

I'll do a find&replace of the mtimport.txt file and reload the base.

Cheers, Fabien