Find Jobs
Hire Freelancers

scripts export data from a db, and manipulate data in DB (windows environment)

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
I need two scripts to help me manage a cyber cafe software. (windows environment) estimate time for someone to finish this job is 10-15 hours ====================================================== script 1 - generate a report & email it. The employees are supposed to sell time to clients, sometimes they dont and they give time for free, which is the same thing as steeling. We want a report to help us stop this. The report is simple. I have made an example of how the report should look like. see the attachment. "[login to view URL]" The report has to show the total time given to clients, and the total approximate fee's that should have been collected. note 1: We have a specific price structure for members and non-members. For this reason the report script needs to have a config file, so we can specifiy the fee structure. see the sample [login to view URL] note 2: I want the script to be ran with an icon on the desktop. batch file. at the end of every shift. when they run this report, the app should download a snapshot of the db. analyze it. and save it into a folder /report/archive file name "snapshot-7-1-2018-5pm" and the report file name should be "snapshot-7-1-2018-5pm-report" the next shift employee will run the report again, and the system will generate a new file called "report-7-2-2018-3am" the system will compare the previous file, and the new file, to be able to see the diffrences. note 3: we will need to setup a time, so i can demo to you the cyber cafe software. and how it works. via skype audio and teamviewer. you can also download the app and run in on your system to learn and understand how it works. you can download it for free here [login to view URL] note 4: i would like the report to be email to me using my google gmail credentials. so the config file, will need to have the smpt settings etc... note 5: The app uses paradox database, and is accessible when the app is open. ================================================= script 2 - clear time from accounts I need another script to run nightly using the windows scheduler. run and exit. the script will run and do the following: 1. find any account that has more than 3000 minutes and bring it down to 0, and disable the account in tinasoft. 2. find any account which has the name allday* disable the account, and make the expiration date the previous day's date. 3. find any account with the username pc01 >>> pc50 and make the time 0 on all of them ===================== requirements ===================== 1. we must be able to talk via voice and screensharing so i can show everything before i award the project 2. i will put 100% of the payment in escrow 3. must be availble usa hours california time to talk about project and do testing when the app is ready
Project ID: 17278955

About the project

9 proposals
Remote project
Active 6 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
Awarded to:
User Avatar
Greettings Sr, I have read the requirements of the scripts. If you contact me in chat, I will spend the time to download and analyze the cybercafe software. I need to check the database of this software, and if the software locks dbs file that prevents other apps to query and modify database. I would also need that you send a sample snapshot of your database to discuss details about how to generate reports. PROPOSAL Create 2 C# windows console scripts to do your described tasks. Will create an installer that will add a desktop icon during installation. Will use gmail smtp server to send the emails. I will be available on California time to make live sessions with you. You can check my profile to know more about my skills and experience in .NET. As senior developer I have been doing the software architect role in many projects. Warranty: I offer a warranty of 1 month on my work, for any malfunction or construction problem that will be corrected at no cost. I can ensure you that my work will fulfill 100% of your needs. Waiting for your answer. Kind Regards Henny Labrada
$130 USD in 3 days
4.5 (12 reviews)
5.0
5.0
9 freelancers are bidding on average $197 USD for this job
User Avatar
Hi there..... Warm Greetings We came along with your request for scripts export data from a db, and manipulate data in DB and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of .NET, C# Programming, C++ Programming, Java, Visual Basic We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$250 USD in 3 days
5.0 (213 reviews)
7.8
7.8
User Avatar
To Whom It May Concern: I am an expert in Database development with 15+ years of experience and good track records. Hello, Nice to meet you, I hope you are well Here is a senior Database developer, langlang. I have read your job description with exciting mood :) In one word, I can say <I can do your project> proudly !!!! Please check my reviews; www.freelancer.com/u/langlangfan I am interested in your projects and I believe I can deliver rich features of the application to beat your imagination. Let's work together to make it happen. Let me know if you are interested and we can always start with something small.
$155 USD in 3 days
5.0 (23 reviews)
6.7
6.7
User Avatar
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have Microsoft certifications in .Net development and sql server. I also have a lot of experience in desktop and web development. Regards
$155 USD in 10 days
4.9 (36 reviews)
5.4
5.4
User Avatar
⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ Hello.I am Russia Developer. I read your description carefully. I have rich experiences in DB . I will do my best to finish your job ASAP. Thanks. Best Regards. ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐
$155 USD in 3 days
4.9 (5 reviews)
3.8
3.8
User Avatar
HI, I am a software engineer, I have 7 years of experience in BI & software development. Specialties : * BI : Modelisation, Data Warehousing, Data Integration, Reporting, SQL optimization... * Software development : implementing a web application, a Windows application, software development, automate tasks/flows/batchs... I offer you my full involvement and commitment to work on your project with a reasonable price, top quality and professional methods. Best regards. Younes FOUITEH
$250 USD in 3 days
4.8 (3 reviews)
1.9
1.9
User Avatar
Hello Sir, I do have experience in making scripts that generates reports. Hope to hear from you. Thank you
$222 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Canoga Park, United States
5.0
136
Payment method verified
Member since Nov 13, 2005

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.