26

(15 replies, posted in Setup)

Hello Excellence,

   The Full Administrator permission have been granted to you. You may proceed with your testing. Thanks You.

Cheers,

tclim

27

(6 replies, posted in Wish List)

Hi All,

   Thanks you for participate in FrontAccounting UTF-8 testing. I appreciate your works and effort. I have submitted the patches that I have done to Joe/Janusz. I hope that they will incorporate into the next release as soon. This will solved the problem arising and causing too many complaint about the encoding issue.

   For those who are existing FrontAccounting users. You are encourage to upgrade to the new release  (hopefully they will released it together with this patches). If you don't want to wait for the next release. You can contact me at tclim@anterp.com. i will help you to convert your existing FrontAccounting package.

  Cheers,

  tclim

28

(15 replies, posted in Setup)

Hello Excellence,

  I have created a new FrontAccounting 2.3.7 DEMO Site. Please use the following information to test it.

URL:  http://www.anterp.com/fa/index.php
Login ID: admin
Password: password1

Please choose your COA.

2) ARABIC EGYPT 8 DIGITS COA

I will add more COA test for others country soon. Let me know the result. Appreciate your works. Thanks You.

Cheers,

tclim

29

(6 replies, posted in Wish List)

Hi All,

   Greeting, I have spend for few days investigate the FrontAccounting "core" source code and trying to convert all COA into UTF-8. I have partially completed but need more testing from you all. Will you willing to help in testing? I will definitely release this code to the community. Hope to heard from you. Thanks You.

Cheers,

tclim

30

(15 replies, posted in Setup)

Hello Excellence,

  I have take initiative to change the FrontAccounting Based and converted into UTF-8. I have partially completed and I need your help to test it. Will you willing to test it out? Appreciate you could.  Once it stable and I will release to the community. Thanks you.

Cheers,

tclim

Hello Rodw,

  Yes please, I have just installed a new FrontAccounting 2.3.7 to reproduce your issue. If you follow the step above, it should work fine. By the way, I am running Linux CentOS 5 64 bit in my test environment. I think the step that I show you above should be able to use in others Linux distributed (with minor changes in database user name apache). Please try it again. Thanks You.

Cheers,

tclim

32

(21 replies, posted in Accounts Receivable)

Hello rodw,

  I have just replied your request on another topic at

https://frontaccounting.com/punbb/viewtopic.php?id=2485

   Please have a look.

Cheers,

tclim

Hello rodw,

  I try to installed new FrontAccounting v2.3.7 and login as admin. I able to Install Language. Extension, Themes/ Chart of Accounts. The only requirements is you must login as the first company you created with FrontAccounting.

If you worry about the permission issue. you may follow the step below to create a new FA 2.3.7.

1) Create MySQL Database
----------------------------------------------------------------------------------------------------------------------------------------
   drop database accountdb;
create database accountdb;
use accountdb;

GRANT ALL ON accountdb.* TO 'apache'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

flush privileges;
----------------------------------------------------------------------------------------------------------------------------------------

  2) Downloads and install FrontAccounting 2.3.7

  2.1) tar -zxvf frontaccounting-2.3.7.tgz
  2.2) chmod 777 modules
          chmod 777 company
          chmod 777 lang
          chmod 777 tmp

2.3) Open Firefox Browser
         http://www.yourdomain.com/frontaccounting

2.4) Setup it and enter your database, admin informations

2.5) After completed. Change the permission as below:
   
chmod 755 modules
chmod 755 company
chmod 755 lang
chmod 755 tmp
chmod 755 themes
chmod 755 sql
chmod 444 config.php
chmod 444 config_db.php
rm -rf install

NOTE:  If you have more than 1 company setup in your FrontAccounting, please use the permission below:

chmod 644 config.php
chmod 644 config_db.php

These 2 files must be writeable to update the new company information.  For security reason, I use chmod 444.

You should be able to install any languages, extension, themes, charts of account. Hope the step above work for you. I usually use the step above to installed FrontAccounting. Thanks You.


Cheers,

tclim

Hi RodW,

  Welcome back. I will inform you when the Virtualmart modules are ready. Thanks you for your support.

Cheers,

tclim

35

(21 replies, posted in Accounts Receivable)

Thanks Joe,

  I have tested the customer inquiry by replacing the code and press on F2, it works great. Thanks for the tips.

Cheers,

tclim

Hi nnnn2011,

  If you are running oldest version of FA 2.3.5, the authentication was encrypted with MD5 before passing to FA. Due to I have submitted another plugin for LDAP authentication. FA team have change the authentication by using the plain text password. This may cause an errors if you deployed our FA Mobile Edition Version 2.3.6 and above into your OLD FA Version 2.3.5.

  To solved your problem, you MUST downloads FA Mobile Edition version 2.3.5. You cannot re-deployed the new version since the authentication will not be able to authenticate. Kindly deploy our FA Mobile Edition with the correct FA version. It will solved the authentication issued. Hope you are clear.

Cheers,

tclim

Hi nnnn2011,
 
  Since you are running FA Version 2.3.5. The current latest version in FA downloads section only show latest version which is supported by FA Version 2.3.6 and 2.3.7. Please downloads directly from my site. It FREE don't worry.

http://www.anterp.com/shop/frontaccounting-mobile

Please redeploy into your server again. Thanks You.

Your Sincerely,

Tee Chert

Hi Lordas101,

   We will add-on  Virtuemart support in future. We will notify you when we are ready. Thanks you.

Cheers,

  tclim

Hi nnnn2011,

  I  am the owner of this FA mobile Edition. Please let me know what version of FA you are currently running? I have submitted 2 version of FA to this forums which covers:

  1) FA Mobile Edition for - V2.3.4 / 2.3.5
  2) FA Mobile Edition for - V2.3.6 / 2.3.7

  But when I try to downloads from Downloads page, https://frontaccounting.com/wbt/pages/d … se-2.3.php. It only have 1 files fa_mobile_236_237.zip. These mean that you are only allowed to use it in newest version of FA. Maybe Joe need to somehow let the visitors to downloads another previous version for FA Mobile Edition V 2.3.4 / 2.3.5.

Please let me know your server information and also FA version. Thanks You.

Cheers,

tclim

40

(3 replies, posted in Setup)

Hello qasimshabbir,

Do you able to access the main page at www.anterp.com yesterday? I was not aware of this until I read your message here. Thanks for reporting to us. We will hardening the server in future. Thanks You.

Cheers,

tclim

Hello Excellence,

   Thanks you for the nice word. I will added more widgets to show the "Recent Activities like New Sales, Customer etc. It will be glad if you can provide some input that is useful when you login to FA Dashboard.

Cheers,

  tclim

42

(21 replies, posted in Accounts Receivable)

Hello,

  When you create a new customer, you must at least create one customer branch. This is necessary in existing framework. Anyway, to automate it, you may edit the file at

   vi sales/manage/customers.php

   under the function handle_submit(&$selected_id)
   
  else
    {     //it is a new customer

        begin_transaction();
        add_customer($_POST['CustName'], $_POST['cust_ref'], $_POST['address'],
            $_POST['tax_id'], $_POST['curr_code'], $_POST['dimension_id'], $_POST['dimension2_id'],
            $_POST['credit_status'], $_POST['payment_terms'], input_num('discount') / 100, input_num('pymt_discount') / 100,
            input_num('credit_limit'), $_POST['sales_type'], $_POST['notes']);


        $selected_id = db_insert_id();
               
        add_branch($selected_id, $_POST['CustName'], $_POST['cust_ref'],
                $_POST['address'], '1', '1', '1', get_company_pref('default_sales_act'),
                get_company_pref('default_sales_discount_act'), get_company_pref('debtors_act'), get_company_pref('default_prompt_payment_act'),
                'DEF', $_POST['address'], 0, '1','1', $_POST['notes']);

 
Please Note:

   This is just my opinion, some parameters are hardcoded to show you the sample. maybe there are better ways to solved your issue. if you try this piece of code, it will work but you need to cater for update function too. The others area you should look into is how it create the contact for this customer.

  Cheers,

  tclim

Hello All,

   For those who are using AntERP.com Mobile Edition. Please downloads a new version with bugfix from:

      http://www.anterp.com/shop/frontaccounting-mobile


Changelog by tclim (13 Oct 2011)
- Bugfix for querying company that have been deleted. The company index was wrongly query from company.php Thanks to Roman K reporting this issued.

- Upgrading the latest Jquery Mobile Alpha RC1 libraries. This should be the latest library at the moment of the released.

  Installation Guide have been included in the documents.

  1) Please BACKUP before you deploy it.
  2) No databases changes.
  3) Just overwrite the existing FA Mobile Edition files. Don't worry, it does not affect your existing FrontAccounting. Only overwrite the FA Mobile Edition.

  The patches have just send to FrontAccounting, it may take some time to upload into Repository. For quick access, please download from above link.


  Hope you enjoy it. Thanks You.

Cheers,

tclim

44

(4 replies, posted in Setup)

Hello Apple,

  I do not used Piwik in my code. I visit the site at piwik and copy the sample code just to show you how to render the JavaScript in FA. It must be used within the

   echo ' ...........javascript here ...........';

  You should copy your tracking code and put into the FA. But not using the sample code that I provide above. That was just to show you how to render the JavaScript. Sorry about that if I provide any misleading information in this topic.

  Anyone who use the Piwik please help Apple to resolved the problem. Thanks You.

Cheers,

  tclim

45

(4 replies, posted in Setup)

Hi Apple,

  You are rights, the place you inserted just before the line

  echo "</body></html>\n";

  I assume that your tracking code as below:

<script type="text/javascript">
try {
    var piwikTracker = Piwik.getTracker("http://URL_1/piwik.php", 1);
    piwikTracker.trackPageView();
    var piwik2 = Piwik.getTracker("http://URL_2/piwik.php", 4);
    piwik2.trackPageView();
} catch( err ) {}
</script>

But you cannot copy and paste into the footer.inc directly, it should be something like below:

echo '<script type="text/javascript">
    try {
        var piwikTracker = Piwik.getTracker("http://URL_1/piwik.php", 1);
        piwikTracker.trackPageView();
        var piwik2 = Piwik.getTracker("http://URL_2/piwik.php", 4);
        piwik2.trackPageView();
    } catch( err ) {}
    </script> ';
   
    echo "</body></html>\n";

  Note:

    You must place the echo '   javascript here and end with '; Please try it.

  Cheers,

  tclim

46

(1 replies, posted in Report Bugs here)

Hello Marc,

  I have search the forum and found out that you have posted this issue in the past. The solutions have been given to you on another topic at https://frontaccounting.com/punbb/viewtopic.php?id=2416 which was posted by yourself.

  If you still unable to solve your problem. I will like to recommend you to switch you current Operating System. The best ways is to install the OS with 64 bit. Since 64 bit have larger capacity to handle the process better than 32 bit architecture.

  Give a try on Linux Server 64 bit - it FREE. You may downloads and installed it. I am running CentOS 5 64 bit without any issue. If you wish, you may downloads a copy. Others recommendation is you may try out Ubuntu 10.04 64 bit. Another great OS.

  Please find the below url that address your issued.
   http://stackoverflow.com/questions/6315 … 8100096-by

  Hope it help.

  Cheers,

  tclim

Hello,

  Great to know that it working now. Enjoy it.

Cheers,

  tclim

Hello,

  If you are using Windows, kindly downloads a free version of NotePad++ from http://notepad-plus-plus.org/. You can easily open the file using NotePad++.

  Sometime, windows Notepad was unable to open the files. Hope it help.

Cheers,

tclim

49

(6 replies, posted in Wish List)

Hello,

  I agree that FrontAccounting should change the current encoding characters to fully support multi-language by replacing all the 'iso-8859-1', 'iso-8859-2' or whatever to 'UTF-8'.

The impact was not only in MySQL but also in all PHP files that encoded with 'iso-8859-1' , 'iso-8859-2' etc.  The Chart of Accounts - COA, Language Packs, Themes available in FA repository.

If you are using Linux Desktop or Server. Simple search all the text using the command below:

  grep -R -B3 -A4 "'iso-8859-1" /home/tclim/workspace/acct237

  grep -R -B3 -A4 "'iso-8859-2" /home/tclim/workspace/acct237

There are hardcoded 'iso-8859-1', 'iso-8859-2' everywhere.

Please also download the dejavu.zip from FrontAccounting and patches into reporting/fonts folder to fully support UTF-8 for PDF viewer. Hence, FA now become a solid Online Accounting Software. This is just my 2 cents.  Hope it help. Thanks You.

Cheers,

tclim

Hello tactics,

  Thanks you for the nice word. We do have our data Sync Suites for FrontAccounting, VtigerCRM and E-Commerce Shopping Cart (Opencart, Zencart, osCommerce, PrestaShop, CRE Loaded). But mostly, we have integrate with Open Source Project at the moment.

  I have a visit in WHMCS and it is a great products which is a commercial products for Web Hosting Billing. WHMCS have ready made API for developers to integrate with any 3rd party software. Hence, it is possible for us to sync the data from WHMCS into FrontAccounting.

Hello Joe,

   Thanks you for the nice word too. I do refer to the original 'exclusive' theme and  understand the flow on how it work. But I have totally rewrite the whole theme with different approach using Jquery and Google Charts. The only remaining is the SQL query string is refer to 'exclusive' theme on how to retrieve the data.

   FrontAccounting is a great great products and it will become one of the famous Open Source Accounting in future.

   Let me share my approach with you. initially, I was thinking of Piwik (http://demo.piwik.org/) which have a great dashboard idea for me to start. But due to time consuming. So, I refer back to my original code at www.anterp.com .

    If you wish to create the dashboard, I will recommend the following for you to start up:
  1) http://demo.piwik.org
  2) http://webdeveloperplus.com/jquery/coll … op-panels/
  3) http://nettuts.s3.amazonaws.com/127_iNE … index.html
  4) http://www.skypoet.net/yui/examples/iGo … ogle1.html
 
  Our current designed are based on http://webdeveloperplus.com/jquery/coll … op-panels/. Please refer to their Demo site at http://demo.webdeveloperplus.com/drag-drop-panels/. Click here to download the source code for dashboard http://demo.webdeveloperplus.com/source … panels.zip

  Google Charts can be refer to http://code.google.com/apis/chart/. There are plenty of resources and online sample can be found. Search for "google chart examples" will do. For my development, I refer to http://code.google.com/apis/ajax/playgr … #pie_chart. It is a great start for Google Charts. Thanks You.

Cheers,

tclim