Re: [Citrusdb-users] apache2 conf.d

[Paul Yasi]

It is your http url.  So it would be your domain name that points to your
server, followed by /citrus

Something like: Http://example.com/citrus

Paul

On Sunday, July 3, 2016, Bogi Maramski  wrote:

> hi all
> I'm truing to configure citrusdb to use conf.d in apache2
> My question is what to put in $url_prefix ?
> There is my /etc/appache2/conf.d/citrus.conf file:
> Alias /citrus /home/citrus-2.4.2
>
> 
> AllowOverride None
> Options None
> 
> 
> Options -FollowSymLinks -Indexes -Includes -ExecCGI
> AllowOverride All
> DirectoryIndex index.php index.html
> 
>
>
> Thanks
>
>
>
> --
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net 
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
--
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Problem printing new invoices with current date on iis

[Paul Yasi]

Is SELinux enabled?

On Sat, Dec 20, 2014 at 12:10 PM, Clinton Strouth 
wrote:

>  I set permissions to 777 on /var/www/html/invoices
>
> Sent from my iPhone
>
> On Dec 20, 2014, at 12:01 PM, Paul Yasi  wrote:
>
>   Does your web server have permission to write to that folder?
>
> On Fri, Dec 19, 2014 at 4:40 PM, Clinton Strouth 
> wrote:
>
>>  Paul i also tried the new version 3.0 on a linux system running Centos7
>> and apache 2.4 and it gives me around the same error
>>
>>
>>  Severity: Warning
>>
>> Message: fopen(/var/www/html/invoices//invoice15.pdf): failed to open
>> stream: Permission denied
>>
>> Filename: libraries/fpdf.php
>>
>> Line Number: 1025
>>
>>
>>  also tried using the current version.
>>
>>
>>  --
>> *From:* Clinton Strouth
>> *Sent:* Friday, December 19, 2014 11:37 AM
>> *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  wrote:
>>
>>  It may be the encoded characters instead of slashes that got in there
>> somehow.  Can you try just /billing
>>
>>  Paul
>>
>> On Wednesday, December 17, 2014, Clinton Strouth 
>> wrote:
>>
>>>  When trying to print new invoices we are getting the following error
>>>
>>> this is being done from the tool's page and then under billing print new
>>> invoices.
>>>
>>>
>>>  FPDF error: Unable to create output file: c:\billing\/invoice8.pdf
>>>
>>>
>>>
>>>  We have the c:\billing\ directory created and nothing gets put into
>>> this file.
>>>
>>>
>>>  Any help would be appreciated.
>>>
>>>
>>>  Thanks
>>>
>>>
>>>
>>>
>>>
>>
>> --
>> The CitrusDB Project | www.citrusdb.org
>> Open Source Customer Service & Billing
>>
>>
>> --
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREE
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>>
>>  ___
>> Citrusdb-users mailing list
>> Citrusdb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>>
>>
>>
>> --
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREE
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>> ___
>> Citrusdb-users mailing list
>> Citrusdb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>>
>>
>
>
> --
> The CitrusDB Project | www.citrusdb.org
> Open Source Customer Service & Billing
>
>
> --
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>  ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
>
> --
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserve

Re: [Citrusdb-users] Problem printing new invoices with current date on iis

[Paul Yasi]

Does your web server have permission to write to that folder?

On Fri, Dec 19, 2014 at 4:40 PM, Clinton Strouth 
wrote:

>  Paul i also tried the new version 3.0 on a linux system running Centos7
> and apache 2.4 and it gives me around the same error
>
>
>  Severity: Warning
>
> Message: fopen(/var/www/html/invoices//invoice15.pdf): failed to open
> stream: Permission denied
>
> Filename: libraries/fpdf.php
>
> Line Number: 1025
>
>
>  also tried using the current version.
>
>
>  --
> *From:* Clinton Strouth
> *Sent:* Friday, December 19, 2014 11:37 AM
> *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  wrote:
>
>  It may be the encoded characters instead of slashes that got in there
> somehow.  Can you try just /billing
>
>  Paul
>
> On Wednesday, December 17, 2014, Clinton Strouth 
> wrote:
>
>>  When trying to print new invoices we are getting the following error
>>
>> this is being done from the tool's page and then under billing print new
>> invoices.
>>
>>
>>  FPDF error: Unable to create output file: c:\billing\/invoice8.pdf
>>
>>
>>
>>  We have the c:\billing\ directory created and nothing gets put into
>> this file.
>>
>>
>>  Any help would be appreciated.
>>
>>
>>  Thanks
>>
>>
>>
>>
>>
>
> --
> The CitrusDB Project | www.citrusdb.org
> Open Source Customer Service & Billing
>
>
> --
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>  ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
>
> --
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>


-- 
The CitrusDB Project | www.citrusdb.org
Open Source Customer Service & Billing
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Problem printing new invoices with current date on iis

[Paul Yasi]

It may be the encoded characters instead of slashes that got in there
somehow.  Can you try just /billing

Paul

On Wednesday, December 17, 2014, Clinton Strouth 
wrote:

>  When trying to print new invoices we are getting the following error
>
> this is being done from the tool's page and then under billing print new
> invoices.
>
>
>  FPDF error: Unable to create output file: c:\billing\/invoice8.pdf
>
>
>
>  We have the c:\billing\ directory created and nothing gets put into this
> file.
>
>
>  Any help would be appreciated.
>
>
>  Thanks
>
>
>
>
>

-- 
The CitrusDB Project | www.citrusdb.org
Open Source Customer Service & Billing
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] https

[Paul Yasi]

If you set both the $url_prefix and the $ssl_url_prefix in the config file
to both have the https URL then it will always use it.

Paul

On Saturday, April 19, 2014, Michael Grant  wrote:

> I just installed CitrusDB.  When I log in to https://mydomain it
> redirects me to the non-https site.  Is there some way I can keep it on the
> https url?
>
> Michael Grant
>


-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Services at different costs depending on client

[Paul Yasi]

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, whatever you are measuring.
On Jul 2, 2013 2:52 PM, "Keith Hodges"  wrote:

> The way I see that Citrus is set up, is to bill for a service or set of
> services at fixed prices. We have a pest control company that only has
> maybe a dozen different services. However, the price of the service can be
> different for each customer. Each customer has different square footage of
> coverage area, different chemicals or products, and other criteria that
> affects price. When you have 5000 different customers, the list of services
> can get out of hand.  Is there a way to set this up without having to enter
> thousands upon thousands of different services? Can we set it up to input
> the price for the service when we add the service to the customer? Thanks
> in advance.
>
>
> --
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Over payment credit

[Paul Yasi]

Once you have the credit service back in there, you can just add a
credit to the account like any other service.  Click add service on
the account.  You might have to click show all to see the credit
service.  Then add that service.  Enter whatever description you want,
and the amount of the credit.  It should be a positive, not negative
amount.  It will make it negative by itself.

Paul

On Tue, Jan 8, 2013 at 2:59 AM, bryan  wrote:
> Paul,
>
> This may have been lost in the holiday mail.
> How do I enter the credit manually with SQL?
>
> Bryan
>
>
> On 2012-12-25 16:11, bryan wrote:
>> 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.  The whole payment is recorded, however
>>> if
>>> the credit is not entered with that link on that account then it
>>> must
>>> be entered manually.  Sometimes a customer may pay for two accounts
>>> or
>>> multiple invoices with one payment, so you may not always want to
>>> click that link that automatically adds a credit to the account and
>>> instead need to find the other account they paid for or the other
>>> invoice to apply that amount to.
>>>
>>> Paul
>>>
>>> On Fri, Dec 7, 2012 at 12:25 AM, bryan  wrote:
>>>> Paul,
>>>>
>>>> Could you tell me what happens to the credit after a payment is
>>>> made?
>>>> It echoes the message: Payment Saved, $31.50 Left over, Add Credit
>>>> for
>>>> $31.50
>>>> The last is a link the doesn't work for me at least.
>>>>
>>>> A payment of $94.50 was entered.
>>>> Customer only needs $63.00 to pay the invoice.
>>>> Credit amount is $31.50.
>>>>
>>>> If the credit isn't entered is it lost?
>>>> The full $94.50 shows up on the payment_history table though.
>>>>
>>>> Regards,
>>>> Bryan
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
>>>> Remotely access PCs and mobile devices and provide instant support
>>>> Improve your efficiency, and focus on delivering more value-add
>>>> services
>>>> Discover what IT Professionals Know. Rescue delivers
>>>> http://p.sf.net/sfu/logmein_12329d2d
>>>> ___
>>>> Citrusdb-users mailing list
>>>> Citrusdb-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>>
>>
>>
>> --
>> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
>> Remotely access PCs and mobile devices and provide instant support
>> Improve your efficiency, and focus on delivering more value-add
>> services
>> Discover what IT Professionals Know. Rescue delivers
>> http://p.sf.net/sfu/logmein_12329d2d
>> ___
>> Citrusdb-users mailing list
>> Citrusdb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Problems With Online Customer Manager

[Paul Yasi]

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 with strict notices.

My error_reporting setting in php.ini looks like:

error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED


Paul

On Fri, Jan 4, 2013 at 7:00 AM, Tope Kenneth  wrote:
> I installed citrus db on a local environment and when i tried the online
> customer manager i got the following errors;
>
> From the Customer Account Manager login page:
>
> Strict Standards: Non-static method ADODB_Session::_init() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 932
>
> Strict Standards: Non-static method ADODB_Session::open() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::close() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::read() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::write() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::destroy() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::gc() should not be called
> statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::config() should not be
> called statically in C:\xampp\htdocs\citrus\online\include\database.inc.php
> on line 29
>
> Strict Standards: Non-static method ADODB_Session::driver() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 526
>
> Strict Standards: Non-static method ADODB_Session::host() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 527
>
> Strict Standards: Non-static method ADODB_Session::user() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 528
>
> Strict Standards: Non-static method ADODB_Session::password() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 529
>
> Strict Standards: Non-static method ADODB_Session::database() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 530
>
>
> After log in to Customer Account Manager:
>
> Warning: session_start(): Cannot send session cookie - headers already sent
> by (output started at
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php:556)
> in C:\xampp\htdocs\citrus\online\index.php on line 60
>
> Warning: session_start(): Cannot send session cache limiter - headers
> already sent (output started at
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php:556)
> in C:\xampp\htdocs\citrus\online\index.php on line 60
>
>
> On log out:
>
> Strict Standards: Non-static method ADODB_Session::_init() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 932
>
> Strict Standards: Non-static method ADODB_Session::open() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::close() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::read() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::write() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::destroy() should not be
> called statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::gc() should not be called
> statically in
> C:\xampp\htdocs\citrus\online\include\adodb\session\adodb-session2.php on
> line 479
>
> Strict Standards: Non-static method ADODB_Session::config() should not 

Re: [Citrusdb-users] Over payment credit

[Paul Yasi]

I cannot duplicate the link failing, it is loading the
tools/addcredit.php script.  The whole payment is recorded, however if
the credit is not entered with that link on that account then it must
be entered manually.  Sometimes a customer may pay for two accounts or
multiple invoices with one payment, so you may not always want to
click that link that automatically adds a credit to the account and
instead need to find the other account they paid for or the other
invoice to apply that amount to.

Paul

On Fri, Dec 7, 2012 at 12:25 AM, bryan  wrote:
> Paul,
>
> Could you tell me what happens to the credit after a payment is made?
> It echoes the message: Payment Saved, $31.50 Left over, Add Credit for
> $31.50
> The last is a link the doesn't work for me at least.
>
> A payment of $94.50 was entered.
> Customer only needs $63.00 to pay the invoice.
> Credit amount is $31.50.
>
> If the credit isn't entered is it lost?
> The full $94.50 shows up on the payment_history table though.
>
> Regards,
> Bryan
>
>
> --
> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
> Remotely access PCs and mobile devices and provide instant support
> Improve your efficiency, and focus on delivering more value-add services
> Discover what IT Professionals Know. Rescue delivers
> http://p.sf.net/sfu/logmein_12329d2d
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Remittance date set

[Paul Yasi]

Do you mean the date shown in Payment history?  When citrus inserts a
payment using the payment tool (tools/payments.php) on the insert
statement around line 95 or so it makes the new payment_history entry
and inserts the CURRENT_DATE into the payment_history creation date.
One would need to instead ask the user what day they wanted to insert
and change the script to put that date in there.

Paul

On Mon, Oct 15, 2012 at 12:00 AM, bryan  wrote:
> Paul,
>
> Is there a way to set the date of the remittance?  Instead of it being
> dated the day it was entered.
>
> Remittance isn't given to us until the end of the month.  But the
> remittance is received on various days throughout the month from the
> customer of course.
>
> Bryan
>
> --
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] New Install

[Paul Yasi]

I'm guessing you may not have the default database from the citrus.sql
file - this needs to be imported into your empty citrus database, you
can do that with phpmyadmin or on the mysql cmd line.

Paul

On Tue, Sep 11, 2012 at 12:22 PM, Rakesh Kotha  wrote:
> Am installing CitrusDB on Windows XP with WAMP Server 2.2
>
> I got Apache, MQSQL, PhpMyAdmin worked.
>
> Now stared configuring CitrusDB.
> Copied the bineried to WWW folder in WAMP.
> When i tried http://localhost/citrus am getting below error:
>
> Fatal error: Call to a member function RowCount() on a non-object in
> C:\wamp\www\citrus\include\database.inc.php on line 58
>
> below is the line 58 in the file:
> $attempts = $result->RowCount();
>
> I haven't changed anything in this file but not sure why am getting this.
>
> Am stuck and tried googling but NO luck.
>
> Could someone help me configuring it.
>
> Thanks in advance
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] custom importer (and more). any interest?

[Paul Yasi]

I wrote a custom importer for my data back when I moved it out of my
previous system, being CUSTOM though, I don't know if it makes any
sense to release it since it was very specific to the format that my
data was coming from.

Unless there are popular customer databases that people are importing
and exporting from then I think everyone it kinda on their own in this
regard.

Paul

On Wed, Aug 22, 2012 at 4:23 AM, Matthias Šubik
 wrote:
> Hello,
> we are in the process of testing citrusdb for our administration needs.
> In this evaluation, we are building a customized importer script, based on 
> the importnew.php, because we need to import things as the sign-up date 
> (which is obviously in the past), and a cancelation date, as we want to have 
> old customers in the database as well.
>
> Is there any interest in this modified importer? If yes I would be motivated 
> to write it less hackish.
>
> I also might be tempted to introduce changes, so the start date of a service 
> (or a sign-up date) is in the future, as this affects the billing cycle, if 
> we have paper based sign up, and a later installation date.
>
> Also, as we are based in Vienna, Austria (Europe), my colleague and I might 
> need to change a few things, to make the tax / tax exempt part fitting to the 
> european system of VAT deduction. As this changes are primarily orientated on 
> our company, we could discuss here (or in private e-Mail) how this changes 
> are interesting for the project.
>
> For the duration of our testing (if it fits our business) we would maintain 
> the changes as a patch on top of the upstream distribution, but If we adopt 
> citrusdb for longer, we would obviously interested in getting them integrated 
> upstream.
>
> Anybody feels interested in this?
>
> ok, back to work.
> Matthias
>
>
> ---
> A: Yes.
>> Q: Are you sure?
>>> A: Because it reverses the logical flow of conversation.
 Q: Why is top posting annoying in email?
>
>
>
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Currency Format

[Paul Yasi]

The variable should go into the config.inc.php and you are right that
kind of function can go into citrus_base.php

Paul

On Thu, Aug 23, 2012 at 5:04 AM, bryan  wrote:
> Paul,
>
> You have probably been asked this before...
> To introduce a function where would I put it?
>include/citrus_base.php ?
>
> I need to change the currency format for Japanese Yen.  Which doesn't
> use decimals.
> So I thought that a function that formats depending on a variable in
> include/config.inc.php
> would be more flexible than changing all the sprintf each type.
>
> $billedamount = sprintf("%.2f",$myresult['d_billed_amount']);
> ==>
> $billedamount = sprintf("%d",$myresult['d_billed_amount']);
>
> Of course instead I would need to change all those to the function name
> but only once.
> One installation uses US dollars and the other Japanese Yen.
>
> $billedamount = currency_format($myresult['d_billed_amount']);
>
>
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Create invoices for all imported

[Paul Yasi]

Using Print New Invoices under Tools you can create a batch of
invoices using the billing date.  When a new account is imported the
billing date will be set to the next available billing date, usually
that will be today's date if you are importing before your billing
date rollover time.

Paul

On Wed, Aug 15, 2012 at 4:58 AM, bryan  wrote:
> Paul,
>
> Is there a way to create invoices for all... newly imported accounts?
> There is the link on the billing page for each customer:
>
> http://180.131.139.228/citrus/index.php?load=billing&type=module&createinvoice=on&billing_id=149
>
> Or do I need to click on each...
>
> Bryan
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Import New Accounts format

[Paul Yasi]

The organization ID is the 17th input, it is not inserted into the
customer table, but is used in the next step when it creates the
billing record.

Paul

On Wed, Aug 15, 2012 at 1:45 AM, bryan  wrote:
> Paul,
>
> After doing a regex substitutions of my data like in your
> safe_value_with_newlines function (include/citrus_base.php), it came
> back up with the wrong number of items again...
>
> So looking at line 75 of tools/modules/billing/importnew.php
> found that the check of the number of fields was 17.
> But looking below that there are only 16 from the $line input.
> The signup_date column is filled in with the CURRENT_DATE SQL and
> doesn't count?
>
> Now if I did something wrong, just yell at me because I am just
> looking at the parts.
>
>
> On 2012-08-12 01:02, bryan wrote:
>> Paul,
>>
>> Thanks. I will try just the service line(s) without quotes.
>> Got crazy with the quotes because of commas in the addresses.
>>
>>
>> On 2012-08-11 22:56, Paul Yasi wrote:
>>> I think the quotes around the service attributes may be screwing it
>>> up, can you try it without quotes, just comma separated.
>>>
>>> Paul
>>>
>>> On Thu, Aug 9, 2012 at 2:58 AM, bryan  wrote:
>>>> Paul,
>>>>
>>>> I have been unsuccessful in moving from our old invoicing system to
>>>> citrusdb.
>>>> All the data for the import file is there even got the cards masked
>>>> and
>>>> GPG ascii armored.
>>>>
>>>> But the services line, I think, is giving me an incorrect number of
>>>> items on each line when trying to import.
>>>>
>>>> The sample shows this:
>>>> Service ID, (any fields that make up the services options_table)
>>>> inthis
>>>> case, Username, Password, OS, Street, Device
>>>>
>>>> I assumed that Service ID means this:
>>>>master_services.id
>>>> That would then link to the service option table linked to that
>>>> service.
>>>> mysql> SELECT id, options_table FROM master_services WHERE id = 19;
>>>> ++---+
>>>> | id | options_table |
>>>> ++---+
>>>> | 19 | base_service  |
>>>> ++---+
>>>> So I included the fields from the base_service table which aren't
>>>> assigned by citrusdb:
>>>> base_service.ext_contract_id, base_service.login,
>>>> base_service.password, base_service.active_cci
>>>>
>>>> mysql> describe base_service;
>>>>
>>>>
>>>> +-+--+--+-+-++
>>>> | Field   | Type | Null | Key | Default | Extra
>>>>  |
>>>>
>>>>
>>>> +-+--+--+-+-++
>>>> | id  | int(11)  | NO   | PRI | NULL|
>>>> auto_increment |
>>>> | user_services   | int(11)  | NO   | | NULL|
>>>>  |
>>>> | ext_contract_id | int(10) unsigned | YES  | | NULL|
>>>>  |
>>>> | login   | char(64) | YES  | | NULL|
>>>>  |
>>>> | password| char(64) | YES  | | NULL|
>>>>  |
>>>> | active_cci  | enum('y','n')| YES  | | NULL|
>>>>  |
>>>>
>>>>
>>>> +-+--+--+-+-++
>>>>
>>>> What did I miss?
>>>>
>>>> Sample of my import file (with all the info made up):
>>>>
>>>> Online,"Bob Smith","ABC Inc.","Suneast Bldg. 3rd Floor Suite 310,
>>>> 307
>>>> Bash
>>>>
>>>>
>>>> St.","WA","Clarkston","USA","83622","03-3498-4499","","03-3498-4899","u...@foo.com","","","",""
>>>> "Bob Smith","ABC Inc.","Suneast Bldg. 3rd Floor Suite 310, 307 Bash
>>>>
>>>>
>>>> St.","WA","Clarkston","USA","83622","03-3498-4499","03-3498-4899","u...@foo.com","1","3***","1110","1"
>>>> &quo

Re: [Citrusdb-users] Import New Accounts format

[Paul Yasi]

I think the quotes around the service attributes may be screwing it
up, can you try it without quotes, just comma separated.

Paul

On Thu, Aug 9, 2012 at 2:58 AM, bryan  wrote:
> Paul,
>
> I have been unsuccessful in moving from our old invoicing system to
> citrusdb.
> All the data for the import file is there even got the cards masked and
> GPG ascii armored.
>
> But the services line, I think, is giving me an incorrect number of
> items on each line when trying to import.
>
> The sample shows this:
> Service ID, (any fields that make up the services options_table) inthis
> case, Username, Password, OS, Street, Device
>
> I assumed that Service ID means this:
>master_services.id
> That would then link to the service option table linked to that
> service.
> mysql> SELECT id, options_table FROM master_services WHERE id = 19;
> ++---+
> | id | options_table |
> ++---+
> | 19 | base_service  |
> ++---+
> So I included the fields from the base_service table which aren't
> assigned by citrusdb:
> base_service.ext_contract_id, base_service.login,
> base_service.password, base_service.active_cci
>
> mysql> describe base_service;
> +-+--+--+-+-++
> | Field   | Type | Null | Key | Default | Extra
>  |
> +-+--+--+-+-++
> | id  | int(11)  | NO   | PRI | NULL|
> auto_increment |
> | user_services   | int(11)  | NO   | | NULL|
>  |
> | ext_contract_id | int(10) unsigned | YES  | | NULL|
>  |
> | login   | char(64) | YES  | | NULL|
>  |
> | password| char(64) | YES  | | NULL|
>  |
> | active_cci  | enum('y','n')| YES  | | NULL|
>  |
> +-+--+--+-+-++
>
> What did I miss?
>
> Sample of my import file (with all the info made up):
>
> Online,"Bob Smith","ABC Inc.","Suneast Bldg. 3rd Floor Suite 310, 307
> Bash
> St.","WA","Clarkston","USA","83622","03-3498-4499","","03-3498-4899","u...@foo.com","","","",""
> "Bob Smith","ABC Inc.","Suneast Bldg. 3rd Floor Suite 310, 307 Bash
> St.","WA","Clarkston","USA","83622","03-3498-4499","03-3498-4899","u...@foo.com","1","3***","1110","1"
> "19","455662","username","PaSwORd","y"
> -BEGIN PGP MESSAGE-
> Version: GnuPG v1.4.5 (GNU/Linux)
>
> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
> scP0MWk5N6mujQ6nsA2IV2GcP/T2QfTtrivPF6yRdVPMQWzyiqWfoYMkii8H6N99
> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
> cP0MWk5N6mujQ6nsA2IV22QfTtriNdzaUogROeyaVrf9g0RFeZXj1EfdyFcLT6N9
> Js5LfEsKh9fEIVletA==
> =mr5H
> -END PGP MESSAGE-
>
>
>
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] payment due date gets set to start of invoiced month

[Paul Yasi]

Billing the same customer every day would not be possible, it uses month
intervals.  1 month or multiple months.

On Jul 9, 2012 10:12 PM, "Nathan Kirk"  wrote:
>
> What would I need to do for daily billing? Is that possible in this code?
>
> Nathan Kirk
>
> On Jul 9, 2012, at 6:59 PM, Paul Yasi  wrote:
>
> > The next billing dates are all based on the from date.  Also if today
> > was january 1st and you are creating a bill now you should set the
> > next billing date to today's date, eg for a january invoice use
> > 2012-01-01 as your next billing date for that first invoices.  After
> > the monthly invoices is created it inserts new next billing dates,
> > from dates, and payment due dates by adding a month to the from date
> > of the invoice it just created.
> >
> > Paul
> >
> > On Mon, Jul 9, 2012 at 5:45 AM,   wrote:
> >> A persistent problem I can't figure out:
> >>
> >> I set up a new "invoice monthly" test account,
> >> set the "next billing date" to 2012.2.2,
> >> the "from date" to 2012.1.1,
> >> the "to date" to 2012.2.1,
> >> and, to give them a couple of weeks to pay,
> >> the "payment due date" to 2012.2.16.
> >> The generated invoice for January shows these dates.
> >> Fine.
> >> But the next invoice, generated on March 2 for the
> >> month of February, shows the "payment due" as
> >> February 1, i.e., earlier than the previous month
> >> and a month earlier than the invoice date.
> >> When an invoice is generated at the start of April
> >> for the month of March, the same thing happens,
> >> i.e. the payment due is March 1.
> >> What I expect to happen is that the payment due
> >> date for the second invoice is a mongth later than
> >> the first, i.e., March 16, and the third invoice
> >> is due on April 16.
> >>
> >> But I can't get it to behave correctly and I can't
> >> see what I might be doing wrong.
> >>
> >> Has anyone seen this before?
> >>
> >> Regards
> >> Michael
> >>
> >>
> >>
--
> >> Live Security Virtual Conference
> >> Exclusive live event will cover all the ways today's security and
> >> threat landscape has changed and how IT managers can respond.
Discussions
> >> will include endpoint security, mobile security and the latest in
malware
> >> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> >> ___
> >> Citrusdb-users mailing list
> >> Citrusdb-users@lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
> >
> >
> >
> > --
> > The CitrusDB Project | http://www.citrusdb.org
> > Open Source Customer Care & Billing System
> >
> >
--
> > Live Security Virtual Conference
> > Exclusive live event will cover all the ways today's security and
> > threat landscape has changed and how IT managers can respond.
Discussions
> > will include endpoint security, mobile security and the latest in
malware
> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > ___
> > Citrusdb-users mailing list
> > Citrusdb-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
--
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] payment due date gets set to start of invoiced month

[Paul Yasi]

The next billing dates are all based on the from date.  Also if today
was january 1st and you are creating a bill now you should set the
next billing date to today's date, eg for a january invoice use
2012-01-01 as your next billing date for that first invoices.  After
the monthly invoices is created it inserts new next billing dates,
from dates, and payment due dates by adding a month to the from date
of the invoice it just created.

Paul

On Mon, Jul 9, 2012 at 5:45 AM,   wrote:
> A persistent problem I can't figure out:
>
> I set up a new "invoice monthly" test account,
> set the "next billing date" to 2012.2.2,
> the "from date" to 2012.1.1,
> the "to date" to 2012.2.1,
> and, to give them a couple of weeks to pay,
> the "payment due date" to 2012.2.16.
> The generated invoice for January shows these dates.
> Fine.
> But the next invoice, generated on March 2 for the
> month of February, shows the "payment due" as
> February 1, i.e., earlier than the previous month
> and a month earlier than the invoice date.
> When an invoice is generated at the start of April
> for the month of March, the same thing happens,
> i.e. the payment due is March 1.
> What I expect to happen is that the payment due
> date for the second invoice is a mongth later than
> the first, i.e., March 16, and the third invoice
> is due on April 16.
>
> But I can't get it to behave correctly and I can't
> see what I might be doing wrong.
>
> Has anyone seen this before?
>
> Regards
> Michael
>
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] invoices

[Paul Yasi]

Using the create invoice link under billing it created an invoice
(maybe you created a few) and you can see it in the invoice
maintenance and print it from there. (maybe it should redirect one to
that screen after clicking create invoice?)

You can also batch create invoices.  If you go into tools and click
Print New Invoices or Email New Invoices, it will make a pdf of all
the invoices for that day to print, or email all the einvoices for
that day.

Paul

On Sun, Jul 1, 2012 at 11:07 PM, Aidan Daly  wrote:
> Hi guys,
>
> Your going to have to bear with me here as this is my first install of this
> application. Im not sure if i have done something wrong but i seem to be
> having issues with generating invoices. It asks me are you sure you want to
> create an invoice for a client but then it doesnt seem to give me any
> further info and i can't seem to see an invoice generated under billing. I
> have created a service and tried doing it that way but not getting anywhere.
> Your assistance is greatly appreciated
>
> Aidan
>
>
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] CitrusDB Installation Survey

[Paul Yasi]

In preparing for CitrusDB version 3 i'd like to make it easier to
install the software, and to understand better how you are using the
software. If you could take two minutes and answer this short 5
question survey it would help me determine how best to proceed. Thank
you for your time.

Please visit: http://www.citrusdb.org/survey


Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] API Functions or Classes

[Paul Yasi]

If you look in the includes folder that comes with 2.x you'll see
there are files that have functions for billing, services, and support
that have much of these function in them.  Including the config and
database files will get your settings and database connection too.

eg:

include('./include/config.inc.php');
include('./include/database.inc.php');
include('./include/billing.inc.php');
include('./include/support.inc.php');
include('./include/services.inc.php');

Paul

On Wed, May 30, 2012 at 11:10 AM, Nathan Kirk  wrote:
> Does anyone have an API or Class set-up to do the functions from outside
> the system(ie add customers,add services with linked products , process
> invoices) ? I have been adding things into the database directly but
> there are some key components I am missing.
>
> Also has anyone created a Statement Page? Where a customer can see all
> of their payments and invoices in one statement.
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Invoice includes services not in range billing.from_date - to_date

[Paul Yasi]

It is a simple billing model, but it works for many uses.  I would be
glad to look at a patch that implements this.  If you expect the
software to do this out of the box, then maybe citrus isn't for you.

Paul

On Wed, May 30, 2012 at 4:38 AM,   wrote:
> Hi Paul/whoever,
>
> We expect our database to be updated constantly (e.g.,
> daily), but invoices may not be generated until a few
> days into the month.
> Thus user_services may contain some services in the
> current month.
>
> Unfortunately, a quick test (using 'Create Invoice')
> indicates that CitrusDB ignores the 'From Date' set
> on a Customer's Billing page, and so it includes the
> services started in the current month in the invoice
> for the previous month.
> I also had a look at the PHP and saw that, e.g.,
> billing.inc.php's total_serviceitems() searches only
> for items for which the 'removed' attribute is 'n',
> so it includes anything that hasn't previously been
> invoiced, whether it's in date range for the invoice
> or not.
>
> We expect invoices for April to contain only items
> from April, those for May to contain only items from
> May, etc., so I consider this a bug.
> At a minimum, isn't it misleading to have 'From Date'
> and 'To Date' on the billing page if, as seems to be
> the case, they have no effect on the generated
> invoice?
>
> Regards,
> Michael
>
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] currencies / volume discounts / extra invoice order line data

[Paul Yasi]

The currency symbol is printed almost nowhere, maybe it should just be
removed.  For multiple currencies would one need multiple prices for
everything?  That sounds like a total mess.  Why would you want to do
that to yourself?

A volume discount could be done during your import script by assigning
it to different services depending on what the amount was, say under
100 gets one service id and over 100 gets a different service id.

Each rate you offer would usually be a different service at a
different price.  You do end up with a huge number of services.  At
least that's how it's meant to be.

Paul

On Wed, May 23, 2012 at 6:40 AM,   wrote:
> I'm evaluating CitrusDB for a telecoms-like application, having
> abandoned an evaluation of jBilling.
>
> CitrusDB seems more limited, but at least I got it working quickly
> with a simple initial demo setup of my own - which is more than I
> can
> say for jBilling, after spending around a week on it.
>
> These are the points I'd like to share. Thanks to anyone who can
> confirm or correct or make suggestions.
>
> Limitation to a single currency: as I'm not evaluating on my own
> behalf, I'm not sure yet if this is a showstopper. There doesn't
> seem
> to be an obvious workaround, though I noticed that no currency unit
> appeared on the sample invoice I generated. Perhaps the simplest
> way
> would be to run a separate installation of CitrusDB for each
> currency (which might be acceptable if they could be limited to,
> say,
> three, but which is obviously not an appealing solution)?
>
> Volume discounts, discount for advance payment, etc. I didn't see a
> section dealing with this subject in the manual. My understanding
> is
> that this would have to be implemented by whatever code is
> importing
> the usage data into the Citrus database. So if the user has paid
> for
> 100 units in advance for the month, getting a fixed discounted
> price,
> then a separate PHP script that finds the usage is 90 does nothing,
> but if it finds the usage is 110 then it adds another service with
> a quantity of 10 to be billed at the usual rate. Correct?
> (The equivalent logic in jBilling would be in Drools rules.)
>
> Only one piece of ancillary data in the invoice: if an options
> table
> is defined to store extra information associated with a service
> then
> only the first column from this appears in the invoice.
> Workaround: store all the data that should be printed in the first
> column, duplicating parts of it in other columns if it is necessary
> or convenient to access them as separate numbers or codes, etc.
>
> (Ideally, I think one of those numbers might be a rate so that the
> same service could be billed at different rates, rather than
> creating a different service for each rate. The rate might be the
> outcome of some complex function of durations, ratios or the like,
> so that the number of services needed could otherwise be large
> due to the many different possible outcomes of the rate
> calculation.
> However, that's probably expecting too much.)
>
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Changing db Name

[Paul Yasi]

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 regulations.
Particularly things like access control and comprehensive log review
may be difficult on a shared host.  A virtual private server may be
more appropriate.

Paul


On Wed, May 23, 2012 at 4:48 PM, Kiersten Williams  wrote:
> I am a new user with some php & mysql experience.  I'd like to run Citrus DB
> on a shared server with GoDaddy.  I am unable to name the mysql database
> "citrus" as that name is already in use.  If I name the database something
> different, which files will I need to modify with the new name in order to
> get things installed properly?
>
> Thanks in advance for any help!
>
> Kiersten
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] Announcing citrusdb 2.4.2

[Paul Yasi]

This 2.4.2 release fixes a file include vulnerability that allowed
users who are logged into citrus to load other php files from the
server.  It also adds some minor features.

- fixes file include vulnerablity
- adds a tool to show the pending creditcard refunds
- adds script that can email customers when their credit card is about to expire
- adds a partial swedish translation by Jadenn Hillier

You can get the latest version from the homepage: http://www.citrusdb.org

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] citrusdb file inclusion exploit

[Paul Yasi]

There is a vulnerability in citrus that can be patched by adding a
preg filter around line 99 of the index.php file that will prevent the
php file inclusion vulnerability.  This vulnerability is only
exploitable to users already logged into citrus.

http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/revision/417/index.php

The SQL injection vulnerability is not exploitable because the
injected code is filtered out before it gets to that database query.

The preg filter will be included in the next release of citrus, which
I hope to get online soon.

http://seclists.org/bugtraq/2012/Apr/53

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] How to configure email settings

[Paul Yasi]

The email functions that send invoices and notices use a mailserver,
usually one running on the same server as the database software.  So
for a linux server you would need to be running an mta like postfix or
exim to send outgoing mail from the server.  On windows there is a
setting in the php.ini that specifies the mail server I believe.

Paul

On Sat, May 5, 2012 at 5:10 AM, nam vo  wrote:
> Hi all,
>
> I cannot find out how to configure citrusdb to work with my current gmail to
> send invoice ... really weird system to me.
>
> I'm totally new to citrusdb. please help.
>
> Nam Vo
>
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Viewing PDF Invoices

[Paul Yasi]

I don't think you have to modify anything, just turn off the
deprecated warnings.

Paul


2012/3/13 James Paul :
> Thanks for the community support, I would rather not have to start
> modifying code.
>
> I am running a linux lampp framework, current version,
> php 5.3.8, FPDF 1.6.
>
> I can backtrack to lampp v1.7, PHP 5.2.8, FPDF 1.6.
>
> Will have to dig though errata to find when split and
> magic were deprecated.
>
> Anyone know ?
>
> --
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Add service to client creates error notice

[Paul Yasi]

I think it worked but is showing a deprecated error since not all the
split calls have been updated to use preg's for php 5.3

You can turn off this message by turning off the deprecated warning in
 your php.ini

error_reporting = E_ALL & ~E_DEPRECATED

In production you probably also want to turn off display_errors and
turn on log_errors:

display_errors = Off
log_errors = On

Paul

2012/3/4 James Paul :
>
> Hello Citrus,
>
> I am looking forward to becoming adept at this software :
>
> I added a customer/client, set up a few new services, and went to add a
> service line
> item to the main customer page and got this notice:
>
> Deprecated: Function split() is deprecated in
> /opt/lampp/htdocs/citrus-2.4.1/include/billing.inc.php on line 1777
>
> Edit: 45 Attendance Hourly (New Client Name)    Created On: Mar 04, 2012,
> Active
>
> Any idea where I missed a pre-config or ??? as the nature of this notice ?
>
> Kindly,
> JP.
>
> --
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Google Apps and Citrus DB

[Paul Yasi]

I don't use google apps myself, but i'm intersted in this module.  Do
you go through google directly or through their ikano partner editon?

Paul

2012/2/21 John Hurst :
> Hey Guys,
>     I've been working on a module for citrusdb that will use Google
> provisioning API to provision Google Apps accounts.  I'm making this because
> we recently switched our customer base over to Google.  Is there anyone else
> out there who is using Google Apps and would be interested in this module?
>
> I have it working now, however still working on getting it to update user's
> names, and passwords.
>
> - John
>
> --
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] I encounter this error before and fix it with older version. "Not Found" but encounter it in 2.4.1 again.

[Paul Yasi]

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 :
> Hi,
>
>
> I have encounter this before and fix it by just editing the below variable,
> but now using latest version of citrusdb 2.4.1 I get that same error.
>
> $url_prefix="/var/www/html/citrusb";
> $ssl_url_prefix="/var/www/html/citrusdb";
>
>
> Not Found
>
> The requested URL /var/www/html/citrusdb/index.php was not found on this
> server.
>
>
> Here is my config.
>
> $path_to_citrus='/var/www/html/citrusdb/';
> $hidden_hash_var='thequickbrownfoxjumpoverthelayzdod';
> $lang = './include/local/us-english.inc.php';
> $url_prefix="/var/www/html/citrusb";
> $ssl_url_prefix="/var/www/html/citrusdb";
>
>
> location of the file
>
>
> [root@student citrusdb]# pwd
> /var/www/html/citrusdb
>
> [root@student citrusdb]# ls -l index.php
> -rw-r--r-- 1 root root 13830 Dec  8 23:55 index.php
> [root@student citrusdb]#
>
>
> OS:
>
> Centos 6.0
> SElinux is disable and firewall is flash
>
>
> Is there something I miss?
>
>
> Thanks in advance,
>
> AC
>
> --
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Feature request...

[Paul Yasi]

Is this when searching for customers?  On a search that does not
return results you should get "Sorry No Records Found" and a link to
"Click here to try again".  If you are getting a query failed
something may be wrong.

Paul

On Tue, Feb 7, 2012 at 7:54 PM, Bill Harris  wrote:
>
> One thing that would be useful, ( unless I have a configuration issue)
> is a navigation options after doing a query, failed or successful..  It
> appears
> I need to actually view a record on successful, to get my sidebar back.
>
> On failure, I just get the "Query failed" message..
>
> Bill
>
>
> --
>
>
> --
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Development work

[Paul Yasi]

It's meant to hold the source of the customer in terms of where they
heard about your service, advertisement, etc.  There is a source
report that can produce a total for each source that uses that field.
If that doesn't matter right now you could use it to hold a temporary
value.

I think I would just add new fields to the end of the table or if
there are a bunch of them make a new table and put those values in
there with the account number as a key.

Paul

On Mon, Jan 23, 2012 at 5:20 PM, Bill Harris  wrote:
> Paul,
>
> What is the "source" column used for?  Can I use it
> to hold a temporary value?
>
> Bill
>
> mysql> describe customer;
> +--+--+--+-+++
> | Field                    | Type             | Null | Key | Default    | 
> Extra          |
> +--+--+--+-+++
> *| source                   | varchar(100)     | YES  |     | NULL       *|   
>              |
> | signup_date              | date             | NO   |     | -00-00 |     
>            |
> | name                     | varchar(255)     | NO   |     |            |     
>            |
> | company                  | varchar(255)     | YES  |     | NULL       |     
>            |
> | street                   | varchar(255)     | NO   |     |            |     
>            |
> | city                     | varchar(255)     | NO   |     |            |     
>            |
> | state                    | char(3)          | NO   |     |            |     
>            |
> | country                  | varchar(255)     | NO   |     | USA        |     
>            |
> | zip                      | varchar(20)      | NO   |     |            |     
>            |
> | phone                    | varchar(20)      | NO   |     |            |     
>            |
> | alt_phone                | varchar(20)      | YES  |     | NULL       |     
>            |
> | fax                      | varchar(20)      | YES  |     | NULL       |     
>            |
> | contact_email            | varchar(255)     | YES  |     | NULL       |     
>            |
> | account_number           | int(11)          | NO   | PRI | NULL       | 
> auto_increment |
> | secret_question          | varchar(254)     | YES  |     | NULL       |     
>            |
> | secret_answer            | varchar(100)     | YES  |     | NULL       |     
>            |
> | cancel_date              | date             | YES  |     | NULL       |     
>            |
> | removal_date             | date             | YES  |     | NULL       |     
>            |
> | default_billing_id       | int(10) unsigned | NO   |     | 0          |     
>            |
> | account_manager_password | varchar(60)      | YES  |     | NULL       |     
>            |
> | cancel_reason            | int(11)          | YES  |     | NULL       |     
>            |
> | notes                    | text             | YES  |     | NULL       |     
>            |
> +--+--+--+-+++
> 22 rows in set (0.00 sec)
>
>
> On 1/23/2012 7:53 AM, Paul Yasi wrote:
>> I don't think it would break anything.
>>
>> Paul
>>
>> On Mon, Jan 23, 2012 at 8:29 AM, Bill Harris  wrote:
>>> Paul,
>>>
>>> Our current "homegrown" Access-based system stores the account
>>> name as the account number (legacy from dial-up days)..
>>>
>>> I want to import the customers today, but wondered if I could add
>>> a varchar column to store the login id into (just temporarily) until
>>> I build the services up.  I was tempted to just store it in the comment
>>> field, but I have a field of those to import as well.
>>>
>>> Will adding a field at the end of the customer table break anything, 
>>> functionally?
>>>
>>> Bill
>>> --
>>> Try before you buy = See our experts in action!
>>> The most comprehensive online learning library for Microsoft developers
>>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>>> Metro Style Apps, more. Free future releases when you subscribe now!
>>> http://p.sf.net/sfu/learndevnow-dev2
>>> ___
>>> Citrusdb-users mailing list
>>> Citrusdb-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>>
>>
>
> ---

Re: [Citrusdb-users] Development work

[Paul Yasi]

I don't think it would break anything.

Paul

On Mon, Jan 23, 2012 at 8:29 AM, Bill Harris  wrote:
> Paul,
>
> Our current "homegrown" Access-based system stores the account
> name as the account number (legacy from dial-up days)..
>
> I want to import the customers today, but wondered if I could add
> a varchar column to store the login id into (just temporarily) until
> I build the services up.  I was tempted to just store it in the comment
> field, but I have a field of those to import as well.
>
> Will adding a field at the end of the customer table break anything, 
> functionally?
>
> Bill
> --
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Running CitrusDB on IIS

[Paul Yasi]

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 sometime if you really want a tutorial.

I think it could also be made to work with Microsoft SQL, but that's a
taller order since there may be some unique MySQL queries that would
need to be updated.

Paul

2012/1/14 Doreen Jones :
> I've looked and can't seem to find anywhere that indicates that CitrusDB
> runs on a Microsoft server running IIS.  Your product looks lovely and I'd
> love to get it - but don't want to bother if IIS isn't supported.  I do have
> PHP Ver. 5.2 on my server.  And I also have MySQL - not sure of version at
> moment but that can be remedied.
>
> Doreen Jones - Owner
> JDS & Associates and East Texas Programming
> Database Solutions and Web Site Development
> Hosting and Domain Name Registration
> 2121 S. Loop 256 - Suite 3 (Capital One Bank - Next to Office Depot)
> Palestine, TX 75801
> We Make  Custom Software !!!
> 903.731.3553
>           Web and associated languages we can offer support for are -
> ASP/.Net, C/C++, COBOL, FOCUS, FORTRAN, PHP, REXX, Visual Basic/.Net.
>
>   We have expertise in the following databases:   MS Access, ORACLE, and
> MS SQL.
>
>   Other expertise:  JCL, MSA, EXEC2, SCADA.  Feel free to ask - we don't
> list everything.
>
>
>
>
> --
> RSA(R) Conference 2012
> Mar 27 - Feb 2
> Save $400 by Jan. 27
> Register now!
> http://p.sf.net/sfu/rsa-sfdev2dev2
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Development work

[Paul Yasi]

There is a stable/maintenance version and an active development
version.  The version on citrusdb.org is 2.4.x that is the
stable/maintenance version and there is a development version 3.0 that
is not yet deemed ready for production.  It has been refactored into
an MVC framework and is under active development at
https://github.com/paulyasi/citrusdb

2.4 commit log: https://code.launchpad.net/~paul-citrusdb/citrusdb/gpg
3.0 commit log: https://github.com/paulyasi/citrusdb/commits/master

Paul

On Sat, Jan 14, 2012 at 11:10 AM, Bill Harris  wrote:
> Paul,
>
> Just curious is CitrusDB under active development?
> Or is the project mostly in maintenance mode..?
>
>
> Bill
>
> --
>
>
>
> --
> RSA(R) Conference 2012
> Mar 27 - Feb 2
> Save $400 by Jan. 27
> Register now!
> http://p.sf.net/sfu/rsa-sfdev2dev2
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] mysql error during install

[Paul Yasi]

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 comfortable using.  I've run citrus in
various linuxes, windows, and macosx at various times.

Paul

On Thu, Jan 12, 2012 at 9:50 AM, Brad Morton  wrote:
> I linked the mysql.sock and it seemed to get of the problem unitl I rebooted. 
>  After a reboot the error comes back and I have to relink it.
>
> Ideas?
>
> Also once the error is gone and I try to login with the default username and 
> password it goes no where.
>
> This is the URL that shows up in my adddress bar after the login attempt:
> https://10.0.0.11/citrus-2.4.1//index.php
>
>
> 
> Brad Morton
> Field Service Manager
> Reztel Broadband
> 780 Midpark Dr. Suite 103
> Kingston, ON K7M 7P6
> Office:(613) 384-2101
> Toll-Free: 888-546-
> Cell: (613) 888-2161
> www.reztel.net
>
> Legal Notice:
> Please consider the environment before printing this email.
> -
> This e-mail message is intended only for the named recipient(s) above and may 
> contain information that is privileged and/or confidential. If you have 
> received this message in error, or are not the intended recipient(s), please 
> immediately notify the sender and permanently delete this e-mail message.
>
> --
> RSA(R) Conference 2012
> Mar 27 - Feb 2
> Save $400 by Jan. 27
> Register now!
> http://p.sf.net/sfu/rsa-sfdev2dev2
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Cosidering using CitrusDB to replace old homegrown billing system

[Paul Yasi]

There isn't a paypal import feature included, but you could probably
modify the importcc.php file in tools to import this file of payment
information.

Has anyone on the mailing list already done something with paypal
files?  I would imagine many people download the same paypal file
format.

Before you apply a payment you'll need to have already created an
invoice that the payment can be applied to.

Paul

On Wed, Jan 11, 2012 at 1:12 PM, Bill Harris  wrote:
>
> I am looking seriously at CitrusDB to replace an ancient
> homegrown billing system based on Access.
>
> It currently uses a Paypal interface to download a payment
> file where customer submit online payments..   It appears
> that CitrusDB can handle these type of payment gateways.
>
> Any suggestions going forward.
>
> Bill
>
>
> --
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] mysql error during install

[Paul Yasi]

I don't know much about running php/mysql under OpenBSD but I found a
tutorial that recommends making a new hard link to the place where
apache can see the file.

http://freeyourbox.org/tutorials/bsd/obsd3.8_apache_php_mysql.html#Setting
that says:

On OpenBSD, apache comes chrooted in the /var/www directory. MySQL's
default socket location is in /var/run/mysql/mysql.sock. This causes a
problem since apache can't "see" the /var/run directory. To overcome
this, we need to make a hard link to the mysql.sock socket file. This
is achieved by typing the following at the command prompt:

# mkdir -p /var/www/var/run/mysql
# ln -f /var/run/mysql/mysql.sock /var/www/var/run/mysql/mysql.sock


Paul

On Wed, Jan 11, 2012 at 11:23 AM, Brad Morton  wrote:
> Been working on setting up the new and improved Citrusdb on spare box we have 
> here.
>
> OS: OpenBSD 5.0
> Mysql-5.1.54
> PHP-5.3
>
> I'm getting close, the login page comes up but at the top it says the 
> following:
> Can't connect to local MySQL server through socket 
> '/var/run/mysql/mysql.sock' (2)
>
> Not sure where to go with this.  Not really a guru with this stuff.
>
> Any help would be great,
>
>
> Cheers
> Brad
>
> --
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] Citrusdb 2.4.1 released

[Paul Yasi]

Announcing version 2.4.1 of citrusdb with bug fixes and minor feature
updates including

- making it easier to choose items to rerun on specific invoices
- adding a date range to the invoice printing tool to print multiple
invoices days at once
- improving the revenue report to show all organizations at once, and
includes the billed amount during that period

You can download the latest version at http://www.citrusdb.org

I'd also like to bring some attention to citrusdb 3.0 in development
on github at https://github.com/paulyasi/citrusdb - this development
version is functional, but still under development and only for
testing and feature enhancement right now.  It makes use of the
codeigniter framework to allow for better code organization and reuse.

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Cloud Services Checklist: Pricing and Packaging Optimization
This white paper is intended to serve as a reference, checklist and point of 
discussion for anyone considering optimizing the pricing and packaging model 
of a cloud services business. Read Now!
http://www.accelacomm.com/jaw/sfnl/114/51491232/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Firefox can't establish a connection to the server at localhost.

[Paul Yasi]

Maybe the SSL module is not loaded, I can reproduce the same error if
I turn off the SSL module in apache.

https://help.ubuntu.com/11.04/serverguide/C/httpd.html#https-configuration

Paul

On Mon, Aug 29, 2011 at 5:41 PM, Brien  wrote:
> Also I have checked to see if apache is running and restarted it after reboot.
> What could be causing this problem do you think?
>
>
>
>
>
> --
> Special Offer -- Download ArcSight Logger for FREE!
> Finally, a world-class log management solution at an even better
> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
> download Logger. Secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsisghtdev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better 
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Firefox can't establish a connection to the server at localhost.

[Paul Yasi]

Do you get any response like the default apache "It Works!" page when
you go to https://locahost/

I've followed these instructions to enable ssl on ubuntu successfully before:
http://www.tc.umn.edu/~brams006/selfsign_ubuntu.html

If you are just trying this out on localhost and not across a network,
then none of this SSL stuff matters in that case either.

Paul

On Mon, Aug 29, 2011 at 1:27 AM, Brien  wrote:
> I'm still searching for a solution for this. I'll try to explain where I'm at
> step by step, to grant more insight on the situation.
>
> Ubuntu 11.04
> Msql 5.1
> php 5.3
> apache2.2
>
> 1. Install citrus 2.4
> 2. edit config.inc.php (I edited everything that the manual instructed me to,
> these are the edits that I'm not sure if I did correctly)
>
> $url_prefix = "http://localhost/citrusdb";;;
> $ssl_url_prefix = "https://localhost/citrusdb";;;
> and my path is:
> $path_to_citrus = '/var/www/citrusdb/';
>
> 3.open browser (firefox) enter http://localhost/citrusdb
>
> I see the citrusdb log in screen and logo
>
> 4.  and finally, enter user/password click login
>
> receive this message on https://localhost/citrusdb/index.php
>
> Unable to connect
>
>          Firefox can't establish a connection to the server at localhost.
>
>  The site could be temporarily unavailable or too busy. Try again in a few
>    moments.
>  If you are unable to load any pages, check your computer's network
>    connection.
>  If your computer or network is protected by a firewall or proxy, make sure
>    that Firefox is permitted to access the Web.
>
> please help.
>
>
> --
> EMC VNX: the world's simplest storage, starting under $10K
> The only unified storage solution that offers unified management
> Up to 160% more powerful than alternatives and 25% more efficient.
> Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management 
Up to 160% more powerful than alternatives and 25% more efficient. 
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Firefox can't establish a connection to the server at localhost.

[Paul Yasi]

Edit billing tries to use the SSL url since it may have card data in
it.  This is probably because you don't have the $ssl_url_prefix
configured correctly.  If you are storing credit cards you'll want to
enable SSL on  your server and configure that ssl_url_prefix to use
the https address.  If you are not storing credit cards then you can
set the ssl_url_prefix to be the same as the regular url_prefix.

Paul

On Sun, Aug 28, 2011 at 3:46 AM, Brien  wrote:
> I just got a fresh install of Citrusdb on my computer. The install went 
> great, I
> have no errors. I created a service, and a customer record, then added that
> service to that customer's record. Then I click to edit default billing. When 
> I
> click that I get
>
> Unable to connect
>
>          Firefox can't establish a connection to the server at localhost
>
>
>
>  The site could be temporarily unavailable or too busy. Try again in a few
>    moments.
>  If you are unable to load any pages, check your computer's network
>    connection.
>  If your computer or network is protected by a firewall or proxy, make sure
>    that Firefox is permitted to access the Web.
>
> Also, the same thing happens when I click the account manager password link.
>
> I Tried everything I can think of and can't get it to work. I searched all 
> over
> to find a answer but haven't been able to come up with anything.
>
> I could really use some help on this thanks,
>
>
> --
> EMC VNX: the world's simplest storage, starting under $10K
> The only unified storage solution that offers unified management
> Up to 160% more powerful than alternatives and 25% more efficient.
> Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management 
Up to 160% more powerful than alternatives and 25% more efficient. 
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] adding credit to an account

[Paul Yasi]

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 the next bill is created.  So if a
customer has an upcoming bill for $20, but has a credit for $5 on
their account, the next bill will total $15.

In the dollar amount for the credit you need to put a positive amount,
eg, 5 not -5, it will do the subtraction for you.

Paul

On Wed, Jul 27, 2011 at 2:42 PM, Victor Ientilucci
 wrote:
> When I added a credit to the account, the next billing cycle tried to
> bill the account for the same amount of the credit. DOes the credit
> service need a special attribute ?
>
> ---
> Victor Ientilucci
> President
> Mega Website Services
> 416-779-6969
> vic...@megawebsiteservices.com
> http://megawebsiteservices.com
>
> On Wed, 27 Jul 2011 12:44:28 -0400, Victor Ientilucci wrote:
>> I am testing the system.  When I say that an account has received a
>> over payment, I want to credit the account. It seems to fail because
>> it cannot get a master_service_id.
>>
>> $query = "SELECT id,options_table FROM master_services ".
>>     "WHERE category = 'credit' ".
>>     "AND organization_id = '$organization_id' LIMIT 1";
>>
>>
>> This returns nothing.  Should I create a service that has a category
>> of type "credit"?
>> What other attributes/values, should it have?
>>
>> Also, how can I tell how much is currently owing on an account?
>>
>> Thanks.
>
>
> --
> Got Input?   Slashdot Needs You.
> Take our quick survey online.  Come on, we don't ask for help often.
> Plus, you'll get a chance to win $100 to spend on ThinkGeek.
> http://p.sf.net/sfu/slashdot-survey
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | www.citrusdb.org
Open Source Customer Service & Billing

--
Got Input?   Slashdot Needs You.
Take our quick survey online.  Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Total Newb; how does it work?

[Paul Yasi]

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 their information.

You can host citrusdb in any LAMP server, though a server on your LAN
is usually best.  It does store potentially sensitive customer data
that should be hosted in a way that meets your organisations security
policies regarding the storage of customer information.

Paul

2011/7/15 Mark E. Skeels :
> Hi, all.
>
> I joined this list because the features of CitrusDB look good for what I
> would like to do with a website.
>
> I am not a website developer, but I am technically minded. I am probably in
> way over my head, but here goes.I want to start a small service oriented
> business. I want my customers to be able to "log in" to my website and get
> status info on their repairs, including projected completion of repair,
> cost, invoices, and maybe other stuff. I want to do it really cheap.
>
> My questions:
>
> I understand that CitrusDB is not a website, but how do the forms/data/input
> screens/etc get integrated/show up on a website?
> Exactly what IS CitrusDB? Think really basic here.I mean, does it create
> a website from a kind of template? Does it integrate into a website? How
> does it "show up?" Is it a complete "solution" or is it integrated somehow?
> Can an end user secure a website from any provider with the necessary stuff
> (mySQL, PHP, etc) and install CitrusDB him/herself?
> Do you have to ask the provider to do this, or is it customary to just get
> the provider service established and then do it?
> Can I install and configure this myself? Or is this something I have to have
> done by the website provider?
>
> I scanned the manual on CitrusDB; what I really need is a kind of general
> overview of how this all fits into a website and the general steps needed to
> get it up and running, something like..
>
> Obtain Web provider
> Obtain domain name
> Design and implement website
> Install CitrusDB
> Configure CitrusDB
> GO (?)
>
> Thanks,
> Mark
>
> That's enough questions for now..we'll see what kind of answers
> I get.
>
> --
> "If your creed and Scripture do not agree,
> cut your creed to pieces,
> but make it agree with this book."
> ~Charles Spurgeon~
>
> --
> AppSumo Presents a FREE Video for the SourceForge Community by Eric
> Ries, the creator of the Lean Startup Methodology on "Lean Startup
> Secrets Revealed." This video shows you how to validate your ideas,
> optimize your ideas and identify your business strategy.
> http://p.sf.net/sfu/appsumosfdev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Storage Efficiency Calculator
This modeling tool is based on patent-pending intellectual property that
has been used successfully in hundreds of IBM storage optimization engage-
ments, worldwide.  Store less, Store more with what you own, Move data to 
the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] new user

[Paul Yasi]

Welcome to citrusdb, this list is still active, though often quiet.

There is a new project i'm working on to refactor citrusdb into
codeigniter if anyone is interested.  This is totally unusable right
now, and i'm not sure how far i'll get.  It is hosted at github,
https://github.com/paulyasi/citrusdb

citrusdb is using mail() in some places, but is swiftmailer to email
invoices in the most recent versions.  swiftmailer can be told to use
smtp or sendmail as well if that is what you are looking for.

Paul

On Sat, Jul 2, 2011 at 6:46 PM, Julian @ digitalctrl
 wrote:
> Yes, it's still active. We're still here. :)
>
> When I did an original setup for a client, I did the same. Many webhosts do
> not allow their users to do this simple and necessary thing. Luckily,
> there's a few of us who can and it seems we have the smarts to know to take
> advantage of it.
>
> Also, greetings, mate. :)
>
> --
>
> Julian B. Wilson
> Lead IT Professional
> Blackberry Phone: 248.912.7828
>
> Call digitalctrl toll-free at:
> 1.888.889.0522
>
> Check out our new home on the web:
> http://www.digitalctrl.org
>
> -Original Message-
> From: Victor Ientilucci [mailto:vic...@megawebsiteservices.com]
> Sent: Saturday, July 02, 2011 2:24 PM
> To: citrusdb-users@lists.sourceforge.net
> Subject: [Citrusdb-users] new user
>
> Hey guys,
>
> I just installed citrusDB and I am a new user of the software.  I am
> just checking if this list is still active.
>
> I see that the config file is in the public space. This is not good. I
> have moved the config file to a location outside of the public
> directory.  I will also be changing it to use SMTP PEAR Mail.  I'll
> release the changes once I am done if anyone cares.
>
> Thanks.
>
> --
> Victor Ientilucci
> President
> Mega Website Services
> 416-779-6969
> vic...@megawebsiteservices.com
> http://megawebsiteservices.com
>
>
>
> 
> --
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
> --
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security 
threats, fraudulent activity, and more. Splunk takes this data and makes 
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Search not working.

[Paul Yasi]

The customer you are viewing is stored as a session variable, so if
that isn't working then you cannot view anything but the first
customer number.

It sounds like you do not have a session storage location properly
setup in your php configuration.

Paul

2011/5/7 "Ing. Oscar Hernández C." :
> Hello,
>
>   Just installed CitrusDB to try it's functionality; made initial
> configuration without problems.
>
>   Using version 2.4, XAMPP Lite 1.7.3 on windows. Tested with Maxthon
> 3.02, IE 9 and FF4.
>
>   Variables:
>
> // define variables
> $sys_dbhost = 'localhost';
> $sys_dbuser = 'citrus';
> $sys_dbpasswd = 'citruspass';
> $sys_dbname = 'citrus';
> $sys_dbtype = 'mysql';
> $path_to_citrus = 'G:\xampplite\htdocs\citrus\\';
> $hidden_hash_var='youmustchangethis';
> //$lang = './include/local/es-spanish.inc.php';
> $lang = './include/local/us-english.inc.php';
> $url_prefix = "http://localhost/citrus/";;
> $ssl_url_prefix = "https://localhost/citrus/";;
>
>
>   One thing I noticed at first run was this error:
>
> Warning: session_module_name() [function.session-module-name]: A session
> is active. You cannot change the session module's ini settings at this
> time in
> G:\xampplite\htdocs\citrus\include\adodb\session\adodb-session2.php on
> line 465
>
> Warning: Unknown: Failed to write session data (files). Please verify
> that the current setting of session.save_path is correct
> (G:\xampplite\tmp) in Unknown on line 0
>
>   I changed session.auto_start = 0 to avoid that error, but don´t know
> if that is causing the following problem, as I can see session files
> created in that folder.
>
>   Every time I search for customers (added 2) search result always show
> the Example Customer from DB, no matter if entered partial or exact name.
>
>   If I enter a non valid name no records are found, that's OK. If I
> click the try again link the search page is shown again and in the left
> side the recently "viewed" customers. Strange thing is that the ID and
> Name of the 2 customers I entered are shown multiple times; if I click
> over the Id and name, again the Example Customer is shown.
>
>   If I search with an empty box on Name/Company I get the 3 customers,
> but again if I click on any customer the Example customer is shown.
>
>   Tried also searching by account number with same results.
>
>   BTW what the "source" field for customer is intended for, referral or
> something like that ?
>
>   Example Customer account number is 1, the other two are 10001 and
> 10001; is there a way to set an extra or custom account number ?
>
>   Any Ideas? Hope my description help to trace the problem.
>
>   TIA, Oscar.
>
>
> --
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today.  Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | www.citrusdb.org
Open Source Customer Service & Billing

--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] CitrusDB 2.4 Released

[Paul Yasi]

CitrusDB 2.4 is now available.  This release now requires SSL for
login and uses the phpass framework to support stronger bcrypt
password hashes.  A new service churn report has been added.  Message
tabs now have separate pages for each usergroup and give a green
notification upon new messages, and the tab nav style has been  added
to the online customer portal.

While most feature of citrus will continue to work with older versions
of php, php 5.3 is now recommended for it's built in bcrypt support.

Download it now at: http://www.citrusdb.org

Get an SSL certificate from your choice of certificate authorities at:
https://www.certs4less.com/1035.html

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] Looking for citrusdb consulting partners

[Paul Yasi]

Due to customer privacy laws and payment card industry standards that
recommend a separation of duties between development and production
work I am restricted from taking on work myself for installation and
integration of citrusdb onto production systems at customer sites.

I am looking to make a list on the citrusdb.org site of consulting
partners that I can refer users to in different regions of the globe.
To qualify as a consulting partner please send me an email that
documents your experience with citrusdb and LAMP environments and
provide details about your consulting business background.  You must
also join the citrusdb commercial support program for $199 per year to
remain listed and to have direct access to myself for any questions or
issues you may have.

And thank you to everyone who makes citrusdb more awesome,

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Adding Additional Fields (particularly images)

[Paul Yasi]

I'm not sure this would be something that would be useful in the release
version, maybe an option to add at some point.  You could hack it in to the
customer view by adding some code to the modules/customer/index.php file
around line 203 replace it with something like:

  "".
  "".
  "".
  "".
  "";

Paul

2011/3/17 Julian @ digitalctrl 

>  Hello all!
>
> I recently installed citrusDB and it is virtually flawless for my needs.
> However, I would like to do some customization to the script, particularly,
> I would like to add the ability to store pictures with the customer records.
> I will either be scanning driver's license photos or using a webcam to snap
> a picture of my customers.
>
> Is there an addon available for this? If not, what would be a good place to
> start to add fields to the customer record?
>
> My thought is that the image file would be saved in a folder (ie.
> ./identities) by the customer record number (ie. 10002.jpg). I am not
> necessarily looking to add this when the customer record is created but
> instead, upload the image to the folder and have it automatically pulled
> upon record view.
>
> Any ideas on where to start or what I should be looking for would be great.
> Thanks.
>   --
>
> *J*ulian *B*. *W*ilson, Lead Professional
> digital*ctrl* .:. *Polished. Professional. Certified.*
> *1.888.889.0522*
>
> For all your *in-home* *&* *on-site* computer needs for today's growing
> digital world.
>
> Check out our new home on the web:
> http://digitalctrl.org
>
>
>
> --
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>


-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
--
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] Citrusdb Version 2.3 Release

[Paul Yasi]

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.  This newer PHP is
required to be compatible with the swiftmailer library now being used
to send einvoices.

You can grab the new version from http://www.citrusdb.org

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] CitrusDB 2.2 Released

[Paul Yasi]

I'm happy to announce the release of citrusdb version 2.2.  This
release now includes the full documentation, LDAP authentication
support, tabs for each message group, and many other minor features
and bug fixes.  Download the latest version from
http://www.citrusdb.org

I am also announcing the availability of Commercial Email Support
Service.  This service is $199 per year and provides unlimited support
incidents handled via email and direct developer consultation.  You
can find more at http://www.citrusdb.org/support.html

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] help

[Paul Yasi]

The \' at the end of your $path_to_citrus path is causing it to escape
the single quote and not close the string.  You need to put two
slashes at the end of that line, or you can use forward slashes
unix-like and not need to specify C: on windows, apache/php treats C:
as the root directory, eg:

$path_to_citrus = 'C:\xampp\htdocs\citrus\\';

OR

$path_to_citrus = '/xampp/htdocs/citrus/';

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System


> The Next 800 Companies to Lead America's Growth: New Video Whitepaper
> David G. Thomson, author of the best-selling book "Blueprint to a
> Billion" shares his insights and actions to help propel your
> business during the next growth cycle. Listen Now!
> http://p.sf.net/sfu/SAP-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | www.citrusdb.org
Open Source Customer Service & Billing

--
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a 
Billion" shares his insights and actions to help propel your 
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] CitrusDB 2.1.1 released

[Paul Yasi]

This is a maintenance release for citrusdb that fixes some bugs and adds
minor features.

- fixes to the credit card import and update function
- added a button to delete a service today
- added a vendor history for auditing later
- fixes to typos and various undefined variables
- customer summary now shows a monthly billable total
- added a portuguese language file
- added a way to retry batch exports if it failed when decrypting card data
- added autoeinvoice script

You can get the latest version of citrus by visiting
http://www.citrusdb.org/

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System


--
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users 
worldwide. Take advantage of special opportunities to increase revenue and 
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Citrus DB CSS issue

[Paul Yasi]

There is not much style being applied in the html of the online customer
site since I thought one would want to wrap it in their own brand's css
anyway.  This question has been asked before though, so maybe that was a
wrong assumption by me and I should apply more styles to the there.

What kind of style are users looking for?  Would a similar left tabnav
style applied to the links for profile, services, billing, etc like the
citrus interface be good?

Paul

On 08/09/2010 06:54 PM, ehall...@webfatcat.com wrote:
> I recently set up the service, but I noticed that the customer account
> manager has no formatting.
>
> Looking at the HTML code I see it referencing the CSS file, and when I
> look to the server the file is there.  For some reason it is not loading.
>
> I tried to set the permissions to 777 on the entire directory, but still
> no luck.
>
> The Admin side is workin with the css file it's dir contains.  Tried
> moving that one as well, but no luck.  I am guessing something is wrong
> with the HTML generated, but I don't see it.  The login for Customer
> Account Manager also has style.
>
> Any help would be greatly appreciated.
>
> Here is the head:
>
>
> 
>   Customer Account Manager
>   
>   
>   function h(oR) {
>   oR.style.background-color='ffdd77';
>   }
>   function deh(oR) {
>   oR.style.background-color='ee';
>   }
>   function dehnew(oR) {
>   oR.style.background-color='ddeeff';
>   }
>   
>   
>   Customer Account Manager: Account
> 1Profile |  href="index.php?cmd=view_services">Services |  href="index.php?cmd=view_bill">Billing |  href="index.php?cmd=support">Support Request |  href="logout.php">Logout
>
>
> Thanks,
> Eric
>
>
>
> --
> This SF.net email is sponsored by 
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev 
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> 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 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Using the auto scripts

[Paul Yasi]

Here is script that I put together for automatic sending of einvoices. 
You can put it in the citrusdb root folder and run it from cron daily to
send einvoices to those customers that have E-Invoice billing types and
the current day as their next billing date.

I've put it into the code repository.  You can get the file by going
there and clicking download file: 

http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/annotate/head%3A/scripts/autoeinvoice

(this link seems to give an error sometimes, but if you refresh it
should load)

Paul

On 06/22/2010 06:18 PM, David Boutcher wrote:
> Thanks for that Paul
>
> After a lot of fiddling someone  suggested I add this line to the  
> start of the statusupdate file:
>
> chdir("/var/www/mydomain.com/web/billing/");
>
> Which worked really well. Maybe you can consider adding this as  
> standard? Some how use a variable for the path?
>
> If you could 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 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 shell script in the the cronjob to just call  
>> statusupdate at
>> the location where it is, something like:
>>
>> #!/bin.sh
>> /var/www/citrusdb/statusupdate
>>
>> I don't know of a modified version of the run email invoice script  
>> that
>> is out there now, I might be able to throw an untested one together.
>> The file that would need to be modified is the
>> citrusdb/tools/modules/billing/einvoice.php
>>
>> Paul
>>
>> On 06/18/2010 06:25 AM, David Boutcher wrote:
>> 
>>> I'm having a little trouble getting the statusupdate script to work,
>>> which is probably down to my lack on linux knowledge.
>>>
>>> If I execute the statusupdate script from it's own directory, it runs
>>> without problem. However, if i try to run it from any where else it
>>> returns lots of errors.
>>>
>>> I'm trying to  get toward it running as a cronjob, but if I can't get
>>> it run by command line i'm sure the cronjob will also fail.
>>>
>>> Can someone point me in the right direction please.
>>>
>>>
>>> My other question is, does anyone have a modifed version of run email
>>> invoice script so I can set it to run every night using the current
>>> date please?
>>>
>>> David
>>>
>>> --
>>> ThinkGeek and WIRED's GeekDad team up for the Ultimate
>>> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
>>> lucky parental unit.  See the prize list and enter to win:
>>> http://p.sf.net/sfu/thinkgeek-promo
>>> ___
>>> Citrusdb-users mailing list
>>> Citrusdb-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>>>
>>>   
>>
>> --
>> ThinkGeek and WIRED's GeekDad team up for the Ultimate
>> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
>> lucky parental unit.  See the prize list and enter to win:
>> http://p.sf.net/sfu/thinkgeek-promo
>> ___
>> Citrusdb-users mailing list
>> Citrusdb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>> 
>
> --
> ThinkGeek and WIRED's GeekDad team up for the Ultimate 
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
> lucky parental unit.  See the prize list and enter to win: 
> http://p.sf.net/sfu/thinkgeek-promo
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>   


--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Support for telecommunications per-minute service

[Paul Yasi]

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 and show the result as the total on the invoice.

You'll have to make a script that adds this new service with the
corresponding usage amounts.  You can call the create_service function
by inluding the include/services.inc.php in your script.

include('./include/config.inc.php');
include('./include/database.inc.php');
include('./include/services.inc.php');

create_service($account_number, $master_service_id, $billing_id,
$usage_multiple, $options_table_name,
$attribute_fieldname_string,
$attribute_fieldvalue_string)

The usage_multiple must is your minute usage that you are inserting.

I imagine that minute usage won't have an options/attributes table
associated with it, but if you have an attributes table you'll need to
use the attribute_fieldname_string that names the attribute table fields
you want to fill in such as:
$attribute_fieldname_string = "username, password";
$attributes_fieldvalue_string = "'myname', 'p4ssw0rd'";

If you do not have an options/attributes table you can leave them as NULL. 

create_service($account_number, $master_service_id, $billing_id,
   $usage_multiple, NULL, NULL, NULL);

If you do have an options/attributes table but are not inserting
attributes right
now you'll still want to include something as a placeholder so it
makes the attributes table for this particular service item.

Paul

On 06/25/2010 04:45 PM, Matt Rygelski wrote:
> How would I configure CitrusDB to allow me to do the following?
>
> I have customers who are on a monthly recurring service that is flat rate for 
> X number of minutes per month.  I receive an output from my system as a comma 
> delimited file that shows every unique service number (Service ID) and it's 
> total use for that billing period.  I want to be able to upload that file 
> every month and let the CitrusDB not only generate an invoice for the flat 
> "base" rate per month but also charge them if there were any use over the X 
> number of minutes they already paid for.  Thoughts?
>
>
>
>   
>
> --
> ThinkGeek and WIRED's GeekDad team up for the Ultimate 
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
> lucky parental unit.  See the prize list and enter to win: 
> http://p.sf.net/sfu/thinkgeek-promo
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>   

--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Login Failure. Please See Administrator error

[Paul Yasi]

There is a table called login_failures that will record your IP address
each time you fail to enter the correct password.  If you fail more than
5 times in a 24 hour period it will not allow you to try logging into
the system again.  You'll need to go to the login_failures table and
remove the rows it added that contain your IP address (or wait 24 hours)

If you somehow changed the admin password by accident to something that
you don't know you will need to manually reset it by opening the user
table and putting in an MD5 in to the password field for the admin user
that you do know.  The following is the MD5 for the default password 
"test" that you can paste in there:

098f6bcd4621d373cade4e832627b4f6


Paul

On 06/18/2010 10:42 PM, AC Perdon wrote:
> Hi,
>
> I have change the admin password to my desired password and also
> created a new account that has als same access right as admin. I have
> entered the password 4 - 5x and it was not accepted I tried the new
> account it was successful then I tried the admin same error and worst
> the error wont go even if I rebooted the server  I keep getting Login
> Failure. Please See Administrator error no loging page is loading . I
> could not figure it out why I'm getting this..
>
>
> Regards,
> AC
>
>
> --
> ThinkGeek and WIRED's GeekDad team up for the Ultimate 
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
> lucky parental unit.  See the prize list and enter to win: 
> http://p.sf.net/sfu/thinkgeek-promo
>
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>   

--
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Using the auto scripts

[Paul Yasi]

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 shell script in the the cronjob to just call statusupdate at
the location where it is, something like:

#!/bin.sh
/var/www/citrusdb/statusupdate

I don't know of a modified version of the run email invoice script that
is out there now, I might be able to throw an untested one together. 
The file that would need to be modified is the
citrusdb/tools/modules/billing/einvoice.php

Paul

On 06/18/2010 06:25 AM, David Boutcher wrote:
> I'm having a little trouble getting the statusupdate script to work,  
> which is probably down to my lack on linux knowledge.
>
> If I execute the statusupdate script from it's own directory, it runs  
> without problem. However, if i try to run it from any where else it  
> returns lots of errors.
>
> I'm trying to  get toward it running as a cronjob, but if I can't get  
> it run by command line i'm sure the cronjob will also fail.
>
> Can someone point me in the right direction please.
>
>
> My other question is, does anyone have a modifed version of run email  
> invoice script so I can set it to run every night using the current  
> date please?
>
> David
>
> --
> ThinkGeek and WIRED's GeekDad team up for the Ultimate 
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
> lucky parental unit.  See the prize list and enter to win: 
> http://p.sf.net/sfu/thinkgeek-promo
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>   


--
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] reviced get_nextbillingdate...

[Paul Yasi]

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 Eric Cho :
> Hi. Folks-
>
> Today I found weird date problem.
>
> July 2010 and Aug 2010 has same 31 days.
>
> So, citrusDB's billing date will be mixed horribly.
>
> (also, I thought from_date should be set as to_date when we roll up to next
> month)
>
> Basically, I found that prev_billing_date column in billing table didn't be
> use from anywhere.
>
> So, I'm use this column as original date that is same with from_date when
> user edited billing info.
>
> Here are some codes-
>
> [include/billing.inc.php]
>
> line 767 -
> $myOrigdate = $billingresult['b_prev_date'];
>
>     // double frequency to add to the to_date
>     $doublefreq = $mybillingfreq * 2;
>
>     // insert the new next_billing_date, from_date,
>     // to_date, and payment_due_date to next from_date
>     $query = "UPDATE billing ".
>         "SET next_billing_date = to_date, from_date = to_date, ".
>       "payment_due_date = to_date, ".
>       "to_date = DATE_ADD('$myOrigdate', ".
>       "INTERVAL PERIOD_DIFF(DATE_FORMAT(to_date, '%Y%m'), ". date('Ym',
> strtotime($billingresult['b_prev_date'])). ")+1 MONTH) ".
>       "WHERE id = '$mybilling_id'";
>     $updateresult = $DB->Execute($query) or die ("Query Failed");
>
>
> (add above selection query - line 740)  b.prev_billing_date b_prev_date,
>
>
> [module/billing/edit.php]
>
> line 187, line 239 - (not be exact)
>
>   "prev_billing_date = '$next_billing_date',". // 2010-05-29 for month
> adding, original column
>
>
> finished.
>
> take a look these codes, and please let me know if you find any wrong part.
>
>
>
> --
>
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--

___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] (no subject)

[Paul Yasi]

I think your keyring is probably owned by a different user than the
one that the web server is running as.  You must change the
permissions of the keyring files to allow read/write access from the
web server account.

I think the permissions below should work, though I haven't tested
them recently.

chmod 777 .gnupg

cd .gnupg
chmod 604 random_seed
chmod 644 pubring.gpg
chmod 644 secring.gpg
chmod 644 trustdb.gpg

Paul

On Sun, May 23, 2010 at 7:04 PM,   wrote:
> I'm having real trouble with the keys
>
> when I execute the command it seems to write the key to /root/.gnupg
>
> my config files looks like this
> $gpg_command = "/usr/bin/gpg --homedir /root/.gnupg --armor --batch -e -r
> 'citrusdb'";
> $gpg_decrypt = "/usr/bin/gpg --homedir /root/.gnupg --passphrase-fd 0
> --yes --no-tty --skip-verify --decrypt";
> $gpg_sign = "/usr/bin/gpg --homedir /root/.gnupg --passphrase-fd 0 --yes
> --no-tty --clearsign -u 'citrusdb'";
>
> citrusdb was the real name i gave the key gen.
>
> but when I try to store a card number i get this error:
>
> Credit Card Encryption Error: error: gpg: WARNING: unsafe ownership on
> homedir `/root/.gnupg' gpg: failed to create temporary file
> `/root/.gnupg/.#lk0x8117040.badbuntu.badbison.co.uk.6225': Permission
> denied gpg: keyblock resource `/root/.gnupg/secring.gpg': general error
> gpg: failed to create temporary file
> `/root/.gnupg/.#lk0x8117040.badbuntu.badbison.co.uk.6225': Permission
> denied gpg: keyblock resource `/root/.gnupg/pubring.gpg': general error
> gpg: citrusdb: skipped: public key not found gpg: [stdin]: encryption
> failed: public key not found
>
>
> I bought the manual but that didn't make things much clearer.
> i'd really appreciate some help. thanks
>
> dave
>
>
> --
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--

___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Query Failed

[Paul Yasi]

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 through the log files for mysql or apache.  Is this
site hosted on a server you control?  Did something change on the
server or mysql configuration?

Paul

On Tue, May 18, 2010 at 2:19 PM, Cornita Tutt-Pinchinat
 wrote:
> Hi,
>
> I have been using Citrus for my customer DB without any problems until
> yesterday.  Now when I search most fields I get a query failed
> message.  For example if I search Name/Company I get data but If I
> search Account Number I get the message query failed.  The last day I
> used it successfully was 5/5/10. I have not made any changes since
> then.  I am able to query some fields without any problems.   I am
> unable to add any new customers.  Any ideas?  If you need any
> additional info let me know and I will get it to you.
>
> --
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--

___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Typo in dashboard.php?

[Paul Yasi]

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 variables to fix also.

Paul

On Fri, May 14, 2010 at 4:11 PM, Rich Cloutier  wrote:
> Just downloaded the latest version (2.1 stable) the other day to play with.
>
> Turned on E_ALL error reporting and I think I've found a typo in
> dashboard.php on line 46:
>
>     $nummessages = $nummessaes + $num_rows;
>
> I think that should be:
>
>     $nummessages = $nummessages + $num_rows;
>
> Also, you use variables in your language files that are undefined (or
> can be:)
>
> $payment_due_date, $total_owed, $turnoff_date, $cancel_date, $phone_billing
>
> Turning on notices and fixing undefined variables can be a pain in the
> butt but I think it leads to better programming, a more robust script
> (will run properly in more environments) and sometimes you catch errors
> like the above.
>
> Rich
>

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--

___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] need help adding more info to citrus db.

[Paul Yasi]

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 editing the example service you can start by creating a new
service using the Edit Services icon under the Tools.  Click on Add
New Service and add your new service info, descrption, price.  The
frequency field refers to the number of months this service is billed
for at a time.  So if it's a monthly service enter 1, if it's a yearly
service enter 12, etc.  Then you get to the part the deals with the
attributes tables.  If this is a brand new service that does not share
attributes with another service type you can enter a new table name
here, something like myservice_attributes.  Then enter a new category
if you want, whether it is actively sold, and whether any database
user needs to be notified when it's status changes.  Then click Add.
Now you will have made a new service.

Then click on the link that says Options/Attributes Tables on that
screen.  Click the create link that is next to your new attribute
table.  This will add that table to the database with the required ID
fields.  Now to add any attribute fields to that table you must use a
database editor like phpmyadmin or SQL alter statements.  You can add
as many fields as you require.  The first two fields you add will be
shown as details on the service listing.  ENUM type fields will be
treated as drop down lists to choose from.

Paul

2010/5/16 Tim Reichhart :
> Hey Guys
> needing help adding more options that citrus db don't have in there right
> now: here is images I am talking about:
> http://tinypic.com/r/11l53ck/5
> http://tinypic.com/r/2mxqxzr/5
>
> --
>
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--

___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] FCC may require protection of confidential information for any internet service providers.

[Paul Yasi]

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 way' the FCC may require
service providers to follow section 222 of the common carrier
regulations which concerns the privacy of customer information.
Currently these regulations pretty much apply just to phone service
providers and not other providers of internet services.

There is a blueprint in launchpad from a while ago that has a link to
some more info about the CPNI regulations also,
https://blueprints.launchpad.net/citrusdb/+spec/cpni

Does anyone out there already use citrus in a section 222/CPNI
compliant way?  Am I right in thinking that CPNI and section 222
compliance are the same or overlap?

Paul
-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--

___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] about citrusdb with paypal

[Paul Yasi]

There is no built in option that connects to paypal.  At one time I
thought that paypal's virtual terminal had a batch file upload
feature, but I cannot find documentation on that now.

It may be possible to use Paypal's Website Payments Pro Payflow
Edition API.  
https://cms.paypal.com/us/cgi-bin/?&cmd=_render-content&content_ID=developer/howto_gateway_payflow_wpp

The authorizenet file in the scripts folder may give you some idea of
how to connect to such an API.

Paul

2010/5/14 Tim Reichhart :
> Hi Guys
> is there a option that I can select for payment option for paypal or not?
>
> --
>
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--

___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] I get this information when i try to login

[Paul Yasi]

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  wrote:
> Hello,
> Thanks for the good work out there.
>
> i have tried to install this system and also tried to configure most
> of the things but when i try to login, i get the information below
>
> Not Found
>
> The requested URL /~pyasi/citrus_project/citrusdb-gpg/index.php was
> not found on this server.
>
> Your help will be highly appreciated
>
> Thanks
>
> Ronnie
>
>
>
>
> --
> M.Ronnie
> Tel:+256772986964
> Email: ronel...@gmail.com
>
> Weblinks
> www.gicug.com
> www.ugsports.net
> www.wauganda.net
> www.swclubi.com
> etc.
>
> Quote
>
> The World is a dangerous place, Not just because of those who do evil,
> But also because of those who look on and Do Nothing!
>
> I Struggle hard not to be a Product of my Environment, but rather my
> environment to be a Product of me!
>
> --
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] I got error during conduct refund.

[Paul Yasi]

Ok, Eric you are in there!

Paul

2010/4/26 Eric Cho :
> Oh. Thanks.
>
> This is my address for twitter. I hope you add this there.
>
> http://twitter.com/myfoxfree
>
> Appreciate!
>
> -Eric
>
>
> ____
> From: Paul Yasi 
> To: For users of CitrusDB discussion 
> Sent: Tue, April 27, 2010 8:58:38 AM
> Subject: Re: [Citrusdb-users] I got error during conduct refund.
>
> I've added this code in there now.  I also added your name to the code
> contributor list.  Do you have a domain name you would like listed
> next to your name?
>
> http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/revision/242
>
> Thanks,
>
> Paul
>
> 2010/4/26 Eric Cho :
>> Oh sorry.
>>
>> I forgot to attach my code in tools/refund.php
>>
>> As at #2, I made this codes at line 46~
>>
>>     if ($refundamount == 0) {
>>         $query = "UPDATE billing_details SET
>>         refund_amount = 0.00,
>>         refund_date = null
>>         WHERE id = $detailid";
>>         $result = $DB->Execute($query) or die ("$query Query Failed");
>>
>>     } else {
>>
>>         $query = "UPDATE billing_details SET
>>         refund_amount = '$refundamount',
>>         refund_date = CURRENT_DATE
>>         WHERE id = $detailid";
>>         $result = $DB->Execute($query) or die ("$query Query Failed");
>>     }
>>
>> So I could cancel refunding by put price as 0.. before actually refund
>> when
>> I click refund button in tools menu.
>>
>> Please take a look this.
>>
>> Thanks.
>>
>> -Eric
>>
>>
>>
>>
>> 
>> From: Eric Cho 
>> To: For users of CitrusDB discussion
>> 
>> Sent: Mon, April 26, 2010 5:51:41 PM
>> Subject: Re: [Citrusdb-users] I got error during conduct refund.
>>
>> Thanks for your reply.
>>
>> #1,
>>
>> As I tried 'creditcard' instead of 'prepaycc', it works well same as
>> 'prepaycc'. (almostly 100% for me)
>>
>> What's exactly differences 'creditcard' and 'prepaycc'??
>>
>> I could use both, since I can control billing date (upcoming).
>>
>>
>> #2,
>>
>> When I tried refund I couldn't find a message such "You must manually
>> process ...   that you said.
>>
>> Anyway, I added exception code for cancel refunding before executing
>> refund
>> button in tools menu.
>>
>> (Since I will use it in a batch process on a regular basis.)
>>
>> I hope it helps you even less :)
>>
>>
>> Thanks in everytime.
>>
>> Regards.
>>
>> -Eric
>>
>>
>>
>> 
>> From: Paul Yasi 
>> To: For users of CitrusDB discussion
>> 
>> Sent: Mon, April 26, 2010 9:02:33 AM
>> Subject: Re: [Citrusdb-users] I got error during conduct refund.
>>
>> Item 1:  Refunds do not currently work for prepaycc billing types,
>> only normal monthly creditcard bills.  When you went into the refund
>> report to indicate the amount of the refund it would have came back
>> with a message: "You must manually process a refund for this billing
>> method"  Prepaycc had sort of been deprecated as a billing type since
>> it's somewhat useless, except that is prevents the customer from being
>> charged again in X months automatically if their previous billing
>> failed.
>>
>> Item 2: the way it handle's importing prepaycc billing types is a bug,
>> however the right fix for this is to change the importcc code that
>> inserts into payment_history to always indicate a creditcard payment
>> type instead of looking to whatever billing method is being used,
>> since the import credit card tool will always be importing credit card
>> payments.  A prepaycc billing type is still paid with a creditcard
>> payment type.  Billing type and Payment Type are two different things.
>>
>> I just commited this change shown here:
>> http://bazaar.launchpad.net/%7Epaul-citrusdb/citrusdb/gpg/revision/240
>>
>> Item 3: My own card software gives me an "N" and some other software I
>> had gave a "38" as a code, so I just have that in there for myself.
>>
>> Paul
>>
>> 2010/4/24 Eric Cho :
>>> Hello.
>>>
>>> I did some of test for CitrusDB.
>>>
>>> I'm using that based on prepaycc (pre-

Re: [Citrusdb-users] I got error during conduct refund.

[Paul Yasi]

I've added this code in there now.  I also added your name to the code
contributor list.  Do you have a domain name you would like listed
next to your name?

http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/revision/242

Thanks,

Paul

2010/4/26 Eric Cho :
> Oh sorry.
>
> I forgot to attach my code in tools/refund.php
>
> As at #2, I made this codes at line 46~
>
>     if ($refundamount == 0) {
>         $query = "UPDATE billing_details SET
>         refund_amount = 0.00,
>         refund_date = null
>         WHERE id = $detailid";
>         $result = $DB->Execute($query) or die ("$query Query Failed");
>
>     } else {
>
>         $query = "UPDATE billing_details SET
>         refund_amount = '$refundamount',
>         refund_date = CURRENT_DATE
>         WHERE id = $detailid";
>         $result = $DB->Execute($query) or die ("$query Query Failed");
>     }
>
> So I could cancel refunding by put price as 0.. before actually refund when
> I click refund button in tools menu.
>
> Please take a look this.
>
> Thanks.
>
> -Eric
>
>
>
>
> 
> From: Eric Cho 
> To: For users of CitrusDB discussion 
> Sent: Mon, April 26, 2010 5:51:41 PM
> Subject: Re: [Citrusdb-users] I got error during conduct refund.
>
> Thanks for your reply.
>
> #1,
>
> As I tried 'creditcard' instead of 'prepaycc', it works well same as
> 'prepaycc'. (almostly 100% for me)
>
> What's exactly differences 'creditcard' and 'prepaycc'??
>
> I could use both, since I can control billing date (upcoming).
>
>
> #2,
>
> When I tried refund I couldn't find a message such "You must manually
> process ...   that you said.
>
> Anyway, I added exception code for cancel refunding before executing refund
> button in tools menu.
>
> (Since I will use it in a batch process on a regular basis.)
>
> I hope it helps you even less :)
>
>
> Thanks in everytime.
>
> Regards.
>
> -Eric
>
>
>
> 
> From: Paul Yasi 
> To: For users of CitrusDB discussion 
> Sent: Mon, April 26, 2010 9:02:33 AM
> Subject: Re: [Citrusdb-users] I got error during conduct refund.
>
> Item 1:  Refunds do not currently work for prepaycc billing types,
> only normal monthly creditcard bills.  When you went into the refund
> report to indicate the amount of the refund it would have came back
> with a message: "You must manually process a refund for this billing
> method"  Prepaycc had sort of been deprecated as a billing type since
> it's somewhat useless, except that is prevents the customer from being
> charged again in X months automatically if their previous billing
> failed.
>
> Item 2: the way it handle's importing prepaycc billing types is a bug,
> however the right fix for this is to change the importcc code that
> inserts into payment_history to always indicate a creditcard payment
> type instead of looking to whatever billing method is being used,
> since the import credit card tool will always be importing credit card
> payments.  A prepaycc billing type is still paid with a creditcard
> payment type.  Billing type and Payment Type are two different things.
>
> I just commited this change shown here:
> http://bazaar.launchpad.net/%7Epaul-citrusdb/citrusdb/gpg/revision/240
>
> Item 3: My own card software gives me an "N" and some other software I
> had gave a "38" as a code, so I just have that in there for myself.
>
> Paul
>
> 2010/4/24 Eric Cho :
>> Hello.
>>
>> I did some of test for CitrusDB.
>>
>> I'm using that based on prepaycc (pre-pay Credit card), everything was
>> fine
>> but refund.
>>
>> When I tried to refund in the Billing's refund menu
>>
>> (http://localhost/citrus-2.1/index.php?load=refund&type=tools&billingid=45&submit=Submit),
>>
>> That records didn't exported when I tried export for one text file in the
>> http://localhost/citrus-2.1/index.php?load=refundcc&type=tools .
>>
>> (There's result file for that but content was empty.)
>>
>>
>>
>> So, I analyzed related source, I found something miss.
>>
>> 1. refunded = 'y' shouldn't do there, because refund export page works as
>> loading refunded<>'y'
>>
>> tools/refund.php line 51~61 has been changed as commentation.
>>
>> 2. DB scheme.
>>
>> DROP TABLE IF EXISTS `payment_history`;
>>
>> CREATE TABLE `payment_history` (

Re: [Citrusdb-users] Error on importing credit card change

[Paul Yasi]

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 :
> Hello!
>
> I found one little error in the "tools/modules/billling/importccupdate.php"
>
> 85 line
> I believe that
>       $armordate .= "$line[0]\n";
> will be change to
>       $armordata .= "$line[0]\n";
>
> 'e' >> 'a'
>
> I hope this information will be reflect to next version :)
>
> Have a good day!
>
> -Eric
>
>
> --
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] I got error during conduct refund.

[Paul Yasi]

Item 1:   Refunds do not currently work for prepaycc billing types,
only normal monthly creditcard bills.  When you went into the refund
report to indicate the amount of the refund it would have came back
with a message: "You must manually process a refund for this billing
method"  Prepaycc had sort of been deprecated as a billing type since
it's somewhat useless, except that is prevents the customer from being
charged again in X months automatically if their previous billing
failed.

Item 2: the way it handle's importing prepaycc billing types is a bug,
however the right fix for this is to change the importcc code that
inserts into payment_history to always indicate a creditcard payment
type instead of looking to whatever billing method is being used,
since the import credit card tool will always be importing credit card
payments.  A prepaycc billing type is still paid with a creditcard
payment type.  Billing type and Payment Type are two different things.

I just commited this change shown here:
http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/revision/240

Item 3: My own card software gives me an "N" and some other software I
had gave a "38" as a code, so I just have that in there for myself.

Paul

2010/4/24 Eric Cho :
> Hello.
>
> I did some of test for CitrusDB.
>
> I'm using that based on prepaycc (pre-pay Credit card), everything was fine
> but refund.
>
> When I tried to refund in the Billing's refund menu
> (http://localhost/citrus-2.1/index.php?load=refund&type=tools&billingid=45&submit=Submit),
>
> That records didn't exported when I tried export for one text file in the
> http://localhost/citrus-2.1/index.php?load=refundcc&type=tools .
>
> (There's result file for that but content was empty.)
>
>
>
> So, I analyzed related source, I found something miss.
>
> 1. refunded = 'y' shouldn't do there, because refund export page works as
> loading refunded<>'y'
>
> tools/refund.php line 51~61 has been changed as commentation.
>
> 2. DB scheme.
>
> DROP TABLE IF EXISTS `payment_history`;
>
> CREATE TABLE `payment_history` (
>   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
>   `creation_date` DATE NOT NULL DEFAULT '-00-00',
>   `transaction_code` VARCHAR(32) DEFAULT NULL,
>   `billing_id` INT(11) NOT NULL DEFAULT '0',
>   `creditcard_number` VARCHAR(16) DEFAULT NULL,
>   `creditcard_expire` INT(4) UNSIGNED ZEROFILL DEFAULT NULL,
>   `billing_amount` DECIMAL(9,2) DEFAULT NULL,
>   `response_code` VARCHAR(100) DEFAULT NULL,
>   `paid_from` DATE NOT NULL DEFAULT '-00-00',
>   `paid_to` DATE NOT NULL DEFAULT '-00-00',
>   `invoice_number` INT(128) DEFAULT NULL,
>   `status`
> SET('authorized','declined','pending','donotreactivate','collections','turnedoff','credit','canceled','cancelwfee','pastdue','noticesent','waiting')
> DEFAULT NULL,
>   `payment_type`
> SET('creditcard','prepaycc','check','cash','eft','nsf','discount') DEFAULT
> NULL,
>   `check_number` VARCHAR(32) DEFAULT NULL,
>   `avs_response` VARCHAR(32) DEFAULT NULL,
>   PRIMARY KEY (`id`),
>   KEY `billing_id_index` (`billing_id`)
> ) ENGINE=MYISAM AUTO_INCREMENT=142 DEFAULT CHARSET=latin1;
>
> (To sum up, there's only change of adding one enum for payment_type column
> as 'prepaycc' next to 'creditcard')
>
>
>
> 3. Not solved yet, I passed this step by wrote response as 'No' in the
> import file.
>
> tools/importcc.php line 79~
>
>     if ($response_id == 'N') { if ($transaction_code == 'CREDIT' OR
> $transaction_code == '38') {
>
> It's weird.. CREDIT (Refund) is suppose to be 'N' as response ??
>
> I wonder whether that is your intention or not.
>
>
>
> My object of this mail is confirm that is whether good approach, and if so,
> willing to help for you.
>
> Please let me know if there's something wrong
>
> Have a good weekend! :)
>
> Regards.
>
>
> --
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] I got error on admin page.

[Paul Yasi]

What browser are you using?  Could you try it in a different or newer browser?

Paul

2010/4/23 Eric Cho :
> 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 Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64;
> Trident/4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ;
> SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media
> Center PC 6.0)
> Timestamp: Fri, 23 Apr 2010 17:48:04 UTC
>
>
> Message: Object required
> Line: 27
> Char: 25
> Code: 0
> URI: http://localhost/CitrusDB/index.php?load=settings&type=tools
>
>
>
>
> So I opened that page's source by notepad there's something weird.
>
> function toggleOff()
> {
> var myelement =
> document.getElementById("WaitingMessage").style;
> myelement.display="none";
>
> This source looking for 'WatingMessage' variable, but there's nothing named
> like this in the source.
>
> How could activate this source ??
>
> Please take a look this problem for me.
>
> Thanks.
>
>
>
> --
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] CitrusDB 2.1 Released

[Paul Yasi]

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 at http://www.citrusdb.org

Instructions for field asset tracking:
http://www.citrusdb.org/help.html#sec-3.11

Paul
-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] error posting an invoice

[Paul Yasi]

You need to edit citrus to use a new path to save the data to.  That
is done by going to Tools and Opening the Settings tool.  Here you'll
see a Path to Credit Card File field.  You need to change that to your
own file path where the invoice can be stored.  It is also where card
data would be exported to if you are exporting card batches.

Paul

On Thu, Mar 25, 2010 at 2:46 PM, Cornita Tutt-Pinchinat
 wrote:
> Hi,
> I get an error message when trying to post invoices for a customer.
> The error is below the config file. I am new to PHP and Citrus so
> excuse me if this is obvious.
>
>
> $sys_dbhost = 'localhost';
> $sys_dbuser = 'myusername';
> $sys_dbpasswd = 'mypassword';
> $sys_dbname = 'mydb_citrus';
> $sys_dbtype = 'mysql';
> $path_to_citrus = '/home/gc2009/public_html/l4adb';
> $hidden_hash_var='myIhavechangedthis';
> $lang = './include/local/us-english.inc.php';
> $gpg_command = "/usr/bin/gpg --homedir /home/www-data/.gnupg --armor
> --batch -e -r 'CitrusDB'";
> $gpg_decrypt = "/usr/bin/gpg --homedir /home/www-data/.gnupg
> --passphrase-fd 0 --yes --no-tty --skip-verify --decrypt";
>
> // use these url prefixes to redirect between the ssl carddata and regular 
> pages
> // also maybe can be used with base href to help limit cross site scripting
> $url_prefix = "http://greencorn.net/l4adb/";;
> $ssl_url_prefix = "http://greencorn.net/l4adb/";;
>
>
>
> ERROR MESSAGE
>
> Warning: fopen() [function.fopen]: open_basedir restriction in effect.
> File(/home/pyasi/sites/io/invoice3.pdf) is not within the allowed
> path(s): 
> (/home/migrate.a2/web:/home/gc2009:/usr/lib/php:/usr/local/lib/php:/tmp)
> in /home/gc2009/public_html/l4adb/include/fpdf.php on line 1046
>
> Warning: fopen(/home/pyasi/sites/io/invoice3.pdf) [function.fopen]:
> failed to open stream: Operation not permitted in
> /home/gc2009/public_html/l4adb/include/fpdf.php on line 1046
> FPDF error: Unable to create output file: /home/pyasi/sites/io/invoice3.pdf
>
> --
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Editing the dashboard

[Paul Yasi]

Yes, I encourage you to modify it.  I kinda figure people will modify
it to fit their own branding.

Paul

2010/3/17 Icko.de.Guzman :
> Wow thanks for the tip Paul! That almost ruined my day.
>
> Follow up question though, on the customer account manager module (which can
> be accessed by through the http://mysitename.com/online), i noticed that it
> was a bit bland, and my client wants to modify it, can i change some parts
> of the customer module in a way that it will exhibit something similar to
> the administrator module?
>
> Thanks again for the output!
>
>
> M
>
> On Wed, Mar 17, 2010 at 10:32 PM, Paul Yasi  wrote:
>>
>> The name for the base modules are assigned in modules.php around line
>> 55.  It is using a  variable from the language file stored in
>> /include/local/.  It would probably be easiest to change the name in
>> the language file or make a new language variable file with your own
>> wording.
>>
>> Paul
>>
>> 2010/3/17 Icko.de.Guzman :
>> > Hi!
>> >
>> > I'm still a neophyte with programming CitrusDB, and I'm tasked with
>> > changing
>> > the menu links on the dashboard to something that is more relevant to
>> > our
>> > system.
>> >
>> > However while I was analyzing the dashboard in the customer page, I
>> > can't
>> > seem to find the actual code wherein the dashboard.php actually gets the
>> > modules allocated on the customer page.
>> >
>> > Please do let me know the work around for this issue, promise that I'll
>> > be
>> > greatly indebted.
>> >
>> > Thanks!
>> >
>> > M
>> >
>> >
>> > --
>> > Download Intel® Parallel Studio Eval
>> > Try the new software tools for yourself. Speed compiling, find bugs
>> > proactively, and fine-tune applications for parallel performance.
>> > See why Intel Parallel Studio got high marks during beta.
>> > http://p.sf.net/sfu/intel-sw-dev
>> > ___
>> > Citrusdb-users mailing list
>> > Citrusdb-users@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>> >
>> >
>>
>>
>>
>> --
>> The CitrusDB Project | http://www.citrusdb.org
>> Open Source Customer Care & Billing System
>>
>>
>> --
>> Download Intel® Parallel Studio Eval
>> Try the new software tools for yourself. Speed compiling, find bugs
>> proactively, and fine-tune applications for parallel performance.
>> See why Intel Parallel Studio got high marks during beta.
>> http://p.sf.net/sfu/intel-sw-dev
>> ___
>> Citrusdb-users mailing list
>> Citrusdb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
>
> --
> "I was born not only to serve you, but to love and protect you until the day
> I die."
>
> --
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Editing the dashboard

[Paul Yasi]

The name for the base modules are assigned in modules.php around line
55.  It is using a  variable from the language file stored in
/include/local/.  It would probably be easiest to change the name in
the language file or make a new language variable file with your own
wording.

Paul

2010/3/17 Icko.de.Guzman :
> Hi!
>
> I'm still a neophyte with programming CitrusDB, and I'm tasked with changing
> the menu links on the dashboard to something that is more relevant to our
> system.
>
> However while I was analyzing the dashboard in the customer page, I can't
> seem to find the actual code wherein the dashboard.php actually gets the
> modules allocated on the customer page.
>
> Please do let me know the work around for this issue, promise that I'll be
> greatly indebted.
>
> Thanks!
>
> M
>
> --
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Error on statusupdate

[Paul Yasi]

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 the same folder as the card
data it creates.

It looks like it is trying to open a file in /home/pyasi that is
probably not on your machine.  To change that go to the Tools and open
the Settings icon.  Here you will be able to modify the Path to Credit
Card File variable to your own file system path.

Paul

PHP Warning:  fopen(): SAFE MODE Restriction in effect.  The script
whose uid is 10163 is not allowed to access /home owned by uid 0 in
/srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/statusupdate
on line 46
PHP Warning:  fopen(/home/pyasi/citrus_project/io/accounts2010-03-16.csv):
failed to open stream: No such file or directory in
/srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/statusupdate
on line 46 cannot open
/home/pyasi/citrus_project/io/accounts2010-03-16.csv

2010/3/16 William Farrugia :
> Dear all,
> I recently installed citrusdb on a subdomain. Everything works fine except
> that I can't manage to run statusupdate. I'm saying run because I was trying
> to run it before setting a cron on it.
> on typing
> /usr/bin/php5 statusupdate
> i get
> PHP Notice:  Undefined variable: payment_due_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 316
> PHP Notice:  Undefined variable: total_owed in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 316
> PHP Notice:  Undefined variable: turnoff_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 318
> PHP Notice:  Undefined variable: cancel_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 320
> PHP Notice:  Undefined variable: cancel_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 322
> PHP Notice:  Undefined variable: cancel_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 324
> PHP Notice:  Undefined variable: cancel_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 324
> PHP Notice:  Undefined variable: phone_billing in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 326
> PHP Notice:  Undefined variable: phone_billing in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 328
> PHP Notice:  Undefined variable: payment_due_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 316
> PHP Notice:  Undefined variable: total_owed in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 316
> PHP Notice:  Undefined variable: turnoff_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 318
> PHP Notice:  Undefined variable: cancel_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 320
> PHP Notice:  Undefined variable: cancel_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 322
> PHP Notice:  Undefined variable: cancel_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 324
> PHP Notice:  Undefined variable: cancel_date in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 324
> PHP Notice:  Undefined variable: phone_billing in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 326
> PHP Notice:  Undefined variable: phone_billing in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/include/local/us-english.inc.php
> on line 328
> PHP Warning:  fopen(): SAFE MODE Restriction in effect.  The script whose
> uid is 10163 is not allowed to access /home owned by uid 0 in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/statusupdate on
> line 46
> PHP Warning:  fopen(/home/pyasi/citrus_project/io/accounts2010-03-16.csv):
> failed to open stream: No such file or directory in
> /srv/www/vhosts/mydomain.com/subdomains/billing/httpdocs/statusupdate on
> line 46 cannot open /home/pyasi/citrus_project/io/accounts2010-03-16.csv
> Any hints?
>
> Thanks,
> William.
> --
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel per

[Citrusdb-users] citrusdb 2.0.2 release

[Paul Yasi]

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 support notices to database users. To use this
feature you'll need to have your server configured to send email for
email notification or have a private jabber.xmpp server for the jabber
messenger notifications.

You can get the latest release at http://www.citrusdb.org

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Saving PDF Invoices to Server

[Paul Yasi]

When you said mailing them with a cron job, do you mean attaching them
to an email?  There is an e-invoice type for emailed invoices, however
it sends a text invoice right now.  At some point i'd like to add an
option that makes that attach pdf files to invoices too  that would
need to generate each pdf file and mime encode it and attach it to
each emailed e-invoice.  It may take longer for the server to
generate, and may make the invoice mail messages more susceptible to
spam blocking since PDF's are a common malware problem now.

Paul

2010/2/25 Ben Monypenny :
> Hi Paul,
>
> I have been working on a way to save the day's new invoices as PDF's to a
> path on the server for mailing with a cron job. My code is:
>
> 
> $host = 'localhost'; // MYSQL database host adress
> $db = 'dbname'; // MYSQL database name
> $user = 'dbuser'; // Mysql Datbase user
> $pass = $_REQUEST['password']; // Mysql Datbase password
> $rounddate = $_REQUEST['rounddate'];
>
> //parse round date
> $sheetyear = substr($rounddate,4,4);
> $sheetmonth = substr($rounddate,2,2);
> $sheetday = substr($rounddate,0,2);
> $date = $sheetyear."-".$sheetmonth."-".$sheetday;
>
> // Connect to the database
> $link = mysql_connect($host, $user, $pass);
> mysql_select_db($db);
>
> //Get data from citrus
> $query = "SELECT
> billing_details.billing_id,billing_details.invoice_number,customer.account_number
> FROM billing_details,customer WHERE
> billing_details.billing_id=customer.default_billing_id and
> billing_details.creation_date = '$date'";
> $result = mysql_query($query);
>
> //put data in array
> $i = "0";
> $details = array();
> while ($row = mysql_fetch_array($result)) {
> $details[$i][0]=$row[0];
> $details[$i][1]=$row[1];
> $details[$i][2]=$row[2];
> $i++;
> }
>
> //remove duplicates where there is more than one service per invoice
> $j = "0";
> $duplicates=array();
> $dets=$details;
> while ($j < $i+1) {
> if (in_array($details[$j][1],$duplicates)) {
> unset($dets[$j]);
> }
> array_push($duplicates,$details[$j][1]);
> //$details = array_values($details);
> $j++;
> }
>
> //save PDF invoices
> for ($m=0; $m<$i; $m++) {
> $url =
> "http://citrusurl/index.php?load=tools/printpreviousinvoice&billingid=".$dets[$m][0]."&invoiceid=".$dets[$m][1]."&details=on&type=dl&submit=on";;
> $path =
> "/home/user/invoices/".$sheetyear.$sheetmonth.$sheetday.$dets[$m][2].".pdf";
> $in = fopen($url,"rb");
> $out = fopen($path,"wb");
> while($chunk = fread($in,8192)){
> fwrite($out,$chunk,8192);
> }
> fclose($in);
> fclose($out);
>
> //print $dets[$m][0];
> //print $dets[$m][1];
> //print $dets[$m][2];
> }
>
> ?>
>
>
> When the script attempts to retrieve the PDF's it can't because it isn't
> logged into citrus. It is creating files with the citrus login page saved in
> them. Can you help with a workaround?
>
> Many thanks,
>
> Ben Monypenny
>
> --
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Saving PDF Invoices to Server

[Paul Yasi]

You'll need to take the code from printpreivous and edit it a bit and
run it outside of citrusdb with the php command line program.  If use
use SELECT DISTINCT billing_details.invoice_number I don't think
you'll need to do that thing that removes duplicate results either.

Include the  functions at the top, Then In place of where you call the
printpreivousinvoice URL you can put the rest of the code from
printpreviousinvoice.

// holds the config vars for database connection
include('./include/config.inc.php');

// connects the database and gives you a $DB object that is required
for outputinvoice function
include('./include/database.inc.php');

// holds the outputinvoice printing function
include('./include/billing.inc.php');

$invoiceid = $dets[$m][1];
$lang = "./include/local/us-english.inc.php";
$path = 
"/home/user/invoices/".$sheetyear.$sheetmonth.$sheetday.$dets[$m][2].".pdf";

require('./include/fpdf.php');
$pdf = new FPDF();

// write the data from the specified invoice
$pdf = outputinvoice($DB, $invoiceid, $lang, "pdf", $pdf);

// save the invoice to a file, F signifies File in FPDF output function
$pdf->Output($path, "F");


I think something like this will work.

Also the billing_id is not actually necessary to print previous
invoices, it's just left over from some old link code.

Paul



2010/2/25 Ben Monypenny :
> Hi Paul,
>
> I have been working on a way to save the day's new invoices as PDF's to a
> path on the server for mailing with a cron job. My code is:
>
> 
> $host = 'localhost'; // MYSQL database host adress
> $db = 'dbname'; // MYSQL database name
> $user = 'dbuser'; // Mysql Datbase user
> $pass = $_REQUEST['password']; // Mysql Datbase password
> $rounddate = $_REQUEST['rounddate'];
>
> //parse round date
> $sheetyear = substr($rounddate,4,4);
> $sheetmonth = substr($rounddate,2,2);
> $sheetday = substr($rounddate,0,2);
> $date = $sheetyear."-".$sheetmonth."-".$sheetday;
>
> // Connect to the database
> $link = mysql_connect($host, $user, $pass);
> mysql_select_db($db);
>
> //Get data from citrus
> $query = "SELECT
> billing_details.billing_id,billing_details.invoice_number,customer.account_number
> FROM billing_details,customer WHERE
> billing_details.billing_id=customer.default_billing_id and
> billing_details.creation_date = '$date'";
> $result = mysql_query($query);
>
> //put data in array
> $i = "0";
> $details = array();
> while ($row = mysql_fetch_array($result)) {
> $details[$i][0]=$row[0];
> $details[$i][1]=$row[1];
> $details[$i][2]=$row[2];
> $i++;
> }
>
> //remove duplicates where there is more than one service per invoice
> $j = "0";
> $duplicates=array();
> $dets=$details;
> while ($j < $i+1) {
> if (in_array($details[$j][1],$duplicates)) {
> unset($dets[$j]);
> }
> array_push($duplicates,$details[$j][1]);
> //$details = array_values($details);
> $j++;
> }
>
> //save PDF invoices
> for ($m=0; $m<$i; $m++) {
> $url =
> "http://citrusurl/index.php?load=tools/printpreviousinvoice&billingid=".$dets[$m][0]."&invoiceid=".$dets[$m][1]."&details=on&type=dl&submit=on";;
> $path =
> "/home/user/invoices/".$sheetyear.$sheetmonth.$sheetday.$dets[$m][2].".pdf";
> $in = fopen($url,"rb");
> $out = fopen($path,"wb");
> while($chunk = fread($in,8192)){
> fwrite($out,$chunk,8192);
> }
> fclose($in);
> fclose($out);
>
> //print $dets[$m][0];
> //print $dets[$m][1];
> //print $dets[$m][2];
> }
>
> ?>
>
>
> When the script attempts to retrieve the PDF's it can't because it isn't
> logged into citrus. It is creating files with the citrus login page saved in
> them. Can you help with a workaround?
>
> Many thanks,
>
> Ben Monypenny
>
> --
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Configuring GPG Key

[Paul Yasi]

If you are running gpg inside a user that is not the same as the web
server's user then you'll need to suppress those permission warnings
by adding --no-permission-warning to your gpg command.

More info about this option and other options are available here:
http://www.gnupg.org/documentation/manuals/gnupg-devel/GPG-Configuration-Options.html

Thanks for using citrus.  And everyone using it for production data,
make sure you backup your private keys just in case!  I'm almost more
paranoid of my losing the private key than losing the card data to
hackers.

Paul

2010/2/19 Ben Monypenny :
> Hi Paul,
>
> Thanks for your extensive answer yesterday. It was very helpful.
>
> I have been encountering problems configuring my gpg key.
>
> I have created a 1024 bit GPG key using gpg --gen-key with option [1] DSA
> and Elgamal and 0 as the expiration time (no expiry). This has stored the
> following files in the /.gnupg folder:
>
> gpg.conf
> pubring.gpg
> pubring.gpg~
> random_seed
> secring.gpg
> trustdb.gpg
>
> I have added the following in /include/config.inc.php:
>
> $gpg_command = "/usr/bin/gpg --homedir /home/myuser/.gnupg --armor --batch
> -e -r 'CitrusDB'";    <=replaced CitrusDB here with 'Real Name' field
> from gpg --gen-key command
>
> $gpg_decrypt = "/usr/bin/gpg --homedir /home/myuser/.gnupg --passphrase-fd 0
> --yes --no-tty --skip-verify --decrypt";
>
> $gpg_sign = "/usr/bin/gpg --homedir /home/myuser/.gnupg --passphrase-fd 0
> --yes --no-tty --clearsign -u 'CitrusDB'";    <=replaced CitrusDB here
> with 'Real Name' field from gpg --gen-key command
>
> When attempting to export a credit card batch in CitrusDB I have been
> getting the error:
>
> message_decrypt failed: eof
>
> I opened up the permissions on the files in the /.gnupg folder but now I get
> the error:
>
> 010-02-19Signature Error: error: gpg: WARNING: unsafe permissions on homedir
> `/home/myuser/.gnupg'
>
> Do you have any idea where I have been going wrong?
>
> Many thanks,
>
> Ben Monypenny
>
> --
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Importing Batch Services from a CSV file

[Paul Yasi]

There are two functions you can call in a loop while you read your
data that will pretty much do this for you.  The create_service and
service_message function.  These are from the include/services.inc.php
and include/support.inc.php.  You'll also probably want to have the
bunch of included files that get you into the database and give you
other functions that these might rely on too.

// Includes
include('./include/config.inc.php');
include('./include/database.inc.php');
include('./include/billing.inc.php');
include('./include/citrus_base.php');
include('./include/services.inc.php');
include('./include/support.inc.php');

// this function will put the data into the user services table and
attributes table
$new_user_service_id = create_service($account_number,
$master_service_id, $billing_id, $usage_multiple,
$attribute_table_name, $attribute_fieldname_string,
$attribute_fieldvalue_string);

The usage_multiple must 1 or greater.

If you have an attributes table you'll need to use
attribute_fieldname_string that names the attribute table fields you
want to fill in such as:
$attribute_fieldname_string = "username, password, domain";
$attributes_fieldvalue_string = "'benmonypenny', 'p4ssw0rd', 'gmail.com'";

If you do not have an attributes table you can leave them as NULL.  If
you do have an attributes table but are not inserting attributes right
now you'll still want to include something as a placeholder so it
makes the attributes table for this particular service item.

// this will put the note for the service being added in the customer history
service_message('added', $account_number, $master_service_id,
$new_user_service_id, NULL, NULL);

Note the service message takes the new_user_service_id that was output
by the create_service function.

// depending on your requirements for application logging you may also
want to log that
// this service was inserted by using the log_activity function
log_activity($DB,$user,$account_number,'create','service',$new_user_service_id,'success');

You can see this all in action around line 74 of the
/modules/services/create.php file


Paul


-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

2010/2/18 Ben Monypenny :
> Hi Paul,
>
> First of all can I say a huge thank you for the huge time and effort that
> you have obviously put into CitrusDB. Its great to see some quality open
> source software that helps out small businesses.
>
> My business provides  a service to customers every four weeks, but sometimes
> it can be five weeks or even more irregularly. I am building a new site and
> attempting to find a way to integrate CitrusDB with my current customer
> records and billing system. I have configured my services in CitrusDB with a
> frequency of zero so that I can add them to customers when they occur. But,
> I would like to be able to add them to batches of customers at a time.
>
> If I create a php script to append the CitrusDB mysql tables from a csv file
> (correctly formatted and with the correct CitrusDB account_number's and
> master_services id's), could you let me know which tables I should append?
>
> For example, if I add records to the bottom of the user_services table
> (making sure the sequential id numbers are correct) and then use the same
> process to add records to the bottom of the customer_history table (making
> sure the user_services id's match), will this work without breaking anything
> in CitrusDB? Or are there any other tables which I will need to append?
>
> Many thanks in advance,
>
> Ben Monypenny
>
> --
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] citrusdb 2.0.1 release

[Paul Yasi]

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 not a security issue since card data
would not be exported, however it would have caused an orphaned batch
to be created before it got an error trying to decrypt and export it.

There are also some minor formatting issues fixed, and the last 4
digits of the card number are included in the declined card email
message.

Get it now from http://www.citrusdb.org

Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] error Not Found after I login the default password

[Paul Yasi]

You need to update the url_prefix and ssl_url_prefix variables to the
correct ones in config.inc.php

These are new in 2.0

Paul

2010/2/5 AC Perdon 

> Hi,
>
> I have installed citrusdb 3 times and my first time to encounter this
> problem which I cant figure it out, can any one help details below:
>
> System Info:
>
> OS:
> Distributor ID:Ubuntu
> Description:Ubuntu 9.10
> Release:9.10
> Codename:karmic
>
> phpinfo output:
> Configuration File (php.ini) Path /etc/php5/apache2  Loaded Configuration
> File /etc/php5/apache2/php.ini Scan this dir for additional .ini files 
> /etc/php5/apache2/conf.d
> additional .ini files parsed /etc/php5/apache2/conf.d/gd.ini,
> /etc/php5/apache2/conf.d/mcrypt.ini, /etc/php5/apache2/conf.d/mysql.ini,
> /etc/php5/apache2/conf.d/mysqli.ini, /etc/php5/apache2/conf.d/pdo.ini,
> /etc/php5/apache2/conf.d/pdo_mysql.ini
>
> Citrus Config:
>
> 7 // define variables
>   $sys_dbhost = 'localhost';
>   $sys_dbuser = 'test';
>   $sys_dbpasswd = 'test123';
>   $sys_dbname = 'citrus';
>   $sys_dbtype = 'mysql';
>   $path_to_citrus = '/var/www/citrus-2.0';
>   $hidden_hash_var='thequickbrownfox';
>   $lang = './include/local/us-english.inc.php';
>   $gpg_command = "/usr/bin/gpg --homedir /home/www-data/.gnupg --armor
> --batch -e -r 'CitrusDB'";
>   $gpg_decrypt = "/usr/bin/gpg --homedir /home/www-data/.gnupg
> --passphrase-fd 0 --yes --no-tty --skip-verify --decrypt";
>
>   // use these url prefixes to redirect between the ssl carddata and
> regular pages
>   // also maybe can be used with base href to help limit cross site
> scripting
>   $url_prefix = 
> "http://localhost/~pyasi/citrus_project/citrusdb-gpg/
> ";
>   $ssl_url_prefix = 
> "https://localhost/~pyasi/citrus_project/citrusdb-gpg/
> ";
>
>   File is located:
>
> $ pwd
> /var/www/citrus-2.0
>
> Citrus version: 2.0 stable
>
> Problem:
>
> After I type in default username and password (admin/test) the page loads
> below error, I think its looking for a directory or a a file located at
> /home/pyasi/citrus_project/io, but I'm not sure cause my previous
> installation was successful and I have check the files seem all of them are
> in the right place.
>
> Not Found
>
> The requested URL /citrusdb/index.php was not found on this server.
> --
> Apache/2.2.12 (Ubuntu) Server at localhost Port 80
> here are the files:
> $ ls
> 1024x768.html dashboard.php   include  receipt.php
> all_billing_details.php   datetest.phpindex.phpscripts
> all_billing_history.php   decryptcardsLICENSE  search.php
> all_customer_history.php  dosearch.phplogout.php   statusupdate
> all_payment_history.php   encryptcardsMODULEGUIDE  tickets.php
> billing_details.php   favicon.ico modules  tools
> billing_history.php   footer.php  modules.php  tools.php
> calendar.php  fullscreen.css  mydate.php   update.php
> citrus.cssfunctions.jsnewcustomer.php
> viewaccount.php
> citrusdb.png  getweekends.pl  online
> viewservice.php
> citrus.sqlheader.php  payment_history.php
> viewticket.php
> classes   help.html   print.php
> customer_history.php  images  README
>
> Thanks and Regards,
> AC
>
>
> --
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the
> business
> Choose flexible plans and management services without long-term contracts
> Personal 24x7 support from experience hosting pros just a phone call away.
> http://p.sf.net/sfu/theplanet-com
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>


-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
--
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] citrusdb 2.0 release now available

[Paul Yasi]

The newest release of citrusdb is now available!  Version 2.0 now
supports industry standard OpenPGP encryption of stored credit card
data, sub-notes added to customer tickets, a history of the customers
you have recently viewed, and logging of citrusdb activity.

Visit http://www.citrusdb.org to get it now!

Also available is the new 2.0 manual for help with installation,
setup, administration, automation, and includes a new chapter on data
security.  Get the PDF manual now for a limited time for just $9.99
http://www.lulu.com/product/download/citrusdb-20-manual/6300087


Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Problem when viewing citrusdb website

[Paul Yasi]

Sounds like you probably need to install the mysql module for php.
Most linux distro's will have a package you can install that will
include this for you.  If you are running ubuntu/debian you can run:

apt-get install php5-mysql

If you compiled php yourself you would have to put --with-mysql in
your configure string.

Paul

On Thu, Jan 21, 2010 at 11:43 PM, Clinton Strouth  wrote:
> I have the following error when trying to view the CitrusDB Website On
> Our Internal Network.
>
> Fatal error: Call to undefined function mysql_connect() in
> /var/www/citrus-1.3.2/include/adodb/drivers/adodb-mysql.inc.php on
> line 362
>
> The version I'm running is Citrus 1.3.2
> Running Apache2.2 With PHP and Mysql 5.0
>
> Any help would be greatly appericated.
>
> Thanks
> --
> Clinton Strouth
>
> --
> Throughout its 18-year history, RSA Conference consistently attracts the
> world's best and brightest in the field, creating opportunities for Conference
> attendees to learn about information security's most important issues through
> interactions with peers, luminaries and emerging and established companies.
> http://p.sf.net/sfu/rsaconf-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] ldap integration

[Paul Yasi]

Citrus does not have any interface to other types of authentication other
than what is in it's own database's user table.  You would have to sync the
info from ldap with the user table.  This may be able to be done when it
runs the user_login function in the user class.

Paul

2010/1/7 Pierrick Merle 

>  Hello,
>
> I'd like to manage users account into ldap not into mysql database.
> Cause i wanna use apache client certificate authentication and grant access
> to citrus interface.
> I'm using that anthentication schema with other apps like otrs and many
> others, and i don't wanna have to manage a sql database for only one
> application.
> Do you think there is a solution ?
>
>
>   Cordialement,
> Pierrick Merle
>
>
>
> *POSEIDON-NETWORKS*
> *Tel: 04.77.28.37.18*
> *Mobile: 06.73.35.53.51*
> *mail: pierr...@poseidon-networks.com*
> *web: www.poseidon-networks.com*
>
> On Thu, 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 
>
>  Hello,
>
> I'm looking for an ldap connector in citrusdb.
> As far as i can see, it seems that connector is present in the adobd driver
> directory, but i can't find any configuraiton in citrusdb interface ,there
> is only a sample query code into the adodb documentation.
> Does anyone already implemented that config ?
> Any help whould be very appreciated.
>
>   Cordialement,
> Pierrick Merle
>
>
>
> *POSEIDON-NETWORKS*
> *Tel: 04.77.28.37.18*
> *Mobile: 06.73.35.53.51*
> *mail: pierr...@poseidon-networks.com*
> *web: www.poseidon-networks.com*
>
>
>
> --
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and
> easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> 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 the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon 
> customershttp://p.sf.net/sfu/verizon-dev2dev
> ___ Citrusdb-users mailing list 
> Citrusdb-users@lists.sourceforge.net 
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
>
> --
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and
> easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> 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 the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev ___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] ldap integration

[Paul Yasi]

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 

>  Hello,
>
> I'm looking for an ldap connector in citrusdb.
> As far as i can see, it seems that connector is present in the adobd driver
> directory, but i can't find any configuraiton in citrusdb interface ,there
> is only a sample query code into the adodb documentation.
> Does anyone already implemented that config ?
> Any help whould be very appreciated.
>
>   Cordialement,
> Pierrick Merle
>
>
>
> *POSEIDON-NETWORKS*
> *Tel: 04.77.28.37.18*
> *Mobile: 06.73.35.53.51*
> *mail: pierr...@poseidon-networks.com*
> *web: www.poseidon-networks.com*
>
>
> --
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and
> easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> 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 the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev ___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Firefox Post Problem

[Paul Yasi]

I think the majority of citrusdb users are firefox users, and I've
never seen this myself or heard about it before.  A quick search about
firefox turns up a feature in firefox called pipelining that may make
multiple requests for one page,
http://www.ehow.com/how_2033391_enable-pipelining-firefox.html - maybe
this is turned on?

Also, Citrusdb does not specify any character set, maybe the code is
triggering a firefox bug:
https://bugzilla.mozilla.org/show_bug.cgi?id=236858

Paul

On Sat, Jan 2, 2010 at 10:52 AM, Eternity  wrote:
> Hi!
>
> When I create a new customer, a new service etc in Citrusdb they get added
> twice when I use firefox, but not with for instance Internet Explorer.
>
> I can see in the webserver logs, that firefox makes the same request
> twice.
>
> I have searched for an answer, but not found anything that suits my
> problem really. Anyone got any ideas?
>
> Chris
>
>
> --
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> 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 the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] Try out the CitrusDB 2.0 beta series

[Paul Yasi]

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 ticket sub notes.

This release is currently meant for testing and not for production
data.  Please try it out and see how it works in your test
environment.

The help.html file now includes the first two chapters of the upcoming
2.0 manual with installation and setup instructions.

You can grab it at:
https://launchpad.net/citrusdb/2.0-beta

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Errors on install - missing language file?

[Paul Yasi]

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 Gwilym Griffith-Jones :
> Hi there,
> I have recently installed CitrusDB on windows. Everything is fine with the
> database and I can login. I get errors all the time over the top of the page
> (below). It looks like some vars are not declared?
> Any ideas appreciated - looks like a great application :-)
> -
> Notice: Undefined variable: payment_due_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 302
>
> Notice: Undefined variable: total_owed in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 302
>
> Notice: Undefined variable: turnoff_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 304
>
> Notice: Undefined variable: cancel_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 306
>
> Notice: Undefined variable: cancel_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 308
>
> Notice: Undefined variable: cancel_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 310
>
> Notice: Undefined variable: cancel_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 310
>
> Notice: Undefined variable: phone_billing in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 312
>
> Notice: Undefined variable: payment_due_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 302
>
> Notice: Undefined variable: total_owed in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 302
>
> Notice: Undefined variable: turnoff_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 304
>
> Notice: Undefined variable: cancel_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 306
>
> Notice: Undefined variable: cancel_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 308
>
> Notice: Undefined variable: cancel_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 310
>
> Notice: Undefined variable: cancel_date in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 310
>
> Notice: Undefined variable: phone_billing in C:\Documents and
> Settings\Gwilym\My Documents\www\citrus\include\local\us-english.inc.php on
> line 312
> 
> Gwilym Griffith-Jones
> . . . .. . . .. . . .. . . .. . . .. . . .. . . .. . . .. .
 http://www.staple.co.nz
> . . . .. . . .. . . .. . . .. . . .. . . .. . . .. . . .. .
> Mob NZ: (+64) 21 388 801
> Ph NZ: +64 3 669 2334 / +64 3 443 1900
> Email: gwily...@gmail.com
> Skype: gwilymgj / cooreea
> . . . .. . . .. . . .. . . .. . . .. . . .. . . .. . . .. . . .
>
> --
> Return on Information:
> Google Enterprise Search pays you back
> Get the facts.
> http://p.sf.net/sfu/google-dev2dev
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Need Quick DB add on

[Paul Yasi]

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 account manager is mostly contained in one
index file.  Anyone who implements this would be advised to save the
files to the separate web server (where the online part is already
hopefully running) when uploaded and not onto the internal citrusdb
server, since access from the online account system to the internal
citrusdb server's filesystem could turn into a bad idea if it's not
kept secure from invalid queries or php filesystem bugs.

Paul
-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

On Sat, Dec 5, 2009 at 3:28 AM, Allen  wrote:
> I need a add on for Citrus
>
> 1. In the Admin page for each customer, I need a upload file button.
>    a. The Admin will upload a phone record sheet for the user to review.
> 2. In the online account users page, I need that file to be able to be
> downloaded and leave a copy on the DB.  The file will be a PDF or XLS up
> to 10MB in size.
>
> How much for this mod - I do not have the time to do this.
>
>
>
> --
> Join us December 9, 2009 for the Red Hat Virtual Experience,
> a free event focused on virtualization and cloud computing.
> Attend in-depth sessions from your desk. Your couch. Anywhere.
> http://p.sf.net/sfu/redhat-sfdev2dev
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>

--
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] CitrusDB Version 1.3.2 Released

[Paul Yasi]

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 organization ID requirement to the import new account function
- Shows support tickets assigned to that service on the service edit screen
- Added authorize.net and credit card reminder billing scripts


You can download this release by visiting the download link on the
home page, http://www.citrusdb.org



Paul

-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Modify Client Question

[Paul Yasi]

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 at 3:10 PM, Michael D.
Ogden wrote:
> When I go to http://servername/admins/modify_client.php?clientid=x
> I get a blank page.
>
> I have made some changes to the event scripts as follows:
>     -
>     -
>     -
>    ,       $clientspostalcode ?>
>
> Could this have broken the modify client scripts? I don't see how it could
> have. Should I have installed an earlier version then upgraded?
>
> In addition (should anyone be curious) I finally discovered how to get the
> PDF bill to work by downloading the plugin dompdf.
>
> In addition, is it possible that the PDF bill get sent as an attachment
> instead of as HTML? How would I do that (or have I just broken it *smile*)
>
> Thanks in advance
>
>
> --
> Enter the BlackBerry Developer Challenge
> This is your chance to win up to $100,000 in prizes! For a limited time,
> vendors submitting new applications to BlackBerry App World(TM) will have
> the opportunity to enter the BlackBerry Developer Challenge. See full prize
> details at: http://p.sf.net/sfu/Challenge
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time, 
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Delete service

[Paul Yasi]

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 on the same billing cycle as their regular billing
record's billing cycle.

There isn't an interface to delete the billing records, if that
billing record has never been used for billing anything you can safely
remove it from the database using sql queries to delete that row from
the billing table.  If that billing record has ever been used to bill
any services though it's a good idea to leave it alone, you can re-use
it for that customer if they order similarly billed services again and
it will make sure the billing reports can get the corresponding
information to look correct.

If you are actually trying to delete a service, that should be easy,
if you have added a service to a customer and decide they don't need
that service anymore, simply click the Edit button next to the service
item and it will take you to the edit service screen.  One of the
button choices on that screen will be to delete the service.

Paul

2009/7/18 Lordsporkton :
> hello,
> I am trying to setup citrus and im having a few issues.
>
> How do I delete services?(i think its a service). I am on the billing tab
> for a customer and I have several services? invoices? They have billing IDs.
>
> When I go to services for that customer it doesnt have any services listed
> that I can see, only allows me to add services and has notes.
>
> WHen i try to run invoice maintenance on one it returns with no invoices
> listed.
>
> Thank you,
> Lawrence
>
>
> --
> Enter the BlackBerry Developer Challenge
> This is your chance to win up to $100,000 in prizes! For a limited time,
> vendors submitting new applications to BlackBerry App World(TM) will have
> the opportunity to enter the BlackBerry Developer Challenge. See full prize
> details at: http://p.sf.net/sfu/Challenge
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time, 
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Install issues with mysql60-server when trying to create tables.

[Paul Yasi]

 There may be a compatibility mode you can try turning on that may
make it work.  I think 6.0 is a preview version and not really for
production use.  I would recommend sticking to the regular general
release version, which is 5.1 right now.

Paul

On Fri, Jul 10, 2009 at 1:21 PM, Clinton Strouth wrote:
> I'm currently having problems implementing the citrusdb software for the
> company I work for.
> We are having the following problems when trying to create the tables
>
> cobra# mysql -p citrus <
> /usr/local/www/apache22/data/citrus-1.3.1/citrus.sql
> ERROR 1064 (42000) at line 19: 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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 4
>
> The current version for mysql server is 6.0 and we are trying to run
> citrus-1.3.1
> Do we need to downgrade from mysql6.0 to 5.0 or what?
>
> Any help would be appericated
>
> Clinton
> SkyNET Communications
> Network Engineer
>
> --
> Enter the BlackBerry Developer Challenge
> This is your chance to win up to $100,000 in prizes! For a limited time,
> vendors submitting new applications to BlackBerry App World(TM) will have
> the opportunity to enter the BlackBerry Developer Challenge. See full prize
> details at: http://p.sf.net/sfu/Challenge
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time, 
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Payroll

[Paul Yasi]

Sorry, citrusdb does not do payroll.

Paul

2009/6/29 Jeremy Winton :
> Does CitrusDB have payroll and if so does it get payroll tax updates?
>
> Thanks in advance
> Jeremy
> --
>
> ___
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] CitrusDB 1.3.1 Release

[Paul Yasi]

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 because
it is now using that field in a different way.  Before you run the
upgrade script you should find any reruns in your active system and
make a note of them to go back and re-do them after the update script
has run.  You can find them by running a query like: SELECT * FROM
billing WHERE rerun_date IS NOT NULL

http://www.citrusdb.org/download/citrus-1.3.1.tar.gz

Paul
-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Citrusdb-users] New 1.3 Manual Available

[Paul Yasi]

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 http://www.lulu.com/content/6837221

I would also like to let everyone know that the source code
development and bug reporting for citrusdb has moved to Launchpad, and
is now using the bzr version control system.  This will allow you to
grab development branches directly from that site and see code and
commit comments online.  You can access citrusdb on launchpad by going
to https://launchpad.net/citrusdb

With the move to launchpad, this means the nightly cvs file is no
longer available, and the commit comments are no longer being sent to
the devel mailing list.  If you want revision notifications you can
subscribe to the trunk branch with a launchpad account by choosing the
subscribe yourself link at
https://code.launchpad.net/~paul-citrusdb/citrusdb/trunk


Paul
-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
Stay on top of everything new and different, both inside and 
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today. 
Use priority code J9JMT32. http://p.sf.net/sfu/p
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Re: [Citrusdb-users] Doubt in citrusdb

[Paul Yasi]

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  wrote:
> 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 to make it clear, this mysql user is not related
> to the citrus admin/test user login.  It is for the web server to talk
> to the mysql server behind the scenes.
>
> You probably should create a new mysql user that is just for citrus to
> use, and then put that username and password into the variables in the
> config.inc.php file.  That should fix that error, and then allow you
> to log in with the citrusdb software's admin/test account.
>
> Paul
>
> 2009/3/25 Sukumar Thota :
>> Hi,
>>
>>
>>
>>     I am trying to start using citrusdb for first time. I downloaded
>> citrusdb 1.2 version, configured my server and followed exactly the way
>> mentioned in the documentation like executing .sql file and changing config
>> file in citrusdb folder. But when I go the site, I see a warning message
>> along with login screen. The warning reads:
>>
>>
>>
>> Warning: mysql_connect() [function.mysql-connect]: Access denied for user
>> 'admin'@'localhost' (using password: YES) in C:\Program Files\EasyPHP
>> 3.0\www\citrusdb\include\adodb\drivers\adodb-mysql.inc.php on line 363
>> Access denied for user 'admin'@'localhost' (using password: YES)
>>
>>
>>
>> I can login to the mysql perfectly fine and mysql is running okay.
>>
>> And when I try to login with  username:admin and password:test, it won’t let
>> me in. Can anyone please help me on this. Thanks.
>>
>>
>>
>> Regards,
>>
>> Sukumar Thota.
>>
>> --
>>
>> ___
>> Citrusdb-users mailing list
>> Citrusdb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>>
>>
>
>
>
> --
> The CitrusDB Project | http://www.citrusdb.org
> Open Source Customer Care & Billing System
>



-- 
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

--
___
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users