<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Importing from DacEasy]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=7247&amp;type=atom" />
	<updated>2018-01-15T05:51:03Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=7247</id>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30523#p30523" />
			<content type="html"><![CDATA[<p>Try the SQLyog community edition for a start - all Windows GUI for the MySQL Database.<br />Direct import from CSV and table creation / altering too in the GUI.<br />The &quot;History&quot; tab will show the SQLs used.</p><p><a href="https://github.com/webyog/sqlyog-community/wiki/Downloads">https://github.com/webyog/sqlyog-commun … /Downloads</a></p><p>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.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2018-01-15T05:51:03Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30523#p30523</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30521#p30521" />
			<content type="html"><![CDATA[<p>I&#039;m afraid I don&#039;t find this trivial.&nbsp; I&#039;m going to need step by step instructions or a link to docs that do.&nbsp; I&#039;ve never worked with MySQL before or any data base and the last time I set up an accounting program was 25 years ago.</p><p>Perhaps I and FA are not a good fit?&nbsp; I may need something more user friendly.</p>]]></content>
			<author>
				<name><![CDATA[claton]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42040</uri>
			</author>
			<updated>2018-01-14T20:15:45Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30521#p30521</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30520#p30520" />
			<content type="html"><![CDATA[<p>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.</p><p><a href="https://en.wikipedia.org/wiki/Federal_Insurance_Contributions_Act_tax">FICA</a> (Employee and Employer Witholding Tax) - US - Federal Insurance Contributions Act<br /><a href="https://www.patriotsoftware.com/payroll/training/blog/what-is-futa-tax/">FUTA</a> (Employer Only) - US - Federal Unemployment Tax Act<br /><a href="http://smallbusiness.chron.com/suta-tax-pays-it-17725.html">SICA</a> (Employer Only) - US - State Unemployment Tax Act</p><p>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 <a href="https://en.wikipedia.org/wiki/United_States_Note">dollars</a> 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!</p><p>Wall Street = Legalised Casino.<br />Monetary Policy = Con Game.</p><p><a href="http://bdmath.com/books/The%20Code%20Book.pdf">The Code Book</a> from The Bangladesh Mathematical Foundation.</p><p><img src="https://frontaccounting.com/punbb/img/smilies/smile.png" width="15" height="15" alt="smile" /></p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2018-01-14T04:11:22Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30520#p30520</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30519#p30519" />
			<content type="html"><![CDATA[<p>Mysql Workbench has a migration tool but requires an &quot;ODBC&quot; driver for the Btrieve source file to be installed.&nbsp; Can anybodt point me to the driver and instructions for installation and use?</p>]]></content>
			<author>
				<name><![CDATA[claton]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42040</uri>
			</author>
			<updated>2018-01-13T21:07:06Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30519#p30519</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30518#p30518" />
			<content type="html"><![CDATA[<p>I feeling rather overwhelmed.&nbsp; Can we start with the importing my chart of accounts or complete general ledger?<br />Here is a sample of the listing copied from an Excel 5.0 output from DacEasy 8.0.&nbsp; reverting back is not possible.&nbsp; <br />You will need a fixed font to see this.&nbsp; If I import the general ledger would that include the chart of accounts??&nbsp; Sample of that follows from the trail balance.</p><p>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; ASSETS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Current Assets&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />1102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cash in Banks&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; <br />11021&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Checking Account&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 1102&nbsp; &nbsp; &nbsp; <br />1105&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Accounts Receivable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; <br />11051&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Accts Receivable-Module&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 1105&nbsp; &nbsp; &nbsp; <br />1106&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Other Receivable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; <br />11063&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Loans to Officers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 1106&nbsp; &nbsp; &nbsp; <br />11064&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Misc. Receivable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 1106&nbsp; &nbsp; &nbsp; <br />1107&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Inventory&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; <br />11071&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Inventory-Module&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 1107&nbsp; &nbsp; &nbsp; <br />11072&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Damaged\Obsolete Invent.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 1107&nbsp; &nbsp; &nbsp; <br />12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Fixed Assets&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />1204&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Machinery/Equipment Net&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; <br />12041&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Original Value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 1204&nbsp; &nbsp; &nbsp; <br />12042&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Accumulated Depreciation&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 1204&nbsp; &nbsp; &nbsp; <br />14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Other Assets&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />1401&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Other Deposits&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asset&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp; <br />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; LIABILITIES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Short Term Liability&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />2101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Accts. Payable Module&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp; &nbsp; <br />2102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Loans due Officer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp; &nbsp; <br />2104&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Taxes Payable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp; &nbsp; <br />21041&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Payroll Taxes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; GENERAL&nbsp; &nbsp; 2104&nbsp; &nbsp; &nbsp; <br />210411&nbsp; &nbsp; &nbsp; &nbsp; Federal Income W/H&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 21041&nbsp; &nbsp; &nbsp;<br />210412&nbsp; &nbsp; &nbsp; &nbsp; FICA W/H Employee&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 21041&nbsp; &nbsp; &nbsp;<br />210413&nbsp; &nbsp; &nbsp; &nbsp; FICA W/H Employer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 21041&nbsp; &nbsp; &nbsp;<br />210414&nbsp; &nbsp; &nbsp; &nbsp; FUTA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 21041&nbsp; &nbsp; &nbsp;<br />210415&nbsp; &nbsp; &nbsp; &nbsp; SUTA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Liability&nbsp; &nbsp;&nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; DETAIL &nbsp; &nbsp; 21041&nbsp; &nbsp; &nbsp;</p><p>Output of Trial Balance Excel 5.0</p><p>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; ASSETS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 29239.44&nbsp; &nbsp; 0&nbsp; &nbsp; 3090.79&nbsp; &nbsp; 0&nbsp; &nbsp; 32330.23&nbsp; &nbsp; 0<br />11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Current Assets&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 29139.44&nbsp; &nbsp; 0&nbsp; &nbsp; 3090.79&nbsp; &nbsp; 0&nbsp; &nbsp; 32230.23&nbsp; &nbsp; 0<br />1102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Cash in Banks&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 5256.89&nbsp; &nbsp; 0&nbsp; &nbsp; 2301.85&nbsp; &nbsp; 0&nbsp; &nbsp; 7558.74&nbsp; &nbsp; 0<br />11021&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Checking Account&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 5256.89&nbsp; &nbsp; 0&nbsp; &nbsp; 2301.85&nbsp; &nbsp; 0&nbsp; &nbsp; 7558.74&nbsp; &nbsp; 0<br />1105&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Accounts Receivable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 12151.19&nbsp; &nbsp; 0&nbsp; &nbsp; 2694.69&nbsp; &nbsp; 0&nbsp; &nbsp; 14845.88&nbsp; &nbsp; 0<br />11051&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Accts Receivable-Module&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12151.19&nbsp; &nbsp; 0&nbsp; &nbsp; 2694.69&nbsp; &nbsp; 0&nbsp; &nbsp; 14845.88&nbsp; &nbsp; 0<br />1106&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Other Receivable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; 60.5&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 60.5<br />11063&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Loans to Officers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46.5&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 46.5&nbsp; &nbsp; 0<br />11064&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Misc. Receivable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 107&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 107<br />1107&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Inventory&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 11791.86&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 1905.75&nbsp; &nbsp; 9886.11&nbsp; &nbsp; 0<br />11071&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Inventory-Module&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 11791.86&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 1905.75&nbsp; &nbsp; 9886.11&nbsp; &nbsp; 0<br />11072&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Damaged\Obsolete Invent.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0<br />12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Fixed Assets&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0<br />1204&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Machinery/Equipment Net&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0<br />12041&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Original Value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 6288.11&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 6288.11&nbsp; &nbsp; 0<br />12042&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Accumulated Depreciation&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 6288.11&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 6288.11<br />14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Other Assets&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 100&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 100&nbsp; &nbsp; 0<br />1401&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Other Deposits&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 100&nbsp; &nbsp; 0<br />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; LIABILITIES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 629.69&nbsp; &nbsp; 219.37&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 410.32<br />21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Short Term Liability&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 629.69&nbsp; &nbsp; 219.37&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 410.32<br />2101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Accts. Payable Module&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 21.52&nbsp; &nbsp; 2.06&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 19.46<br />2102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Loans due Officer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 13&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 13<br />2104&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Taxes Payable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 589.1&nbsp; &nbsp; 216.31&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 372.79<br />21041&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Payroll Taxes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; 527.23&nbsp; &nbsp; 153.24&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 373.99<br />210411&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Federal Income W/H&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; 58.54&nbsp; &nbsp; 0&nbsp; &nbsp; 104.62&nbsp; &nbsp; 0&nbsp; &nbsp; 163.16<br />210412&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;FICA W/H Employee&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 38.25&nbsp; &nbsp; 0&nbsp; &nbsp; 153.75&nbsp; &nbsp; 0&nbsp; &nbsp; 192&nbsp; &nbsp; 0<br />210413&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;FICA W/H Employer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 573.75&nbsp; &nbsp; 113.77&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 459.98<br />210414&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;FUTA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 56&nbsp; &nbsp; 0&nbsp; &nbsp; 56<br />210415&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;SUTA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 86.21&nbsp; &nbsp; 0&nbsp; &nbsp; 6.34&nbsp; &nbsp; 0&nbsp; &nbsp; 92.55&nbsp; &nbsp; 0<br />210416&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Minnesota Income W/H&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 61&nbsp; &nbsp; 0&nbsp; &nbsp; 40&nbsp; &nbsp; 0&nbsp; &nbsp; 101&nbsp; &nbsp; 0<br />210417&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;SDI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 80.4&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 80.4<br />21042&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Sales Tax Payable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; 61.87&nbsp; &nbsp; 63.07&nbsp; &nbsp; 0&nbsp; &nbsp; 1.2&nbsp; &nbsp; 0<br />210421&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Minnesota Sales Tax&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 51.66&nbsp; &nbsp; 61.63&nbsp; &nbsp; 0&nbsp; &nbsp; 9.97&nbsp; &nbsp; 0<br />210422&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Minneapolis&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 5.19&nbsp; &nbsp; 0&nbsp; &nbsp; 1.43&nbsp; &nbsp; 0&nbsp; &nbsp; 6.62<br />210423&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Hennipen&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; 0.81&nbsp; &nbsp; 0.57&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0.24<br />210424&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Transit Improvement&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 1.92&nbsp; &nbsp; 1.1&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0.82<br />210425&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Albert Lea&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; 2.29&nbsp; &nbsp; 1.2&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 1.09<br />2105&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Outstanding Payroll&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 6.07&nbsp; &nbsp; 1&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 5.07<br />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; Stockholder Equity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; 13575.27&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 13575.27<br />31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Captital Stock&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0&nbsp; &nbsp; 100&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 0&nbsp; &nbsp; 100</p>]]></content>
			<author>
				<name><![CDATA[claton]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42040</uri>
			</author>
			<updated>2018-01-13T20:58:12Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30518#p30518</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30509#p30509" />
			<content type="html"><![CDATA[<p>Just restating what apmuthu said, follow the instructions by&nbsp; <a href="https://frontaccounting.com/punbb/viewtopic.php?pid=30427#p30427">trafficpest</a> to import the customers.</p>]]></content>
			<author>
				<name><![CDATA[Braath Waate]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41493</uri>
			</author>
			<updated>2018-01-13T12:29:25Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30509#p30509</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30505#p30505" />
			<content type="html"><![CDATA[<p>Once you get the CSV of the customers and assuming you are using the latest FA v2.4.3 and the <strong>sql/en_US-new.sql</strong> 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.</p><p>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 &quot;market economy&quot;.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2018-01-13T07:08:11Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30505#p30505</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30499#p30499" />
			<content type="html"><![CDATA[<p>Thank you for all the info.&nbsp; Using my existing DacEasy is impossible as it doesn&#039;t work after 2010 (evidently coded EOL).</p><p>I can get the CVS files through the printing dialog. I&#039;m not sure if there is a separate export dialog anywhere but will look tonight.&nbsp; </p><p>How do I import this into front accounting so it can be used?&nbsp; This is not trivial to me.</p><p>I will get MySQL Workbench and look at the Database Migration Wizard and see if it will be useful.</p><p>FYI I was using DacEasy in DosBox on Linux.</p><p>Thanks.</p>]]></content>
			<author>
				<name><![CDATA[claton]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42040</uri>
			</author>
			<updated>2018-01-12T19:26:07Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30499#p30499</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30408#p30408" />
			<content type="html"><![CDATA[<p>BTrieve Tools:</p><p><a href="https://www.novell.com/coolsolutions/tools/13531.html">16 bit BT View</a> - <a href="https://www.novell.com/coolsolutions/tools/downloads/bview.zip">Download</a><br /><a href="http://dalethorn.com/Btrieve.html">BTrieve Tools Zip</a> - <a href="http://dalethorn.com/Btrtools.zip">Download</a><br /><a href="http://www.goldstarsoftware.com/whitepapers.asp">Technical White Papers on BTrieve conversion</a></p><p>Free Print Drivers:<br /><a href="http://dosprinter.net/">Free DOS Printer</a> for Windows - <a href="http://dosprinter.net/DOSPrinter.zip">Download</a><br /><a href="http://www.andtechnologies.com/index.php?q=downloads/free-software">DOSPrint</a> - [url=http://www.andtechnologies.com/download/free20110630/DOSPrint.zip[/url]Download[/url]</p><p>Tech Notes:<br /><a href="https://blogs.msdn.microsoft.com/7/2010/11/30/enabling-printing-for-dos-applications-within-windows-xp-mode-vm-on-windows-7/">Microsoft</a><br /><a href="https://www.4dos.info/dhardw.htm">4DOS</a><br /><a href="http://www.tomshardware.com/forum/119359-45-redirect-port-printer">Tom&#039;s Hardware</a></p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2018-01-05T03:08:02Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30408#p30408</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30407#p30407" />
			<content type="html"><![CDATA[<p>DacEasy (<a href="http://www.daceasy.com.hk/products/dosline.htm">v9</a> and <a href="http://www.daceasy.com.hk/products/deacv10_14.htm">v10 to 14</a> and <a href="http://www.popsoft.com.hk/downloadac/Daceasy/download.htm">Utilities</a>) 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 <a href="https://en.wikipedia.org/wiki/Btrieve">BTRIEVE</a> database for DOS that is akin to MySQL&#039;s <a href="https://en.wikipedia.org/wiki/ISAM">ISAM</a> (Indexed Sequential Access Method) DB Engine.</p><p>The manual for DacEasy v14 is available <a href="http://www.infocenter.com.hk/daceasy/download/v14/DacEasy%20Installation%20&amp;%20New%20Features%20Guide.pdf">here</a> and it&#039;s list of files and what they are for is <a href="http://www.shouldiremoveit.com/Sage-DacEasy-Version-2014-95069-program.aspx">listed</a> here.</p><p>Commercial products to convert Btrieve DB to MySQL DB are:<br /><a href="https://www.mertech.com/btrieve-to-mysql/">Mertech Btrieve to MySQL</a><br /><a href="https://web.archive.org/web/20160724231256/http://www.fullconvert.com/Btrieve-to-MySQL/">FullConvert Enterprise</a> - abandoned / unsupported / lost on the web<br /><a href="http://www.nssdd.com/pricing.htm">Nelson Software Tools</a></p><p>BTrieve itself is now Pervasive SQL (PSQL) - <a href="https://forums.mysql.com/read.php?79,630005">MySQL Discussion thread for conversion</a>.</p><p>DacEasy is now part of Sage and they <a href="https://sagecity.na.sage.com/support_communities/sage_daceasy/f/sage-daceasy-forum/28906/daceasy-accounting-network-ver-9-for-windows-have-s-n-but-need-activation-key-for-reinstallation">do not generate Activation keys for these old versions</a> when you need to re-install. Provide feedback if <a href="https://www.findserialnumber.net/daceasy-accounting-9-0-serial-number-keygen-26486742.html">this</a> works.</p><p>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 <a href="http://www.dos2usb.com/">LPT2USB</a> Driver for them.</p><p><a href="http://www.dsbglobal.com/dosprinter/CaptureLpt1.htm">Capturing LPT1</a> is also possible.</p><p><a href="http://wiki.freedos.org/wiki/index.php/Printer">FreeDOS</a> supports USB Printers.</p><p>You can also run DacEasy in a DOS VirtualBox / VMWare Player / QEMU Emulator.</p><p><a href="https://en.wikipedia.org/wiki/DOSBox">DOSBox</a> too can be used.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2018-01-05T02:21:34Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30407#p30407</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Importing from DacEasy]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30405#p30405" />
			<content type="html"><![CDATA[<p>First I need you to know I&#039;m on a time crunch.&nbsp; I had been using DacEasy on DOS but it quit working after 2010.&nbsp; Being the world&#039;s best procrastinator my accounting is years behind. </p><p>I would like to know if it is possible and how I can import my chart of accounts, account values, customers, vendors, etc.</p><p>I&#039;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.</p><p>Thanks so much for any help you can give. </p><p>Claton</p>]]></content>
			<author>
				<name><![CDATA[claton]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42040</uri>
			</author>
			<updated>2018-01-04T19:02:36Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30405#p30405</id>
		</entry>
</feed>
