interesting journey familiar with google sheet

Note:

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, 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!


benzrad daily todo lists / agenda since his web log and old family brings world the biggest gift, woz 楚甲主, since the birth of the Son's 1st child, exported from remember the milk web site which defies csv export. here exported with pyrtm and sorted in google sheet. publish here for golden memories of zhone Royal China in hard times and spontaneous joyful life stream under saint shines.
Now with settled museum of those innocent era, the Royal China archive more solidated and wonderful. let the life stream floats forever on berth of the Earth planet.

Get a copy of the archive.



riveryog的头像

last Friday water heat system started rolling. I also felt blackout with boring agenda and time to kill. hope this year end not so poor financially. I however, launched to prepare myself entertainment indoor: steam games.
this morning visited woz, dearest son earlier than usual, near 8am. in idle I started to browse steam store. I told myself if there are titles less than $2, I will buy interested ones. then I saw my long time regret not tried game, "Homefront". in minutes I enlisted it under my son's account. I also bought "Red nation" later, a zombies game which will drive my son away for the dirty bloodiness according his habit.

after luncheon and showered in public spa, I tried again a zombie game free gained during its promo. its not action packed, nor time sensitive, so I can play it like learning a multimedia works. after gaming I felt it quite satisfying.

God, cold and shameless reality in nowadays PRC really speechless. we Chinese blame nobody but pray our redemption sooner get, esp in mercy of Christian God's salvage, upon the wrong road our last generations chose, and fake faith lasts thousands years & enslaves the arid eastern Asian earth more futile than wasteland.

riveryog, 旎宫嘉坊
www.riveryog.biz

在线用户

当前有0个用户在线。

新进用户

  • riveryog
  • agarten

Default 快捷方式