[Invision to Xen Migration] Nodes Categories - missing Name [No title] & paragraph & line format...

G@rgamel

G@rgamel

New member
Affected version
2.3.6 (XF) + 1.6.1 (Importer)
Hey Guys.

I've done a testimport for my Invision 4.7.20 Forum to the latest Version for XF.
All Threads, Users ... and so on are fully imported.

I'm just missing the categorie name for all nodes.
Just the nodes from the Invision Community Clubs were imported.
All other nodes from the main forum were'nt imported and have the Name [No title]

And the target format for my posts aren't not the same like the source format.
Take a look at the screenshots.

Invision 4.7.20
1740998408325.webp
XF 2.3.6 (Importer 1.6.1)
1740998448346.webp

The Paragraphs and lines are not the same.

Thanks and regards from sunny Germany :-)

G@rgamel
 
Last edited:
So... I have a solution for the paragraph and line problem.

First of all... You have to modify the old “Invision” database... I copied the database from database_123 to database_123_migration to make sure I don't have any problems with my live database.

My entries looked like this

HTML: 
<p>
    Zwei Schatten sind wir,
</p>

<p>
    die sich nur finden, wenn das Licht
</p>

<p>
    sie trennt.
</p>

<p>
    Und doch greift meine Seele nach dir,
</p>

<p>
    wie eine Hand einen Dolch
</p>

<p>
    aufnimmt.
</p>

<p>
     
</p>

<p>
    (<em>Ich kann dich nicht loslassen,</em>
</p>
The first step is to clean all <p></p>-tags in the forums_posts table.
I used this query
SQL: 
UPDATE forums_posts
SET post = TRIM(
    REPLACE(
        REPLACE(
            REPLACE(
                REPLACE(
                    post, '<p>', ''),
                '</p>', '\n'),
            '\n\n\n', '\n'),
        '\n\n', '\n')
)
WHERE post LIKE '%<p>%';

After the cleanup, my result looked like this
Code: 
    Zwei Schatten sind wir,

    die sich nur finden, wenn das Licht

    sie trennt.

    Und doch greift meine Seele nach dir,

    wie eine Hand einen Dolch

    aufnimmt.

     

    (<em>Ich kann dich nicht loslassen,</em>

    <em>ohne zu bluten</em>.)

Then I prepared my migration from Invision to Xenforo. It runs successfully and now I have to use my last cleaning query in the Xenforo database.
SQL: 
UPDATE `xf_post`
SET `message` = REGEXP_REPLACE(`message`, '\n\s*\n', '\n')
WHERE `message` REGEXP '\n\s*\n';

Here I only had to remove the unneeded lines and replace duplicate lines with a single line to achieve the same visual result as in Invision.
And it works well.

1741011051533.webp
 
Back
Top Bottom