Smart Upload Manager Frequently Asked Questions

Frequently Asked Questions (FAQ)

Overview

The Smart Upload Manager is a tool designed to help automate the import of data from CSV files into Kantata OX. You can use CSV files to create new records and update existing ones.

How do I access the Smart Upload Manager?

The Smart Upload Manager can be accessed by going to https://smartuploadmanager.com.

What objects can I upload files for?

The Smart Upload Manager currently supports the following Kantata OX objects:

• Account Memberships
• Assignments
• Cost Rates
• External References
• Holidays
• Holiday Calendars
• Holiday Calendar Associations
• Holiday Calendar Memberships
• Invoices
• Invoice Additional Items
• Invoice Fixed Fee Items
• Invoice Payments
• Expenses
• Groups
• Project Allocations
• Project Custom Field Values
• Project Group Custom Field Values
• Project Organization Memberships
• Project Participations
• Project Resource Custom Field Values
• Project Resource Skills
• Project Resources
• Projects
• Roles
• Scheduled Hours
• Skills
• Skills Memberships
• Task Custom Field Values
• Task Dependencies
• Task Followers
• Tasks
• Time Adjustments
• Time Entries
• Time Off Entries
• Users
• User Custom Field Values
• User Organization Memberships
• Workweek Memberships

Can I deactivate email notifications during the upload?

Yes. To deactivate email notifications for your account, go to the Account Settings page and then toggle the Account Email Notifications setting to Off. 

Can I queue up multiple files for data upload in a specific order, or can I schedule them to load at a specific time?

Multiple files can be uploaded into a single blueprint for processing. One file can be uploaded for each data set in Kantata OX. They will process in reverse order of dependency. Rows for each data set can process independently of other rows within the same file or rows between files.

Blueprints cannot be scheduled, however, they can be validated and processed at any time.

Can I run multiple blueprints at the same time?

Yes, you can run multiple blueprints at the same time. Please note that individual accounts have a limit of concurrent requests—which vary depending on the object type—that can be made to Kantata OX at the same time. For example, if multiple blueprints are actively loading tasks in SUM into an account, only 5 concurrent requests will be made to Kantata OX since the task object type limit is 5.

Why are requests to Kantata OX limited?

Smart Upload Manager limits the number of concurrent requests it makes to Kantata OX on a per-account basis to better balance performance and processing speed with API traffic. There are also API limits that limit how many calls can be made within a certain amount of time.

What are the concurrent request limits—per object type—when validating a blueprint?

Blueprint validations can run a maximum of 10 concurrent requests at a time.

What are the concurrent request limits—per object type—when processing a blueprint?

• Invoices: 1
• Project Participants: 1
• Custom Field Values: 2
• Tasks: 5
• Time Entries: 5
• Project Allocations: 5
• Project Resources: 2
• Projects: 1
• All other objects: 10 

Do I need to fill out every field in the CSV template in order to upload?

No, not every field is required to be filled out in order to be processed successfully. There are different required fields for creating objects vs updating objects. Refer to the Smart Upload Manager - Data Set Templates+ file for the required fields.

Can I archive or unarchive a project or a top-level parent task?

Yes. The Archived feature is available for project and task updates. The current best practice is to process the archiving and unarchiving of projects or tasks in separate blueprints. This ensures that all data can be updated before the archiving takes place.

Can I delete or clear a specific field in the object for a project or task?

CSVs uploaded with blank data in rows will be ignored. Deleting or clearing existing values is currently not supported.

What are the limitations for Trial accounts?

Trial accounts have access to all data sets available in SUM. Each data set's CSV file is limited to the first 200 rows. Any data after row 200 will be ignored.

How do I change the date format in a CSV to be in [YYYY-MM-DD] format if I'm editing the file in Microsoft Excel?

The Smart Upload Manager supports the [ISO 8601] Date Format. By default, most computers use Microsoft Excel for editing CSV files. Microsoft Excel typically auto-formats the date once it recognizes you have entered one.

In a case where Microsoft Excel may not auto-format the date, you can change the date format manually by doing the following:

1. Select all applicable Date Fields.
2. Right-click and select Format Cells from the drop-down. The Format Cells window appears.
3. Choose Custom from left-hand list of options.
4. Within the Type field, enter the desired formatting: YYYY-MM-DD.
5. Click OK. The date formatting updates within the CSV.
6. Save the CSV file.

Can I specify multiple selections in my CSV file for custom fields that allow multiple choices?

Yes, specifying multiple selections in multi-choice custom fields is supported. The desired choices must be entered in the same cell.

These choices must meet the following specifications:

• Comma-separated.
• Inside square brackets.
• No spaces between choices.

Can I use the Smart Upload Manager to update users that are not on my Kantata OX account?

No. Just like in the user interface, you can only update users who are on your Kantata OX account.

Can I leverage the Smart Upload Manager to update inactive users on my Kantata OX account?

Smart Upload Manager does not currently support activating or deactivating users.

What happens if my computer crashes or I close my browser while the blueprint is validating or processing?

Once your file is loaded to your data set, the validation and processing take place on the Kantata side. These processes are not dependent on your computer or connection. This means you may log in and out as desired. However, you will have to be logged in to view the status of your blueprint or to make any changes to it.

Is there a row limit per file for each data set or blueprint?

There isn’t a hard limit on the number of rows a CSV file may contain. The recommended maximum limit is 50,000 rows per data set.

How long does validation take?

Validation is an involved process. The validator checks the data in the uploaded file—the data in Kantata OX—and the data in the other data sets of the blueprint. This is in an effort to ensure a successful upload.

While there is no set time frame, this process may take a decent amount of time to complete. In general, the more rows and data sets in a blueprint, the longer validation will take.

How long does processing take?

Processing time is primarily dependent on the Kantata OX API. The Smart Upload Manager is able to utilize a high concurrency to import data quickly. The Kantata OX API has rate limits specific to different endpoints which may affect processing time. While there is no set time frame, the more rows and data sets in a blueprint, the longer processing will take.

What if there are validation errors?

When validation fails it is indicated by a red exclamation mark within each Data Set tab. The indicator icon appears with an error message(s) in-line for each row that failed validation.

A new CSV file—with the errors resolved—can be uploaded to each data set that had errors. The whole blueprint can then be run through the validation process again.

What if there are processing errors?

Despite having successfully completed the validation step, processing can still generate errors. This can happen if you are connected to a live Kantata OX environment with users actively in the system.

Similar to the validation step, if the rows are unable to be processed they will be indicated by a red exclamation mark. This indicator is located within the Data Set tab in-line with the row that failed processing.

How will I know that validation or processing is complete?

The Smart Upload Manager will display the validation and processing status on-screen indicating that validation and processing are complete or if any failures occurred.

If validation completes without errors, can my blueprint automatically begin processing?

Yes, if you check the Auto-process checkbox before starting validation. Checking this box will allow the blueprint to automatically begin processing if validation completes without errors. Please note that you cannot check the Auto-process box after validation has begun.

Is the order of the tasks in the spreadsheet the same order that appears in the project?

When created, tasks will be loaded into Kantata OX in the order they are listed in the CSV file as long as there are no nested tasks (subtasks).

If there are subtasks in the CSV, the tasks will be created under their indicated parent task respective to the order listed in the CSV.

What is an external reference?

An external reference is a way to identify objects in Kantata OX based on an ID or key not created by Kantata OX. They can be thought of as "tags" for Kantata OX objects.

When creating or updating objects in the Smart Upload Manager, you can "tag" external references for those objects at the same time using the external_id column.

Listed below are examples of different values in their respective columns and their "tags":

• external_id column = service_model_ref
• service_name = Smart Upload Manager
• Service Model = [API Object Name]

Who can access SUM and what permission level is needed?

Users do not need a specific permission to access SUM. SUM will upload data based on the user permissions of whoever is using it. If a user with low permissions is using SUM, they will only be able to create/edit objects they have access to via UI. It is recommended users have an Account Administrator permission level in Kantata OX when using SUM as it allows the greatest use of the product.

How can I apply templates to projects?

Templates can be applied to projects via the Projects data set. You can specify the Template ID using the Project Tracker Template ID column when uploading your file. There are other template-specific columns that can help determine where in the Work Breakdown Structure (WBS) your template is imported and when it begins. Consult the Project Reference Sheet in the Smart Upload Manager Data Set Templates+ document for more information.

How long are Blueprints (and data sets) kept in SUM before being deleted?

Blueprints, and their data sets, are deleted 100 days after their creation date.

Can I upload external references independently from creating or updating objects?

Yes. SUM supports creating and updating external references directly, including for objects not available as data sets. All objects that support external references in Kantata OX are supported in SUM.

Troubleshooting Common Exceptions

Issue: ["Not Found"]

Issue: Effective_date must be given in ISO-8601 format (YYYY-MM-DD)

Issue: Required field is missing