Gages & Calibrations

system · September 18, 2008, 11:08am

Nothing to stop you from keeping it in Access and just customizing a form to odbc/SQL query Access from within your .NET custom code and then display it as desired in Vantage.

We have a number of things in SQL server db's that still have no good home in the Progress db - so we left it there and just pull it into forms where needed.

We PLAN to eventually migrate a lot of this stuff to Progess - but it seemed smarter/safer to wait for the product to continue to mature (and perhaps provide native tables to hold the data instead of rushing to judgement that will never happen and dumping it to UD tables).

Frankly, there is a lot less code involved integrating non-Progress data via odbc/sql than there is to use UD tables.

Rob Brown

--- On Thu, 9/18/08, Toby Boogerd <tboogerd@...> wrote:

From: Toby Boogerd <tboogerd@...>
Subject: RE: [Vantage] Re: Gages & Calibrations
To: vantage@yahoogroups.com
Date: Thursday, September 18, 2008, 10:51 AM

Currently I'm debating seeing what I can do in V8 with a custom form and
some code. We don't need it to be some out the this world system, just a
place to store and track data and gages with some flags. We currently
use Access but we are trying to get as many disparate systems into one,
that being Vantage.

____________ _________ _________ __

From: Michael McWilliams [mailto:mmcwilliams22@ yahoo.com]
Sent: Thursday, September 18, 2008 9:44 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Gages & Calibrations

Right now we are using something called QA Calibrate to track all
of this information. We also are planning on migrating it into
Vantage in the future. I would be interested in hearing what you
come up with.

--- In vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ,
"Toby Boogerd" <tboogerd@.. .> wrote:
>
> Anyone out there handling the tracking of gages and calibrations in
> Vantage?
> If so, can you elaborate.
>
>
> Toby Boogerd
> Information Systems
>
>
> <outbind://28-
000000008130E53E77D 25C4087FAED6E6AD B51C90700F6EC568 7CDB544
>
4CA70941294C6E8C0C0 0000108742C00007 9A3A132C79E4946B 63C6C608C157D360 00
030
> FE466D0000/cid: 995045216@ 04092008- 1C59> 712.324.4854 |
> <outbind://28-
000000008130E53E77D 25C4087FAED6E6AD B51C90700F6EC568 7CDB544
>
4CA70941294C6E8C0C0 0000108742C00007 9A3A132C79E4946B 63C6C608C157D360 00
030
> FE466D0000/cid: 995045216@ 04092008- 1C60> tboogerd@...
>
> NOTICE: This email may contain confidential and proprietary
information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
the
> recipient agrees not to use, reproduce, disclose, or manufacture
its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
>
>
> Please consider the environment before printing this email.
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

system · September 18, 2008, 10:38am

Anyone out there handling the tracking of gages and calibrations in
Vantage?
If so, can you elaborate.

Toby Boogerd
Information Systems

<outbind://28-000000008130E53E77D25C4087FAED6E6ADB51C90700F6EC5687CDB544
4CA70941294C6E8C0C00000108742C000079A3A132C79E4946B63C6C608C157D36000030
FE466D0000/cid:995045216@04092008-1C59> 712.324.4854 |
<outbind://28-000000008130E53E77D25C4087FAED6E6ADB51C90700F6EC5687CDB544
4CA70941294C6E8C0C00000108742C000079A3A132C79E4946B63C6C608C157D36000030
FE466D0000/cid:995045216@04092008-1C60> tboogerd@...

NOTICE: This email may contain confidential and proprietary information
of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
recipient agrees not to use, reproduce, disclose, or manufacture its
contents, in whole or in part, without prior written consent of
Rosenboom Machine & Tool, Inc.

Please consider the environment before printing this email.

[Non-text portions of this message have been removed]

system · September 18, 2008, 10:44am

Right now we are using something called QA Calibrate to track all
of this information. We also are planning on migrating it into
Vantage in the future. I would be interested in hearing what you
come up with.

--- In vantage@yahoogroups.com, "Toby Boogerd" <tboogerd@...> wrote:
>
> Anyone out there handling the tracking of gages and calibrations in
> Vantage?
> If so, can you elaborate.
>
>
> Toby Boogerd
> Information Systems
>
>
> <outbind://28-
000000008130E53E77D25C4087FAED6E6ADB51C90700F6EC5687CDB544
>
4CA70941294C6E8C0C00000108742C000079A3A132C79E4946B63C6C608C157D36000
030
> FE466D0000/cid:995045216@04092008-1C59> 712.324.4854 |
> <outbind://28-
000000008130E53E77D25C4087FAED6E6ADB51C90700F6EC5687CDB544
>
4CA70941294C6E8C0C00000108742C000079A3A132C79E4946B63C6C608C157D36000
030
> FE466D0000/cid:995045216@04092008-1C60> tboogerd@...
>
> NOTICE: This email may contain confidential and proprietary
information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
the
> recipient agrees not to use, reproduce, disclose, or manufacture
its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
>
>
> Please consider the environment before printing this email.
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · September 18, 2008, 10:48am

Currently I'm debating seeing what I can do in V8 with a custom form and
some code. We don't need it to be some out the this world system, just a
place to store and track data and gages with some flags. We currently
use Access but we are trying to get as many disparate systems into one,
that being Vantage.

________________________________

From: Michael McWilliams [mailto:mmcwilliams22@...]
Sent: Thursday, September 18, 2008 9:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Gages & Calibrations

Right now we are using something called QA Calibrate to track all
of this information. We also are planning on migrating it into
Vantage in the future. I would be interested in hearing what you
come up with.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Toby Boogerd" <tboogerd@...> wrote:

>
> Anyone out there handling the tracking of gages and calibrations in
> Vantage?
> If so, can you elaborate.
>
>
> Toby Boogerd
> Information Systems
>
>
> <outbind://28-

000000008130E53E77D25C4087FAED6E6ADB51C90700F6EC5687CDB544

>

4CA70941294C6E8C0C00000108742C000079A3A132C79E4946B63C6C608C157D36000
030

> FE466D0000/cid:995045216@04092008-1C59> 712.324.4854 |
> <outbind://28-

000000008130E53E77D25C4087FAED6E6ADB51C90700F6EC5687CDB544

>

4CA70941294C6E8C0C00000108742C000079A3A132C79E4946B63C6C608C157D36000
030

> FE466D0000/cid:995045216@04092008-1C60> tboogerd@...
>
> NOTICE: This email may contain confidential and proprietary

information

> of Rosenboom Machine & Tool, Inc. By opening any enclosed files,

the

> recipient agrees not to use, reproduce, disclose, or manufacture

its

> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
>
>
> Please consider the environment before printing this email.
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

system · September 18, 2008, 10:56am

No. There is no elegant way in Vantage I've found to do so that isn't more trouble than it's worth as, let's face, you really don't need much more than some recurring schedules in outlook with attachments listing the specific tools/gauges to calibrate.

If you are hell bent on doing it in Vantage - how are you tools gauges set up in vantage now? (Are they resources that actually get called in methods? Are they Parts?)

If they are resources, you could create scheduled jobs that are nothing more than a single OP calling the tool/guage resource(s) (an indicating that calibration is to be checked by a dispatchable QC resource) on whatever schedule frequency you wish. (We used to schedule preventitive maintenance on our legacy system this way.)

If they are Parts, you could make them lot or serial number controlled and leverage the Shelf Life Part.field to trigger review via a custom report or dashboard. (Basically a serial number or lot aged inventory report.)

We do something similar with elastomer seal inventory (and didn't need to go to lot or serial number control to do it... Just leveraged the Inventory transaction tables to determine receipt time and then - using an assumption that physically controlled FIFO inventory handling is reliable - perform a FIFO simulation to determine if inventory on-hand has exceeded its Shelf Life.

Personally, I'd do the Outlook thing myself unless you are already partially invested in setting it up in Vantage.

Rob Brown.

--- On Thu, 9/18/08, Toby Boogerd <tboogerd@...> wrote:

From: Toby Boogerd <tboogerd@...>
Subject: [Vantage] Gages & Calibrations
To: vantage@yahoogroups.com
Date: Thursday, September 18, 2008, 10:40 AM

Anyone out there handling the tracking of gages and calibrations in
Vantage?
If so, can you elaborate.

Toby Boogerd
Information Systems

<outbind://28- 000000008130E53E 77D25C4087FAED6E 6ADB51C90700F6EC 5687CDB544
4CA70941294C6E8C0C0 0000108742C00007 9A3A132C79E4946B 63C6C608C157D360 00030
FE466D0000/cid: 995045216@ 04092008- 1C59> 712.324.4854 |
<outbind://28- 000000008130E53E 77D25C4087FAED6E 6ADB51C90700F6EC 5687CDB544
4CA70941294C6E8C0C0 0000108742C00007 9A3A132C79E4946B 63C6C608C157D360 00030
FE466D0000/cid: 995045216@ 04092008- 1C60> tboogerd@rosenboom. com

NOTICE: This email may contain confidential and proprietary information
of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
recipient agrees not to use, reproduce, disclose, or manufacture its
contents, in whole or in part, without prior written consent of
Rosenboom Machine & Tool, Inc.

Please consider the environment before printing this email.

[Non-text portions of this message have been removed]