skybuild for it · skybuild export saved to db skybuild allows defining exports of various student...

SkyBuild for IT

2019 User Group Conference

SkyBuild for IT

Leverage the power of SkyBuild in your IT toolbox.

Learn how you can create custom data files that you can use with third party vendors and software.

See how easy it is to ftp the files to vendor sites, and much more!

FTP Connections

• Data Mining and SkyBuild

• Imports and Exports

• Setup included in templates or in Scheduled Tasks

FTP Connections for Import/Export Options

What is a UNC Path to Skyward Web?

• Enter a Location as UNC path in Import or Export Interface• Example: \\server\share\folder\file.example

• The Import From or the Export To folder on a remote server:• Needs to…

• Be a Windows or Equivalent File Share

• Be accessible by/from the Skyward Report Queue server(s)

• Permissions assigned to the Skyward Service Account

• Create a local or Domain Account

• The password must match the Service Account on your Skyward Server(s)

• All Skyward Services use the Skyward Service Accountas the Logon account to the UNC path

UNC Path Testing

Product Setup > Skyward Contact Access > Tools > Fix Programs > Add > Program:unctestedit.w > Save > Run.

A Scheduled Task

My Print Queue > Tasks

Add an FTP Connection

Test an FTP Connection

Curl command behind the scenes could be:

?:\skyward\ocx\curl.exe –o “c:\skyward\wrk\filename.nnn” –u “username:password” –ssl-reqd –k –connect-timeout 10 –mac-time 14400 –v “ftp://ftp.dns.com:21//export/filename.nnn”

SkyBuild Staff Import

SkyBuild Staff Import

SkyBuild Staff Import

SkyBuild Employee Import

Employee Import Tool will automate the import of employee users in a Business database. This import tool is known as the Applicant Import Utility. This utility imports employees from an import file. The Applicant Import Utility is a licensed feature that is available since June 2016 Release.

Link to Student/Finance Database

SkyBuild Imports/Exports

SkyBuild Imports/Exports • Pre-Defined Interfaces

• Share Interfaces

• Import Interfaces

• Clone Interfaces

SkyBuild Import and Export Fields

SkyBuild Export Saved to DB

SkyBuild allows defining exports of various student related data, usually for use with other data systems. One of the options in setting up the export is“Save Exported Files in Database to View through the Export File Viewer”.

This option stores the entire contents of the data exported in a file, in the database. If such a process is scheduled, then the file is typically saved to a “UNC” or network path and saving a copy of the file in the database may not be necessary. By storing such exports that are often auto-scheduled to run multiple times per day/week/month/year may add significant sizeto the database. Decide if you truly need a copy of the data stored each time.

SkyBuild Export Cleanup

If you don’t wish to retain the files in the database, then you should set up ‘mass delete’ of exported files in the database.

1. Navigate to WS\AD\SB\EX\FV > Mass Delete > Add.

2. This template can be set up to delete files which are X number of days old.For example: It could be set to clear all old data 10 days or older like the example below.

3. Click Save and Run to run the cleanup utility.

SKYWARD

IT Services

Thank you for attending!