<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Inventory import]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=5103</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5103&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Inventory import.]]></description>
		<lastBuildDate>Thu, 21 Aug 2014 19:06:29 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Inventory import]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=20527#p20527</link>
			<description><![CDATA[<p>Add 1 item.<br />Export it<br />study the exported file format.<br />Prepare the rest of the items in that format.<br />Now import the rest.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Thu, 21 Aug 2014 19:06:29 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=20527#p20527</guid>
		</item>
		<item>
			<title><![CDATA[Inventory import]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=20518#p20518</link>
			<description><![CDATA[<p>Is there no way to import quantities as part of the Import CSV process?</p><p>I looked at the import_items.php file and mimicked the file layout in the section referring to the import items.</p><p>Here&#039;s the commented layout I used:</p><p>type, item_code, stock_id, description, category, units, qty, mb_flag, currency, price</p><p>However, when i go to import it I&#039;m getting a SQL every time. I&#039;ve double and triple checked it and the import columns are exactly the way they read above in the csv. </p><p>At first it belly ached about a problem with the 0_dimension table and I found a reference that suggested there was a typing error in one line (needed the double ==&nbsp; for the compare). I changed that and didn&#039;t get the error, but it did absolutely nothing but take me right back to the items import page. </p><p>I&#039;m a bit stumped as to how you&#039;re supposed to load skus with qtys and I can&#039;t even begin to entertain this if I have to write something to update them in sql. </p><p>Ideas?</p><p>Thanks,</p><p>C.</p>]]></description>
			<author><![CDATA[null@example.com (cdubks88)]]></author>
			<pubDate>Tue, 19 Aug 2014 14:08:41 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=20518#p20518</guid>
		</item>
	</channel>
</rss>
