webERP Forum
Import Stock Items from .csv ( Z_ImportStocks.php) - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: How To ? (/forumdisplay.php?fid=6)
+--- Thread: Import Stock Items from .csv ( Z_ImportStocks.php) (/showthread.php?tid=429)

Pages: 1 2


Import Stock Items from .csv ( Z_ImportStocks.php) - willsonyu - 11-25-2012 07:22 PM

HI,
Does the Utilities Import Stock Items from .csv ( Z_ImportStocks.php) works or not? I have try many time and still cannot import any item.
Therefore, I am appreciated if anyone have an example *.csv that works so I can follow. Thanks.


RE: Import Stock Items from .csv ( Z_ImportStocks.php) - tim_schofield - 11-25-2012 09:11 PM

(11-25-2012 07:22 PM)willsonyu Wrote:  HI,
Does the Utilities Import Stock Items from .csv ( Z_ImportStocks.php) works or not? I have try many time and still cannot import any item.
Therefore, I am appreciated if anyone have an example *.csv that works so I can follow. Thanks.

It appears that bugs have been introduced into this script. I am attaching the correct version of Z_ImportStocks.php. It seems that I cannot attach a csv file (for some reason that file type is blocked??) but I can send by email if you want.

Thanks
Tim


RE: Import Stock Items from .csv ( Z_ImportStocks.php) - tim_schofield - 11-26-2012 12:38 AM

I should mention as well, that Excel saves its csv files with an incorrect mime type (or at least it used to last time I checked) so beware of this issue.

Thanks
Tim


RE: Import Stock Items from .csv ( Z_ImportStocks.php) - opto - 11-26-2012 12:41 AM

Hi Tim,

for testing, this might be of general interest.
Can you attach with some other extension (like **renaeme_to_csv.php)?

It would help to see the format and test - we will do that sometime soon, as well.

Thanks,

Klaus

(11-25-2012 09:11 PM)tim_schofield Wrote:  
(11-25-2012 07:22 PM)willsonyu Wrote:  HI,
Does the Utilities Import Stock Items from .csv ( Z_ImportStocks.php) works or not? I have try many time and still cannot import any item.
Therefore, I am appreciated if anyone have an example *.csv that works so I can follow. Thanks.

It appears that bugs have been introduced into this script. I am attaching the correct version of Z_ImportStocks.php. It seems that I cannot attach a csv file (for some reason that file type is blocked??) but I can send by email if you want.

Thanks
Tim



RE: Import Stock Items from .csv ( Z_ImportStocks.php) - tim_schofield - 11-26-2012 01:04 AM

Hi Klaus, still get this:

"Please correct the following errors before continuing:
The type of file that you attached is not allowed. Please remove the attachment or choose a different type."

I have your email address so will send it to you by email.

Thanks
Tim


RE: Import Stock Items from .csv ( Z_ImportStocks.php) - opto - 11-26-2012 01:52 AM

Interesting. So the forum does not look at the extension but at the file contents.

I appreciate your pm.

Klaus


RE: Import Stock Items from .csv ( Z_ImportStocks.php) - phil - 11-26-2012 12:10 PM

I've added this extension to the configuration so it should accept csv type and interpret at text/plain mime type.


RE: Import Stock Items from .csv ( Z_ImportStocks.php) - willsonyu - 11-29-2012 01:53 PM

Hi Tim,

Phil added an extension so it should accept csv type file. Can you please upload again a sample .csv file that I can follow your example.

Thank you,
Willson


RE: Import Stock Items from .csv ( Z_ImportStocks.php) - tim_schofield - 11-29-2012 03:25 PM

(11-29-2012 01:53 PM)willsonyu Wrote:  Hi Tim,

Phil added an extension so it should accept csv type file. Can you please upload again a sample .csv file that I can follow your example.

Thank you,
Willson

Please find attached


RE: Import Stock Items from .csv ( Z_ImportStocks.php) - willsonyu - 11-29-2012 03:30 PM

(11-29-2012 03:25 PM)tim_schofield Wrote:  
(11-29-2012 01:53 PM)willsonyu Wrote:  Hi Tim,

Phil added an extension so it should accept csv type file. Can you please upload again a sample .csv file that I can follow your example.

Thank you,
Willson

Please find attached

Thank you very much.
Willson