|
Latest Discussions
|
 |
|
|
|
|
 |
|
Support Forum
|
|
|
| Author |
Messages |
|
Andre van den Berg
Posts:89
 |
| 06/14/2008 1:49 AM |
|
Hello,
Is it possible to resize a complete album afterwards? I created a album and did not set the resize option.
Now when i use the lightbox option i get realy big photo's. that don't fit on the screen.
So i want to resize them so it's looking good in the lightbox. |
|
|
|
|
Pengtsen R
Posts:4596
|
| 06/14/2008 5:52 AM |
|
| well, the pictures are resized when you uplaod them, it seems you can't resize them to a different resolution after creation. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Andre van den Berg
Posts:89
|
| 06/14/2008 6:07 AM |
|
| How to resolve this? |
|
|
|
|
Andre van den Berg
Posts:89
|
| 06/14/2008 12:53 PM |
|
| I mean so that i not lose my title and description. |
|
|
|
|
Pengtsen R
Posts:4596
|
| 06/14/2008 7:43 PM |
|
| it seems this can't be done :( |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Andre van den Berg
Posts:89
|
| 06/16/2008 2:58 AM |
|
I solved the problem with the following steps:
1. Make a temp table with name: BizModules_UPG_Photo_Kopie
GO
/****** Object: Table [dbo].[BizModules_UPG_Photo_Kopie] Script Date: 06/16/2008 08:28:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BizModules_UPG_Photo_Kopie](
[ItemId] [int] IDENTITY(1,1) NOT NULL,
[AlbumId] [int] NOT NULL,
[Title] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Link] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Src] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Approved] [bit] NOT NULL,
[CreatedByUser] [int] NOT NULL,
[CreatedDate] [smalldatetime] NOT NULL,
[LastModifiedDate] [smalldatetime] NULL,
[SortOrder] [int] NULL,
[DownloadId] [int] NULL,
[TnWidth] [int] NULL,
[TnHeight] [int] NULL,
[ExifDescription] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TakenDate] [smalldatetime] NULL,
CONSTRAINT [PK_BizModules_UPG_Photo_Kopie] PRIMARY KEY CLUSTERED
(
[ItemId] ASC
) WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[BizModules_UPG_Photo_Kopie] WITH CHECK ADD CONSTRAINT [FK_BizModules_UPG_Photo_BizModules_UPG_Album_Kopie] FOREIGN KEY([AlbumId])
REFERENCES [dbo].[BizModules_UPG_Album] ([ItemId])
GO
ALTER TABLE [dbo].[BizModules_UPG_Photo_Kopie] CHECK CONSTRAINT [FK_BizModules_UPG_Photo_BizModules_UPG_Album_Kopie]
2. Copy data from the table: BizModules_UPG_Photo of the album to the table: BizModules_UPG_Photo_Kopie
INSERT INTO BizModules_UPG_Photo_Kopie
(AlbumId, Title, Description, Link, Src, Approved, CreatedByUser, CreatedDate, LastModifiedDate, SortOrder, DownloadId, TnWidth, TnHeight, ExifDescription,
TakenDate )
SELECT AlbumId, Title, Description, Link, Src, Approved, CreatedByUser, CreatedDate, LastModifiedDate, SortOrder, DownloadId, TnWidth, TnHeight, ExifDescription,
TakenDate
FROM BizModules_UPG_Photo AS BizModules_UPG_Photo
WHERE (AlbumId = 98) 3. Select all photo's in the manage photo's and klik remove.
4. Copy the original JPG files to the Large directory.
5. Run synchronise
6. Update the table: BizModules_UPG_Photo with the data that you made a copy in step 2. from the table: BizModules_UPG_Photo_Kopie.
UPDATE BizModules_UPG_Photo
SET BizModules_UPG_Photo.Title = BizModules_UPG_Photo_Kopie.Title, BizModules_UPG_Photo.Description = BizModules_UPG_Photo_Kopie.Description,
BizModules_UPG_Photo .SortOrder = BizModules_UPG_Photo_Kopie.SortOrder
FROM BizModules_UPG_Photo INNER JOIN
BizModules_UPG_Photo_Kopie ON BizModules_UPG_Photo.Src = BizModules_UPG_Photo_Kopie.Src AND
BizModules_UPG_Photo .AlbumId = BizModules_UPG_Photo_Kopie.AlbumId 7. And you have the Title, Description, Sortoder with the photo's again. |
|
|
|
|
Andre van den Berg
Posts:89
|
| 06/16/2008 3:04 AM |
|
Why do i still see in the presentation the file name in the title and the same in the lightbox. Is there somewhere cache?
How to solve this.
In the manage photo's i see the title en description correct. |
|
|
|
|
Pengtsen R
Posts:4596
|
| 06/16/2008 4:19 AM |
|
| maybe you should edit a photo to clear the xml cache. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Andre van den Berg
Posts:89
|
| 06/16/2008 6:33 AM |
|
| How to regenerate xml cache? |
|
|
|
|
Pengtsen R
Posts:4596
|
| 06/16/2008 8:29 PM |
|
| edit a photo, any photo, then UMG regenerate it. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Andre van den Berg
Posts:89
|
| 06/16/2008 9:19 PM |
|
| I did that and it's working, thank you. |
|
|
|
|
Pengtsen R
Posts:4596
|
| 06/17/2008 6:18 AM |
|
| great. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
|
| You are not authorized to post a reply. |
|
|
|
|
|
|
 |
 |
|
 |
|