Issue When attempting to use the Read Card button to read credentials from a card reader the following error is shown. Failed to read the card from the reader Failed to read cardFailed to read cardFailed to read card Product Line Security Expert Environment Security Expert Client Proximity Card Encoder (PRX-ENC-DT) Cause A Proximity Card Encoder (PRX-ENC-DT) is not connected to the Workstation. Resolution 1. Using a USB connection, connect a PRX-ENC-DT to the Workstation. The USB connected card reader can be used to read new cards and add those card credentials to a User by placing the card on the reader and pressing the Read Card button in the User object. Read CardRead CardRead Card This will read 13.56MHz Schneider encoded Mifare and DESFire cards. The encoder is not able to read 125KHz cards.   2. Using alternative methods for adding credentials to Users Manually adding the Facility and Card Numbers to an available slot in the User object. Badging the card at a Card Reader and right-clicking the resulting access event in the Status Window and selecting to add to an existing or create a new User. Use the Data Sync Service to import Users, and changes to Users, from CSV files. See Mass importing User Photos into Security Expert using Data Sync Service for an indication of how the Data Sync Service is configured.

Issue How to use a digital point card with a Network 8000 MicroZone II controller. Product Line TAC IA Series Environment Network 8000 MicroZone II controller Digital Point Card Cause To use the digital input cards (DPC-3-1 & DPC-3-2) with a MicroZone II controller, it requires a custom application file. Resolution The MicroZone II controller supports two digital input cards:  DPC-3-1 & DPC-3-2. A custom application file (1-DPC3.MZ2) is required to properly read the digital input card, review technical bulletin TB01-26 for more details. (Note: The DPC-5 series cards were designed for the MNL and MNB controllers.  They are compatible with the DUI Expander Object available for both controller lines.)

Issue Does the entire SBO system need to be upgraded to 1.5.0.171xx, 1.6.2.12xxx or 1.7.2.111xx before upgrading to 1.9.1 if the network includes LON devices? Can SBO be upgraded directly to 1.9.1 from 1.5.X, 1.6.X or 1.7.X? Product Line EcoStruxure Building Operation Environment SBO Workstation 1.5.0/1.6.1/1.7.1 SBO ES 1.5.0/1.6.1/1.7.1 SBO AS 1.5.0/1.6.1/1.7.1 SBO AS-P 1.7.1 Cause In systems that have SBO servers that already are hosting LON devices based on LonWorks imported device templates (.XIF) or resource kits (.DRF), the servers need to be prepared before an upgrade from versions 1.5/1.6/1.7 to version 1.9.1. Even servers where device templates (.XIF) or resource kits (.DRF) are just imported, and no devices or network variables are created yet, the servers have to be prepared before the upgrade. Resolution Please see section 9.2.3 of SBO 1.9.1 Release Notes. Although it says "Steps to upgrade a 1.6.2/1.7.2 multi-server system" you don't have to upgrade the AS or ES etc, even if they run 1.6.1/1.7.1, it's only SBO Workstation that need to be hotfixed. Links to the different Workstation hotfixes can be found Server with LonWorks devices - TPA-SBO-17-0002.00 - Links to hot fixes. If there are no LON devices in the system, you may upgrade directly to 1.9.1 from 1.5.X/1.6.X/1.7.X

Issue What is the process to replace a CX9400 with a CX9680 NC2? Product Line Andover Continuum Environment Upgrading a CX9200, CX9400 Eclipse, CX9900, CX9940 to a NCII Netcontroller. CMX9924. Model Number, Type change. Cause Where can I get the process to upgrade my obsolete CX controller. Resolution Cyberstation V1.74 SP2 or above is required to support the upgrading process of a CX9200, CX9900 and CX9940 up to a Netcontroller 2. The upgrade process for this is detailed in Appendix B or the NetController II Operating and Technical Reference Guide. For the CX9400 Eclipse controller they require a minimum of V1.91 to support the upgrade. For the older versions of Cyberstation that do not support direct upgrading of a model number, you will need to bring the Netcontroller II on line as a new controller, then in offline editing copy /paste (or Drag /Drop) all objects over to the Netcontroller II. Then go online and fully reload the Netcontroller II and any connected Infinet controllers. The old controller can then be deleted from the system. The objects could also be copied over using edited ASCII dump files if you prefer that method, but either way you may still have to re-animate your Pinpoint graphics unless you upgrade to a version that supports the Netcontroller II replacement. NOTE ACC-LON RS-485 and ACC-LON FTT-10A protocol options A CX9900 may be labeled CPU-8M and a CX9940 labeled CPU-4M. Later CX99 models may have FT added, eg. CPU-8M-FT When replacing a CX9900 or CX9940 it is vital to know if it requires an RS485 or FTT10 IOU module port (if this port is being used) as this CANNOT be modified on site. See article titled No response from I/O module when learning in an IOU This process cannot be used to upgrade the CMX9924 controllers.  The available range of Netcontroller II controllers available has recently been reduced, see PA-00535 "Andover Continuum Offer Optimization"

Issue Need to activate an Output when access is denied to a User at a Door. Product Line Security Expert Environment EcoStruxure Security Expert Cause In the Door object, there is a facility for triggering Outputs on Pre Alarm, Door Left Open, and Door Forced Open but nothing for when a User is denied access. Resolution There were new Door commands added to SP-C firmware 2.08.1018 and newer to add this functionality. AccessDeniedTime = # has been added to the Door commands which will specify the duration in seconds that an output or output group will be activated for when access to the door has been denied. This must also be paired with one of the following 2 commands in order for the functionality to occur. AccessDeniedOutput = # has been added to the Door commands which will specify the output that will be activated when access to the door has been denied. The # will be the database ID of the output/output group. AccessDeniedOutputGroup = # has been added to the Door commands which will specify the output group that will be activated when access to the door has been denied. The # will be the database ID of the output group. As an example, if you wanted the Output with an Id = 3 to turn on for 5 seconds when access is denied at the Door, the following lines would need to be added to the Door object in the Commands section. AccessDeniedTime = 5 AccessDeniedOutput = 3 Door Command - Access Denied OutputDoor Command - Access Denied Output  

Issue How to tell if the Filemaster or Client is equalized Product Line TAC INET Environment I/NET Seven Cause Equalization Questions Resolution Take a look at the INET Seven Icon at the bottom right portion of the client’s screen.   For full details see TCON 298 - Getting Started page 3-2

Issue What configuration is required for a Multical BACnet heat meter Environment Schneider Electric (Kamstrup) heat meter connected to a Continuum or SmartStruxure system on MS/TP. Multical 61/62/601/602/801 Cause Setup information required Resolution With the BACnet interface card fitted in the Multical meter it is a native BACnet MS/TP device. Connect it to the AS or bCX1 depending on your system and Learn/ find BACnet devices. It should appear online and allow the objects to be uploaded. A typical unit like the Multical 602 will contain 12 Analog Inputs for all of the information from the meter. The Meter will operate at 9600, 19200, 38400, 57600 and 76800 Baud rates and autobaud to the connected system. For the Datasheet  Click Here. For the BACnet PICs statement Click Here. For help with Heat meter selection see the online selection tool: Online Heat Meter Selection Tool - PA-00216

Issue How do I set up Seven Trends? Environment I/NET site Cause How to setup Seven Trends Resolution I recommend you read about this in TCON 299 (INET Seven System Operator Guide). The overall sequence for using the SevenTrends features of I/NET Seven is as follows: Configure DCUs to collect data. Define trends in host stations to receive data. Configure host stations to receive collected data. Set transfer parameters. Archive SevenTrends data. Create SevenTrends reports (may be done any time after Step 3 is complete).  Refer to the SevenReports help file for more information on creating reports.

Issue How to set up M-Bus for Heat meters using Westermo AD-01 Environment Continuum Cause The M-Bus Xdriver is often loaded on Comm1 of a NC, NC2 or bCX (RS-232) this if often then connected to a Westermo AD-01 M-Bus adapter. How is this set up Resolution Westermo Connection Details Westermo web site AD-01 1. The Westermo unit requires a separate power supply, see AD-01 datasheet for power supply connection details (Nominally 230Vac) 2. Connection to an RS232 Controller comm port (NC2 or bCX comm1 used in this example) NC2      AD01    or     AD01 RJ45     DTEtop        9pinD RJ45     Slave           (Female) 5-SG     1-SG             5-SG 6-RD     4-RD            2-RD 8-TD     3-TD             3-TD bCX      AD01     or     AD01 9pinD    DTEtop        9pinD (male)   Slave            (Female) 5-SG     1-SG              5-SG 2-RD     4-RD             2-RD 3-TD     3-TD              3-TD 3. AD-01 Connection to an MBus network Heat Meters. (AD-01 METER BUS MASTER Terminals 4 & 5 to Terminals 24 & 25 on heat meter (Kamstrup or SE unit) MBus Card) The MBus baud rate is often set to 300 when the heat meters are powered by battery, the baud rate is set on the comm port of the bCX or NC2, this is automatically used by the heat meters so these do not require setting up. The heat meter address can be found in the meter menu See the XDriver guide and software for further details of controller set up NOTE To test it is often best to leave parameter 3 at zero, to ensure the standard telegram is sent, then set parameter 2 to one. The value seen is usually the Meter Customer number. (It has been seen with some issues of this Xdriver, that the controllers needs to be reloaded before the telegram is received and populates the Numerics correctly) Typical Screens

Issue How to change the IP address in the EC/ES software when it is grayed out. Product Line EcoStruxure Building Operation Environment Building Operation Enterprise Central (EC) and Enterprise Server (ES) Building Operation WorkStation Cause The EC/ES IP address is grayed out in the Network Tab of the Server Properties and cannot be changed.  This setting is only used to view the IP address that the server is currently using - typically the IP of the network interface card of the PC running this.  To change this setting it must be done through the Communications TAB of the server as detailed in the resolution.  Resolution EcoStruxure Building Operation 2.0 and above EBO 2.0 and above now supports multiple NIC configurations, see 2.0.1 Release Notes for details, in particular, the following note.   Note: That from 2.0 the server will still listen for incoming requests on all network adapters so this setting is only used for choosing which communication settings that the server will use to communicate with child servers. This allows other IP protocols on different networks, e.g. BACnet, Modbus, etc. to communicate with the Server.    It is now possible to select which network adapter the Enterprise Central and the Enterprise Server use.  See the following WebHelp Topic Configuring Network Interface Card for an Enterprise Server or for an Enterprise Central StruxureWare Building Operation 1.9 and below  When the IP address of the computer changes the ES will automatically update the "IP/DNS Address" in the Properties, Network tab. If your computer has multiple network connections, ensure that the Network Interface Card (NIC) to be used for the SmartStruxure network is set to be at the top of the list in the Adapters and Bindings. Go to the computer's Control Panel > Network Connections Select "Advanced, Advanced Settings... " from the menu. In the "Connections:" section, select the Network Connection to be used and press the up arrow to move it to the top of the list. For Windows 7 / Server 2008 See the following link on how to change the order of protocol bindings: How to change the network connection priority in Windows 7 For Windows 8 and beyond, please refer to Adapter priority setting unavailable in Windows 10 In addition to the ES Network Properties, there is also the Communication tab in the ES that lists all of the Server IP addresses in the system. If these need to be changed this can be done by selecting the server and clicking on the "Show/ Hide Communication settings" button circled in red below.

Issue Need to restore or do a clean installation on the Magelis Opti PC Magelis Opti PC has crashed or Windows don't load properly Magelis Opti PC has become very slow or unresponsive Product Line Other, TAC Vista Environment Magelis Opti PC Windows XP Embedded Cause Just like a regular PC the Magelis Opti PC may crash due to software errors, and it may also become slow after long time use. Resolution The procedure "Restoring the Operating System" is described on page 7 (pg. 11 if go by PDF page numbers) of the Magelis Opti PC Installation Guide (also available on the supplied DVD) Caution! Back up all important data on your primary drive before restoring your system. Restoring will delete all data on your drive, and your Magelis Opti PC will have the same software and data configuration as when it was delivered. Hardware required Reinstallation DVD-ROM: Magelis Opti PC Restore & Documentation DVD. An external DVD drive with USB adapter. USB keyboard. Restoration On Magelis Opti PC: Connect the external DVD drive to a USB port on the Magelis Opti PC. Power on the Magelis Opti PC. Press DEL to run the BIOS setup. Insert the restore DVD into the DVD drive. In the “Advanced BIOS features” menu, under “First boot device,” select “USB-CDROM.” Press F10 to save and exit. Select “Yes” when prompted to save your changes. At the MS-DOS C:\> prompt, type “RESTORE” and select your configuration. When the message “Proceed Restore [Y,N]” appears, type “Y.” The following message will appear to indicate restore was completed successfully. ***** Restore OK **** Restore may take several hours depending on the speed of the DVD drive. If any other message appears, contact your approved Schneider Electric technical center. Remove the DVD and press “CTRL+ALT+DEL” to restart the machine.

Issue How to remove the "Y" selected in the Alarm Inhibit Editor Environment I/NET site Cause How to remove the "Y" selected in the Alarm Inhibit Editor Resolution This node may not be saved in the workstation’s Network Configuration Editor. First save this device in network configuration, then attempt to modify the settings in the Alarm Inhibit Editor. Refer to TCON 237 Alarm Inhibit (AI)

Issue How to remove, from a Niagara R2 Enterprise Server station, data for all logs prior to a specific date with one command. Product Line TAC IA Series Environment I/A Series R2 Enterprise Server Cause Cloudscape database management Resolution There is a utility that will allow deleting of records before a certain date of all or specific tables in the cloudscape database. The space from deleted records can also be recovered after deleted. This utility is called CloudscapeAdmin and is downloadable from The Exchange Download Center. Download cloudscapeAdmin.jar and place in the x:\niagara\[NiagaraRevision]\nre\lib directory (for Builds 431 and higher). To run this utility the station will need to be stopped. Once the station is stopped, open the console from either the created short cut or x:\niagara\[NiagaraRevision]\nre\bin\console.exe. From here type ‘nre CloudscapeAdmin’ and hit enter to view the commands to use it.  There are two functions that cloudscapeAdmin can do: Delete; The delete command deletes records before a certain date but does not reduce the size used on the disk. The empty area of the database will be filled with new archived data. Compact; The compact command deletes records before a certain date and recovers the space from the disk. This process is slower. Command: nre CloudscapeAdmin x:\niagara\[Niagara Revision]\stations\[Station Name] [User Name] [Password] [delete or compact] [tablename or all] [date] Sample Delete commands: nre CloudscapeAdmin c:\niagara\r2.301.522a\stations\StationName admin admin delete all 2007-07-01 Sample Compact commands: nre CloudscapeAdmin c:\niagara\r2.301.522a\stations\StationName admin admin compact all 2007-07-01

Issue How to read individual bits from a Modbus Holding Register that holds a 16-Bit Word and represent each Bit as a separate Digital point Product Line EcoStruxure Building Operation Environment Building Operation Enterprise Server Building Operation Automation Server (AS, AS-P, AS-B) Modbus TCP/IP Modbus RTU (RS485) Cause There is a requirement for a Modbus Holding Register that is a 16-bit unsigned value, each bit represents a digital state in the Modbus device and to replicate this as 16 separate digital states in EBO. The 16-bit unsigned value is an integer with a range of 0 to 65,535 and needs to be converted into 16 digital values. Resolution Use a Modbus Digital Input point for each bit required. Each object will be configured to read the same Modbus register address, but with a different bitmask value applied prior to evaluating the value. For example: Read Modbus Holding Register 40123 with a value of 32769 (16-bit unsigned) and decode bits 0, 8, and 15 as three separate Digital points Since the actual Value of 32769 being read at address 40123 is shown in Binary as 1000000000000001 it can be seen that Bit 0 and Bit 15 should return TRUE while Bit 8 should return FALSE Configure each point as follows: Modbus Digital Input Point 40123 bit 0 Register number 123 Register type 16 bit unsigned Read function code 03 Bit mask - enable only Bit 0   Modbus Digital Input Point 40123 bit 8 Register number 123 Register type 16 bit unsigned Read function code 03 Bit mask - enable only Bit 8   Modbus Digital Input Point 40123 bit 15 Register number 123 Register type 16 bit unsigned Read function code 03 Bit mask - enable only Bit 15   Additional information can be found in the EcoStruxure Building Operation - Technical Reference Guide - Search for Bitmask.   If you need to break this bit information out for programming this can be done with a FB application and just binding the full 16 bits to the FB as shown here.

Issue How to order controllers with XDriver support How to upgrade a controller so it has XDriver support All NC2 options are not available as standard How to order node upgrade XDriver X-Driver X Driver Product Line Andover Continuum Environment 2 nd Generation Controllers with X Driver Port enabled NC2, NCII, Netcontroller 2 CX9680 bCX1, bCX9640 bCX4040  not bCX4000 ACX57xx ACX5720 ACX5740 CX9702 - No XDriver Support X-Drivers  Cause If the NC2 controller required has non standard XDriver requirement, then a standard unit must be ordered, then later upgraded Resolution NC2 (NCII, NetController 2, CX9680) This unit is only available with XDriver enabled on Comm1 (as an option). If other comms ports are required to have XDriver support then this can be ordered after the NC2 is received by ordering the upgrade (you need the serial number before the upgrade order can be processed) via your normal order entry facility. Option tab - example NC2 Xdriver Comm1 : 00000009 (0000)  (XDriver enable and but not loaded) Xdriver Comm2 : 00000000 (0000)  (XDriver not enabled) Xdriver Comm3 : 00000000 (0000)  (XDriver not enabled) Xdriver Comm4 : 00000000 (0000)  (XDriver not enabled) Only the NC2-F (fitted with FTT10 Lon IO option) can support the Echelon XDriver, this is enabled via the Web interface and loaded on to Comm16 in the usual way. If this Comm Port is used for an XDriver, then no IO can be connected to the NC. (This is a no cost option and does not require an upgrade) bCX bCX9640 bCX4040 - NOT bCX4000 The bCX has two comms ports, the XDriver functions can be enabled on none, either or both at the time of ordering (add X1, X2 or X12) Option tab - example bCX Xdrvr Comm1:00000009 (DF23)  (XDriver enable and loaded) Xdrvr Comm2:00000000 (0000)  (XDriver not enabled) ACX ACX5720 ACX5740 The ACX57x0 has a single comm port, the XDriver functions can be enabled at the time of ordering (see the Option tab - example ACX57 Xdriver Comm1 : 00000009 (0000)  (XDriver enable and but not loaded) NOTES 00000000=XDriver not enabled, 00000001=CommPort only, 00000009=CommPort & Ethernet enable, 00000011=CommPort & Access API enable (Schlage, Assa Abloy etc) The four digit number in bracket shows which Xdriver is load and corresponds to "Xdriver valid" at the bottom of the xdriver.xdr file. If Ethernet support is required on the port then this should be requested at the time of ordering. XDrivers like Modbus TCP/IP and Bacnet IP are loaded on to a comms port but communicate via the Ethernet port, therefore the XDriver Ethernet support needs to be enabled for these XDrivers to operate. The XDrivers and hardware update forms are available for download: For orders submitted through Sweden | For orders submitted through the U.S. If an Xdriver requires removing, then go offline, select the comm port, change to Autoset, return online then reload the controller Other upgraded to controllers, eg. node count upgrade is dealt with in a similar way. (Order upgrade, apply upgrade file using "OS Update") 2018 Offer optimising see Product Announcements, means that controllers are no longer available with XDrivers enabled, therefore the controller must be purchased, then upgraded.

Issue How to order Continuum v2.0 to take advantage of a Software license instead of a Hardware license. Product Line Andover Continuum Environment Continuum v2.0 and above Continuum Software Licensing Cause A new site requires software licenses, not hardware security keys. Resolution For details on how to order the licensing for Continuum software key see Ordering and Activation of Software License for Continuum v2.0 Note: Purchase a new Continuum Security Key before upgrading to a keyless license. The following is taken from the above document. A new installation – Software license ordering and activation is available only as an upgrade to a hardware key. For new installations please order the USB key from the factory, upon receipt follow the steps outlined hereon for upgrading your USB license to software license. The following products can be ordered with a Software Key: WebClient Server All factory Add-On options [–E (Endura), -D (Data Exchange/Active Directory), -B (Badging), etc...] CoE Add-On options. (see Continuum 2.0 Keyless Add-on Applications FAQ V1.0.pdf for details.) The following can not support a Software Key and will require a Hardware Key (USB or Parallel port): Continuum Interface Server

Issue How to monitor if equipment is running without running cables to additional sensors Environment Current Sensor switch Cause Running cables to and fitting sensors can be time consuming and expensive, are there other ways to monitor equipment? Resolution The current drawn by equipment can be monitored within a control panel using the Current Sensor devices.   This method of monitoring equipment will not replace other monitor methods, but will be suitable for some projects - Detecting belt loss, coupling shear and mechanical failures - Evaluating lighting circuit and other electrical service run times - Monitoring status of critical electrical equipment - Choose from Switch, 0-5VDC, 0-10VDC and 4-20mA     Information on current sensos can be downloaded from the Schneider Electric Exchange Extranet. Click here to be linked to applicable area.

Issue How to install Vista/Xenta Language packs Product Line TAC Vista   Environment Vista Server TAC Xenta Server Vista Webstation Vista Workstation   Cause There are 4 different components that you can change the language on Vista server Vista workstation Vista webstation Xenta server's The files you need for this can be downloaded on Extranet, if your preferable language does not exist it might be because they are not done with the translation for that current version or the language does not exist. The most used one are Danish Finnish German Norwegian Polish Spanish Swedish The native language is English NOTE: Remember, in order to download the correct version, the language pack needs to be same version as the current software installed. Resolution There are 4 files that need to be downloaded and executed. The example below points to Swedish language pack files for version 5.1.6. To find the correct files search the download center for "Language Pack" as well as the desired language and version. The install order does not matter. TAC Vista Server 5.1.6 Language Pack Swedish TAC Vista Workstation 5.1.6 Language Pack Swedish TAC Web Applications 5.1.6 Language Pack Swedish TAC Xenta 700 5.1.6 Original Language Pack The first three files are straight forward.  After the install is complete, the language files have been changed and you can run the software with the new language (Vista software should be installed prior installing the language pack). The Xenta Server web interface will not change language until you download a project with the correct settings. When you do the download make sure you choose "Send all project and language files"  (see picture).     Note: For new Windows it sometimes require a multilingual file to be installed from Microsoft. Make sure the OS supports the language you want to install. After that file has been installed, change the Language for non-unicode program to the preferred language (requires a restart of PC).

Issue How to increase the number of Modbus registers the Xenta server polls in a single request? Product Line TAC Vista Environment XBuilder Xenta 511 Xenta 913 Xenta 701 Xenta 711 Xenta 721 Xenta 731 Cause This feature is not well documented in the Xenta 700 documentation, though it is mentioned in the TAC Xenta Server – Gateway, Technical Manual (Xenta 913). Resolution In XBuilder, selected the Modbus device in the network view. Under Link->Max Range Size you will see the current setting, the default is 20 which most devices support. Change the number to the desired value between 1-100. Note that the value must be supported by the device! Download the project to the device to commit changes.  

Issue Want to be able to import a list of individuals quickly without having to retype all the details from a spreadsheet or text file again into I/NET Product Line TAC INET Environment I/NET Seven Revision 2.xx and higher Microsoft Access 2003 Microsoft Access 2007 Warning Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support Services for assistance. Cause Customers usually have a spreadsheet or database of employees and / or users which they want to quickly import into their I/NET Seven Access control database.  The process below describes how to do this along with its limitations. Resolution Process to import Individuals via the IDWorksView table using Microsoft Access 2003 / 2007 The import process will NOT update any existing data; it will only add new entries and leave existing entries as they were.  So this is typically a process used for a new installation.  If you are attempting to import into an existing Access control database with individuals then it is strongly recommended to backup your I/NET SQL database. It is also strongly recommended you test this in an ‘offline’ state, that is, it is not connected to any physical controllers until you are comfortable that the process provides the desired results. The same limitations that apply with ID Works (Refer to TCON 301 Chapter 5) apply to this import process. TAC I/NET Seven (not just I/O Server) must be running on the server specified in TAC I/NET Seven’s ODBC data source in order for records created or modified from ID Works to be downloaded to affected DPUs. ID Works does not allow you to add or modify multiple cards for a single individual. ID Works does not allow you to remove a card from an individual without deleting the individual record. You cannot disable an individual’s card without disabling the individual. You cannot create a new group or a new tenant.  All Tenant and Group information must already exist in I/NET You cannot make an individual’s record be DPU resident. You cannot assign a decimal card number to an individual. You cannot set an individual’s APB scheme (that is, hard, soft, or graced anti-pass back). You cannot assign a PIN to an individual. The steps to import are as follows: Download ZIP file containing necessary files here. If you are using Microsoft Access 2007 use the following files Format customer data into the Excel template (dbo_IdWorksView.xlt in the ZIP file) or provide this to the customer to complete the Employee details.  Pay attention to required data shown in the comments for each title cell. Open db1.mdb file in the ZIP file using Microsoft Access 2003 /  idworks.accdb if using Microsoft Access 2007. Double click (open) the table dbo_IdWorksView to establish the connection to I/NET on the respective machine.  You may be prompted for login details – you must use the ‘sa’ login and password installed on the PC. If successful you should see any individuals that already exist in the database (unless blank).  Close the table. If you are using Microsoft Access 2007 Click Here to view the changes for steps 6 though to 8. Right–click in any of the white space and select Import (or go to File>Get External Data>Import) Browse to the location of the Excel Spreadsheet, saved in step 2, containing the data to be imported.  Be sure to change the File Type to *.xls otherwise you will not find the file.  Select the file. Import wizard should appear, now select the following options within the import wizard: Select the Check box “First row contains column headings..” Select Next Select “In an Existing Table” and select the table from the drop down list – there should only be one there. dbo_IdWorksView. Select Next. Select Finish. Be patient – the process can take a few minutes based on the number of entries that you are trying to import.  Once imported you should receive a message indicating that the import was completed.  Select OK. If you have images referenced in your import file, be sure that the Images are in place before modifying ANY individual in I/NET.  Otherwise the image path will be deleted.  The next step is to get the imported data downloaded to the controllers. For each SLI perform a station SAV and station restore – it may take some time for all this information to be downloaded to the DPUs and may fail in some instances.  You may also notice the system slow up for some time (hours) until all of this information has been successfully downloaded to the controllers.  It may also be necessary to force the data into the DPU by performing staggered DPU Restores on specific doors that are experiencing incorrect functionality. There is also a way to realize this function using Microsoft SQL Server Management Studio Express instead of Microsoft Access. See How to Import a Large Number of Individuals from Excel to I/NET SQL Database at One Time for more information.