{"id":264,"date":"2017-09-09T02:15:21","date_gmt":"2017-09-09T02:15:21","guid":{"rendered":"https:\/\/blog.tanklogix.com\/?p=264"},"modified":"2017-09-20T16:31:53","modified_gmt":"2017-09-20T16:31:53","slug":"new-version-manual-csv-upload-tickets-1-2","status":"publish","type":"post","link":"https:\/\/blog.tanklogix.com\/index.php\/2017\/09\/09\/new-version-manual-csv-upload-tickets-1-2\/","title":{"rendered":"Manual CSV Upload Tickets 1.2"},"content":{"rendered":"<p>We have added two new fields to the CSV upload process with this new<strong> Version 1.2:<\/strong><\/p>\n<ul>\n<li><strong>NOTES<\/strong> (25-character text-string field for comments)<\/li>\n<li><strong>WATER TYPE<\/strong> (integer enumeration \/ list to identify different types of water:<\/li>\n<\/ul>\n<p>0=Unidentified (default)<br \/>\n1=Pit<br \/>\n2=Flow Back<br \/>\n3=Produced<br \/>\n4=Other<br \/>\n5=Dirty Water<br \/>\n6=Fresh Water<br \/>\n7=Mud<br \/>\n8=Pipeline<\/p>\n<p>9=Scavenger<\/p>\n<p>&nbsp;<\/p>\n<p><strong>We have also added the ability to send the Customer ID and \u00a0Driver ID data in as two separate columns (as in the original design), or as a single combined column (new).<\/strong><\/p>\n<p>Also in this final production version 1.2:<\/p>\n<ul>\n<li>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.<\/li>\n<li>Small changes in wording of UI<\/li>\n<li>Bug fix: corrected problem with loading a single row in CSV file<\/li>\n<li>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)<\/li>\n<li>Added email notification of all successful loads<\/li>\n<li>Version 1.0 (13-column version) has been removed from menu and from blog.tanklogix.com<\/li>\n<li>Version 1.2 has replaced version 1.2 (RC) (1.2 is now full production version)<\/li>\n<\/ul>\n<p>This post will discuss the second option &#8211; uploading a .CSV file you have prepared on your personal device to the TankLogix Portal. Four document links will help you in this:<\/p>\n<ul>\n<li>A CSV File Upload specs document detailing exactly how the file should be crafted.<\/li>\n<li>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\u00a0to a .csv file, you may have some blank rows in your .xlsx file and the end, rows that you don&#8217;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&#8217;ll see the comma placeholders: \u00a0,,,,, 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.<\/li>\n<li>A Web User Guide &#8211; the Portal page you can use to actually upload your .CSV file.<\/li>\n<\/ul>\n<p>The following documents will guide you in your preparation:<\/p>\n<p><strong>CSV File Upload Specs Version 1.2:\u00a0<a href=\"https:\/\/blog.tanklogix.com\/wp-content\/uploads\/2017\/09\/TankLogix-Manual-Transaction-Ticket-Specs-V3.pdf\">TankLogix Manual Transaction Ticket Specs V3<\/a>\u00a0<\/strong><\/p>\n<p><strong>Sample .CSV file Version 1.2 to use having Customer ID and Driver ID as separate columns:\u00a0<a href=\"https:\/\/blog.tanklogix.com\/wp-content\/uploads\/2017\/09\/TankLogixModelUpload15ColumnV3_CustDriver2Col.csv\">TankLogixModelUpload15ColumnV3_CustDriver2Col<\/a><\/strong><\/p>\n<p><strong>Sample .CSV file Version 1.2 to use having Customer ID and Driver ID as one combined column:\u00a0<a href=\"https:\/\/blog.tanklogix.com\/wp-content\/uploads\/2017\/09\/TankLogixModelUpload15ColumnV3_CustDriver1Col.csv\">TankLogixModelUpload15ColumnV3_CustDriver1Col<\/a><\/strong><\/p>\n<p><strong>Web Page User Guide Version 1.2: \u00a0<a href=\"https:\/\/blog.tanklogix.com\/wp-content\/uploads\/2017\/09\/TankLogix-User-Guide-Manual-Ticket-Uploads-15-V3.pdf\">TankLogix User Guide &#8211; Manual Ticket Uploads 15 V3<\/a><\/strong><\/p>\n<p>Should you need assistance, please contact us via email at <strong>support@tanklogix.com<\/strong> and supply your contact information. We&#8217;ll get back with you!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &nbsp; We have also added the ability [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[4,3,6],"tags":[],"class_list":["post-264","post","type-post","status-publish","format-standard","hentry","category-portal","category-tutorials","category-version"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8PMuw-4g","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/posts\/264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/comments?post=264"}],"version-history":[{"count":8,"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/posts\/264\/revisions"}],"predecessor-version":[{"id":281,"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/posts\/264\/revisions\/281"}],"wp:attachment":[{"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/media?parent=264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/categories?post=264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.tanklogix.com\/index.php\/wp-json\/wp\/v2\/tags?post=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}