Doors.NET comes with a generic import utility that can be used to import card data from an Excel (XLS or XLSX) spreadsheet. This is not a licensed feature so it can be used free-of-charge with Doors.NET.

2.0 Configure the Import Wizard

1. Create a folder on the C: drive and copy your XLS or XLSX file into it.
2. Go to the local drive on the PC, click Keri >> DoorsNET then ensure the files and folders are sorted by type.
3. Scroll down the list and locate the executable file named: CardholderImportGeneric.
   
   
   
   
4. Execute the file.
5. Login with the default username and password (both admin) then click Connect.
   
   
   
   
6. Right-click in the Connect String text field and select Excel if you are importing an XLS file.
   
   
   
   
7. Select Excel 2007 if you will be importing data from an XLSX file.
   
   
   
   
8. The following text will be added (if using XLS/Excel) -Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
9. If using an XLSX/Excel 2007 file, the default text will be: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";
10. Change Source=c:\myFolder\myExcel2007file.xls(x) to the specific name of the folder you created and the exact name of your Excel file.
11. For example: Source=c:\Cardholders\20users.xls(x)
    
    
    
    
12. In the Query text field right-click and you will see the names of the DoorsNET cardholder data fields.
    
    
    
    IMPORTANT NOTE: You should ensure that these exactly match the headers in the Excel spreadsheet.
    
    
13. Once your spreadsheet headers exactly match those that display (when you right click) enter the following query (or similar):
    
    Select Imprint, Last_Name, First_Name, Middle_Name, Cardnumber, ActivationDate, ExpirationDate FROM [Sheet1$] - Sheet 1 is the default name of the first sheet of an XLS or XLSX spreadsheet.
    
    
14. If the headers in the spreadsheet do not match, you will need to type Select [HeaderName 1] AS - then right-click and select the Doors.NET cardholder field to map it to.
    
    For example FNAME AS First_Name, LNAME AS Last_Name, MNAME AS Middle_Name, etc FROM [SHEET1$]
    
    
    
    
    
15. Your import wizard should resemble what is shown below:
    
    
    
    
16. Next, assign a valid access group to the imported cardholders or set them to Unassigned.
17. Set the card status to either active or inactive.
    
    
    
    
18. Click the Import button. You will see the following window.
    
    
    
    
19. You will then see a review window similar to that shown below.
    
    
    
    
20. Click Yes and importing of the data will begin.
21. At the bottom of the wizard you will see an indicator each time a record is saved.
22. Once complete a notification will appear confirming the importing has finished. Click OK to this message.
    
    
    
    
23. On the import wizard you now have to place a tick in the option "Check Multiple Access Groups". Then click the Import button again. This will upgrade each of the cardholder records so that in the database they will support the assignment of multiple access groups.
    
    
    
    
24. Click Import again, each of the imported records will be scanned, then the following message will appear.
    
    
    
    
25. OK this message and close the import wizard.
26. You will now be able to log into the Doors.NET software and view the imported cardholder records.