<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — After Installation Import Transaction Module Destroy FA]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=7934</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=7934&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in After Installation Import Transaction Module Destroy FA.]]></description>
		<lastBuildDate>Wed, 16 Jan 2019 14:08:52 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33996#p33996</link>
			<description><![CDATA[<p>Just install from official repo and then overwrite the files with the latest ones and then activate it for the desired companies and then activate the permissions for those companies roles.</p><p>The modules/_cache folder will have the remnants of module installations and the modules folder will have the module files in a fodler in it. Also the installed_extensions.php will have it listed if installed and will be also present in the various company counterparts where activated.</p><p>To manually install just copy over the module folder into the <strong>modules</strong> folder and then activate as normally done.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Wed, 16 Jan 2019 14:08:52 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33996#p33996</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33990#p33990</link>
			<description><![CDATA[<p>hey,</p><p>thanks for respond to me!</p><p>Encounter! Done!</p><p>well, i have one more question,</p><p>how can we remove the install/active extension files and use as manual installation via upload to modules folder because some of your install/active extension is not updated or maybe not download updated files from repo, so is there any possibility that we can break it or use a manual upload to modules/folder</p><p>https://imgur.com/a/c9Ccpu7</p>]]></description>
			<author><![CDATA[null@example.com (emiangel839)]]></author>
			<pubDate>Wed, 16 Jan 2019 06:20:30 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33990#p33990</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33987#p33987</link>
			<description><![CDATA[<p>This occurs because your CSV file is not properly formatted.<br />The <strong>list()</strong> statements in the files <strong>import_transactions.php</strong> and <strong>includes/import_transactions.inc</strong> populate the <strong>$code_id</strong> variable.</p><p>The possibilities where it could go wrong are at:<br /></p><div class="codebox"><pre><code>ST_JOURNAL:
  list($reference, $date, $memo, $amt, $code_id, $taxtype, $dim1_ref, $dim2_ref, $person_type_id, $person_id, $comments)
ST_BANKPAYMENT:
  list($reference, $date, $memo, $amt, $ignore, $code_id, $taxtype, $dim1_ref, $dim2_ref, $person_type_id, $person_id, $BranchNo)
ST_BANKDEPOSIT:
  list($reference, $date, $memo, $ignore, $amt, $code_id, $taxtype, $dim1_ref, $dim2_ref, $person_type_id, $person_id, $BranchNo)
ST_BANKDEPOSIT / ST_BANKPAYMENT:
  list($reference, $date, $memo, $amt, $code_id, $taxtype, $dim1_ref, $dim2_ref, $person_type_id, $person_id, $BranchNo)
ST_SALESORDER / ST_SALESINVOICE:
  list($customer_id, $branchNo, $reference, $date, $payment_id, $sales_type_name, $dimension_id, $dimension2_id, $item_code, $item_description, $quantity, $unit, $price, $discountpercentage, $freightcost, $delfrom, $deldate, $delto, $deladdress, $contactphone, $email, $custref, $shipvia, $comments, $exrate)</code></pre></div>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Tue, 15 Jan 2019 19:09:09 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33987#p33987</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33983#p33983</link>
			<description><![CDATA[<p>hey,</p><p>thanks for respond to me,</p><p>well, i am tried to encounter an errors which is i found is here</p><div class="codebox"><pre><code>DATABASE ERROR : Could not query chart_master table
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;= account_code&#039; at line 1
sql that failed was : SELECT account_code FROM 0_chart_master WHERE = account_code</code></pre></div><p>any solutions?</p>]]></description>
			<author><![CDATA[null@example.com (emiangel839)]]></author>
			<pubDate>Tue, 15 Jan 2019 12:05:59 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33983#p33983</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33969#p33969</link>
			<description><![CDATA[<p>Check if the DB user in FA has the necessary permissions - use the debug feature in FA and check it out or take local professional assistance.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Mon, 14 Jan 2019 18:32:07 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33969#p33969</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33955#p33955</link>
			<description><![CDATA[<p>hey, thanks for reply</p><p>well, i have checked it for the purpose of reference i used now 001/2019<br />for the DB issue,<br />i have created a new company such as demo and now try to do in it.<br />but nothing error is found and when we click process without trial its again show to me as i have disclosed image above.</p><p>can you please guide me for this or any other ways to do?</p>]]></description>
			<author><![CDATA[null@example.com (emiangel839)]]></author>
			<pubDate>Mon, 14 Jan 2019 12:07:42 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33955#p33955</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33950#p33950</link>
			<description><![CDATA[<p>Logout, close all browser instances and then login. Check the db that the serial numbers of the vouchers do not already exist in your FA instance. Then try it again.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Mon, 14 Jan 2019 08:57:36 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33950#p33950</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33947#p33947</link>
			<description><![CDATA[<p>hey,</p><p>thanks for respond to me;</p><p>well, i have un-tick the TRIAL RUN already the same this is occur i have also attached a image for you</p><p>https://imgur.com/a/M3hfkrF</p><p>Regards</p>]]></description>
			<author><![CDATA[null@example.com (emiangel839)]]></author>
			<pubDate>Mon, 14 Jan 2019 07:32:53 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33947#p33947</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33946#p33946</link>
			<description><![CDATA[<p>It appears that you are using the dry run method which is used for checking. Try the actual run choice.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Mon, 14 Jan 2019 06:26:04 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33946#p33946</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33945#p33945</link>
			<description><![CDATA[<p>hey,</p><p>Thanks for responding to me.<br />Well we have first worked on our demo server then went live.</p><p>Well, I have checked and replaced files download from your repo!</p><p>The module is now working but when we make .csv and upload it, it shows to me:<br /></p><div class="codebox"><pre><code>Bad debts using account 8100 (Reference: 101)
2:1065
Added to table &#039;bank_trans&#039;: 11, 2, 101, 10/01/2019, 1000, 0, (line 2 in import file journal_en_GB.csv&#039;)
Added to table &#039;gl_trans&#039; Debit bank account: 11, 10/01/2019, 1065, 0, 0, 1000, Bad debts using account 8100 (Reference: 101) , 0, (line 2 in import file &#039;journal_en_GB.csv&#039;)
Debtors Control using account 1100 ( Person: 2, Reference: 101)
3:1060
Added to table &#039;bank_trans&#039;: 11, 1, 101, 10/01/2019, -1000, 2, 2 (line 3 in import file &#039;journal_en_GB.csv&#039;)
Added to table &#039;gl_trans&#039; Debit bank account: 11, 10/01/2019, 1060, 0, 0, -1000, Debtors Control using account 1100 ( Person: 2, Reference: 101) , 2, 2 (line 3 in import file &#039;journal_en_GB.csv&#039;)
(Reference: )</code></pre></div><p>This means there is no error but when we&nbsp; checked the Journal inquiry nothing entry is recorded!</p><p>What can I do?</p>]]></description>
			<author><![CDATA[null@example.com (emiangel839)]]></author>
			<pubDate>Mon, 14 Jan 2019 06:23:13 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33945#p33945</guid>
		</item>
		<item>
			<title><![CDATA[Re: After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33940#p33940</link>
			<description><![CDATA[<p>The Official Extensions repo has become a nightmare for some as they have not been updated properly by the respective authors / maintainers in recent times. Compounded with this is the fact that PHP/MySQL versions too have been rapidly evolving. Hence the onus is on the end user to take suitable precautions like this non exhaustive list:</p><p>1. Take backup before any new module installation<br />2. Read the module code if PHP savvy<br />3. Compare the code in the modules folder with those in the <a href="https://github.com/apmuthu/FA24extensions">FA24Extensions repo</a> and other repos and use your own judgement before relying on any source.<br />4. Search the forums and the wiki and other&#039;s weblogs for pertinent gotchas.<br />5. Rollback any bad extension install<br />6. Ensure that the FA DB schema is not changed on such roll back - a restore from backup is better and advised.<br />7. File additions/deletions and modifications especially in the various installed_extensions.php files need to be rolled back as well.<br />8. Many Charts of Accounts when taken from the official repo will not have their field name orders in synch with the default ones.</p><p>If you are dealing with a commercial / production installation, do not use FA (or for that matter any ERP) without professional assistance - smart people&#039;s time will need to be paid for well and are certainly worth much more than many dumb superior&#039;s salaries! Those who pretend to be &quot;self-sufficient&quot; IT heads responsible for FA in their organisations are actually doing a great disservice to their employers - all will be well till something goes wrong and then heads roll or a coverup occurs - either way FA gets a bad name!</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Mon, 14 Jan 2019 04:46:56 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33940#p33940</guid>
		</item>
		<item>
			<title><![CDATA[After Installation Import Transaction Module Destroy FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33939#p33939</link>
			<description><![CDATA[<p>hey,</p><p>can anyone help me regarding this module when i install and active this module its destroy the FA</p><p>i have attached image for better understanding</p><p>https://imgur.com/a/XehZzXB</p><p>tested on version 2.4.4 , 2.4.5 and v2.4.6</p><p>regards</p><p>*or any module is here for transaction import?</p>]]></description>
			<author><![CDATA[null@example.com (emiangel839)]]></author>
			<pubDate>Sun, 13 Jan 2019 13:15:46 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33939#p33939</guid>
		</item>
	</channel>
</rss>
