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.



Custom table on new Tab in WOs Maximo 7.1.1.6

From: peter.hacking (2011-09-21 00:21)

Hi all,
I am trying to get custom tables to be usable on a new tab in Work Order tracking. I created a new Tab and copied the code from the Specifications table into my app .xml file. I then edited the code to suit the new tables but I just get Invalid Binding errors.
Could anyone help me with this problem? I have inserted my xml code below, just the new Tab part. I must be missing something because I can't see what is wrong with it.
Any help greatly appreciated.
Thanks in advance Peter
</tab>
- <tab id="budgetinfo" label="Budget Info">
- <section border="true" id="budgetinfo_grid2_sec">
- <sectionrow id="budgetinfo_grid2_row1">
- <sectioncol id="budgetinfo_grid2_row1_col1">
- <section id="budgetinfo_grid2_row1_col1_1">
<multiparttextbox dataattribute="WONUM" descdataattribute="DESCRIPTION" id="budgetinfo_grid2_row1_1_1" menutype="workorder" />
</section>
</sectioncol>
- <sectioncol id="budgetinfo_grid2_row1_col2">
- <section id="budgetinfo_grid2_row1_col2_1">
<textbox dataattribute="siteid" id="budgetinfo_grid2_row1_col2_1_1" />
</section>
</sectioncol>
- <sectioncol id="budgetinfo_grid2_row1_col3">
- <section id="budgetinfo_grid2_row1_col3_1">
<textbox dataattribute="status" id="budgetinfo_grid2_row1_col3_1_1" />
</section>
</sectioncol>
</sectionrow>
</section>
- <table id="budgetinfo_prjfunding" label="Project Funding" relationship="WO_PRJFUND_WONUM">
<datasrc id="1313383923460" mboname="prjfunding" relationship="WO_PRJFUND_WONUM" />
- <tablebody displayrowsperpage="10" filterable="true" id="budgetinfo_prjfunding_tablebody">
<tablecol filterable="false" id="budgetinfo_prjfunding_tablebody_1" mxevent="toggledetailstate" mxevent_desc="Show Detail" sortable="false" type="event" />
<tablecol dataattribute="description" id="budgetinfo_prjfunding_tablebody_3" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_2" showfilterfield="true" sortable="false" />
<tablecol dataattribute="amount" id="budgetinfo_prjfunding_tablebody_4" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_4" showfilterfield="true" sortable="false" />
<tablecol dataattribute="businessunit" id="budgetinfo_prjfunding_tablebody_5" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_5" showfilterfield="true" sortable="true" />
<tablecol dataattribute="grantno" id="budgetinfo_prjfunding_tablebody_6" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_6" showfilterfield="true" sortable="true" />
<tablecol dataattribute="approved" id="budgetinfo_prjfunding_tablebody_7" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_7" showfilterfield="true" sortable="true" />
<tablecol dataattribute="approvedate" id="budgetinfo_prjfunding_tablebody_8" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_8" showfilterfield="true" sortable="true" />
<tablecol filterable="false" id="budgetinfo_prjfunding_tablebody_9" mxevent="toggledeleterow" mxevent_desc="Mark Row for Delete" mxevent_icon="btn_garbage.gif" sortable="false" type="event" />
</tablebody>
- <tabledetails id="budgetinfo_prjfunding_1">
- <section id="budgetinfo_prjfunding_1_griddetails" label="Details">
- <sectionrow id="budgetinfo_prjfunding_table_1_griddetails1_row">
- <sectioncol id="budgetinfo_prjfunding_table_1_griddetails1_row_col1">
- <section id="budgetinfo_prjfunding_table_1_griddetails1_row_col1_sec">
<textbox dataattribute="DESCRIPTION" id="budgetinfo_prjfunding_1_griddetails_2" lookup="LONGESC" />
</section>
</sectioncol>
- <sectioncol id="budgetinfo_prjfunding_table_1_griddetails1_row_col2">
- <section id="budgetinfo_prjfunding_table_1_griddetails1_row_col2_sec">
<textbox dataattribute="amount" id="budgetinfo_prjfunding_1_griddetails_4" smartfilloff="true" />
<textbox dataattribute="businessunit" id="budgetinfo_prjfunding_1_griddetails_5" smartfilloff="true" />
<textbox dataattribute="grantno" id="budgetinfo_prjfunding_1_griddetails_6" />
<textbox dataattribute="approved" id="budgetinfo_prjfunding_1_griddetails_7" />
<textbox dataattribute="approvedate" id="budgetinfo_prjfunding_1_griddetails_8" />
</section>
</sectioncol>
</sectionrow>
</section>
</tabledetails>
- <buttongroup id="budgetinfo_prjfunding_2">
<pushbutton default="true" id="budgetinfo_prjfunding_2_1" label="New Row" mxevent="addrow" />
</buttongroup>
</table>
- <table id="budgetinfo_budest" label="Budget Estimate" orderby="displaysequence" relationship="WO_PRJBUDEST_WONUM">
- <tablebody displayrowsperpage="10" filterable="true" id="budgetinfo_budest_tablebody">
<tablecol filterable="false" id="budgetinfo_budest_tablebody_1" mxevent="toggledetailstate" mxevent_desc="Show Detail" sortable="false" type="event" />
<tablecol dataattribute="description" id="budgetinfo_budest_tablebody_3" linkedcontrolid="budgetinfo_budest_1_griddetails_2" showfilterfield="true" sortable="false" />
<tablecol dataattribute="amount" id="budgetinfo_budest_tablebody_4" linkedcontrolid="budgetinfo_budest_1_griddetails_3" showfilterfield="true" sortable="false" />
<tablecol dataattribute="etcode" id="budgetinfo_budest_tablebody_5" linkedcontrolid="budgetinfo_budest_1_griddetails_4" />
<tablecol dataattribute="budestdate" id="budgetinfo_budest_tablebody_6" linkedcontrolid="budgetinfo_budest_1_griddetails_5" />
<tablecol filterable="false" id="budgetinfo_budest_tablebody_9" mxevent="toggledeleterow" mxevent_desc="Mark Row for Delete" mxevent_icon="btn_garbage.gif" sortable="false" type="event" />
</tablebody>
- <tabledetails id="budgetinfo_budest_1">
- <section id="budgetinfo_budest_1_griddetails" label="Details">
- <sectionrow id="budgetinfo_budest_table_1_griddetails1_row">
- <sectioncol id="budgetinfo_budest_table_1_griddetails1_row_col1">
- <section id="budgetinfo_budest_table_1_griddetails1_row_col1_sec">
<textbox dataattribute="DESCRIPTION" id="budgetinfo_budest_1_griddetails_2" lookup="LONGDESC" />
</section>
</sectioncol>
- <sectioncol id="budgetinfo_budest_table_1_griddetails1_row_col2">
- <section id="budgetinfo_budest_table_1_griddetails1_row_col2_sec">
<textbox dataattribute="amount" id="budgetinfo_budest_1_griddetails_3" smartfilloff="true" />
<textbox dataattribute="etcode" id="budgetinfo_budest_1_griddetails_4" smartfilloff="true" />
<textbox dataattribute="budestdate" id="budgetinfo_budest_1_griddetails_5" />
</section>
</sectioncol>
</sectionrow>
</section>
</tabledetails>
- <buttongroup id="budgetinfo_budest_2">
<pushbutton default="true" id="budgetinfo_budest_2_1" label="New Row" mxevent="addrow" />
</buttongroup>
</table>
</tab>


From: planschd (2011-09-21 00:38)

Hello Peter,
I am not able to address the invalid binding issues ... but
I noticed you are interested in Budget Tracking.
Maximo 7X has this capability and is found under Cost Management.
I imagine this (too) can be moved to WOTRACK.
The benefits of Maximo "cost management" are:
�� The primary keys are linked to the WONUM
�� Outage/building shutdown tracking scope and cost (budgets, commitments, invoices, ETC)
�� Major maintenance (or Project Scheduling)
�� O&M departmental budgeting
�� Plus, you are able to make a multi-level work breakdown structure
�� And (auto) track scope changes
�� And extract Project Cost Tracking report

w/br
John Reeve
Manager, Practice Leader Maintenance and Reliability Solutions
Cohesive Information Solutions Inc
Cell: 423 314 1312
Sent on the Sprint� Now Network from my BlackBerry�

-----Original Message-----
From: "peter.hacking" <peter.hacking@uwa.edu.au>
Sender: MAXIMO@yahoogroups.com
Date: Wed, 21 Sep 2011 00:21:46
To: <MAXIMO@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Custom table on new Tab in WOs Maximo 7.1.1.6

Hi all,
I am trying to get custom tables to be usable on a new tab in Work Order tracking. I created a new Tab and copied the code from the Specifications table into my app .xml file. I then edited the code to suit the new tables but I just get Invalid Binding errors.
Could anyone help me with this problem? I have inserted my xml code below, just the new Tab part. I must be missing something because I can't see what is wrong with it.
Any help greatly appreciated.

Thanks in advance Peter


</tab>
- <tab id="budgetinfo" label="Budget Info">
- <section border="true" id="budgetinfo_grid2_sec">
- <sectionrow id="budgetinfo_grid2_row1">
- <sectioncol id="budgetinfo_grid2_row1_col1">
- <section id="budgetinfo_grid2_row1_col1_1">
<multiparttextbox dataattribute="WONUM" descdataattribute="DESCRIPTION" id="budgetinfo_grid2_row1_1_1" menutype="workorder" />
</section>
</sectioncol>
- <sectioncol id="budgetinfo_grid2_row1_col2">
- <section id="budgetinfo_grid2_row1_col2_1">
<textbox dataattribute="siteid" id="budgetinfo_grid2_row1_col2_1_1" />
</section>
</sectioncol>
- <sectioncol id="budgetinfo_grid2_row1_col3">
- <section id="budgetinfo_grid2_row1_col3_1">
<textbox dataattribute="status" id="budgetinfo_grid2_row1_col3_1_1" />
</section>
</sectioncol>
</sectionrow>
</section>
- <table id="budgetinfo_prjfunding" label="Project Funding" relationship="WO_PRJFUND_WONUM">
<datasrc id="1313383923460" mboname="prjfunding" relationship="WO_PRJFUND_WONUM" />
- <tablebody displayrowsperpage="10" filterable="true" id="budgetinfo_prjfunding_tablebody">
<tablecol filterable="false" id="budgetinfo_prjfunding_tablebody_1" mxevent="toggledetailstate" mxevent_desc="Show Detail" sortable="false" type="event" />
<tablecol dataattribute="description" id="budgetinfo_prjfunding_tablebody_3" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_2" showfilterfield="true" sortable="false" />
<tablecol dataattribute="amount" id="budgetinfo_prjfunding_tablebody_4" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_4" showfilterfield="true" sortable="false" />
<tablecol dataattribute="businessunit" id="budgetinfo_prjfunding_tablebody_5" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_5" showfilterfield="true" sortable="true" />
<tablecol dataattribute="grantno" id="budgetinfo_prjfunding_tablebody_6" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_6" showfilterfield="true" sortable="true" />
<tablecol dataattribute="approved" id="budgetinfo_prjfunding_tablebody_7" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_7" showfilterfield="true" sortable="true" />
<tablecol dataattribute="approvedate" id="budgetinfo_prjfunding_tablebody_8" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_8" showfilterfield="true" sortable="true" />
<tablecol filterable="false" id="budgetinfo_prjfunding_tablebody_9" mxevent="toggledeleterow" mxevent_desc="Mark Row for Delete" mxevent_icon="btn_garbage.gif" sortable="false" type="event" />
</tablebody>
- <tabledetails id="budgetinfo_prjfunding_1">
- <section id="budgetinfo_prjfunding_1_griddetails" label="Details">
- <sectionrow id="budgetinfo_prjfunding_table_1_griddetails1_row">
- <sectioncol id="budgetinfo_prjfunding_table_1_griddetails1_row_col1">
- <section id="budgetinfo_prjfunding_table_1_griddetails1_row_col1_sec">
<textbox dataattribute="DESCRIPTION" id="budgetinfo_prjfunding_1_griddetails_2" lookup="LONGESC" />
</section>
</sectioncol>
- <sectioncol id="budgetinfo_prjfunding_table_1_griddetails1_row_col2">
- <section id="budgetinfo_prjfunding_table_1_griddetails1_row_col2_sec">
<textbox dataattribute="amount" id="budgetinfo_prjfunding_1_griddetails_4" smartfilloff="true" />
<textbox dataattribute="businessunit" id="budgetinfo_prjfunding_1_griddetails_5" smartfilloff="true" />
<textbox dataattribute="grantno" id="budgetinfo_prjfunding_1_griddetails_6" />
<textbox dataattribute="approved" id="budgetinfo_prjfunding_1_griddetails_7" />
<textbox dataattribute="approvedate" id="budgetinfo_prjfunding_1_griddetails_8" />
</section>
</sectioncol>
</sectionrow>
</section>
</tabledetails>
- <buttongroup id="budgetinfo_prjfunding_2">
<pushbutton default="true" id="budgetinfo_prjfunding_2_1" label="New Row" mxevent="addrow" />
</buttongroup>
</table>
- <table id="budgetinfo_budest" label="Budget Estimate" orderby="displaysequence" relationship="WO_PRJBUDEST_WONUM">
- <tablebody displayrowsperpage="10" filterable="true" id="budgetinfo_budest_tablebody">
<tablecol filterable="false" id="budgetinfo_budest_tablebody_1" mxevent="toggledetailstate" mxevent_desc="Show Detail" sortable="false" type="event" />
<tablecol dataattribute="description" id="budgetinfo_budest_tablebody_3" linkedcontrolid="budgetinfo_budest_1_griddetails_2" showfilterfield="true" sortable="false" />
<tablecol dataattribute="amount" id="budgetinfo_budest_tablebody_4" linkedcontrolid="budgetinfo_budest_1_griddetails_3" showfilterfield="true" sortable="false" />
<tablecol dataattribute="etcode" id="budgetinfo_budest_tablebody_5" linkedcontrolid="budgetinfo_budest_1_griddetails_4" />
<tablecol dataattribute="budestdate" id="budgetinfo_budest_tablebody_6" linkedcontrolid="budgetinfo_budest_1_griddetails_5" />
<tablecol filterable="false" id="budgetinfo_budest_tablebody_9" mxevent="toggledeleterow" mxevent_desc="Mark Row for Delete" mxevent_icon="btn_garbage.gif" sortable="false" type="event" />
</tablebody>
- <tabledetails id="budgetinfo_budest_1">
- <section id="budgetinfo_budest_1_griddetails" label="Details">
- <sectionrow id="budgetinfo_budest_table_1_griddetails1_row">
- <sectioncol id="budgetinfo_budest_table_1_griddetails1_row_col1">
- <section id="budgetinfo_budest_table_1_griddetails1_row_col1_sec">
<textbox dataattribute="DESCRIPTION" id="budgetinfo_budest_1_griddetails_2" lookup="LONGDESC" />
</section>
</sectioncol>
- <sectioncol id="budgetinfo_budest_table_1_griddetails1_row_col2">
- <section id="budgetinfo_budest_table_1_griddetails1_row_col2_sec">
<textbox dataattribute="amount" id="budgetinfo_budest_1_griddetails_3" smartfilloff="true" />
<textbox dataattribute="etcode" id="budgetinfo_budest_1_griddetails_4" smartfilloff="true" />
<textbox dataattribute="budestdate" id="budgetinfo_budest_1_griddetails_5" />
</section>
</sectioncol>
</sectionrow>
</section>
</tabledetails>
- <buttongroup id="budgetinfo_budest_2">
<pushbutton default="true" id="budgetinfo_budest_2_1" label="New Row" mxevent="addrow" />
</buttongroup>
</table>
</tab>




From: al_potanin (2011-09-21 04:48)

Hi,
Have you created relationship from WO to new table?
You also have to create maxlookupmap record
And usually it starts working after Maximo restart :)
--- In MAXIMO@yahoogroups.com, "peter.hacking" <peter.hacking@...> wrote:
>
> Hi all,
> I am trying to get custom tables to be usable on a new tab in Work Order tracking. I created a new Tab and copied the code from the Specifications table into my app .xml file. I then edited the code to suit the new tables but I just get Invalid Binding errors.
> Could anyone help me with this problem? I have inserted my xml code below, just the new Tab part. I must be missing something because I can't see what is wrong with it.
> Any help greatly appreciated.
>
> Thanks in advance Peter
>
>
> </tab>
> - <tab id="budgetinfo" label="Budget Info">
> - <section border="true" id="budgetinfo_grid2_sec">
> - <sectionrow id="budgetinfo_grid2_row1">
> - <sectioncol id="budgetinfo_grid2_row1_col1">
> - <section id="budgetinfo_grid2_row1_col1_1">
> <multiparttextbox dataattribute="WONUM" descdataattribute="DESCRIPTION" id="budgetinfo_grid2_row1_1_1" menutype="workorder" />
> </section>
> </sectioncol>
> - <sectioncol id="budgetinfo_grid2_row1_col2">
> - <section id="budgetinfo_grid2_row1_col2_1">
> <textbox dataattribute="siteid" id="budgetinfo_grid2_row1_col2_1_1" />
> </section>
> </sectioncol>
> - <sectioncol id="budgetinfo_grid2_row1_col3">
> - <section id="budgetinfo_grid2_row1_col3_1">
> <textbox dataattribute="status" id="budgetinfo_grid2_row1_col3_1_1" />
> </section>
> </sectioncol>
> </sectionrow>
> </section>
> - <table id="budgetinfo_prjfunding" label="Project Funding" relationship="WO_PRJFUND_WONUM">
> <datasrc id="1313383923460" mboname="prjfunding" relationship="WO_PRJFUND_WONUM" />
> - <tablebody displayrowsperpage="10" filterable="true" id="budgetinfo_prjfunding_tablebody">
> <tablecol filterable="false" id="budgetinfo_prjfunding_tablebody_1" mxevent="toggledetailstate" mxevent_desc="Show Detail" sortable="false" type="event" />
> <tablecol dataattribute="description" id="budgetinfo_prjfunding_tablebody_3" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_2" showfilterfield="true" sortable="false" />
> <tablecol dataattribute="amount" id="budgetinfo_prjfunding_tablebody_4" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_4" showfilterfield="true" sortable="false" />
> <tablecol dataattribute="businessunit" id="budgetinfo_prjfunding_tablebody_5" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_5" showfilterfield="true" sortable="true" />
> <tablecol dataattribute="grantno" id="budgetinfo_prjfunding_tablebody_6" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_6" showfilterfield="true" sortable="true" />
> <tablecol dataattribute="approved" id="budgetinfo_prjfunding_tablebody_7" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_7" showfilterfield="true" sortable="true" />
> <tablecol dataattribute="approvedate" id="budgetinfo_prjfunding_tablebody_8" linkedcontrolid="budgetinfo_prjfunding_1_griddetails_8" showfilterfield="true" sortable="true" />
> <tablecol filterable="false" id="budgetinfo_prjfunding_tablebody_9" mxevent="toggledeleterow" mxevent_desc="Mark Row for Delete" mxevent_icon="btn_garbage.gif" sortable="false" type="event" />
> </tablebody>
> - <tabledetails id="budgetinfo_prjfunding_1">
> - <section id="budgetinfo_prjfunding_1_griddetails" label="Details">
> - <sectionrow id="budgetinfo_prjfunding_table_1_griddetails1_row">
> - <sectioncol id="budgetinfo_prjfunding_table_1_griddetails1_row_col1">
> - <section id="budgetinfo_prjfunding_table_1_griddetails1_row_col1_sec">
> <textbox dataattribute="DESCRIPTION" id="budgetinfo_prjfunding_1_griddetails_2" lookup="LONGESC" />
> </section>
> </sectioncol>
> - <sectioncol id="budgetinfo_prjfunding_table_1_griddetails1_row_col2">
> - <section id="budgetinfo_prjfunding_table_1_griddetails1_row_col2_sec">
> <textbox dataattribute="amount" id="budgetinfo_prjfunding_1_griddetails_4" smartfilloff="true" />
> <textbox dataattribute="businessunit" id="budgetinfo_prjfunding_1_griddetails_5" smartfilloff="true" />
> <textbox dataattribute="grantno" id="budgetinfo_prjfunding_1_griddetails_6" />
> <textbox dataattribute="approved" id="budgetinfo_prjfunding_1_griddetails_7" />
> <textbox dataattribute="approvedate" id="budgetinfo_prjfunding_1_griddetails_8" />
> </section>
> </sectioncol>
> </sectionrow>
> </section>
> </tabledetails>
> - <buttongroup id="budgetinfo_prjfunding_2">
> <pushbutton default="true" id="budgetinfo_prjfunding_2_1" label="New Row" mxevent="addrow" />
> </buttongroup>
> </table>
> - <table id="budgetinfo_budest" label="Budget Estimate" orderby="displaysequence" relationship="WO_PRJBUDEST_WONUM">
> - <tablebody displayrowsperpage="10" filterable="true" id="budgetinfo_budest_tablebody">
> <tablecol filterable="false" id="budgetinfo_budest_tablebody_1" mxevent="toggledetailstate" mxevent_desc="Show Detail" sortable="false" type="event" />
> <tablecol dataattribute="description" id="budgetinfo_budest_tablebody_3" linkedcontrolid="budgetinfo_budest_1_griddetails_2" showfilterfield="true" sortable="false" />
> <tablecol dataattribute="amount" id="budgetinfo_budest_tablebody_4" linkedcontrolid="budgetinfo_budest_1_griddetails_3" showfilterfield="true" sortable="false" />
> <tablecol dataattribute="etcode" id="budgetinfo_budest_tablebody_5" linkedcontrolid="budgetinfo_budest_1_griddetails_4" />
> <tablecol dataattribute="budestdate" id="budgetinfo_budest_tablebody_6" linkedcontrolid="budgetinfo_budest_1_griddetails_5" />
> <tablecol filterable="false" id="budgetinfo_budest_tablebody_9" mxevent="toggledeleterow" mxevent_desc="Mark Row for Delete" mxevent_icon="btn_garbage.gif" sortable="false" type="event" />
> </tablebody>
> - <tabledetails id="budgetinfo_budest_1">
> - <section id="budgetinfo_budest_1_griddetails" label="Details">
> - <sectionrow id="budgetinfo_budest_table_1_griddetails1_row">
> - <sectioncol id="budgetinfo_budest_table_1_griddetails1_row_col1">
> - <section id="budgetinfo_budest_table_1_griddetails1_row_col1_sec">
> <textbox dataattribute="DESCRIPTION" id="budgetinfo_budest_1_griddetails_2" lookup="LONGDESC" />
> </section>
> </sectioncol>
> - <sectioncol id="budgetinfo_budest_table_1_griddetails1_row_col2">
> - <section id="budgetinfo_budest_table_1_griddetails1_row_col2_sec">
> <textbox dataattribute="amount" id="budgetinfo_budest_1_griddetails_3" smartfilloff="true" />
> <textbox dataattribute="etcode" id="budgetinfo_budest_1_griddetails_4" smartfilloff="true" />
> <textbox dataattribute="budestdate" id="budgetinfo_budest_1_griddetails_5" />
> </section>
> </sectioncol>
> </sectionrow>
> </section>
> </tabledetails>
> - <buttongroup id="budgetinfo_budest_2">
> <pushbutton default="true" id="budgetinfo_budest_2_1" label="New Row" mxevent="addrow" />
> </buttongroup>
> </table>
> </tab>
>