Find Jobs
Hire Freelancers

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

$30-250 USD

Κλειστή
Αναρτήθηκε πάνω από 2 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
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.
Ταυτότητα εργασίας: 31774495

Σχετικά με την εργασία

10 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 3 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
10 freelancers δίνουν μια μέση προσφορά $166 USD για αυτή τη δουλειά
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 σε 5 ημέρες
5,0 (15 αξιολογήσεις)
5,4
5,4
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 σε 2 ημέρες
5,0 (46 αξιολογήσεις)
5,2
5,2
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 σε 5 ημέρες
5,0 (4 αξιολογήσεις)
3,0
3,0
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 σε 30 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hi, Clear requirement, this should be doable using standard windows installation + ace drivers. Please contact me for further discussion Cheers.
$180 USD σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της PHILIPPINES
Makati City, Philippines
5,0
1
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Αυγ 16, 2019

Επαλήθευση Πελάτη

Άλλες δουλειές από αυτόν τον πελάτη

Data extraction from MS Access Database
$30-250 USD
Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.