FrontAccounting forum - Instructions

Re: Instructions

dummy@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

dummy@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

dummy@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

dummy@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

dummy@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

dummy@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

dummy@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

dummy@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

dummy@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

dummy@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

dummy@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

dummy@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

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

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

Re: Instructions

dummy@example.com (joe) — Sun, 07 Jun 2009 21:23:54 +0000

Something like this:
acc_no; acc_name; acc_type; ......
49091; Other Sales; Sales; ......
It doesn't really matter how the rows are formatted. Just an explanation on the fields.
Another possibility is to import (if you can) into either M$ Excel or Open Office Calc and export that file. And send it me.

/Joe

Re: Instructions

dummy@example.com (pongraczi) — Sun, 07 Jun 2009 15:42:22 +0000

Hi,

Could you show me a sample about the comma separated file?
I have a chart of accounts for my country, I am interesting to import that into FA.
Thank you!

István