Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

UploaderId

Usage

PartsPrice

Import prices for parts per price list into Server database.

PartsBalance

Import availability for parts per warehouse into Server database.

Parts

Import ReplacementCode and AvailabilityCode on parts.

Organizations

Import organizations and addresses for organizations into Server database.

Users

Import users into Server database.

AssetUpload

Import assets into Asset database.

Invoice

Import invoices into Server database.

Sample configuration

Code Block
languagexml
<?xml version="1.0" encoding="utf-8"?>
<CustomFolderConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<Enabled>true</Enabled>
	<!-- In case SaveItem is true, importer service will save imports directly to the database. In this case importer service will 
	need to know where to find the server.config file since it may be either in AppData or in Program data depending on if importer 
	service is installed on Manager Server or on Web Server. -->
	<ServerConfigPath>C:\ProgramData\Signifikant\Assert\server.config</ServerConfigPath>
	<!-- Log files placed here. -->
	<LogFolder>C:\Signifikant\Log\ImportLog</LogFolder>
	<!-- File watcher will be recreated every x hrs. Default is 0 which means no recreation. Setting available from version 5.1.7 and later. -->
	<SuperviseHours>48</SuperviseHours>
	
	<Settings>
		<CustomFolderSettings ImporterId="Parts">
			<DumpUploadItems>true</DumpUploadItems>
			<FolderDescription>Part status</FolderDescription>
			<FolderEnabled>true</FolderEnabled>
			<FolderFilter>Parts*.xml</FolderFilter>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<BackupFolder>C:\Signifikant\Import_service_backup</BackupFolder>
			<FolderIncludeSub>false</FolderIncludeSub>
			<MoveToBackup>true</MoveToBackup>
			<SaveItems>true</SaveItems>
			<XlsSheet/>
			<SsxSheet>signifikant_parts.xsl</SsxSheet>
			<UploadItems>true</UploadItems>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploaderId>Parts</UploaderId>
			<UploadSiteId>Alo</UploadSiteId>
			<UploadLogin>false</UploadLogin>
			<UploadUsername>uploader</UploadUsername>
			<UploadPassword>uploader</UploadPassword>
			<Options>
				<Option key="PurgeAfter" value="true"/>
			</Options>
		</CustomFolderSettings>
		<CustomFolderSettings ImporterId="PartsPrice">
			<DumpUploadItems>true</DumpUploadItems>
			<FolderDescription>Part price</FolderDescription>
			<FolderEnabled>true</FolderEnabled>
			<FolderFilter>PartsPrice*.xml</FolderFilter>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<BackupFolder>C:\Signifikant\Import_service_backup</BackupFolder>
			<FolderIncludeSub>false</FolderIncludeSub>
			<MoveToBackup>true</MoveToBackup>
			<SaveItems>true</SaveItems>
			<XlsSheet/>
			<SsxSheet>signifikant_price.xsl</SsxSheet>
			<UploadItems>true</UploadItems>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploaderId>PartsPrice</UploaderId>
			<UploadSiteId>Alo</UploadSiteId>
			<UploadLogin>false</UploadLogin>
			<UploadUsername>uploader</UploadUsername>
			<UploadPassword>uploader</UploadPassword>
			<Options>
				<Option key="PurgeAfter" value="true"/>
			</Options>
		</CustomFolderSettings>
		<CustomFolderSettings ImporterId="PartsBalance">
			<FolderEnabled>true</FolderEnabled>
			<FolderDescription>Part availability</FolderDescription>
			<FolderFilter>PartsBalance*.xml</FolderFilter>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<BackupFolder>C:\Signifikant\Import_service_backup</BackupFolder>
			<FolderIncludeSub>false</FolderIncludeSub>
			<MoveToBackup>true</MoveToBackup>
			<SaveItems>true</SaveItems>
			<SsxSheet>signifikant_avaibility.xsl</SsxSheet>
			<UploadItems>true</UploadItems>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploaderId>PartsBalance</UploaderId>
			<UploadSiteId>Alo</UploadSiteId>
			<UploadLogin>false</UploadLogin>
			<UploadUsername>uploader</UploadUsername>
			<UploadPassword>uploader</UploadPassword>
			<Options>
				<Option key="PurgeAfter" value="true"/>
			</Options>
		</CustomFolderSettings>
		<CustomFolderSettings ImporterId="Organizations">
			<FolderEnabled>true</FolderEnabled>
			<FolderDescription>Organization import</FolderDescription>
			<FolderFilter>Organisations*.xml</FolderFilter>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<BackupFolder>C:\Signifikant\Import_service_backup</BackupFolder>
			<FolderIncludeSub>false</FolderIncludeSub>
			<MoveToBackup>true</MoveToBackup>
			<SaveItems>true</SaveItems>
			<SsxSheet>signifikant_organization.xsl</SsxSheet>
			<UploadItems>true</UploadItems>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploaderId>Organizations</UploaderId>
			<UploadSiteId>Alo</UploadSiteId>
			<UploadLogin>false</UploadLogin>
			<UploadUsername>uploader</UploadUsername>
			<UploadPassword>uploader</UploadPassword>
			<Options>
				<Option key="PurgeAfter" value="true"/>
			</Options>
		</CustomFolderSettings>
		<CustomFolderSettings ImporterId="Users">
			<FolderEnabled>true</FolderEnabled>
			<FolderDescription>User Import</FolderDescription>
			<FolderFilter>Users*.xml</FolderFilter>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<BackupFolder>C:\Signifikant\Import_service_backup</BackupFolder>
			<FolderIncludeSub>false</FolderIncludeSub>
			<MoveToBackup>true</MoveToBackup>
			<SaveItems>true</SaveItems>
			<SsxSheet>signifikant_user.xsl</SsxSheet>
			<UploadItems>true</UploadItems>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploaderId>Users</UploaderId>
			<UploadSiteId>Alo</UploadSiteId>
			<UploadLogin>false</UploadLogin>
			<UploadUsername>uploader</UploadUsername>
			<UploadPassword>uploader</UploadPassword>
			<Options>
				<Option key="PurgeAfter" value="false"/>
			</Options>
		</CustomFolderSettings>
	</Settings>
</CustomFolderConfiguration>

Desrciption of tags

	<CustomFolderSettings ImporterId="Invoice">
          <FolderEnabled>true</FolderEnabled>
          <FolderDescription>Initial data place holder and template (Invoices for Dometic)</FolderDescription>
          <FolderFilter>Invoice*.xml</FolderFilter>
          <FolderPath>C:\Signifikant\Import_service</FolderPath>
          <BackupFolder>C:\Signifikant\Import_service_backup</BackupFolder>
          <FolderIncludeSub>false</FolderIncludeSub>
          <MoveToBackup>true</MoveToBackup>
          <SaveItems>true</SaveItems>
          <XlsSheet>signifikant_invoice.xsl</XlsSheet>
          <SsxSheet />
          <UploadItems>true</UploadItems>
          <UploaderId>Invoice</UploaderId>
          <UploadServer>http://localhost/AssertWeb/</UploadServer>
          <UploadUsername>uploader</UploadUsername>
          <UploadPassword>uploader</UploadPassword>
          <UploadLogin>false</UploadLogin>
          <Options>
            <Option key="PurgeAfter" value="false"/>
          </Options>
        </CustomFolderSettings>
	</Settings>
</CustomFolderConfiguration>

Desrciption of tags

Tags

Description

Options

ServerConfigPath

Path to the server.config file where configuration is kept for the editor- or web-server. Important is the Notification settings, and the integration to Monitoring dashboard.

For an editor server: C:\ProgramData\Signifikant\Assert\server.config.

For a web server: C:\inetpub\wwwroot\AssertWeb\App_Data

FolderEnabled

If configuration is active or not.

true/false

FolderDescription

Description.

textText

FolderFilter

Regex used on the files that appear in the folder. Only files matching the regex will be handled, e.g. Part_price*.xml.

Text (Now possible to use a pipe character '|' in the filter to allow combining multiple filters to target different types of files)

FolderPath

Folder path to monitor for new files.

FolderIncludeSub

If sub folders are to be scanned for imports.

true/falseText

MaxIdleDays

Time limit when it is considered an error if no new import files arrive, see below.

integerInteger

MaxIdleHours

Time limit when it is considered an error if no new import files arrive, see below.

integerInteger

MoveToBackup

If file is to be moved to backup folder.

true/false

BackupFolder

After an import or upload is completed, move file to this folder.

SaveItems

If file content is to be saved on database on same server as importer service runs on.

true/false

SiteId

Site name when importing into Manager site.

Site name

UploadItem

If file content is to be uploaded to web server site.

true/false

UploadSiteId

Site name when uploading into web viewer site.

Site name

UploadServer

Url for the web server e.g https://www.domain.com/AssertWeb/

UploaderId

Type of upload, see table above.

See table above

UploadLogin

If login required to upload items to webserver.

true/false

UploadUsername

User name and password for calling the upload API on the web server. Api permissions are setup in: C:\ProgramData\Signifikant\Assert\api-permission.config, see Technical documentation - Signifikant REST API authentication .

UploadPassword

DumpUploadItems

If upload dump is to be generated in log folder.

true/false

XlsSheet

Custom Xls for the importer. Custom Xls shall be placed in C:\ProgramData\Signifikant\Assert\Customize

SsxSheet

Signifikant predefined SSX format for the import type as signifikant_organization.xsl

Options

Used to define alternatives to control the import

See separate table below.

...