已完成

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

=====================

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

技能: .NET, C# 编程, C++编程, Java, Visual Basic

查看更多: 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

关于此雇主:
( 128个评论 ) Canoga Park, United States

项目ID: #17278955

授予:

cybert2t

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 更多

$130 USD 在3天内
(7条评论)
4.6

11 威客就此工作平均出价 $206

schoudhary1553

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 更多

$250 USD 在3天内
(121条评论)
7.1
langlangFan

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. 更多

$155 USD 在3天内
(20条评论)
6.6
$300 USD 在3天内
(37条评论)
6.5
$155USD 在1天里
(41条评论)
5.5
carlosperezit

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 更多

$155 USD 在10天内
(30条评论)
5.3
AlexandrUKR

please clarify possible next steps

$250 USD 在20天内
(12条评论)
4.3
YounesFOUITEH

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 更多

$250 USD 在3天内
(3条评论)
2.0
bengalTIGER1106

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ 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 在3天内
(1条评论)
1.4
$244 USD 在3天内
(1条评论)
0.0
nandhuerode

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

$222 USD 在5天内
(0条评论)
0.0