<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — EXISTING ENTRIES IN THE SYSTEM]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=4962&amp;type=atom" />
	<updated>2014-05-21T18:55:29Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=4962</id>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19941#p19941" />
			<content type="html"><![CDATA[<p>Glad that you managed.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2014-05-21T18:55:29Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19941#p19941</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19940#p19940" />
			<content type="html"><![CDATA[<p>Joe:</p><p>Someone from iPage.com did help me get the &quot;en_US-new.sql&quot; file. Problem solved. Thanks for your patience.</p>]]></content>
			<author>
				<name><![CDATA[dkchew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19366</uri>
			</author>
			<updated>2014-05-21T17:46:13Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19940#p19940</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19939#p19939" />
			<content type="html"><![CDATA[<p>Ok, you can send me the url and admin login details to my email.&nbsp; Please use: joe dot hunt dot consulting at gmail dot com.</p><p>Replace the dot with a . And at with the @ caharacter. Also trim the spaces.</p><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2014-05-21T17:31:00Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19939#p19939</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19937#p19937" />
			<content type="html"><![CDATA[<p>Joe:</p><p>Got into MySQL thru my iPage account. It shows the &quot;frontaccounting_aag674le4g&quot; database, with the following tabs:</p><p>Databases<br />SQL<br />Status<br />Variables<br />Charsets<br />Engines<br />Processes<br />Export<br />Import</p><p>How do I get &quot;en_US-new.sql&quot; file from here and how do I copy it to the /company/0/backup folder?</p>]]></content>
			<author>
				<name><![CDATA[dkchew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19366</uri>
			</author>
			<updated>2014-05-21T17:18:05Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19937#p19937</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19935#p19935" />
			<content type="html"><![CDATA[<p>Joe:</p><p>How do I even get to my /sql folder? Is there a manual for FA so that I can learn how to use the software?</p>]]></content>
			<author>
				<name><![CDATA[dkchew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19366</uri>
			</author>
			<updated>2014-05-21T17:07:57Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19935#p19935</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19930#p19930" />
			<content type="html"><![CDATA[<p>@dkchew</p><br /><p>You can also copy the file from your /sql folder to the /company/0/backup folder. If you have file access to the folders, this should be no problem. <br />After that the en_US-new.sql file will show up in the backup window when you goto Setup tab in FA and select Backup and Restore.<br />You should then select this file and press Restore Backup.</p><p>/Joe</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2014-05-21T10:40:44Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19930#p19930</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19929#p19929" />
			<content type="html"><![CDATA[<p>Joe:</p><p>Alternatively, can you log into my account and do this &quot;restore&quot;? </p><p>Your help is greatly appreciated.</p>]]></content>
			<author>
				<name><![CDATA[dkchew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19366</uri>
			</author>
			<updated>2014-05-21T07:06:05Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19929#p19929</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19928#p19928" />
			<content type="html"><![CDATA[<p>Joe:</p><p>The only options for the right panel are:</p><p>View Backup<br />Download Backup<br />Restore Backup<br />Delete Backup<br />Upload File<br />Choose File</p><p>When I hit the &quot;Choose File&quot; option, it opens up the files that are on my computer. How do I select a file that is in the /sql folder. </p><p>Is it possible for you to retrieve the &quot;en_US-new.sql&quot; and send it to me in an attachment?</p>]]></content>
			<author>
				<name><![CDATA[dkchew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19366</uri>
			</author>
			<updated>2014-05-21T07:03:59Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19928#p19928</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19925#p19925" />
			<content type="html"><![CDATA[<p>In the right pane select the option Browse for the en_US-new.sql in the /sql folder. Then upload this file by selecting Upload.</p><p>Use an editor to look at this uploaded file. Check that the table prefix (0_)is the same that the table prefix for your company. You can probably see that by looking at one of your backups.<br />If not the same, then fix the en_US-new.sql file by replacing the 0_ prefix by your own prefix.</p><p>Finally restore the file en_US-new by selecting the file and press Restore.</p><p>That&#039;s it.</p><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2014-05-21T06:10:03Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19925#p19925</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19923#p19923" />
			<content type="html"><![CDATA[<p>Joe:</p><p>Please pardon my ignorance as this is the first time I am using FA. I am still encountering difficulties following your instructions. </p><p>This is what I have been doing:</p><p>I log on to my account at FA. Hit the &quot;Setup&quot; tab and then hit the &quot;Backup and Restore&quot; in the Maintenance section. The page that opens up has &quot;Create Backup&quot; and &quot;Backup script maintenance&quot; Two files are listed in the second section. The en_US-new.sql is not listed. What do I do from here?</p>]]></content>
			<author>
				<name><![CDATA[dkchew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19366</uri>
			</author>
			<updated>2014-05-20T21:57:57Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19923#p19923</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19921#p19921" />
			<content type="html"><![CDATA[<p>This file is situated in the /sql folder of your installation.<br />You upload it via Setup tab, Backup and Restore. You select this file, and finally you restore this file into your Company.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2014-05-20T20:29:46Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19921#p19921</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19920#p19920" />
			<content type="html"><![CDATA[<p>Joe:</p><p>Where can I find en_US-new.sql and how do I upload it?</p><p>Thanks.</p>]]></content>
			<author>
				<name><![CDATA[dkchew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19366</uri>
			</author>
			<updated>2014-05-20T19:52:45Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19920#p19920</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19919#p19919" />
			<content type="html"><![CDATA[<p>If this is the en_US-demo.sql data, then you can goto Setup tab, Backup and Bestore and upload the en_US-new.sql data from the /sql folder.<br />After that you can restore the Company from this file.</p><p>Now you have a pretty empty chart of accounts. At least without transactions.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2014-05-20T19:32:11Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19919#p19919</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[EXISTING ENTRIES IN THE SYSTEM]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19918#p19918" />
			<content type="html"><![CDATA[<p>Just installed the FA module. Noticed that there are already existing data entries in the system prior to 2014. How do we clear these entries?</p>]]></content>
			<author>
				<name><![CDATA[dkchew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19366</uri>
			</author>
			<updated>2014-05-20T19:22:02Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19918#p19918</id>
		</entry>
</feed>
