Helio Alves's Groups
-
Learning
61 members
-
Joomla! 1.6 User Guide
43 members
-
Security
46 members
Helio Alves's Page
Latest Activity
Adam D'arcy commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
Alves, I have exactly the same problem as you! I've also found this component JCOnverter which does a lot of the hard work but I have 3,000 posts that I'll have to sort back into categories in Joomla!.
Could you help me…
Helio Alves commented on Ewout Wierda's blog post 'CCKs: from choice to dominance and integration?'
Yeah I just saw the announcement and it seems to be quite interesting. The layout seems very attractive and user friendly.
I think CCKs for Joomla are becoming very competitive and powerful allowing you to extend Joomla more then ever. How these…
Helio Alves commented on Ewout Wierda's blog post 'CCKs: from choice to dominance and integration?'
My bad @IvoApostolov, I was sure I've read about it some were in the website, my apology to everyone :)
Helio Alves commented on Babs's blog post 'Integrating payment gateways'
Hi Babs,
I don't know how you feel programing but here you can find useful information on how to develop a getway payment:
http://www.nbill.co.uk/documentation/payment-gateway-development.html
I don't know if you want a getway payment…
Helio Alves commented on Ewout Wierda's blog post 'CCKs: from choice to dominance and integration?'
@Marco,
Actually Flexicontent is not using Joomla com_content it has it's own content component com_flexicontent. Why it is using it's own content component it's because Flexicontent allows you to have multiple sub-categories, which…
Helio Alves commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
It is never too late :)
Well I tried an app called Wordpress Converter that would take an export file from wordpress (xml file) and would convert into a sql file but it didn't work so I decided to try to fix this component and got it to work :)…
C O'Shea commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
a bit late. but, somewhere on my hard drive i have an app to do it automatically.. must find it..
Helio Alves commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
Amy, you are my hero :)
Thank you very much, it works perfect. I would love to share it with the community, how could I do that? where should I put the component?
Actually I'm not the developer of the component, I'm not even a developer,…
Amy Stephen commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
Try adding DISTINCT (SELECT DISTINCT wposts.* etc")
Sorry for not getting back to you!
Helio Alves commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
OK,
So here's the query to work, well mostly.
$query = "SELECT wposts.*, wp_term_taxonomy.*
FROM wp_posts wposts
LEFT JOIN wp_postmeta wpostmeta ON wposts.ID = wpostmeta.post_id
LEFT JOIN wp_term_relationships ON (wposts.ID =…
Helio Alves commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
OK,
So here's the query to work, well mostly.
$query = "SELECT wposts.*, wp_term_taxonomy.*
FROM wp_posts wposts
LEFT JOIN wp_postmeta wpostmeta ON wposts.ID = wpostmeta.post_id
LEFT JOIN wp_term_relationships ON (wposts.ID =…
Helio Alves commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
Ok, I think I found some thing that could make things go a step further.
Here: http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query#Query_based_on_Custom_Field_and_Category
I found a query that allows me to do what I need, at…
Helio Alves commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
Hi Amy,
I'd like to know if you got the file and if you got the chance to take a look. I've made many research about this issue but with no success. I wasn't able to find anything that could help me, the worst is that I'm pretty…
Amy Stephen commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
Would it be possible to email me your file? AmyStephen AT gmail DOT com.
Thanks!
Helio Alves commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
Hi Amy,
Thank you very much for your help.
Actually my problem is the following, I hope I can clearly explain.
I have two problems, first is when I import categories, here is an example:
In wp_terms, term_id are 3, 7, 8 if I import them the first…
Amy Stephen commented on Helio Alves's blog post 'I need help converting a Wordpress Blog into Joomla'
Helio -
Your query looks very close. You are missing the Category (catid) value. If you can figure out how to determine that value for your INSERT statement, you might have what you need.
There are a number of important data relationships that…
Profile Information
- Business Web site
- http://www.facommunications.com
- http://twitter.com/helioalves
Helio Alves's Blog
I need help converting a Wordpress Blog into Joomla
Hi Everyone,
I need to import a Wordress Blog with around 1000 posts and I'm using component Jconverter that can be found here: http://ow.ly/WbuL , this component works only in half, I explain. It does import posts and categories, I'm not a developer but I went into the code and fixed the posts import, they were imported without alias so it's fixed now, but when posts are imported they lose the category they belong to.
I took a look at the… Continue
I need to import a Wordress Blog with around 1000 posts and I'm using component Jconverter that can be found here: http://ow.ly/WbuL , this component works only in half, I explain. It does import posts and categories, I'm not a developer but I went into the code and fixed the posts import, they were imported without alias so it's fixed now, but when posts are imported they lose the category they belong to.
I took a look at the… Continue
Posted on January 15, 2010 at 2:00pm — 14 Comments
Comment Wall (1 comment)
- At 10:13am on October 21, 2009,
Amy Stephen said…
- Welcome! Thanks for joining us. There is a Getting Started article that might be helpful to find your way around. Appreciate you jumping into the Security discussion. Look forward to getting to know you and how you use Joomla!.
© 2012 Created by Amy Stephen.
