<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — FA 2.3.24 importing CSV file of items not working,]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5920&amp;type=atom" />
	<updated>2015-09-04T07:50:31Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5920</id>
		<entry>
			<title type="html"><![CDATA[Re: FA 2.3.24 importing CSV file of items not working,]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=24184#p24184" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-09-04T07:50:31Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=24184#p24184</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[FA 2.3.24 importing CSV file of items not working,]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=24178#p24178" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[luc vander]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20682</uri>
			</author>
			<updated>2015-09-03T17:02:45Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=24178#p24178</id>
		</entry>
</feed>
