our customers (residential internet access users) have broadband connection through our network. we would like to limit the download to 6 GB per month. But if they have money on the pre-paid account (coming in via cash or pre-paid cards) we will bill i.e. 2 USD per GB (after the 6GB). We are importing usage data as monthly bandwidth used in GB. This is just a number, for instance 8.Allowed bandwidth per moth is 6 GB per customer. We set up a product called BANDWIDTH with price=2, qty=1 with the intention to bill 2 USD per each extra GB the customer has used. this works fine, billing and invoicing are ok. BUT... We would like to give extra bandwidth JUST if customer has money on his pre-pay account (so no negative balance due is accepted). We need to set an action that, in case of no positive balance due (this include also tha case where the customer dont use the pre-paid system, because 6GB is ok for him) will change the pppoe profile on the mysql. In this way, we stop the traffic and the balance due can just be negative for the delay of the data importing, but would not be significant for us. how can we do it? thanks Gianluca
There isn't a mechanism within Optigold to do it, you probably would need to write an external script that polls the Optigold data and does whatever you need to do in your scenario.
sorry Swan, another thing I dont understand. If it is a prepaid system and we would like to use just this system, we should have an option that a customer cannot buy if it has no money on the account. for instance if it is a one-time product .... G
Yes, you can get at through SQL or XML. No, because the prepaid cards are a form of payment, so in theory they could purchase anything (for example they could purchase a $40 product and pay for it with 2 $20 prepaid cards).
<<Yes, you can get at through SQL or XML. thanks again, we will work on it. how can the sql retreive such information, where to point on the OG? <<No, because the prepaid cards are a form of payment, so in theory they could <<purchase anything (for example they could purchase a $40 product and pay <<for it with 2 $20 prepaid cards). of course, but if we decide to give no "credit" to the customers... if one purchases a 404 worth product and just have 20 on the account .... probably in any case of purchase we need to DO the check before releasing the product. and this again from an external application that before all checks the balance of the client in that moment. so again the same question, where/how to retreive such an information from the OG? ciao G
The customer should only be credited with the product once it's actually paid for (and the invoice closed). For ODBC and XML, you will need to set it up as a data source in FileMaker (see the FileMaker user's guide for more info on that).