<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — FA 2.3.24 importing CSV file of items not working,]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=5920</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5920&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in FA 2.3.24 importing CSV file of items not working,.]]></description>
		<lastBuildDate>Fri, 04 Sep 2015 07:50:31 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: FA 2.3.24 importing CSV file of items not working,]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=24184#p24184</link>
			<description><![CDATA[<p>Do not use the import_items extension to start with, as the CSVs do not respect the changes in your FA installs&#039; specific Chart of Accounts especially if they differ in field order from the stock en_US-new.sql CoA. The presence of db schema customizations and/ or changes brought in by installation of extensions (I am assuming your are using the Git Snapshot of the FA 2.3.x stable version) too must be factored in.</p><p>My <a href="https://frontaccounting.com/fawiki/index.php?n=Devel.ManualImportOfInventoryItems">Wiki article on import of items</a> into FA (straddles several tables) has been extended with what to do in case the field order is different from the standard en_US-new.sql CoA - it now appears quite frightening when I look at it though!</p><p>If and only if you cannot still get it done, pm the access details and I can get it done. Going forward it will be a hassle to keep bulk updating it if your are then unable to use the import_items extension as is. Work involved would be hex cleanup of the data and sanitising it for CSV / SQL import besides managing it&#039;s field and table dependancies and business computation rules.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Fri, 04 Sep 2015 07:50:31 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=24184#p24184</guid>
		</item>
		<item>
			<title><![CDATA[FA 2.3.24 importing CSV file of items not working,]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=24178#p24178</link>
			<description><![CDATA[<p>Dear forum,</p><p>This is my second post on this forum, I am still orientating FA and I am very enthusiastic about it.<br />The problem with NL language has been solved thanks to this forum (thanks Apmuthu)</p><p>So its obvious I am a newbee into FA :-)</p><p>Another issue which I encountered is that its seems that its not possible to import items using a .CSV file.</p><p>However import_items version 2.3.0-3 is installed with the internal installer confirmed by the &quot;installed extensions list&quot;, I can not import (or export) any CSV list of the items at all.</p><p>I have read many topics and posts related to CSV file import and I am trying to get this working for 2 days now, but the information in those posts don&#039;t work for me unfortunately.</p><p>Flow:<br />-import_items 2.3.0-3 has been installed with the internal installer<br />-there is NOT an extra bullet in the role maintenance listing which I can check<br />-Due to no bullet to check under rol maintenance, there is NOT showing a new &quot;CSV export / import button&quot; or anything under&nbsp; &nbsp; Stock</p><p>FA version 2.3.24, latest master, installed SSL secured subdomain<br />MySQL 5.5.44<br />PHP 5.3.29<br />Apache 2.2.29</p><p>We got everything working what we need in FA but not the CSV import items.</p><p>FA seems very perfect for us, but has to have a item import function for more then 10K of parts.</p><p>So who can help us please?</p><p>Thank you so much for your help in advance.</p><p>Cheers,<br />Luc</p>]]></description>
			<author><![CDATA[null@example.com (luc vander)]]></author>
			<pubDate>Thu, 03 Sep 2015 17:02:45 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=24178#p24178</guid>
		</item>
	</channel>
</rss>
