Topic: EXISTING ENTRIES IN THE SYSTEM

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?

Re: EXISTING ENTRIES IN THE SYSTEM

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.
After that you can restore the Company from this file.

Now you have a pretty empty chart of accounts. At least without transactions.

/Joe

Re: EXISTING ENTRIES IN THE SYSTEM

Joe:

Where can I find en_US-new.sql and how do I upload it?

Thanks.

Re: EXISTING ENTRIES IN THE SYSTEM

This file is situated in the /sql folder of your installation.
You upload it via Setup tab, Backup and Restore. You select this file, and finally you restore this file into your Company.

/Joe

Re: EXISTING ENTRIES IN THE SYSTEM

Joe:

Please pardon my ignorance as this is the first time I am using FA. I am still encountering difficulties following your instructions.

This is what I have been doing:

I log on to my account at FA. Hit the "Setup" tab and then hit the "Backup and Restore" in the Maintenance section. The page that opens up has "Create Backup" and "Backup script maintenance" Two files are listed in the second section. The en_US-new.sql is not listed. What do I do from here?

Re: EXISTING ENTRIES IN THE SYSTEM

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.

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.
If not the same, then fix the en_US-new.sql file by replacing the 0_ prefix by your own prefix.

Finally restore the file en_US-new by selecting the file and press Restore.

That's it.

Joe

Re: EXISTING ENTRIES IN THE SYSTEM

Joe:

The only options for the right panel are:

View Backup
Download Backup
Restore Backup
Delete Backup
Upload File
Choose File

When I hit the "Choose File" option, it opens up the files that are on my computer. How do I select a file that is in the /sql folder.

Is it possible for you to retrieve the "en_US-new.sql" and send it to me in an attachment?

Re: EXISTING ENTRIES IN THE SYSTEM

Joe:

Alternatively, can you log into my account and do this "restore"?

Your help is greatly appreciated.

Re: EXISTING ENTRIES IN THE SYSTEM

@dkchew


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.
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.
You should then select this file and press Restore Backup.

/Joe

/Joe

Re: EXISTING ENTRIES IN THE SYSTEM

Joe:

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?

Re: EXISTING ENTRIES IN THE SYSTEM

Joe:

Got into MySQL thru my iPage account. It shows the "frontaccounting_aag674le4g" database, with the following tabs:

Databases
SQL
Status
Variables
Charsets
Engines
Processes
Export
Import

How do I get "en_US-new.sql" file from here and how do I copy it to the /company/0/backup folder?

Re: EXISTING ENTRIES IN THE SYSTEM

Ok, you can send me the url and admin login details to my email.  Please use: joe dot hunt dot consulting at gmail dot com.

Replace the dot with a . And at with the @ caharacter. Also trim the spaces.

Joe

Re: EXISTING ENTRIES IN THE SYSTEM

Joe:

Someone from iPage.com did help me get the "en_US-new.sql" file. Problem solved. Thanks for your patience.

Re: EXISTING ENTRIES IN THE SYSTEM

Glad that you managed.

/Joe