Importing Data Into MPWEB
In this article:
Overview
Remove Existing Sample Data
CSV Import Instructions
Manage Imports
Overview
Instead of entering records into your MPWEB account manually you can import data using our CSV import process to quickly get your account up and running. You have the option of performing the import yourself using the directions below, or you can contact us at support@mtcpro.com to help you through the importing process.
We can import the following data:
Employee List
Equipment List
Inventory / Parts List
Vendor List
Maintenance Templates
You can find sample import templates via these links:
MPWEB-Employee-Import.csv
MPWEB-Equipment-Import.csv
MPWEB-Parts-Import.csv
MPWEB-Vendors-Import.csv
MPWEB_Template_Import
The following information can also be imported via CSV, but you must send us a sample file first in order to configure the import settings for you:
Fuel Transactions (unit #, date, meter reading, volume, unit price, vendor name, state)
Meter Updates (unit #, date, meter reading 1, meter reading 2)
Desktop Software Migration Assistance
If you are migrating from one of our desktop applications (such as Fleet Maintenance Pro), please get in touch with us at support@mtcpro.com and we'll assist with importing your data. We will need a backup .zip file of your existing database in order to import the data records to your MPWEB account.
Remove Existing Sample Data
When you first create an MPWEB account you will see some sample equipment and parts to help you test using the program. You can remove these sample records from the system, so that way only your equipment, parts, etc. are in the account.
To remove sample data, click the gear on the top right and go to Organization Profile.
Click the button to Remove Sample Data on the top left.
CSV Import Instructions
First, make sure you have downloaded and filled out the CSV templates listed in our Overview section. To perform the CSV data import, click the cloud icon with the up arrow on the top right. Choose the type of data you wish to import from the drop down.
The next screen will show some results from the CSV file. You will need to tell the systems what type of data belongs to each column using the drop down menus.
Once you have mapped all of the necessary columns, click the green Start button. The system will begin importing the data.
It will show processing at first, then the status will change to Complete. The system will let you know if any errors were encountered.
Note: You do not have to wait for the import to finish processing to continue using the program. You can leave the screen and the system will keep processing the file in the background. If you wish to check on the status of a previous import, click the cloud icon on the top right and choose Manage.
Here is an example of a successful import:
Manage Imports
To view previous imports, click the cloud icon with the up arrow and choose Manage.
Here you will be able to view any previously performed imports.
Click any import row to view details.
MPWEB has the ability to reverse imports for up to 72 hours via the Undo Import button on the bottom of this screen. This will remove any records from the import file from your system. This is particularly useful if, for example, you were importing equipment or parts and 'missed' a column, or assigned a column to a wrong value. You will be able to undo the import and re-import at a later time.