Problems with remote Dataset

Freymi · May 3, 2019, 11:14am

Hello.

I’m trying to import a remote JSON dataset.
When I test the remote data URL I get the following result:

{
   "entries": [
      {
         "data": {
            "soups": [
               [
                  "03.05.2019",
                  "Fr",
                  "Suppe",
                  "Chicken-Currysuppe (3,J)",
                  "G",
                  "0,70 / 0,90 / 1,40",
                  "0,70",
                  "0,90",
                  "1,40"
               ]
            ],
            "main": [
               [
                  "03.05.2019",
                  "Fr",
                  "HG1",
                  "Apfel-Heidelbeer-Topfenschmarrn (3,AA,C,G)",
                  "V",
                  "2,00 / 2,80 / 3,60",
                  "2,00",
                  "2,80",
                  "3,60"
               ],
               [
                  "03.05.2019",
                  "Fr",
                  "HG2",
                  "Kartoffelecken exotisch mit Mango-Chillirahm (3,AA,F,I,J)",
                  "VG",
                  "2,50 / 3,10 / 4,20",
                  "2,50",
                  "3,10",
                  "4,20"
               ],
               [
                  "03.05.2019",
                  "Fr",
                  "HG3",
                  "Fischfilet paniert mit Kräuterquark-Dip und Petersilienkartoffeln (3,5,AA,D,G,I)",
                  "F",
                  "3,10 / 3,90 / 4,60",
                  "3,10",
                  "3,90",
                  "4,60"
               ],
               [
                  "03.05.2019",
                  "Fr",
                 "HG4",
                  "Halbes Grillhendl mit Würfelkartoffeln (8)",
                  "G",
                  "4,70 / 5,70 / 6,20",
                  "4,70",
                  "5,70",
                  "6,20"
               ]
            ],
            "garnish": [
               [
                  "03.05.2019",
                  "Fr",
                  "B1",
                  "Petersilienkartoffeln (5)",
                  "VG",
                  "0,70 / 0,90 / 1,40",
                  "0,70",
                  "0,90",
                  "1,40"
               ],
               [
                  "03.05.2019",
                  "Fr",
                  "B2",
                  "Gemüsecocktail Cordial (3,I)",
                  "VG",
                  "0,80 / 1,00 / 1,50",
                  "0,80",
                  "1,00",
                  "1,50"
               ],
               [
                  "03.05.2019",
                  "Fr",
                  "B3",
                  "Salatmix",
                  "V",
                  "0,90 / 1,10 / 1,60",
                  "0,90",
                  "1,10",
                  "1,60"
               ],
               [
                  "03.05.2019",
                  "Fr",
                  "B4",
                  "Würfelkartoffeln ",
                  "VG",
                  "1,00 / 1,10 / 1,60",
                  "1,00",
                  "1,10",
                  "1,60"
               ],
               [
                  "03.05.2019",
                  "Fr",
                  "B5",
                  "Salat Buffet (1,3,6,9,16,C,G,J,L)",
                  "V",
                  "3,00 / 3,50 / 4,20",
                  "3,00",
                  "3,50",
                  "4,20"
               ]
            ],
            "dessert": [
               [
                  "03.05.2019",
                  "Fr",
                  "N1",
                  "Vanillequark (1,G)",
                  "V",
                  "0,80 / 1,00 / 1,50",
                  "0,80",
                  "1,00",
                  "1,50"
               ],
               [
                  "03.05.2019",
                  "Fr",
                  "N2",
                  "Mousse Noisette (F,G,H,HB)",
                  "V",
                  "1,10 / 1,40 / 1,60",
                  "1,10",
                  "1,40",
                  "1,60"
               ]
            ]
         }
      }
   ],
   "number": 1,
   "processed": [
      [
         []
      ]
   ],
   "messages": [
      "Processing 1 results into 1 potential columns",
      "Processing Result with Data Root ",
      "DataRoot is an object",
      "Processing as a Single Row",
      "Consolidating entries",
      "There are 1 entries in total"
   ]
}

however when I change the Data Root to soups no data gets returned:

{
   "theme": {
      "store": {},
      "pool": {},
      "rootUri": "/",
      "envTested": false,
      "envFault": false,
      "envWarning": false,
      "middleware": null,
      "logHandlers": null,
      "logProcessors": null,
      "authentication": null,
      "samlSettings": null,
      "casSettings": null,
      "cacheDrivers": null,
      "cacheNamespace": "Xibo",
      "themeConfig": {
         "theme_name": "Xibo Default Theme",
         "theme_title": "Xibo Digital Signage",
         "app_name": "Xibo",
         "theme_url": "http://xibo.org.uk",
        "cms_source_url": "https://github.com/xibosignage/xibo/",
         "cms_install_url": "http://xibo.org.uk/manual/en/install_windows_client.html",
         "cms_release_notes_url": "http://xibo.org.uk/manual/en/release_notes.html",
         "themeCode": "default",
         "themeFolder": "theme/default/"
     }
   },
   "version": "2.0.0"
}

I tried to change the data root anyway and add rows, but haven’t managed to get any data displayed.

onemidia · May 4, 2019, 1:13am

Olá, você pode fornecer a URL para ver o que esta acontecendo?

Você seguiu os passos de editação dos dados?
https://xibo.org.uk/manual/en/media_datasets.html

Freymi · May 5, 2019, 4:38pm

I followed the guide, but without success.
Unfortunately the Remote Dataset URL is in a private Network, so I can’t post it here.
But it returns the following JSON:
“data”: {
“soups”: [
[
“03.05.2019”,
“Fr”,
“Suppe”,
“Chicken-Currysuppe (3,J)”,
“G”,
“0,70 / 0,90 / 1,40”,
“0,70”,
“0,90”,
“1,40”
]
],
“main”: [
[
“03.05.2019”,
“Fr”,
“HG1”,
“Apfel-Heidelbeer-Topfenschmarrn (3,AA,C,G)”,
“V”,
“2,00 / 2,80 / 3,60”,
“2,00”,
“2,80”,
“3,60”
],
[
“03.05.2019”,
“Fr”,
“HG2”,
“Kartoffelecken exotisch mit Mango-Chillirahm (3,AA,F,I,J)”,
“VG”,
“2,50 / 3,10 / 4,20”,
“2,50”,
“3,10”,
“4,20”
],
[
“03.05.2019”,
“Fr”,
“HG3”,
“Fischfilet paniert mit Kräuterquark-Dip und Petersilienkartoffeln (3,5,AA,D,G,I)”,
“F”,
“3,10 / 3,90 / 4,60”,
“3,10”,
“3,90”,
“4,60”
],
[
“03.05.2019”,
“Fr”,
“HG4”,
“Halbes Grillhendl mit Würfelkartoffeln (8)”,
“G”,
“4,70 / 5,70 / 6,20”,
“4,70”,
“5,70”,
“6,20”
]
],
“garnish”: [
[
“03.05.2019”,
“Fr”,
“B1”,
“Petersilienkartoffeln (5)”,
“VG”,
“0,70 / 0,90 / 1,40”,
“0,70”,
“0,90”,
“1,40”
],
[
“03.05.2019”,
“Fr”,
“B2”,
“Gemüsecocktail Cordial (3,I)”,
“VG”,
“0,80 / 1,00 / 1,50”,
“0,80”,
“1,00”,
“1,50”
],
[
“03.05.2019”,
“Fr”,
“B3”,
“Salatmix”,
“V”,
“0,90 / 1,10 / 1,60”,
“0,90”,
“1,10”,
“1,60”
],
[
“03.05.2019”,
“Fr”,
“B4”,
"Würfelkartoffeln ",
“VG”,
“1,00 / 1,10 / 1,60”,
“1,00”,
“1,10”,
“1,60”
],
[
“03.05.2019”,
“Fr”,
“B5”,
“Salat Buffet (1,3,6,9,16,C,G,J,L)”,
“V”,
“3,00 / 3,50 / 4,20”,
“3,00”,
“3,50”,
“4,20”
]
],
“dessert”: [
[
“03.05.2019”,
“Fr”,
“N1”,
“Vanillequark (1,G)”,
“V”,
“0,80 / 1,00 / 1,50”,
“0,80”,
“1,00”,
“1,50”
],
[
“03.05.2019”,
“Fr”,
“N2”,
“Mousse Noisette (F,G,H,HB)”,
“V”,
“1,10 / 1,40 / 1,60”,
“1,10”,
“1,40”,
“1,60”
]
]
}

onemidia · May 5, 2019, 6:42pm

Preciso da URL JSON, você pode enviar no privado.

Freymi · May 5, 2019, 7:19pm

The URL is in a private local network, you won’t be able to access it.
However I can make a copy of the script and upload it to another server and send you the link.
Should only take a few minutes.

Freymi · May 5, 2019, 7:27pm

This is a public link to the script http://xibo.freymi.de/test.php

onemidia · May 5, 2019, 8:05pm

Encontrei estes resultados
Espero que ajude

Freymi · May 5, 2019, 8:42pm

Thank you, I had to add the data in front of soups.
However when I do it like in your screenshots and select “View data” in the dataset menu, I still don’t see any data…

onemidia · May 5, 2019, 9:15pm

Faça suas capturas de telas, fica mais fácil eu analisar o que esta de errado

Freymi · May 6, 2019, 7:39am

When I click “View Data” I don’t see the JSON Data

onemidia · May 6, 2019, 11:52am

Olá,
Primeiro gostaria de saber que tipo de instalação foi feita, Docker ou Manual?
Você tem outros dataset funcionando ou somente este?, essas informações são importantes para um saber onde esta o problema.
O XTR - Tarefas de Rotina esta funcionando?

Desça a barra ate o final para visualizar o resultado

A sincronização demora uns 40 minutos.

Depois de 40min. o resultado sera exibido

onemidia · May 6, 2019, 11:53am

Você pode estar verificando esta configurações
https://xibo.org.uk/docs/setup/xtr-routine-tasks

Freymi · May 6, 2019, 12:40pm

I Installed XIBO manually and I only have one Dataset at the moment.
I just noticed that all the tasks are gone in the menu.
I started the “fetch remote datasets” task before, but it’s gone now.
Should I just reinstall XIBO with docker?

system · March 4, 2020, 5:13pm