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
<?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>