# Export Timelion Sheets for future use

**URL:** <https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503>\
**Category:** Kibana\
**Tags:** timelion\
**Created:** [December 6, 2017, 11:05am UTC](https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503 "2017-12-06T11:05:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![stevedearl](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@stevedearl](https://discuss.elastic.co/u/stevedearl)\
**Post date:** [December 6, 2017, 11:05am UTC](https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503/1 "2017-12-06T11:05:41Z")

</div>

Hi All,

I was trying to figure out how to do this and the following post from Lou on May 2016 seemed to provide a solution:

> [@Timelion sheets exports for reuse on another Kibana instance](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053):
>
> Hello, everything is in the title yum I have some saved sheets in my Kibana instance, and would like to find a way to take them (where are them saved ??) and put them in another Kibana installation on another PC... Your ideas/suggestions are very welcome. Have a great day.

However, like pavithrakc who posted a reply, this solution doesn't seem to work for me.

Can anyone suggest the best way to export/import Timelion charts.

For information, I have the following Timelion charts:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/5/358c0996db05b7e49e1b891ae62b21bfe4c679e2.png)

If I try to use the console as described in the post above to retrieve one of these sheets, it doesn't work:

Command:  
`GET .kibana/timelion-sheet/tlion_esb_ins_AFB_MaxProcessing_CreateOffer`

Result:  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/a/aae0b1d1b12e3f79eb3b1c0e07b54bed2933a446.png)

All help appreciated.

Steve

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [December 6, 2017, 6:03pm UTC](https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503/2 "2017-12-06T18:03:06Z")

</div>

Hi Steve,

Kibana visualizations have changed to use a GUID id and no longer use the `type` parameter for different saved object types in 6.0+ versions. But you can still search on the title field

Try something like this;

`GET .kibana/_search?q=title:tlion_esb_ins_AFB_MaxProcessing_CreateOffer`

Regards,  
Lee

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [December 6, 2017, 6:22pm UTC](https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503/3 "2017-12-06T18:22:26Z")

</div>

I think there's another way (maybe easier).

When you save a Timelion sheet you get 2 choices;

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/c/8c8f6417dc988a3d7561e1303b17ce5e3b067ffb.png)

If you save it as a Kibana Dashboard panel you can use the regular Saved Objects UI to export it;

I just saved the default `.es(*)` timelion expression and then exported it and got this;

```auto
[
  {
    "_id": "02576270-dab0-11e7-93ca-1907e1bfe028",
    "_type": "visualization",
    "_source": {
      "title": "Lee",
      "visState": "{\"type\":\"timelion\",\"title\":\"Lee\",\"params\":{\"expression\":\".es(*)\",\"interval\":\"auto\"}}",
      "uiStateJSON": "{}",
      "description": "",
      "version": 1,
      "kibanaSavedObjectMeta": {
        "searchSourceJSON": "{}"
      }
    }
  }
]

```

---

<div class="post-metadata">

**Author:** ![stevedearl](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@stevedearl](https://discuss.elastic.co/u/stevedearl)\
**Post date:** [December 6, 2017, 9:13pm UTC](https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503/4 "2017-12-06T21:13:53Z")

</div>

Hi Lee,

Thanks for the reply. I'll check out both your suggestions when I'm back in the office tomorrow, but either of them would help me out.

Cheers,  
Steve

---

<div class="post-metadata">

**Author:** ![stevedearl](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@stevedearl](https://discuss.elastic.co/u/stevedearl)\
**Post date:** [December 7, 2017, 8:35am UTC](https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503/5 "2017-12-07T08:35:26Z")

</div>

Hi Lee,

For some reason I couldn't get the CURL 'search' to retrieve me the document via the console:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/6/c6bfacfd7c11015c6a8990660e21e23e9d4cf11c.png)

However, saving the expression as a dashboard panel worked fine, and they then appear under the 'Visualizations' section of the Management/Saved Objects tab. This works, as it means all my searches, visualizations (including Timelion) and dashboards can be imported/exported in one go, and I can get back to the original tlion query by looking at the saved panel expression.

I guess if I had one final comment, it might be a good enhancement in the future if the "Save entire Timelion sheet" option in Timelion made the sheet available within the Saved Objects/Visualizations area too as at the moment it's a little confusing that you save it, but it would not be present on an export so would be lost if you then re-imported the objects into a new Kibana instance (as I did).

Thanks again for the rapid (and v. useful) advice,  
Steve

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [December 7, 2017, 3:00pm UTC](https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503/6 "2017-12-07T15:00:19Z")

</div>

One thing that might be throwing you off on your search for the timelion saved object, is that the `id` of a saved object used to be the `title` of the saved object but with spaces replaced by underscores. If your title is actually `tlion esb ins AFB MaxProcessing CreateOffer` then you would use that in your search instead of the former id string with underscores.

I'll discuss with Timelion developers and see if it makes sense to add them as another object type to export. And if so, I'll file an issue to get it in the queue.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 4, 2018, 3:00pm UTC](https://discuss.elastic.co/t/export-timelion-sheets-for-future-use/110503/7 "2018-01-04T15:00:59Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
