• From: Bahrain, Manama
  • Registered: 09/19/2011
  • Posts: 29

Topic: import csv

i have been trying to import csv after reading the readme.txt with no success ( i try exporting the data  and importing it back it dosent accept the fields )

can any one give me a sample line of the item import and sales order



thanks alot

  • Registered: 04/08/2012
  • Posts: 5

Re: import csv

I do not mean to be brash but...1 year later and no response to the question.
I believe that frontaccounting may be the best thing on the market but it is not user friendly. the instructions for importing inventory is about as clear as mud. I my old program I have a spreadsheet that has...Item number, supplier id, category, description quantity, cost, price...everything you would need to create a purchase order and or an invoice. I see no clear way of adding inventory. The items screen does not allow for supplier, cost, price, quantity...
I just added a product and then tried to create an invoice. what is up with the price after taxes?.. I have to do the calculation?
I would love to have a chat with some one who actually uses this program.
email me whtemple1959@gmail.com

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: import csv

Have you tried the wiki?

Bulk export / import can be done at the db table level if you know what you are doing.
1. Take an sql snapshot from phpmyadmin
2. Add an item in FA
3. Take another sql snapshot from phpmyadmin
4. Compare the 2 sql snapshots for diff table records
5. Map your inventory entries based on the diff table record set obtained above into a CSV file
6. Import teh CSV into the table(s)

apmuthu's Website