Codeunit 18091280 EOS028 CFG Excel

Codeunit 18091280 EOS028 CFG Excel

Methods

RunExcelFromPruductConfig

procedure RunExcelFromPruductConfig(ConfigCharac: Record "EOS028 CFG Config. Charac."; xConfigCharac: Record "EOS028 CFG Config. Charac.")

This procedure Run Excel from Product Configurator to validate characteristics with excel.

Parameters / Return Value

  • ConfigCharac Record "EOS028 CFG Config. Charac."

  • xConfigCharac Record "EOS028 CFG Config. Charac."

    “xConfigCharac” contains old configuration

CheckUseExcel

procedure CheckUseExcel(): Boolean

This procedure checks if to use Excel.

Parameters / Return Value

  • Returns Boolean

    If true will be used Excel. If false will not be used Excel

CheckUseSAASExcel

procedure CheckUseSAASExcel(): Boolean

This procedure checks if to use SAAS Excel.

Parameters / Return Value

  • Returns Boolean

    If true will be used SAAS Excel. If false will not be used SAAS Excel

RunExcelFromProductConfigurator

procedure RunExcelFromProductConfigurator(ConfiguratorLine: Record "EOS028 CFG Configurator Line")

This procedure downloads Excel preview file.

Parameters / Return Value

  • ConfiguratorLine Record "EOS028 CFG Configurator Line"

    “ConfiguratorLine” contains new configuration

RunExcelFromConfiguratorLinesOnClosePage

procedure RunExcelFromConfiguratorLinesOnClosePage(ConfiguratorLine: Record "EOS028 CFG Configurator Line")

This procedure runs Excel for calculate characteristics during closing of Product Configurator.

Parameters / Return Value

  • ConfiguratorLine Record "EOS028 CFG Configurator Line"

    “ConfiguratorLine” contains new configuration

RunExcelFromConfiguratorLinesOnOpenPage

procedure RunExcelFromConfiguratorLinesOnOpenPage(ConfiguratorLine: Record "EOS028 CFG Configurator Line")

This procedure uploads excel file for calculate characteristics. It is performed only for SAAS mode.

Parameters / Return Value

  • ConfiguratorLine Record "EOS028 CFG Configurator Line"

    “ConfiguratorLine” contains new configuration

ConvertTextToDecimal

procedure ConvertTextToDecimal(DecText: Text): Decimal

This procedure converts text do decimal to manage decimal and thousand separator.

Parameters / Return Value

  • DecText Text[]

    Text to convert

  • Returns Decimal

    Decimal convert

Events

GetResult

local procedure GetResult(Ins: InStream; var TempExcelBufResult: Record "Excel Buffer" temporary; var IsHandled: Boolean; SheetName: Text)

This procedure gets characteristics from a file Excel. It is from app EX028.02 “Product Configurator for Excel”.

Parameters / Return Value

  • Ins InStream

    “Ins” contains Excel file

  • TempExcelBufResult Record "Excel Buffer"

    “TempExcelBufResult” must be contains all characteristics read by Excel file

  • IsHandled Boolean

    if true the characteristics will be validated in Product Configurator. if false the characteristics will not be validated in Product Configurator

  • SheetName Text[]

    “SheetName” to read

OnBeforeCreateExcelFileName

local procedure OnBeforeCreateExcelFileName(var FileName: Text)

Raised before create excel file name for Sharepoint. Use it to modify the name.

Parameters / Return Value

  • FileName Text[]

EOS Labs -