William,
    To make your service have custom fields to hold custom data for each customer you will need to have an
options table for the service.  These option tables will need to be set up before you add the service to the
customers account.  Go into tools and edit your service.  In the Options/Attributes Table type in
a name wish to call the table (this will be a table in your sql database).  Save your settings on this service.
On the top in the same window,  click on the Options/Attributes Table tab.  You should see your table in
this list with a create link next to it. Click on create, this will make the table in your database.  You should be
able to add your services to the customers accounts now that you have an options table set up.
Now to add the fields to the service you will have to do on your sql command line, or using a program like
phpmyadmin (recommended).  Go into your table and begin to add fields to it.  There are 3 field types that I'm
aware of that you can use with citrusdb.  For just a standard filed you can type info into, use varchar.  For a
drop down menu use enum.  For a large text area that you can type notes or any larger amount of text into use
BLOB.

Just add the fields you wish to have in this service you you should be good to go.  Citrus will see the fields and
give you the option to fill them as you add/edit the customers services.

My apologies if this is a little vague.  I'm assuming you are knowledgeable of sql.  Please let me know if you
need more help.

- John Hurst



John Hurst wrote:
William,
    Go in and edit your service.  Set the cost (Price) of your service to $1.  Go and add the service
to your customer, before clicking on add enter the exact dollar amount you wish to charge this customer
in the Measured Usage field.  That should do the trick.

- John Hurst


William King wrote:
I have some support type services that are custom contracted by each
client. How do I manually specify the billing amount and other service
details?

-William


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url="">
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
  

--

John Hurst
Customer Support Specialist
----------------------------------------
p
208.548.2345
f 208.548.9911
e [EMAIL PROTECTED]
----------------------------------------
150 South Main
P.O. Box 270
Rockland, ID 83271-0270


Direct Communications


------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url="">

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

--

John Hurst
Customer Support Specialist
----------------------------------------
p
208.548.2345
f 208.548.9911
e [EMAIL PROTECTED]
----------------------------------------
150 South Main
P.O. Box 270
Rockland, ID 83271-0270


Direct Communications

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Reply via email to