Sign in to follow this  
Followers 0
SoundOfPoetTree

Extract data from website to a database

2 posts in this topic

I've searched the forums and example scripts but haven't run across anything quite like I need to accomplish... Here's the plan: I have a website for a game in which each member has a profile page that lists various details (in text) such as amount of message board posts, days old, donations, etc... that I need to somehow extract and insert into a database for easy viewing and analysis. Here's an example:

Game Stats:

Age: 291 days

Birthday: March 25th

Visits: 2,588 (8.89 visits/day)

Karma: 146

Community Score: Trusted community member

Karma Mindset: 77% of karma given out is positive.

Subscriber with 220 subscription days left.

Message Board Stats:

MB Posts: 333 (1.14 posts/day)

Guild Board Posts: 111 (4.62 posts/day)

Guild Information:

Guild Member For: 0 years, 24 days.

Credits Donated To Guild: 181,070,247 credits.

Bytes Donated To Guild: 0 bytes.

Marks Donated To Guild: 0 marks.

Tokens Donated To Guild: 0 tokens.

Nightly credit donation: 1,000,000 credits.

Guild Donation Log:

Ore: 0

Fresh Fish: 0

Clearing Items: 0

Healing Herbs: 0

Weapons/Armor: 0

Other Items: 100

These numbers represent the theoretical

value of the items, better items add more.

Some low items don't count at all.

Guild Taxes:

Credits taxed from battle: 0 credits

EXP taxed from battle: 24,130,210 exp

Guild Activity:

Guild Board Posts: 111 (4.62 posts/day)

Posts Today: 9

So what I need to do is make a script that will extract, say, the "Credits taxed from battle" and "Guild Board Posts" fields from numerous users and input the data into a database (preferably Access). I'm new to AutoIt but have previously used iOpus iMacros, so I'm not utterly helpless I suppose. Any help or pointers in the right direction would be greatly appreciated.

Share this post


Link to post
Share on other sites



Hey,

I'm trying to do something very similar, and using the Beta version have got something using the _IEBodyReadText function. But its a bit unstable. Try searching for lyric programs. Someone on here wrote a great program which extracts lyrics from a website and displays them, the functions used in that would be similar to what you need for your database I imagine.

Mark

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0