What Is the CSV App Management Feature?

This feature lets you bulk configure and update the inventory information (contract information, costs, etc.) for each app in the App Inventory.

Note: This feature requires a contract for the SSO Free + SaaS Management plan or the SSO Pro + SaaS Management plan.
　For pricing, see here

Before You Begin

• This feature lets you update the inventory information for SSO apps and SaaS apps.
  Note that it cannot be used to configure SSO settings (bulk proxy password settings).
  Note: For steps on performing a bulk proxy password setting, see here
• For a list of the inventory information you can configure, see here.
• The CSV file you download for configuration reflects the
  sort order and show/hide settings from the App Management screen.
  If you want to configure or update a field that is currently hidden on the screen, make sure to show that field beforehand.
  

Setup Steps

1. Log in to TrustLogin, then from the Admin Page go to "Apps > CSV App Management."
   
   

2. Click the "Start Generation" button.
   

   A message indicating that CSV file generation has started will be displayed.
   
   

3. Once the CSV file is ready, the "Download" button becomes active.
   Click the button to download the CSV file.
   
   Note: You can also download the file from the URL in the
   　"App Inventory CSV File Ready Notification" email sent when the CSV file is ready.
   
4. Open the downloaded file.
   The list of apps that can be configured or updated is retrieved in CSV file format.
   
   
5. Enter the required values in the CSV file.
   To add a new app to the App Inventory, add a row to the CSV file and enter the required information.
   For details on the fields you can configure, see here.
   
   Note: If you enter only a number for "License Fee Unit Price/Monthly/Annual," it will be displayed in yen (¥).
   Note: Fields whose CSV header name has a "*" (listed below) are not updated. Editing their values has no effect.
   • Provisioning Status
   • Authentication Method
   • Total Number of Assigned Apps
   • Number of SSO-Assigned Members
   • Number of SSO-Assigned Groups
   • SSO App UUID
   • SaaS App UUID
   • Last Data Updated
     
6. After you finish entering the information, save the file.
   
7. From the TrustLogin Admin Page, use "Select File" → "Upload" to upload the saved CSV file.
   
   Processing starts after the CSV file is uploaded.
   

8. Processing is complete once the status changes to "Completed" and the completion time is updated.
   Check that the app information has been updated on the screen.

   
   
   Note: An "App Inventory Import Completed Notification" email will be sent to the administrator.

About Errors

Errors During Upload

If you use a CSV file other than the downloaded template, an error will be displayed during upload.
Edit the CSV file obtained via the "Download" button and upload it again.

Errors After Upload

If there is a problem with the content of the uploaded CSV file,
the status will change to "Failed" and a "Check Error" link will be displayed on the screen.

Click "Check Error" to download the error file, then check the content and make corrections.
For conditions related to input fields, see here.