Jump to content

[875] [927]- Color Lables


rene

Recommended Posts

Hey Murat,

I use the color lables for sorting out pictures to order. Can I assign a key like the "W" to an action?

 

e.g. I click on "W" for uploading them to my blog, therefore I would need to resize them to the perfect size for galleries, but this is not implemented by now.

 

Or "D" for dropbox

 

 

thanks, rene!

Link to comment
Share on other sites

Today I realised something new.

 

The order the Color Lables are set is messed up. post-1019-0-70889100-1380094042_thumb.png

 

originally I had

- 1x bestellen

- 2x bestellen

- 3x bestellen

- 4x bestellen

- 5x bestellen

- 6x bestellen

- 20x30 vergrößern

- Panorama

- Fotobuch

 

1x bestellen started with the number 1 going down to 9, this still works, but the view is messed up, so I always need to try it out.

 

 

And as mentioned above could I instead of Numbers assign letters? (Maybe rename Color Lables" to "Lables" or "User Generated Labels")

 

 

Thanks, rene!

Link to comment
Share on other sites

Hi Renee,

 

I found a workaround for the sort order, just run the following query and your color label tags will be now in alphabetical order:

 

  • For safety, stop your Daminion server (and backup your database :))
  • Start pgAdmin III from your windows start menu
  • Under the Object browser panel, double click on your PostgreSQL instance:
  • post-97-0-69770800-1380104924_thumb.png
  • Enter your postgres user account's password (usually 'postgres')
  • Expand the tree at the left to: Databases -> Daminion and hit the 'SQL' button on the toolbar:
  • post-97-0-64973700-1380104928_thumb.png
  • Copy and paste the code bellow into the editor and hit the green 'Run' button
  • Start your Daminion server and client

 


--Set the sortorder column values with the alphabetical order from your labels
UPDATE	colorlabel_table
SET		sortorder = r1.alphabeticalorder
FROM	(
		SELECT (row_number() OVER(ORDER BY c2.value ASC))-1 AS alphabeticalorder,
				c2.id
		FROM colorlabel_table c2
	) r1
WHERE	colorlabel_table.id = r1.id;

--Create an index to use for clustering
CREATE INDEX colorlabel_table_sortorder
ON public.colorlabel_table USING btree (sortorder int4_ops);

--Reorder the "physical" table
CLUSTER colorlabel_table USING colorlabel_table_sortorder;

--Drop the index to clean the database
DROP INDEX colorlabel_table_sortorder;

 

Hope it helps

 

Regards

Link to comment
Share on other sites

ok there seems to be a problem.

 

I stop the Server and make a backup, that worked fine. than I'm trieing to login to the postgres. I always get the error "Server is not responding" I tried passwords: postgre" and "postgres" nothing works.

 

I even restarted the server machine itself. Any Ideas?

 

thanks!

Link to comment
Share on other sites

ok there seems to be a problem.

 

I stop the Server and make a backup, that worked fine. than I'm trieing to login to the postgres. I always get the error "Server is not responding" I tried passwords: postgre" and "postgres" nothing works.

 

I even restarted the server machine itself. Any Ideas?

 

thanks!

 

Weird thing, could you check if the postgresql service is running? (Administrative Tools -> Services).

It it is not, does it give you any error if you try to start it?

 

Regards

Link to comment
Share on other sites

Yes, after entering the password, either "postgres" or "postgre" I get the following screen. post-1019-0-60976900-1380212530_thumb.png

 

Something like "Server is not answering"

 

If Daminion is working fine, then probably the pgAdmin connection is pointing to a different server/port. Check if the connection's properties (right click-> Properties) match your postgres instance. I'm guessing probably the port may be different than the one where the postgres server is running on (you can check the port in the Daminion Server Administrator on: File -> Preferences -> PostgreSQL).

Link to comment
Share on other sites

  • 4 weeks later...
  • 1 month later...
  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...