Spec me a fault reporting system!

[NVP]

Damn you guys are killing it. I've only ever worked for an huge international beast so always either in house or custom package stuff is used... I can guarantee your home made office version will be a million times more useful and usable as well as customisable.

 

[AHarvey]

You could try Jira Service Desk. The pricing is based on the number of people handling requests (Atlassian call these “agents”) and not the number of people who can raise issues (Atlassian call these “customers”). Take it as a SaaS service for as little as $10 a month for up to 3 Agents https://www.atlassian.com/software/jira/service-desk/pricing

We use Jira and TopDesk at my company, the dev's like Jira but from a support point of view we absolutely ******* hate it. Topdesk is far superior but even that isn't great.

 

[Maccy]

I would but I’m not allowed to advertise. Perhaps an acceptable and more helpful money saving suggestion for forum members I could have given would be to say that instead of going direct then find a platinum partner on here and ask for a quote as any has the means to give a discount: https://partnerdirectory.atlassian.com/

If this is also advertising (I don’t work for Atlassian though) then please accept my apologies and delete.

Ahhh yes I remember who you are now, good looking company I remember

 

[Diddums]

I could build you a sexy Excel spreadsheet? (I love a good tracker spreadsheet )

I'd do this with a group Spreadsheet. But then I bloody love spreadsheets.

I'm even worse

I do it with access and a front end form

who doesnt love look up drop downs for a userlist or item number list...

(@Maccy please give me a spanking if this is naughty.)

Alright then you three! I have a mission for you, should you wish to accept it. Compensation will be agreed and will be paid via invoice from my company. I'm sure an Excel wizard could knock something like this up in a day so let me know what you'd charge for this:

• A spreadsheet which will be universal, to be able to be used across various sites.
• Include various categories, such as maintenance, stock checking, and any other tasks that we may need to carry out in an office.
• Include an asset list, with various columns for various data, such as maintenance frequency, description of how to conduct regular maintenance*, specialist contractor, their contact details, a little photo, etc.
• PPM planner week by week, so if I enter week 36 it spits out all the tasks that need doing
• An exportable checklist so that once a task is completed it can be printed and filed, or saved to a drive, so if something goes wrong later on we can nail someone's arse to the wall prevent it happening again.

*If possible, export a separate printable document which can also be saved to a drive, so an engineer can print off the document that the spreadsheet has produced, stick it on a clipboard, go do the works, then return and input the data on a PC and save it for future reference.

This is, of course, completely separate from a ticketing system but the goalposts have moved a bit as of this morning so I need to adapt, and adapt quickly.


So TL;DR:

Engineer opens spreadsheet, enters week number, spreadsheet spits out exactly what needs servicing (preferably with separate sheets explaining what to do and what materials are needed which can also be saved separately). Also generates a list separately which can be filled in, detailing all the info with space for comments, materials used, etc.

It's a bit rough, but is this workable? Whatchafink?

 

[Marky]

(@Maccy please give me a spanking if this is naughty.)

Alright then you three! I have a mission for you, should you wish to accept it. Compensation will be agreed and will be paid via invoice from my company. I'm sure an Excel wizard could knock something like this up in a day so let me know what you'd charge for this:

• A spreadsheet which will be universal, to be able to be used across various sites.
• Include various categories, such as maintenance, stock checking, and any other tasks that we may need to carry out in an office.
• Include an asset list, with various columns for various data, such as maintenance frequency, description of how to conduct regular maintenance*, specialist contractor, their contact details, a little photo, etc.
• PPM planner week by week, so if I enter week 36 it spits out all the tasks that need doing
• An exportable checklist so that once a task is completed it can be printed and filed, or saved to a drive, so if something goes wrong later on we can nail someone's arse to the wall prevent it happening again.

*If possible, export a separate printable document which can also be saved to a drive, so an engineer can print off the document that the spreadsheet has produced, stick it on a clipboard, go do the works, then return and input the data on a PC and save it for future reference.

This is, of course, completely separate from a ticketing system but the goalposts have moved a bit as of this morning so I need to adapt, and adapt quickly.


So TL;DR:

Engineer opens spreadsheet, enters week number, spreadsheet spits out exactly what needs servicing (preferably with separate sheets explaining what to do and what materials are needed which can also be saved separately). Also generates a list separately which can be filled in, detailing all the info with space for comments, materials used, etc.

It's a bit rough, but is this workable? Whatchafink?

If you want it to spit out reports/lists etc. I think Access might be the way to go. I have experience in that also, but I don't know how commonly used it is anymore (maybe someone else can chime in on this? We still use it at our work, but we know it's very outdated these days).

 

[balls]

Spiceworks is a good shout and has a configurable user portal - Perhaps a bit to IT focused but is free and could be adapted to what you are after.

Used at our work also - seems to work quite well

 

[AHarvey]

(@Maccy please give me a spanking if this is naughty.)

Alright then you three! I have a mission for you, should you wish to accept it. Compensation will be agreed and will be paid via invoice from my company. I'm sure an Excel wizard could knock something like this up in a day so let me know what you'd charge for this:

• A spreadsheet which will be universal, to be able to be used across various sites.
• Include various categories, such as maintenance, stock checking, and any other tasks that we may need to carry out in an office.
• Include an asset list, with various columns for various data, such as maintenance frequency, description of how to conduct regular maintenance*, specialist contractor, their contact details, a little photo, etc.
• PPM planner week by week, so if I enter week 36 it spits out all the tasks that need doing
• An exportable checklist so that once a task is completed it can be printed and filed, or saved to a drive, so if something goes wrong later on we can nail someone's arse to the wall prevent it happening again.

*If possible, export a separate printable document which can also be saved to a drive, so an engineer can print off the document that the spreadsheet has produced, stick it on a clipboard, go do the works, then return and input the data on a PC and save it for future reference.

This is, of course, completely separate from a ticketing system but the goalposts have moved a bit as of this morning so I need to adapt, and adapt quickly.


So TL;DR:

Engineer opens spreadsheet, enters week number, spreadsheet spits out exactly what needs servicing (preferably with separate sheets explaining what to do and what materials are needed which can also be saved separately). Also generates a list separately which can be filled in, detailing all the info with space for comments, materials used, etc.

It's a bit rough, but is this workable? Whatchafink?

If it's multi-site i'd be looking at google sheets/forms etc if that's the way you wanted to go, otherwise, I'd be looking at a cheap website build with a database backend.

Something like https://gsuite.google.com/marketplace/app/mojo_helpdesk/934375269201

 

[Armageus]

If it's multi-site i'd be looking at google sheets/forms etc if that's the way you wanted to go, otherwise, I'd be looking at a cheap website build with a database backend.

Something like https://gsuite.google.com/marketplace/app/mojo_helpdesk/934375269201

Thanks - been looking for something like this for Work - we are already using Google Apps, so this should be ideal

 

[AHarvey]

Thanks - been looking for something like this for Work - we are already using Google Apps, so this should be ideal

I've been meaning to try and make more use of google apps and get into scripting etc for it but I just never have the time. It offers so much for small businesses without the costs associated with other licenses etc

 

[WantoN]

I’m afraid I won’t be taking up the challenge @AHarvey

Nothing personal chap, just have a plateful on. I’d rather spend my free time dossing

I’d agree that given your requirements that Access could be appropriate, it’s old school but effective, and flexible enough.

We use networked spreadsheet for product requests and changes, special returns etc it works well for things outside the scope of our MRP system. They automatically assign unique IDs etc

 

[AHarvey]

I’m afraid I won’t be taking up the challenge @AHarvey

Nothing personal chap, just have a plateful on. I’d rather spend my free time dossing

I’d agree that given your requirements that Access could be appropriate, it’s old school but effective, and flexible enough.

We use networked spreadsheet for product requests and changes, special returns etc it works well for things outside the scope of our MRP system. They automatically assign unique IDs etc

think you meant to tag @Diddums

 

[m@rty]

Why are you not looking for a full blown CAFM system?

 

[Diddums]

Why are you not looking for a full blown CAFM system?

Sadly we're not at that point yet, this company has grown ridiculously in recent years and certain aspects have been left behind, one of which I'm in the position to turn around and make a huge impact. I need to build a case for a CAFM system to get the funding. It'll come eventually, just takes time, effort and patience.

The scope for opportunity at this company is like nothing I've seen before, so hopefully I can pick up a few folks along the way.

 

[Delta3D]

Spiceworks was fantastic for a client I provided support for. Free version and was customization to fit their needs, could also run reports off etc to see usage and common problems. Plus it has user-made addons

 

[randomshenans]

If you use O365, use SharePoint and build a list. Piece of cake.

 

[Gypo]

Spiceworks

 

[PiKe]

Is there anything out there that you can use in a retail environment for general public walk ins but also doubles as a ticket system for companies?

We currently use a very, very old system by oneorzero, it works but it's kind of clunky.

 

[Diddums]

If you use O365, use SharePoint and build a list. Piece of cake.

Can you elaborate on this a bit? We do use O365 so it could be a goer. I thought Sharepoint was just a shared drive

 

[hegemon]

Implemented this in my workplace, we use it for small projects and issue/feature requests mainly. It has been very successful for the past 5 years.

https://www.redmine.org/

It's open source and free.

 

[Diddums]

Bippity boppity bump!

Found something which looks fantastic on paper, has TONS of functionality and features, has an app which allows loads of stuff too, gonna have a play tonight and see how it goes.

It’s called UpKeep Maintenance Management CMMS.

In case anyone cares, I’ll post up some thoughts / updates as I go