[en] NiceLabel Web Client is the Web Printing client that loads the NiceLabel label or solution file from Control Center and runs it locally. All communication with the server is done via "Web Printing" component installed in the Internet Information Services (IIS). The same component also displays the login screen for Web Printing.
[en] When the Client needs data from a database or external system accessible over HTTP and/or Web Services methods, the connection can't be. The connectivity redirects to the "Web Printing" component, which receives the data and sends it back to the Client.
[en] If you use a server-based database (such as Microsoft SQL) or Microsoft Excel/Access files saved in the file system on the local or network drive, there should be no problems.
[en] If you want to use the Microsoft Excel/Access files saved in the Document Storage, you have to set up the system correctly.
Note
[en] The information in this article applies to the on-premise variant of the NiceLabel Document Management System (NiceLabel LMS Enterprise).No configuration is necessary when you use a cloud-based NiceLabel Document Management system (Loftware Cloud).
Note
[en] The access to Microsoft Excel or Microsoft Access documents stored in Document Management System is read-only. You cannot change the content of data files and save them.
[en] ON THE SERVER (ONE TIME CONFIGURATION)
[en] NOTE: The steps in this section apply only for NiceLabel Web Printing 2017. In NiceLabel 2019, you can use 32-bit or 64-bit database drivers.
-
[en] Install the Microsoft Access Database Engine (ACE) Redistributable on the server, where the "Web Printing" component is installed. For availability of ACE packages, see the KB article Connectivity to Office documents on 64 bit platforms.
[en] Install the same version as you have installed on the computer where you design your labels/solutions.
-
[en] On the server with "Web Printing" installed, run IIS Manager.
-
[en] In the list of Application Pools, select EPMWebPrintingAppPool.
-
[en] Right-click it and select Advanced Settings.
-
[en] If you have installed 32-bit database drivers, set the option Enable 32-Bit Applications to True.
-
[en] In Advanced Settings, find the option Identity.
-
[en] Change the default identity ApplicationPoolIdentity into the real Windows user account that has permission to the folder in the Document Storage, where you have saved the Microsoft Excel/Access file.
[en] The access permissions to Document Storage are defined in the Administration tab in Control Center.
-
[en] Click OK in all dialog boxes.
-
[en] In IIS Manager, select Default Web Site, then double click the Request Filtering icon.
-
[en] Delete the .MDB file extension from the list.
-
[en] In IIS Manager, select the EPMWebDav site, then double click the Request filtering icon.
-
[en] Delete the .MDB file extension from the list.
-
[en] If your "server" is Windows Server operating system, make sure to install the Desktop Experience feature. This installs the "Microsoft.Jet.OLEDB.4.0" provider to access .XLS file types. For installation details, see Control Center installation guide.
[en] ON THE DESIGN COMPUTER (FOR EACH LABEL/SOLUTION)
-
[en] When configuring the database connection in NiceLabel Desktop Designer, use the full path to the database in Documents storage. Relative paths doesn't work. Use the UNC syntax (\\server@8080\davwwwroot\folder\database.accdb).
-
[en] If you have enabled HTTPS traffic to your Document Storage (EPMWebDav site has enabled HTTP traffic), the UNC syntax is \\server@ssl@8080\davwwwroot\folder\database.accdb).
-
[en] When configuring a database connection, use the modern database provider (such as Microsoft Office 12.0 Access Database Engine OLE DB Provider).
[en] NOTE: Avoid using Microsoft Office 16.0 Access Database Engine OLE DB Provider. Occasionally, it might stop responding and cause NiceLabel service NiceLabelEPMProxyService to fail (you will have to restart it).
-
[en] In the Advanced tab, enable the option Share Deny Write and disable the option Share Deny None for Access permissions.