<span style="font-family: Arial, Helvetica, Sans-Serif; font-size: 12px"><div>Eric - thanks!</div>
<div> </div>
<div>I will give it some thought, and see what I think the User Requirements should be. </div>
<div> </div>
<div>[Later thought inserted here --- After giving this a bit of thought, it is beginning to look complicated, so if this more than you thought, please just say so. This will still be valuable as a conversation starter for the group...]</div>
<div> </div>
<div>As a start, I'm sure I will want the database to capture:</div>
<div>- Dates of work [started, completed]</div>
<div>- Issue / complaint / As-found condition [something about how the repair event started]</div>
<div>- Requested By [could default to someone, rule based]</div>
<div>- Work performed / As-left condition</div>
<div>- Parts list [quantity, description, part #, price, source]</div>
<div> -- A lookup table for commonly used sources would be a time saver, once the static data was input</div>
<div>- Who performed the work [likely would default to someone, based on some rule]</div>
<div>- Subject of the work [which vehicle, house, computer, router, tool, etc]</div>
<div> -- Vehicles might call for a simple identifier on the main table, with the details of each vehicle in a separate table</div>
<div> -- haven't thought through how to handle variable transaction data, like current vehicle mileage. could be on main, or pop-up, or?</div>
<div> -- Computers might benefit from the same kind of treatment, since they vary by make, model, memory, storage, etc.</div>
<div>- Subcontracted or sublet items [eg, machine shop, electrician, computer shop, etc] with what, who, how much</div>
<div>- Comments field [no particular purpose, but ...]</div>
<div>
<div> </div>
<div> </div>
<div>Al Fuller<br />
al@bighealey.org<br />
<br />
'65 A-H BJ-8<br />
'85 Rx-7 GSL-SE</div>
</div>
<div> </div>
<hr align="center" size="2" width="100%" />
<div><span style="font-family: tahoma,arial,sans-serif; font-size: 10pt;"><b>From</b>: eric@megageek.com<br />
<b>Sent</b>: Friday, June 23, 2017 9:13 AM<br />
<b>To</b>: al@bighealey.org<br />
<b>Cc</b>: Shop-talk@autox.team.net<br />
<b>Subject</b>: Re: [Shop-talk] Repair Order Database</span>
<div> </div>
<font face="sans-serif" size="2">What would you want the app to do? How would you image using it? I can try to start working on something if you want.</font><br />
<br />
<br />
<font face="sans-serif" size="2">Sent from my Commodore 64 on a 2400 Baud Modem.<br />
Tech Viper<br />
"Be as beneficent as the sun or the sea, but if your rights as a rational being are trenched on, die on the first inch of your territory." Ralph Waldo Emerson </font><br />
<br />
<br />
<br />
<font color="#5f5f5f" face="sans-serif" size="1">From: </font><font face="sans-serif" size="1">"Al Fuller" <al@bighealey.org></font><br />
<font color="#5f5f5f" face="sans-serif" size="1">To: </font><font face="sans-serif" size="1"><Shop-talk@autox.team.net>, <eric@megageek.com></font><br />
<font color="#5f5f5f" face="sans-serif" size="1">Date: </font><font face="sans-serif" size="1">06/23/2017 09:02 AM</font><br />
<font color="#5f5f5f" face="sans-serif" size="1">Subject: </font><font face="sans-serif" size="1">Re: [Shop-talk] Repair Order Database</font>
<hr noshade="noshade" /><br />
<br />
<br />
<font face="Arial" size="1">Hey Eric:</font><br />
<font face="Arial" size="1"> </font><br />
<font face="Arial" size="1">I have no access to or knowledge to Domino, so that wouldn't be my first choice. </font><br />
<font face="Arial" size="1"> </font><br />
<font face="Arial" size="1">However, the idea of the system having a web app does sound like an idea that would make it more usable. I could see access to the info from the shop or garage using a smartphone or tablet, and not having to have a full-fledged computer at hand.</font><br />
<font face="Arial" size="1"> </font><br />
<font face="Arial" size="1"> </font><br />
<font face="Arial" size="1">Al Fuller<br />
al@bighealey.org<br />
<br />
'65 A-H BJ-8<br />
'85 Rx-7 GSL-SE</font><br />
<font face="Arial" size="1"> </font>
<hr /><br />
<font face="Tahoma" size="2"><b>From</b>: eric@megageek.com<br />
<b>Sent</b>: Friday, June 23, 2017 4:49 AM<br />
<b>To</b>: Shop-talk@autox.team.net<br />
<b>Cc</b>: "Al Fuller" <al@bighealey.org><br />
<b>Subject</b>: Re: [Shop-talk] Repair Order Database</font><font face="Arial" size="1"> </font><br />
<font face="Arial" size="1"> </font><br />
<font face="sans-serif" size="2">I'm a Lotus Domino guy all the way. I run my own web/mail server in the environment. I have made web apps and phone apps for my needs. If you have access to an environment, it's the way to go. </font><br />
<br />
<font face="sans-serif" size="2">I also use Access for smaller stuff at work. For what you are taking about, it would most likely be the way to go if you doing everything yourself and you already have Office. If you need any help building it, let me know.</font><br />
<br />
<font face="sans-serif" size="2">If you just want a web app in Domino (and you don't care how pretty it is (I don't do pretty)) I can build something on my domino server for you guys. It would be 100% free for you.</font><br />
<br />
<font face="sans-serif" size="2">Let me know.</font><br />
<br />
<br />
<font face="sans-serif" size="2">Sent from my Commodore 64 on a 2400 Baud Modem.<br />
Tech Viper<br />
"Be as beneficent as the sun or the sea, but if your rights as a rational being are trenched on, die on the first inch of your territory." Ralph Waldo Emerson </font><br />
<br />
<br />
<br />
<font color="#5f5f5f" face="sans-serif" size="1">From: </font><font face="sans-serif" size="1">"Al Fuller" <al@bighealey.org></font><br />
<font color="#5f5f5f" face="sans-serif" size="1">To: </font><font face="sans-serif" size="1"><Shop-talk@autox.team.net></font><br />
<font color="#5f5f5f" face="sans-serif" size="1">Date: </font><font face="sans-serif" size="1">06/22/2017 23:11</font><br />
<font color="#5f5f5f" face="sans-serif" size="1">Subject: </font><font face="sans-serif" size="1">[Shop-talk] Repair Order Database</font><br />
<font color="#5f5f5f" face="sans-serif" size="1">Sent by: </font><font face="sans-serif" size="1">"Shop-talk" <shop-talk-bounces@autox.team.net></font><font face="Arial" size="1"> </font>
<hr noshade="noshade" /><br />
<br />
<br />
<font face="Calibri" size="2">Do any of you guys know of a good repair order database for home or small shop use?<br />
<br />
Two of us were debating whether we set up port-forwarding or web server on the security camera system for one of the guys’ shop, but it could easily apply to keeping track of what has been done on our own cars. I think we have ten (10) cars between us that we are keeping on the road, so it’s easy to get confused.<br />
<br />
Anybody have a tool they use to keep track? I’m assuming the “best” candidate would be something that runs under Maria, mysql or MS Access, but I’m open to other suggestions.</font><br />
<br />
<font color="#004080" face="Calibri" size="2">Al Fuller<br />
al at bighealey dot org<br />
'65 BJ-8<br />
'85 Rx-7</font><br />
<font face="Arial" size="2">_______________________________________________</font><br />
<br />
<br />
<br />
</div></span>