Script to move data Dizkus 3.1 to MUBoard
Closed this issue · 37 comments
I Michael,
As requested on the community forum.
Would you please let me know an email address to send you my dizkus tables.
Many Thanks.
Regards.
Pierre.
Hi Pierre,
kontakt(at)webdesign-in-bremen.com
Greetings
@PierreNau
Did you get my email address?
Hi Michael,
Yes I did and I sent you the dizkus database on Tursday night at mailto:kontakt@webdesign-in-bremen.com through your web site.
Did you get it? Please confirm me.
If not, I shall send it tomorrow when back at home
Regards.
Pierre.
Envoyé de mon iPad
Le 10 janv. 2015 à 09:00, Michael Ueberschaer notifications@github.com a écrit :
@PierreNau
Did you get my email address?—
Reply to this email directly or view it on GitHub.
Sorry. No I did not.
Regards Michael
Correction. I did. It was on my account.
Thx for that.
Greetings Michael
Close ticket.
See detail tickets.
I think the script is complete.
Would be nice if you could test the current repository.
Hi Michael,
I have tested the repository:
Database import is working perfectly wether selecting "all" or "category and forums" or "posts and answers"
However the results must be improved.
Hereafter screenshots that speak by themselves:
Category: --> name missing and description missing but position OK:
Forums
Forum: --> name missing and description missing but position OK:
Users:
All users are imported. Only ranks have to be set-up.
Ranks:
Name of rank is missing and some cleaning is necessary (my job)
Frontpage:
Here is the front page display:
Apparently, the number of posts
I'll send you the current MUBoard database after script running.
OK for the French translation. I'll modify it and let you know ASAP.
Thank you for the script.
Regards.
Pierre.
You're welcome.
Thx for the screenshots.
Hmmhmm....that is not so good.
Special chars in the title, descriptions and so on make it harder to import all correctly.
The ranks are not set in your dizkus tables, so i cannot improve that....
Which php version do you use and is the mysqli Extension activated on your server?
Hereafter my server details
php version: 5.4.31
mysql version: 5.5.40-36.1
Apache version: 2.4.10
PHP extension : mysqli (activated)
OK for the ranks. I have to sort it out by myself on my dizkus tables.
What do you mean by chars (é, ê, è, à for example?)
Pierre.
Ok. The technical aspect is not the cause of the missing title and so on.
I have to look....
Something like L'hotel.
What about your users. For some of them i get no import?!
Which names are missing?
Aspect of not set ranks for users.
For your understanding.
In your user table is for all users 'user_rank' set to 0.
With the french translation you should wait until the script works like expected.
Oh I see!
I have 2 zikula install:
1.39 where dizkus cannot work
1.2.9, where dizkus is working.
The number of users is different (more users on 1.2.9). So after importing the dizkus database on the 1.3.9 installation where MUBoard is (and to make the script running) the dizkus table users (that of 1.2.9) is not matching the users table of 1.3.9.
That's reason why you got no import for some of them.
Maybe I'd better to equal the number of users.
With regard the ranks, I got rid of them. I'll set them up later on.
Regards.
Pierre.
Nice to know. So the issues with users and ranks are cleared.
For the other issues with titles and so on i have to look.
Regards
Michael
About categories.
In dizkus the categories have no description; it is an additional feature in MUBoard. 😄
Indeed!
It would be nice if you could test again with current repository.
Regards
Michael
Sorry Michael but I can’t connect to my DATABASE as it was possible previously??
I did not change any data.
Regards.
Pierre.
My server is OK.
Le 13 janv. 2015 à 17:50, Michael Ueberschaer <notifications@github.com mailto:notifications@github.com> a écrit :
It would be nice if you could test again with current repository.
Regards
Michael—
Reply to this email directly or view it on GitHub #60 (comment).
Yes. I implemented a check for that.
First idea is, your datas are wrong; sorry?! 😄
With regard to the data, I cannot see any difference from the previous version.
Host
DB Name
Nom d'utilisateur
Password
With exactly the same value, I can't connect to the same database. What was possible previously.
Yes. Previously there were no check and there were no access to the database. Now there is a check for find the reason why the titles, descriptions and texts do not find their way into the database.
Are you sure you have the correct datas; you speak of two databases?!
I ask because for me the import is working.
Hi Michael,
I've sorted it out my issue. I did a mistake in handling the databases.
The script worked properly as you can see here: http://www.jfk-assassinat.com/index.php?module=muboard&type=user&func=view&ot=category
Howerver, I don't understand why the number of posts of some users of the DIZKUS database are not implemented by the script . Example user christian is set to 0 what is odd for a major contributor?
Last suggestion why not to implement implement the total number of post to the bottom of the template instead of or in addition of the information (legend)?
Anyway, many thanks for your help.
Regards.
Pierre.
Hi Pierre,
let me know the user ID of christian and i will have a look.
Ab out layout you could create an issue.
Regards
Michael
Michael,
christian id is 19.
Moreover I have no access to some forum because of the 5000 limit:
Is it possible to increase the 5000 limit to 10 000 or more?
Ok to create an issue about the layout.
Regards.
Pierre
Hi Pierre, limit i changed to 10000.
You have to install again.
Regards
Michael
In my user table of MUBoard after running import user christian(id 19) has 337 posts.
I have just tested....i'm a little bit confused.
Yes Michael that's correct. My explanation was poor.
What I meant is that the name of christian does not appear beside the 19 id as it should.
Thank you for the extension of the limit. That works pretty good!
Fine! 😄 You're welcome!
Is christian in the table of the users module?
No christian is not!! So I have to create this user with id 19 (not affected in the users table).
I'll check that and if it works I'll do the same process for similar cases.
I'll let you know.
Pierre.
👍
Michael,
I did it for christian and all users in the same case. It worked perfectly. By now the forum is OK.
I just experienced something odd while posting the message. No problem whatsoever to post but I always this message to the top:
What's that? The first time I got this.
Thanks for your help.
Regards.
Pierre.
Fine, that the import is like you wished.
To the messages:
The module wants to send a mail to users, that have subscribed a forum, if you post something within the forum.
Maybe there is no valid email adress in the users module for them, because MUBoard should get it from there.
If not i have to look at.
OK, but nobody has scribed to any forum as it was not online until now.
Maybe you peak of that users that suscribed formerly on the Dizkus forum?
In addition, I have suscribed to all forums by clicking on the envelop icon to the right of each and I got the same message while posting. My email address is valid.
Maybe you peak of that users that suscribed formerly on the Dizkus forum?
Yes. In the table 'z_dizkus_description' there are 51 entries that get imported by the import script.
I could delete this part of the script or make it optional to import the subscribers.