Data Loader

The Clarizen Data Loader is a web based tool that does not require installation. It can be launched from within Clarizen so that no login is required. Just follow a few simple steps and the data you always wanted to see inside Clarizen will be available.

Specification: Integration Apps

Categories: IT, Marketing, Professional Services, Project Management, Research and Development

Capabilities: Data Integration

About This App

The Clarizen Data Loader is a web based tool that does not require installation. It can be launched from within Clarizen so that no login is required. Just follow a few simple steps and the data you always wanted to see inside Clarizen will be available.

Easy to use:

The Data Loader’s user interface is intuitive and easy to use. Feedback messages are also embedded to help track data issues in the process. In five steps you can load your data into Clarizen:

  1. Identify the Clarizen entity you want to load the data into
  2. Map the Clarizen fields to the ones available in your data file
  3. Create an Excel or CSV file with the field names in the headers and the data in the rows
  4. Open the Clarizen Data Loader from within Clarizen
  5. Upload the file and hit the update button

Data Types:

Any data type is supported, including reference to object various types. For example, you can: load cases and link them to a work item, add tasks within specific projects, add resources and reviewers in the imported work item and even load timesheet entries and link them to the relevant work items.

Tracking and Load History:

Once the load is complete, an email will be sent to your email address and a task will be created under a default project in your organization. The task will include attachments, the original data file and a messages log list from the load process and an undo file with the list of inserted objects. That way you will always be able to go back, track your actions and even rollback the transaction if required.

Technical specification:

Once the app is installed, your account will be updated with 3 new custom actions:

  • Organization – “Data Loader” – This action enables you to load any type of object into your organization
  • Project – “Work Plan Loader” – This action enables you to load any work item structure into the selected project
  • Task – “Rollback Load” – This action enables you to rollback an entire Load transaction to the specifically selected task. This custom action is only available for Super Users

API Support:

You can also activate this load process by invoking a SOAP web service

The interface function format is:

Public UpdateErrorNative Load(string sessionId, string fileName, string entityType, byte fileContent, bool validateOnly)

To activate this functionality, please contact your Clarizen representative

Limitations:

  • Before installing, please ensure your account has sufficient customization to allow this application to be installed
  • Please note that the application is limited and can only load files with up to 5K rows.
  • An alert message will be shown if a non Admin/ Financial User/ Super User, will try to use this app. Admins are encouraged to restrict the usage by adding these limitation on the Custom Actions.

Read more on Clarizen Data Loader

Video

Data Loader Video Thumbnail
Data Loader