1. First start
When starting Sharpcode for the first time, the program will create it's postgresql database, named sharpcode. In order to do so, you will be asked to provide the following postgresql parameters :
- Host (default : localhost)
- Port (default : 5432)
- Username (defaut : postgres)
- Password (the one you entered in the installation wizard)
The configuration will be stored in a json file named : config.json. The password will be crypted.
2. Login
The default user name is : Admin
There is no password (empty) 🙀.
3. Create your first label model
3.1 Directories
The models can be organized in directories. you can manage you directories using the Folder menu, as shown in the following screenshot
- New folder : Create new folder or directory
- New sub-folder : create a child directory for the selected directory (parent)
- Edit folder : Edit the selected directory name
- Delete folder : Delete the selected directory
3.2 Models
You can manage your label models using the Models menu as shown in the following screenshot
- New model : Create a new model by providing his Name, Default printer and File Name (ex : label_product_50_25).
- Edit model : Edit the selected model informations
- Delete model : Delete the selected model
3.3 Sample data
Sample data are ready to use informations, that you can use to create your label model without the need to connect to a real data source (csv, sql server database ...). You can provide your own sample data as shown in the following screenshot
You can preview the selected model with the sample data, by clicking on the Preview button.
3.4 Designer
After creating a empty model, let's name it for example Product 50x25 Label, click on the Designer button to start..., well, design it.
The designer starts as shown in the following screenshot
- The Properties panel allow you to set your label size (Height and Width).
- The Field list panel allow you to add fields into your label by a sample Drag and drop
- The Tools on the left enable you to add different controls such as a Text, Barcode, Image, Table ...
- The Preview tab (on the top right corner), enable you to preview your design.
When the design is ready, you can save it in the Reports folder (in the installation directory). The file must be named as mentioned when creating the model.
4. Data source
To print label of your data, you should first connect to a data source. Sharpcode can handle various type of data source such as a Csv file, PostgreSql or Sql Server database ...
To add a data source, click on the data source menu, the New, and select the type of data source you want.
I will choose PostgreSql database for our example.
Fill the required fields to connect to your data source, if it's a data base, you will be asked to provide a select query as shown on the following screenshot
The data will be shown in the Data Source tab as shown here
you can then select your model, and preview the labels you designed.
5. Printing and Exporting
You can print the labels for the selected model, and the current data source using the default printer of the model (set when creating the model).
You can export the labels into images (JPG, PNG) or PDF file.
And you're done 👍









