Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
Elxis 5.5 Calypso supports 2 factor authentication login with e-mail or SMS.
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
Elxis 4.x/5.x DEV
»
Categories, articles and images importing tool
« previous
next »
Print
Pages: [
1
]
Author
Topic: Categories, articles and images importing tool (Read 6483 times)
maple
Full Member
Posts: 192
Categories, articles and images importing tool
«
on:
September 28, 2012, 17:06:14 »
Hello,
first of all, Elxis 4 it's impressive. Quick, secure, scalable, easy to use...
I've a lot of articles, about 1000. I can see some big waste of time and headache adding one by one from the elxis control panel.
I need a solution for importing this 1000 articles (with some images) and categories, to the elxis 4 database.
About 90% of these articles are from word (.doc or .docx extensions).
Also all these articles are in two or three languages.
So, need an importing tool. Perhaps a component, or something provisional to begin to work as soon as possible.
Thank you very much and congratulations for the very, very good work.
agus
«
Last Edit: September 28, 2012, 17:23:51 by maple
»
Logged
StefanSultanov
Full Member
Posts: 143
Re: Categories, articles and images importing tool
«
Reply #1 on:
September 28, 2012, 20:34:24 »
If Elxis team comes up with such a tool, it would be great!
How about phpMyAdmin?
I've imported some large arrays of articles that way...
Logged
datahell
Elxis Team
Hero Member
Posts: 10345
Re: Categories, articles and images importing tool
«
Reply #2 on:
September 28, 2012, 22:19:33 »
MS Word is not a web authoring tool.
It will be a tragic mistake if you import articles from word.
You must first convert Word's messy code into plain text by pasting the word text into a pure text editor (notepad, pspad, etc).
Off course this way you will loose styling but you will get a clean version of the article.
You can also convert word's code into html code but all the converters I have seen don't produce good html.
Things you should also take care of:
If you don't provide category information (catid) all articles will be imported as autonomous pages (catid=0). You should afterwards move them to the proper category.
Translations should point to the original article. So, you must first import the articles and then import/bind the translations. This can only be done by a specially build php script.
You should also provide required by Elxis parameters such as title, seo title, meta tags, etc... A php script could do that automatically.
For each article image Elxis generates 3 different versions of it
. A thumbnail, a medium one, and the large one. So your script must also create these images (thumbnail and medium) and use proper naming.
«
Last Edit: September 28, 2012, 22:21:04 by datahell
»
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
rentasite
Elxis Community
Hero Member
Posts: 3282
Web Services
Re: Categories, articles and images importing tool
«
Reply #3 on:
September 28, 2012, 23:05:53 »
Quote from: datahell on September 28, 2012, 22:19:33
It will be a tragic mistake if you import articles from word.
Thumbs up, on this!
Logged
Rent a Site
|
Lelevose
maple
Full Member
Posts: 192
Re: Categories, articles and images importing tool
«
Reply #4 on:
September 29, 2012, 13:57:09 »
Oh, thank you all for the responses.
I can see on the CKEditor a button (past from the word). I don't know if it possible take this engine to keep the word format, or similar one, into the importing tool. Anyway, I already try this button, but, it's not a perfect paste, I know...
Well, Datahell, I haven't good coding knowledgements. Anyone have any importing tool, php script or simple component to take at least a plain text without format and take into the correct categories with images to the Elxis 4 db? It is possible that anyone at Elxis Team make a good importing tool component (images, article, categories, languages) in the near future?
StefanSultanov, could you show the code making part of this across phpMyAdmin?
Thanks so much
agus
«
Last Edit: September 29, 2012, 13:58:46 by maple
»
Logged
StefanSultanov
Full Member
Posts: 143
Re: Categories, articles and images importing tool
«
Reply #5 on:
September 30, 2012, 12:40:07 »
No, mate!
There is no coding involved here.
If you want a clean paste of unformatted text into the text editor from word - you do this:
Copy from Word
Paste to Notepad - Copy from Notepad
Paste into Elxis editor.
(Works fine under Windows 7)
If you don't do that, "the tragedy" appears when you press the HTML button. You'll see Word formatting 10 times as long as your article!
This is slowing your site soooo much, man!
If you want bulk import MANY articles and categories, you must go to PHP MyAdmin and import it as SQL or CSV data.
Such file you can generate with Excel.
http://www.youtube.com/watch?v=wfahu3ggy8c&feature=related
I believe you can take this from here. Be very careful!
You can totally destroy the database and the way Elxis connects with it.
And yet, it's not coding in the real sense of the word.
Good luck!
Anyway, a quick and easy to work with articles importing tool is really a killer feature, if developers decide to implement it.
«
Last Edit: September 30, 2012, 14:46:09 by StefanSultanov
»
Logged
datahell
Elxis Team
Hero Member
Posts: 10345
Re: Categories, articles and images importing tool
«
Reply #6 on:
September 30, 2012, 13:09:46 »
There are
many document writers
(ms office, libre office, star offfice, etc) and formats (doc, docx, rtf, odt, etc...)
Also the
encoding
might be different. MS for example uses ANSI. If you import a document written in Greek (windows-1253 or iso-8859-7) from word into Elxis you will get a very bad result as Elxis expects to get text in utf-8. You should make sure to write your texts in utf-8.
Finally your office has a save us/export functionality. You can for example export it as html. But if you look into the generated code you will see that it is tragic.
Do you want your site to have such html code? Personally I don't...
It is almost impossible to create an importing tool that will work 100% correct.
I don't want to create a tool that will possible create problems to the site.
«
Last Edit: September 30, 2012, 13:15:31 by datahell
»
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
maple
Full Member
Posts: 192
Re: Categories, articles and images importing tool
«
Reply #7 on:
September 30, 2012, 17:05:47 »
Oh, I see that it's a difficult issue. Anyway, thanks to all for your responses.
And, perhaps only importing a plain text articles and categories with no format can be a good solution for a simple importing tool component.
If anyone can help me, I will be very happy... I have about 1000 articles to upload
If not, 1000 article it's not the same as 10000 hahaha I can do it manually. I'm very fast!
Anyway, thank you very much to all. Elxis 4 it's awesome!!
agus
«
Last Edit: September 30, 2012, 18:59:50 by maple
»
Logged
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Support
»
Elxis 4.x/5.x DEV
»
Categories, articles and images importing tool