mysql_connect() is a php function that is included when installing php
with mysql support. When compiling php one needs to specify
--with-mysql, maybe this wasn't specified by the php package you are
using. If you make a file with the phpinfo() command in it, that will
show you whether php has
It's certainly a possiblity down the road in 1.1 or later.
Paul
On 3/25/06, Pagehit Talklists [EMAIL PROTECTED] wrote:
Hey Paul,
Is there any plans in the future to integrate Quickbooks export? I would
love to have the ability to export all invoices/payments to Quickbooks so I
don't have to
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Paul Yasi
Sent: Tuesday, March 28, 2006 10:37 AM
To: citrusdb-users@lists.sourceforge.net
Subject: Re: [Citrusdb-users] Printing Invoices
Well it was made to be used daily, or you could prorate
customers into a billing cycle like on the 1st
make sure that your browser isn't saving the password, that can cause
it to not log in correctly.
Paul
On 4/20/06, Help Desk [EMAIL PROTECTED] wrote:
I have just attempted to install 0.9.4 on FreeBSD running Apache 2.0.55,
with PHP 4.4.1.
From the login screen, I can attempt to login,
There is an idea on the todo list for a future version to have a
function to export billing history from citrusdb into quickbooks for
accounting purposes, but nothing is planned to go the other way, from
quickbooks into citrusdb. Are you billing services right out of
quickbooks? What are you
This error is coming from Apache. It probably means that the
permission of the citrusdb folder is set incorrectly. It needs to be
chmod a+rx for read and execute permission.
Paul
On 6/9/06, Michael Rulison [EMAIL PROTECTED] wrote:
But on trying to load index.php to log on to citrus I get:
I've confirmed this happens in the newest 1.0.2 version also, the
credit shows up but isn't calculated in the total. This is caused by
line 329 in the include/billing.inc.php file where it is only querying
billed amounts that are greater than the paid amount, the billed
amount shows up as a
I've just released version 1.0.3 that fixes this bug. It will show
correct total including the credit amount and automatically apply
outstanding credits to the account after a bill is generated. You can
download the latest release at http://www.citrusdb.org
Paul
On 9/5/06, Morgan Jones [EMAIL
PROTECTED]
You can reach the person managing the list at
[EMAIL PROTECTED]
When replying, please edit your Subject line so it is more specific
than Re: Contents of Citrusdb-users digest...
Today's Topics:
1. eInvoices (Technical Services)
2. Re: eInvoices (Paul Yasi
I don't think you have the invoice billing type selected for the
customer, so it won't print them. Once you choose the invoice billing
type you should be able to print an invoice for them, and then it will
show the invoiced amounts in the billing tab and each service in
billing details.
Paul
On
The left over number is the amount left after it has applied payment
to the amounts owed. For some reason it doesn't think there is any
amount owed. Does that customer have anything in their billing
details tab? Did you apply the payment by account number, billing id,
or invoice number?
Paul
What is the difference between a customer note and a trouble ticket?
Would it be like a bigger customer note with some more status details
and open/close searching? Can you provide some specs on what you
would need a trouble ticket system to do? Trouble tickets aren't
something I use, so I am
Does YourPay automatically do your recurring monthly payments? If
this is done by YourPay, You could set CitrusDB up to generate
invoices, but then not print them, so it has a record of that month's
invoice. You could then import the payment results from YourPay if
you can correlate their
time and trees.
Paul Yasi wrote:
You certainly don't need to delete the customer. The billing record
for the customer needs to be edited. After a customer is billed,
their billing record is updated with their next billing date and next
payment periods. When you delete an incorrect invoice
. I assume I would set the billing date as I created the
customer - setting it to start 6/1. Is that right?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul Yasi
Sent: Tuesday, June 19, 2007 6:02 PM
To: For users of CitrusDB discussion
Subject
it looks like that doesn't work correctly, I think some parts of adodb
are missing from the distributed files. I'll have to put them in
there and make a new release.
Paul
On 6/24/07, Ronald Hornidge [EMAIL PROTECTED] wrote:
Hello all,
I just wanted to first say that I am very impressed
to my webserver, and gave the files the same user/group as
everything else. I edited (on the web server) the config.inc.php as
follows:
?php
/**/
// Copyright (C) 2002-2005 Paul Yasi [EMAIL PROTECTED]
// Read
When you put in the over payment it showed you the amount over paid as
an amount left over at the top of the payment screen. Since it has
no bill to apply that payment to, you must add it as a credit to the
account, or apply it to a different account if the customer is paying
for multiple
PROTECTED] On Behalf Of Paul Yasi
Sent: Sunday, July 01, 2007 3:42 PM
To: For users of CitrusDB discussion
Subject: Re: [Citrusdb-users] Early Payment
When you put in the over payment it showed you the amount over paid as
an amount left over at the top of the payment screen. Since it has
That sounds like php isn't set up correctly. Usually that means it's
either not installed in apache, or not configured right in your conf
files. Can you put a simple phpinfo file in there to see if that
works? something like:
?php
phpinfo();
?
This should run and show you lots of information
, Paul Yasi wrote:
Maybe that part is not clear enough. Both the public and private part
of the system are meant to be installed on servers that are running
24/7. The private server would be inside your LAN, it will hold all
the information in a MySQL database on the private server. The public
It is not possible for citrus to change a customer's account number.
Keeping the account number the same all the time is very important
since it connects the customer with all their information. I would
not use a phone number as their customer number, the customer may move
and get a new phone
, can this be done to a working system with current users? Where the
next account would be the new #s? or would it have to be done before use.
Also.. Your example context didnt work for me.. What exaclty do I have to
type and how on mySQL.
Thanks
- Original Message -
From: Paul Yasi
You basically just named them :) You need to edit the files inside
the modules/customer folder. At the very least you need to change
edit.php and index.php, and then in addition you can edit create.php
to put that in the New customer form, and the search.php to search for
them.
Paul
On
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
Are hourly billed services often done straight through like that.
When I worked in web design there was an intermediate step that the
person doing the work keeps track of their time on paper, since they
might start and stop working on a client a number of times during a
day and inputs it into the
You could copy the tools/modules/billing/einvoice.php file and the
includes and then edit the einvoice.php file to run on it's own with
the php command line client using today's date in a cron job to export
the current day's credit card batch.
Paul
On Nov 3, 2007 1:10 PM, Jack Martin [EMAIL
I am unable to duplicate this error. When you make a new customer it
should fill in their billing record with the same address information
as the new customer. What database scheme version are you using? If
you go to Tools, and click General Configuration, they should match
like:
Citrus
I am thinking of requiring PHP5 for the next 1.2 release. This would
allow me to use more of PHP5's features, especially it's more complete
object orientation.
PHP4 will have no more feature releases after December 31st, and no
more security releases after August 2008, so I am looking for a time
CitrusDB does not have the ability to automatically print an invoice
outside of the customer's billing cycle. One would print it on their
next billing date, not in between billing dates. When printing an
invoice, that will add new charges to their account, so it's not
something that you probably
Er, actually that is the $ symbol, no the @ sign. The @ sign shows up
I bet, but the $ symbol doesn't
Paul
On Jan 19, 2008 6:17 PM, Paul Yasi [EMAIL PROTECTED] wrote:
It is the html ascii code for the @ sign. I try to escape these back
to actual text in the html_to_ascii function, but I
I don't have a good solution for the DNS zones right now, though
citrusdb could be modified to at least show a multi-line textfield
instead of a one-line input text type when it finds a text type. That
add field probably won't be able to work inside the service editor,
though the other simple
The only field type that is shown different from the standard text
field is an enum. If you make an enum with those two choices, it will
show up as a drop down list that you can choose 'PPPoE' or 'Static IP'
from. Since MySQL does not have a boolean type, people often make an
enum field with 'Y
What version did your download? I believe this may have been a
problem with the 1.2.2 file, but was fixed in 1.2.2.1 - this is the
version that is linked from the home page.
Paul
On Sat, Feb 23, 2008 at 12:52 PM, Emmanuel Fromm [EMAIL PROTECTED] wrote:
The subject line is the error I get when
I don't have an XP machine with AMP on it to try, but It's doing two
different things when you change a billing record. It's updating what
you changed on the record, and also updating the to_date according to
the billing type selected. You can watch it do queries by turning on
ADODB's debug
There probaly isn't an obvious place to put it except to email it to
me. If you want it up on the citrusdb.org site, I could create a new
folder called contrib to put things like this into. I would also be
open to including it with the release if it looks like it should go
there.
Paul
On Tue,
Yes, it's kinda strange. I've added back in the Completed item in the
development version, though the whole flow of support notes probably
needs to be re-thought. The only difference between lowercase and
uppercase is based on when it's using the translation (in this case to
English) vs. when
Do any of your field values have a backslash \ in them? there may
some issue with magic_quotes that I ran into once. I'm trying to
figure out the best way around it, since PHP6 won't have magic_quotes,
but 4 and 5 do by default.
Paul
On Mon, Apr 28, 2008 at 9:49 PM, Rich Cloutier [EMAIL
That's odd, the schema should allow the creditcard_number,
creditcard_expire, and rerun_date to be inserted as null values and
mysql puts in zeroes for you. Did you happen to use any particular
windows gui tool to import the default citrus database schema? It
looks like there may be some kind of
, @@session.sql_mode, @@sql_mode;
I thought this worked in strict, but I guess not. I'll have to change
my sql_mode and find out.
Paul
On Wed, Apr 30, 2008 at 4:29 PM, Rich Cloutier [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
Message: 3
Date: Wed, 30 Apr 2008 10:24:12 -0400
From: Paul Yasi
The Activate Accounts script will mark an account for Collections that
has been past due for more than the number of Collections days
indicated in general. It will then set the removal date for those
services to today and print it out with the rest of the service to be
removed. It's part of
Currently, the left over payment does not get applied automatically to
the account. One would have to manually enter it as a credit or apply
it to a different invoice. If one was paying an invoice, and had an
amount left over, rather than automatically apply the credit or put it
towards a
I'm not aware of anyone who has implemented a function that will email
users with support notes. One of my coworkers asked about such a
feature also. I guess i'm a person that wants less stuff in their
inbox, not more, but if people want it, it may not be too difficult to
make a function to turn
I remember talking to Liran about this last year,
http://www.mail-archive.com/citrusdb-users@lists.sourceforge.net/msg00299.html
The account activation script creates a file, that ideally would be
created daily, of who to add, delete, enable, and disable, with the
account attributes indicated by
Yes, citrusdb can do all this. Have you looked at the help file, help.html?
The bills are generated by going to the Tools and clicking on the
Print New Invoices. Then you can print invoices for those customers.
Your citrusdb user account will need to have at least Manager
privileges to do this,
are obvious.
Thanks,
Jean
On 8-Dec-08, at 9:04 AM, Paul Yasi wrote:
Yes, citrusdb can do all this. Have you looked at the help file,
help.html?
The bills are generated by going to the Tools and clicking on the
Print New Invoices. Then you can print invoices for those customers.
Your
CitrusDB version 1.3 is now in beta and available from the website.
This is not for production use, however you can test some of the new
features that will be soon available:
* a new statusupdate script that is to be run nightly to update
account status and create an account activate/deactivate
Is anyone out there are doing support email ticket management with a
web interface? What kind of software have you found that does this
well? Has anyone connected it to citrus in any way?
Paul
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care Billing System
This release includes a number of new functions. Most notably the
ability to indicate a service as carrier dependent that are sold
through a third party who need separate notification when that service
type is activated or deactivated.
The Account Activation tool has been removed in favor of the
I'm glad you got it working. I would guess it was somehow missing
files from the /include/adodb folder, I don't know why that would
happen on a new install. The name of the citrusdb folder really
should not matter.
Paul
On Thu, Feb 19, 2009 at 7:43 PM, Peter Coons pco...@dataoriented.com
You'll need to make sure the mysql server has a user with a name and
password matching the one you have in the citrus config.inc.php file.
If you are using EasyPHP that should come with phpMyAdmin that will
allow you to easily check what mysql server users there are under the
privileges tab. Just
Oh, and that mysql user will need access to the default citrus
database you created with the citrus.sql file too of course!
On Wed, Mar 25, 2009 at 10:07 PM, Paul Yasi p...@coffeebuzz.com wrote:
You'll need to make sure the mysql server has a user with a name and
password matching the one you
The new CitrusDB 1.3 Manual is now available! It provides up to date
information for using version 1.3 and I believe it a better organized
pdf file with a nicer chapter list thanks to producing the manual
using emacs org-mode (thanks org-mode!). You can get the manual from
lulu at
CitrusDB 1.3.1 has been released. This is release adds the ability to
choose which items to rerun on a credit card payment, it can associate
a ticket to a service,
and allows fixed amount taxes or fees. Please note that the update
script will reset any rerun dates in the database to be NULL
Sorry, citrusdb does not do payroll.
Paul
2009/6/29 Jeremy Winton jere...@cafes.net:
Does CitrusDB have payroll and if so does it get payroll tax updates?
Thanks in advance
Jeremy
--
The billing tab allows you alter that customer's billing record. Most
customers would only have one billing record, the default one is show
there, and the alternate ones are shown below it in a list. Sometimes
you may add alternate billing records when a customer has a service
that is not billed
I'm not sure what file you are referring to? Are you sure it's
/admins/modify_client.php ?
One could make the PDF be sent as an email attachment, to do this the
you would have to mime encode the PDF output and attach it to the
email message with appropriate headers.
Paul
On Mon, Jul 20, 2009
CitrusDB 1.3.2 has been released. This release fixes numerous minor
issues as well as a hand full of larger ones:
- Fixed decimal precision for money amounts in tables
- Faster exporting of large batches
- Added billing record tools to manually set status and send or print notices
- Added an
Adding a new module that would upload files and associate those files
to an account number should not be too difficult, especially if the
filename can contain the account number. The part that then links
them with their online account manager would need to be a custom added
case, since the online
Those variables are used by the notice class when creating notices,
they are currently undefined until they are in use, so that notice is
actually correct. You can safely turn off notices like this in your
php.ini file with a setting like:
error_reporting = E_ALL ~E_NOTICE
Paul
2009/12/13
A public beta version for testing the next major release of citrusdb
is now available!
Version 2.0 adds support for public key encryption of credit card
data, logging of access to customer records, a search dashboard that
shows previous customers you have viewed, and better support tickets
with
, 2010-01-07 at 09:45 -0500, Paul Yasi wrote:
I'm not too familiar with ldap. Are you trying to use ldap to initiate the
connection from the webserver to the mysql server, or to hold the citrusdb
users themselves?
Paul
2010/1/7 Pierrick Merle pierr...@poseidon-networks.com
Hello,
I'm
The latest bug fix for citrusdb 2.0 is now available. This release
now adds a gpg_sign variable to the configuration that is used to
specify a priate key signature command that is used to verify the
passphrase entered in the export cards tool before any other batch
processing is begun. This is
This release changes credit items to be used to credit new charges,
and does not use them to pay off past invoices which was causing
confusion. It also shows the subtotal of unused credit on the invoice.
Also adds a notification feature that can email or send jabber/xmpp
notifications of new
Those notices are not going to cause it to not function, they just
reflect your error level in PHP showing you everything. The thing
that will cause it not to function is the PHP Warnings
at the bottom. CitrusDB is trying to save the accounts files that
statusupdate creates. It puts it in to
This minor feature release release adds a function to track field
assets being shipped out with a service. Credit card charges are now
applied to the newest invoice first. Adds the to and from date range
for each service on a receipt. Fixes the subject in the email
notifications
Download it now
What browser are you using? Could you try it in a different or newer browser?
Paul
2010/4/23 Eric Cho e.ch...@yahoo.com:
Hello.
I'm using CitrusDB on localhost.
I found one error when I try to open sub window for configuration menu in
tool as follows.
Webpage error details
User
Oops. I've committed a fix for the next release:
http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/revision/241
Paul
2010/4/26 Eric Cho e.ch...@yahoo.com:
Hello!
I found one little error in the tools/modules/billling/importccupdate.php
85 line
I believe that
$armordate .=
on a regular basis.)
I hope it helps you even less :)
Thanks in everytime.
Regards.
-Eric
From: Paul Yasi p...@coffeebuzz.com
To: For users of CitrusDB discussion citrusdb-users@lists.sourceforge.net
Sent: Mon, April 26, 2010 9:02:33 AM
Subject: Re
Ok, Eric you are in there!
Paul
2010/4/26 Eric Cho e.ch...@yahoo.com:
Oh. Thanks.
This is my address for twitter. I hope you add this there.
http://twitter.com/myfoxfree
Appreciate!
-Eric
From: Paul Yasi p...@coffeebuzz.com
To: For users of CitrusDB
I think you need to update the url_prefix variables in config.inc.php
to match your own URL for your installation of citrus.
Paul
On Wed, May 5, 2010 at 6:52 PM, Ronnie Mubiru ronel...@gmail.com wrote:
Hello,
Thanks for the good work out there.
i have tried to install this system and also
I know there are many service providers using citrus and wanted to
discuss the possible third way of internet regulation proposed by the
FCC in the US.
http://www.engadget.com/2010/05/06/fcc-outlines-new-third-way-internet-regulatory-plan-will-spli/
According to the news about the new 'third
Regarding the option for inputting new fields for IP addresses and
fields for DHCP etc. There is some info in the help document about
setting up new services with custom attributes here:
http://citrusdb.org/help.html#sec-3.8.1 However maybe it is unclear
what all that implies.
Instead of
I've fixed the nummessages typo and found a whole bunch of undefined
vaiables to fix when I turned on notices. I know i've turned on E_ALL
notices to find these before, but it seems that is was undone during
some upgrade or something. Thanks for reminding me. I've found still
more undefined
You can enable the debug function by adding:
$DB-debug = true;
Near the top of the index.php file.
Adding debug will print out all the database queries all over the
page. You will only need to pay attention to the one that shows up
right before the query failed message.
You should look
I'm not sure I understand the issue. Citrus primarily uses the
DATE_ADD function from MySQL which should not have a problem adding to
any calendar date correctly.
You are right that the prev_billing_date column is not used anywhere,
it's a left over field from pre-release days.
Paul
2010/5/29
The statusupdate script requires many of the files in the /include
folder of citrus, so if it cannot find those files in the same place it
is at it cannot run. You can copy the /include folder to the same place
you are running statusupdate from to get it to work or a better idea may
be to use a
If the rate for extra minutes not included with the flat rate is the
same for all rate-centers you could create one service called something
like additional minutes that costs the per-minute rate and put the
amount of minutes used in the Measured Usage field. This will multiply
that by the rate
knock up a version of the email invoice to be run nightly
that would be much appreciated. I have a fair amount of web space on
my server if you ever need any!
db
On 19 Jun 2010, at 14:03, Paul Yasi wrote:
The statusupdate script requires many of the files in the /include
folder
This new feature release adds email invoices with pdf attachments,
credit card reruns now create invoices with pastdue amounts instead of
moving old items to new invoices, and more indexes have been added to
the default sql scheme for faster queries.
This new version requires PHP 5.2 or greater.
Citrusdb is not content management system for a customer facing
website all by itself, though it does have a small component you can
use that provides customers a view of their account. Most of citrusdb
is for internal usage by customer service representatives and billing
to manage customers and
You should certainly have had the Example Service and credit entries,
not sure why those would not be there. That sounds like the initial
installation of the citrus.sql file did not complete correctly.
Regarding the credits, they are added to the customer's services
listing, and are applied when
It will not login and look as if it's doing nothing if you have the
wrong password or there may be some errors you can look at in the
apache error_log or wherever php may be writing errors.
I currently use ubuntu linux but citrus can run anywhere php/mysql can
run. Whatever OS you are
It should work, but I have not done it myself. Citrus is dependent on
the php interpreter and not the web server underneath. Microsoft has
made some commitment to making php work with windows.
http://www.microsoft.com/web/platform/phponwindows.aspx
I could try it on my Windows 7 partition
The URL prefix needs to be the beginning of the URL to your citrus
site that will work in a browser, eg: http://www.example.com/citrusdb
and https://www.example.com/citrusdb
Paul
2012/2/20 AC Perdon acp@gmail.com:
Hi,
I have encounter this before and fix it by just editing the below
The database can be named anything you want as long as it matches what
you set in the $sys_dbname variable in the config.inc.php file.
eg:
$sys_dbname = 'citrus2';
I would ask you to consider if shared hosting keeps your customer data
adequately safe and meets your local PII laws and
This means that E_STRICT is probably enabled in your error reporting
setting. You'll want to turn that off in your php.ini settings so it
does not show these notices. Once it does not show the notices it
should allow the setting of session cookies correctly since it won't
have output any headers
:
Paul,
Looks like I erased the credit and prorated services.
Added them back in as per the original citrus.sql.
Now how do I insert the credit manually?
Bryan
On 2012-12-08 00:37, Paul Yasi wrote:
I cannot duplicate the link failing, it is loading the
tools/addcredit.php script
There is a usage multiple that you can use to charge anything you want. If
you make the service price 1 dollar, them whatever amount you put in the
usage multiple is the total for that service.
You can also label the usage multiple to name it something else like hours,
square feet, gallons,
*To:* For users of CitrusDB discussion
*Subject:* Re: [Citrusdb-users] Problem printing new invoices with
current date on iis
Same problem keeps placing a /
Sent from my iPhone
On Dec 18, 2014, at 6:13 PM, Paul Yasi p...@coffeebuzz.com wrote:
It may be the encoded characters instead of slashes
90 matches
Mail list logo
