PILOT FUEL CARD CSV
I see you've added new templates for loves and efs fuel cards. Can we do the same for pilot. Having to copy and paste from the pilot excel to the tms template is very tedious.
-
Official comment
The Pilot fuel card template was added to the fuel card importer.
-
No answer to this question speaks volumes. It would be very easy for them to allow each customer to setup the fuel dashboard on the truckingoffice page to whatever they use. Done, it would work for everyone.
2 -
Exactly. Pilot is one of largest fuel providers and having to copy and paste the info for multiple trucks to import fuel is very tedious. They have templates for other fuel cards. Should be a easy fix.
2 -
The Pilot / FlyingJ fuel cards are by EFS. Did you guys try the EFS template?
1 -
I can definitely try it. My pilot card comes directly from pilot so I didn't know it's the same format or under the efs umbrella. I'll try it and let you know.
2 -
Where do I find the efs template? I see the trucking office csv sample download.
1 -
That is a drop down menu. Just click on that, and you will see the other options.
2 -
That didn't work. Would you like a report from me to view?
1 -
Yes please. Send it to support@truckingoffice.com.
2 -
I'll send it now. It could be user error but anything to make the import easier would be great.
2 -
When you export it can you make sure it is a CSV? The file that you sent me is not a CSV. It is in Microsoft format which ends in .xlsx
2 -
So I sent in my .CSV file and they went over it and I got this email back as follows:
"Thank you for the email. The developers are looking into adding more integrations for our fuel card import feature. We appreciate your business as well as your patience! In the meantime, if you transfer the information to our sample file spreadsheet, you can import the spreadsheet into the expenses column.
Please let us know if you need anything else!Stephanie Gibbons"
I understand that there's an unlimited number of ways that different fuel cards will lay out the information for each customer, which is why I think having trucking office make a spreadsheet where each individual user can change the values on each column to fit whatever solution they use and what works for them. By using the sample template that you supply I lose all of the other information that my fuel card gives me, like invoice number, price per gallon, DEF, miscellanies oil, anit-freeze, time and location of sales.
I appreciate the attention being brought to the issue now, as I see it being a big issue as its one of the larger expenses and keeping track of it is very important and can get out of control very fast the more trucks and drivers you have running. So I can enter the the .CSV file now, but its severely limited as to the information my fuel card gives me, and its so much more in depth than what trucking office will accept.
So for now I have to keep a separate file so I can go back and compare and or print out files to compliment the little information trucking office retains. I'm a new user, so far this is really the only major issue I've run into so far. Thank you for making a really great tool for us little to medium guys and working every day to make this great tool better. I will be a customer for life as I see you really are trying to make it easier for all of us, and for that I thank you.
2 -
Very valid point. The trucking office sample doesn't account for my other fuel card expenses. Hopefully now we will get some progress on this issue.
2 -
I think they will address the issue as fuel, Def, oil, tires, etc., and anything else you can use a fuel card for is so important and one of the larger, if not largest expenses you can incur each week. Without accurate reports, the service they offer will really suffer and you'll have people and customers looking elsewhere for a solution.
Even if they offered the efs fuel card template for us to use, I'm sure it has more than the standard csv file they offer now, which really isn't much. I see it as a very simple fix that each user can customize specifically for themselves and the application they use. Once that's addressed and fixed, you'd be silly to look elsewhere as this would be an all in one solution.2
Please sign in to leave a comment.
Comments
14 comments