Virtual machine with jobsworth

[John Doe]

ClockingIT has a VM that has Ubuntu Server setup and with ClockingIT installed.

Can something similar be done for jobsworth?

[Aristedes Maniatis]

On 19/09/2016 8:55pm, John Doe wrote:
> ClockingIT has a VM that has Ubuntu Server setup and with ClockingIT installed.
>
> Can something similar be done for jobsworth?

I don't have the time to create such a thing, but I could see it would be very useful if someone would like to create one.

Ari



--
-------------------------->
Aristedes Maniatis
CEO, ish
https://www.ish.com.au
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

[Joubert]

Hi guys,

Then, why not a docker image then?

______________________________________________________

Joubert "RedRat"

/me at Linkedin and Github

--

---
You received this message because you are subscribed to the Google Groups "jobsworth" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobsworth+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[John Doe]

It just so FRUSTRATING and so many steps that it gets tiring when you hit roadblock after roadblock...

IMO, its one (the frustration and non easy install) of the reason people are chosing other time/project mangament programs instead of ClockingIT/jobsworth...

[Aristedes Maniatis]

Sure, I understand that if you aren't familiar with the Java application environment it can be confusing. But to be clear, I've released years of my own development work and tens of thousands of dollars worth of paid development. And I've released it under an open source license because I believe in open source.

However, my time is limited and I don't really have any availability to work on things which I can't use myself. So this is an opportunity for others to step forward and help the community grow, develop their own features or package jobsworth to make it easier. Maybe someone will offer a commercial service and people can pay others to have a hosted supported offering.

That's not my goal right now, and I don't see it anywhere in my future. But if someone wants to step into this gap, brilliant!

Cheers
Ari

> --
>
> ---
> You received this message because you are subscribed to the Google Groups "jobsworth" group.

> To unsubscribe from this group and stop receiving emails from it, send an email to jobsworth+...@googlegroups.com <mailto:jobsworth+...@googlegroups.com>.

> For more options, visit https://groups.google.com/d/optout.

[John Doe]

The thing is that I have yet to see one complete installation of this. One thing is to install it on your box. Another thing is just release half baked together software.

Ive developed web services on Java perfectly. From scratch. This isnt about being familiar with Java or not. Its just about not making things clear.

[Aristedes Maniatis]

On 23/09/2016 1:12am, John Doe wrote:
> The thing is that I have yet to see one complete installation of this. One thing is to install it on your box. Another thing is just release half baked together software.
>
> Ive developed web services on Java perfectly. From scratch. This isnt about being familiar with Java or not. Its just about not making things clear.

If you want a company supported product with a support service, I recommend you choose a different system. If you want to log tasks with the problems you hit during installation and detailed technical descriptions of what you did to try and resolve it, then I'll be happy to assist in my spare time.

[John Doe]

Slowly and fighting Im getting there! :) Its a shame there isnt enough documentation but like you said, this is a spare time Project.

In your opinion, what different system would you choose that comes closest to ClockingIT/jobsworth?

[Ángel F]

+1
I have been in love with Jobsworth since day one, but it is too
difficult to manage, install and update, so I use other systems and I
cannot get anyone to use it either.

> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "jobsworth" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to jobsworth+...@googlegroups.com.

[John Doe]

What did you switch to?

[Daniel Thiele]

I would also like to express my interest in a docker image and also would like to know a good alternative...

[Frank Orellana]

Hi, I've finally managed to create a VM using ubuntu server 16.10 and Jobsworth 5.0 beta2, I am trying to upload it somewhere to share it.

In the meantime, I'm testing it and I'm a little puzzled because I don't find some features that where in the hosted version (clockingit) or maybe I just don't find them:

Reports (I dont see the option at all... it is one of the main reasons I like clockingit!)
Start working button (it was also hard to figure out that the user had to had checked the track time to be able to record worked time)
Notes

Hopefully I'm just not seeing the options for some reason :), maybe these changes are in the next beta, if someone creates it I can update de VM with it.

I will let you know when i have the VM uploaded somewhere.

[Aristedes Maniatis]

On 4/4/17 3:11pm, Frank Orellana wrote:
> Hi, I've finally managed to create a VM using ubuntu server 16.10 and Jobsworth 5.0 beta2, I am trying to upload it somewhere to share it.

Excellent, thanks. Perhaps a set of instructions on how you created it might also be useful for others.

> In the meantime, I'm testing it and I'm a little puzzled because I don't find some features that where in the hosted version (clockingit) or maybe I just don't find them:
>
> Reports (I dont see the option at all... it is one of the main reasons I like clockingit!)
> Start working button (it was also hard to figure out that the user had to had checked the track time to be able to record worked time)
> Notes

I don't recall any reports which were removed over the years, but it has been a very long time. Start working button was greatly enhanced (you can even have different timers in different tabs in your browser). Notes were definitely removed because I couldn't see the point of them. They went nowhere and integrated with nothing else.

[Frank Orellana]

Well.. I'll try to gather the instructions (i have written down most of what i did but it's a mess... I'll try to clean them up and share them along with the VM). I will also try a little bit more the new version and see what I can find, thanks!

[Frank Orellana]

Hi, I added the links to the VM and the instructions to create it from scratch in a new post.

I still can't find where to generate the reports from jobsworth. In clockingIt there was a direct menu to generate them, and you could generate Pivot, Audit, Timeline and Workload reports in it. Is this option still available in jobsworth 5? I gave all the permissions to the users that I could find but still cannot find the option or a way to generate something similar.

This is the option I am talking about:


Thanks!

[Aristedes Maniatis]

I'd like to include any more hints you have on the README at https://github.com/ari/jobsworth about setting it up from scratch, but your VM will help a lot of people. Thank you.

All those worklog reports are still there. In fact they are greatly enhanced. I added a whole layer around billing (to drive our external finance invoicing system), although these days I don't do any hourly billing any longer so that's not something I still use.

The main things I removed were:

* notes
* chat (there are so many other, better chat tools and I wanted to get rid of Flash from the app)
* visual representation of subtasks (I wanted to keep it, but I also wanted a better grid tool)
* probably other smaller stuff you'll find in the release notes


Ari

On 5/4/17 11:30am, Frank Orellana wrote:
> Hi, I added the links to the VM and the instructions to create it from scratch in a new post.
>
> I still can't find where to generate the reports from jobsworth. In clockingIt there was a direct menu to generate them, and you could generate Pivot, Audit, Timeline and Workload reports in it. Is this option still available in jobsworth 5? I gave all the permissions to the users that I could find but still cannot find the option or a way to generate something similar.
>
> This is the option I am talking about:
>
>

> Thanks!
>
>
> El martes, 4 de abril de 2017, 2:47:51 (UTC-3), Frank Orellana escribió:
>
> Well.. I'll try to gather the instructions (i have written down most of what i did but it's a mess... I'll try to clean them up and share them along with the VM). I will also try a little bit more the new version and see what I can find, thanks!
>
>
>
> El martes, 4 de abril de 2017, 2:33:23 (UTC-3), Ari Maniatis escribió:
>
> On 4/4/17 3:11pm, Frank Orellana wrote:
> > Hi, I've finally managed to create a VM using ubuntu server 16.10 and Jobsworth 5.0 beta2, I am trying to upload it somewhere to share it.
>
> Excellent, thanks. Perhaps a set of instructions on how you created it might also be useful for others.
>
> > In the meantime, I'm testing it and I'm a little puzzled because I don't find some features that where in the hosted version (clockingit) or maybe I just don't find them:
> >
> > Reports (I dont see the option at all... it is one of the main reasons I like clockingit!)
> > Start working button (it was also hard to figure out that the user had to had checked the track time to be able to record worked time)
> > Notes
>
> I don't recall any reports which were removed over the years, but it has been a very long time. Start working button was greatly enhanced (you can even have different timers in different tabs in your browser). Notes were definitely removed because I couldn't see the point of them. They went nowhere and integrated with nothing else.
>
>
> Ari
>
>
> --
> -------------------------->
> Aristedes Maniatis
> CEO, ish
> https://www.ish.com.au
> GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
>

> --
>
> ---
> You received this message because you are subscribed to the Google Groups "jobsworth" group.

> To unsubscribe from this group and stop receiving emails from it, send an email to jobsworth+...@googlegroups.com <mailto:jobsworth+...@googlegroups.com>.

> For more options, visit https://groups.google.com/d/optout.

[Frank Orellana]

Great! the instructions are in the other post, in there I put the instructions to execute the vm and also to install it from scratch in any ubuntu server 16.10

This is a screen from the vm running jobsworth 5b2: (I can't find the reports anywhere :/ , I've been playing with it and nothing, that's the admin user with all the grants set, maybe I'm doing something wrong)



Thanks! It looks great btw.

[Aristedes Maniatis]

On 5/4/17 11:52am, Frank Orellana wrote:
> Great! the instructions are in the other post <https://groups.google.com/d/msg/jobsworth/NM2Ntd0GTUQ/PVLCZIsxEwAJ>, in there I put the instructions to execute the vm <https://github.com/frank-orellana/jobsworth/releases/tag/v5.0-beta-2-vm> and also to install it from scratch <https://github.com/frank-orellana/jobsworth/wiki/Jobsworth-5.0-beta-2-on-Ubuntu-Server-16.10> in any ubuntu server 16.10

Brilliant. Let's get that into the main wiki docs too.

Some thoughts:


* "mysql.exe"?

* Almost all of 1.2 can be replaced with just

apt-get install tomcat7

That should install Java, the tomcat user and everything else.

* 2.1. Instead of "sudo nano /opt/tomcat/conf/context.xml" how about:

wget https://github.com/ari/jobsworth/blob/master/config/context.example.xml -O /opt/tomcat/conf/context.xml


* 2.3

rm -rf webapps/ROOT should not be needed since tomcat will do that when you replace the war

> This is a screen from the vm running jobsworth 5b2: (I can't find the reports anywhere :/ , I've been playing with it and nothing, that's the admin user with all the grants set, maybe I'm doing something wrong)

What's under the "overview" menu for you?

[Frank Orellana]

Thanks, I corrected the mysql executable (it was because of the copy/paste mess i had)

* Almost all of 1.2 can be replaced with just
   apt-get install tomcat7

R/ I tried the apt-get install tomcat7  approach several times but failed... maybe i was missing some config or some permissions, but after many hours i decided to go with the download and config manually approach. It worked like a charm, maybe that's where many users start to get anxious with the installation, but maybe now that I know more of the possible fixes/erros, I will try that with the following beta and if it works I will update the tutorial.

* 2.1. Instead of "sudo nano /opt/tomcat/conf/context.xml" how about:
wget https://github.com/ari/jobsworth/blob/master/config/context.example.xml -O /opt/tomcat/conf/context.xml

R/  I was thinking of making it that way but I was still going to need to explain that they should update the file with the correct user and password of the database, the example file already has them configured with the info from the same tutorial (user: jw, pasword: jobsworth). Maybe we can have a context.xml ready to download with an user and password for the tutorial? that would make things easier!

* 2.3
rm -rf webapps/ROOT  should not be needed since tomcat will do that when you replace the war

R/ Yes I guess you are right, but after many attempts (an again... maaany hours :'( ), this is one of the things I did that lead to everything working fine for the first time so I decided to leave it in the instructions (just in case!)

What's under the "overview" menu for you?

R/ This is my overview menu (the same too for other admin user I created also with all the permissions I could find). I tried all of the options and cannot find it :/

Frank

[Aristedes Maniatis]

On 5/4/17 12:28pm, Frank Orellana wrote:
> R/ This is my overview menu (the same too for other admin user I created also with all the permissions I could find). I tried all of the options and cannot find it :/

Yes, its that item called "Billing". History also has stuff that (I think) used to be a report in old clockingit (but I really can't remember well).

[Frank Orellana]

Damn... I think I missed it (I'm still sleepy from all this setup). I think that's it, I will check it better tomorrow.

I will start working also on a script to migrate all the data from the hosted app. If someone has a script with the db structure of the old app, that would be great. I found some things in the code but it appears it's not complete, and although I guess i could infer the columns from the dump and the schema.rb file it would be a lot easier to have that.

Hopefully I will be able to create a script that would at least migrate the most important stuff.

Also is there a way to sync the wiki page in my fork with the main project or should we just create a new one in it? I was thinking of creating either a new folder in the project with the needed files so the tutorial can just download them, or create a new "jobsworth-installer-or-something-like-that" project with the files in them.

Thanks!

[Aristedes Maniatis]

On 5/4/17 12:57pm, Frank Orellana wrote:
>
> I will start working also on a script to migrate all the data from the hosted app. If someone has a script with the db *structure* of the old app, that would be great. I found some things in the code but it appears it's not complete, and although I guess i could infer the columns from the dump and the schema.rb file it would be a lot easier to have that.

In theory, you could run all the migrations in jobsworth and upgrade everything from a clockingIT export. In practice Rails migrations aren't that robust and I'd say you'd need to go back to each major jobsworth release (1, 2, 3, etc) and upgrade one step at a time. The schema changes have been significant over the years.

Some people moved to jobsworth and kept up to date over time. But a big upgrade of 8 years in one go is pretty hard.

> Hopefully I will be able to create a script that would at least migrate the most important stuff.

Yes, start with everything in the migrations folder and see what breaks. Some of will need to be converted to raw SQL statements I think.

> Also is there a way to sync the wiki page in my fork with the main project or should we just create a new one in it? I was thinking of creating either a new folder in the project with the needed files so the tutorial can just download them, or create a new "jobsworth-installer-or-something-like-that" project with the files in them.

Not sure, but the wiki on my project has public edit rights, so go for it.

[Frank Orellana]

Hi again,

Here it is an updated VM with jobsworth intalled in it : Download from dropbox, (if anyone knows a better and safe file sharing site let me know) 

Also I think the installer script is pretty much ready now if you prefer to install it on your own. You can check it out in the side project I created for it in github: jobsworth-installer

This VM is built with Ubuntu Server 17.04 minimal, so the size is much smaller than the first one which I'm gonna be deleting soon.

The install script has been tested on Debian 8.8, and Ubuntu from the 15.10 version up to the 17.04

[Aristedes Maniatis]

Hi Frank

Thanks so much for doing this... very useful indeed. I'll put some pointers to it on the main site if some other people would like to also confirm they are all able to easily follow these instructions.

As for hosting, why not just put the binaries on github? https://help.github.com/articles/distributing-large-binaries/

Ari

On 18/5/17 3:41pm, Frank Orellana wrote:
> Hi again,
>

> Here it is an updated VM with jobsworth intalled in it : Download from dropbox <http://bit.ly/jobsworth5b2_7z>, (if anyone knows a better and safe file sharing site let me know)
>
> Also I think the installer script is pretty much ready now if you prefer to install it on your own. You can check it out in the side project I created for it in github: jobsworth-installer <http://bit.ly/2p7MpYz>

>
> This VM is built with Ubuntu Server 17.04 minimal, so the size is much smaller than the first one which I'm gonna be deleting soon.
>
> The install script has been tested on Debian 8.8, and Ubuntu from the 15.10 version up to the 17.04
>
>
>
>
> El miércoles, 5 de abril de 2017, 0:10:14 (UTC-3), Ari Maniatis escribió:
>
> On 5/4/17 12:57pm, Frank Orellana wrote:
> >
> > I will start working also on a script to migrate all the data from the hosted app. If someone has a script with the db *structure* of the old app, that would be great. I found some things in the code but it appears it's not complete, and although I guess i could infer the columns from the dump and the schema.rb file it would be a lot easier to have that.
>
> In theory, you could run all the migrations in jobsworth and upgrade everything from a clockingIT export. In practice Rails migrations aren't that robust and I'd say you'd need to go back to each major jobsworth release (1, 2, 3, etc) and upgrade one step at a time. The schema changes have been significant over the years.
>
> Some people moved to jobsworth and kept up to date over time. But a big upgrade of 8 years in one go is pretty hard.
>
>
> > Hopefully I will be able to create a script that would at least migrate the most important stuff.
>
> Yes, start with everything in the migrations folder and see what breaks. Some of will need to be converted to raw SQL statements I think.
>
>
> > Also is there a way to sync the wiki page in my fork with the main project or should we just create a new one in it? I was thinking of creating either a new folder in the project with the needed files so the tutorial can just download them, or create a new "jobsworth-installer-or-something-like-that" project with the files in them.
>
> Not sure, but the wiki on my project has public edit rights, so go for it.
>
> Ari
>
>
>
> --
> -------------------------->
> Aristedes Maniatis
> CEO, ish
> https://www.ish.com.au
> GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
>

> --
>
> ---
> You received this message because you are subscribed to the Google Groups "jobsworth" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to jobsworth+...@googlegroups.com <mailto:jobsworth+...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.

[Frank Orellana]

Thanks, I managed to upload it to the release (I've tried before but maybe the VM was too big, now it worked fine)

So updating the links:

Installer and Migration script: Instructions and download

Preinstalled Virtual Machine: download

Step by step installation instructions: Wiki

cheers