April 6, 2015 at 12:58 pm
I have a database and a dvr that has movies that correspond to the data in the database. Is there a way to run a report and then by selecting a record in the report access the movie that pertains to that record?
Thanks in advance for any information you can provide.
April 6, 2015 at 1:50 pm
mballentine (4/6/2015)
I have a database and a dvr that has movies that correspond to the data in the database. Is there a way to run a report and then by selecting a record in the report access the movie that pertains to that record?Thanks in advance for any information you can provide.
From what you posted the answer is a solid "it depends". Does the DVR have an API you can utilize? Do you really think doing this in a report is a good idea? There is simple not even close to enough information in your post to even begin to ask the questions needed to get started on determining if this is possible.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 6, 2015 at 2:20 pm
The reason I am asking is because our customer has requested to be able to view the movie that is associated with the data in the database. As far as the DVR having an API, I am not sure, but would be willing to get the hardware required if this can be done. If you know of a source of information I can refer to I would greatly appreciate direction.
Thanks
April 6, 2015 at 3:04 pm
mballentine (4/6/2015)
The reason I am asking is because our customer has requested to be able to view the movie that is associated with the data in the database. As far as the DVR having an API, I am not sure, but would be willing to get the hardware required if this can be done. If you know of a source of information I can refer to I would greatly appreciate direction.Thanks
I couldn't possibly have anything to point you to. What you have asked is "I have a DVR do you know if there is a manual that explains if they have an API". Not only is that WAY outside the realm of sql server, you didn't even mention which brand, let alone which model of DVR. The things you are trying to do require some programming, you are not going to be able to directly access the DVR with a t-sql query.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 6, 2015 at 3:10 pm
this is effectively recreating the wheel, isn't it(youtube.com?)
Like Sean said, i doubt you'll have an API to push around a DVR; i've never seeen or heard of one.
if you have a DVR, i would think you'd need to extract the movies out to avi or swf or flv or mp4, and then you can embed them easily within a web page.
Lowell
April 6, 2015 at 4:30 pm
In the report, create a link button to the file on the file server. Click the link and it should pop up. Not 100% sure this would work, but it's easy to test. The issue though is streaming. Is it local or offsite? If it's offsite, I would anticipate laggy video. In that case, you're going to need to implement buffering which can't be done in SQL. This is why people use Plex.
April 7, 2015 at 7:27 am
Thank you all for your input.
The link sounds like it might be the way to go.
The dvr is on site (in the customer's network).
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply