|
Latest Discussions
|
 |
|
|
|
|
 |
|
Support Forum
|
|
|
| Author |
Messages |
|
H W
Posts:21
 |
| 10/07/2007 10:09 AM |
|
Hi
We're now doing an increasing amount of our admin tasks from T-SQL as it's faster and more convenient than using the DNN web interface.
One thing I'd like to automate is the addition of new albums - especially as we are currently creating several of these every week.
So far we've prototyped this by just invoking the stored procedure BizModules_UPG_AlbumAdd.
This seems to work well - we don't seem to have to create the on-disk folder - it just seems to work :-)
Has anyone else tried this?
Does anyone know of any drawbacks to this type of approach?
Thanks
HW
--- example SQL used
DECLARE @PortalId int,
@ModuleId int,
@ParentId int,
@Title nvarchar(100),
@Description nvarchar(1000),
@Audio nvarchar(50),
@AudioCaption nvarchar(100),
@Tn nvarchar(100),
@TnWidth int,
@TnHeight int,
@CreatedDate smalldatetime,
@LastModifiedDate smalldatetime,
@CreatedByUser int,
@Owner int,
@SortOrder int,
@HeaderTemplate nvarchar(150),
@ComposeRoles nvarchar(500),
@ModerationRoles nvarchar(500),
@ViewRoles nvarchar(500),
@MaxPhotoWidth int,
@MaxPhotoHeight int,
@NeedApproval bit,
@FlickrSubscription nvarchar(1000),
@FlickrRefreshInterval int,
@FlickrLastRefreshTime datetime
SET @PortalId = 0
SET @ModuleId = 1263
SET @ParentId = NULL
SET @Title = 'Test Album'
SET @Description = 'Test Description'
SET @Audio = NULL
SET @AudioCaption = NULL
SET @Tn = NULL
SET @TnHeight = 50
SET @TnWidth = 40
SET @CreatedDate = getdate()
SET @LastModifiedDate = getdate()
SET @CreatedByUser = 1
SET @Owner = 1
SET @SortOrder = NULL
SET @HeaderTemplate = '[ALBUMNAME] - [TITLE] ([SIZE],[RESOLUTION])'
SET @ComposeRoles = 'Administrators'
SET @ModerationRoles = 'Administrators'
SET @ViewRoles = NULL
SET @MaxPhotoWidth = 600
SET @MaxPhotoHeight = 350
SET @NeedApproval = NULL
SET @FlickrSubscription = NULL
SET @FlickrRefreshInterval = 0
SET @FlickrLastRefreshTime = NULL
EXEC BizModules_UPG_AlbumAdd @PortalId,
@ModuleId,
@ParentId,
@Title,
@Description,
@Audio,
@AudioCaption,
@Tn,
@TnWidth,
@TnHeight,
@CreatedDate,
@LastModifiedDate,
@CreatedByUser,
@Owner,
@SortOrder,
@HeaderTemplate,
@ComposeRoles,
@ModerationRoles,
@ViewRoles,
@MaxPhotoWidth,
@MaxPhotoHeight,
@NeedApproval,
@FlickrSubscription,
@FlickrRefreshInterval,
@FlickrLastRefreshTime
|
|
|
|
|
Pengtsen R
Posts:5177
|
| 10/07/2007 10:40 AM |
|
| it should be ok, I think there is no problems. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
|
| You are not authorized to post a reply. |
|
|
|
|
|
|
 |
 |
|
 |
|