|
Latest Discussions
|
 |
|
|
|
|
 |
|
Support Forum
|
|
|
| Author |
Messages |
|
ananda situnayake
Posts:5
 |
| 01/17/2008 12:26 AM |
|
Hi,
I am researching using ultra video gallery for a media company website , they require linking videos to a unique field in a 3rd party DB which i will have ccess to, i.e. all videos will need to be uploade and "joined" to a specific program title record in another DB. I appreciate this is not possible out of the box but would you foree this being a simple change if i purchased the source ode?
looks like a good produt i just need to be sure i can integrat it with a second SQL DB
|
|
|
|
|
Pengtsen R
Posts:5177
|
| 01/17/2008 7:21 AM |
|
| you mean, don't use UVG datatables to store video and other information, but to store them in another data tables which is created by another program? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
ananda situnayake
Posts:5
|
| 01/17/2008 7:27 AM |
|
I still want to store video etc in existing tables but i have a separate database/table which will contain the categories that i want videos to belong to, each row in this table woulkd be for example a program title, i want to be upload and search videos against program titles.
The categories/program titls table will be administered via another system and is not something i have control over, but i basically need to be ble to read this table fro the uvg module nd use it to pupulate the categories drop down and also for it to be used in searching etc.
|
|
|
|
|
Pengtsen R
Posts:5177
|
| 01/17/2008 6:48 PM |
|
| I have to say I'm not exactly sure about your questions, is it possible to explain it in more detail? you also can show me some designs or diagrams about your DB strucutre. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
ananda situnayake
Posts:5
|
| 01/18/2008 3:45 AM |
|
sorry my fault im probably not explaining very well.
you have a table
UVG_VIDEO and UVG_VIDEOCATEGORY and UVG_CATEGORY
at the moment your system stores a video inthe UVG_VIDEO table and the UVG_VIDEOCATEGORY table contains the link between the video and the category it belongs to. what i am saying is that i will have another table belonging to another application that i will want to be the video category table so how easy will it be to ammend the source code to do this.
e.g my third party table will be called PROGRAM_TITLES and have an id field , i would want each uploaded video to be joined to an entry in the PROGRAM_TITLES table
cheers, hope thats clearer...it seems like it should be a fairly simple change?
ana
|
|
|
|
|
Pengtsen R
Posts:5177
|
| 01/18/2008 4:13 AM |
|
| so your PROGRAM_TITLES table have VideoId and CategoryId field? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Pengtsen R
Posts:5177
|
| 01/18/2008 4:17 AM |
|
| can you show me a full column list of your PROGRAM_TITLE table? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
ananda situnayake
Posts:5
|
| 01/18/2008 4:19 AM |
|
| no, they wouldnt i have no control over the program_title table except that i know it will have a unique id, so i will have to change the UVG_VideoCategory table to point to the program title table instead of the uvg_category table |
|
|
|
|
Pengtsen R
Posts:5177
|
| 01/18/2008 4:23 AM |
|
| so you don't use all category features in UVG? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
ananda situnayake
Posts:5
|
| 01/18/2008 7:33 AM |
|
no i would need to change the category feature to pull the categories (program titles) from the program_title table
|
|
|
|
|
Pengtsen R
Posts:5177
|
| 01/18/2008 7:50 AM |
|
please note we are talking about 2 tables, one is UVG_Category, which is used to store category info, UVG_VideoCategory which is used to store linkage between video and video category.
if all fields in these 2 tables can be found in your custom data table, you can consider to leave the vb source alone, just change stored procedures to save data in your own table, for example, UVG_CategoryAdd procedure add a record in UVG_Category table, you can consider to alter it so data is stored in your program table.
In this case you don't need to change even one line of vb source.
thanks. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
|
| You are not authorized to post a reply. |
|
|
|
|
|
|
 |
 |
|
 |
|