[Citrusdb-users] Credit Card handling

[liran tal]

Hi,

I went over the FAQ, the online documentation and the Mailing List hosted on
SF
but I wasn't able to conclude how and if Credit Cards are processed and how
are they handled.

I've installed citrusdb and I'm wondering if a new customer that is billed
not via cash or check,
but rather using a credit card, how is the billing done? is it
possible/needed to configure
citrusdb with an interface to an online cc processing system like
authorize.net, paypal and others?


A clarification on this subject would be nice,
thanks.


Regards,
Liran.

[Paul Yasi]

Credit cards are exported to a batch file, then that file would be
processed by a credit card processor such as authorize.net, paypal, or
a uploaded to a regular merchant account.

There are a number of different formats that are sent to credit card
processors, so citrusdb just exports a simple comma delimited format,
if the credit card processor does not take a simple format like that,
it's up to you to change it into the batch format your credit card
company processes. Different processors have different codes for
charges, refunds, and indicators for different card types.

Paul

Post by liran tal
Hi,
I went over the FAQ, the online documentation and the Mailing List hosted on
SF
but I wasn't able to conclude how and if Credit Cards are processed and how
are they handled.
I've installed citrusdb and I'm wondering if a new customer that is billed
not via cash or check,
but rather using a credit card, how is the billing done? is it
possible/needed to configure
citrusdb with an interface to an online cc processing system like
authorize.net, paypal and others?
A clarification on this subject would be nice,
thanks.
Regards,
Liran.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[liran tal]

Hey Paul,

Post by Paul Yasi
Credit cards are exported to a batch file, then that file would be
processed by a credit card processor such as authorize.net, paypal, or
a uploaded to a regular merchant account.

So there's a regular batch export of all credit cards that are to be billed
every x time, then the batch file is to be imported by the operator to
online merchant accounts. This far I understand.

Was any of the online cc processors been tested like authorize.net
or paypal? to accept the format that citrusdb exports?

And another question if you will... :-)
I haven't seen any support for radius (freeradius) provisioning, for
example, when
creating a new customer in citrusdb it will also create a radius account
profile
(this is usually done via a database backend such as mysql).
I totally understand that this is a more specific requirement and that
citrusdb
was probably not founded with these ideas in mind but is it possible to
integrate such functionality using a plugin maybe?
I can describe more in depth what kind of provisioning tasks are required.


Regards,
Liran.

[Paul Yasi]

There is the Activate Accounts tool which simply creates a list of
accounts to ADD, DELETE, ENABLE and DISABLE. The format is specified
in the help.html file. That format could then be imported into a
script that actually talks to a radius server to perform those
actions. There is no module that connects to radius directly though.

Paul

Post by liran tal
Hey Paul,

Post by Paul Yasi
Credit cards are exported to a batch file, then that file would be
processed by a credit card processor such as authorize.net, paypal, or
a uploaded to a regular merchant account.

So there's a regular batch export of all credit cards that are to be billed
every x time, then the batch file is to be imported by the operator to
online merchant accounts. This far I understand.
Was any of the online cc processors been tested like authorize.net
or paypal? to accept the format that citrusdb exports?
And another question if you will... :-)
I haven't seen any support for radius (freeradius) provisioning, for
example, when
creating a new customer in citrusdb it will also create a radius account
profile
(this is usually done via a database backend such as mysql).
I totally understand that this is a more specific requirement and that
citrusdb
was probably not founded with these ideas in mind but is it possible to
integrate such functionality using a plugin maybe?
I can describe more in depth what kind of provisioning tasks are required.
Regards,
Liran.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[liran tal]

Hey Paul,

There's actually no need to talk the RADIUS protocol but rather to
talk databases-language. This is because most implementations of a
RADIUS server if not all (for an ISP deployment) are using a database
backend such as MySQL, PostgreSQL or others.

The (free)RADIUS server reads its information based on tables in the
database which include the username, password and possibly other
RADIUS attributes information.

This makes it easy then to integrate between CitrusDB and a RADIUS/Database
server if you say that there's a trigger that can launch a script and pass
to it
the necessary values to "provision" a new user in the RADIUS - provision,
meaning
that the script will create a new database record for the user, and that's
it actually.

What do you think?

I am the author of daloRADIUS which is a web management application to
administer a RADIUS installation and Hotspots deployment. I do not wish
to include a billing part in daloRADIUS as it's a job for experts and there
are better solutions like CitrusDB which do a good job.
I am more than interested in seeing this integration process between
CitrusDB
and daloRADIUS or actually the database servers with a RADIUS database
scheme.


I have all of the RADIUS part knowledge and I'll be happy to take this
integration process into action if you will.


References:
daloRADIUS Website - http://sourceforge.net/projects/daloradius
daloRADIUS Wiki - http://daloradius.wiki.sourceforge.net/


Regards,
Liran.

Post by Paul Yasi
There is the Activate Accounts tool which simply creates a list of
accounts to ADD, DELETE, ENABLE and DISABLE. The format is specified
in the help.html file. That format could then be imported into a
script that actually talks to a radius server to perform those
actions. There is no module that connects to radius directly though.
Paul

Post by liran tal
Hey Paul,

Post by Paul Yasi
Credit cards are exported to a batch file, then that file would be
processed by a credit card processor such as authorize.net, paypal, or
a uploaded to a regular merchant account.

So there's a regular batch export of all credit cards that are to be

billed

Post by liran tal
every x time, then the batch file is to be imported by the operator to
online merchant accounts. This far I understand.
Was any of the online cc processors been tested like authorize.net
or paypal? to accept the format that citrusdb exports?
And another question if you will... :-)
I haven't seen any support for radius (freeradius) provisioning, for
example, when
creating a new customer in citrusdb it will also create a radius account
profile
(this is usually done via a database backend such as mysql).
I totally understand that this is a more specific requirement and that
citrusdb
was probably not founded with these ideas in mind but is it possible to
integrate such functionality using a plugin maybe?
I can describe more in depth what kind of provisioning tasks are

required.

Post by liran tal
Regards,
Liran.

-------------------------------------------------------------------------

Post by liran tal
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users