DB Bindings and Dynamic Pages

Need help? Post a question or browse the topics for technical support in using Noventri products, peripherals, and accessories.
Post Reply
mark_anderson_us
Trusted Contributor
Trusted Contributor
Posts: 61
Joined: Fri Mar 16, 2012 12:21 pm

DB Bindings and Dynamic Pages

Post by mark_anderson_us »

Hi Guys

Either I'm not getting it, or dynamic pages don't work correctly with DB Bindings. I have multiple visitors every day and I want to cycle through each of them at x-second intervals. I have a single list and a record is returned for each site the visitor will visit. I want to use DB Binding for this, so that I don't need to create 4 separate projects.

I have 4 visitor boards and want to create a single project. (The idea is to filter the data each displays using DB Bindings). Seems fairly straightforward. My test data returns the following:

Code: Select all

ID	VisitDate	 Company	           Site	        StartTime	        EndTime
1	7/22/2014	  WH GI BV 1	   Wheeling	7/22/14 0:01	7/22/14 23:59
1	7/22/2014  WH GI BV 1	   Gilman	        7/22/14 0:01	7/22/14 23:59
1	7/22/2014	  WH GI BV 1	   Broadview	7/22/14 0:01	7/22/14 23:59
2	7/22/2014	  WH GI BV 2	   Wheeling	7/22/14 0:01	7/22/14 23:59
2	7/22/2014  WH GI BV 2	   Gilman	        7/22/14 0:01	7/22/14 23:59
2	7/22/2014	  WH GI BV 2	   Broadview	7/22/14 0:01	7/22/14 23:59
3	7/22/2014	  BV	                   Broadview	7/22/14 0:01	7/22/14 23:59
4	7/22/2014	  WH GI	           Wheeling	7/22/14 0:01	7/22/14 23:59
4	7/22/2014	  WH GI	           Gilman	        7/22/14 0:01	7/22/14 23:59
5	7/22/2014	  GI	                   Gilman	        7/22/14 0:01	7/22/14 23:59
6	7/22/2014	  GI BV	           Gilman	        7/22/14 0:01	7/22/14 23:59
6	7/22/2014	  GI BV	           Broadview	7/22/14 0:01	7/22/14 23:59
The player bound to Broadview (site is the binding column) is displaying 12 dynamic pages (Always Record 7). It should display records 3,6,7,12 as they are the only ones where the DB Binding matches the Site.

There's nothing in the documentation that explains how dynamic pages are handled and how overlapping or concurrent events are handled.

One other question: do I have to use start time and end time?
User avatar
Tim R
Noventri Digital Signage Expert
Noventri Digital Signage Expert
Posts: 18
Joined: Thu Dec 10, 2009 1:50 pm

Re: DB Bindings and Dynamic Pages

Post by Tim R »

Hello Mark,

Database bindings currently only help in the sense of maintaining/creating one select statement across projects. Therefore, they do require separate projects to be made in order to achieve your goal.

I would recommend creating one template project, then performing a Save As to create the other 3 projects.

Also, in regards to your second question: Yes, the start and end time are required.

Kind Regards,
Tim Rollins
Executive Director of Technology
Noventri
20940 Twin Springs Dr.
Smithsburg, MD 21783-1510 USA
301-790-0103
Fax: 301-790-0173
http://www.noventri.com
Post Reply