Cancelled

vbScript -Classic .asp txt processing

Hi -

I'm sraping [url removed, login to view] using Web Content Extractor from Newprosoft

I need the .txt files processed,

and then later on or very soon, asp pages for SQL statements into MS SQL Server

plus web interface (web pages .asp) and then later .net

The project is data heavy.

1 - jobs per day log

2_ X

3 - page counter program + page counter loop, url creation

4 - duties url extraction loop

5 - qualification url extration loop

6 - date extraction

7 - string extaction - send mail *********later

8 - string extraction - questions -get fax!

9 - insertion into database*********later

10 - make forms for database *********later

I use the search page here

[url removed, login to view]

when using this page always check

1)Yes

2)by date

3)last 24 hours

4)brief

you get this string

[url removed, login to view]

q=&salmin=&salmax=&paygrademin=&paygrademax=&FedEmp=Y&tm=1d&sort=dt&vw=b&brd=3876&ss=0&FedPub=Y&SUBMIT1.x=56&SUBMIT1.y=14&SUBMIT1=Search+for+Jobs

I need header and footer info from overiew, duties and qualifications page

111111111111

1 - jobs per day log

The program is initialized by getting the number of new jobs each day, the report looks like this

Jobs 1 to 50 of 2185

you will take the number out and add a date to it for a 2 column table

date, 2185

Each day, the info will be appended

04/12/2008,2185

04/13/2008 1309

etc

Deliverable : 2 col .txt file

333333333333333333

page counter program + page counter loop, url creation

The page-report from the above query string returns 50 jobs at a time so you need to read from a text file the number of jobs

Jobs 1 to 50 of 2185 - you need to divide that by 50 to get the number of pages/urls

this example will need 50 urls query strings

Deliverable:

a .txt file with needed urls

rec 1 - not need any modification - as is, literal string

[url removed, login to view]

q=&salmin=&salmax=&paygrademin=&paygrademax=&FedEmp=Y&tm=1d&sort=dt&vw=b&brd=3876&ss=0&FedPub=Y&SUBMIT1.x=56&SUBMIT1.y=14&SUBMIT1=Search+for+Jobs

rec 2 - 50

[url removed, login to view];pg=******2&FedEmp=Y&tm=1d&sort=dt&vw=b&brd=3876&ss=0&FedPub=Y

[url removed, login to view];pg=******3&FedEmp=Y&tm=1d&sort=dt&vw=b&brd=3876&ss=0&FedPub=Y

...

[url removed, login to view];pg=******50&FedEmp=Y&tm=1d&sort=dt&vw=b&brd=3876&ss=0&FedPub=Y

No STARS! No STARS!

the deliverable will have no commas, no quotes - just a one column list of urls

44444444444444444

duties url extraction

I will scrape the urls for the duties page and qual page into the same table

the data will be in a multi-col .txt file

you must copy the urls into a file like #3 above format

DELIVERABLE - .txt file of url for duties page, no commas, one url per line

5555555555555555555

qualification url extration loop

I will scrape the urls for the duties page and qual page

the data will be in multi-col .txt file urls

you must copy the urls into a file like #3 & #4 above

DELIVERABLE - .txt files of url for qual page, no commas, one url per line

6666666666666666666

date extraction

the date scraped look like this

Tuesday, March 25, 2008 to Monday, March 31, 2008

these need to string manipulated into dates good for sql server

777777777 ************later

send mail extraction - delay - This is nice to have but not important now

I need the address extracted

8888888888888

Question footer - the fax must be extracted and made into usable data

For questions about this job:

Callie Nicholson

Phone: 703-415-7501 ext 312

Fax: 1-888-275-5116

TDD: 1-800-887-5506

Later - all data extracted

999999999999

insert into data base *********later

10

make asp pages to show data************later

Skills: ASP, Data Processing, Visual Basic

See more: visual basic insertion sort, vbscript jobs, usajobs, text string search, string b, sql get date, search text string, m string, ms processing, loop net, jobs web content, jobs report, jobs asp, jobs asp net, job asp, insertion sort visual basic, info jobs, extraction jobs, content creation jobs, column jobs

About the Employer:
( 0 reviews ) oak creek, United States

Project ID: #242425

1 freelancer is bidding on average $100 for this job

c4p

Let's start!

$100 USD in 5 days
(2 Reviews)
2.7