Transitioning to OnRent Events from another solution? If you can export data from your previous software, you should be able to use this as a basis for an import to OnRent Events.

Importing from another solution is generally a four-step process:

Look for an option to export data from your previous solution. This may be in reports or in your settings screen. It may be called “save data,” “run a query,” or “export”.

You’ll want to export to a spreadsheet, ideally CSV, but spreadsheet apps can save to CSV at a later point if this isn’t an option.

Once you’ve exported data, it’s time to cleanse the data. 

Your files will likely have customers that you no longer do business with, products that you no longer rent or sell, and other data that you don’t wish to retain. Run through your spreadsheets and delete any that you don’t need.

Depending on how your old solution stores data, you might also find that some data isn’t where it should be. For example, some legacy solutions don’t have options for notes, so staff might pop notes into address fields. The system will validate the information you import, so it’s important to make sure it’s all right.

After cleansing, you’ll want to make sure that your spreadsheet is in a format that the system can interpret.

You can grab copies of example import templates and check how they should be formatted in our guides, see: Example import files

We recommend working from two copies of files – your existing files and the new ones that you’re prepping for OnRent Events. This way, you always have a copy of your original data to hand.

Our import templates have certain column headings on them, and the import process is much easier if you match those. 

We’d generally recommend creating a few records in the system first, then heading to System Setup > Export Data and grabbing CSV files. This will give you a good feel for how the data you’ve input to the system will appear on import templates.

From here, copy and paste information from your old spreadsheets to your new ones.

The ID is the system's internal reference for a record. When adding new entries, leave the ID column blank. 

When your file is ready, save your spreadsheet as a CSV file and head to System Setup > Import Data to import it into the system.

The import tool will attempt to match column headings. Match any columns that weren’t mapped, so all the data you wish to import is green.

Hit Upload and you’ll receive an email that lets you know the status of the import after a few moments. If there are any problems, the system will let you know exactly which row caused a problem and how to fix it.

Importing data can be an intricate process. If you have questions, just start a chat with our customer success team, and we’ll be happy to help. Email us at help@current-rms.com or start a conversation using the green help bubble at the bottom-right ↘️