Find Jobs
Hire Freelancers

Powershell script to gather data from webpage and input into MS Access table...

$10-30 USD

In Progress
Posted about 8 years ago

$10-30 USD

Paid on delivery
I need a Powershell script to pull the content of a webpage. The elements needed are on the page and need to be reformatted and written into a MS Access 2010 table. !!!!!The request is to do it with "Powershell". That is what I must have. No other third-party apps such as JS, Perl or Python.!!!!!! Finish/fix the script I started and have attached as a file or start from scratch... Pseudo code: Verify webpage exists: if "[login to view URL]"; returns error then "No updates for this date" ***Error example: "[login to view URL]" else do the following: Pull these items from the page: ------------------ "<p>This SRU number: 2016-05-04-001<br>" "This SEU number: 1476<br>" for each table... There are two tables on this sample but this changes. The can be "High Priority", Medium Priority", and/or "Low Priority". So for each table I need to categorize each of the rules. Only two sample for the two tables are shown here. "<caption><b>High Priority</b></caption>" "<tr><td>1</td><td>38680</td><td>MALWARE-CNC</td><td>[login to view URL] GET attempt</td><td>off</td><td>drop</td><td>drop</td></tr>" "<tr><td>1</td><td>38681</td><td>MALWARE-CNC</td><td>[login to view URL] POST attempt</td><td>off</td><td>drop</td><td>drop</td></tr>" "<caption><b>Medium Priority</b></caption>" "<tr><td>1</td><td>38677</td><td>INDICATOR-OBFUSCATION</td><td>UTF-8 evasion attempt</td><td>off</td><td>off</td><td>off</td></tr>" "<tr><td>1</td><td>38678</td><td>INDICATOR-OBFUSCATION</td><td>UTF-8 evasion attempt</td><td>off</td><td>off</td><td>off</td></tr>" ------------------ The middle Policy State, "Bal", is the one needed from the three listed. What I need is the data placed in the table "tbl_Rules" in the Access database. The columns are: "SRU","SEU","Priority_Level","GID","SID","Rule_Group","Rule_Message","Policy_State_Bal" Example inut from sample page: 2016-05-04-001,1476,High Priority,1,38680,MALWARE-CNC,[login to view URL] GET attempt,drop 2016-05-04-001,1476,High Priority,1,38681,MALWARE-CNC,[login to view URL] POST attempt,drop 2016-05-04-001,1476,Medium Priority,1,38677,INDICATOR-OBFUSCATION,UTF-8 evasion attempt,off 2016-05-04-001,1476,Medium Priority,1,38678,INDICATOR-OBFUSCATION,UTF-8 evasion attempt,off
Project ID: 10465885

About the project

3 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
hi there, have been doing this every now and then. PM me the details. thanks
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
3 freelancers are bidding on average $50 USD for this job
User Avatar
HI I will do it via ms access webbrowser control via coding or via vb.net Regards zura
$111 USD in 3 days
5.0 (13 reviews)
5.2
5.2
User Avatar
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$15 USD in 1 day
4.8 (4 reviews)
2.3
2.3

About the client

Flag of UNITED STATES
macdill afb, United States
5.0
11
Payment method verified
Member since Jul 10, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.