完了

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, ビジュアルベーシック

さらに表示: 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

採用者について:
( 131件のレビュー ) 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日以内
(10レビュー)
4.8

10人のフリーランサーが、このジョブに平均$202で入札しています

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日以内
(145件のレビュー)
7.2
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
$155 USD 1日以内
(50件のレビュー)
5.7
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日以内
(31件のレビュー)
5.3
AlexandrUKR

please clarify possible next steps

$250 USD 20日以内
(12件のレビュー)
4.3
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日以内
(3件のレビュー)
3.2
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件のレビュー)
1.9
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