For question #1, the steps to create a new translation can be found in the Navigation Configuration Guide located here:
Page 28 Translation Caches has the detail you need.
Foundation can be used without the F&C license. For example, you could create your own FlexSync handlers for trade specs and that would fall under the PDM bundle. Foundation is merely a framework. Just the FlexSync formulation solution pack falls under the F&C bundle since it allows you to perform a lot of design functions. There should be a notice that F&C is required in the FlexSync formulation guide, I'll check it out and make sure.
Let us know if you end up using foundation for other specs, we'd love to hear your use cases.
The process of adding fields to a report is detailed in the FlexSync Developer's guide. It breaks down to the following steps:
1) Add a named range to the report template Excel file where you'd like the data to be inserted. The
location of this file can be found on the report editor page in the FlexSyncConfig Windows app.
2) Create a report field definition for the new field using the report editor in FlexSyncConfig
3) Create and associate a handler chain with the new field definition that tells FlexSync how to generate the data.
Look at the Handler Chain for the Summary.SpecName field as an example when creating the chain for EffectiveDate. You'll probably
want to set the config params for the source handler to this:
and then use the DateFinalHandler to format the data as a date in the spreadsheet.
Each step is covered in greater detail in the FlexSync Developer's guide.
The VB code isn't really responsible for getting the data from the Specification into the generated report. The
FlexSync infrastructure code utilizes the report configuration, fields, and handlerchains defined in the FlexSyncConfig
App to pull the data from the spec when generating the report. You'll need to look at the handler chain definition
for a given report field to know how that data is being retrieved and formatted.
I have performed the Below steps to add a new field to report:
- Created a new field in the Excel sheet with the Name as Summary.EffectiveDate in the Name Manager.
- Edited the report in the FlexsyncConfig.exe to point to the modified Excel sheet.
- In the Field Section of the FlexsyncConfig.exe added a New Field Summary.EffectiveDate as a Shared String
- In the Handler Section of the FlexsyncConfig.exe created a New Handler EffDatehandleChain with the ClassBasedSourceSingleValueHandlerFactory as source Handler with Parameters as DataObject.Summary.EffectiveDate and DatefinalHandlerSingleValueHandlerFactory as the Final Handler.
- After Committing the changes i am able to see the new field created in the flexReporFields Table and the Handler Created which is visible in the flexReportHandlerChains and the FlexReportFieldHandlers Table.
- I am unable to find a Relationship between the field EffectiveDate and the Handler in flexRptFldHandlerChainJoin table.
What steps need to be followed in order to relate the new field created to the new handler created?
Using FlexSyncConfig's Report Editor, in the Fields table, if you mouse click the Fields column of an individual row,
the Handler Chains section updates to show the handler chain associated with that Field. You can then use the
Handler Chain dropdown to select which chain to associate with the field.
Thanks Christopher. I was able to get the field into the report.
I have Another issue i am facing for an attribute:
1. For the Reference output material of the spec the formulation spec we need to get the value for the Density (both the mass and volume) along with UOM for each.
Currently the BOMOutputs.Density.MassEntered Quantity is fetched using the ClassBAsedSourceMultiValueHandlerFactory with the parameter as GetOutputMass.
This fetches the value and displays the scaled value as per the quantity of the output material.
Is there a way to fetch both the volume and the mass Values defined in the design attributes section of the summary tab of the reference output material specification.?
2. Also is it possible to add an entire custom section from the reference output material specification? will this have any performance issues on the report?
3How do we increase the time out in such cases?
1) To grab the two values for inclusion in a single cell, or to calculate the density and include that in a single cell, you'd need to write a custom source handler.
2) You can use the SpecHostedCSHandler source handler which is provided as part of the default FlexSync install. Here are the details:
The SpecHostedCSHandler is a source handler that provides custom section data directly associated with a specification. The SpecHostedCSHandler returns a single column from the specified Custom Section as a collection of IExtendedAttributeBaseDOs that can be passed to the EAFinalHandler for formatting within the Excel spreadsheet. This handler takes the Custom Section ID and Column ID as configuration parameters. The header column of the custom section can be specified in the configuration parameters using the id ‘Header’.
As far as performance goes, it would depend on the size and complexity of the custom section.
3) If you need to change the default setting for request timeout, do so in the web.config file under <httpRuntime>:
<httpRuntime executionTimeout = "number(in seconds)"/>