FrontAccounting forum — Error during CSV Inventory Import

Re: Error during CSV Inventory Import

null@example.com (briankeesbury) — Thu, 01 Sep 2011 18:03:40 +0000

Thank you guys for the help. After getting the first import to work we are switching to using the BUY option to import for our next update.

I was wondering if it will read a Category column if I add one into it.

Re: Error during CSV Inventory Import

null@example.com (tom) — Mon, 08 Aug 2011 00:54:23 +0000

No, see the readme.txt for BUY

tom

Re: Error during CSV Inventory Import

null@example.com (briankeesbury) — Sun, 07 Aug 2011 23:41:07 +0000

Quick question on this though, is it possible to add my cost to the same csv to import that as well?

Re: Error during CSV Inventory Import

null@example.com (briankeesbury) — Sun, 07 Aug 2011 23:12:00 +0000

Works like a charm now. Thank you guy very much.

Re: Error during CSV Inventory Import

null@example.com (tom) — Tue, 02 Aug 2011 11:45:01 +0000

It looks like you are missing a column:

ITEM;ITEM_CODE;STOCK_ID;Description;Category;units;dummy;MB_FLAG;Currency;Price;

Where Item_Code = STOCK_ID of the item.

You have the STOCK_ID missing

I think for the most part ITEM_CODE == STOCK_ID, these are used in the 'item_codes' table

Also line 52 of import_items.php has a problem it should be:

function get_dimension_by_name($name) {
if ($name == '') return 0;

it was

if ($name = '') return 0;

If you are using dimensions, it seems that the 'dummy' field before MB_FLAG is where you can put a dimension

Let me know if this fixes you up

tom

Re: Error during CSV Inventory Import

null@example.com (tom) — Fri, 29 Jul 2011 15:55:25 +0000

Yes I will look at it

Re: Error during CSV Inventory Import

null@example.com (joe) — Fri, 29 Jul 2011 06:26:51 +0000

Hello Tom Moulton,

Will you have a look at this. I guess you wrote this module, right?

/Joe

Error during CSV Inventory Import

null@example.com (briankeesbury) — Thu, 28 Jul 2011 21:58:10 +0000

Description:
DATABASE ERROR : Could not find dimension
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 '' at
line 1
sql that failed was : SELECT * FROM 0_dimensions WHERE name=

FrontAccounting 2.3.5
Inventory Items CSV Import 2.3.0-1(Installed) 2.3.0-1(Available)
MySQL 5.1
Apache 2.2.XX (Latest Version)

Link to my CSV:
https://docs.google.com/leaf?id=0B5_5equsThdMYTQ2N2IyYTAtY2Y2ZC00NDQ0LThmZWItNGU0ZWZkZTAzZDc1&sort=name&layout=list&num=50