Fremdwährungspreise importieren
Enthält Konfiguration und Demo-Daten für den Import von Fremdwährungspreisen zu Artikeln.
XML-Konfigurationsdatei
Fremdwaehrungspreise_Import_Konfiguration.xml
<?xml version="1.0" encoding="utf-8"?>
<Configuration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" FileVersion="2">
<SpecialConfigKey />
<SpecialContentDownload>false</SpecialContentDownload>
<SpecialExtendedContentDownload>false</SpecialExtendedContentDownload>
<CacheImport>false</CacheImport>
<WebServiceUsername />
<WebServicePassword />
<FileType>CSV</FileType>
<Separator>;</Separator>
<StartImportAtRow>2</StartImportAtRow>
<QuotedStrings>false</QuotedStrings>
<NumberFormat>Default</NumberFormat>
<SourceDownloadConfiguration />
<DefaultSupplierNumber xsi:nil="true" />
<PrimaryItemIdentifier IdentifiedBy="ItemNumber" SourceColumnName="ARTIKELNUMMER" />
<OnlyUpdate>true</OnlyUpdate>
<DenyImportForMissingItems>false</DenyImportForMissingItems>
<IgnoreInactiveItems>false</IgnoreInactiveItems>
<OnlyUpdateItemsYoungerThanDays xsi:nil="true" />
<CreateNewItemCriteria>false</CreateNewItemCriteria>
<SkipWhenItemCriteriaNotExists>false</SkipWhenItemCriteriaNotExists>
<DoNotCheckOrSetLocks>false</DoNotCheckOrSetLocks>
<CreateNewItemProfilingCriteria IsEnabled="false" />
<ClearItemProfilingCriteria IsEnabled="false" />
<DownloadAndImportImages>false</DownloadAndImportImages>
<PackagingConfiguration>
<PackagingUnitSourceColumnName />
</PackagingConfiguration>
<SkipPurchasePriceCalculation>false</SkipPurchasePriceCalculation>
<ColumnConfiguration>
<DataConfig TargetTableName="ARTIKELSTAMM" TargetColumnName="VK" SourceColumnName="EUR" Overwrite="true" />
<DataConfig TargetTableName="ARTPREISE" TargetColumnName="VK" SourceColumnName="USD" Overwrite="true" Currency="USD" />
<DataConfig TargetTableName="ARTPREISE" TargetColumnName="VK" SourceColumnName="CHF" Overwrite="true" Currency="CHF" />
</ColumnConfiguration>
</Configuration>]] ></ac:plain-text-body></ac:structured-macro><p><br /></p><h1>Daten-Datei</h1><ac:structured-macro ac:name="code" ac:schema-version="1" ac:macro-id="3d4f3ea3-5834-4dc3-b96c-7a4eea946d24"><ac:parameter ac:name="title">Fremdwaehrungspreise_Import_Daten.csv</ac:parameter><ac:plain-text-body><![CDATA[ARTIKELNUMMER;EUR;USD;CHF
123456;500;550;450
234567;1100;1300;990
345678;400;430;380
]] ></ac:plain-text-body></ac:structured-macro><p class="auto-cursor-target"><br /></p>