[vc_row bg_image=”11803″ cover_bg=”true” parallax_bg=”true” text_color=”light” top_padding=”40″ bottom_padding=”40″][vc_column width=”1/2″][vc_empty_space][vc_column_text css=””]SunSystems Transfer Desk[/vc_column_text][separator width=”80px” color=”#ffffff”][vc_column_text css=”.vc_custom_1718702805485{margin-top: 20px !important;}”]

This gives you the ability to transfer data internally within a SunSystems database and to transfer data to and from external files

[/vc_column_text][/vc_column][vc_column width=”1/2″][media animation=”none” image=”13590″][/vc_column][/vc_row][vc_row top_padding=”40″ bottom_padding=”10″][vc_column width=”1/2″ css=”.vc_custom_1715067827636{border-color: #0059a8 !important;}”][vc_column_text css=””]

Overview

[/vc_column_text][separator width=”80px” color=”#0059a8″ margin_top=”10″ margin_bottom=”30″][vc_column_text css=”.vc_custom_1715068881712{padding-top: 18px !important;}”]The Transfer Desk function and its associated components are fully web enabled. This means you can access it anywhere with an internet connection and on any device, including tablets and smartphones.[/vc_column_text][vc_column_text css=””]Records can be:

• Created
• Amended
• Deleted
• Closed
• Suspended
• Hidden
• Opened

Formats

• Delimited
• Single Fixed Width Record
• Multi Fixed Width Records
• User XML
• Simple XML

[/vc_column_text][/vc_column][vc_column width=”1/2″][vc_empty_space][vc_raw_html css=””]JTNDbGluayUyMHJlbCUzRCUyMnN0eWxlc2hlZXQlMjIlMjB0eXBlJTNEJTIydGV4dCUyRmNzcyUyMiUyMGhyZWYlM0QlMjJodHRwcyUzQSUyRiUyRmZpbmFuc3lzLmNvbSUyRndwLWNvbnRlbnQlMkZ0aGVtZXMlMkZzcGVjdWxhci1jaGlsZCUyRmNzcyUyRmxpZ2h0Ym94Lm1pbi5jc3MlMjIlMjAlMkYlM0UlMEElMEElM0MlMjEtLSUyMGxvYWQlMjB0aGUlMjBKUy0tJTNFJTBBJTNDc2NyaXB0JTIwc3JjJTNEJTIyaHR0cHMlM0ElMkYlMkZmaW5hbnN5cy5jb20lMkZ3cC1jb250ZW50JTJGdGhlbWVzJTJGc3BlY3VsYXItY2hpbGQlMkZqcyUyRmxpZ2h0Ym94Lm1pbi5qcyUyMiUzRSUzQyUyRnNjcmlwdCUzRSUwQSUwQSUwOSUzQ3NjcmlwdCUzRSUwQSUwOSUwOSUyRiUyRm9wdGlvbiUyMGZvciUyMGxpZ2h0Ym94JTBBJTA5JTA5bGlnaHRib3gub3B0aW9uJTI4JTdCJTBBJTA5JTA5JTIwJTI3cG9zaXRpb25Gcm9tVG9wJTI3JTIwJTNBJTIwMTUwJTJDJTBBJTA5JTA5JTIwJTIwJTI3d3JhcEFyb3VuZCUyNyUzQSUyMHRydWUlMEElMDklMDklN0QlMjklMEElMDklM0MlMkZzY3JpcHQlM0UlMEElMEElM0NhJTIwaHJlZiUzRCUyMmh0dHBzJTNBJTJGJTJGZmluYW5zeXMuY29tJTJGd3AtY29udGVudCUyRnVwbG9hZHMlMkYyMDI0JTJGMDUlMkZTdW5TeXN0ZW0tVHJhbnNmZXItRGVzay5qcGclMjIlMjBkYXRhLWxpZ2h0Ym94JTNEJTIyRlNBX09DUl9UYWJfZ3JhcGhpYy1WMiUyMiUyMGRhdGEtdGl0bGUlM0QlMjIlMjIlM0UlM0NpbWclMjBzcmMlM0QlMjJodHRwcyUzQSUyRiUyRmZpbmFuc3lzLmNvbSUyRndwLWNvbnRlbnQlMkZ1cGxvYWRzJTJGMjAyNCUyRjA1JTJGU3VuU3lzdGVtLVRyYW5zZmVyLURlc2suanBnJTIyJTJGJTNFJTNDJTJGYSUzRSUwQSUwQQ==[/vc_raw_html][vc_column_text css=””]

Click to enlarge image

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text css=””]Reference data is read directly to the relevant table whilst transactional data is sent to the “Ledger Import Control Desk” and the user is given the opportunity to validate and report the data before importing to the live table.[/vc_column_text][vc_row_inner][vc_column_inner width=”1/2″ css=”.vc_custom_1715071748454{padding-right: 20px !important;padding-bottom: 30px !important;padding-left: 20px !important;background-color: #1caadd !important;}”][vc_column_text css=””]

Using the Transfer Desk

[/vc_column_text][media animation=”none” image=”13434″][vc_column_text css=””]The full utility is divided into three main areas, these are:

• Transfer Profile
• Transformation Designer
• File Designer

[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][vc_column_text css=””]The simplest way to use the utility is using XML. This way, only a “Transfer Profile” needs to be written. Sometimes, the data needs to be manipulated in some way before arriving at its target, e.g. the account code may be swapped with an analysis code. This is done using the Transformation Designer and allows every field to be mapped to another field as well as being manipulated in some way if necessary, i.e. the Accounting Period may need to be altered to reflect the Current Period.

If the data is not XML, then the file designer needs to be configured. This allows the user to define exactly the format of the data and the Transformation allows the user to pick up the design and map the fields into the relevant SunSystems fields[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column][vc_column_text css=””]

Surrounding Functionality

[/vc_column_text][separator width=”80px” color=”#0059a8″ margin_top=”10″ margin_bottom=”30″][vc_empty_space height=”15″][vc_column_text css=””]There is functionality that surrounds the Transfer Desk. Rules need to be set on what the user wants to do with the Source data once the routine has been run. So the data can be:

• Copied to a new location
• Renamed and moved to another location
• Deleted
• Left as it is

The Transformation allows Java to be written against fields. A good example is the Source Data, which has the wrong date format. Java can be written to reformat this. It is possible to write “Lookups” against the data. So, it is possible to select a field and tell it if the Source Data falls within a range, then select a particular value for that target.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text css=””]

Automation Desk

[/vc_column_text][separator width=”80px” color=”#0059a8″ margin_top=”10″ margin_bottom=”30″][vc_empty_space height=”15″][vc_column_text css=””]Automations are made up of one or more profiles that are run together as one process, in the order you specify using Automation Designer.
An automation consisting of several profiles can be useful in allowing multiple transfer processes to run autonomously. An automation with only one profile can also be useful, for example, to pre-configure any of the runtime parameters set as overridable for the profile.[/vc_column_text][/vc_column][/vc_row][vc_row text_color=”light”][vc_column][vc_row_inner css=”.vc_custom_1718101979688{padding-bottom: 30px !important;padding-left: 20px !important;background-color: #0059a8 !important;}”][vc_column_inner width=”1/2″][vc_column_text css=””]

Automation Designer allows you to:

[/vc_column_text][vc_column_text css=””]

• Create and edit automations
• Add profiles to an automation
• Define the order in which the profiles are to run within the Automation
• Change overridable runtime parameters
• Store, and load automations

[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][media image=”13603″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column][vc_column_text css=””]You can also schedule automations to run at a predetermined time using a scheduler program such as NT Scheduler.
Once an automation is created using Automation Designer, it is normally run from within Transfer Desk.

However it is also possible to run it from a command line.

For example, in Windows, selecting Start >> Run allows you to enter the command. You can use the same command line syntax when setting up a scheduler program such as NT Scheduler to run the automation on a scheduled basis.

It can also be used in a Navigator shortcut, in order to run a specific automation directly from SunSystems Navigator.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_empty_space][/vc_column][/vc_row]