I happened to check forum today after many days.
I have loaded the module in my local instance.
Will be using it. A quick review gave me good feel.

I don't know wheather I should be discussing following part here -
Could you please help to remove an issue in reporting module ?
Issue is - When we take Excel report. In OOCalc (May be Ms Excel too) report files show up without borders but in preview and print, borders are visible. So reports are not printed properly. If you can give it a look, it would be nice.

Thanks

Thanks you very much ! Have you had a chance to use it ? Unfortunately I haven't had the time to write any other modules. Just some custom modifications for my own uses, but nothing major.

/Elax

I checked the module and amazed by it's implementation.
Hats off to you !

I am wondering with you such great programming skills, have you developed other modules to make FA more productive ? Something like serialized inventory, POS etc.

Thanks

Hi elax,

I have recently created a module that can import CSV to sales order form.
It will not directly post the sales order, rather it will import items through CSV and show a pre-filled Sales Order form.
Which you may check, select customer and set other details properly before confirming the order.

Since I am away, I will be posting this module to FA admins for review soon.

It has a TODO : Check item is salable
Also this feature needs to have a 2 lines added in FA core file - sales_order_entry.php

Thanks

Hi
I've done my own module which allow you to copy/paste orders to/from Excel (or any text editor) and much much more (https://frontaccounting.com/punbb/viewtopic.php?id=2793)
Let me know if you are interested.

/Elax

I have recently created a module that can import CSV to sales order form.
It will not directly post the sales order, rather it will import items through CSV and show a pre-filled Sales Order form.
Which you may check, select customer and set other details properly before confirming the order.

Since I am away, I will be posting this module to FA admins for review soon.

It has a TODO : Check item is salable
Also this feature needs to have a 2 lines added in FA core file - sales_order_entry.php

Thanks

Really excentric approach .
Keep in mind FA make lots of checks before the data for any entered document are stored in database. The more FA code you ommit the more chances to break your ledger.

Janusz

You are right, this is why I want to integrate it in FA (so I can use all the FA code) rather than doing SQL (even though It work pretty well). I've started doing something and It's quite promising, I'll keep you in touch when it's finished.

/Elax

Janusz

So I had this idea, rather than generating a SQL file that then I have to upload, I can add a "free text" popup in the actual GUI where I could copy/paste my order text file (in my format) and convert it (using PHP or JS) to a cart. I've been looking a bit how it work and it's seems possible to add a import/export to text function to the cart(s) which should then "modify" properly. (I understood that the cart is saved in the session, therefore it should be possible to "build" it from a text).
I'm a wright ? Does it seems to be a good approach or could you suggest me something else ?

/Elax

/Joe

/Joe

Thanks
Elax

I created a (ruby) script which parses a csv file (+ some extra command) and  generate a sql file filling the sales_order_details table.
The sql file lookup at the price and description in the database if need

The csv+ file looks like :

:order, 36             #set the current order id
sku1                    # add item "sku1" to order#36
sku2 | desc         # add item "sku2" and set the description to desc
sku3, 20  , 14.5  # qty = 20 price = 14.5

:order, 37          #order 37 now
:clear             #clear the order 37 (except details with sent qty)
sku1
sku2

etc ...

That seems to work pretty well. I can now write all of my orders in one file using vim , duplicate bits if needed, copy paste from excel or email etc ...
However I have to create the "empty" order manually first as my script only deal with the sales_order_details.

I also written a sql query wich 'prepopulate' a such file making easier to find  which order id correspond to which order and what is missing in it.

This solution is still a bit tedious as it involve some file manipulations  and the use of phpmyadmin to run the query, but if you have to convert a excel spreadsheet with 200 items to an FA order that really worth it.

If anyboby is interested by this I could provide the script ( It still not fully tested yet though)

Elax

/Joe