e107 to mambo

imako · **Joined:** Fri Jul 14, 2006 8:53 am **Posts:** 2

I'm bit poor MySQL/PHP -programmer, so i ask if anyone has useable script to just convert e107 users to joomla-users.

I was thinking, that i am going to export e107_user to CVS-table and then importing it to jos_users, but there are some [censored] up fields in e107_user table.. i compare the e107_user and jos_user tables for example:

e107_user

user_id: 1
user_name: Just Example
user_loginname: example
user_customtitle
user_password: xxxxxxxxxxxxxxxxxxxxxxxxxx
user_sess
user_email: exampleman@domain.com
user_signature
user_image
user_timezone
user_hideemail: 0
user_join: 1148419058
user_lastvisit: 1150956720
user_currentvisit: 1151306777
user_lastpost
user_chats
user_comments
user_forums
user_ip
user_ban
user_prefs
user_new
user_viewed
user_visits
user_admin
user_login
user_class
user_perms
user_realm
user_pwchange

jos_users

id: 1
name: Just Example
username: example
email: exampleman@domain.com
password: xxxxxxxxxxxxxxxxxxxxxx
usertype: Registered
block: 0
sendEmail: 0
gid: 18
registerDate: 2006-07-12 11:12:24
lastvisitDate: 2006-07-13 09:32:09
activation
params

So problem really is.. wtf is with e107 user_join, user_lastvisit and user_currentvisit? In Joomla dates and times are understandable but with e107 they are messed up.

I would appreceite any help i get and hopefully someone has working solution what doesnt need programming (more than setting up db-arrays in code) :-[

alexalecu · **Joined:** Mon Sep 19, 2005 12:27 pm **Posts:** 8

it looks like those dates are actually milliseconds (or seconds) since 1 Jan 1970

ItchySox · **Posted:** Fri Jul 14, 2006 12:55 pm

alexalecu wrote:

the conversion scripts were written for a specific e107 installation

Big thanks for that. Watching this thread with interest

supern00b · **Joined:** Wed Aug 31, 2005 8:37 pm **Posts:** 55

Anyone still moving on this one?

I've still a client wanting to make the move from e107 to joomla.

mandragora · **Joined:** Tue Oct 17, 2006 1:07 pm **Posts:** 4

Hi,

Is this project still runnig or closed ??
I`m very interessted to switch my users and data from e107 to joomla.
Anyone working on this project ??

thx
mandragora

supern00b · **Joined:** Wed Aug 31, 2005 8:37 pm **Posts:** 55

I just finished this for a site.
It was ugly in the making, but turned out great.

Now they have been moved from e107 to a Joomla!, CommunityBuilder, SMF system and there have been no complaints. I think of the 500+ members the site only lost about 2.
All forums and news were intact.

mandragora · **Joined:** Tue Oct 17, 2006 1:07 pm **Posts:** 4

Hi supern00b,

That sounds great.
I have a question.

What must i do with this script files from alexalecu ??
Can you explain me step by step how do you organice this ??

I think i must install joomla on a server or local.
Then i thing i must put the script files in my e107 installation or in the jommle directory??

please give me a hint.

thx
cu
mandragora

mandragora · **Joined:** Tue Oct 17, 2006 1:07 pm **Posts:** 4

Hi,,

Can anybody help me ??
Please give me a hint.

thx
cu
mandragora

mandragora · **Joined:** Tue Oct 17, 2006 1:07 pm **Posts:** 4

Please give me a hint. :-[

$:-\$

ItchySox · **Posted:** Tue Oct 24, 2006 2:28 pm

I've never done this, but my guess

is that the process involves either transferring, renaming, repopulating (or by other means) tables that perform content functions for e107 to tables that perform the same or similar functions within your Joomla database. This could be done with scripting or manually... I guess

Riots · **Joined:** Thu Dec 07, 2006 5:42 am **Posts:** 8

is this still being followed up on ?
I need to convert about 79 e107 users to joomla users..
everything else i can hand code in.. thanks..

Fabbritzio · **Joined:** Sun Jan 07, 2007 1:48 pm **Posts:** 8

The script is missing? because I download the file and appears 0 kb , is any other script to convert from e107 to joomla?

Rhy · **Joined:** Mon Mar 12, 2007 11:42 am **Posts:** 1

in case you are blind as a bat (as I was after browsing this topic for 6 times): the link again

ItchySox · **Posted:** Mon Mar 12, 2007 2:59 pm

Here...

It's at the end of the 20th post, remember, you have to be logged in.

HTH

AmelFl · **Joined:** Sat Mar 17, 2007 7:27 pm **Posts:** 16

noob here

is there an eaiser way to transfer e017 to joomla

hexer4u · **Joined:** Fri Mar 23, 2007 4:29 pm **Posts:** 7

alexalecu, I tried your script, but it gives an error: SELECT Error: Table 'ac2004.e107_content' doesn't exist
I checked, and in my e107 database there is no table with this name. Any ideas?
Thanks

Deusdies · **Joined:** Wed Mar 21, 2007 10:50 pm **Posts:** 18

Exactly.

Anyone help! We desperately need to convert our e107 to joomla database!

edjent · **Joined:** Wed May 02, 2007 5:10 am **Posts:** 2

We are about to embark on this venture, see if its possible/probable, i've used both CMS's for several years and know both the code and databases structures fairly well....

From what I can infer from reading and through my experience in both db's this has to be possible... complicated yet possible.. its just a matter of manipulating the databases fields properly, this is going to be a manual deal, i'll prob do it in excel and generate the sql files from there, we'll see how it goes... keep ya'll posted....

AmelFl · **Joined:** Sat Mar 17, 2007 7:27 pm **Posts:** 16

thanks

loplo · **Joined:** Sun Jul 29, 2007 7:10 pm **Posts:** 9

any news?
some easyer way to "send" the e107 users to joomla?

hellooo.... anyone here?

loplo · **Joined:** Sun Jul 29, 2007 7:10 pm **Posts:** 9

I gave up, hoping for a script.

I have not more than 200 users on my e107 site and I will add them manually into the joomla sql database.

I have the following problem.

I've added copyed (copy paste) my user from the e107 database to joomla.
user/pass/email
also incremented the ID and in the GID i've put 18 (regular user) <-- right??

Now, I can login into joomla with the manually added user, but in admin mode, with admin user I can't see the user in the users list.

Can anyone help me with this issue?

Thanks in advance

loplo

g3n0c1d3 · **Joined:** Tue Dec 04, 2007 11:53 pm **Posts:** 1

For 100 euro, I will migrate ur e107 portal with joomla with users, and forum post's

stamata · **Posted:** Mon Dec 24, 2007 12:03 pm

for few thousand euros, i will learn php and mysql and then convert database from e107 to joomla

anyway, for my poor database with about 40 users and 15 news items, with 3 downloadas and without a forum, i will convert them manually

AmelFl · **Joined:** Sat Mar 17, 2007 7:27 pm **Posts:** 16

so this is still open

$:-\$

edjent · **Joined:** Wed May 02, 2007 5:10 am **Posts:** 2

We decided to go with a different CMS all together for this project; although we are still manging several other projects with joomla and ijoomla modules. I was able to convert over the users into the new CMS for this project it was all manual but it worked.

The MD5 encryption on the password fields are the same from e107 to joomla the only thing you have to do manual in joomla is make sure that the jos_aco_groups table cross references the correct id in the jos_users table. This is easier done in excel, just backup the tables from mysql admin to a csv file drop in the new inserts from e107 giving each a unique value then open the aco_groups table in a csv and cross reference the unique ids to the aco_groups table then create two sql files from your csvs and upload them over the current tables.

Of course, as alway, do this in a development enviroment and make backups along the ways. Its a bit complicated may take some trial and error but if you got the tools it can be done. shoot me a PM if you need some help I;ll do it on contract if you need it done quickly and want to pay for it.

AmelFl · **Joined:** Sat Mar 17, 2007 7:27 pm **Posts:** 16

I only need my news articles and downloads transferred...

I will be intergrating IBP members to joomla

shoulders · **Joined:** Fri Oct 10, 2008 9:03 pm **Posts:** 24

the links.php does not work from the download.

you have to alter where it says 'e107_links' to 'e107_links_page'

'e107_links' is the menu items. 'e107_links_page' is the plugin.

second, when you create the categoreis in weblinks as per instructions the catagory ID must be the same.

This script could be made to add the catagories aswell. I am not the man though as i have struggled to find this much out.

hope this helps

shoulders

lvictor · **Joined:** Wed Oct 17, 2007 4:49 pm **Posts:** 25

I'm migrating from E107 to Joomla 1.9, does anyone know how to import the passwords so that they work in Joomla?

drartik · **Joined:** Sat Sep 19, 2009 4:26 am **Posts:** 1

How can i only convert the users form e107 to joomla? I have 300 users, i don't care about the news, articles, forum and bla bla bla
Thank you in advance,
Mike

Joomla! Discussion Forums

Forum rules

e107 to mambo

Quick reply

Who is online