Orchid

Please be advised that our integrated credit card processing through Card Connect is currently experiencing transaction timeouts and failures. Investigations are underway and a resolution is coming soon. For more immediate updates, visit status.cardconnect.com and subscribe for text and email alerts. We apologize for the inconvenience and thank you for your patience!

Happy Holidays! Please be advised that our offices will be closed December 24th, 25th, 31st, and January 1st to allow out employees to spend time with their families this holiday season.
Thank you for your understanding.

>System Maintenance is scheduled Sunday night, April 22nd, between 10:00 PM and 5:00 AM EST Monday, April 23rd. While these database upgrades and maintenance is necessary, it will mean that our online services will not be available during this maintenance window. These services include: online booking, messaging, remote access, memberships or any account management. We apologize for any inconvenience this work may cause and thank you for your service and patience.

We recently experienced a service outage related to some Amazon Web Services, which affected key functionality of our Remote Access Service. This interruption happened on Thursday, June 22nd, between the hours of 9:00pm and 2:00am EST. The Remote Access Service is now fully restored. If you continue to experience issues with your Remote Access Service, please follow the directions on this Support Article to restart the Remote Access Service and try reconnecting again. You can also restart your computer to restart your service. If you are still experiencing issues afterwards please contact our support team at 1 (800) 604-2040.

All of our services have been restored after a brief interruption that impacted our Cloud online services. This interruption occurred between 9:45 a.m. and 10:55 a.m. EST on September 18th. We apologize for the inconvenience and thank you for your patience!

Exporting Database Information

Your software has the ability to export many tables in the database using the Export function.

  1. Select the Tools pull-down menu.
  2. Click Export to Text File.
  3. On the Export Database Information to a File screen, select the data that you would like to export. Each selection will be saved as its own text (.txt) file.
  4. Click Export. You will be prompted to select a file name and location for each file. These files are tab-delimited text files and can be opened with Microsoft Excel.
You can also connect your SQL Server database to Microsoft Excel directly following the Microsoft Knowledge Base article here. You may need to enable the Data tab in Excel first.
  1. When you are prompted for the connection information in the Data Connection Wizard, refer to FileDatabase Controls in your software for the Server Name. It's displayed in the Network Settings section.
  2. In the Log on credentials section, select Use the following User Name and Password. The user name will be sa and the password will be your database password if you have one. If you do not have one, it will be CMJsoftware4477.
  3. Select your program name from the pull-down menu and follow the prompts to select the table you would like to connect with Excel.

Did you find this article helpful?