4,926 Reply by apmuthu

(5 replies, posted in Banking and General Ledger)

"Yes they are" what ??

general customers/suppliers

OR

journal debtors/creditors only?

Go to forum: Banking and General Ledger

4,927 Reply by apmuthu

(13 replies, posted in Accounts Receivable)

Pass a contra entry!

Go to forum: Accounts Receivable

4,928 Reply by apmuthu

(5 replies, posted in Report Bugs here)

If it is windows XP, there there should not be user permissions issue. If it is Win7/8/8.1 then there could be user permissions issues for the folders having the FA code. Are you running it on XAMPP (if so please see the wiki for OpenSSL extension inclusion in php.ini). Check your php.ini settings to see if it satisfies FA's requirements. Also see that some of the .htaccess files are not causing you problems by renaming them temporarily.

Go to forum: Report Bugs here

4,929 Reply by apmuthu

(5 replies, posted in Banking and General Ledger)

debtors and creditors go into debtor_master table and possibly have customer / branch tables to be populated as well.

Are these debtors/creditors general suppliers / customers or are they journal debtors/creditors only?

The GL and Dashboard will automatically pick up the entries from the database tables when populated.

Go to forum: Banking and General Ledger

4,930 Reply by apmuthu

(3 replies, posted in Jobs wanted/offered, non-free offers)

If only search is required outside of FA code, it can be hammered out using other tools with canned SQLs. If search is required within FA, the see if any similar functionality exists in other parts of FA and then try to port it.

Better still is to avoid the drop down entirely and choose the ajax method by toggling the checkboxes in the company Setup page.

Go to forum: Jobs wanted/offered, non-free offers

4,931 Reply by apmuthu

(4 replies, posted in Report Bugs here)

The auto Google translate bash oneliner was requested to make translation easier as native speakers of the language can afterwards correct only the ones that are wrong.

Sales Invoice
Sales Invoice:

The above two could have been handled by just one instance without the colon and the colon could have been hard coded in the scripts. If the colon comes in between the string, then it can be handled individually.

Go to forum: Report Bugs here

4,932 Reply by apmuthu

(3 replies, posted in Jobs wanted/offered, non-free offers)

Search Window Facility for Items, Customers, Suppliers already exists with Ajax and without it (drop down select box) - based on Company Setup checkboxes settings.

Go to forum: Jobs wanted/offered, non-free offers

4,933 Reply by apmuthu

(9 replies, posted in Reporting)

If by July you have introduced new accounts then the two would not match.

Hence use something like WinMerge or some diff program to compare both reports and then you can make do with the reports as they are.

Go to forum: Reporting

4,934 Reply by apmuthu

(2 replies, posted in Translations)

The fix for this issue is attached herein.

--- old/admin/inst_lang.php    Mon Sep 29 21:21:28 2014
+++ new/admin/inst_lang.php    Mon Oct 13 07:15:53 2014
@@ -77,7 +77,7 @@
 
         $support = $GetText->check_support($lang, $charset);
 
-        if (function_exists('gettext') && !$support && !get_post('DisplayAll')) continue;
+        if (function_exists('gettext') && !$support && !get_post('DisplayAll') && $lang != 'C') continue;
 
         label_cell($lang);
         label_cell($available ? get_package_view_str($lang, $lang_name) : $lang_name);

Go to forum: Translations

4,935 Topic by apmuthu

(2 replies, posted in Translations)

The default page that comes up when we navigate to Setup -> Install/Update Languages is the one that has the checkbox "Display also languages not supported by server locales" unchecked and it does not display the default "C" language so important to revert to English!

A fix to remedy this is needed - otherwise we will have to continually check the checkbox and then choose "C".

Go to forum: Translations

4,936 Reply by apmuthu

(4 replies, posted in Report Bugs here)

There are lots of strings with and without a colon(:) at the end - can they not all be consolidated?
Minimizing number of strings would make for quicker translations.

Also ucfirst() can be used to capitalise the first letter of a string to minimize the number of strings in translations as well.

Any bash oneliner to make a quick Google translate and work from there?

Go to forum: Report Bugs here

4,937 Reply by apmuthu

(6 replies, posted in Report Bugs here)

It is Login Timeout and is the last but one in the right hand side.

All system details are at Setup -> Maintenance -> System Diagnostics.

Go to forum: Report Bugs here

4,938 Reply by apmuthu

(12 replies, posted in FA Modifications)

@Janusz - please check to see if it can be included in the core with or without a flag in the config.

Go to forum: FA Modifications

4,939 Reply by apmuthu

(6 replies, posted in Report Bugs here)

Setup -> Company Setup -> Browser Timeout -> change from default 600 (10 minutes) to say 28800 (8 hours).

Go to forum: Report Bugs here

4,940 Reply by apmuthu

(5 replies, posted in Report Bugs here)

Platform: Windows/Linux ?
PHP, Apache, MySQL versions?
JS should not be disabled to use FA.
Check your browser type and version and see if it has been infected. Remove all cache from the browser.

Go to forum: Report Bugs here

4,941 Reply by apmuthu

(5 replies, posted in Setup)

Make a file with the following contents:

<?php
echo phpinfo();
?>

and upload it to your webroot and browse to it - you will get all the server information you need like php version. Remove the file forthwith as it is a security risk if left there.

Find out what your webserver user is and make the webroot files and folders owned by it and make all folders 755 and files 644. That way the world will not be able to write into it.

All system details are at Setup -> Maintenance -> System Diagnostics.

Go to forum: Setup

4,942 Topic by apmuthu

(6 replies, posted in Modules Add-on's)

Visit my FA Utilities page for FA related Utilities as WebService.

Visit the Customer Import SQL generation page and input the Company Number (without the underscore) and a tab separated Vales text file containing the customers you wish to import.

Use the generated SQL in a MySQL client in the relevent database.

The input file should be a tab separated value file.
Have No headings
Must have .tsv file extension
File Size < 30Kb.
Nothing is stored on the server
Uploaded temporary file is parsed on the fly.
Only addslashes is used to clean input
No CR/LF in any of the fields

Fields in Order:
NickName
FirstName
LastName
Address
Phone
Email
NRIC
Gender

Go to forum: Modules Add-on's

4,943 Topic by apmuthu

(8 replies, posted in Translations)

The standard FA Repo does not as yet have any Tamil Translation.

If anyone has done it hitherto - please provide it to the project.

A small start has been made in doing it afresh. Around 230 (out of around 3000)  strings have been translated, compiled and attached herein along with screenshots to enable others to contribute as well.

In debian squeeze the following were done to get it working:

# locale-gen en_US.UTF-8 UTF-8 ta_IN UTF-8 en_US.ISO-8859-1 ISO-8859-1
sed -i -e 's/# en_US.UTF-8 UTF-8/en_US.UTF-8 UTF-8/' /etc/locale.gen
sed -i -e 's/# en_US ISO-8859-1/en_US ISO-8859-1/' /etc/locale.gen
sed -i -e 's/# ta_IN UTF-8/ta_IN UTF-8/' /etc/locale.gen
dpkg-reconfigure --frontend=noninteractive locales
update-locale en_US ISO-8859-1 en_US.UTF-8 UTF-8 ta_IN

The translation files were uploaded to lang folder.

A element was added to the array in lang/installed_languages.inc which now became:

<?php

/* How to make new entries here for non-packaged languages:

-- 'code' should match the name of the directory for the language under \lang
.-- 'name' is the name that will be displayed in the language selection list (in Users and Display Setup)
-- 'rtl' only needs to be set for right-to-left languages like Arabic and Hebrew
-- 'encoding' used in translation file
-- 'version' always set to '' for manually installed languages.
-- 'path' installation path related to FA root (e.g. 'lang/en_US').
*/


$installed_languages = array (
  0 => 
  array (
    'code' => 'C',
    'name' => 'English',
    'encoding' => 'iso-8859-1',
  ),
  1 => 
  array (
    'code' => 'en_US',
    'name' => 'English US',
    'encoding' => 'utf-8',
    'path' => 'lang/en_US',
  ),
  2 => 
  array (
    'code' => 'ta_IN',
    'name' => 'Tamil IN',
    'encoding' => 'utf-8',
    'path' => 'lang/ta_IN',
  ),
);

$dflt_lang = 'C';
?>

Login to the default company as admin and navigate to Setup -> Install/Activate Languages and choose the ta_IN radio button. Logout and Login again and the Tamil Login Interface will come up.

If you are using PoEdit to compile the .po to .mo file, then in Windows, the following utility (make_mo.bat) will come in useful when placed and executed from where the .po file is:

set langname=ta_IN
set poedpath=C:\Program Files\Poedit\bin\
copy %langname%.po "%poedpath%"
set abc=%cd%
cd "%poedpath%"
msgfmt %langname%.po -o %langname%.mo

move %langname%.mo "%abc%"
del %langname%.po
cd %abc%
set abc=

Useful Links:
TamilCUBE Dictionary
TamilDict Dictionary
Google Translate
gxlate - My PHP function to obtain a single Google translated string without the use of any Google Translate API key.

Go to forum: Translations

4,944 Reply by apmuthu

(6 replies, posted in Report Bugs here)

Check timeout. Possibly Windows 8.1 quirks....

Go to forum: Report Bugs here

4,945 Reply by apmuthu

(5 replies, posted in Setup)

php 2.11.9.6 ??

Go to forum: Setup

4,946 Topic by apmuthu

(4 replies, posted in Report Bugs here)

Please check the lang/new_language_template/LC_MESSAGES/empty.po file that contains several lines just being #, php-format.
Is this a bug / cause for some strings to become missing?

Go to forum: Report Bugs here

4,947 Reply by apmuthu

(9 replies, posted in Reporting)

Isn't that what you wanted - to display all?

Go to forum: Reporting

4,948 Reply by apmuthu

(5 replies, posted in Setup)

Yes do that but make sure that the webserver user has write access to the important files and folders (heck, just make it all for now).

Also state what platform you are on - Linux / Windows and and flavour/version, apache, php and mysql versions too wold be handy.

You need to install languages and CoAs from the default company and activate them for the other companies before becoming visible in them (don't forget to activate the extensions/CoAs for the respective companies.

Go to forum: Setup

4,949 Reply by apmuthu

(3 replies, posted in Reporting)

The Arabic Fonts can be downloaded here.

Go to forum: Reporting

4,950 Reply by apmuthu

(3 replies, posted in Reporting)

Wiki-ed the solution.

Arabic in FA
============
In linux, install the Arabic locale:
    locale-gen ar_EG.utf8
Install ar_EG Arabic Language within FA
Edit the encoding in lang/installed_languages.inc to be 'utf-8' for ar_EG language
Upload the Arabic fonts ? (aealarabiya and aefurat) to the reporting/fonts folder
Edit lines 158 in reporting/includes/class.pdf.inc to be:
    case "ar_EG" :     $fontname = "aealarabiya";     break;
When logged in, make your language preference for the UI to be Arabic.
Now all reports will be in Arabic.

Go to forum: Reporting