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

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

Habilidades: .NET, Programação C#, Programação C++ , Java, Visual Basic

Veja mais: effects scripts export data, open website accounts, open source dicom archive production, c# programming, windows desktop, .net framework, open youtube accounts, scripts export data effects, open country accounts alertpay, open mail accounts, open gmail accounts, open facebook accounts, freelance open gmail accounts, set windows environment php iis, windows mobile data gsm, openvpn windows environment system, open multiple accounts bet365, manage jsp windows environment, vbnet open source accounts, windows environment

Acerca do Empregador:
( 131 comentários ) Canoga Park, United States

ID do Projeto: #17278955

Concedido a:


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 Mais

$130 USD em 3 dias
(10 Comentários)

10 freelancers estão ofertando em média $202 para esse trabalho


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 Mais

$250 USD in 3 dias
(145 Comentários)

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. Mais

$155 USD in 3 dias
(20 Comentários)
$300 USD in 3 dias
(37 Comentários)
$155 USD em 1 dia
(50 Comentários)

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 Mais

$155 USD in 10 dias
(31 Comentários)

please clarify possible next steps

$250 USD in 20 dias
(12 Comentários)

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ 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 dias
(3 Comentários)

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 Mais

$250 USD in 3 dias
(3 Comentários)

Hello Sir, I do have experience in making scripts that generates reports. Hope to hear from you. Thank you

$222 USD in 5 dias
(0 Comentários)