Just started using the tool and find it very promising however I've hit a snag that may well be down to my db tables. When I do the export to database the project fielc remains null even though the $HOURS, $DATE and $USERNAME are successfully imported. The column is of type VARCHAR in my db for the project identifier and I'm using the latest 3.1.1 release. Any ideas? Thanks in advance,
Stuart
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Couple of questions:
- Do you have an alias setup for your project under the "project names" tab?
- What database are you using?
- How big is your varchar field in the table?
- In the "field values" tab, how far up/down the list is the field name that you're trying to set to $PROJECT? Is it first in the list or last in the list?
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- I hadn't set up any alias fields but once I did I found
the alias' were successfully exported..I'd rather just export the original project names if possible.
- I'm using mySQL
- It's a VARCHAR(30)
- The order is:
$USERNAME
$PROJECT
$DATE
$HOURS
thanks for the rapid response!
Stuart
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you could, go ahead and open a bug report for this issue. Once you do, I'll attach a new JDBCConnect.jar that will replace the existing one in your plugins directory. You can test out & let me know if it works for you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Just started using the tool and find it very promising however I've hit a snag that may well be down to my db tables. When I do the export to database the project fielc remains null even though the $HOURS, $DATE and $USERNAME are successfully imported. The column is of type VARCHAR in my db for the project identifier and I'm using the latest 3.1.1 release. Any ideas? Thanks in advance,
Stuart
Couple of questions:
- Do you have an alias setup for your project under the "project names" tab?
- What database are you using?
- How big is your varchar field in the table?
- In the "field values" tab, how far up/down the list is the field name that you're trying to set to $PROJECT? Is it first in the list or last in the list?
Thanks!
Some answers and observations:
- I hadn't set up any alias fields but once I did I found
the alias' were successfully exported..I'd rather just export the original project names if possible.
- I'm using mySQL
- It's a VARCHAR(30)
- The order is:
$USERNAME
$PROJECT
$DATE
$HOURS
thanks for the rapid response!
Stuart
Easy 'nuff. I'll make that change in 3.1.2 and post it shortly.
Which would be beter: groupname-projectname or just projectname?
If you could, go ahead and open a bug report for this issue. Once you do, I'll attach a new JDBCConnect.jar that will replace the existing one in your plugins directory. You can test out & let me know if it works for you.
fixed in CVS
I've raised the bug report,
Stuart
New plugin has been attached to it.
Hi,
I have the same issue. I'm using a ODBC Bridge to a Mysql and I just export alias.
thanks.
I'll check that out. Are your receiving any error messages?
NO, I don´t but if I try Alias field it works.
I'm moving my replies to your bug report - check there for updates.