Discussion:
[Citrusdb-users] Development work
Bill Harris
2012-01-14 16:10:18 UTC
Permalink
Paul,

Just curious is CitrusDB under active development?
Or is the project mostly in maintenance mode..?


Bill

--
Paul Yasi
2012-01-15 15:11:28 UTC
Permalink
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
Post by Bill Harris
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
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
Bill Harris
2012-01-23 13:29:32 UTC
Permalink
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
Paul Yasi
2012-01-23 13:53:13 UTC
Permalink
I don't think it would break anything.

Paul
Post by Bill Harris
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
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
Bill Harris
2012-01-23 22:20:59 UTC
Permalink
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 | | 0000-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)
Post by Paul Yasi
I don't think it would break anything.
Paul
Post by Bill Harris
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
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Paul Yasi
2012-01-24 01:09:21 UTC
Permalink
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
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   |     | 0000-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)
Post by Paul Yasi
I don't think it would break anything.
Paul
Post by Bill Harris
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
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
------------------------------------------------------------------------------
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
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
Loading...