<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Import transactions not working]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=10722&amp;type=atom" />
	<updated>2026-04-18T04:59:59Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=10722</id>
		<entry>
			<title type="html"><![CDATA[Re: Import transactions not working]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=43861#p43861" />
			<content type="html"><![CDATA[<p>Update on this problem:</p><p>With the help of my programmer son, we tracked the upload progress through the import_transactions.php file by dropping in display debug statements at various points in the code.&nbsp; We finally found some code that if we comment out one line the import program continues to the point where it reports that the .csv has been imported.&nbsp; However, the imported order cannot be found.</p><p>The line of code that we commented out is line 360 (we were using Notepad to search the file, so this may not be the actual line of code).&nbsp; Here is a snippet of the code (the suspect line is $_SESSION[ &#039;Items&#039; ]-&gt;write(0);):</p><p>display_notification_centered(&quot;a&quot;);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //$_SESSION[&#039;Items&#039;]-&gt;write(0);<br />display_notification_centered(&quot;b&quot;);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION[&#039;Items&#039;]-&gt;clear_items();<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; unset($_SESSION[&#039;Items&#039;]-&gt;line_items);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; unset($_SESSION[&#039;Items&#039;]);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $firstlinecopied = false;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Commit import to database</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($type == ST_JOURNAL) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $typeString = &quot;General Journals&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } elseif ($type == ST_BANKDEPOSIT) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $typeString = &quot;Deposits&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } elseif ($type == ST_BANKPAYMENT) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $typeString = &quot;Payments&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } elseif ($type == ST_SALESORDER) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $typeString = &quot;Sales Order csv lines / $doc_num order(s)&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } elseif ($type == ST_SALESINVOICE) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $typeString = &quot;Sales Invoices csv lines / $doc_num invoice(s)&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</p><p>It would be appreciated if someone would provide some next steps for us to check.&nbsp; The FA version is 2.4.9.&nbsp; Thanks</p>]]></content>
			<author>
				<name><![CDATA[diventi.enterprises]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42171</uri>
			</author>
			<updated>2026-04-18T04:59:59Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=43861#p43861</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Import transactions not working]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=43860#p43860" />
			<content type="html"><![CDATA[<p>I am trying to import sales order data from Shopify into FA.&nbsp; I&#039;ve read all the posts I can find on the subject and have tried numerous variations of data types in the .csv file.&nbsp; I have used the template FA makes available.&nbsp; Does it matter which character set is selected on the csv import dialogue?</p><p>I have progressed to the point where no errors are reported and the FA interface feeds back a line highlighted in green of the data that was processed.&nbsp; However, when I check to see if a new SO record was created I don&#039;t find one.</p><p>I would expect that the feed back resulting from a successful upload would be more than the green highlighted information.</p><p>Also, the menu option to IMPORT TRANSACTIONS is perpetually greyed out, forcing me to go through the steps to save the access rights for the Administrator (me) each time I want to try to import.&nbsp; Not sure if this is somehow related but even if it isn&#039;t it&#039;s very frustrating!</p>]]></content>
			<author>
				<name><![CDATA[diventi.enterprises]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42171</uri>
			</author>
			<updated>2026-04-17T00:15:30Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=43860#p43860</id>
		</entry>
</feed>
