Manual CSV Upload Tickets 1.2

by | Sep 9, 2017 | Portal, Tutorials, Version |

We have added two new fields to the CSV upload process with this new Version 1.2:

  • NOTES (25-character text-string field for comments)
  • WATER TYPE (integer enumeration / list to identify different types of water:

0=Unidentified (default)
1=Pit
2=Flow Back
3=Produced
4=Other
5=Dirty Water
6=Fresh Water
7=Mud
8=Pipeline

9=Scavenger

 

We have also added the ability to send the Customer ID and  Driver ID data in as two separate columns (as in the original design), or as a single combined column (new).

Also in this final production version 1.2:

  • Clarification: If you have coded your CSV file with single-column customer id and driver id combined, if the customer id portion (left-most 4 characters) is blank, the default setting will pad 0000 left-zero-fill the customer id.
  • Small changes in wording of UI
  • Bug fix: corrected problem with loading a single row in CSV file
  • Added logic to remove blank rows from CSV. These are sometimes found at end of CSV (hard to see visually for customers unless they view the CSV with text editor)
  • Added email notification of all successful loads
  • Version 1.0 (13-column version) has been removed from menu and from blog.tanklogix.com
  • Version 1.2 has replaced version 1.2 (RC) (1.2 is now full production version)

This post will discuss the second option – uploading a .CSV file you have prepared on your personal device to the TankLogix Portal. Four document links will help you in this:

  • A CSV File Upload specs document detailing exactly how the file should be crafted.
  • Sample .CSV files that is also downloadable as a model of what the CSV file should look like when you upload in the Portal. You will find a sample screenshot inside the CSV File Upload specs doc that will show you what the CSV file should look like when you open it in a text editor. Sometimes, for example when saving a .xlsx to a .csv file, you may have some blank rows in your .xlsx file and the end, rows that you don’t realize are there. They are hard to see or detect in the .xlsx file. They will be readily visible in the .csv file because you’ll see the comma placeholders:  ,,,,, where there is no data in the row. The .csv is an exacting file, but well worth the final text-editor checks to save you time in the long run.
  • A Web User Guide – the Portal page you can use to actually upload your .CSV file.

The following documents will guide you in your preparation:

CSV File Upload Specs Version 1.2: TankLogix Manual Transaction Ticket Specs V3 

Sample .CSV file Version 1.2 to use having Customer ID and Driver ID as separate columns: TankLogixModelUpload15ColumnV3_CustDriver2Col

Sample .CSV file Version 1.2 to use having Customer ID and Driver ID as one combined column: TankLogixModelUpload15ColumnV3_CustDriver1Col

Web Page User Guide Version 1.2:  TankLogix User Guide – Manual Ticket Uploads 15 V3

Should you need assistance, please contact us via email at support@tanklogix.com and supply your contact information. We’ll get back with you!