Volunteer help needed importing reviews by hand

[Morrus]

Hey guys,

It looks like the old reviews data will need to be imported by hand. There are thousands of reviews, but due to the way the data was originally entered, there's no direct way to simply imoprt the information across.

So I'm hoping a few people will volunteer to help import them by hand. The more people who help, the quicker it will get done. Basically, it's data-entry: a crapload of cutting and pasting.

If I can get some volunteers, I'll give them temorary mod permissions in the reviews area. That will enable them to delete the old reviews data as they copy it, to prvent confusion.

I'd guess it would take about a minute per review. The only thing that would add to that, I think, it the quick Google Image Search you'll need to do for each,a s each review needs a graphic uploaded.

For review ratings, unless the original reviewer actually mentioned his/her rating in the text of the original review, the best you can do is attempt to determine what score they'd have given based on the review itself. Since you'll be able to assign reviews to the original reviewer, they'll be able to go in and adjust that at any time.

Anyway, if you have some spare time and are willing to help out, please let me know here.

Thanks, guys!

 

[Rodrigo Istalindir]

Hey guys,

It looks like the old reviews data will need to be imported by hand. There are thousands of reviews, but due to the way the data was originally entered, there's no direct way to simply imoprt the information across.

So I'm hoping a few people will volunteer to help import them by hand. The more people who help, the quicker it will get done. Basically, it's data-entry: a crapload of cutting and pasting.

If I can get some volunteers, I'll give them temorary mod permissions in the reviews area. That will enable them to delete the old reviews data as they copy it, to prvent confusion.

I'd guess it would take about a minute per review. The only thing that would add to that, I think, it the quick Google Image Search you'll need to do for each,a s each review needs a graphic uploaded.

For review ratings, unless the original reviewer actually mentioned his/her rating in the text of the original review, the best you can do is attempt to determine what score they'd have given based on the review itself. Since you'll be able to assign reviews to the original reviewer, they'll be able to go in and adjust that at any time.

Anyway, if you have some spare time and are willing to help out, please let me know here.

Thanks, guys!

I can do some. Boards willing, of course.

 

[Morrus]

I can do some. Boards willing, of course.

Tell me about it. I've done three, but I think i'll wait until the boards are a bit quieter.

Here's the process I'm going through:

1) Each thread in the old data category is a product. Each post in that thread is a product description, a review or a comment on a review. We only want the reviews.

2) Create a new review in the relevant category.

3) Google image search to find a nice big image. 200px is standard, it'll resize larger ones down, so just err on the side of too big and you'll be fine.

4) Scan the review and pick a sentence or two to put in the byline field. The find a short paragraph to put in the short synopsis field - most reviewers have a decent intro or conclusion paragraph you can copy/paste.

5) Copy/paste in the name of the reviewer. That's gotta be exact, as it'll match that to thier member acvount.

6) Copy/paste in the entire review.

7) Use your best judgement to rate the product accoridng to what they've said. So, if they emntion the artwork was crappy, give it a low score on Production Value. If they say they're pleased at paying $10 for 300 pages, give it a high score in the Value for Money category. Sometimes they'll actually tell you how they arrived at their score, which helps. Bear in mind it used to be 1-5, and now it's 0-10.

8) Hit submit. Once you see it's gone through OK, delete the original and any corresponding comments so that nobody duplicates it. Plus we get a sense of satisfaction as we watch the number sin that forum dwindle towards zero.

I'll give you mod powers in the reviews section, so you should be able to do all of the above!

Thanks, I really appreciate this!

 

[Morrus]

Oh, couple of notes I forgot:

1) You'lll notice that with mod powers you'll ahve an entry whereby you can "feature" a review, and it's already filled in. Edit that to some date in the past so it doesn't show up in the Featured Reviews block.

2) I'm trying not to do two reviews of the same product close to each other, to avoid a whole page of reviews of the same product on the Recent Reviews display, I'm pretty much picking a thread at random, grabbing one review from it, deleting that review and then moving to another thread.

 

[Mark]

Email sent.

 

[Blackrat]

I have quite a lot of empty time on my hands when I'm at work, which is luckily even on the quiter hours of ENW, so I could give you a hand in this, starting on monday .

 

[Angel Tarragon]

I've got lots of time on my hands and would love to help out.

 

[Morrus]

Fantastic1 Thanks, guys! I've set you all up as reviews moderators so you should have all the required permissions.

 

[Blackrat]

Okay, I tried to port one and just wanted to make sure I did everything okay before I set out to sort these in real.

Here's the original: http://www.enworld.org/forum/showthread.php?t=154990 as you can see edited it to notify that it has already been ported. I'll delete it once you've approved that I did everything right.

And here it is in the new reviews section: http://www.enworld.org/forum/showthread.php?t=239863

 

[Morrus]

Absolutely perfect! The only thing I'd have done differently is the Short Synopsis, where I'd have put a paragraph of text, rather than listing the credits and pagecount. But that's no biggie!