FrontAccounting forum — Sample CSV/Excel file for Items import

Re: Sample CSV/Excel file for Items import

null@example.com (apmuthu) — Fri, 03 Oct 2014 08:55:39 +0000

When you exported the csv file you had some earlier entry - delete it in the csv and populate the csv with other items that have not been entered as yet and then import it.

Re: Sample CSV/Excel file for Items import

null@example.com (ali002) — Thu, 02 Oct 2014 18:07:48 +0000

Dear All,

When i import the csv file, the fa complain like this:
"Line 2: Update
The entered information is a duplicate. Please go back and enter different values."
What it mean ?

Re: Sample CSV/Excel file for Items import

null@example.com (apmuthu) — Thu, 05 Sep 2013 09:39:36 +0000

1. Manually enter one item directly from the FA GUI
2. From the Import Items Extension, choose to export the Items
3. Prepare the rest of your Items as per the exported file
4. Now import this prepared file into FA from within the Import Items Extension

Re: Sample CSV/Excel file for Items import

null@example.com (sayemfx) — Thu, 05 Sep 2013 08:33:51 +0000

Yes I am referring to Import Items Extension by Tom Moulton. I have read the documentation but not understanding the format of how to prepare my csv file with my above mentioned requirements.

Thank you very much.

Re: Sample CSV/Excel file for Items import

null@example.com (apmuthu) — Tue, 03 Sep 2013 22:39:09 +0000

I trust you are referring to the Import Multiple Journal Entries v2.3 extension by Tom Hallman.

Documentation is available here.

If you are referring to Import Items Extension by Tom Moulton (wrongly stated as Tom Hallman in the config file), then the documentation is available here

Sample CSV/Excel file for Items import

null@example.com (sayemfx) — Tue, 03 Sep 2013 01:01:40 +0000

Hello,

I have installed and activated "Inventory Items CSV Import" extension by Tom Hallman. Can anyone kindly provide a sample CSV/Excel file that I can use to import the items? I am confused about how to make the CSV/Excel file. For example, I have a following sample items to import:

Item Code: 1007
Name: Keyboard
Description: Sample Description
Category: Components
Item Type: Purchased
Supplier: AR Bhai
Quantity: 50
Re-order Level: 10
Purchase Price: 500
Sales Price Wholesale: 550
Sales Price Retail: 600

Thank you very much.