chris wallis
Posts:41
 |
| 10/14/2008 7:58 AM |
|
i am uploading mulitple files in zip files and they won't accept the price i am setting so i am having to go through and manually add the prices
is this a bug of the way it is meant to work
if not is there a better way of doing this than the longwinded proces of using manage downloads
|
|
|
|
|
Pengtsen R
Posts:5179
|
| 10/14/2008 7:59 AM |
|
| please make a series of screenshots to demonstrate when you done and what the problem is, then you can email to us in the bottom "Contact Us" link. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
chris wallis
Posts:41
|
| 10/14/2008 8:20 AM |
|
| email sent with screen shot for you |
|
|
|
|
chris wallis
Posts:41
|
| 10/22/2008 4:44 AM |
|
Since upgrading to the latest build of UMG i am having issues with this.
I am not sure if it was a bug, but when i uploaded a zip file it would link the uploaded pic as a download, and i then had to go back and set the price.
I had written a trigger to update the price on insert onto UPG_Download table, but this won't work as they are now not being added to this table, could you advise me what to set up so that it would trigger an insert across to this table and set up the required into for the download table
AFTER INSERT
AS
UPDATE dbo.BizModules_UPG_Download
SET Price = '4.5000'
FROM inserted i
JOIN dbo.BizModules_UPG_Download b ON i.ItemId = b.ItemId |
|
|
|
|
Pengtsen R
Posts:5179
|
| 10/22/2008 6:52 AM |
|
| you mean now the original photo is not linked as the download of the resized version? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
chris wallis
Posts:41
|
| 10/22/2008 6:59 AM |
|
yeap, its used to link it and leave the price as free, which would be fine for the trigger to change the price automatically
|
|
|
|
|
Pengtsen R
Posts:5179
|
| 10/22/2008 7:00 AM |
|
| what's your current "Link original file" settings in Settings screen? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
chris wallis
Posts:41
|
| 10/22/2008 9:30 AM |
|
the box was unticked, is that new in the last update ?
i have ticked and it works fine now and the trigger does the required
|
|
|
|
|
Pengtsen R
Posts:5179
|
| 10/22/2008 9:31 AM |
|
| please enable it and try again. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
chris wallis
Posts:41
|
| 10/22/2008 9:37 AM |
|
yeap with it ticked it works fine, thanks very much
was this option changed in the newest version? |
|
|
|
|
Pengtsen R
Posts:5179
|
| 10/22/2008 9:38 AM |
|
| ok, great. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
dan hank
Posts:29
|
| 11/11/2008 2:24 PM |
|
Could you explain how you accomplish the auto price insert with that sql trigger? This is exactly what I need done. I upload several pictures and need to set them all to same price without wasting time on the manage downloads page.
Thanks
Dan
|
|
|
|
|
chris wallis
Posts:41
|
| 11/11/2008 2:31 PM |
|
are you familiar with SQL? and do you have access to the database and server through management console?
on the table Bizmodules_upg_download table
you will need to create a trigger
the standard syntax is
CREATE TIGGER "trigger name" on "table name
and then the action of the trigger
see below the code i used
CREATE TRIGGER price_change on Bizmodules_upg_download
AFTER INSERT
AS
UPDATE dbo.BizModules_UPG_Download
SET Price = '4.5000'
FROM inserted i
JOIN dbo.BizModules_UPG_Download b ON i.ItemId = b.ItemId
BE WARNED - if you don't know what youa re doing with SQL be very carefull about doing this as you can risk doing all sorts to the Database, Make sure you back it up first
|
|
|
|
|
dan hank
Posts:29
|
| 11/11/2008 3:38 PM |
|
Chris, thanks for the response. For now i'm testing on my localhost with sql express. I'm very familiar with sql mostly within sql server management studio. But I have never created triggers before. I will have to read up about triggers.
So if I use management studio to create new trigger on the download table, I can erase the template and paste that code. I'll backup and try it.
Thanks so much
Dan |
|
|
|
|
chris wallis
Posts:41
|
| 11/11/2008 3:44 PM |
|
i tend not to use the "create trigger" function with in the management studio, if you just past that code in and execute on the right table then it should work fine.
i tested on a copy of the DB first and then used on the live with the insert into the table happening via photo upload instead of an insert statement
this will blanket apply on all photos, i reckon you could expand via an IF or where statement if you know that a group of photos will have certain criteria |
|
|
|
|
dan hank
Posts:29
|
| 11/11/2008 3:51 PM |
|
I will be uploading pictures in bulk, either with the zip file upload, or the drop into the ftp folder (and then syncing in the manage albums section). My goal is to have ALL pictures the same price. So I just need to update the price on each upload automatically, or go back later and mass update the price field with sql.
Dan |
|
|
|
|
Pengtsen R
Posts:5179
|
| 11/11/2008 8:06 PM |
|
| Chris, thank you for sharing your work with us! |
|
Pengtsen R
http://www.bizmodules.net |
|
|
dan hank
Posts:29
|
| 11/12/2008 11:12 AM |
|
Simply updating the download table with new prices does not make the items available for purchase. The purchase button is grayed out still. I've looked through all sp's and tables. There must be hard code or a local file that handles this. Can you help me with this? Also how do you display the price of the picture when viewing the picture?
Dan |
|
|
|
|
chris wallis
Posts:41
|
| 11/12/2008 1:28 PM |
|
check your options on the managed downloads as i didn't have to make any other changes.
Without the trigger they were there with a price of 0.00 if yours are not doing this by default the we have some different settings |
|
|
|
|
dan hank
Posts:29
|
| 11/12/2008 2:00 PM |
|
I setup the trigger and it works nicely! thanks chris
Do you know how to display the price on the photo? I can't figure out how to make the price visible anywhere.
example: http://www.bizmodules.net/tabid/119/Default.aspx |
|
|
|
|