How to Import and Export Data In DoorKing

Importing and exporting data can be a real time saver. This post includes a video tutorial that will walk you through the steps for importing and exporting.
This is a simple way of getting the DoorKing Account Manager loaded with information, especially if you have a list currently available.

A common use for exporting is to make changes to a large number of residents in the database.

  • Export the account that needs to be altered.
  • Make the necessary changes in Microsoft Excel, OpenOffice or Google Drive.
  • Save as a .CSV file.
  • Import the data with the “initialize” option checked. This will overwrite the existing data in DoorKing.

Another use is merging a large number of residents into the data base.

  • Use an existing or blank database to export the header names.
  • Create a list of residents formatted to the header names
  • Save as a .CSV file.
  • Import the data with the “update” option checked. This will merge the existing data and the new data together.

 

Click the links for the blank database .CSV shown in the video  Blank DoorKing Database CSV, as well a s the demo .CSV Demo DoorKing CSV

Replacement Covers for EMX IRB-4x Photo Eyes

Foggy EMX IRB-4X Photo Eye Lenses -

I have searched high and low for new EMX lenses and have finally found a source.

Link to Vynckier.

I had ordered a replacement set of enclosures online from Vynkier, they arrived in two days. Actually, one arrived. They had shipped one enclosure instead of two. I made a phone call to customer support and they had the missing enclosure shipped right away.

This was first time I dealt with the company. I called and the customer service rep was very quick to realize the problem. I understand mistakes happen, especially in shipping and ordering. Hopefully this isn’t a trend.

Even though a complete enclosure is sold, I was only after the clear cover. The rear part of the enclosure doesn’t have the stand-off’s for the board like the enclosures from EMX. This is not a deal breaker for me as the full enclosure was around $15 ea. +shipping. This is much cheaper for the customer that having to purchase a complete set of photo eyes.

Sun-Damaged-EMX-IRB-4X-Photo-Eye-Lens
Sun Damaged
New-EMX-IRB-4X-Photo-Eye-Lens
New

 

 

 

 

 

 

 

 

 

 

As you can see from the pictures above, the sun can cause a lot of damage to the lenses. This can cause issues with gates being stuck open. As the lens becomes cloudy the infrared light becomes scattered from the transmitter. The more scattered the light, the less gets to the receiver. Once the amount of infrared light gets below the threshold, the receiver will lock on the relay. I have seen photo eyes turn on when the sun hits the lens at a particular angle, and go back into operation once the sun moves on. With a clear lens I haven’t seen this happen.

As a temporary fix I have removed the bottom sticker and turned the lens upside down. You can see this in the picture above.