Follow these steps if you want to create a project using an external data source as your primary source of information. If you want the local BadgeMaker Identity project to be your primary source of information, please refer to chapter 2.2<\/p>\n
We will start by creating a new project. Click the New Project icon and select \u201cCreate a new BM CONNECT project\u201d from the dialog.<\/p>\n
#SCREENSHOT2#
\nEnter a name for your project and click \u201cNext\u201d. BadgeMaker will now create the internal database structure to base your project upon. Click \u201cNext\u201d once the process is complete. The third step in the process is the definition of data sources.<\/p>\n
Click \u201cAdd data source\u201d to create a new data source. By default, the data source will be set to a Microsoft SQL Server, which can be changed to an ODBC data source by selecting it from the \u201cType\u201d dropdown box.<\/p>\n
After selecting Microsoft SQL Server as the type of data source, you are able to fill in all information required to connect to the server.<\/p>\n
Server: Path or IP address to the server. If the server is hosted on another system in the network, it can be either addressed as \\\\servername or the IP address of the server (see item A in the screenshot below).<\/p>\n
Information such as the database name (or name of the view) username and password will be provided by your database administrator. Note that in order to be able to work with a Microsoft SQL Server, an active network connection must be available.<\/p>\n
After selecting Microsoft Access as the type of data source, you are able to fill in all information required to connect to the database.<\/p>\n
Simply click the “Browse” button, and navigate to the location of the project file on your local drive or network drive. Some Access databases require an username or password, which can be entered below.<\/p>\n
Click the “Test connection” button to ensure the connection can be established, and continue with the next step.<\/p>\n
After selecting MySQL as the type of data source, you are able to fill in all information required to connect to the database.<\/p>\n
Similar to the Microsoft SQL Server data source type, the MySQL type requires information on the location and access to the server in order to function. <\/p>\n
Server: Path or IP address to the server. If the server is hosted on another system in the network, it can be either addressed as \\\\servername or the IP address of the server.<\/p>\n
Information such as the database name (or name of the view) username and password will be provided by your database administrator. Note that in order to be able to work with a MySQL, an active network connection must be available.<\/p>\n
Click the “Test connection” button to ensure the connection can be established, and continue with the next step.<\/p>\n
After selecting ODBC as the type of data source, you will be able to select one of the ODBC drivers installed on your system. Please note that Windows may have more than one driver installed per file extension. In this example, we have selected the Microsoft Access Driver (*.mdb) for our data source (see item B in the screenshot below).<\/p>\n
After selecting the driver, you are able to provide a direct path to your database file. The path to the database needs to be formatted in a certain way, for Microsoft Access (*.mdb) files, the format is:<\/p>\n
DBQ= example: The connection string and information may differ per ODBC driver. A website such as connectionstrings.com may provide you with information on how to connect with your database using an ODBC connection.<\/p>\n Note that in order to be able to open your project using a remote directory, an active network connection must be available.<\/p>\n After configuring the data source, click the button \u201cTest connection\u201d. Once the dialogue reports \u201cConnection OK!\u201d you are able to proceed. If the connection cannot be established, the dialogue will report a detailed overview of the problem. Check all information and make sure a connection with the external server is available before trying again.<\/p>\n Once the connection is established, click \u201cAdd table\u201d in order to continue configuring your data source. A pop-up dialogue will list all tables available for you. Microsoft SQL Server, Microsoft Access and MySQL data sources will likely only list database tables, where other files (such as MS Access databases over ODBC connections) might also list tables otherwise invisible to the user.<\/p>\n After selecting a table, you are able to configure the rights to the table, and to each of the listed columns in the table. Users connecting with a Microsoft SQL Server, MySQL or Microsoft Access database will also be able to create and remove rows, whereas users connecting through an ODBC database will only be able to select the \u201cEdit data\u201d checkbox for existing rows.<\/p>\n Note that the newly created data source will have the \u201cPrimary table\u201d checkbox checked. This setting can only be altered during the process of defining the data sources, so make sure that the primary table is correctly configured.<\/p>\n For a primary table, you are able to define the \u201cId column\u201d this is a column containing unique, numeric data. For secondary tables, you have to define its relation to the primary table or to one of the tables linked to the primary table. This means that each table will have to contain a column containing a corresponding type and kind of data. It is advised to keep the column marked as \u201cId column\u201d as read-only or even hidden if the data in the column is not crucial to users working with the data grid.<\/p>\n The list of columns can be used to define certain restrictions to each column such as \u201cRead-only\u201d or \u201cHidden\u201d. By default, columns will be marked as \u201cRead-only\u201d. Think carefully about what data you want to manage through BadgeMaker, and what data should be managed by other external systems.<\/p>\n Once complete, you are able to define the image sources for passphotos and signatures in your project. You are able to choose from three different options:<\/p>\n \u2022 Read image from local project \u2022 Read or download image from path or URL \u2022 Read image from database (blob) Images will have to be linked to a record in the database in the same way data sources are linked to each other. It is highly recommended to choose the \u201cId column\u201d of the primary data source as the source. BadgeMaker Connect will use the filenames of the images to match between images and records. Only exact matches will be imported in the project.<\/p>\n Once all the steps have been completed, click \u201cFinish\u201d and your project will be created.<\/p>\n In addition to creating project around an external data source, it is also possible to add external information to data that is already available in an existing BadgeMaker Identity project.<\/p>\n If you want to configure your existing BadgeMaker Identity project to use data sources, go to the Project Settings panel, and choose Data Sources under the BadgeMaker Connect tab. The approach to configuring the data sources is very similar to the process when creating a project from scratch, please refer to chapter 2.1 for a detailed explaination.<\/p>\n The main difference compared to creating a new BadgeMaker Connect project is that the local project data will always be your primary source of information. This means that any external data source will have to include a column that matches one of the columns in your local project data. <\/p>\n Attention: The software will only join tables when a corresponding record is found in both the local and the external data, which means that if you have a local project with 10 records, and an external project with 20 records, only the 10 records that match the local project will be displayed in the datagrid. The software will automatically complement the data in case a new record is added that has a correspondence with one of the records in the external data source.","protected":false},"excerpt":{"rendered":" BadgeMaker Connect How to set up a BadgeMaker Connect Project Follow these steps if you want to create a project using an external data source as your primary source of information. If you want the local BadgeMaker Identity project to be your primary source of information, please refer to chapter<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":2582,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-user-guide.php","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-2627","page","type-page","status-publish","hentry"],"yoast_head":"\n
\nDBQ=C:\\Projects\\Databases\\Db.mdb;<\/p>\nDefining the data sources<\/h6>\n
\nSelecting this option stores captured images along with the BadgeMaker Identity project files. This option can be used to capture new image data.<\/p>\n
\nThis option allows you to read images from a remote directory either on a server or on a network drive. This can only be used to read image data. New data cannot be captured.<\/p>\n
\nThis allows you to read an image from a specific column in the databased marked as BLOB (Binary Large Object) This option can be used to both read existing data and capture new image data to the database.<\/p>\nHow to set up data sources for existing projects<\/h6>\n