DWI Config fil (Avanceret)
- Generelt
- Eksempel på den nye struktur
- Sammenligning mellem gamle og nye elementer
Generelt:
Inden opgradering af DWI klient, anbefales det altid at man tager en backup af klientens konfigurationsfiler. Skulle man så opleve problemer, eller ikke kan gendanne sit tidligere setup, kan man via denne finde alle indstillinger der var lavet i den tidligere version.
Fra og med version 2.0.5 af DWI klienten, er der ændret på den XML struktur der benyttes til at gemme konfigurationen med. Et eksempel er vist herunder på den nye XML struktur, og derefter et skema der viser alle ændringer. Ud fra disse kan man så evt. genskabe sin tidligere konfigurationsfil til at virke med 2.0.5 klienten og nyere.
BEMÆRK: DanDomain anbefaler kun erfarne og øvede brugere at konvertere config filen. Dette supporteres ikke af DanDomain, og bør kun bruges som en sidste udvej.
Eksempel på den nye struktur:
Den nye struktur ser sådan ud:
<configuration>
<database>
<tablePrefix>min_</tablePrefix>
<maxItemsPerJob>250</maxItemsPerJob>
<decimalDelimiter>.</decimalDelimiter>
<connString>DWI01</connString>
<dateTimeFormat>dd-mm-yyyy hh:mi:ss</dateTimeFormat>
<booleanAsInteger>false</booleanAsInteger>
<mssqlEnabled>false</mssqlEnabled>
<mssqlConnString>server=;uid=;pwd=;database=</mssqlConnString>
<noneMSDBMS>
<enabled>false</enabled>
<delimiterIdentifierStart>[</delimiterIdentifierStart>
<delimiterIdentifierEnd>]</delimiterIdentifierEnd>
<selectIdentifier>TOP</selectIdentifier>
</noneMSDBMS>
<update autoDeleteNotUpdatedRows="false">
<table name="DWIProduct" checked="true">
<field name="VendorNumber" checked="true" />
<field name="ProductName" checked="true" />
<field name="ProductCategoryNumber" checked="true" />
<field name="ProdType" checked="true" />
<field name="CostPrice" checked="true" />
<field name="Weight" checked="true" />
<field name="PictureLink" checked="true" />
<field name="PictureBigLink" checked="true" />
<field name="PDFLink" checked="true" />
<field name="StockCount" checked="true" />
<field name="StockLimit" checked="true" />
<field name="DeliverTime" checked="true" />
<field name="ShortDescription" checked="true" />
<field name="LongDescription" checked="true" />
<field name="LongDescription2" checked="true" />
<field name="KeyWords" checked="true" />
<field name="UnitNumber" checked="true" />
<field name="Hidden" checked="true" />
<field name="FrontPage" checked="true" />
<field name="News" checked="true" />
<field name="NewsPeriod" checked="true" />
<field name="SortOrder" checked="true" />
<field name="MinBuyAmount" checked="true" />
<field name="RetailPrice" checked="true" />
<field name="EDBPrices" checked="true" />
<field name="IsVariantMaster" checked="true" />
<field name="MasterProdNumber" checked="true" />
<field name="ReservedField1" checked="true" />
<field name="ReservedField2" checked="true" />
<field name="ReservedField3" checked="true" />
<field name="ReservedField4" checked="true" />
<field name="ReservedField5" checked="true" />
<field name="ReservedField6" checked="true" />
<field name="ReservedField7" checked="true" />
<field name="ReservedField8" checked="true" />
<field name="ReservedField9" checked="true" />
<field name="ReservedField10" checked="true" />
<field name="MetaDescription" checked="true" />
</table>
<table name="DWIPrice" checked="true">
<field name="UnitPrice" checked="true" />
<field name="Avance" checked="true" />
<field name="SpecialOfferPeriodID" checked="true" />
<field name="SpecialOfferPrice" checked="true" />
</table>
<table name="DWIStock" checked="true" />
<table name="DWIProductGroup" checked="true">
<field name="ProductCatName" checked="true" />
<field name="Hidden" checked="true" />
<field name="SortOrder" checked="true" />
<field name="ProductCatLink" checked="true" />
<field name="ProductCatDescription" checked="true" />
<field name="ParentCategoryNumber" checked="true" />
</table>
<table name="DWIB2BGroup" checked="true">
<field name="B2BGroupName" checked="true" />
<field name="B2BGroupDescription" checked="true" />
</table>
<table name="DWIOrderHead" checked="true" />
<table name="DWIProductSegments" checked="true" />
<table name="DWIProductGroupSegments" checked="true" />
<table name="DWICustomer" checked="true">
<field name="Company" checked="true" />
<field name="Name" checked="true" />
<field name="Address" checked="true" />
<field name="Address2" checked="true" />
<field name="ZipCode" checked="true" />
<field name="City" checked="true" />
<field name="CountryID" checked="true" />
<field name="Phone" checked="true" />
<field name="Fax" checked="true" />
<field name="Email" checked="true" />
<field name="VATRegnum" checked="true" />
<field name="ReservedField1" checked="true" />
<field name="ReservedField2" checked="true" />
<field name="ReservedField3" checked="true" />
<field name="ReservedField4" checked="true" />
<field name="ReservedField5" checked="true" />
<field name="IsB2BCustomer" checked="true" />
<field name="B2BGroupNumber" checked="true" />
<field name="B2BUsername" checked="true" />
<field name="B2BPassword" checked="true" />
<field name="EAN" checked="true" />
<field name="TypeID" checked="true" />
<field name="GroupNumber" checked="true" />
<field name="LanguageID" checked="true" />
</table>
<table name="DWICustomerGroup" checked="true">
<field name="GroupName" checked="true" />
<field name="IsDefault" checked="true" />
</table>
<table name="DWIVariantRelation" checked="true" />
<table name="DWIProductVariantGroup" checked="true">
<field name="FreeTextVariant" checked="true" />
<field name="SortOrder" checked="true" />
<field name="SelectText" checked="true" />
<field name="FreetextDefaultValue" checked="true" />
<field name="FreetextMinValue" checked="true" />
<field name="FreetextMaxValue" checked="true" />
<field name="FreetextRegExValPattern" checked="true" />
<field name="FreetextValFailedText" checked="true" />
<field name="FreetextReadOnly" checked="true" />
<field name="IsProductConfigurator" checked="true" />
</table>
<table name="DWIProductVariant" checked="true" />
<table name="DWIProductRelated" checked="true" />
<table name="DWIProductVariantGroupRelation" checked="true" />
</update>
</database>
<log>
<logAllErrors>true</logAllErrors>
<filePath></filePath>
</log>
</configuration>
Sammenligning mellem gamle og nye elementer:
| XML element (gammel) | XML element (ny) |
| ERPConnStr | connString |
| ERPTablePrefix | tablePrefix |
| ERPIncTableDWIProduct | table name=”DWIProduct” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIPrice | table name=”DWIPrice” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIStock | table name=”DWIStock” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIProductGroup | table name=”DWIProductGroup” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWICustomer | table name=”DWICustomer” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIB2BGroup | table name=”DWIB2BGroup” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIOrderHeadAndLine | table name=”DWIOrderHead” checked=”true”
Sæt “checked” attribut. |
| DWIBoolsToInt | booleanAsInteger |
| DWISetDateTimeFormat | dateTimeFormat |
| DWIMoneyDecimalDelimiter | decimalDelimiter |
| DWIUserTransactionSQL | mssqlEnabled |
| DWIUserTransactionSQLConn | mssqlConnString |
| DWILogErrorsAll | logAllErrors |
| DWIProductDisablePictureLink | field name=”PictureLink” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisablePictureLinkBig | field name=”PictureBigLink” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisablePDFLink | field name=”PDFLink” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisableShortDescreption | field name=”ShortDescription” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisableLongDescreption | field name=”LongDescription” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisableCategory | field name=”ProductCategoryNumber” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisableSortOrder | field name=”SortOrder” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisableHidden | field name=”Hidden” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisableFrontPage | field name=”FrontPage” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisableNews | field name=”News” checked=”true”
Sæt “checked” attribut. “True” laves om til “false” og omvendt. |
| DWIProductDisableStockCount | field name=”StockCount” checked=”true” |
| DWIAutoDeleteRowsNotUpdated | update autoDeleteNotUpdatedRows=”false”
Sæt “autoDeleteNotUpdatedRows” attribut. |
| DWILogFilenameRowsNotUpdated | filePath |
| ERPUseNoneMSDBMS | <noneMSDBMS><enabled> |
| ERPNoneMSDBMSDelimiterIdentifierStart | delimiterIdentifierStart |
| ERPNoneMSDBMSDelimiterIdentifierEnd | delimiterIdentifierEnd |
| ERPUseNoneMSDBMSSelectIdentifier | selectIdentifier |
| DWIMaxItemsPerJob | maxItemsPerJob |
| ERPIncTableDWIProductSegments | table name=”DWIProductSegments” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIProductCatSegments | table name=”DWIProductGroupSegments” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIProductVariantGroup | table name=”DWIProductVariantGroup” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIVariantRelation | table name=”DWIVariantRelation” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIProductVariant | table name=”DWIProductVariant” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIProductRelated | table name=”DWIProductRelated” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWICustomerGroup | table name=”DWICustomerGroup” checked=”true”
Sæt “checked” attribut. |
| ERPIncTableDWIProductVariantGroupRelation | table name=”DWIProductVariantGroupRelation” checked=”true”
Sæt “checked” attribut. |
