Chadderuski,What you should try to do is use the "Create Complete tab-delimited .txt file in temp dir (Attributes Not Included)" Link.
This will put your data file in the temp directory that you can then use your ftp program to download.
Same goes for uploading to temp directory for import.
Thanx for the reply, however, I have tried to to do the files to the temp directory and it still does the 500 internal server error. When I only had 1500 item it worked fine, but when I got to 2500+ then it times out. Does not matter weather I download or put in temp directory.
Per your download problem, have you looked at your php.ini file? There are some variables in there that you can customize to give yourself more memory and processor time.
What do you mean? Can you explain what I would want to do.
Thanx
Hi friends,
I'm using ZC 1.38. I installed easy populate from Langer, it installed fine and could download the datbase correctly, but when I tried to upload I would get a 500 error, so now I installed, Easy Populate CSV, the latest updated in Jan 2009, which is working fine.
I need help on 2 issues which would make things easier for me.Thanks for your help.
- Download and upload the database using a semicolon";" instead of a comma "," separating the columns. in Spain we use the comma to separate the decimals in the prices, eg. (€11,50) so when I open the database it gives me the price in 2 separate columns, and also the description field commas create problems.
- I use wholesale and retail prices and have the dual price module installed, when I downloaded the database with the langer module there was a column for the wholesale prices v_price_w , but this new version does not include it, how can I add this field to may downloads.
After reading, I am still not clear on how to not over write long product descriptions when using easy populate. I am open to using Open Office for uploading long descriptions.
I had a programming friend change a core file to protect my product descriptions temporarily but I know that is not the way to go.
Should I delete the description column in EP when uploading a global price update, will that protect my data?
Would apreaciate any help.
Johnny
Open your php.ini file and look for this section. You can usually bump these up, but many hosts will over ride your values if you go too high:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_execution_time = 90 ; Maximum execution time of each script, in seconds
max_input_time = 90 ; Maximum amount of time each script may spend parsing request data
memory_limit = 64M ; Maximum amount of memory a script may consume (10MB)
If this doesn't help, then something on the hosting side is really restricting your scripts. In shared hosting environments you are really at the mercy of the hosting provider's imposed restrictions, and the other 100's (if not 1000's !?!?!?!) of sites you are sharing your box with.
It may be time to change providers or to consider a VPS... wiredtree and knownhost both have good affordable packages (about 40/month) and superior tech support.
Hope this helps.
Oh, just a note: Once you upload your php.ini file, run a script with phpinfo() in it to make sure it accepted the changes. Some hosts cache the php.ini file and it can take "time" to update your changes.
Good Luck!
-cj
HELP PLEASE!!
I am using:
Zen Cart ver 1.3.7.1
Easy Populate ver 1.2.5.4
When I UPload EP File all my existing product records are updated just fine. Any new product records are skipped (not added to the dbase) with this message:
Model BF3 SM-No catagory provided for this new product.
The catagory structure is Shaker Maple>Base>Specialty
HOWEVER- if I add the product id:
BF3 SM to Catalog>Catagories/Products and then run Upload EP File again with the same file BF3 SM is updated correctly, but all the other new products are still skipped with the above message.
Can anybody shed any light on this?
DAFI
Model BF3 SM-No catagory provided for this new product.
Do you have the category name in your EP file that this product is going to? That is what the error is telling you - no category for the product was listed.
Yes I have the catagory name. I have several products in the catagory.
I have since taken a download file and can change the name of the v_product_model of an existing product to the name BF3 SM and upload it. The product is then added to the database. I can find no difference in the Catagory names from this file and the one I am creating. Any ideas?
Yes! I found the error.
My Bad.
I suspect I typoed in the column headings (ie v_products_model etc) but never could find it. In the end I copied the headings that were exported by EP and pasted them into my data.
The resulting file worked perfectly.
Darrel
i POSTED THIS FOR HELP ON THE 29TH MARCH BUT NO HELP YET, MAYBE IT WAS MISSED .
Hi friends,
I need help on 2 issues which would make things easier for me.Thanks for your help.
- Download and upload the database using a semicolon";" instead of a comma "," separating the columns. in Spain we use the comma to separate the decimals in the prices, eg. (€11,50) so when I open the database it gives me the price in 2 separate columns, and also the description field commas create problems.
- I use wholesale and retail prices and have the dual price module installed, when I downloaded the database with the langer module there was a column for the wholesale prices v_price_w , but this new version does not include it, how can I add this field to may downloads.
Bookmarks