Content Comparison

...

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

language	xml

<?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>
          <DeleteAfterImport>true</DeleteAfterImport>
          <FolderIncludeSub>false</FolderIncludeSub>
          <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
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
DeleteAfterImport	If file should be deleted after a successful import. (NB: This takes precedence over backup settings) Note. This option is available in version 5.2 and later.	true/false
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.

...

Version	Old Version 28	New Version Current
Changes made by	Mattias Löfstrand	Mattias Löfstrand
Saved on	24 Nov 2022	27 Apr 2023

Versions Compared

Key

Sample configuration

Desrciption of tags

Desrciption of tags