Find Jobs
Hire Freelancers

Data Extraction from MS Access database on Windows 10 20H2 via script

$30-250 USD

Geschlossen
Veröffentlicht vor mehr als 2 Jahren

$30-250 USD

Bezahlt bei Lieferung
I need data extracted from an MS Access 2007 (.mdb) used by ZKTeco, not all data are extracted, only select columns from different table. What I require: 1. Script needs to be vbscript (text-based, executed by Windows [login to view URL]). 2. Script should have option to fetch data based on specified date/hours/minutes at runtime. 3. Script should have option to specify the location of the database at runtime. 4. Script output is text-based (.csv). 5. Script is NOT obfuscated for checking and validation by IT Security group. 6. Script does NOT require custom app/3rd part apps to run. Should be running on built-in Windows 10 with NO helper files/DLLs required. 7. Script can be run on local user account only, no Administrator rights required. Script should run on PC with: 1. Windows 10 20H2 and later version (Windows 11 is optional) installed. 2. Office 365 32-bit version installed installed. It is allowable to download and install Microsoft Jet or Microsoft ACE database drivers should script requires it. 3rd party MS Access drivers (not from Microsoft) is not allowed. Expectation: The script can be executed from Windows command prompt or as a scheduled task. The purpose of the script is to have it running every hour unattended via Scheduled Task, and can be run manually when needed. The output .CSV file is "TAB delimited" text file. The data needed from the database are just as follows: 1. Time of ID tap 2. Internal user ID 3. Device ID (this is the door access controller ID) 4. Employee ID 5. ID serial number Data are arranged as table with first row as column header name. Based on the "option" set during runtime, the script will open the database (specified file location) and filter the output based on the date/time range specified. As an example, script is run as below: [login to view URL] [login to view URL] c:\database\[login to view URL] 10 20 30 where: c:\database\[login to view URL] = name of the database to open 10 = number of days to fetch 20 = number of hours to fetch 30 = number of minutes to fetch The output text file should contain the past 10 days and 20 hours and 30 mins of data fetched from the database. Suppose the script ran on October 20, 2021 @ 23:00hrs, the output file should contain data from October 10, 2021, with start of data from 02:30hrs, up to the time the script is ran. Reach out directly to me if need more info.
Projekt-ID: 31774495

Über das Projekt

10 Vorschläge
Remote Projekt
Aktiv vor 3 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
10 Freelancer bieten im Durchschnitt $166 USD für diesen Auftrag
Avatar des Nutzers
hi. I have 8+ years of experience with ZKTeco access devices. I have done a number of similar projects. here are couple of my projects: ---( https://www.freelancer.com/projects/c-sharp-programming/ZKteco-download-records-service )--- and ---( https://www.freelancer.com/jobs/project-24133800/ )--- I can build a solution for you. let's do it...
$250 USD in 5 Tagen
5,0 (15 Bewertungen)
5,4
5,4
Avatar des Nutzers
Thank you for the excellent project description! I can provide you a simple .vb script that will work exactly like you want: it will read selected mdb file, filter records and output into tab separated file. Roman
$200 USD in 2 Tagen
5,0 (46 Bewertungen)
5,2
5,2
Avatar des Nutzers
Good day! I can create you a data extraction tool using Visual Basic .NET which is very much similar to VBScript. The tool will require no 3rd party software / dependencies to run and it will run on any PC once, .NET framework and Microsoft OLEDB drivers are installed. Both of those are provided by Microsoft itself and the .NET framework comes preinstalled with Windows 10 most of the time. The program will have a simple GUI to set your required parameters for scheduled running or manual running. During the scheduled running mod, you will be able to access it from the system tray. (Optional) You will be able to schedule the program to autorun through either Windows Scheduled Tasks or the program interface itself. I will provide you the project source code for security auditing and if required can assist your team to compile it at your end. Also, the code will be well documented and easy to understand. I have done several similar projects with ZKTeco and can demonstrate my previous work if required. Please feel free to contact me through the chat option. Thanks K.A.
$150 USD in 5 Tagen
5,0 (4 Bewertungen)
3,0
3,0
Avatar des Nutzers
Hi, I am a professional software developer and I can help you with this. My previous developed software are still running on Microsoft Access Database and sometimes I need to fetch data from them so I have developed a system. That is why I can relate this project to be familiar for me. I have read the description and I am confident that I can do this. Will it be ok if the script is written in C#? As you mentioned "Script does NOT require custom app/3rd part apps to run" but I think it will need Access Database Engine pre-installed on the system. Let's chat and I can do this for you. Kind regards, Karan
$200 USD in 30 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi, Clear requirement, this should be doable using standard windows installation + ace drivers. Please contact me for further discussion Cheers.
$180 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von PHILIPPINES
Makati City, Philippines
5,0
1
Zahlungsmethode verifiziert
Mitglied seit Aug. 16, 2019

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.