Issue: Submitting DNA Fusion log files to Technical Support
Applies to: All versions of DNA Fusion
Summary: How to use the DNA Diagnostics utility to expediently submit log files to Open Options Technical Support and help diagnose or troubleshoot a system error.
Issue: COM+ Network Access not enabled in Windows Server 2016 - Preventing client connections
Applies to: All versions of DNA Fusion
Summary: Instructions on how to Enable COM+ network access in Windows firewall and/or registry settings manually. By default, COM+ remote access is disabled in Windows Server 2016. To resolve client connectivity issues the operator must manually edit one of the registry settings. It is also possible that some of the firewall settings will need to be changed.
NOTE: Future versions of DNA Fusion (starting with 7.0.0.39) will detect this issue and enable the COM+ Network Access automatically.
https://www.ooaccess.com/wp-content/uploads/2019/01/OOLogo_H-01-2-300x100.png00Brent Dohertyhttps://www.ooaccess.com/wp-content/uploads/2019/01/OOLogo_H-01-2-300x100.pngBrent Doherty2017-09-13 16:27:582017-09-13 16:27:58Client Connectivity on Windows Server 2016 (COM+ Firewall Settings)
Issue: ONR (Over Network Reflash) of firmware to Schlage AD series locks and PIM
Applies to: DNA Fusion v6.4.0.25 and above with Schlage AD series lock integration
Summary: Instructions on how to bring PIM/Lock/Reader firmware up to minimum requirements (shown below), download firmware via DNA Fusion, and perform a factory reset if the download fails.
Using Microsoft Excel, follow the steps below to convert an Excel file to a flat file CSV with text fields in quotes:
Open the Excel file to be imported.
Press Alt+F11 to open the Microsoft Visual Basic for Applications dialog.
SelectInsert/Module from the main menu of Visual Basic for Applications dialog to show script editor.
Copy and Paste the following code into the script editor.
Sub CSVFile() Dim SrcRg As Range Dim CurrRow As Range Dim CurrCell As Range Dim CurrTextStr As String Dim ListSep As String Dim FName As Variant FName = Application.GetSaveAsFilename(“”, “CSV File (*.csv), *.csv”) ListSep = Application.International(xlListSeparator) If Selection.Cells.Count > 1 Then Set SrcRg = Selection Else Set SrcRg = ActiveSheet.UsedRange End If Open FName For Output As #1 For Each CurrRow In SrcRg.Rows CurrTextStr = ìî For Each CurrCell In CurrRow.Cells CurrTextStr = CurrTextStr & “””” & CurrCell.Value & “””” & ListSep Next While Right(CurrTextStr, 1) = ListSep CurrTextStr = Left(CurrTextStr, Len(CurrTextStr) - 1) Wend Print #1, CurrTextStr Next Close #1 End Sub
Close the script editor.
SelectRun/Run Macros from the main menu of Visual Basic for Applications dialog.
Click Run to open the Save As dialog.
Browse to the desired location and clickSave.
The file is now saved in the proper format and can be imported via the DNAImport tool.
https://www.ooaccess.com/wp-content/uploads/2019/01/OOLogo_H-01-2-300x100.png00Brent Dohertyhttps://www.ooaccess.com/wp-content/uploads/2019/01/OOLogo_H-01-2-300x100.pngBrent Doherty2017-09-13 11:15:432017-09-13 11:36:35Formatting Data for DNA Import