Find Jobs
Hire Freelancers

Create application to download CSV from web API and process information inside CSV for telephone calls

$250-750 NZD

クローズ
投稿日: 7年以上前

$250-750 NZD

完了時にお支払い
We need an application that will connect to a web URL (we provide) every minute and download a list of telephone calls. It can be downloaded from the URL in CSV, JSON or XML format (up to you) The application will look for telephone calls from a pre-set list of extension sources and based on the destination numbers called, and time field, work out the cost of each call. The details will be exported as a new CSV file. This must be a windows application compatible with windows 7/8/10+ and run in the system tray We will provide documentation for the webserver API The process 1) Application launches and sits in system tray 2) Application queries server every minute using an http URL. Part of the URL is made from the current time. Eg. https://ipaddress:8443/cdrapi?format=CSV&starttime=2016-11-04T00:20:00%2B13:00&endtime=2016-11-04T00:21:00%2B13:00 The url is (YYYY)-(MM)-(DD)T(HH):(MM):(SS)%2BTIMEZONE More info for the format will come once you are ready to start the project It is an https url with a username/password and we want to ignore the certificate prompt 3) A CSV file is downloaded if any telephone calls were made in the last minute 4) The application will exporta new CSV file using the downloaded CSV file a) Ignore any calls with sources not on pre-programmed extension list b) If a call source does come from the list, it will log the Extension | Source | Destination | Date/Time | Duration| Cost c) The exported CSV is overwritten each minute if it still exists 5) Cost is calculated by using the first numbers of the destination field If the numbers match a certain pattern, the matched call cost rate is used Example extension list Extension, Source 6000, 6000 6001, 6001 6002, 6002 ... 6100, 6100 The above is a list of source extensions that will have their calls logged - all others will be ignored. Example Cost List Number Match, Rate 03, $0.50 04, $0.50 06, $0.50 09, $0.50 001, $1.00 002, $1.00 0800, $0.00 02, $1.00 If the call matches a source extension, and the destination begins with 03 and lasts for 30 seconds it will be charged the minimum rate of 0.50 for 60 seconds. On the output CSV it will log the call as $0.50 If the call matches a source extension and the destination begins with 001 and lasts for 120 seconds, it will be charged for two minutes at a rate of $1.00. On the output CSV it will log the call as $2.00 If the call matches a source extension and the destination begins with 001 and lasts for 90 seconds, it will be charged for 1.5 minutes at $1.00 per minute. On the output CSV it will log the call as $1.50 Configurable options - URL IP ADDRESS - URL TIMEZONE - COLLECTION OCCURANCE (Every 1 minute / Every 2 minutes / Every 5 minutes from startup - LIST OF SOURCE EXTENSIONS - LIST OF CALLING RATES FOR DESTINATION NUMBERS - EXPORT FOLDER\Filename
プロジェクト ID: 11970607

プロジェクトについて

8個の提案
リモートプロジェクト
アクティブ 7年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です

クライアントについて

NEW ZEALANDのフラグ
Napier, New Zealand
5.0
5
お支払い方法確認済み
メンバー登録日:9月 17, 2011

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。