V8 - Engr Workbench - Using User Defined Fields

Yahoo Archive
1
Much thanks to all of you!
We had mapped the target table PartMtl to Source Table EcoMtl, but to
re-use the data in the custom fields within the Engineering Workbench,
we also had to map the Target Table as EcoMtl and the Source Table as
PartMtl. - (a double mapping).

Thanks again - you saved us the wait for a "bug" write-up - answering a
question that Tec h Support could not.

Pam
Metro Machine

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jonnyfatman666
Sent: Tuesday, January 30, 2007 5:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: V8 - Engr Workbench - Using User Defined Fields




This stumped me too!
Here is what we did.

Under 'System Maintenance', 'Utilities', 'Custom Field Map'
Select the appropriate tables (ensure you are clear on the difference
between source and target).
In our case we looked at Target Table - PartMtl, Source Table - EcoMtl
and matched up Character01 on each.
This links up the Character01 UDF between the tables. You must also do
this to the JobMtl table if you want it to be called in properly to
jobs.

Jonny

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Stephen Edginton" <stephene@...> wrote:
>
> Also look into field map maintenance (system management -> utilities)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Mark Wonsil
> Sent: 30 January 2007 03:10
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] V8 - Engr Workbench - Using User Defined Fields
>
>
>
> Hi Pam,
> > Anyone tried to use a user defined field in the ECOMtl table -
writing
> > it to the PartMtl Table so it is available for reports?
> >
> > We got this to work, however, when you pull this same parent part
back
> > into the Engineering Workbench the user defined fields are blank.
> >
> > Where does the Engineering workbench get the info to pull into the
> form
> > - another 3rd table? Or do user defined field automatically get
> cleared?
>
> I assume that you bound the fields to the user defined records in
> ECOMTL. I
> have found that you must exit Developer Mode (SAVE FIRST!!!) and then
> try your
> customization. The binding doesn't seem to work while I'm in Developer
> Mode,
> at least until I exit the command and restart it. All user-defined
> records are
> contained in the records themselves and not in a different table.
>
> Mark W.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
2
Anyone tried to use a user defined field in the ECOMtl table - writing
it to the PartMtl Table so it is available for reports?

We got this to work, however, when you pull this same parent part back
into the Engineering Workbench the user defined fields are blank.

Where does the Engineering workbench get the info to pull into the form
- another 3rd table? Or do user defined field automatically get cleared?

Thanks for any help you can give us.

Metro Machine


[Non-text portions of this message have been removed]
3
Hi Pam,
> Anyone tried to use a user defined field in the ECOMtl table - writing
> it to the PartMtl Table so it is available for reports?
>
> We got this to work, however, when you pull this same parent part back
> into the Engineering Workbench the user defined fields are blank.
>
> Where does the Engineering workbench get the info to pull into the form
> - another 3rd table? Or do user defined field automatically get cleared?

I assume that you bound the fields to the user defined records in ECOMTL. I
have found that you must exit Developer Mode (SAVE FIRST!!!) and then try your
customization. The binding doesn't seem to work while I'm in Developer Mode,
at least until I exit the command and restart it. All user-defined records are
contained in the records themselves and not in a different table.

Mark W.
4
Also look into field map maintenance (system management -> utilities)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: 30 January 2007 03:10
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V8 - Engr Workbench - Using User Defined Fields



Hi Pam,
> Anyone tried to use a user defined field in the ECOMtl table - writing
> it to the PartMtl Table so it is available for reports?
>
> We got this to work, however, when you pull this same parent part back
> into the Engineering Workbench the user defined fields are blank.
>
> Where does the Engineering workbench get the info to pull into the
form
> - another 3rd table? Or do user defined field automatically get
cleared?

I assume that you bound the fields to the user defined records in
ECOMTL. I
have found that you must exit Developer Mode (SAVE FIRST!!!) and then
try your
customization. The binding doesn't seem to work while I'm in Developer
Mode,
at least until I exit the command and restart it. All user-defined
records are
contained in the records themselves and not in a different table.

Mark W.





[Non-text portions of this message have been removed]
5
This stumped me too!
Here is what we did.

Under 'System Maintenance', 'Utilities', 'Custom Field Map'
Select the appropriate tables (ensure you are clear on the difference
between source and target).
In our case we looked at Target Table - PartMtl, Source Table - EcoMtl
and matched up Character01 on each.
This links up the Character01 UDF between the tables. You must also do
this to the JobMtl table if you want it to be called in properly to
jobs.

Jonny


--- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@...> wrote:
>
> Also look into field map maintenance (system management -> utilities)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Mark Wonsil
> Sent: 30 January 2007 03:10
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] V8 - Engr Workbench - Using User Defined Fields
>
>
>
> Hi Pam,
> > Anyone tried to use a user defined field in the ECOMtl table -
writing
> > it to the PartMtl Table so it is available for reports?
> >
> > We got this to work, however, when you pull this same parent part
back
> > into the Engineering Workbench the user defined fields are blank.
> >
> > Where does the Engineering workbench get the info to pull into the
> form
> > - another 3rd table? Or do user defined field automatically get
> cleared?
>
> I assume that you bound the fields to the user defined records in
> ECOMTL. I
> have found that you must exit Developer Mode (SAVE FIRST!!!) and then
> try your
> customization. The binding doesn't seem to work while I'm in Developer
> Mode,
> at least until I exit the command and restart it. All user-defined
> records are
> contained in the records themselves and not in a different table.
>
> Mark W.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>