![A.R.F.I (A Really Fast [vB4] Importer)](/community/data/resource_icons/1/1397.jpg?1380738613){kind=icon}
A.R.F.I (A Really Fast [vB4] Importer) [Paid] 1.0.0
- Thread starter digitalpoint
- Start date
Ok, i'm at the point now where I can't take it any further, the attachments sytem is all a bit convoluted for my abilities.
However for the most part, this will work on a generic VB4 install. This is the time taken to do www.p8ntballer-forums.com from VB4 > XF.
To compare, using a web-based importer took around 6 hours...
However for the most part, this will work on a generic VB4 install. This is the time taken to do www.p8ntballer-forums.com from VB4 > XF.
To compare, using a web-based importer took around 6 hours...
Code:
!!!WARNING!!! - set charset to 'binary' in XenForo_Application:loadDb()
#################################################
### Digital Point A.R.F.I. vB4 -> XF Importer ###
### Modified by Slavik at www.XenForo.com ###
### with assistance from Mike, Jake and Shawn ###
#################################################
### Notes: ###
### None of the user feilds will be imported ###
### by default. If you want to keep your user ###
### fields these need to be configured in ###
### XenForo first and then mapped at lines ###
### 380-396. ###
#################################################
1 - Posts
2 - Users
3 - Threads
4 - Private Messages
5 - Avatars
6 - Attachments
7 - Forums
8 - Miscellaneous
9 - Everything
Make Selection [1-9]: 9
exporting posts...
[forking process for posts]
post IPs (1,183,726 records in 19.93s)...
likes (0 records in 0.04s)...
post edit history (71,037 records in 18.62s)...
reported posts (0 records in 0.92s)...
reported post comments (0 records in 0.93s)...
reported profile posts (0 records in 0.04s)...
reported profile post comments (0 records in 0.04s)...
reported private messages (0 records in 0.04s)...
reported private message comments (0 records in 0.04s)...
Total time for posts: 40.65s
exporting users...
[forking process for users & user authenticate]
user external auth (0 records in 0.04s)...
user follow (22,295 records in 0.06s)...
user ignored (166 records in 0.05s)...
user notes (2 records in 0.04s)...
user options (27,341 records in 0.14s)...
user profile (27,341 records in 1.02s)...
user privacy (27,341 records in 0.22s)...
user warnings (1,725 records in 0.12s)...
user bans (2,943 records in 0.22s)...
warning action triggers (2,943 records in 0.11s)...
skipping user fields (6,424 records in 0.01s)...
user registration IPs (27,341 records in 0.29s)...
user account confirmation IPs (1,646 records in 0.17s)...
user change log (11,489 records in 0.24s)...
user change log IPs (3,056 records in 0.16s)...
profile posts (12,667 records in 0.21s)...
profile post IPs (12,658 records in 0.19s)...
user upgrades active (291 records in 0.04s)...
user upgrades expired (487 records in 0.04s)...
user upgrades log (883 records in 0.06s)...
Total time for users: 3.43s
*** Don't forget to rebuild user cache ***
exporting threads...
[forking process for threads]
watched threads (295,118 records in 0.40s)...
thread user post (611,466 records in 1.15s)...
polls (19,589 records in 0.62s)...
thread read (0 records in 0.07s)...
Total time for threads: 2.25s
*** Don't forget to rebuild poll cache ***
exporting private messages...
[forking process for conversation master]
conversation message (182,233 records in 14.72s)...
conversation recipient (288,037 records in 3.31s)...
conversation user (199,111 records in 3.20s)...
skipping IPs
Total time for private messages: 21.34s
performing avatar diff...
4,948 users with new avatars
Total time for avatars: 150.50s
skipping attachments...
Total time for attachments: 0.00s
exporting forums...
nodes (80 records in 0.14s)...
forums (68 records in 0.07s)...
link forums (1 records in 0.07s)...
forum read (0 records in 0.10s)...
watched forums (1,486 records in 0.11s)...
Total time for forums: 0.48s
exporting micellaneous stuff...
deletion log (8,649 records in 0.15s)...
moderator log (50,342 records in 0.71s)...
daily stats (13,179 records in 30.56s)...
Total time for micellaneous stuff: 31.42s
[waiting on process for users & user authenticate] DONE.
[waiting on process for conversation master] DONE.
[waiting on process for threads] DONE.
[waiting on process for posts] DONE.
Grand Total For Everything: 4 minutes, 20 seconds (4,731,127 records)
FabioCesar
Member
There is a possibility of developing a version with the reverse process? XF => VB?
Brent W
Well-known member
Something tells me you won't get that support from here....
FabioCesar
Member
I am interested in collaborating with the developer, but if not there is interest by the other party then ended here.
Paul
Well-known member
Thats REALLY impressive...
However would be good to be able to do the attachments too...
(hint hint)
Damn - Wish i could code... anyone do a tutorial??
Thats REALLY impressive...
However would be good to be able to do the attachments too...
(hint hint)
Damn - Wish i could code... anyone do a tutorial??
Attachments update, nearly there,
Imported 9 items. (1 minutes 0.66 seconds)
Paul
Well-known member
Jarod
Active member
I believe the schemas on both vb4 and vb3 were idential, so it should
Right,
So this is now at the point where once I hammer out any other small bugs, and get attachments properly working, I would like some data outside of my own to test with.
If you have a relatively large VB4 or VB3 board, and are happy to send over a copy of your site for my testing, please drop me a PM. Obviously the data would be used only for testing purposes only, and once done would be securely destroyed.
So this is now at the point where once I hammer out any other small bugs, and get attachments properly working, I would like some data outside of my own to test with.
If you have a relatively large VB4 or VB3 board, and are happy to send over a copy of your site for my testing, please drop me a PM. Obviously the data would be used only for testing purposes only, and once done would be securely destroyed.
