Tech Bulletins 2017

Submitting DNA Fusion Log files

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.

Download Technical Bulletin (PDF): 

  TB17-4 (661 KB)

Client Connectivity on Windows Server 2016 (COM+ Firewall Settings)

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.

Download PDF w/images: 

  TB17-3 (261 KB)

ONR Firmware Download

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.

Download PDF w/images: 

  TB17-2 (319 KB)

 

 

Formatting Data for DNA Import

Issue: How to format data for DNA Import

Applies to: All versions of DNA Fusion

Summary: Instructions on how to format data to flat file CSV in preparation for import.

Download PDF w/images: 

  TB17-1 (302 KB)

Using Microsoft Excel, follow the steps below to convert an Excel file to a flat file CSV with text fields in quotes:

  1. Open the Excel file to be imported.
  2. Press Alt+F11 to open the Microsoft Visual Basic for Applications dialog.
  3. Select Insert/Module from the main menu of Visual Basic for Applications dialog to show script editor.
  4. Copy and Paste the following code into the script editor.

  5. 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

  6. Close the script editor.
  7. Select Run/Run Macros from the main menu of Visual Basic for Applications dialog.
  8. Click Run to open the Save As dialog.
  9. Browse to the desired location and click Save.

The file is now saved in the proper format and can be imported via the DNAImport tool.