http://permalink.gmane.org/gmane.comp.crm.citrusdb.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/434 <pre>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 &lt;benmonypenny-gM/Ye1E23mwN+BqQ9rBEUg&lt; at &gt;public.gmane.org&gt;: </pre> Paul Yasi 2010-03-01T16:01:58 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/433 <pre>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, $inv</pre> Paul Yasi 2010-02-26T15:53:01 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/432 <pre>this is great! Ben Monypenny wrote: ------------------------------------------------------------------------------ Download Intel&amp;#174; 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 </pre> Allen 2010-02-26T01:21:37 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/431 <pre>------------------------------------------------------------------------------ Download Intel&amp;#174; 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Ben Monypenny 2010-02-26T01:12:01 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/430 <pre>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 &lt;benmonypenny-gM/Ye1E23mwN+BqQ9rBEUg&lt; at &gt;public.gmane.org&gt;: </pre> Paul Yasi 2010-02-19T15:32:46 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/429 <pre>------------------------------------------------------------------------------ Download Intel&amp;#174; 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Ben Monypenny 2010-02-19T14:59:05 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/428 <pre>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 t</pre> Paul Yasi 2010-02-18T21:37:12 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/427 <pre>------------------------------------------------------------------------------ Download Intel&amp;#174; 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Ben Monypenny 2010-02-18T19:52:14 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/425 <pre>------------------------------------------------------------------------------ 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> AC Perdon 2010-02-09T10:36:58 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/424 <pre>------------------------------------------------------------------------------ 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Paul Yasi 2010-02-06T15:31:19 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/423 <pre>------------------------------------------------------------------------------ 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> AC Perdon 2010-02-06T04:06:46 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/421 <pre>Problem fixed I completed php5 with mysql support some how the files where corrupt in the support for the mysql addon to php. Thanks for the additional information Paul I had to recomplile php and mysql. Clinton ---------------------------------------------------------------------- Message: 1 Date: Fri, 22 Jan 2010 09:46:21 -0500 From: Paul Yasi &lt;paul-Ph1erp/B97UZQ9iXQcw1wQ&lt; at &gt;public.gmane.org&gt; Subject: Re: [Citrusdb-users] Problem when viewing citrusdb website To: For users of CitrusDB discussion &lt;citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org&gt; Message-ID: &lt;57a62b2e1001220646s30f84295x9491e4bb6584e9cc-JsoAwUIsXosN+BqQ9rBEUg&lt; at &gt;public.gmane.org&gt; Content-Type: text/plain; charset=ISO-8859-1 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 con</pre> Clinton Strouth 2010-01-23T16:26:27 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/420 <pre>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 &lt;cstrouth1-Re5JQEeQqe8AvxtiuMwx3w&lt; at &gt;public.gmane.org&gt; wrote: </pre> Paul Yasi 2010-01-22T14:46:21 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/419 <pre>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 </pre> Clinton Strouth 2010-01-22T04:43:24 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/418 <pre>------------------------------------------------------------------------------ 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Pierrick Merle 2010-01-07T17:12:32 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/417 <pre>------------------------------------------------------------------------------ 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Paul Yasi 2010-01-07T16:56:02 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/416 <pre>------------------------------------------------------------------------------ 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Pierrick Merle 2010-01-07T16:09:59 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/415 <pre>------------------------------------------------------------------------------ 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Paul Yasi 2010-01-07T14:45:08 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/414 <pre>------------------------------------------------------------------------------ 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Pierrick Merle 2010-01-07T12:57:29 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/413 <pre> The unspecified characterset seems to be the solution to my problem, I tried turning off automatic detection of characterset in firefox and after that no doublerequests are made! Thank you very much, and thank you for CitrusDB! :) Chris On Sun, 3 Jan 2010, Paul Yasi wrote: ------------------------------------------------------------------------------ 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 </pre> Eternity 2010-01-03T20:00:20 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/412 <pre>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 &lt;eternity-nMKIGJZKI6fQ+Ui9UX+TldBPR1lH4CV8&lt; at &gt;public.gmane.org&gt; wrote: </pre> Paul Yasi 2010-01-03T15:21:16 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.crm.citrusdb.user