Versions Compared

Version Old Version 6 New Version 7
Changes made by

Mattias Löfstrand

Mattias Löfstrand

Saved on

Key

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

...

Info

This service is available in version 5.0 and later

Overview

The import process require a configuration of folders, filenames, transformers, handlers, logging etc,. Once this is setup the service is working automatically to handle new data.

...

  1. A new file is generated on a predefined disk area by an external system

  2. The service supervises the disk area and detects the new file, the file name is compared to a name pattern to determine if the file is handled and how it is handled

  3. The import handler is called to transform the file to an internal format suitable for upload

  4. The items loaded to the importer is passed to the uploader

  5. The uploader handler calls a remote server Api, passing a chunk of items

  6. The remote Api will handle the data and store it to the server, the REST call indicates what interface is called and type of the data to store

...

Configuration

Imported data

Currently we handle part prices, part availability, organisations and customers - all is imported to the Server database on a remote server. It is also possible to import part information into a Manager site.

The service configuration is in: C:\ProgramData\Signifikant\Assert\importer-service.config. Each configuration is defined in a CustomFolderSettings tag and, if it is to upload to a web server, refers an UploaderId depending on upload action.

UploaderId

Usage

PartPrice

Import prices for parts per price list into Server database.

PartBalance

Import availability for parts per warehouse into Server database.

Organization

Import organizations and addresses for organizations into Server database.

AssetUpload

Import assets into Asset 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>
	<ServerConfigPath>C:\ProgramData\Signifikant\Assert\server.config</ServerConfigPath>
	<LogFolder>C:\Signifikant\Log\ImportLog</LogFolder>
	<Settings>
		<CustomFolderSettings ImporterId="PartPrice">
			<BackupFolder>C:\Signifikant\Backup</BackupFolder>
			<DumpUploadItems>true</DumpUploadItems>
			<FolderDescription>Part price</FolderDescription>
			<FolderEnabled>true</FolderEnabled>
			<FolderFilter>PRICE*.xml</FolderFilter>
			<FolderIncludeSub>false</FolderIncludeSub>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<MoveToBackup>true</MoveToBackup>
			<SaveItems>true</SaveItems>
			<SsxSheet/>
			<UploadItems>true</UploadItems>
			<UploadLogin>true</UploadLogin>
			<UploadPassword>uploader</UploadPassword>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploadUsername>uploader</UploadUsername>
			<UploaderId>PartsPrice</UploaderId>
			<XlsSheet>part_price.xsl</XlsSheet>
			<Options>
				<Option key="PurgeAfter" value="true" />
			</Options>
		</CustomFolderSettings>
		<CustomFolderSettings ImporterId="PartsBalance">
			<FolderEnabled>true</FolderEnabled>
			<FolderDescription>Part availability</FolderDescription>
			<FolderFilter>Item_Balance_All*.xml</FolderFilter>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<FolderIncludeSub>false</FolderIncludeSub>
			<MoveToBackup>true</MoveToBackup>
			<BackupFolder>C:\Signifikant\Backup</BackupFolder>
			<SaveItems>true</SaveItems>
			<XlsSheet>PartBalance.xsl</XlsSheet>
			<SsxSheet/>
			<UploadItems>true</UploadItems>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploaderId>PartsBalance</UploaderId>
			<UploadLogin>false</UploadLogin>
			<UploadUsername>uploader</UploadUsername>
			<UploadPassword>uploader</UploadPassword>
			<Options>
				<Option key="PurgeAfter" value="true" />
			</Options>
		</CustomFolderSettings>
		<CustomFolderSettings ImporterId="Organization">
			<FolderEnabled>true</FolderEnabled>
			<FolderDescription>Organization</FolderDescription>
			<FolderFilter>Customer*.xml</FolderFilter>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<FolderIncludeSub>false</FolderIncludeSub>
			<MoveToBackup>true</MoveToBackup>
			<BackupFolder>C:\Signifikant\Backup</BackupFolder>
			<SaveItems>false</SaveItems>
			<XlsSheet>organization.xsl</XlsSheet>
			<SsxSheet>signifikant_organization.xsl</SsxSheet>
			<UploadItems>true</UploadItems>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploaderId>Organization</UploaderId>
		</CustomFolderSettings>
		<!-- <CustomFolderSettings ImporterId="AssetImport"> -->
		<CustomFolderSettings ImporterId="AloAssetImport">
			<FolderEnabled>true</FolderEnabled>
			<FolderDescription>Assets</FolderDescription>
			<FolderFilter>Signifikant_Serial*.xml</FolderFilter>
			<FolderPath>C:\Signifikant\Import_service</FolderPath>
			<FolderIncludeSub>false</FolderIncludeSub>
			<MoveToBackup>true</MoveToBackup>
			<BackupFolder>C:\Signifikant\Backup</BackupFolder>
			<SaveItems>false</SaveItems>
			<XlsSheet/>
			<SsxSheet/>
			<UploadItems>true</UploadItems>
			<UploadSiteId>Alo</UploadSiteId>
			<UploadServer>http://localhost/AssertWeb/</UploadServer>
			<UploaderId>AssetUpload</UploaderId>
			<DumpUploadItems>true</DumpUploadItems>
			<UploadLogin>true</UploadLogin>
			<UploadUsername>uploader</UploadUsername>
			<UploadPassword>uploader</UploadPassword>
			<Options>
				<Option key="ArtnoFile" value="ARTNO*.xml"/>
				<!-- <Option key="DefaultImageFile" value="LOADER_DEFAULT.png"/> -->
			</Options>
		</CustomFolderSettings>    </Settings>
</CustomFolderConfiguration>

Desciption of tags

Tags

Description

Options

FolderEnabled

If configuration is active or not.

true/false

FolderDescription

Description.

text

FolderFilter

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

FolderPath

Folder path to monitor for new files.

FolderIncludeSub

If sub folders are to be scanned for imports.

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 imported into Manager site.

true/false

SiteId

Site name when importing into Manager site.

Site name

UploadItem

If file content is to be uploaded to web server

...

Configuration

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.

Organization, AssetUpload, PartPrice, PartBalance

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\

...

Description

Tags

Customize

SsxSheet

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

Options

Options

Used to define alternatives to control the import

See separate table below.

...

The service also logs to an application log file, normally found at: C:\ProgramData\Signifikant\Assert\ImportService.log

Custom Xls for uploads

Prices

Availability

Organizations

Assets

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@1ecd09
showSpacefalse
sortmodified
typepage
reversetrue
labelsimport service
cqllabel in ( "service" , "import" ) and type = "page" and space = "ASKB"

...