[TH] Smilie Importer [Deleted]

[Code Monkey]

Hmm, I'm thinking I can export my vBulletin smilie table as xml and then just adjust it to this format. Is there an example template for the xml structure?

 

[Jon W]

Hmm, I'm thinking I can export my vBulletin smilie table as xml and then just adjust it to this format. Is there an example template for the xml structure?

There are 4 examples listed on this page:
http://xenforo.com/community/resources/smilie-importer-by-waindigo.1141/

 

[Code Monkey]

Do I just remove the sprite part?

 

[Jon W]

Do I just remove the sprite part?

I am not familiar with the XML for vBulletin. Perhaps you can post a bit of it here so I can understand?

 

[Code Monkey]

I am not familiar with the XML for vBulletin. Perhaps you can post a bit of it here so I can understand?

-<table name="vb_smilie">
    <column name="smilieid">2</column>
    <column name="title">Embarrassment</column>
    <column name="smilietext">:o</column>
    <column name="smiliepath">http://mysite.com/images/smilies/redface.gif</column>
    <column name="imagecategoryid">1</column>
    <column name="displayorder">1</column>
    <column name="importsmilieid">0</column>
</table>

 

[Code Monkey]

That's actually a phpmyadmin export as xml of the smilie table.

 

[Jon W]

-<table name="vb_smilie">
    <column name="smilieid">2</column>
    <column name="title">Embarrassment</column>
    <column name="smilietext">:o</column>
    <column name="smiliepath">http://mysite.com/images/smilies/redface.gif</column>
    <column name="imagecategoryid">1</column>
    <column name="displayorder">1</column>
    <column name="importsmilieid">0</column>
</table>

So that would convert to:

<smilies>
    <smilie>
        <title><![CDATA[Embarrassment]]></title>
        <image_url><![CDATA[http://mysite.com/images/smilies/redface.gif]]></image_url>
        <smilie_text><![CDATA[:o]]></smilie_text>
    </smilie>
</smilies>

 

[Code Monkey]

Seems simple. I'll code a script to export it into that format then. Thanks

 

[Code Monkey]

Here is the vBulletin 4 xml creation tool for anyone that wishes to use it. http://xenforo.com/community/resources/vbulletin-smilies-to-xml-conversion-script.1817/

 

[Jon W]

Here is the vBulletin 4 xml creation tool for anyone that wishes to use it. http://xenforo.com/community/resources/vbulletin-smilies-to-xml-conversion-script.1817/

Nice work. Thanks for sharing.

 

[giorgino]

1.2 compatibility?

 

[Jon W]

1.2 compatibility?

No issues AFAIK.

 

[denisx04]

The provided file was not a valid XML file. Please provide a valid XML file.

I get that error when I import my smiley zip.

 

[Code Monkey]

Then it's an invalid XML file. You have to try to open it in a browser or xml viewer and see what error it throws.

EDIT: Or wait, did you say smiley ZIP? It can't be a zip file.

 

[Jon W]

The download here is a ZIP file (XenForo won't allow upload of XML files).

So you need to extract it and upload the XML file.

Or you need to install this add-on, which will allow you to upload the ZIP (or just put in the URL of this page):
http://xenforo.com/community/resources/install-and-upgrade-by-waindigo.2035/

 

[tommydamic68]

I have installed this add on - imported the xml file and have "blank" smiles. Any ideas?

 

[Jon W]

I have installed this add on - imported the xml file and have "blank" smiles. Any ideas?

You need to make sure to upload the image files to the correct place -- they are not included in the XML file.

 

[tommydamic68]

What is the correct location?

 

[Jon W]

What is the correct location?

styles/default/xenforo/

 

[tommydamic68]

Got it - thanks! Had to upload the sprite sheet.