Integrations - VL University https://visuallease.com/vluniversity/course-category/integrations/ Tue, 26 Mar 2024 20:48:32 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.3 https://visuallease.com/vluniversity/wp-content/uploads/sites/5/2021/10/cropped-VL-ONLY-onWHT-1-32x32.png Integrations - VL University https://visuallease.com/vluniversity/course-category/integrations/ 32 32 Integrations Hub: Exports https://visuallease.com/vluniversity/course/integrations-hub-exports/ https://visuallease.com/vluniversity/course/integrations-hub-exports/#respond Wed, 15 Feb 2023 22:53:11 +0000 https://visuallease.com/migratevlu/?post_type=lp_course&p=298 The post Integrations Hub: Exports appeared first on VL University.

]]>

COURSE ID

7.1

COURSE DESCRIPTION

This course is designed to walk you through the Exports feature of Visual Lease’s Integrations Hub. By the end of this course, learners will be able to setup the SFTP server for your scheduled exports, schedule new exports, review failed/successful exports, and delete exports.

 

COURSE MATERIALS

Transcription:

INTRODUCTION

Hi everyone! Welcome to this video on the new Exports feature of the Integrations Hub.

First, let’s review the webinar agenda:
• I’ll introduce the Integrations Hub
• I’ll provide an example use of Exports
• I’ll demonstrate the Exports feature of the Hub.

Currently, we offer tools such as the auto importer for importing flat files and the Accounting Feeds as ways to integrate, to some degree, the VL platform with your ERP, contract management, or property management system.

We have been working on more advanced integrations capabilities to create more seamless connections between VL and your systems.

We are proud to offer the next class of integration tools via the new Integrations Hub, which provides the following managed file transfer options:
• Schedule the automatic exporting of standard and Ad Hoc reports and accounting feeds
• Schedule the automatic importing of lease or platform information via flat files.

The Hub also provides documentation on our API library for building real-time connections to your systems.

This video covers the Exports feature.

Why would you use the Exports feature? Let’s go to the Visual Lease platform to see one way you can benefit.

You might currently run reports from the Standard Lease Reports screen as follows. Let’s say you run the Lease Accounting report, so I’ll select that.

I may want to run separate reports for separate business units, regions, asset classes, or other criteria. So I load a saved filter for the first set of criteria with the Load Saved Filter button. The criteria for the filter is shown.

After I run the report and either download it or email it, I’ll need to run it again for a different filter as I just did. And that’s just if I’m only running the Lease Accounting Report.

So the setup process is very manual. Plus, each report is emailed or downloaded one at a time.

The Exports section of the Integrations Hub enables you to schedule each report or accounting feed type for each filter all up front. When these reports are generated, they will automatically appear in your sFTP server site.

Let’s jump into the Visual Lease Integrations Hub to see this enhancement. Please note that this is a site used for demonstration, so the information within it may not reflect actual situations. At this time only Administrators will have access.

The first screen that appears is the Dashboard. In the future this will be able to display multiple windows providing metrics on your integrations between Visual Lease and your systems. For now we have the Monitoring window that displays the total number of imports and/or exports attempted in a given period of time, both as a donut chart and a bar chart listing the numbers and percentages of successful and failed attempts.

Before you can export a report or feed, you need to set up an sFTP designation. This is done in Settings. To get there, select your name in the upper right corner and select Settings.

The initial screen is your user profile. From this screen, you can change your password.

Click Export on the left.

Here we see some designations already created. They identify the sFTP server to which the reports and/or accounting exports will be saved and the login credentials for that server. While this feature is in beta testing, you can only use VL’s sFTP server. When this is available for general release, you can use your own sFTP server. You may want to set up multiple sites for different departments such as accounting and lease administration.

To add a new designation, click Add.

Enter an easily-identifiable name in SFTP Name, such as the name of the report or feed you are saving with the connection, or a description of the external system you are sending the report to, such as Accounts Receivable System 1 or Office Space Utilization Server. You can also set up a designation for each type of report. Therefore I’ll name this designation after the ad hoc report I want to export

Enter the Host URL provided by Visual Lease, and the Username and Password.

Enter the sFTP Port number. It is typically 22, which is the case for our server.

Click Connect to save the designation.

Now let’s see the export jobs that have been run or are scheduled to run. Click the X in the upper right to escape the Settings screen.

Click Exports in the left pane.

The top section shows the export jobs that are scheduled

The bottom section shows the jobs that have already run and include whether they succeeded or failed.

Either section can be sorted by any column.

Of course we can also schedule new exports by clicking Schedule.

Enter an identifiable Job Name.

When you click inside the Report field, you see a drop-down of the saved standard and Ad Hoc reports in your platform. These are sorted in a different order than in the platform, so you may need to type part of the report name to see the full name in this list. I’ll select a report.

One thing that must be mentioned is that in order to schedule a standard report in this way, you must first save the criteria and lease filter with the report in the VL platform using the Save Report button. I’ll quickly go back to the Standard Lease Reports screen.

To save a report to appear in the Report list in the Hub, set your criteria, load a filter, and click Save Report. Please note that you will not be able to find these saved reports in the VL platform like you can the Ad Hoc reports.

Let’s go back to the Integrations Hub

So the reports in the Report dropdown are run by this process against the filter and criteria that it was originally saved with.

Enter the first date the export should run. You can also enter the Start Time.

You have the option to either stop the schedule on a particular date by entering that date, or select the No end date check box to keep the export running. To add a specific end date, click the calendar icon again, and select the date this export should stop running.

Select the frequency at which to run the report. I’ll pick Monthly.

Below that is for specifying the SFTP recipient, meaning in which folder in your sFTP partition should the report be saved. I’ll select YYY.

When I click Save, the next occurrence of that schedule is added to the Scheduled list.

In the History section, a Fail result could be because the sFTP designation was incorrect or perhaps there was an error with generating the report. If you see a Fail result, double-check the designation in Settings and run the schedule again. If it still fails, contact support@oscar2.creativamotions.com.

For standard reports, the Output column shows the generic name of the report. For ad hoc reports, the column shows the text Adhoc_Report. In both cases, the date and time are included in the Output name.

To delete a schedule, click the trash can icon next to it. It will stop all future exports of that schedule.

That concludes our introduction to Exports in the Integration Hub!

To recap:
• The Exports feature of the Integrations Hub starts with creating sFTP designations.
• Create scheduled jobs to export specific reports or feeds for specific criteria. You can select the frequency and for how long the jobs should run.
• Use the Exports screen to review the successful and failed export jobs

Thank you for attending this course! If you have any questions, suggestions or feedback on this training video, please email us at Support@visuallease.com.

The post Integrations Hub: Exports appeared first on VL University.

]]>
https://visuallease.com/vluniversity/course/integrations-hub-exports/feed/ 0
Integrations Hub: Imports https://visuallease.com/vluniversity/course/integrations-hub-imports/ https://visuallease.com/vluniversity/course/integrations-hub-imports/#respond Tue, 14 Feb 2023 22:53:39 +0000 https://visuallease.com/migratevlu/?post_type=lp_course&p=301 The post Integrations Hub: Imports appeared first on VL University.

]]>
Transcription:

Hello and welcome to this video on the new Imports feature of the Integrations Hub.

First, let’s review the webinar agenda:

  • I’ll introduce the Integrations Hub
  • I’ll provide an example use of Imports
  • I’ll demonstrate the Imports feature of the Hub.

Currently, we offer tools such as the auto importer for importing flat files and the Accounting Feeds as ways to integrate the VL platform with your ERP, contract management, or property management system.

We have been working on more advanced integration capabilities to create more seamless connections between VL and your external systems.

We are proud to offer the next class of integration tools via the new Integrations Hub, which provides the following managed file transfer options:

  • Schedule the automatic exporting of standard and Ad Hoc reports and accounting feeds
  • Schedule the automatic importing of lease or platform information via flat files

The Hub also provides documentation on our API library for building real-time connections to your systems.

This video will cover the Imports feature.

Why would you use the Imports feature? Let’s go to the Visual Lease platform to see one way you can benefit.

You might currently store data and run reports in your external applications and manually import that information into the Visual Lease platform, file by file with this Import Lease Information screen. For example, I’ll click General Lease Information to open the screen for importing basic information on a set of leases.

After downloading and populating the template, you upload it back here in the Upload section. The results are then shown below.

If you can’t put all your changes in one template, or you have to update more than one platform area, you’ll need to do all this again multiple times.

The Import section of the Integrations Hub enables you to schedule recurring, automatic imports to meet your end-to-end compliance needs more easily.

Let’s jump into the Visual Lease Integrations Hub to see this enhancement. Please note that this site is used for demonstration, so the information within it may not reflect actual situations. At this time only Administrators will have access to schedule imports.

The first screen that appears is the Dashboard. In the future, you will be able to display multiple windows providing metrics on your integrations between Visual Lease and your external systems. For now, we have the Monitoring window which displays the total number of imports and/or exports attempted in a given period, and tracks the percentages of successful and failed attempts.

Before you can begin importing reports, you need to set up an SFTP Designation. This can be done in Settings. To get there, select you name in the upper right corner and select Settings.

The initial screen is your user profile. From this screen, you can change your password, as well as your time zone.

Click Import on the left.

From this screen, you can review existing SFTP Designations and create new ones. They identify the sFTP server from which import files can be retrieved. While this feature is in beta testing, you can only use VL’s sFTP server. When this is available for general release, you can use your own sFTP server. You may want to set up multiple sites for different departments such as accounting and lease administration. Click the Add button to create a new SFTP Designation for your Imports.

Enter an easily identifiable name in SFTP Name, such as the type of data you are importing with this connection.

Enter an easily identifiable name in SFTP Name, such as the type of data you are importing with this connection.

Enter the Host URL for this SFTP, as well as your Username and Password.

Enter the SFTP Port number. This will typically be 22, as is the cause with our server.

Enter the SSHKEY of this SFTP Designation.

Click Connect to save the new SFTP designation.

Let me refer you to this note. It says you need to create a folder named AutoImporter at the root of your sFTP sites. This is the folder you will place your files in that the platform will pick up for importing.

Now, let’s see the import jobs that have been run or are scheduled to run. Click the X in the upper right to escape the Settings Screen.

Click Imports in the left pane.

The top section shows the import jobs that are scheduled.

The bottom section shows the jobs that have already run and include whether they succeeded or failed. You can see exactly what data failed to import in your SFTP site, which I’ll explain a little later.

Both sections can be filtered by any column.

We can also schedule a new import by clicking Schedule in the top right.

Enter an easily identifiable Job Name.

Select the Import Type from the list. The option selected here will correspond with the way the system will read and import the provided data.

I’ll select General Lease Info.

Enter the first date the import should run. You can also specify the start time.

You have the option to either stop the schedule on a particular date by entering that date or select the No end date check box to keep the import running.

Select the frequency at which to run the report. I’ll pick monthly.

Finally, select the SFTP Designation from the list.

When I click Save, the next occurrence of that schedule is added to the Scheduled list.

The flat files that this process uses to import lease information to Visual Lease require a specific format for each import file type. Contact our support team at support@visuallease.com for complete information.

In the History section, a Fail result could be because the SFTP designation was incorrect or perhaps there was an error with the .dat file. The results of importing or attempting to import each file are written to a new file and placed in the same folder. Successfully imported files are placed in a new folder called Completed.

To delete a schedule, click the trash can icon next to it. It will stop all future imports of that schedule.

That concludes our introduction to Imports in the Integration Hub!

To recap:

  • The Imports feature of the Integrations Hub starts with creating SFTP designations.
  • Create scheduled jobs to import lease information in specific platform areas. You can select the frequency and for how long the jobs should run.

Use the Imports screen to review the successful and failed import jobs.

Thank you for attending this course! If you have any questions, suggestions or feedback on this training video, please email us at Support@visuallease.com.

The post Integrations Hub: Imports appeared first on VL University.

]]>
https://visuallease.com/vluniversity/course/integrations-hub-imports/feed/ 0