FrontAccounting forum — Instructions

Re: Instructions

null@example.com (joe) — Sat, 01 Mar 2014 05:35:47 +0000

1. You just upload it to the /company/X/backup folder, where X is your company number.

Make a search and replace of the table prefix, f.i. If the table prefix in the COA is 0_ then replace it with table prefix for your existing company.

Restore this backup on your existing company.

Remember to take backups before acting.

Joe

Re: Instructions

null@example.com (hfinger) — Sat, 01 Mar 2014 04:46:23 +0000

I downloaded en_AU-0000.sql and edited the definitions of the GST accounts and added a couple. I then checked for any cross-references in the rest of the file, and found only one, to 2290. When I tried to create a new company, I could not figure out to import this local CoA file. The only choice was to tick one of the Australian CoA options in the company details page.

How do I import a local SQL file?

Regards,
Hedley

Re: Instructions

null@example.com (joe) — Mon, 11 Apr 2011 21:33:16 +0000

I am not sure how this works in UTF8. The field len for account name is 50. I thought that MySql extended it, but if it doesn't, yes I guess we have to shorten the names.

The orange triangle is a javascript time-out. It maybe an error. More info could be found if the javascript is turned off.

/Joe

Re: Instructions

null@example.com (jori) — Mon, 11 Apr 2011 20:04:10 +0000

What is a small orange triangle with exclamatory mark inside, it shows sometimes when processing, is it an error?

Re: Instructions

null@example.com (jori) — Mon, 11 Apr 2011 19:27:42 +0000

Thank you very much Joe!

Before I follow your insturctions in the email, I'd like to let you know that account names in COA are truncated. Maxium 22 characters are visable incl spaces. So I think I should make names shorter, right?

Re: Instructions

null@example.com (joe) — Fri, 08 Apr 2011 22:23:17 +0000

I have answered you directly. We should try to convert this into a SQL script file. If you have the opportunity you should make a backup of the client that is using this COA and send me this backup SQL script.

I will then send it to the global repository.

/Joe

Re: Instructions

null@example.com (jori) — Fri, 08 Apr 2011 17:04:42 +0000

I've just sent Georgian COA in xlsx format, is it OK?

Re: Instructions

null@example.com (itronics) — Mon, 28 Mar 2011 20:13:08 +0000

The easiest way is just to install FA when the box is connetced to interenet. The connection is not required later for normal use. Other option is to copy indonesian COA from working installation where i t is installed and restore it via Creat/Restore Backup.
Janusz

Re: Instructions

null@example.com (iqbalfa) — Thu, 24 Mar 2011 06:47:59 +0000

I want to install FrontAccounting 2.3.x to a computer that has no internet connection. How do I make the Indonesian COA available to that FrontAccounting installation?

Re: Instructions

null@example.com (itronics) — Mon, 06 Jul 2009 19:32:17 +0000

Yes, every company uses separated set of tables. All companies created are completely independent. Keep in mind that some (potentially dangerous) options are available only for admin of first created company (the super admin). This includes installing modules and languages, creating new companies and performing system upgrade.
Janusz

Re: Instructions

null@example.com (dleigh) — Mon, 06 Jul 2009 15:01:34 +0000

So, does "start a new company" (which I've not done yet) mean that one uses a whole separate set of database tables? Will I be prompted for the COA files in the process? Is there some sort of doc that tells HOW a COA is installed? I understand all the technical side, but what are the steps with respect to the application and what are the implications...that's what's missing in my understanding.

Re: Instructions

null@example.com (itronics) — Mon, 06 Jul 2009 13:23:17 +0000

You cannot simply replace one chart of accounts with another, because the COA is not stand alone feature, but is real foundation for any other features in FA. Most tables like suppliers, customers, items, transactions etc. has relations to GL accounts, so first you have to choose right COA, then fill database with other data.

Janusz

Re: Instructions

null@example.com (joe) — Mon, 06 Jul 2009 09:18:39 +0000

You will have to creaate a new company with this chart of account. Log in as super admin (the admin that creted the training co.
Then you can start from scratch.

/Joe

Re: Instructions

null@example.com (dleigh) — Sat, 04 Jul 2009 08:15:20 +0000

Excuse my ignorant question. I've got a working installation, with just the demo training company on it. I'm the IT guy for small French company and I want to add a French Chart of Accounts. I've downloaded the one from the site, but when I look at the file, it would appear that it's replacing THE ENTIRE DATABASE.

Is this right? does it squash everything (users, any customization we've already done, etc.)?

I've searched in forum to find a "how to" for installing a chart of accounts and have not found it. There's undoubtedly a piece of info that it seems that most folks understand straight away, but I don't. So any help would be appreciated.

Thanks!

Re: Instructions

null@example.com (pongraczi) — Mon, 08 Jun 2009 09:52:25 +0000

Ok, thank you, work in progress.............