winterion

I'm having the same issue. I can't figure out what I'm doing, it's quite frustrating, really. My understanding was that Linkpoint/YourPay Connect was supposed to handle the storage/usage of credit card info so that my site didn't have to. If that's the case, why do you need SSL in the first place, if the only info being transferred to them is (item numbers, item descriptions, costs, subtotal, tax, shipping, grand total)? Or, is there something I'm missing? I've been trying to figure this out for weeks. The phone support for YourPay won't help.. they basically say it's my responsibility to figure out how to send them the necessary data, but I really don't know how. This is my first time setting up any sort of e-commerce solution, and it's been six months of hell, from struggling to get EasyPopulate to work with our massive database of items to editing the css and php files to make the site look semi-respectable and less cookie cutter. Still, this shopping cart part is the ultimate stumper, and I'm in way over my head. Has anyone successfully set up Linkpoint / YourPay, and if you have, what steps did you take? (I'm woefully in the dark about all this.)

Oh, I'm really sorry, big gaffe on my part. :-" Umm, the 18,000 or so takes somewhere around 15 minutes? Maybe less.. I could time it exactly. I'm totally new to EP, so I'm not exactly familiar how the 'split' function works. I can try and look it up, try to learn, won't beg you guys to hold my hand through that. Should it be expected that a 50,000 line .csv file would have to use the split function? As for the same one each time? No, it doesn't.. different line each time. So I don't think the stop is related to the .csv file itself, like, a bad line in it. Edit: Okay, my idiocy knows no bounds. The split thing was really easy. But, those five files it created (since my split was at 10k items).. any way to command EP to import those one at a time, all five, or do I have to keep coming back to the PC to do them one at a time? (Sort of a queue thing..)

The problem we have with splitting the import file is logistical.. I have found by splitting it into 10 files, 5000 or so each, we can reliably upload the whole thing. But, that means, every half-hour I need whoever is working the store to perform the next step. The hope was that whoever is working, once a week, can simply start this process up, and that it would go, start to finish, on its own. :blush: Or, is there an automated method in which EP can perform one .csv file in a series of uploads? (would you need Row 1 repeated, say, every 5000 lines? Could do that with an Excel macro, for example.)

My host (Bluehost) permits you to put in your own php.ini file, so I've done so. (I wasn't sure where to put it, so I put a copy in public_html, a copy in my osCommerce root dir, and a copy in the admin directory. They are all identical files.) I've never heard of the set_time_limit variable. I've adjusted the following in php.ini: max_execution_time = 7200 ; Maximum execution time of each script, in seconds (30) max_input_time = 7200 ; Maximum amount of time each script may spend parsing request data (60) memory_limit = 256M ; Maximum amount of memory a script may consume (32MB) And, I've adjusted the following in easypopulate.php: (the server does not run in safe mode) set_time_limit(0); define ('EP_SPLIT_MAX_RECORDS', 10000); I've even edited the function/sessions.php file: $SESS_LIFE = 28800; So, honest to goodness, I'm stumped. Edit: Forgot to add this: EP vers: 2.76f-MS2 r1 Temp Dir: /home/gameparl/public_html/catalog/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 10000 records Model Num Size: 24 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 24 Enable attributes: false SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false

What's the most number of lines anyone's been able to use Easy Populate to import at once? I think my record is about 18,000... which, given that I have a 50,000 line .csv to import, doesn't help. I've been trying to get some community support on that for months to no avail. But, anyway. I'm curious to just -know- if anyone's been able to clear that 50,000 plateau, or something significantly larger?

Okay. I'm sure this is a problem people have encountered before, and I hate to annoy you with things, but I swear that I've gone through the documentation a hundred times, tried all the basic solutions, and still, to no avail. :blush: I have a 50,000 item .csv file I want to upload into my database on a weekly process so that the proper quantities of items display on our site, and new items get added. Now, this .csv file is easily enough created. And, for demonstration purposes, here's an example pair of lines. v_products_model,v_categories_name_1,v_products_name_1,v_products_price,v_produc ts_quantity,EOREOR NOV02 2034,COMIC,Mekanix #4 (of 6),2.99,5,EOREOR So, we've got the model number, the item category, the description (which is a cleverly concat'ed pair of lines in our database), price, quantity, and the end of row thingy. So far, so good, right? Now, add 49998 more lines of the second line, with different stuff in it, obviously. Here's the problem. We can upload it to the temp directory just fine. We can hit the import from temp dir, it starts processing, and in fact, it processes every entry it gets to just fine, accurately filling our SQL database with precious products! Now, the trick is, it stops. It just.. stops. No error message, but somewhere between 12,000 and 18,000-ish items in, (usually somewhere around C to E) it just ends. I'm not sure WHAT it is, but I suspect it's one of the following: -osCommerce admin session timeout -php.ini file settings -easypopulate.php file settings -dark sorcery Now, here's the thing. I've read over all these other posts, I've tried (no exaggeration here) about 100 different settings for the php.ini and easypopulate.php files. I've put copies of php.ini in my public_html, catalog, and admin folders. Anyway, the critical settings I've tried: php.ini max_execution_time = xxxx ; Maximum execution time of each script, in seconds (tried between 30 and 9000) max_input_time = xxxx ; Maximum amount of time each script may spend parsing request data (tried between 30 and 9000) memory_limit = xxxM ; Maximum amount of memory a script may consume (tried between 8M and 512M) easypopulate.php set_time_limit(xxx); have tried this commented and uncommented between 120 and 28800 define ('EP_SPLIT_MAX_RECORDS', xxx); have tried this commented and uncommented between 300 and 70000 $ep_separator = "\t"; now, interestingly, this setting seems to work for the comma-delimited .csv? or does this mean something else... define ('EP_MAX_CATEGORIES', 24); we have about twenty categories, so this was to allow for a bit of expansion, no problems here Now, this is what happens: Easy Populate 2.76f-MS2 r1 - Default Language : english(1) Filename: finalbook.csv | NOV02 2034 | COMIC | Mekanix #4 | 2.99 | 5 Updated | NOV02 2035 | COMIC | Mekanix #5 | 2.99 | 5 Updated etc... now, this list seems to keep building every time I tap the down key or page down or scroll.. while the browser continues to show a loading bar. ..for a few minutes. Eventually, the status bar reads Stopped, and the last line usually looks something like | NOV02 8035 | COMIC | Abbe (where it's just cut off at some random point in the line). Now, I'm so boggled. I can't seem to figure out -what- causes it to stop.. be it a session timeout from osCommerce, or EasyPopulate, or the length of the massive SQL command that a 50,000 item .csv file creates, or what.. but I'm being told from a lot of people that there SHOULD be no problem with this. But, I've been agonizing over this (amongst other problems.. whoever said this was easy is either lucky or a great liar!) for well over three months now. This was a project I started with the hopes of having it ready around Christmas, and now Easter is around the corner. Frankly, I feel sort of inept, so I've been throwing my various problems at the mercy of the community at large (some threads going un-noticed and un-replied, others full of the same suggestions I've seen elsewhere, to no avail.) So, please, all I can do is ask.. help? >_<

I read through the easypopulate.php file but didn't find any variables that would help. Maybe I'm missing something? I also didn't see anything in the osCommerce variables. (I'm possibly blind, but much more likely dumb.) Do I need to make adjustments to php.ini for such a large file, maybe? Timeout extension, larger memory, etc. And, has anyone else tried using EasyPopulate to import such a hefty database? (~50,000 items) What was your experience like?

Hey, everyone. Easy Populate was a very useful program in getting the demonstration version of our osCommerce site up and running. Thank you! But, we've run into a wall. The site ( http://www.gameparlorstore.com/catalog ) has a few items set up for now for demonstration, but we've got a .csv file waiting to upload with a whopping 49,368 lines. Tried, and it grossly violated the 334455352 or whatnot max size (8mb?). The error message mentioned about line 900 or so. Can we really only use .csv files with about a half-thousand lines per .csv file upload? Is there any way we can upload the entire 49,368 line file and import it successfully? As it stands, we only use five fields.. here's an example slice: v_products_model v_categories_name_1 v_products_name_1 v_products_price v_products_quantity FPR 10973 MIN-F AeroTech 2 Record Sheets - Classic Battletech 29.99 3 IWM 20-639 MIN-F KGA 28 Kanga Jump HovTank - Classic Battletech 8.95 2 IWM 20-685 MIN-F Bandit Hovercraft (2) - Classic Battletech 11.95 2 IWM 20-785 MIN-F Demolisher II Tank - Classic Battletech 9.5 2 IWM 20-975 MIN-F Fafnir Mech - Classic Battletech 10.95 1 IWM 20-976 MIN-F Hellion Mech - Classic Battletech 6.5 1 IWM 20-977 MIN-F Cestus Mech - Classic Battletech 9.5 2 KEN 901 ZINE SpaceHack #1 (of 3) - 2.99 3 PIN 1115 RPG The Way of the Brave d20 - Hell on Earth, Deadlands 19.95 13 GOO 13-200 RPG Fast Play Rules - (d20)Silver Age Sentinels 2.95 4 GOO 13-202 RPG Character Record Folio - Silver Age Sentinels 4.95 3 GRR 1102 RPG Wrath & Rage: Guidebook - To Orcs (d20) 16.95 2 JUL02 2227 COMIC 2000 AD #1308 - 3.25 1 AUG02 0265 COMIC Black Sun #2 - 2.95 1 JUL02 0237 COMIC American Century #19 - 2.75 1 AUG02 0290 COMIC The Filth #5 (of 13) - 2.95 1 AUG02 0294 COMIC Midnight Mass #7 (of 8) - 2.5 2 Now, since our online store has to share inventory with our local store, we need to update the online store with our local store's quantities as often as possible. That means frequent database updates.. with the size of the .csv, is that a realistic idea? Also, we get new items in fairly often.. any way for an Easy Populate to tell what item codes are just getting quantity updates and what ones are new lines (that is, "new products" ?)