Yes, EasyBadge can be connected to external databases via its Open Database Connectivity feature (OBDC). Before we answer how to set it up, it’s important to keep a few things in mind:
Before setting up an ODBC connection, there are some pre-requisites to consider:
To change the external connection, you must carry out the following:
1.Click into the main EasyBadge menu via the button in the top left-hand corner of the program.
2. Click ‘Modify Database’.
3. Click ‘Database Settings’. From here, you can adjust the sync settings as shown below.
Backing up your database is important, and below we’ve outlined how to carry out a back up on all the data that sits in your EasyBadge database.
Remember that if you’re using the smartphone app to send data to the database and you make a copy of files, the data will be downloaded to the database along with the copy.
For data to appear on the EasyBadge mobile app, it’s necessary to send the data to the cloud. To do this:
Now the pushed data will show all records have been pushed. The data will periodically update to the app each time the database is edited.
1. Ensure you can browse the location of any database file (.mdb) that you need to move. You’ll be able to see these by going to ‘Settings’ > ‘Databases’ via the main EasyBadge menu.
2. Now you can browse to this location in Windows File Explorer and move the .mdb file you want to relocate to your desired folder or server location.
3. Next, open up the database from the new location and click the EasyBadge menu button and select ‘Open Database’. From here select ‘Access’ as the type.
4. Browse to where the database file has been moved to and highlight the file. Click ‘Open’ to open it and start using the database.
If you need to delete an EasyBadge database that is saved on to a computer, you can do it by:
You can create a database on a SQL server by carrying out the following:
The new SQL database will be blank, so you’ll need to import the old data separately. You can find help on importing here, but for quick reference:
If you need to remove permissions of a phone or paired mobile device from your EasyBadge software, carry out the following:
You aren’t able to easily export images en-masse in EasyBadge, but you can save photocard-style images to your computer. To do this, right-click and select ‘Save Image’. You’ll now be able to select a file name and save it to your computer or a device.
EasyBadge also has an ‘Image on Disk’ feature that allows you to reference images in a folder. This means you don’t have to load them directly into the database table.
To connect to a non-EasyBadge database, you’ll need to create a custom database within EasyBadge itself. Before we tell you how, we’ll assume:
If you follow the below process, you’ll help create a custom database when the wizard doesn’t include fields that are required. If you’re undertaking a larger print project, you’ll need to create more specific fields.
If your print has some specific requirements, you might want to link it to a larger parent database. You can do this with a combo of using the database wizard and adding fields manually.
This will then bring up a new list with all the fields you can add into your database. Some of these won’t have been available in the wizard example earlier. Once you’ve picked the fields you want to create, click ‘Create’ and then type in the associated field names and specify how many characters you wish to fit in your field.
This will then update your database and you’ll have your fields. Once you click ‘OK’, each field will be added.
The above should provide you with the knowledge to create your custom database, but it’s worth bearing in mind you can modify your fields further if required. Some examples include:
Need to add a field to your ID card? You can do it manually with EasyBadge. The instructions below will guide you through the process:
Adding an extra unique field to your EasyBadge database is a simple process. We’ve outlined the best way to go about it in the instructions below.
1. Click the menu button in the top left of the EasyBadge program window.
2. Click ‘Add Field’.
3. In the Add Field window, select ‘Text Field’ and click the ‘Create’ button.
4. Name the field according to your needs. In this example, we’ve used ‘Payroll Number’. Once you’ve done this, click ‘OK’.
5. Your database will now need to close and reopen, so click ‘OK’.
6. You now need to change the properties field. Click into the main EasyBadge menu in the top-left of the program window.
7. Select ‘Modify Database’ and then click ‘Modify Field’. Once you’re in the window, click on ‘Payroll Field’ and change the unique value to ‘True’.
8. Click on any part of the window to refresh the view, then click the ‘Save’ button. The changes will now be saved.
9. Click the ‘X’ in the top-right corner.
10. You’ve successfully added an extra unique field to your EasyBadge database.
When you add a record, there’ll now be a field that holds the Payroll Field. Now, when you try to add a new record which has the same data in that field, you’ll be reminded by the above message.
If you’re working within a database, it may be necessary to make a unique ID field visible to discover the order in which it was originally created. To do this: