E10 Configurator

Yahoo Archive
1

Either the On Save does not like server side Code, in which case you can put it into a UD Method and call the method.  See if that helps.

 

Otherwise, the UD table may not have all of the “mandatory” fields in it.  I thought there were like 5 keys, in which case you just need include those fields and set them to empty strings.

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 22, 2016 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 Configurator

 

 

I'm trying to write code on the On Save.

Below is the code I am trying to use. It seems it gets angry with the Ice.Tables.UD08

 

using (var txScope = IceContext.CreateDefaultTransactionScope())

Ice.Tables.UD08 UD08;

if (UD08 == null)

{

UD08 = newRow Ice.Tables.UD08();

 Db.UD08.Insert(newRow);

 newRow.Company = Context.CompanyID;

 newRow.Key1 = Context.OrderNumber;

 newRow.Key2 = Inputs.Engine.Label;

 newRow.Character01 = Inputs.Engine.Value;

 Db.Validate();

 txScope.Complete();

}

 

 

 

 

2

Did any of you see the E10 Configurator WebEx from Epicor's product manager, Charlie Muellner? I'm genuinely excited to update my configurators.

 

3
Is the WebEx available online?

Thanks!

Mark W.
4
https://epicor.webex.com/epicor/lsr.php?RCID=a0b95e7b9b414313b26126e1891434f9

Thoughts?
5

I am currently testing in E10 and I have run into an issue with the configurator.

I have reports, dashboards and queries that access the PcInValue table.

I have found out in E10 that table does not get updated when you enter a new configured order.

Instead it updates a table called PcValueSet and the 2 columns that contain the data are FieldValues and FieldProperties. These 2 columns store the data as XML. Does anyone know how I can use data from these 2 fields in Reports, Dashboards a Queries? Some of my dashboards just filter data on 1 Input name or 1 Input value.


Thanks in advance

6

The only way to get to this data is via C#/SQL code.  I do use it in some places.  For those fields I must have out of the configurator and can’t run code, I make UD fields and pass the data on save from the configurator itself.

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 21, 2016 9:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 Configurator

 

 

I am currently testing in E10 and I have run into an issue with the configurator.

I have reports, dashboards and queries that access the PcInValue table.

I have found out in E10 that table does not get updated when you enter a new configured order.

Instead it updates a table called PcValueSet and the 2 columns that contain the data are FieldValues and FieldProperties. These 2 columns store the data as XML. Does anyone know how I can use data from these 2 fields in Reports, Dashboards a Queries? Some of my dashboards just filter data on 1 Input name or 1 Input value.

 

Thanks in advance

7

Actually there is another way - in 10.1 there is a View called ERP.PcInputValue that will allow you to dynamically parse the XML in the table as seen here in this abridged version of the view. If you select from this view using the right where filter, it may work for your needs.


ALTER view [Erp].[PcInputValue] as

SELECT Erp.PcValueHead.Company,

       Erp.PcValueHead.GroupSeq,

       .

       .

       FldValues.value('local-name(.)', 'nvarchar(50)') AS InputName,

       FldValues.value('.', 'nvarchar(50)') AS InputValue,

       FldValues.value('(@Type)[1]', 'nvarchar(50)') AS DataType,

       Erp.PcValueSet.SysRowID,

       Erp.PcValueSet.SysRevID

FROM Erp.PcValueSet Cross apply FieldValues.nodes('*') as FieldValues(FldValues)

INNER JOIN Erp.PcValueHead ON Erp.PcValueSet.Company = Erp.PcValueHead.Company

   AND Erp.PcValueSet.GroupSeq = Erp.PcValueHead.GroupSeq

   AND Erp.PcValueSet.HeadNum = Erp.PcValueHead.HeadNum

INNER JOIN Erp.PcValueGrp ON Erp.PcValueSet.Company = Erp.PcValueGrp.Company

   AND Erp.PcValueSet.GroupSeq = Erp.PcValueGrp.GroupSeq   

where FldValues.value('local-name(.)', 'nvarchar(50)') <> 'GroupSeq' and

  FldValues.value('local-name(.)', 'nvarchar(50)') <> 'HeadNum' and

  FldValues.value('local-name(.)', 'nvarchar(50)') <> 'PageSeq' and

  FldValues.value('local-name(.)', 'nvarchar(50)') <> 'ValueSetSeq' and

  FldValues.value('local-name(.)', 'nvarchar(50)') <> 'InputName'

GO




8
I'm trying to write code on the On Save.
Below is the code I am trying to use. It seems it gets angry with the Ice.Tables.UD08

using (var txScope = IceContext.CreateDefaultTransactionScope())
Ice.Tables.UD08 UD08;
if (UD08 == null)
{
UD08 = newRow Ice.Tables.UD08();
 Db.UD08.Insert(newRow);
 newRow.Company = Context.CompanyID;
 newRow.Key1 = Context.OrderNumber;
 newRow.Key2 = Inputs.Engine.Label;
 newRow.Character01 = Inputs.Engine.Value;
 Db.Validate();
 txScope.Complete();
}