The Replicon Import Add-in (RIA) is an Excel add-in you can use to import data into Replicon. It can be used for the following:
Refer to Common RIA use cases for more information on what you can do with RIA.
See https://ria.replicon.com/WebSetup/TemplateInfo.html for a list of all data templates RIA can import.
You can also use our in-app data import feature to add, edit, or delete projects, tasks, clients, project and task assignments, users, holidays, activities, and groups. It doesn't require installation, and is supported for use on Macs.
Changes you make using RIA cannot be reversed. Therefore, use caution when working with RIA, as it allows you to easily make changes to large amounts of live data that cannot be undone.
Making bulk changes using RIA can impact the performance of the Replicon system. If you are importing lots of data, we'd appreciate it if you'd carry out your import outside of standard business hours.
RIA allows you to import data into your Replicon instance using an Excel spreadsheet. Adding and updating data using a spreadsheet is faster and easier than making manual changes directly in the Replicon interface.
RIA is especially useful if many items you’re adding or updating share the same settings. For example, if many users share the same permissions, you can create an import entry for one user, then copy the permissions to the others.
To import data, you'll need to set up a RIA template that includes the data, and then click a button to import it. To add data to the template, you can copy and paste data from an existing spreadsheet or you can use RIA’s built-in data input features and create a new template from scratch.
RIA includes several features that make populating a spreadsheet with data easy. For example, the add-in retrieves all valid values for a field from your Replicon instance for you to choose from, and can also automatically populate update templates with existing field values.
Using RIA has the following prerequisites:
Runtime framework requirements
To install RIA:
For information on setting up RIA and carrying out imports refer to:
We frequently update RIA with new features and functionality. If a new version is available, RIA will automatically update to that version when you log in.
Click the What’s New button in the RIA top menu for information on improvements we’ve made to the add-in.
To send feedback about RIA, click the Feedback button in the RIA top menu and complete the dialog that displays.
If you’re reporting an error, select the sad face button, and click Capture Error Details.
RIA will save to your desktop a CSV file including details of your latest import attempt. Attach this file to the feedback email before sending it to firstname.lastname@example.org to help us identify the problem you encountered.
You can also make requests or suggestions regarding RIA in the Replicon community.
No. RIA acts like an extension of the application, so once you’ve logged in to RIA, permissions in the add-in work exactly the same way as they do in the Replicon application – you can only perform actions allowed by your assigned permissions. An import error will occur if you attempt to import data for a field you’re not allowed to modify in Replicon.
In general, the Add templates overwrite existing data, and Update templates edit or append data.
When you use an Add template, all existing data will be overwritten for the record in question. For example, if you add a timesheet and hours have already been entered in Replicon for that timesheet period, those hours will be overwritten. The only exception to this is the Tasks import; if you add tasks, they will be appended to existing tasks.
If you use an Update template, only the data you selected will be updated. And in the following cases, the new data will be appended the existing settings:
These steps outline the suggested order for importing data into Replicon, taking data dependencies into consideration. For example, these steps indicate that you must create activities before assigning them to users, and that you create users before creating their timesheets.
If you only need to add or update a particular type of data, you can ignore this sequence. However, be aware that if data you’re adding or updating is dependant on data that doesn’t exist in Replicon, you won’t be able to complete the import.
No, RIA can only be used with the latest version of Replicon. Older versions of Replicon have their own import tools.
No. RIA doesn’t support use with the Mac operating system.
No, RIA doesn’t have an audit history feature.
No, it’s not possible to revert changes you’ve made using RIA.
Depending on the version of Excel you’re using, you may need to click Add-ins in the Excel menu for the RIA menu to display. To make the menu display by default when Add-ins is selected, click the icon in the top, right-hand corner of Excel, and select Show Tabs and Commands.