interesting journey familiar with google sheet

zho.io, Zhong in relation 往来中文, bring China abreast 21 Century with world democracy.
http://zho.io
回复
头像
riveryog
帖子: 96
注册: 13 4月 2016, 15:15
地址: Faezrland天下主家
联系:

interesting journey familiar with google sheet

帖子 riveryog » 13 9月 2017, 15:21

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
riveryog.biz 旎宫嘉坊
http://riveryog.blog.163.com

回复