PDA

View Full Version : w-agora importer: remarks


zlos
Tue 19th Apr '05, 3:06am
Hi

At www.wizaz.pl/forum (http://www.wizaz.pl/forum) you can observe imported w-agora forum. Impex worked great :D Thumbs up! for guys & Jerry :)

Although to make it heavenly superiour you need to work on some small issues:

a. Attachments from Agora are not being imported into vB. I have set filesystem in attachment storage before started working with Impex.

b. Some of the posts are doubled.

c. All "Imported" usergroups are doubled.

d. I have no clue how to update user counters like post count (Import & Maintenance -> Update counters seems to have some difficulties).

e. User profile creation date is being set to 1970-01-01 for all imported users. As far as I know Agora has this information in users table :)


That's it for the time being. I'll keep you updated.



And JERRY THANKS FOR THE AGORA IMPORTER!!! :)

zlos
Tue 19th Apr '05, 3:25am
d. I have no clue how to update user counters like post count (Import & Maintenance -> Update counters seems to have some difficulties).
This one is already OK :)

Jerry
Tue 19th Apr '05, 4:06pm
a. Attachments from Agora are not being imported into vB. I have set filesystem in attachment storage before started working with Impex.


I've yet to have a board with attachments to be able to dev and test this, if you want to submitt yours with attachments, I'll add the module.


b. Some of the posts are doubled.
c. All "Imported" usergroups are doubled.



Sounds like a re-run module to me, for this to happen.


e. User profile creation date is being set to 1970-01-01 for all imported users. As far as I know Agora has this information in users table :)


I've added this now, if the user creation date is users.unixdate.

zlos
Tue 19th Apr '05, 5:26pm
I've yet to have a board with attachments to be able to dev and test this, if you want to submitt yours with attachments, I'll add the module.

No problem. 1.2 GB of attachments could be waiting for you. I am not joking :)
I can make copy of dbase and corresponding attachments. But - you can check table "attachments" to see where agora stores the files (only filesystem storage is possible at agora).

Your decision - if yes I will drop you download links in PM.

I've added this now, if the user creation date is users.unixdate.

This should solve the problem :)

Jerry
Tue 19th Apr '05, 5:33pm
No problem. 1.2 GB of attachments could be waiting for you. I am not joking :)
I can make copy of dbase and corresponding attachments. But - you can check table "attachments" to see where agora stores the files (only filesystem storage is possible at agora).

Your decision - if yes I will drop you download links in PM.


Sure tar.gz the attachments up with a fresh mysqldump, PM me the link, and I'll add the module.

zlos
Wed 20th Apr '05, 12:23pm
Sure tar.gz the attachments up with a fresh mysqldump, PM me the link, and I'll add the module.

Done! Pls check your PM.
Sorry, all together it is approx. 3Gigs...

Jerry
Thu 21st Apr '05, 6:55pm
I've done and added the module, down load impex again, clear your session and all imported data and give it a rerun (btw : takes +40 mins for 85,000 attachments, importing into the database opposed to the file system).

Set up if you want the attachments in the database or the filesystem before you do the import, it will save time.

----------------

The base path it asks for is the one thats you forums folder is in.

Example full path for an attachment file :

/home/jerry/www/forums/ogloszenia/usmiechnijsie/notes/99997.032s.jpg

Your base path is :

/home/jerry/www