OpenRMA Documentation


Welcome to OpenRMA Documentation Guide.   OpenRMA

OpenRMA is a simple, yet powerful software for all kind of technicians and repair shops that needs to keep track their RMA services , jobs, repair works.  

OpenRMA works with with a MySQL Database system Cloud based or local based to hold all the information about your customers, repairs, inventory and more.  

Just enter your customer details, the product fault description and you are ready to print forms, print parcel labels, thermal tickets, email customer and all the actions your repair shop needs.  

As simple as it is.

Back To Top


OpenRMA System Requirements. In order for OpenRMA to run Smoothly we recommend the following minimum system requirements:  
Supported Operating Systems
  • Microsoft® Windows® 7 operating system
  • Microsoft® Windows® 8 operating system
  • Microsoft® Windows® 8.1 operating system
  • Microsoft® Windows® 10 operating system**
Required Software
  • .Net Framework® 4.5 or later version.
  • mySQL ® Database Server 5.5 or Later
CPU 32-bit and 64-bit Intel® or AMD® multi-core processor
Graphics Card Hardware Any graphics cards with at least 1280x1024 or higher resolution
RAM 2 GB of RAM (4 GB recommended)
Disk Space 500 MB of free disk space for install
Screen Resolution 1680 x 1050 and Higher
*On computers with Microsoft Windows 7, 8, 8.1 and 10 Operating System we recommend to run the program with Administrator privileges (Right click Run as Administrator).

Back To Top

OpenRMA installation video

Here is a 2 minutes installation guide.       Next proceed with the Configuration guide.

Back To Top

OpenRMA Configuration

How to configure OpenRMA Software to work on your own Computer Database or in the cloud.

  1. Press the Settings Button from the login screen (if you have a Professional or higher editions purchased) or click Setting Panel button on the left of the Main Program Screen.
  2. When you are into the Settings screen, you need to enter the correct database connection details (Database Communications Settings Box on the upper left corner of the settings page).
We have 2 common scenarios here.
  • Scenario a) Local database use. This is if you host your own local computer database server and you want the data to be on your own local or localnetwork computer.
  • Scenario b) Cloud database use (This applies when you purchase a cloud database from us).
b) This applies to scenario b. that you have purchased our cloud database option. In that case, you have received your database connection details via email after the purchase. All you need to do is to copy and paste the database connection details from your email to the Database communication settings here in settings panel. After you have entered the details (Hostname/IP, Database User, Database Password, Database Name) click on Test Connection button to make sure the details you entered are correct. If the connection was successfuly click the Save button. After that you are ready to go. Default username and Password to login from the login screen is admin and admin.    

a) This applies to scenario a. If the case scenario for your setup is the Case a then follow these steps to setup the database on your local or networked computer you have.

  1. Open the Settings Window.
  2. Make sure you have the following settings on the Database Communication Settings (upper left side of the settings window).
  • Hostname/IP: localhost
  • Database Username: root
  • Database Password: openrma
  • Database Name: openrma
Finally click the Test Connection Settings Button. If the connection was success click save and you are ready to use the software. If in any step you see any error, or you couldn’t install and configure on your computer, you should contact our support department and a certified technician will help you installing and configuring the software on your computer for free. *Note: If you have an existing MySQL Database Server installed you need to conctact our support so a technician can configure the software for use on your environment.

Back To Top

Activating Software License

Activating OpenRMA Software See the video tutorial bellow or read the manual instructions.     After a valid purchase of OpenRMA Repair Centre Standard or Professional edition, you will receive an email with your license file that activates your software permanently. Save the license file anywhere (for example on Desktop) and then OpenRMA Software and go to Menu Help ---> Apply License/Activate Software. OpenRMA Activation Step1 A new window will open so you can select your license file you saved before. To select your file we sent you via email click on the Apply License Button and select the license file. After validation of license file the program will Open Automatically activated without any other restrictions. OpenRMA Activation Step2 If you have Purchased Professional edition and have a number of Volume Licenses pre-activated for specific computers, just enter your Name, Company, Email (The email you used to purchase the software licenses) and hit Request Activation button. If the user details are correct, the software will be activated automatically for you. If you still have trouble, activating your software you can open a Support Ticket by clicking here.

Back To Top

Devices and trouble lists

Adding common problems to quick troubles list and Common devices to quick devices list   Common problems to quick trouble list. When you first check-in a customer, you can quick select from a common list of usual troubles or fault descriptions so you don't have to type it all the time (for example display not working or Display Replacement, format Computer and so on).   Common devices to quick devices list. Also when you type what type of device comes for repairing (for example iPhone7, Samsung Galaxy s8 edge etc.) you can also select a device from common devices list. The list is show as you type if Product name field. To change the devices and descriptions on both lists you have to edit the 2 text files (Devices.txt and Problems.txt) located in OpenRMA Installation directory (by default is C:\Program Files (x86)\OpenRMA Standard) or From menu Edit select Devices Quicklist or Troubles Quicklist. The file will open with Notepad program so you can edit the listings you want. If you accidentally deleted the file, the program will ask you to create it. Just select yes. Add one device or trouble per line. Save them and restart OpenRMA program. Your new devices and trouble will automatically populated on lists.  

Back To Top

Backup / Restore Database

Backup OpenRMA Data In order to backup the database, you have to go to settings, then database management tool. You will see the above menu. From this menu you can press the "Backup OpenRMA database" button and a backup dump (.sql file) will be created on OpenRMA folder inside the users Document directory. For example "c:\users\<username>\Documents\OpenRMA" folder. This is a complete backup with all data used by OpenRMA (Customers, Services, Attachments, Settings and so on). You can use this backup file (.sql file) to restore to a second OpenRMA instance machine.   Restore OpenRMA backup file To restore a backup file, press the "Restore OpenRMA Database" button. A new Dialog window opens and ask you to select a backup file to restore. After selecting your file a warning window appears and warning you about restoration. WARNING: This action will DELETE all data of the program (customers, services, attachments and so on) and it will restore the data from the backup file. So it is wise to backup your database first.   OpenRMADB

Back To Top

Add Custom RMA Forms

Changing default RMA Print form. New version of OpenRMA now loads default print form from the form folder inside the Application Installed Directory. Default location is ""C:\Program Files (x86)\OpenRMA Standard\". Inside the forms directory you will see the "default_en-US.jpg" image file. This is the default RMA print form in English format. You can use any image editing tool  to customize the appearance of the image. Edit you own Banner and/or change your terms and conditions printed. Note: Do not change the place of the fields (name, address telephone etc.) because these are by default printed on this location. If you wish you can sent us an email to [email protected] and sent us your default header logo and terms and conditions and we will generate your custom RMA form.

Back To Top

Creating New RMA Service

Video Tutorial to create a new RMA Repair Service.     Creating New RMA Service To create a new RMA Service, first you must fill the customer details on the Main Screen. First Name and Last Name  are the minimum required fields that you have to enter in order to save the new client. When you are done with all the customer details, press the Save customer Button. Next step is to fill the RMA Service Information (Product type, Condition, Accessories, Problem Description and so on.) When you are done with the Service Details Press the Save RMA button. Now the new RMA Service have created and saved into the database. That was the process of creating a new RMA service. Now for adding additional Technician notes later when a technician starts to repair this service, you may press the Services Tracking button on the left. The RMA Services Management form open and you can search for a particular service based on RMA ID, telephone, Serial number and/or customer name. When you find you service double click it from the list on the bottom and all the fields will populate with the service details, so you can modified as needed. When you are done with this Repairing you can check the RMA Finished checkbox so you can filter your results later.

Back To Top

Manage existing RMA Services

Video Tutorial to manage existin RMA Repair Services.     After you have opened a RMA service for a customer you or your technician may start repairing and fill the required details, information for their reference. For example the Technician inspection result, working hours and other useful information required by your Tech store. To do this you need to open the Services Tracking from the left of the main screen. You can press the search button to search all the RMA from the database or you can filter the service you want to search and work on. For example you may want to scan with the barcode scanner the rma id on the printed form of a particular RMA and then you are ready to work and fill all the details you need. You can also search a service by serial number, customer phone, name. Finally after you have finished you work you can save the RMA by clicking on Save button.    

Back To Top