Thank you for your response.
I am looking for a more affordable alternative to QB.
However, I have already invested more time than I have available in FA.
Maybe later, but right now, I have to focus on my own biz rather than invest in diagnostics.
1 02/01/2026 09:38:56 pm
Re: Import CSV Items (9 replies, posted in Items and Inventory)
2 02/01/2026 08:17:04 pm
Re: Import CSV Items (9 replies, posted in Items and Inventory)
Trafficpest, than you for the time you have invested troubleshooting my issue.
Unfortunately, I am still not experiencing any joy, though I have experienced different results.
Givens:
version: FrontAccounting 2.4.19
extension: Inventory Items CSV Import 2.4.0-3
phpMyAdmin: 5.2.2
1. Using Inventory Items CSV Import module
I have had no further success copying and pasting your Example Data Row.
Exporting I continue to get HTML-like code and can find little of use even when opening in Notepad first.
2. phpMyAdmin
I have managed to export from "0_item_codes" as CSV which makes some sense, but doesn't match the formatting of your example. I have modified and used this to import (1) item into the SQL database, but it never shows up in the GUI for FA > Items.
While I have some programming experience (though quite out-of-date) and I don't consider myself IT naive,
I am trying to run a manufacturing business and have little time to spend this kind of technical troubleshooting trying to set up an accounting package.
I might be open to making one more attempt, but I am ready to move on.
Again, thank you for your time and effort.
3 02/01/2026 02:29:17 pm
Re: Import CSV Items (9 replies, posted in Items and Inventory)
Thank you for your thoughtful and detailed response.
I will study this and get back to you about my results.
I will also investigate your suggestion about myphpadmin
4 01/30/2026 04:19:53 pm
Re: Import CSV Items (9 replies, posted in Items and Inventory)
My education lacks any SQL training, so I have been trying to avoid it.
Based on previous learning experience, importing CSV files should be a simple matter of determining the appropriate format, formatting data and importing. No fuss, no muss.
This has not been the case with FA. Not certain why it needs be so complicated.
5 01/29/2026 12:40:20 pm
Re: Import CSV Items (9 replies, posted in Items and Inventory)
I have created an example item in FA and attempted to export CSV file of items, but exported file is anything but CSV.
I would love to use this accounting package but the without functional import / export I will need to find another solution.
and
6 01/04/2026 11:33:50 pm
Topic: Import CSV Items (9 replies, posted in Items and Inventory)
I have successfully installed/enabled Import CSV extension, access rights, etc.
However, I have been unsuccessful in regards to importing my CSV file.
I have scoured various and many threads, many have been helpful, but still no joy.
While I have a tech background, I have no knowledge of SQL.
The present "header" I am using with my file is as follows:
ITEM;ITEMCODE;STOCK_ID;Description;Category;units;;MB_FLAG;Currency;Price;
I am sorry if this has been addressed elsewhere, but I have tried but not found a solution.
Any assistance would be appreciated.