Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Import Stock Items from .csv ( Z_ImportStocks.php)
11-25-2012, 07:22 PM
Post: #1
Import Stock Items from .csv ( Z_ImportStocks.php)
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.
Find all posts by this user
Quote this message in a reply
11-25-2012, 09:11 PM (This post was last modified: 04-07-2013 09:24 AM by phil.)
Post: #2
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
(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
Find all posts by this user
Quote this message in a reply
11-26-2012, 12:38 AM (This post was last modified: 04-07-2013 09:24 AM by phil.)
Post: #3
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
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
Find all posts by this user
Quote this message in a reply
11-26-2012, 12:41 AM (This post was last modified: 11-26-2012 12:42 AM by opto.)
Post: #4
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
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
Find all posts by this user
Quote this message in a reply
11-26-2012, 01:04 AM (This post was last modified: 04-07-2013 09:25 AM by phil.)
Post: #5
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
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
Find all posts by this user
Quote this message in a reply
11-26-2012, 01:52 AM
Post: #6
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
Interesting. So the forum does not look at the extension but at the file contents.

I appreciate your pm.

Klaus
Find all posts by this user
Quote this message in a reply
11-26-2012, 12:10 PM
Post: #7
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
I've added this extension to the configuration so it should accept csv type and interpret at text/plain mime type.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
11-29-2012, 01:53 PM
Post: #8
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
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
Find all posts by this user
Quote this message in a reply
11-29-2012, 03:25 PM (This post was last modified: 04-07-2013 09:25 AM by phil.)
Post: #9
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
(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


Attached File(s)
.csv  test.csv (Size: 345 bytes / Downloads: 56)
Find all posts by this user
Quote this message in a reply
11-29-2012, 03:30 PM
Post: #10
RE: Import Stock Items from .csv ( Z_ImportStocks.php)
(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
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)