[875] [927]- Color Lables

[rene]

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!

[rene]

Today I realised something new.

 

The order the Color Lables are set is messed up.

 

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!

[exterminador]

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:
  
• 
  
• 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:
  
• 
  
• 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

[rene]

Thanks Exterminador,

I will try it later.

 

[rene]

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!

[exterminador]

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

[rene]

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

 

Hey Exterminador, I can check, but I guess it is running since Daminion works.

[exterminador]

Hey Exterminador, I can check, but I guess it is running since Daminion works.

 

Hi Rene, do you get into this screen? Do you have only one connection at the left? Could you add a screenshot of that screen?

 

[rene]

Hi Rene, do you get into this screen? Do you have only one connection at the left? Could you add a screenshot of that screen?

 

 

Yes, after entering the password, either "postgres" or "postgre" I get the following screen.

 

Something like "Server is not answering"

[exterminador]

Yes, after entering the password, either "postgres" or "postgre" I get the following screen.

 

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).

[rene]

Exterminador, thank you! This worked! The port at the pgAdmin 3 was slightly different than in Daminion Server Admin.

 

Thanks!

[rene]

In built 905 this Issue is still active. Murat was telling me, not to modify the databse so, but this issue still appears.

[rene]

Ok this is still active in 923.

 

[rene]

in the current buil 951 this is still occuring