Fetching remote Dataset from dynamic content

Get Help CMS Features and Functionality
1

CMS Version

4.3.1

Player Type

XIbo windows

Player Version

XIbo windows r406

Issue

So i wrote a script to fetch product name, itemname, category and description from Odoo Point of Sale automatically.

With the purpose of syncing price in case there’s price change.

Let’s say we use simple example like this

  1. Candy
  2. Bread
  3. Coffee
  4. Tea
  5. Mineral Water

The problem is,

from my understanding since xibo dataset input layout pinpoint to specific row number, if i happen to make changes in odoo like this by archiving the Tea product :

  1. Candy
  2. Bread
  3. Coffee
  4. Mineral Water

The row order would change and the menu would be messed up since 4 is now Mineral water

Anyway to work around this? I don’t see any option to tie to specific db entry or something like that..

2

Ok i kinda figure this out, so we have to play around with the filter rule, so no matter how much data gets added, it will still point to the correct entry.

I have another gripe though,

So I need to design a portrait menu, with 1080p portrait resolution i can barely see the font text,

toosmall
toosmall1831×848 75.9 KB

Previously i made it with 1080p landscape and rotate the elements 90 degree, but playlist+ rich text doesn’t seem to allow rotating orientation, so i had no choice but to use 1080p portrait.

Even zooming the browser doesn’t help, is there any work around for this?

3

Hi,

I’ve been using odoo since the openerp days. Are you using odoo’s saas software or are you using community? I’ve found the best way to do interactions with their XMLRPC aPI with signage content is to develop a middleware database where you can handle the data retrieval.

I’ve encountered a similar issue where we were needing to either fade the text on menu items when they’re out of stock, or remove them completely, the latter messes with the overall layout as you add or subtract / archive products.

Dumping everything from odoo to a simple rest API server we hosted saved us from having to reposition everything constantly as we could set our formatting fields separately in our own database where we had additional fields that were signage specific and not stored in odoo.

1 Like