I have a list of my products and prices in a MS excel table. Is it possible to import it in Librepos or Posper db and not re encode everything manually in the stock ? If necessary I can change everything you want in that excel table to be compatible...(fields structure)
Well the first question is what kind of information is in the excel tables? For POSper a category and tax is required for each product along with things like a reference no., name, sell price, and maybe some other stuff.
Once you know what the actual data will look like in the DB (and don't want to do it manually) than you'll need to generate some SQL import statements for whatever DB you're using. I don't know if excel has anything built in but my approach would be to export to a csv than write a little script that generates the insert statements based on the contents of that csv.
That's what I mean : it's very easy to give the good structure to the excel table but my only problem is the script and statements...
The exact insert statements depend on the exact DB you're using but regardless of the DB they're fairly well documented. As for the script you'll have to take care of that yourself, we can't really write custom scripts for everybodys preexisting sets of data.
If you are using the default HSQLDB database then you should find enough to get started from here:
Look at Section 8
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.