AFAS

Index

Introduction
Disclaimer
Installation
Usage
Configuration
Logging (Optional)

Introduction

This MC can be used to retrieve and update data from AFAS

Disclaimer

The use of this tool is at users own risk. The user understands that Scope4mation is not responsible nor liable for any damages, unexpected results, costs or any other effect that might occur as a result of using this tool.  

Installation

Extract the software from the zip file. Once the extraction is done, you need to configure the .exe.config file located next to the executable.

Once everything is filled in and saved, run the tool with the parameter: -GenSettingsTable: 

C:\Mini Connectors\AFAS>AFASMC.exe -GenSettingsTable 

Usage

When you see a child with Parameter: in front, that means these are required extra parameters when the parent parameter is used.

• -Get_Meta
  • Retrieves all get connectors that can be used by the token and generates the output tables for them
• -Update_Meta
  • Retrieves all update connectors that can be used by the token and generates the input tables for them
• -Update_MetaStructure
  • Generates 2 tables that contains all update connectors and extra field properties
• -Update
  • Parameter: Name of the table containing the input data
  • Updates the data in AFAS using the data from the input table the generated name of the table is used to determine to what object it must be updated
• -Get
  • Every parameter after the first are AFAS get connectors that will be retrieved and saved to their output tables
• -GenSettingsTable
  • Generates the settings table containing the AFAS token , UpdateOutputPrefix, GetOutputPrefix and dm_unid
• -Control
  • Parameter: Name of the PtRealization table
  • This function checks if the records in the input table are successfully sent

Configuration

Option	Description	Sample
DBServer	The server where the database engine is running.	s4m-hostname
DB	The name of the database where the application will save and retrieve its data from	AFASMC
SettingsTable	The name of the settings table. It will be generated when using –GenSettingsTable and read its extra settings from	AFASSettings
Username	The SQL username to use for the SQL connections	admin
Password	The password that corresponds to the SQL User	*****
MaxControlAttempts	An number indicating the maximum amount of attempts the control function will attempt to check the record. This value if incremented each time the control function is ran	5
AllowedAction	Comma separated list with the options: 1 = Create 2 = Update 3 = Delete	1,2,3
EnvironmentID	The ID of the AFAS environment	42
UseLogServer	True or False; Use the DM central logging engine or a local log file	True

 Logging (Optional)

You can read more about the logging settings here.