• From: USA
  • Registered: 12/19/2017
  • Posts: 5

Topic: Importing from DacEasy

First I need you to know I'm on a time crunch.  I had been using DacEasy on DOS but it quit working after 2010.  Being the world's best procrastinator my accounting is years behind.

I would like to know if it is possible and how I can import my chart of accounts, account values, customers, vendors, etc.

I'm not very experienced at this stuff but any help in this regard would be better than printing it out and typing in by hand.

Thanks so much for any help you can give.

Claton

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Importing from DacEasy

DacEasy (v9 and v10 to 14 and Utilities) when I last used it over 2 decades ago was using dBASE (.DBF) files. It should be trivial to export them out into Excel / CSV files before importing them into MySQL directly. DacEasy last used BTRIEVE database for DOS that is akin to MySQL's ISAM (Indexed Sequential Access Method) DB Engine.

The manual for DacEasy v14 is available here and it's list of files and what they are for is listed here.

Commercial products to convert Btrieve DB to MySQL DB are:
Mertech Btrieve to MySQL
FullConvert Enterprise - abandoned / unsupported / lost on the web
Nelson Software Tools

BTrieve itself is now Pervasive SQL (PSQL) - MySQL Discussion thread for conversion.

DacEasy is now part of Sage and they do not generate Activation keys for these old versions when you need to re-install. Provide feedback if this works.

If you are interested in still using DacEasy, it can be setup in a DOS emulator and run on the newer OSes along with an LPT2USB Driver for them.

Capturing LPT1 is also possible.

FreeDOS supports USB Printers.

You can also run DacEasy in a DOS VirtualBox / VMWare Player / QEMU Emulator.

DOSBox too can be used.

apmuthu's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Importing from DacEasy

BTrieve Tools:

16 bit BT View - Download
BTrieve Tools Zip - Download
Technical White Papers on BTrieve conversion

Free Print Drivers:
Free DOS Printer for Windows - Download
DOSPrint - [url=http://www.andtechnologies.com/download/free20110630/DOSPrint.zip[/url]Download[/url]

Tech Notes:
Microsoft
4DOS
Tom's Hardware

apmuthu's Website

  • From: USA
  • Registered: 12/19/2017
  • Posts: 5

Re: Importing from DacEasy

Thank you for all the info.  Using my existing DacEasy is impossible as it doesn't work after 2010 (evidently coded EOL).

I can get the CVS files through the printing dialog. I'm not sure if there is a separate export dialog anywhere but will look tonight. 

How do I import this into front accounting so it can be used?  This is not trivial to me.

I will get MySQL Workbench and look at the Database Migration Wizard and see if it will be useful.

FYI I was using DacEasy in DosBox on Linux.

Thanks.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Importing from DacEasy

Once you get the CSV of the customers and assuming you are using the latest FA v2.4.3 and the sql/en_US-new.sql Chart of Accounts, manually enter one typical ustomer and see the diffs in the before and after backups and construct your sqls accordingly. This will need to be carefully done in a cloned container and then migrated to the production install. The same can be done for vendors (suppliers), items (inventory), etc.

Try to revert to an earlier version of DacEasy before Sage took over. You will most probably find a non expiring version.....MBAs tend to enforce migration by such blackmail tactics - they probably cannot survive in a non-monopolistic environment - they will however wax eloquent on the virtues of their idea of a free "market economy".

apmuthu's Website

  • From: USA
  • Registered: 07/16/2017
  • Posts: 276

Re: Importing from DacEasy

Just restating what apmuthu said, follow the instructions by  trafficpest to import the customers.

  • From: USA
  • Registered: 12/19/2017
  • Posts: 5

Re: Importing from DacEasy

I feeling rather overwhelmed.  Can we start with the importing my chart of accounts or complete general ledger?
Here is a sample of the listing copied from an Excel 5.0 output from DacEasy 8.0.  reverting back is not possible. 
You will need a fixed font to see this.  If I import the general ledger would that include the chart of accounts??  Sample of that follows from the trail balance.

1             ASSETS                              Asset          1      GENERAL              
11            Current Assets                      Asset          2      GENERAL    1         
1102          Cash in Banks                       Asset          3      GENERAL    11       
11021         Checking Account                    Asset          4      DETAIL     1102     
1105          Accounts Receivable                 Asset          3      GENERAL    11       
11051         Accts Receivable-Module             Asset          4      DETAIL     1105     
1106          Other Receivable                    Asset          3      GENERAL    11       
11063         Loans to Officers                   Asset          4      DETAIL     1106     
11064         Misc. Receivable                    Asset          4      DETAIL     1106     
1107          Inventory                           Asset          3      GENERAL    11       
11071         Inventory-Module                    Asset          4      DETAIL     1107     
11072         Damaged\Obsolete Invent.            Asset          4      DETAIL     1107     
12            Fixed Assets                        Asset          2      GENERAL    1         
1204          Machinery/Equipment Net             Asset          3      GENERAL    12       
12041         Original Value                      Asset          4      DETAIL     1204     
12042         Accumulated Depreciation            Asset          4      DETAIL     1204     
14            Other Assets                        Asset          2      GENERAL    1         
1401          Other Deposits                      Asset          3      DETAIL     14       
2             LIABILITIES                         Liability      1      GENERAL              
21            Short Term Liability                Liability      2      GENERAL    2         
2101          Accts. Payable Module               Liability      3      DETAIL     21       
2102          Loans due Officer                   Liability      3      DETAIL     21       
2104          Taxes Payable                       Liability      3      GENERAL    21       
21041         Payroll Taxes                       Liability      4      GENERAL    2104     
210411        Federal Income W/H                  Liability      5      DETAIL     21041     
210412        FICA W/H Employee                   Liability      5      DETAIL     21041     
210413        FICA W/H Employer                   Liability      5      DETAIL     21041     
210414        FUTA                                Liability      5      DETAIL     21041     
210415        SUTA                                Liability      5      DETAIL     21041     

Output of Trial Balance Excel 5.0

1             ASSETS                                29239.44    0    3090.79    0    32330.23    0
11             Current Assets                       29139.44    0    3090.79    0    32230.23    0
1102            Cash in Banks                       5256.89    0    2301.85    0    7558.74    0
11021            Checking Account                   5256.89    0    2301.85    0    7558.74    0
1105            Accounts Receivable                 12151.19    0    2694.69    0    14845.88    0
11051            Accts Receivable-Module            12151.19    0    2694.69    0    14845.88    0
1106            Other Receivable                    0    60.5    0    0    0    60.5
11063            Loans to Officers                  46.5    0    0    0    46.5    0
11064            Misc. Receivable                   0    107    0    0    0    107
1107            Inventory                           11791.86    0    0    1905.75    9886.11    0
11071            Inventory-Module                   11791.86    0    0    1905.75    9886.11    0
11072            Damaged\Obsolete Invent.           0    0    0    0    0    0
12             Fixed Assets                         0    0    0    0    0    0
1204            Machinery/Equipment Net             0    0    0    0    0    0
12041            Original Value                     6288.11    0    0    0    6288.11    0
12042            Accumulated Depreciation           0    6288.11    0    0    0    6288.11
14             Other Assets                         100    0    0    0    100    0
1401            Other Deposits                      100    0    0    0    100    0
2             LIABILITIES                           0    629.69    219.37    0    0    410.32
21             Short Term Liability                 0    629.69    219.37    0    0    410.32
2101            Accts. Payable Module               0    21.52    2.06    0    0    19.46
2102            Loans due Officer                   0    13    0    0    0    13
2104            Taxes Payable                       0    589.1    216.31    0    0    372.79
21041            Payroll Taxes                      0    527.23    153.24    0    0    373.99
210411            Federal Income W/H                0    58.54    0    104.62    0    163.16
210412            FICA W/H Employee                 38.25    0    153.75    0    192    0
210413            FICA W/H Employer                 0    573.75    113.77    0    0    459.98
210414            FUTA                              0    0    0    56    0    56
210415            SUTA                              86.21    0    6.34    0    92.55    0
210416            Minnesota Income W/H              61    0    40    0    101    0
210417            SDI                               0    80.4    0    0    0    80.4
21042            Sales Tax Payable                  0    61.87    63.07    0    1.2    0
210421            Minnesota Sales Tax               0    51.66    61.63    0    9.97    0
210422            Minneapolis                       0    5.19    0    1.43    0    6.62
210423            Hennipen                          0    0.81    0.57    0    0    0.24
210424            Transit Improvement               0    1.92    1.1    0    0    0.82
210425            Albert Lea                        0    2.29    1.2    0    0    1.09
2105            Outstanding Payroll                 0    6.07    1    0    0    5.07
3             Stockholder Equity                    0    13575.27    0    0    0    13575.27
31             Captital Stock                       0    100    0    0    0    100

  • From: USA
  • Registered: 12/19/2017
  • Posts: 5

Re: Importing from DacEasy

Mysql Workbench has a migration tool but requires an "ODBC" driver for the Btrieve source file to be installed.  Can anybodt point me to the driver and instructions for installation and use?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Importing from DacEasy

Making an Excel / Access table with the above data is trivial. It then will not need the BTrieve ODBC Driver and use the native MS Jet ODBC Driver for Excel / Access.

FICA (Employee and Employer Witholding Tax) - US - Federal Insurance Contributions Act
FUTA (Employer Only) - US - Federal Unemployment Tax Act
SICA (Employer Only) - US - State Unemployment Tax Act

So much for ease of doing business in the USA! No wonder they find it attractive to import from the rest of the world! All they need to do is print more money and run up trillions of dollars of debt.... Every country should follow suit - then there would be no one willing to export to anyone....in others currency! Then no more multi-currency in FA or no FA at all!

Wall Street = Legalised Casino.
Monetary Policy = Con Game.

The Code Book from The Bangladesh Mathematical Foundation.

smile

Post's attachments

DacEasy Import.xls 39.5 kb, 1 downloads since 2018-01-14 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • From: USA
  • Registered: 12/19/2017
  • Posts: 5

Re: Importing from DacEasy

I'm afraid I don't find this trivial.  I'm going to need step by step instructions or a link to docs that do.  I've never worked with MySQL before or any data base and the last time I set up an accounting program was 25 years ago.

Perhaps I and FA are not a good fit?  I may need something more user friendly.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Importing from DacEasy

Try the SQLyog community edition for a start - all Windows GUI for the MySQL Database.
Direct import from CSV and table creation / altering too in the GUI.
The "History" tab will show the SQLs used.

https://github.com/webyog/sqlyog-commun … /Downloads

Everyone starts off not knowing MySQL and assuming FA not to be a good fit but in time you will find is as user friendly as possible as any web app can be. Scout around for anything more user friendly and let us know so that FA can catchup as well.

apmuthu's Website