FrontAccounting forum — Import an inventory list from a csv file

Re: Import an inventory list from a csv file

null@example.com (tom) — Thu, 04 Feb 2010 03:28:31 +0000

He has sent it to me and I will update the package.

thanks!
tom

Re: Import an inventory list from a csv file

null@example.com (itronics) — Wed, 03 Feb 2010 20:39:11 +0000

You can send code contributions to the address from Contact page of the site, or better directly to Tom to the address found on developer mailing list.
Janusz

Re: Import an inventory list from a csv file

null@example.com (tom) — Wed, 03 Feb 2010 14:03:13 +0000

Thanks for the bug report, I will add the update and have a new version posted for download!

Re: Import an inventory list from a csv file

null@example.com (stildalf) — Wed, 03 Feb 2010 12:45:30 +0000

Hi All,

I've made a change to this script to fix a problem when creating a new Item Category on item import. Script used to only specify category name and the category could then not be seen or edited by viewing 'Items and Inventory'->'Item Categories'.

Script now updates the following fields for the created Category: Tax Type, GL Accounts, Units & Item Type (Item/Service/Manufactured).

I just don't know where to post the updated file. Should I post it on Mantis? (Don't thinks so...)

Re: Import an inventory list from a csv file

null@example.com (stildalf) — Sun, 17 Jan 2010 07:09:21 +0000

Once again, thumbs up to everyone putting in the time over here.

Stildalf

Re: Import an inventory list from a csv file

null@example.com (joe) — Sat, 16 Jan 2010 09:34:29 +0000

This is on the Website for download now.

/Joe

Re: Import an inventory list from a csv file

null@example.com (tom) — Fri, 15 Jan 2010 11:51:34 +0000

I will have it this weekend.

I am just finishing up testing

tom

Re: Import an inventory list from a csv file

null@example.com (stildalf) — Fri, 15 Jan 2010 07:00:46 +0000

Hey Tom,

Noticed from module downloads section "CSV Importing - Advanced (Release 2.0.X only)". Gues this won't work in 2.2.3 then. Do you know how much work it might take to get it to work for 2.2.3? How far apart are the data structures from 2.0.x to 2.2.x?

I'm new to FA, a whole 2 days in actually. Loving it by the way. I have quite a few years of experience developing on Axapta/DynamicsAX for a bunch of clients and was looking for something way simpler to run a small IT support and development firm - pretty sure I've found it in FA. (Well done to all involved!) For sure I'll start digging under the hood soon and would love to assist where I can, when I can.

Re: Import an inventory list from a csv file

null@example.com (Tocharsy) — Thu, 15 Oct 2009 08:17:38 +0000

i newly install frontaccount for an existing company and need to enter the stocks into frontaccount but could not input the item quantity.
how can i get this done please.
thanks.

Re: Import an inventory list from a csv file

null@example.com (tom) — Mon, 08 Jun 2009 17:09:24 +0000

You can use anything (without spaces is best)

item_import

is good.

I think that field is in there so you can install more than one version of a given module

item_import1
item_import2

Why you'd need to do that I am not sure, but the flexibility is there.

You then go to the Menu Tab you selected (Items and Inventory) and click on the Name you have it (Items Import)

Select the GL Accounts you want to use for the items, etc.
Make sure you use the right Field separator. The default is ;
I personally use ,

The browse to the CVS file on your local system that you prepared

click Import

Warnings and errors will be noted and a summary of the number of updates made.

Tom
ps. I prefer to answer things here, so others can use the information too

Re: Import an inventory list from a csv file

null@example.com (Oebidoebie) — Mon, 08 Jun 2009 13:32:19 +0000

Joe,

I followed the instructions, but I would like to know where I should make the new folder (location) for import_items.

The readme.txt only states "should follow unix folder convention". I have no idea what this means.

Best regards,

Marc

Re: Import an inventory list from a csv file

null@example.com (joe) — Mon, 08 Jun 2009 13:09:55 +0000

Did you follow the instructions in the attached readme.txt file inside the module?
Tom has changed this module quite a bit. I think his email is inside. You can address him directly via email from here.

/Joe

Re: Import an inventory list from a csv file

null@example.com (Oebidoebie) — Mon, 08 Jun 2009 12:44:12 +0000

Joe,

I installed the import item module, but I don't know where to make the import_items folder.

At the moment it's not updating any products.

Best regards,

Marc

Re: Import an inventory list from a csv file

null@example.com (joe) — Fri, 28 Mar 2008 21:39:56 +0000

The problem is that the stock items require GL transactions, based on an item value. It is possible to change the Import module to do these transactions, but we do not have the resource for that at present. So otherwise you have to enter it manually.

/Joe

Re: Import an inventory list from a csv file

null@example.com (jgiiikmg) — Fri, 28 Mar 2008 14:01:16 +0000

Janusz, thank you for the reply. I have used the Item Import to get the parts from my csv inventory list, however I don't see any way to get the inventory quantity into FrontAccounting. Is there any way to do this or does it require a manual Inventory adjustment for each item.