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
