Data Extraction from MS Access database on Windows 10 20H2 via script
$30-250 USD
Closed
Posted over 2 years ago
$30-250 USD
Paid on delivery
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.
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...
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
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.
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