Find Jobs
Hire Freelancers

Write some Software

$10-30 USD

Terminado
Publicado hace casi 8 años

$10-30 USD

Pagado a la entrega
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
ID del proyecto: 10465803

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I have created the script for you. You can download it from here: [login to view URL] File contains two readme file and an exe file it has been developed in powershell only, but for demo i have converted it into exe. before you run [login to view URL] create the table in the database with the following given fields id autoNumber SRE shortText SEU shortText GID shortText SID shortText Rule_group LongText Rule_Message LongText Priority ShortText policy_state_bal ShortText field names should remain the same. please test it if you get any errors please tell me i will fix it.
$30 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
3 freelancers están ofertando un promedio de $25 USD por este trabajo
Avatar del usuario
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 en 1 día
4,8 (4 comentarios)
2,3
2,3
Avatar del usuario
hi there, have been doing this every now and then. PM me the details.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
macdill afb, United States
5,0
11
Forma de pago verificada
Miembro desde jul 10, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.