If you’re moving to OnRent Events from another system, you can bring your existing data with you. As long as your previous software lets you export data, you can use those files to create imports for OnRent Events.
Overview of the Import Process
Importing data generally involves four main steps:
Export data from your old system
Cleanse the data to remove or correct unwanted information
Prepare it for import into Current RMS
Save and import your files
Step 1: Export from Your Old Solution
Look for an option in your existing software to export data. This might appear under Reports, Settings, or as an Export or Save Data option.
Export your data into a spreadsheet format—ideally CSV (comma-separated values). If that’s not possible, most spreadsheet programs (like Excel or Google Sheets) can convert your file to CSV later.
Step 2: Cleanse Your Data
After exporting, take time to review and tidy your data:
Remove old or irrelevant records (e.g., inactive customers or discontinued products).
Check for misplaced information—some older systems may store notes or extra data in incorrect fields.
Ensure each column contains only valid and properly formatted data.
OnRent Events validates data during import, so cleaning up now helps avoid errors later.
Step 3: Prepare Your Data for Import
Once your spreadsheets are cleaned up, make sure they match the OnRent Events import format.
Download Example Import Templates
Grab example import files from our guide: Example Import Files.
These templates show how your data should be structured and labelled.
Match Column Headings
Use the same column names found in the templates.
For a quick reference, try creating a few sample records directly in Current RMS, then go to System Setup → Export Data. This shows how your data appears in the correct format. Then, simply copy and paste data from your old spreadsheet into the new template.
Leave the “ID” Column Blank
The ID field is automatically created by OnRent Events. When adding new records, leave this column em
Step 4: Save and Import
When your file is ready:
Save it as a CSV.
Go to System Setup → Import Data in Current RMS.
Upload your file.
The system will automatically match most column headings. If any aren’t matched, you can map them manually.
Once uploaded, you’ll receive an email notification confirming the import status.
If there are issues, the message will specify the row and error so you can correct it quickly.