Extracting data from selected label + group in panel + docking

Suggestions for new functionality in NiceLabel. Do you want some feature but can't find it in the NiceLabel software? Post your wish here. Note: This is not a support forum.

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
FunDeckHermit
Enthusiast
Posts: 14
Joined: Fri Apr 20, 2018 1:58 pm

Extracting data from selected label + group in panel + docking

Post by FunDeckHermit » Fri Apr 20, 2018 2:45 pm

Hi,

I've been using Nicelabel Powerforms and am really liking the user interface and ease of use.

A few features are missing in my humble opinion:
  • A method of extracting data from the label like the rotation, size, width.
    This could be used to automatically select a specific printer.
    One could also use the rotation of the label to rotate the PrintPreview on Mouse Enter
  • A second feature would be to group controls in some sort of panel.
    This panel can be rotated, coloured, zoomed and would have a visibility
  • A third feature would be to dock these panels just like a windows forms application.
    You'd need to re-create the Document Outline windows from visual studio. You could re-use the arrows that are currently in use in the event manager.
  • A Dictionary to store Key,Value pairs. This could be used as a way to map variables one-to-one.
  • Use a config-file to store database connections, switching the datasource from a test-environment to the costumers database is somewhat difficult. A variable from a file or even using a normal variabel would help.
  • A last feature I would like to see is running SQL without freezing the UI-thread.
    Currently I'm using a hack with Powershell to run the Query and polling the execution count in the Document timer event.

    Powershell hack: (open file)

    Code: Select all

    powershell.exe -command "Invoke-Sqlcmd -ServerInstance '.\sqlexpress2014' -database 'DatabaseName' -Query 'EXEC dbo.StoredProcedureName'"
    Polling query: (SQL-statement)

    Code: Select all

    SELECT TOP 1  
    	execution_count
    FROM sys.dm_exec_procedure_stats
    WHERE OBJECT_NAME(object_id) = 'StoredProcedureName'
    Order by last_execution_time DESC
I think some of these features will enhance the user experience of Nicelabel Powerforms.
Some of these features might already be implemented in NiceLabel Automation.
All feedback is appreciated.

User avatar
dado
NiceLabel Development
NiceLabel Development
Posts: 663
Joined: Tue Sep 12, 2006 12:50 pm
Location: Kranj, Slovenia
Contact:

Re: Extracting data from selected label + group in panel + docking

Post by dado » Tue Apr 24, 2018 9:39 am

I can answer that this one is already implemented: Use a config-file to store database connections, switching the datasource from a test-environment to the costumers database is somewhat difficult.
A variable from a file or even using a normal variabel would help.


To read about it open the following document:
https://www.nicelabel.com/resources/fil ... ide-en.pdf
And check the -> 8.3.5 Database Connection String Replacement

About the: A method of extracting data from the label like the rotation, size, width.
There is an action that extracts data from the label. It is called "Get Label Information". But this cannot be used in a label but on forms and in Automation.

Other features will have to be discussed here in the HQ and then we'll see what can get implemented in the future releases.

Regards, Damjan

FunDeckHermit
Enthusiast
Posts: 14
Joined: Fri Apr 20, 2018 1:58 pm

Re: Extracting data from selected label + group in panel + docking

Post by FunDeckHermit » Mon Apr 30, 2018 1:18 pm

Hallo Dado,

Thanks for your reply, I will check the PDF you provided.

User avatar
Saso
NiceLabel
NiceLabel
Posts: 2929
Joined: Mon Sep 04, 2006 8:09 am
Contact:

Re: Extracting data from selected label + group in panel + docking

Post by Saso » Tue May 08, 2018 3:20 pm

Additionally to Dado's comment, this feature is kind of already available.
A Dictionary to store Key,Value pairs
You can use the action Save Variable Data to save data to delimiter-structured text file.
Then you would use the action Load Variable Data to load the data back.
Saso Fleiser
Senior Technical Product Specialist

Post Reply