June 29, 2022, 02:15:37 AM
Welcome, Guest. Please login or register
News: Stay up to date with everything that's happening at http://twitter.digitalsignage.com

MediaSignage support forum

Show Posts

Messages | * Topics | Attachments

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - EbuscoSignage

Pages: [1]
Studio (Legacy / SignStudio) / Modify JSON data
« on: September 17, 2020, 01:05:44 PM »
We retrieve data from another program . This contains names and the birthdays of our employees.
However... The program exports the birthday a day to early!

Meaning if the birthday is on by example 30-10-1955 (dd-mm-yyy), it gives us 29-10-1955

While I love getting cake a day earlier, it's not what we want of cos.
Unfortunately, there are some developments within the source program, that they're unable to address this issue on short notice.

The question now is: Can I adjust the data retrieved to add the day "+1"?
Perhaps it will be hard to do so, if we get a date like 31-08-xxxx to become 01-09-xxxx, but perhaps there is a way?
(Currently as it's setup in DSS, it is working fine but with the wrong date)

The (raw) data looks as followed:

  "Table": [
      "ID": 1281,
      "DisplayName": "Jimmy Hendrix",
      "Birthday": "1955-09-29T00:00:00",
      "BirthdayString": "29-09-1955"
      "ID": 1390,
      "DisplayName": "Whoopie Goldberg",
      "Birthday": "1958-10-19T00:00:00",
      "BirthdayString": "19-10-1958"

etc... for more employees

In a scene, I added the lines as followed:

$Table[0].BirthdayString" - "$Table[0].DisplayName"
$Table[1].BirthdayString" - "$Table[1].DisplayName"
$Table[2].BirthdayString" - "$Table[2].DisplayName

Pages: [1]
Carbonate design by Bloc
variant: carbon
SMF 2.0.12 | SMF © 2016, Simple Machines