Hello,
I just downloaded and installed ConsultComm 3.0.2 and have been able to get it connected to the MySQL DB. I have mapped the fields according to the help file and created a test project.
However, when I attempt to export to the Database, (seemingly) nothing happens. No information shows up in the table specified and I do not receive any type of an error message. Visually nothing at all happens.
The following line from the help file makes me wonder if I've missed a step:
"map project names in ConsultComm to project names stored within your database"
Does this indicate that the projects must be predefined in the DB before I can export to the tables or will CC create the project entries for me?
Thank You,
Travis
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you have the "Validate Project" checkbox selected in the Options tab of the JDBC Plugin settings, then you do need to have the project names in the database first. Otherwise you should be good.
If you are still having this problem and "Validate Project" isn't selected, feel free to send the layout for the table you're trying to export to and I'll try to reproduce the problem.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you for you quick response. The layout I'm using is this:
DB Type: MySQL 3.23.53a
Database Name: ConsultComm
Table Name: projects
Table Type: MyISAM
Table Schema:
employee_name char(50)
hours_billable tinyint(1)
hours_worked decimal(10,0)
project_name char(100)
work_date timestamp(14)
Field Mappings (from Field Values tab of JDBC settings):
Under the Project Names tab in settings there is a check in the "Export" column next to the test project I have defined. On the options tab "Validate Project" is not checked.
Thank you for your assistance in this matter,
Travis
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you very much for your efforts in tracking this down.
So far I'm very impressed with the application, small, simple, and highly effective.
Excellent work.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I seem have a similar problem with v3.1.1. When exporting, everything goes into the database fine except for the project name. I tried first with 'Validate Project' unchecked, and $PROJECT mapped to a varchar(100). I subsequently tried making the column 'TEXT' type (mysql v4.0 database btw). I also tried checking 'Validate Project' and creating a project table. It prompted for the project name, and created a row in the table, but the project name field was again blank.
Any ideas?
Thanks
Mike
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I just downloaded and installed ConsultComm 3.0.2 and have been able to get it connected to the MySQL DB. I have mapped the fields according to the help file and created a test project.
However, when I attempt to export to the Database, (seemingly) nothing happens. No information shows up in the table specified and I do not receive any type of an error message. Visually nothing at all happens.
The following line from the help file makes me wonder if I've missed a step:
"map project names in ConsultComm to project names stored within your database"
Does this indicate that the projects must be predefined in the DB before I can export to the tables or will CC create the project entries for me?
Thank You,
Travis
If you have the "Validate Project" checkbox selected in the Options tab of the JDBC Plugin settings, then you do need to have the project names in the database first. Otherwise you should be good.
If you are still having this problem and "Validate Project" isn't selected, feel free to send the layout for the table you're trying to export to and I'll try to reproduce the problem.
Thank you for you quick response. The layout I'm using is this:
DB Type: MySQL 3.23.53a
Database Name: ConsultComm
Table Name: projects
Table Type: MyISAM
Table Schema:
employee_name char(50)
hours_billable tinyint(1)
hours_worked decimal(10,0)
project_name char(100)
work_date timestamp(14)
Field Mappings (from Field Values tab of JDBC settings):
employee_name -> $USERNAME
hours_billable -> $BILLABLE
hours_worked -> $HOURS
project_name -> $PROJECT
work_date -> $DATE
Under the Project Names tab in settings there is a check in the "Export" column next to the test project I have defined. On the options tab "Validate Project" is not checked.
Thank you for your assistance in this matter,
Travis
This appears to be a problem with a MySQL data type, will probably have something posted by Thursday...
Thank you very much for your efforts in tracking this down.
So far I'm very impressed with the application, small, simple, and highly effective.
Excellent work.
Bug is fixed in CVS; compiled packages should be available soon (uploading 'em now).
Thank you, can't wait to give it a shot. Thank you again for your help in this matter.
Works great, thanks again for the assistance.
I seem have a similar problem with v3.1.1. When exporting, everything goes into the database fine except for the project name. I tried first with 'Validate Project' unchecked, and $PROJECT mapped to a varchar(100). I subsequently tried making the column 'TEXT' type (mysql v4.0 database btw). I also tried checking 'Validate Project' and creating a project table. It prompted for the project name, and created a row in the table, but the project name field was again blank.
Any ideas?
Thanks
Mike
I'll try my MySQL 4 installation and see...
I've been trying to replicate this bug using ConsultComm 3.1.1 and MySQL 4.0.21 but haven't been able to. Are you still experiencing the problem?
Hm. Yes. The project field is consistently blank when I export.... What is the 'type' of your project name field in the database?
I'll triple check my settings, and maybe poke at the source a bit.
Thanks for the response.
Mike
It's a VARCHAR field. I'll try some additional types.