astpp-tracker Mailing List for ASTPP - Open Source Voip Billing (Page 4)
Brought to you by:
darrenkw
You can subscribe to this list here.
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(14) |
Dec
(5) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2008 |
Jan
(7) |
Feb
|
Mar
|
Apr
|
May
(19) |
Jun
(3) |
Jul
(2) |
Aug
(2) |
Sep
(8) |
Oct
|
Nov
(8) |
Dec
|
2009 |
Jan
(3) |
Feb
|
Mar
(1) |
Apr
(1) |
May
(4) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2010 |
Jan
|
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
2011 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: SourceForge.net <no...@so...> - 2007-11-18 02:34:11
|
Feature Requests item #1833870, was opened at 2007-11-17 19:34 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833870&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Priority: 5 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Nobody/Anonymous (nobody) Summary: User IAX2 & SIP device management Initial Comment: Users should be able to add and remove their own IAX and SIP devices. This task depends upon Add new Close Task Close Task Additional comments about closing: Mark task 100% complete Assign to me Edit this task * Comments (7) * Related Tasks (0/0) * Notifications (4) * Reminders (0) * History Comment by Darren (dkwiebe) - Saturday, 04 November 2006, 20:50 GMT — Edit — Delete I\'ve changed my mind on this one. However, I do think that users should be able to at least list their own devices. Comment by Darren (dkwiebe) - Sunday, 21 January 2007, 09:17 GMT — Edit — Delete Who has input on this one? I'm not sure what to think. Comment by Sonia Khan (SoniaKhan) - Monday, 05 February 2007, 06:28 GMT — Edit — Delete Possible, if you are using asterisk realtime for sip and iax2. In fact we can do something bigger then this. We can ENABLE and DISABLE sip and iax2 devices, even if it has enough balance, just a little tweaking required. Let me try it first...! ;-) Comment by Darren (dkwiebe) - Wednesday, 28 February 2007, 03:27 GMT — Edit — Delete It would be nice to do this. I have an account with www.les.net. They allow you to add your own SIP and or iax2 devices. This is really handy from a customers perspective. Comment by Darren (dkwiebe) - Friday, 04 May 2007, 23:20 GMT — Edit — Delete Sonia, did you do anything with this? Comment by Sonia Khan (SoniaKhan) - Monday, 07 May 2007, 16:02 GMT — Edit — Delete No, i haven't do any development for past 2 months due to Typhoid. It has weakened my body and my sight and i am still recovering it. I hope to restart astpp development soon. BTW, i did give my beta code to Shahzad. What happened to that Shahzad? Did you test and commit it? Please reply privately on my email. Thanks. Comment by Darren (dkwiebe) - Tuesday, 08 May 2007, 00:10 GMT — Edit — Delete I'm very sorry to hear that. If there's anything we can do to assist you in your recovery please let me know. I look forward to seeing you active again. :-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833870&group_id=205663 |
From: SourceForge.net <no...@so...> - 2007-11-18 02:30:50
|
Bugs item #1800039, was opened at 2007-09-21 19:27 Message generated for change (Settings changed) made by darrenkw You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994546&aid=1800039&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed >Resolution: Rejected Priority: 8 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Aleph Communications (darrenkw) Summary: Call rating issue Initial Comment: From: Cron Daemon <ro...@si...> Date: Sep 22, 2007 1:05 AM Subject: Cron <root@de> /opt/sipa2z/scripts/astpp-fix-rate.pl To: ro...@si... Interface language is set to: en Connected to ASTPP Database! DBI:mysql:database=asterisk;host= 127.0.0.1Connected to CDR Database! Processing Uniqueid: 1190402025.14279---------------------- uniqueid: 1190402025.14279, cardno: sarwar, phoneno: 00971508035911, Userfield: FORKED disposition: ANSWERED Pricelist: itcforwarding reseller: itc SELECT * FROM routes WHERE '00971508035911' RLIKE pattern AND pricelist = 'itcforwarding' ORDER BY LENGTH(pattern) DESC pattern: ^(011|00|^)97150.* Route: United Arab Emirates-Mobile Cost: 1600 Pricelist: itcforwarding Pattern: ^(011|00|^)97150.* PATTERN: ^(011|00|^)97150.*FOUND A MATCHING PATTERN. SELECT * FROM pricelists WHERE name = 'itcforwarding' pricelistData: itcforwarding 0 1 1 0, 1600, 272, 60, 0Connect: 0 Cost: 1600 Answered: 272 Inc: 60 included: 0 AnsweredTime: 272 Included Sec: 0 Increment: 60 Total Increments: 4.53333333333333 Bill Seconds: 300 Total cost is 8000 Matching pattern is ^(011|00|^)97150.* INSERT INTO cdrs(uniqueid,cardnum,callerid,callednum,trunk,disposition,billseconds,debit,callstart,status,notes) VALUES ('HASH(0x899b24c)', ' 1190402025.14279', 'sarwar', '0427419389', 'N/A', '00971508035911', 'ANSWERED', '272', '8000.00', '0', NULL) Reseller: itc Charge 1190402025.14279 to itc---------------------- uniqueid: 1190402025.14279, cardno: itc, phoneno: 00971508035911, Userfield: FORKED disposition: ANSWERED Pricelist: xeiva reseller: SELECT * FROM routes WHERE '00971508035911' RLIKE pattern AND pricelist = 'xeiva' ORDER BY LENGTH(pattern) DESC pattern: ^(011|00|^)97150.* Route: United Arab Emirates-Mobile Cost: 1550 Pricelist: xeiva Pattern: ^(011|00|^)97150.* PATTERN: ^(011|00|^)97150.*FOUND A MATCHING PATTERN. SELECT * FROM pricelists WHERE name = 'xeiva' pricelistData: xeiva 0 1 1 0, 1550, 272, 1, 0Connect: 0 Cost: 1550 Answered: 272 Inc: 1 included: 0 AnsweredTime: 272 Included Sec: 0 Increment: 1 Total Increments: 272 Bill Seconds: 272 Total cost is 7026.66666666667 Matching pattern is ^(011|00|^)97150.* INSERT INTO cdrs(uniqueid,cardnum,callerid,callednum,trunk,disposition,billseconds,debit,callstart,status,notes) VALUES ('HASH(0x899b24c)', '1190402025.14279 ', 'itc', '0427419389', 'N/A', '00971508035911', 'ANSWERED', '272', '7026.67', '0', NULL) Reseller: SELECT id FROM cdrs WHERE uniqueid = '1190402025.14279 ' AND cardnum = 'sarwar' LIMIT 1 SELECT id,debit,credit FROM cdrs WHERE uniqueid = '1190402025.14279' AND cardnum = 'itc' LIMIT 1 Use of uninitialized value in subtraction (-) at /usr/local/astpp/astpp- common.pl line 3865. Use of uninitialized value in subtraction (-) at /usr/local/astpp/astpp-common.pl line 3865. Use of uninitialized value in concatenation (.) or string at /usr/local/astpp/astpp-common.pl line 3866. UPDATE cdrs SET cost = 0 WHERE id = AND callednum = '00971508035911' DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND callednum = '00971508035911'' at line 1 at /usr/local/astpp/astpp- common.pl line 3870. ---------------------------------------------------------------------- Comment By: Aleph Communications (darrenkw) Date: 2007-11-17 19:29 Message: Logged In: YES user_id=1227065 Originator: YES This was caused by your database not having a uniqueid tagged to each call. I'm closing it. ---------------------------------------------------------------------- Comment By: Aleph Communications (darrenkw) Date: 2007-11-03 16:34 Message: Logged In: YES user_id=1227065 Originator: YES I believe this was caused by your system not writing the uniqueids to the database. If so this is not an astpp bug. ---------------------------------------------------------------------- Comment By: Aleph Communications (darrenkw) Date: 2007-10-31 23:20 Message: Logged In: YES user_id=1227065 Originator: YES I'm not sure what's going on with this issue. Is it still happening? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994546&aid=1800039&group_id=205663 |
From: SourceForge.net <no...@so...> - 2007-11-18 02:30:03
|
Bugs item #1800039, was opened at 2007-09-21 19:27 Message generated for change (Comment added) made by darrenkw You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994546&aid=1800039&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 8 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Aleph Communications (darrenkw) Summary: Call rating issue Initial Comment: From: Cron Daemon <ro...@si...> Date: Sep 22, 2007 1:05 AM Subject: Cron <root@de> /opt/sipa2z/scripts/astpp-fix-rate.pl To: ro...@si... Interface language is set to: en Connected to ASTPP Database! DBI:mysql:database=asterisk;host= 127.0.0.1Connected to CDR Database! Processing Uniqueid: 1190402025.14279---------------------- uniqueid: 1190402025.14279, cardno: sarwar, phoneno: 00971508035911, Userfield: FORKED disposition: ANSWERED Pricelist: itcforwarding reseller: itc SELECT * FROM routes WHERE '00971508035911' RLIKE pattern AND pricelist = 'itcforwarding' ORDER BY LENGTH(pattern) DESC pattern: ^(011|00|^)97150.* Route: United Arab Emirates-Mobile Cost: 1600 Pricelist: itcforwarding Pattern: ^(011|00|^)97150.* PATTERN: ^(011|00|^)97150.*FOUND A MATCHING PATTERN. SELECT * FROM pricelists WHERE name = 'itcforwarding' pricelistData: itcforwarding 0 1 1 0, 1600, 272, 60, 0Connect: 0 Cost: 1600 Answered: 272 Inc: 60 included: 0 AnsweredTime: 272 Included Sec: 0 Increment: 60 Total Increments: 4.53333333333333 Bill Seconds: 300 Total cost is 8000 Matching pattern is ^(011|00|^)97150.* INSERT INTO cdrs(uniqueid,cardnum,callerid,callednum,trunk,disposition,billseconds,debit,callstart,status,notes) VALUES ('HASH(0x899b24c)', ' 1190402025.14279', 'sarwar', '0427419389', 'N/A', '00971508035911', 'ANSWERED', '272', '8000.00', '0', NULL) Reseller: itc Charge 1190402025.14279 to itc---------------------- uniqueid: 1190402025.14279, cardno: itc, phoneno: 00971508035911, Userfield: FORKED disposition: ANSWERED Pricelist: xeiva reseller: SELECT * FROM routes WHERE '00971508035911' RLIKE pattern AND pricelist = 'xeiva' ORDER BY LENGTH(pattern) DESC pattern: ^(011|00|^)97150.* Route: United Arab Emirates-Mobile Cost: 1550 Pricelist: xeiva Pattern: ^(011|00|^)97150.* PATTERN: ^(011|00|^)97150.*FOUND A MATCHING PATTERN. SELECT * FROM pricelists WHERE name = 'xeiva' pricelistData: xeiva 0 1 1 0, 1550, 272, 1, 0Connect: 0 Cost: 1550 Answered: 272 Inc: 1 included: 0 AnsweredTime: 272 Included Sec: 0 Increment: 1 Total Increments: 272 Bill Seconds: 272 Total cost is 7026.66666666667 Matching pattern is ^(011|00|^)97150.* INSERT INTO cdrs(uniqueid,cardnum,callerid,callednum,trunk,disposition,billseconds,debit,callstart,status,notes) VALUES ('HASH(0x899b24c)', '1190402025.14279 ', 'itc', '0427419389', 'N/A', '00971508035911', 'ANSWERED', '272', '7026.67', '0', NULL) Reseller: SELECT id FROM cdrs WHERE uniqueid = '1190402025.14279 ' AND cardnum = 'sarwar' LIMIT 1 SELECT id,debit,credit FROM cdrs WHERE uniqueid = '1190402025.14279' AND cardnum = 'itc' LIMIT 1 Use of uninitialized value in subtraction (-) at /usr/local/astpp/astpp- common.pl line 3865. Use of uninitialized value in subtraction (-) at /usr/local/astpp/astpp-common.pl line 3865. Use of uninitialized value in concatenation (.) or string at /usr/local/astpp/astpp-common.pl line 3866. UPDATE cdrs SET cost = 0 WHERE id = AND callednum = '00971508035911' DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND callednum = '00971508035911'' at line 1 at /usr/local/astpp/astpp- common.pl line 3870. ---------------------------------------------------------------------- >Comment By: Aleph Communications (darrenkw) Date: 2007-11-17 19:29 Message: Logged In: YES user_id=1227065 Originator: YES This was caused by your database not having a uniqueid tagged to each call. I'm closing it. ---------------------------------------------------------------------- Comment By: Aleph Communications (darrenkw) Date: 2007-11-03 16:34 Message: Logged In: YES user_id=1227065 Originator: YES I believe this was caused by your system not writing the uniqueids to the database. If so this is not an astpp bug. ---------------------------------------------------------------------- Comment By: Aleph Communications (darrenkw) Date: 2007-10-31 23:20 Message: Logged In: YES user_id=1227065 Originator: YES I'm not sure what's going on with this issue. Is it still happening? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994546&aid=1800039&group_id=205663 |
From: SourceForge.net <no...@so...> - 2007-11-18 00:42:02
|
Feature Requests item #1833840, was opened at 2007-11-17 17:42 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833840&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface Improvements Group: None Status: Open Priority: 5 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Nobody/Anonymous (nobody) Summary: Web Administration Initial Comment: Web based management and user interface for provisioning and also for customers to check balance and cdrs etc. calling card resellers and distributors should be able to login from oscommerce, and print cards (after purchase) on a slip (credit card like) Comment by Wasim Baig (wasim) - Sunday, 21 January 2007, 07:46 GMT This should be done. Needs pretty icons and stuff but the basics are there. Comment by Wasim Baig (wasim) - Friday, 02 February 2007, 18:10 GMT http://tango.freedesktop.org/Tango_Icon_Gallery for icons Comment by Wasim Baig (wasim) - Friday, 02 February 2007, 20:33 GMT With AJAX to improve the user experience and speed up, as well as make it asynchronous, I think an interface similar to that of vtiger (just an example should work) .. the header row should have (logo on left, current page in hierarchy, logged in (username) logged in time, ip/hostname, possibly a tickettape rss feed to update users on system wide status, news etc) preferences | help | logout (wasim 17:04) | search second row should have the main menus, onClick, the third row should open with horizontal sub-menus, on mouseover, just show the menu as currently on third row, show the current position in the menu structure in BOLD, then the commonly done tasks for this (we might need to revisit the interface spec for this), quick rate call, add, delete a single button for one popup with ALL MENUS the bottom header info should have corporate details a link should be to ASTPP - 100% open source billing as well as disclaimer, page creation time astpp version info, system host information Comment by Darren (dkwiebe) - Thursday, 07 June 2007, 00:05 GMT I think that most of this could be done in the templates. What do you think? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833840&group_id=205663 |
From: SourceForge.net <no...@so...> - 2007-11-18 00:39:22
|
Bugs item #1833839, was opened at 2007-11-17 17:39 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994546&aid=1833839&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Nobody/Anonymous (nobody) Summary: Card Deletion requires dial attempt Initial Comment: when you enter a pin thats expired, this is what happens, == astpp-callingcards.agi|||||: CARD BRAND: pakistantoday SPECIFIED BRAND: == astpp-callingcards.agi|||||: ASTPP Number: 9651972264734 == astpp-callingcards.agi|||||: ASTPP Number Status: 1 -- Playing 'silence/1' (language 'en') -- Playing 'silence/1' (language 'en') == astpp-callingcards.agi|||||: Present Time: 20070816050734.000000 == astpp-callingcards.agi|||||: Expiration Date: 2007-08-15 18:03:08 == astpp-callingcards.agi|||||: Valid for Days: 30 == astpp-callingcards.agi|||||: First Use: 2007-07-16 18:03:08 == astpp-callingcards.agi|||||: UPDATE callingcards SET status = 2 WHERE cardnumber = '9651972264734' == astpp-callingcards.agi|||||: DELETE FROM ani_map WHERE account = '9651972264734' and you get a good-bye announcement, (followed by please enter your pin number and the cycle continues and never ends, thats a separate issue, we can fix that). I think a cron should be doing this == astpp-callingcards.agi|||||: Present Time: 20070816050734.000000 == astpp-callingcards.agi|||||: Expiration Date: 2007-08-15 18:03:08 == astpp-callingcards.agi|||||: Valid for Days: 30 == astpp-callingcards.agi|||||: First Use: 2007-07-16 18:03:08 == astpp-callingcards.agi|||||: UPDATE callingcards SET status = 2 WHERE cardnumber = '9651972264734' == astpp-callingcards.agi|||||: DELETE FROM ani_map WHERE account = '9651972264734' rather than wait for the caller to dial the pin again, what do you suggest ? Comment by Darren (dkwiebe) - Thursday, 06 September 2007, 05:27 GMT This has been coded and committed to svn. de astpp-callingcards # svn commit Sending astpp-update-balance.pl Transmitting file data . Committed revision 2121. de astpp-callingcards # ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994546&aid=1833839&group_id=205663 |
From: SourceForge.net <no...@so...> - 2007-11-18 00:37:35
|
Feature Requests item #1833838, was opened at 2007-11-17 17:37 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833838&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Priority: 5 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Nobody/Anonymous (nobody) Summary: Alert customer on account fill Initial Comment: A call has to go to the customer (based on the Dialstring) to announce his balance after every account top up. This should be an option set by the admin/reseller for each account Comment by Darren (dkwiebe) - Saturday, 22 September 2007, 03:07 GMT Are you sure this one is necessary? If you are then please close this ticket and open one one sourceforge and we'll discuss it there. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833838&group_id=205663 |
From: SourceForge.net <no...@so...> - 2007-11-18 00:35:37
|
Feature Requests item #1833836, was opened at 2007-11-17 17:35 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833836&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface Improvements Group: None Status: Open Priority: 5 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Nobody/Anonymous (nobody) Summary: Web Based Self Care Initial Comment: Web based self care for recharging card , change pin , manage ani/caller id , call summary report , statements/reports, change language etc ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833836&group_id=205663 |
From: SourceForge.net <no...@so...> - 2007-11-18 00:34:22
|
Feature Requests item #1833835, was opened at 2007-11-17 17:34 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833835&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface Improvements Group: None Status: Open Priority: 5 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Nobody/Anonymous (nobody) Summary: Invoicing Support Initial Comment: Invoices need to be generated and call details 1. viewable on website, archived 2. emailed at specified interval per account Comment by Darren (dkwiebe) - Sunday, 09 September 2007, 01:50 GMT This is basically done using the oscommerce link. The only issue is that we don't actually email the customer the invoice. Instead we email them a notification that the invoice has been added to their account. Comment by Darren (dkwiebe) - Saturday, 22 September 2007, 02:56 GMT Is this sufficient? Did you need more? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994549&aid=1833835&group_id=205663 |