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
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
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 Plus
10 freelance font une offre moyenne de $202 pour ce travail
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 satisf Plus
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. Plus
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 hav Plus
⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ 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. ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐
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 deve Plus
Hello Sir, I do have experience in making scripts that generates reports. Hope to hear from you. Thank you