Importing Trips from a CSV file

This is a guide to importing trips from any provider into your MediRoutes desktop app using a CSV file.

Step 1 - Navigate to Importing Trips

Click on the Import Trips Icon on the Home Tab. It is located below the passenger record, right under the red Trip Changes button, and looks like a paper with a blue down arrow.

Step 2 - Pick a Funding Source 

• Select the funding source to import trips under.
• Click Upload Trip File

• Pick the file in your Windows pop-up and click Open.
• Once you pick and open the file, the import process will begin. 
  
  

Common Trip File Data Errors 

Some data on CSV files may be considered "bad data" and can cause errors when you try to import the file. These are data issues from the file, created by the Broker or trip provider, so you will have to clean up the data by backspacing it from wherever it is located in Excel. If you are receiving an error when importing your file, reference the list below to see if there is anything in the file causing the error. 

• Special Characters, like , : | ' / # " " in the Comment or Notes sections on the file. These special characters can cause issue since this is a CSV (Comma Delimited) file, which is raw data separated by commas. These particular characters can cause data to be moved around and not be mapped to the right place, causing error messages. You will need to remove the characters from the CSV file before importing the trips into Mediroutes. This is typically done by backspacing them out of the file using Excel.
• Carriage returns or extra whitespace cause similar issues as the special characters. Again, because the file is a CSV (comma delimited) file, extra whitespace, such as tabs or carriage returns, can move the data on the file and cause errors. Carriage returns are when someone has entered down to the next line in the file without having filled up the previous line. This is typically seen in the notes or comments for a trip. Some notes or comments may have several pieces of information all on their own line. This will need to be cleaned up by backspacing the carriage returns and just separating each piece of information with a period and a space. 
• CSV UTF-8 file type. Some files will export to your computer as a CSV UTF-8 file type. This is not the same as the CSV (comma delimited) file type and will not work for importing into MediRoutes. To check the file type, you will need to open the file in Excel, click File in the top left, then click Save As on the left. At the top middle section of the Save As screen, you will see the file name and the file type. If the file type is listed as CSV UTF-8, you will need to select CSV (comma delimited) from the file type dropdown list and then save the file.
  
  

If all potential causes for errors listed above have been checked and/or removed from the file and you are still having issues, please contact MediRoutes Support. 

Revised Date: 8/23/24 ARB