Overclockers Australia Forums

OCAU News - Wiki - QuickLinks - Pix - Sponsors  

Go Back   Overclockers Australia Forums > Software Topics > Programming & Software Development

Notices

Reply
 
Thread Tools
Old 22nd December 2016, 10:09 PM   #1
ChiefBoss Thread Starter
Member
 
ChiefBoss's Avatar
 
Join Date: Mar 2012
Location: Melbourne
Posts: 198
Default Write Us A Database!

We do things at my place of work almost exclusively on paper. We carry around field laptops but everything is done on paper - its a completely rooted set-up.

It would make things so much more efficient, easier, convenient and most importantly (for the company, and our client/s) reduce cost if we moved all this bullshit paperwork into/onto a database system.

I'm hoping to find someone small (individual or business, this would be great for a Uni Student on summer break too I'd imagine) that I can chat with and discuss in more detail the nature of our business and the kinds of things and ideas we could implement to make this thing chooch!

A brief description of what we do...

We oversee the maintenance and installation of a large hydrographic network. This network collects stream/river level, water quality and rainfall data. Maintenance is carried out on these sites on a rotating monthly/bi-monthly roster. we have several teams that do this work. Field observations are manually recorded and referenced to instrumentation readings.

This database can/would allow us to run a report before we go to a group of sites, the report would have a list of materials and equipment that we need to bring - this would be to repair or improve something that we noted last visit.

It could allow us to track the history of instrumentation as it gets moved around over the years... for example, a particular piece of kit might be found to be out of calibration. It would be good to know where it was used prior to the current location in case the data it captured there needs editing.

Let me know if you're keen!

Last edited by ChiefBoss; 18th January 2017 at 7:44 PM.
ChiefBoss is offline   Reply With Quote
Old 22nd December 2016, 11:53 PM   #2
Sindarin Ultra
Member
 
Sindarin Ultra's Avatar
 
Join Date: Sep 2005
Location: Brisbane
Posts: 236
Default

Ha, I knew that all sounded familiar! http://forums.overclockers.com.au/sh....php?t=1174753

I do some freelance software dev and might be able to help

Do you generally have internet access on site? A central online database would probably be easiest, also avoiding offline sync issues etc. Access the db through a web interface or desktop client depending on what you need to do.
Sindarin Ultra is offline   Reply With Quote
Old 23rd December 2016, 7:10 PM   #3
Smokin Whale
Member
 
Smokin Whale's Avatar
 
Join Date: Nov 2006
Location: Pacific Ocean off SC
Posts: 5,168
Default

Airtable, or at least Google Forms/Sheets?

Easy enough for the layman to play with.
Smokin Whale is offline   Reply With Quote
Old 18th January 2017, 7:38 PM   #4
ChiefBoss Thread Starter
Member
 
ChiefBoss's Avatar
 
Join Date: Mar 2012
Location: Melbourne
Posts: 198
Default

Yes, a cloud based solution is definitely the way to go. this would mean people in the office could get access to data without us having to go back and sync to the network.

I've had a quick look at Airtable and google forms on your advice but they might be a little to limited in their functionality... I'm not sure.

I guess my other line of thinking is that I'm way to bloody busy at the moment to put the work in myself, otherwise I'd have done something in MS Access already - and poorly at that!

Fundamentally I like the idea of getting a professional to craft something tailored to our needs that, when the time and needs dictates, can be expanded to incorporate further functionality etc.
ChiefBoss is offline   Reply With Quote
Old 21st January 2017, 10:58 AM   #5
breech
Member
 
breech's Avatar
 
Join Date: Mar 2002
Location: Syd
Posts: 1,780
Default

Take a look at Trello, now owned by Atlassian, it might be an easy start and could be merged into the heavier products later.
breech is offline   Reply With Quote
Old 23rd January 2017, 10:17 AM   #6
^catalyst
Member
 
^catalyst's Avatar
 
Join Date: Jun 2001
Location: melbourne
Posts: 11,566
Default

Yeah, Trello is good for this type of deal.
^catalyst is offline   Reply With Quote
Old 23rd January 2017, 10:28 AM   #7
Maelstrom
Member
 
Maelstrom's Avatar
 
Join Date: Jul 2001
Location: Canberra
Posts: 1,558
Default

Surely if it's a decently sized business ("large hydrographic network") then it would be worthwhile getting a business grade solution worked out?

I mean, a simple online database with forms would be worlds ahead of paper, but there are a lot of additional things to consider:

* What is your backup arrangement, and how quickly can you restore from it?
* What will you do when there are outages (especially if they last days)?
* How many people can use it at once, and what happens if you grow?
* How secure is your data (and what happens if it gets pinched/modified/leaked)?
* Can your customers access it on the platform, or do you need people to manually produce reports?

etc etc etc

You don't necessarily need to gold plate it, and you don't want to put up so many road blacks that it can't make progress, but getting a good solution set up that addresses these could make the difference between a clunky system that costs time to maintain and later leads to regret vs something that works off the bat and helps the company save time/money and can therefore grow.

PS Trello is basically online post-it-notes - good for basic task management, but not able to generate reports of things you need on a per site basis or anything like that.
Maelstrom is online now   Reply With Quote
Old 23rd January 2017, 11:19 AM   #8
Uranux
Member
 
Uranux's Avatar
 
Join Date: Sep 2001
Location: Brisbane
Posts: 111
Default

Have you looked at Powerapps? My brother has been doing a bit of work with it recently for some of his clients and it seems to be well received.
Uranux is offline   Reply With Quote
Old 25th January 2017, 1:30 PM   #9
beech_boy
Member
 
Join Date: Jul 2005
Location: Sydney
Posts: 9
Default

It also sounds like you want some Asset Management functions as well on top of CMMS system.

I work for an Aussie company that provides Asset Management, Work Order, Problem, Inventory management solutions.

PM if you have questions.
beech_boy is offline   Reply With Quote
Old 31st January 2017, 10:43 AM   #10
Satriani
Member
 
Join Date: Apr 2005
Posts: 214
Default

Quote:
Originally Posted by beech_boy View Post
It also sounds like you want some Asset Management functions as well on top of CMMS system.

I work for an Aussie company that provides Asset Management, Work Order, Problem, Inventory management solutions.

PM if you have questions.
Pulse?

10char
Satriani is offline   Reply With Quote
Old 14th June 2017, 9:23 PM   #11
ChiefBoss Thread Starter
Member
 
ChiefBoss's Avatar
 
Join Date: Mar 2012
Location: Melbourne
Posts: 198
Default

Just following up on this.

Work hired a professional developer to write an app for iOS.

Seems like it could be a good thing but will wait for the beta!

The best thing they have done is have it so we own the app making it an asset and functional tool. Obviously there'll be some issues along the way but us owning it will mean that more functionality can be built in later on as needs shift etc.
ChiefBoss is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +10. The time now is 4:55 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
OCAU is not responsible for the content of individual messages posted by others.
Other content copyright Overclockers Australia.
OCAU is hosted by Micron21!