Find Jobs
Hire Freelancers

Powershell scan directory for new/edited logfiles and put it into mysql table

€8-30 EUR

Закрито
Опублікований over 5 years ago

€8-30 EUR

Оплачується при отриманні
Hi, [login to view URL] (attachment) is the logfile example in the same directory like other logfiles. [login to view URL] is a php file which puts all logfiles in directory into database if they are not duplicated ofcourse so now a powershell [login to view URL] which would run on local pc and update the logfiles from that directory in remote mySQL on same principle as does [login to view URL] (note that logfiles does not have any delimiters) [login to view URL] powershell file is checking for changed/created new logfiles and also outputs them into another logfile every 5 seconds (found on web and would fit my needs) So what i need from you? Edit powershell file that scans directory every 5 seconds for changes and creations of new .log files ([login to view URL]) and put all new/edited data in mysql table, if you have any other idea you are welcome If the file edit/modification or creation is true and it contains new data then it should start mysql query to insert that last new lines of .log files into 6 rows! Also there should be in case if pc has no connection and so on, some kind of check of last inserted files and should loop thru that ones until is sucesfully inserted in mySQL tables, so that we dont want to miss any of logfile outputs in mysql. Maybe after completed mysql insertion it writes something to some file that it knows what was not inserted, so it will not go over all files to try to insert them and cause higher pc load. An mysql connection (password, username or even better also database and server) should be a little bit more secure and not readable, i have seen some examples of that encrypting and decrypting in powershell. files included: mydir (directory) [login to view URL] (script that scans directory for *.log changes/creation etc.) [login to view URL] (logfile how data is needed to get into mysql -> 6 rows [login to view URL] (just to show that [login to view URL] is working fine with other logfiles in directory) [login to view URL] (writes what is done at *.log files in directory so on that trigger from [login to view URL] you could build forward) [login to view URL] -> this is how i'm doing it right now, delimiter is space so thats why there is $value[4]." ".$value[5]; (because of 2 spaces) and at last 6th is implode(" ",array_slice($value,6)); so it doesnt split it in more rows. so this has just to change into powershell basicaly Regards
ID проекту: 18016524

Про проект

Дистанційний проект
Активність 5 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними

Про клієнта

Прапор SLOVENIA
Bled, Slovenia
5,0
2
Спосіб оплати верифіковано
На сайті з черв. 28, 2012

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.