> ## Content Index
> Fetch the complete content index at: https://www.oransblog.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to collate all my online data! Graphs Galore!
- URL: https://www.oransblog.com/timeliner-data-collation/
- Published: 2021-03-21T21:45:50.000Z
- Updated: 2026-10-29T05:57:15.000Z
- Description: My is goal is to combine all my data i generate online into one source
- Author: Oran C
- Tags: coding, data, data visualization, life, #Import 2026-11-12 01:14

Im trying out [timeliner : All your digital life on a single timeline, stored locally](https://github.com/mholt/timeliner?ref=oransblog.com)

goal is to combine all my data i generate online into one source

```bash
cd ~
bash
git clone https://github.com/mholt/timeliner.git
cd timeliner

```

## how to install go

[How to Install GoLang (Go Programming Language) in Linux](https://www.tecmint.com/install-go-in-linux/?ref=oransblog.com)

### error and fix for go install

#### didnt have gcc i used [tdm-gcc](https://jmeubank.github.io/tdm-gcc/download/?ref=oransblog.com) which worked!

```bash
cd cmd/timeliner
go build
ls
./timeliner -h

```

# how to add sms backup (android only) to my timeliner database

[Data Source: SMS Backup & Restore · mholt/timeliner Wiki](https://github.com/mholt/timeliner/wiki/Data-Source:-SMS-Backup-&-Restore?ref=oransblog.com)

```bash
timeliner add-account smsbackuprestore/1234567890
timeliner add-account smsbackuprestore/1234567890

/mnt/c/Users/oranm/github/timeliner/cmd/timeliner/timeliner add-account smsbackuprestore/1234567890

/mnt/c/Users/oranm/github/timeliner/cmd/timeliner/timeliner import /mnt/c/Users/oranm/Downloads/sms-20210314004348.xml smsbackuprestore/1234567890

 mkdir ~/time_line_dir
 cp sms-20210314004348.xml ~/time_line_dir/
 cd ~/time_line_dir/

```

## [How to Add a Directory to Your $PATH in Linux](https://www.howtogeek.com/658904/how-to-add-a-directory-to-your-path-in-linux/?ref=oransblog.com)

```bash
export PATH=/mnt/c/Users/oranm/github/timeliner/cmd/timeliner/:$PATH
source $HOME/.profile
timeliner -h

timeliner add-account smsbackuprestore/1234567890
timeliner import /home/wisemonkey/time_line_dir/sms-20210314004348.xml smsbackuprestore/1234567890

```

# how to add google location history

#### go to [takeout.google](https://takeout.google.com/?ref=oransblog.com)

### how to view outputed sqlite database [SQLite Viewer](https://inloop.github.io/sqlite-viewer/?ref=oransblog.com)

![](https://www.oransblog.com/content/images/2021/03/image-14.png)

![](https://www.oransblog.com/content/images/2021/03/image-15.png)

![](https://www.oransblog.com/content/images/2021/03/image-16.png)

![](https://www.oransblog.com/content/images/2021/03/image-17.png)

![](https://www.oransblog.com/content/images/2021/03/image-18.png)

![](https://www.oransblog.com/content/images/2021/03/image-19.png)

![](https://www.oransblog.com/content/images/2021/03/image-20.png)

![](https://www.oransblog.com/content/images/2021/03/image-22.png)

```bash
timeliner add-account google_location/<GMAILADDR>@gmail.com
timeliner add-account google_location/example@gmail.com

timeliner import /path/to/takeout.zip google_location/you@gmail.com

timeliner import /home/wisemonkey/time_line_dir/takeout.zip google_location/example@gmail.com

timeliner import ./takeout.zip google_location/example@gmail.com

```

![](https://www.oransblog.com/content/images/2021/03/image-30.png)

an error i got, turns out i was trying to import a .zip instead of a .json!

![](https://www.oransblog.com/content/images/2021/03/image-24.png)

rename from "Location History.json"

![](https://www.oransblog.com/content/images/2021/03/image-25.png)

To "location\_history.json"

```bash
timeliner import ./location_history.json google_location/example@gmail.com
```

![](https://www.oransblog.com/content/images/2021/03/image-35.png)

run the import command

![](https://www.oransblog.com/content/images/2021/03/image-27.png)

setting up a config file for connections to oauth services EX: facebook, or twitter 

![](https://www.oransblog.com/content/images/2021/03/image-28.png)

change "YOUR\_APP\_ID" here

![](https://www.oransblog.com/content/images/2021/03/image-29.png)

dont forget to add the facebook account here

```bash
timeliner add-account facebook/<USERNAME FACEBOOK>
C:/Users/github/timeliner/cmd/timeliner/timeliner.exe add-account facebook/<FACEBOOK ACCOUNT> -config "timeliner.toml"
C:/Users/github/timeliner/cmd/timeliner/timeliner.exe -v get-all facebook/<FACEBOOK ACCOUNT>

```

#   
how to view sqlite database in the browser

#### [SQLite Viewer](https://inloop.github.io/sqlite-viewer/?ref=oransblog.com)