Find Jobs
Hire Freelancers

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.
Project ID: 31774495

About the project

10 proposals
Remote project
Active 2 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
10 freelancers are bidding on average $166 USD for this job
User Avatar
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 days
5.0 (15 reviews)
5.4
5.4
User Avatar
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 days
5.0 (46 reviews)
5.2
5.2
User Avatar
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 days
5.0 (4 reviews)
3.0
3.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Clear requirement, this should be doable using standard windows installation + ace drivers. Please contact me for further discussion Cheers.
$180 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PHILIPPINES
Makati City, Philippines
5.0
1
Payment method verified
Member since Aug 16, 2019

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.