Re: [asterisk-biz] Excel php import library for rate sheets?

2013-07-25 Thread Bruce Ferrell

On 07/24/2013 07:23 AM, Gerrit Jacobsen wrote:

Hello

Is anyone aware of a php library to automate the import of carrier rate sheets?

I see that there exists PHPExcel which can handle Excel spreadsheets.
Ideally the library should provide the possibility to use import templates so 
that recurring imports can be largely automated.

Any hints are greatly welcome

Cheers

Gerry




Gerry,

Unfortunately the answer to your question is a question... Import into what?

Asterisk all by itself doesn't know anything about rates/costs or charges.

It DOES know how to process calls and generate call records.

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


[asterisk-biz] religious arguments and billing systems

2011-07-18 Thread Bruce Ferrell

Folks,

I've been a Linux systems professional since 1993.  I've been a 
telecommunications professional since 1980; a veteran of Western Union 
and MCI.  I've worked with just about every major Linux distribution and 
many non Linux *IX platforms. I have made very specific engineering 
decisions for my systems as a result of my experience.  In all those 
years one refrain I've heard from as a dull drum beat from developers is 
that if you pay me, you can complain/ask for extras.


Well, I find myself in the position of both being able and willing to 
pay for support... Only to find that the developers now want to only 
support if they can re-engineer my systems.  I even had one vendor 
collect money for three months before telling he was unsure if or when 
he would be able to support me, but if I was willing to pay extra for 
development, it might accelerate what I needed.  Needless to say, I 
declined the extortion and got my money back.


I'm not asking for asterisk or billing  on windows.  I'm not willing to 
put in windows... Nor am I willing to put in Debian or Ubuntu.  I place 
all three in the same class... the toy of the day.  I won't debate this 
but I will discuss it off list if you're so inclined.


I have a working Asterisk system.  it IS generating revenue.  I need to 
be able for my non-technical staff to be able to operate and provision 
it.  I have installed a2billing and approached it's commercial entity 
for training only to have my request avoided.  I mention them by name 
only because this venue gave them such a high recommendation only to 
disappoint me again.


So, now I ask... Is there any vendor that is willing and competent to 
provide support for a fee without trying to re-engineer my system?Do 
notice, I said for a fee.  Not free.  I am pursuing this line of inquiry 
as well as others.  BTW, no, I will not be putting in freeswitch, SER or 
other similar solutions at this time.  I have a very specific task that 
needs accomplished and am willing to pay a reasonable amount to get there.




--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [asterisk-biz] religious arguments and billing systems

2011-07-18 Thread Bruce Ferrell


The short for what I need is the following

1.)   CDR rating/invoicing
1a.) profitability reporting
   # someone told me I needed LCR for this.  I want reporting on what 
calls are costing me, not route changes.

1b.) Call cutoff on low balance
2.)   Not currently necessary, but something I am thinking about is SIP 
endpoint provisioning (hardphone) integrated into the items above.


I need the functions integrated into my existing asterisk dial plan, 
which is maybe 30 lines.


I use asterisk realtime to maintain as much of my asterisk configuration 
as possible with the idea in mind that will allow me to grow the system 
without managing a lot of files on multiple systems.  That said, I am 
just one server at this point and bottle necked in call 
rating/invoicing/account balance cutoff.


I was told it was possible with a2billing but I don't see a clear 
document on how a2billing works so I don't quickly see how to hook it in.


Bruce Ferrell - President
Ferrell Systems Engineering, Inc.

On 07/18/2011 10:54 AM, Nitzan Kon wrote:

Bruce,

It would be helpful if you posted what it is exactly that you
need done. A2Billing is a great billing system if you are the
DIY type and can modify it - or you have someone on your team
who can. It's actually one of the easiest billing systems to
modify which is exactly what makes it so powerful.

--- On Mon, 7/18/11, Bruce Ferrellbferr...@baywinds.org  wrote:


Folks,

I've been a Linux systems professional since 1993. 
I've been a telecommunications professional since 1980; a

veteran of Western Union and MCI.  I've worked with
just about every major Linux distribution and many non Linux
*IX platforms. I have made very specific engineering
decisions for my systems as a result of my experience. 
In all those years one refrain I've heard from as a dull

drum beat from developers is that if you pay me, you can
complain/ask for extras.

Well, I find myself in the position of both being able and
willing to pay for support... Only to find that the
developers now want to only support if they can re-engineer
my systems.  I even had one vendor collect money for
three months before telling he was unsure if or when he
would be able to support me, but if I was willing to pay
extra for development, it might accelerate what I
needed.  Needless to say, I declined the extortion and
got my money back.

I'm not asking for asterisk or billing  on
windows.  I'm not willing to put in windows... Nor am I
willing to put in Debian or Ubuntu.  I place all three
in the same class... the toy of the day.  I won't
debate this but I will discuss it off list if you're so
inclined.

I have a working Asterisk system.  it IS generating
revenue.  I need to be able for my non-technical staff
to be able to operate and provision it.  I have
installed a2billing and approached it's commercial entity
for training only to have my request avoided.  I
mention them by name only because this venue gave them such
a high recommendation only to disappoint me again.

So, now I ask... Is there any vendor that is willing and
competent to provide support for a fee without trying to
re-engineer my system?Do notice, I said for a
fee.  Not free.  I am pursuing this line of
inquiry as well as others.  BTW, no, I will not be
putting in freeswitch, SER or other similar solutions at
this time.  I have a very specific task that needs
accomplished and am willing to pay a reasonable amount to
get there.



--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-biz





--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


[asterisk-biz] Wanted: Asterisk billing system

2011-06-13 Thread Bruce Ferrell

Hello,

I'm looking for information regarding vendors of billing systems for 
asterisk.


I would like to have something for which support is available, is linux 
based, is distribution agnostic... No not agnostic, I am strongly 
opposed to debian and ubuntu based systems and vendors.


I need both pre-paid (with cutoff) and post paid models.

Bruce Ferrell


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [asterisk-biz] Wanted: Asterisk billing system

2011-06-13 Thread Bruce Ferrell



On 06/13/2011 11:52 AM, Shamsul Arefin wrote:


Have a look at WWW.a2billing.org http://WWW.a2billing.org
They do provide commercial support and will meet your requirment

Regards
Shams

On Jun 14, 2011 4:50 AM, Bruce Ferrell bferr...@baywinds.org 
mailto:bferr...@baywinds.org wrote:

 Hello,

 I'm looking for information regarding vendors of billing systems for
 asterisk.

 I would like to have something for which support is available, is linux
 based, is distribution agnostic... No not agnostic, I am strongly
 opposed to debian and ubuntu based systems and vendors.

 I need both pre-paid (with cutoff) and post paid models.

 Bruce Ferrell


Shams,

I visited their web site and it seems that they prefer to install to an 
Ubuntu system.  No go, automatically.


Bruce Ferrell
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz

Re: [asterisk-biz] Wanted: Asterisk billing system

2011-06-13 Thread Bruce Ferrell
Thanks for the pointer.  I do have the expertese.  I've been a linux 
professional since the days of Yggrasil


Bruce F  :)

On 06/13/2011 12:55 PM, Bruce B wrote:
A2billing runs well on Redhat or any Linux based system with support 
for php, asterisk, etc


If you don't have the time to learn the installation or lack 
the expertise I suggest:

http://a2billing2asterisk.googlepages.com

Once you get it running, it's a nobrainer.

Unfortunately, there is not much choice when it comes to billing for 
Asterisk.


-Bruce



On Mon, Jun 13, 2011 at 3:32 PM, Bruce Ferrell bferr...@baywinds.org 
mailto:bferr...@baywinds.org wrote:




On 06/13/2011 11:52 AM, Shamsul Arefin wrote:


Have a look at WWW.a2billing.org http://WWW.a2billing.org
They do provide commercial support and will meet your requirment

Regards
Shams

On Jun 14, 2011 4:50 AM, Bruce Ferrell bferr...@baywinds.org
mailto:bferr...@baywinds.org wrote:
 Hello,

 I'm looking for information regarding vendors of billing
systems for
 asterisk.

 I would like to have something for which support is available,
is linux
 based, is distribution agnostic... No not agnostic, I am strongly
 opposed to debian and ubuntu based systems and vendors.

 I need both pre-paid (with cutoff) and post paid models.

 Bruce Ferrell


Shams,

I visited their web site and it seems that they prefer to install
to an Ubuntu system.  No go, automatically.

Bruce Ferrell

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-biz



--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-biz


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz

[asterisk-biz] Innomedia devices available

2011-04-21 Thread Bruce Ferrell

Hi,

After winding up a project I find myself with a moderate number of 
Innomedia VoIP phones and ATA type devices I'd like to sell.  Most are 
still unopened in the box with the factory accessory set.


Please contact me off list for more information

Bruce Ferrell



--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [asterisk-biz] Re: Linksys SPA400

2006-08-14 Thread Bruce Ferrell
The GPL source tarball was released last week and it seems to include 
Asterisk.  You tell me if it's hackable :)


shadowym wrote:

Cool product!

So does anyone know what the echo cancellation is like?  It says G168 but
that does not give any indication of quality.  If it is basically a 4 port
version of the SPA3000 internally then that tells me all I need to know.  


Where does this stand with respect to an Asterisk server with a Sangoma+ HW
echo can card?

On a further tangent, I wonder if this could be integrated with Asterisk for
the 4xFXO.  The firmware is open source.  I see that it runs a linux 2.4
kernel and someone on the voip wiki suggested it is running Asterisk.  I
could not conclude that from the source code myself but I didn't look too
deep.

-Original Message-
From: Lonnie Lazar [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 12, 2006 5:00 PM
To: asterisk-biz@lists.digium.com
Subject: [asterisk-biz] Re: Linksys SPA400

Dome C.:

Please see http://store.voxilla.com/customer/product.php? 
productid=16235cat=274page=1

Feel free to contact me off-list with any questions.
--
Lonnie Lazar
Voxilla Sales
[EMAIL PROTECTED]
http://www.voxilla.com
http://store.voxilla.com



Message: 7
Date: Sat, 12 Aug 2006 20:57:48 +0700
From: Dome C. [EMAIL PROTECTED]
Subject: [asterisk-biz] Linksys SPA400
To: Commercial and Business-Oriented Asterisk Discussion
asterisk-biz@lists.digium.com
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=TIS-620; format=flowed

Dear all.

Want to buy Linksys SPA400 1 box for test. Please send me price

Dome C.



--







___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz



--
One day at a time, one second if that's what it takes

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [asterisk-biz] Reliable GUI for Asterisk (don't mention FreePBXplease)

2006-07-21 Thread Bruce Ferrell

No I havent tried them yet

http://www.intuitivecreations.com/contributions/AMS/

http://astguiclient.sourceforge.net/

[EMAIL PROTECTED] wrote:

Zeeshan,

Please find the first fully functional GUI to work with Asterisk and
still
the most advanced :

http://www.bicomsystems.com/products/online_demo/

Documented and supported.



The docs for PBXware are available in HTML, PDF and E-Book formats:
http://www.bicomsystems.com/docs/pbxware/1.8/

The complete guidance for supported devices:
http://www.bicomsystems.com/docs/uad/

PBXware comes with OPCOM - MS windows based operator panel:
http://www.bicomsystems.com/docs/opcom/1.0/

It also includes outCALL... Outlook integration for each end user:
http://www.bicomsystems.com/docs/outcall/1.0/



Senad








___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz



--
One day at a time, one second if that's what it takes

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [asterisk-biz] Selling the source code for asterisk callcentersolution

2006-05-24 Thread Bruce Ferrell
Unfortunately, copyright (GPL) has nothing to do with patents.  G729 and 
G723 are patented codecs and Digium has to pay licensing fees to be able 
to use them without regard to the source of the code that implement 
them.  get a clue.


Michael Workman wrote:
You ask EVERYONE to make all there work and effort Open Source cause you 
don't want to pay.
But if we follow the Rules according to GPL... then Why the Hell is had 
not Digium made the g729 and g723.1 Codec's open source...
 
it was written on code from asterisk... for it Should be open source 
according to GPL... So in Short I don't think people should demand 
that people make there software open source UNTIL Digium Makes G729 and 
G723 Open source...
 
Until they do... Asterisk's GPL Has not Got a Pot to piss in...
 
 
 



From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Houser

Sent: Wednesday, May 24, 2006 1:29 PM
To: 'Commercial and Business-Oriented Asterisk Discussion'
Subject: RE: [asterisk-biz] Selling the source code for asterisk 
callcentersolution


  I agree.
 
  In the spirit the open source your project could not have gotten off 
the ground without the efforts it took build Asterisk.  Take your hard 
work, release it under GPL, and you will benefit from those who look to 
implement it. 
 
  Or, go the route you are asking and it may rot since the marketplace 
of someone buying it just to remarket it will be small.  At best you're 
going to get low ball offers that will insult your hard work efforts.
 
  Also, read the trades, open source is exploding in both small and 
large corporations.  Your potential market for support would provide a 
return much larger than a one time sale...
 
Good luck with your project.
 

From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Ignacio Ramos

Sent: Wednesday, May 24, 2006 11:26 AM
To: Commercial and Business-Oriented Asterisk Discussion
Subject: Re: [asterisk-biz] Selling the source code for asterisk call 
centersolution


Patrick:

Leave it for the open source, under the GPL, just like Asterisk, and 
sell your services installing it, improving it, all over the world


That is an option.

cheers

On 5/24/06, Erick Perez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
wrote:


Hi patrick, please contact me at:
eaperezh (at) gmail (dot) com
and since im overseas please provide me with your phone number to
call you.
Any screenshots and documentation?


On 5/24/06, Patrick kemac  [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
 
 
  Hello
  We have developed CRM for call center based on asterisk (Inbound and
  Outbound) as school project.
  We would like to sell the application (source code and
documentation for
  anyone who is interested in
  commercializing the CRM.
  Please contact me for details
  Features implemented
  · Outbound dialing and intelligent inbound call routing
  · Digital quality live monitoring and recording
  · Web-based real-time remote monitoring and management
  · Network and multi-site management and view from a single location
  · Seamless compatibility with non-IP legacy systems
  · Secure and user-friendly graphical user interface (GUI)
  · Scalable – unlimited number of agents
 
  Waiting for replies
  ___
  --Bandwidth and Colocation provided by Easynews.com
http://Easynews.com --
 
  asterisk-biz mailing list
  To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-biz
 
 
 


--

---
Erick Perez
Linux User 376588
http://counter.li.org/ http://counter.li.org/  (Get counted!!!)
Panama, Republic of Panama
___
--Bandwidth and Colocation provided by Easynews.com
http://Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz


This e-mail and any attachments may contain confidential and privileged 
information. If you are not the intended recipient, please notify the 
sender, or [EMAIL PROTECTED], immediately by return e-mail 
and destroy any copies. Any dissemination or use of this information by 
a person other than the intended recipient is unauthorized and may be 
illegal. Unless otherwise stated, opinions expressed in this e-mail are 
those of the author and are not endorsed by the author's employer.





___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   

[asterisk-biz] SPA9000

2006-03-02 Thread Bruce Ferrell

Anyone seen one of these?

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [asterisk-biz] T1 Y cable

2006-02-28 Thread Bruce Ferrell

you're right.  they don't exist

Herman Webley wrote:

Greeetings all,

Where can I buy one of those T1 'y' cables that will allow me to connect
two asterisk boxes (via PRI cards) to a single PRI for redundancy (just
one actually uses the PRI, the other monitors the other server using
linux HA).

Or am I mistaken and these connectors don't really exist?

Best regards,
Herman Webley

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz



--
One day at a time, one second if that's what it takes

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [Asterisk-biz] Modem Over IP: solutions ?

2005-10-22 Thread Bruce Ferrell
depending on the alarm datalink speed, you should be able to use G711 on 
just about any ATA or IAD type device. PSK modulations will be more 
suseptable to jitter.  Usually alarm circuits are FSK under 1200 BPS so 
they should make it fine.


Jean-Michel Hiver wrote:

Hi,

I have a potential client who has legacy alarm systems which use modems 
to transmit encoded data to a remote location through the PSTN. They 
wish to replace the 'PSTN' bit with an IP link.


I am aware that it would be best if the data was transmitted directly 
over IP rather than modulated and then sent on the internet, but that is 
not possible because of the legacy equipment.


I was wondering if there was some specialized ATAs of some kind that 
would do TDMoIP and which could be used for this purpose?


Link latency is about 300ms with no more than 10ms jitter. If you have a 
solution please let me know!


Cheers,
Jean-Michel.

___
Asterisk-Biz mailing list
Asterisk-Biz@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-biz


___
Asterisk-Biz mailing list
Asterisk-Biz@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [Asterisk-biz] Asterisk Ffork - OpenPBX.org

2005-10-11 Thread Bruce Ferrell

trixter http://www.0xdecafbad.com wrote:

On Tue, 2005-10-11 at 22:46 +1300, Matt Riddell wrote:


Eh?!

So you think that France Telecom hasn't assigned SipPro to handle the
licencing for Europe?




What specifically are they gonna license?  That specific code or the
g.729 codec itself?  Were software patents in the EU recently voted to
be invalid?  That means that they can license a specific bit of code but
not the method for that code, which means that a 3rd party can write
their own g.729 codec and release that without paying the per seat
patent fee.

Unless that was just a dream I had a few months ago, which is just as
likely.



It's not the code itself which is patented... It's the G.729 algorithms 
  so any implementation of them requires a license.

___
Asterisk-Biz mailing list
Asterisk-Biz@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [Asterisk-biz] Asterisk Ffork - OpenPBX.org

2005-10-08 Thread Bruce Ferrell

Dinesh Nair wrote:

   -- 8 snippage 8 --



perhaps a rewrite of a GPLed H.323 stack is in order, then this whole 
thing will go away.




That would be a not very fun thing to do...  First you have to do a 
GPL'd ASN1 compiler.  I tried once a few years back.  My head STILL hurts!

___
Asterisk-Biz mailing list
Asterisk-Biz@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-biz


Re: [Asterisk-biz] PAP2-NA New or Used

2005-09-28 Thread Bruce Ferrell

Website says you have to order 5 or they cancel your order :(

Danny Froberg wrote:
Check with Cory  Co at voipsupply.com, I think they stacked up a bunch 
of these.


/Danny

Michael Blood wrote:

Does anyone have any PAP2-NA available for sale.  I konw they are on 
back order everywhere but I thought I would send out a quick question.
 
You can reply to me directly at

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
Thanks
 
Michael Blood





___
Asterisk-Biz mailing list
Asterisk-Biz@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-biz



___
Asterisk-Biz mailing list
Asterisk-Biz@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-biz


___
Asterisk-Biz mailing list
Asterisk-Biz@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-biz