New user's not listed in: Reassign task

[geezenslaw]

Hello EmForge dev, gurus and mortals. I have EmForge installed for my
software dev. proj. Though, there have been a few set-backs I have
found the application very useful. Now, I have another user who has
registered on the EmForge issue tracker in hopes that I could assign a
Task to his user account but his new user account does not show up
anywhere. Please advise, David.

[Alexey Kakunin]

Hi David!
in which workflow you want to be able to assign this new user?

For example, some workflows has steps,  should be performed by specific "Swimlane" or "Role" - like:
"Fix A Bug" step in "BugFixing" workflow should be implemented by "Developer"

So, only "Developers" will be listed in related combobox...

So, to be able to assign user to some step - you need to add it into specific Role in the project (go to project pages -> Roles -> Select required role -> type username in inputbox (then EmForge will find user by typed username it will show special sign) - and press "Assign")

If we are speaking about general "ToDoTask" - you can simple add that user into "User" role in project.

I hope it will help - feel free to ask if you have any more questions

2009/7/23 geezenslaw <da...@davidwbrown.name>

--
With Best Regards,
Alexey Kakunin, EmDev Limited

Professional Software Development:
http://www.emdev.ru

[geezenslaw]

Hello Alexey, thanks for the speedy reply. I apologize for the slow
response but I was under the assumption I would get an email from
Google (go figure). In the future I will check in more regularly.

Here are my steps (target is ToDoTask):
1. navigate to Projects --> Project Info --> Roles --> Available Roles
--> Add Role --> Create New Role --> (Role Name:, Display Name:,
Email:)
2. navigate to Tasks --> select Task Status: Opened --> click Task #4
--> Task at Step Process ToDo --> select tab: Step: Process ToDo -->
General Step Settings: select Reassign --> Reassign popup empty. (i.e.
nothing to select from in the Reassign popup).

I understand your explanation and in particular these topics:
swimlanes, roles and the like but I am still befuddled as to where to
apply steps mechanically to reach my target goal of reassigning Tasks,
Bug and the like. This would be a big boost to my dev. proj. if I
could get the feature of reassignment to work.

Regards, and please advise, David.

[geezenslaw]

Hello Alexey, thanks for the reply. Your suggestions helped and now
our EmForge Issue Tracker is doing a much better job for our project.
I have installed another instance of EmForge but I have changed the
database to: MySQL. I have used the hSQL database in the past
standalone. I have not used the hSQL db in memory as is done in the
out-of-the-box EmForge. I have used the AWT client hSQL
DatabaseManager to access the hSQL databases in the past. I want to
migrate my hSQL/EmForge instance to my new MySQL/EmForge instance.
What is the jdbc URL for a connection to your in-memory hSQL db? Or do
you know of some good scheme or script to migrate (ETL) the hSQL
records to MySQL for EmForge? Please advise, David.

[Alexey Kakunin]

Hi David!

Sorry I was not able to answer to your previous email (I was outside the city) - but I happy to see you resolved your problem with user (issue was you don't need to create new role in project, but need assign user to some role in project)

About hsql - EmForge user not in-memory HSQL (because in this case all data will be lost after stopping EmForge and HSQL instance. EmForge user file-system based hsql. Files stored somethere on file-system - there exactly - depends from your operation-system and how you run it.

For example, if you are using Windows and EmForge installed from msi, HSQL DB will be at <PathToInstallEmForge>/EmForge.db (or just try to find EmForge.db file in your filesystem)

So, to connect to this DB from AWT client, you need to use followed jdbc url:
jdbc:hsqldb:file:/path/to/emforge/EmForge.db
Just replace path/to/emforge to your real path used for installation.
But, please, note, since HSQL lock file for one process, you will not able access this DB in AWT HSQL admin while EmForge is run

About migration from HSQL to MySQL:
Unfortunately, I do not know proper way to migrate data from one type of DB to another :( Different DBs used different way to generate ids for primary keys, as well as used different data-types.

Some time ago I planned to implement import-export tool (via XML) allowed to import data from other systems, as well as migrate to another DB via export/import data - but, due to limited resources - this feature still not implemented

2009/7/25 geezenslaw <da...@davidwbrown.name>