{"id":26209,"date":"2019-08-07T16:50:24","date_gmt":"2019-08-07T20:50:24","guid":{"rendered":"https:\/\/mjtsai.com\/blog\/?p=26209"},"modified":"2019-08-07T16:50:24","modified_gmt":"2019-08-07T20:50:24","slug":"downloading-att-wireless-usage-data","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2019\/08\/07\/downloading-att-wireless-usage-data\/","title":{"rendered":"Downloading AT&#038;T Wireless Usage Data"},"content":{"rendered":"<p><a href=\"https:\/\/twitter.com\/cdespinosa\/status\/1158919474235363328\">Chris Espinosa<\/a>:<\/p>\n<blockquote cite=\"https:\/\/twitter.com\/cdespinosa\/status\/1158919474235363328\">\n<p>Thing 1 I have learned about AT&amp;T Wireless data plan usage download:<\/p>\n<p>You can download you usage for Excel, and it downloads as an .xls file&mdash;but it&rsquo;s XML, not BIFF.<\/p>\n<p>Thing 2 I have learned about AT&amp;T Wireless data plan usage download: <\/p>\n<p>You can download you usage as a CSV file, and it&rsquo;s saved by default as .csv&mdash;but it uses a vertical bar as the column delimiters, not a comma.<\/p>\n<p>Thing 3 I have learned about AT&amp;T Wireless data plan usage download: <\/p>\n<p>When you finally get the usage data into a spreadsheet, the values in the Usage column represent either kilobytes or megabytes, on a row by row basis. There&rsquo;s no scale indicator in the row data.<\/p>\n<\/blockquote>\n<p>I wish I could say this was the first time I&rsquo;ve seen mixed units in a column or a &ldquo;CSV&rdquo; file with no C&rsquo;s.<\/p>\n\n<p>Previously:<\/p>\n<ul>\n<li><a href=\"https:\/\/mjtsai.com\/blog\/2019\/08\/01\/why-unsubscribing-can-take-time\/\">Why Unsubscribing Can Take Time<\/a><\/li>\n<li><a href=\"https:\/\/mjtsai.com\/blog\/2019\/04\/02\/falsehoods-about-time-and-csvs\/\">Falsehoods About Time and CSVs<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Chris Espinosa: Thing 1 I have learned about AT&amp;T Wireless data plan usage download: You can download you usage for Excel, and it downloads as an .xls file&mdash;but it&rsquo;s XML, not BIFF. Thing 2 I have learned about AT&amp;T Wireless data plan usage download: You can download you usage as a CSV file, and it&rsquo;s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"2019-08-07T20:50:26Z","apple_news_api_id":"95047f80-0274-41b1-98db-7db7cc4aa771","apple_news_api_modified_at":"2019-08-07T20:50:27Z","apple_news_api_revision":"AAAAAAAAAAD\/\/\/\/\/\/\/\/\/\/w==","apple_news_api_share_url":"https:\/\/apple.news\/AlQR_gAJ0QbGY2323zEqncQ","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[2],"tags":[1394,986,1857],"class_list":["post-26209","post","type-post","status-publish","format-standard","hentry","category-technology","tag-att","tag-cellular-data","tag-csv"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/26209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=26209"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/26209\/revisions"}],"predecessor-version":[{"id":26210,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/26209\/revisions\/26210"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=26209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=26209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=26209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}