分页: 1 / 1

interesting journey familiar with google sheet

发表于 : 13 9月 2017, 15:21
riveryog
after learned from its official site, www.rememberthemilk.com, that its mainly a muslim supported family company, I felt need of my data portability. the client and site defied csv export, however, 2 days research online python tool, pyrtm, and a local converter, todotxt_import-master.zip at https://codeload.github.com/revl/todotx ... zip/master, I got my python environment on ubuntu running and finally got txt or csv exported. last day and overnight spent on cleaning data which has date errors. I spent near 10 hours cramming google sheet function/formula, aiming convert format "Week Mon-day" into "yyyy-mm-dd" among which passed years missing. I want to verifying year according the week information, such a common problem but few online community knowledge touched. mounting problems with the converting let me gave up in dawn and search for alternative ways to retrieve my data from the unfriend website. and my search rewards on ubuntu, the todotxt_import tool, a local niche working like a charm. then again there small portion of task to reformat well exported text in google sheet spreads in cells of different columns and rows, all stripes via google sheet functions from sole import of exported. my newly learned skill in last 24 hours helps a lot, and soon I satisfied with final dataset almost intact maintains original source of import, and published at once online onto to zhone web, ie : http://l.zho.io/lovesone or http://www.zuo.center/faezrland
God, dad, isn't it a wonderful journey re-enliven me in escort of powerful google? help me settle my golden memories in the todolist archive, and reinforce my workspace with newly adopted todolist managemental, toodledo at www.toodledo.com. in the new journey with toodledo, my data portable must be more promising!
read it at https://drive.google.com/a/warozhu.com/ ... sp=sharing, or get a copy from our site for offline study: https://zho.io/images/zsasset/file/yearstodolists.xls