Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Retrieve Asset Information in a Workorder from a Barcode

From: Hollie Alexander (2011-10-26 16:46)

Most of our assets have barcodes on them. The value of the barcode is stored in a field called ASSETTAG on the ASSET table. I would like the technician to be able to scan the asset tag in the workorder screen. They are able to pull up the asset if they click on the "Select Value" menu next to the assetnum. But I would like to eliminate that step, and scan it into the asset tag field directly from the workorder screen. Is this possible?


From: Travis Herron (2011-10-27 19:49)

Hollie,
You should be able to.
1) Go to Application Designer and open the WOTRACK design.
2) On the List tab of the design, add a new Table Column control
3) Open the Properties for the Table Column you just added
4) For the Attribute, enter ASSET.ASSETTAG
5) Save.
That should do it!
Travis Herron
--- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@...> wrote:
>
> Most of our assets have barcodes on them. The value of the barcode is stored in a field called ASSETTAG on the ASSET table. I would like the technician to be able to scan the asset tag in the workorder screen. They are able to pull up the asset if they click on the "Select Value" menu next to the assetnum. But I would like to eliminate that step, and scan it into the asset tag field directly from the workorder screen. Is this possible?
>


From: Hollie Alexander (2011-10-27 21:33)

Thank you for the response, Travis. I tried that, but when you put in the assettag it says "Object ASSET is read-only". It's trying to change the value of Assettag not look-up the asset by the assettag.
--- In MAXIMO@yahoogroups.com, "Travis Herron" <therron@...> wrote:
>
> Hollie,
>
> You should be able to.
>
> 1) Go to Application Designer and open the WOTRACK design.
> 2) On the List tab of the design, add a new Table Column control
> 3) Open the Properties for the Table Column you just added
> 4) For the Attribute, enter ASSET.ASSETTAG
> 5) Save.
>
> That should do it!
>
> Travis Herron
>
> --- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@> wrote:
> >
> > Most of our assets have barcodes on them. The value of the barcode is stored in a field called ASSETTAG on the ASSET table. I would like the technician to be able to scan the asset tag in the workorder screen. They are able to pull up the asset if they click on the "Select Value" menu next to the assetnum. But I would like to eliminate that step, and scan it into the asset tag field directly from the workorder screen. Is this possible?
> >
>


From: Travis Herron (2011-10-28 15:27)

Well, I just tried following my instructions in my test environment, and it works fine.
Did you create it through App Designer or editing the XML?
Did you add a Table Column control, or something else?
We are talking about searching on the List tab, aren't we? Now that I'm re-reading your question, it sounds like you are IN the work order (like, on the Work Order tab, the Plans tab, the Actuals tab, . . .anywhere BUT the List tab) and want to do a search. You can't do that; you have to use a lookup or hyperlink/Go To.
Check the properties on the Table Column control in App Designer. On mine, Filterable is checked, the Attribute is ASSET.ASSETTAG, and the Input Mode is READONLY.
--- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@...> wrote:
>
> Thank you for the response, Travis. I tried that, but when you put in the assettag it says "Object ASSET is read-only". It's trying to change the value of Assettag not look-up the asset by the assettag.
>
>
> --- In MAXIMO@yahoogroups.com, "Travis Herron" <therron@> wrote:
> >
> > Hollie,
> >
> > You should be able to.
> >
> > 1) Go to Application Designer and open the WOTRACK design.
> > 2) On the List tab of the design, add a new Table Column control
> > 3) Open the Properties for the Table Column you just added
> > 4) For the Attribute, enter ASSET.ASSETTAG
> > 5) Save.
> >
> > That should do it!
> >
> > Travis Herron
> >
> > --- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@> wrote:
> > >
> > > Most of our assets have barcodes on them. The value of the barcode is stored in a field called ASSETTAG on the ASSET table. I would like the technician to be able to scan the asset tag in the workorder screen. They are able to pull up the asset if they click on the "Select Value" menu next to the assetnum. But I would like to eliminate that step, and scan it into the asset tag field directly from the workorder screen. Is this possible?
> > >
> >
>


From: Hollie Alexander (2011-10-28 18:04)

Oh sorry for the confusion, no not the list tab. From the "Work Order" tab--when they actally open a work order. On that tab there is a "Asset" box. When you enter the asset number it pulls up that asset. I would like them to enter the Asset Tag instead of Assetnum to pull it into the workorder. I think I'd probably need to have an "Assettag" field on the workorder to accomplish this.
--- In MAXIMO@yahoogroups.com, "Travis Herron" <therron@...> wrote:
>
> Well, I just tried following my instructions in my test environment, and it works fine.
>
> Did you create it through App Designer or editing the XML?
>
> Did you add a Table Column control, or something else?
>
> We are talking about searching on the List tab, aren't we? Now that I'm re-reading your question, it sounds like you are IN the work order (like, on the Work Order tab, the Plans tab, the Actuals tab, . . .anywhere BUT the List tab) and want to do a search. You can't do that; you have to use a lookup or hyperlink/Go To.
>
> Check the properties on the Table Column control in App Designer. On mine, Filterable is checked, the Attribute is ASSET.ASSETTAG, and the Input Mode is READONLY.
>
> --- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@> wrote:
> >
> > Thank you for the response, Travis. I tried that, but when you put in the assettag it says "Object ASSET is read-only". It's trying to change the value of Assettag not look-up the asset by the assettag.
> >
> >
> > --- In MAXIMO@yahoogroups.com, "Travis Herron" <therron@> wrote:
> > >
> > > Hollie,
> > >
> > > You should be able to.
> > >
> > > 1) Go to Application Designer and open the WOTRACK design.
> > > 2) On the List tab of the design, add a new Table Column control
> > > 3) Open the Properties for the Table Column you just added
> > > 4) For the Attribute, enter ASSET.ASSETTAG
> > > 5) Save.
> > >
> > > That should do it!
> > >
> > > Travis Herron
> > >
> > > --- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@> wrote:
> > > >
> > > > Most of our assets have barcodes on them. The value of the barcode is stored in a field called ASSETTAG on the ASSET table. I would like the technician to be able to scan the asset tag in the workorder screen. They are able to pull up the asset if they click on the "Select Value" menu next to the assetnum. But I would like to eliminate that step, and scan it into the asset tag field directly from the workorder screen. Is this possible?
> > > >
> > >
> >
>


From: Travis Herron (2011-10-28 18:54)

Yep, you'd need to create a field WORKORDER.ASSETTAG and create a custom crossover, bound to WORKORDER.ASSETTAG, to pull the assetnum from ASSET to WORKORDER.
Travis Herron
--- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@...> wrote:
>
> Oh sorry for the confusion, no not the list tab. From the "Work Order" tab--when they actally open a work order. On that tab there is a "Asset" box. When you enter the asset number it pulls up that asset. I would like them to enter the Asset Tag instead of Assetnum to pull it into the workorder. I think I'd probably need to have an "Assettag" field on the workorder to accomplish this.
>
>
>
> --- In MAXIMO@yahoogroups.com, "Travis Herron" <therron@> wrote:
> >
> > Well, I just tried following my instructions in my test environment, and it works fine.
> >
> > Did you create it through App Designer or editing the XML?
> >
> > Did you add a Table Column control, or something else?
> >
> > We are talking about searching on the List tab, aren't we? Now that I'm re-reading your question, it sounds like you are IN the work order (like, on the Work Order tab, the Plans tab, the Actuals tab, . . .anywhere BUT the List tab) and want to do a search. You can't do that; you have to use a lookup or hyperlink/Go To.
> >
> > Check the properties on the Table Column control in App Designer. On mine, Filterable is checked, the Attribute is ASSET.ASSETTAG, and the Input Mode is READONLY.
> >
> > --- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@> wrote:
> > >
> > > Thank you for the response, Travis. I tried that, but when you put in the assettag it says "Object ASSET is read-only". It's trying to change the value of Assettag not look-up the asset by the assettag.
> > >
> > >
> > > --- In MAXIMO@yahoogroups.com, "Travis Herron" <therron@> wrote:
> > > >
> > > > Hollie,
> > > >
> > > > You should be able to.
> > > >
> > > > 1) Go to Application Designer and open the WOTRACK design.
> > > > 2) On the List tab of the design, add a new Table Column control
> > > > 3) Open the Properties for the Table Column you just added
> > > > 4) For the Attribute, enter ASSET.ASSETTAG
> > > > 5) Save.
> > > >
> > > > That should do it!
> > > >
> > > > Travis Herron
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "Hollie Alexander" <halexander@> wrote:
> > > > >
> > > > > Most of our assets have barcodes on them. The value of the barcode is stored in a field called ASSETTAG on the ASSET table. I would like the technician to be able to scan the asset tag in the workorder screen. They are able to pull up the asset if they click on the "Select Value" menu next to the assetnum. But I would like to eliminate that step, and scan it into the asset tag field directly from the workorder screen. Is this possible?
> > > > >
> > > >
> > >
> >
>