Daddyslipdisk Posted July 27, 2005 Share Posted July 27, 2005 I tried using easy populate, but I'm completely frustrated. I've played with it for hours and get all kinds of errors during import. The last time I tried using easypopulate I downloaded the file so I could see how everything was laid out, then I even copied and pasted the info from my file into the appropriate columns and then when I try and upload it, I get the following errors; Warning: move_uploaded_file(/home/globeche/public_html/catalog//catalog/temp/downloaded-filledin-test.txt): failed to open stream: No such file or directory in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/tmp/phpybqBQw' to '/home/globeche/public_html/catalog//catalog/temp/downloaded-filledin-test.txt' in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpybqBQw User filename: downloaded-filledin-test.txt Size: 1385910 Warning: file(/home/globeche/public_html/catalog//catalog/temp/downloaded-filledin-test.txt): failed to open stream: No such file or directory in /home/globeche/public_html/catalog/admin/easypopulate.php on line 667 Warning: Invalid argument supplied for foreach() in /home/globeche/public_html/catalog/admin/easypopulate.php on line 690 So at this point, I'm about to switch to another store that gives me some built in importing capabilities because I've been at this for 2 days straight and I'm very frustrated and annoyed. Unless someone has a better solution then what I'm doing, I'm going to find the nearest clocktower because ain't no way in Hades that I plan to enter these 3000+ products one by one into the store. Anyone that wants to see what I've done and what the file looks like that I'm uploading is welcome to it at http://www.globechemicalcompany.com/downlo...lledin-test.txt. ANY help would be greatly appreciated and maybe even compensated. Quote Link to comment Share on other sites More sharing options...
battybaby Posted July 28, 2005 Share Posted July 28, 2005 Warning: move_uploaded_file(/home/globeche/public_html/catalog//catalog/temp/downloaded-filledin-test.txt): failed to open stream: No such file or directory in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 That looks wrong to me. Go back to the easypopulate.php file and fix the path. From memory it's right in the beginning of the file, the default is something like catalog/temp. just change it to temp. Good luck :) Quote Practice safe hex! Link to comment Share on other sites More sharing options...
battybaby Posted July 28, 2005 Share Posted July 28, 2005 One more thing: I had a (very) quick look at your file and it looks ok except for one thing. One of your product descriptions is "3M? Dose ?n Fill". I'm 100% sure that the apostrophe is going to give you grief. I highly recommend that you carefully comb through each item description and make sure any apostrophe has the \ symbol before it. ie: 3M? Dose ?n Fill should be 3M? Dose \?n Fill I know it's frustrating but give EP a chance. It really is a very neat tool, you just have to make sure your file is perfect. And make sure you take a back up of your PHP files AND your database before you attempt to upload your txt file. Trust me on this one! Quote Practice safe hex! Link to comment Share on other sites More sharing options...
Daddyslipdisk Posted July 28, 2005 Author Share Posted July 28, 2005 (edited) That looks wrong to me.? Go back to the easypopulate.php file and fix the path.? From memory it's right in the beginning of the file, the default is something like catalog/temp.? just change it to temp. Good luck :) <{POST_SNAPBACK}> Thanks for this. If your import works, I'll be more than happy to pay for your time. portions edited put it in there for me! Ha ha haha-ha-hm-ok, not kidding. Edited July 29, 2005 by Mibble Quote Link to comment Share on other sites More sharing options...
battybaby Posted July 29, 2005 Share Posted July 29, 2005 (edited) Thanks for this.? If your import works, I'll be more than happy to pay for your time. portions edited Ha ha haha-ha-hm-ok, not kidding. HA! Edited July 29, 2005 by Mibble Quote Practice safe hex! Link to comment Share on other sites More sharing options...
Guest Posted July 29, 2005 Share Posted July 29, 2005 do not change it to just catalog. your problem is in your /catalog/admin/includes/configure.php set docoment_root to $DOCUMENT_ROOT also post your admin/includes/configure.php file without the database connection info. Quote Link to comment Share on other sites More sharing options...
Daddyslipdisk Posted August 2, 2005 Author Share Posted August 2, 2005 (edited) do not change it to just catalog.your problem is in your /catalog/admin/includes/configure.php set docoment_root to $DOCUMENT_ROOT also post your admin/includes/configure.php file without the database connection info. <{POST_SNAPBACK}> I tried both suggestions. Replaced all apostrophes with /' and it didn't like $DOCUMENT_ROOT, so I just left it blank ('') and everything appeared to be accessing the correct location, but it still can't do it. I gave the temp directory a chmod of 777 just to get past this importing error, but now I get the following errors: Warning: move_uploaded_file(/catalog/temp/first300-test2.txt): failed to open stream: No such file or directory in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/tmp/phpoie6Xh' to '/catalog/temp/first300-test2.txt' in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpoie6Xh User filename: first300-test2.txt Size: 129069 Warning: file(/catalog/temp/first300-test2.txt): failed to open stream: No such file or directory in /home/globeche/public_html/catalog/admin/easypopulate.php on line 667 Warning: Invalid argument supplied for foreach() in /home/globeche/public_html/catalog/admin/easypopulate.php on line 690 Someone please help and tell me what I'm suppoed to do at this point. Edited August 2, 2005 by Daddyslipdisk Quote Link to comment Share on other sites More sharing options...
Daddyslipdisk Posted August 2, 2005 Author Share Posted August 2, 2005 (edited) I tried both suggestions. Replaced all apostrophes with /' and it didn't like $DOCUMENT_ROOT, so I just left it blank ('') and everything appeared to be accessing the correct location, but it still can't do it. I gave the temp directory a chmod of 777 just to get past this importing error, but now I get the following errors: Warning: move_uploaded_file(/catalog/temp/first300-test2.txt): failed to open stream: No such file or directory in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/tmp/phpoie6Xh' to '/catalog/temp/first300-test2.txt' in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpoie6Xh User filename: first300-test2.txt Size: 129069 Warning: file(/catalog/temp/first300-test2.txt): failed to open stream: No such file or directory in /home/globeche/public_html/catalog/admin/easypopulate.php on line 667 Warning: Invalid argument supplied for foreach() in /home/globeche/public_html/catalog/admin/easypopulate.php on line 690 Someone please help and tell me what I'm suppoed to do at this point. <{POST_SNAPBACK}> Ok, I've been playign around and I went into easypopulate.php and changed the $tempdir line to the full absolute URL and it actually imported the first product of the 300 products! Just one product, not all 300. So we're getting somewhere, but here's the message I get now: Warning: move_uploaded_file(http://www.globechemicalcompany.com/catalog/temp/first300-test2.txt): failed to open stream: HTTP wrapper does not support writeable connections. in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/tmp/phpY0wxBM' to 'http://www.globechemicalcompany.com/catalog/temp/first300-test2.txt' in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpY0wxBM User filename: first300-test2.txt Size: 122557 | ACE 12408 | BAYER ASPI | Maintenanc | Personal C | First Aid | | 33.58 | SACM4065.J | SACM4065.J | Bayer? Asp | ACME UNITE | 3.00 | ACMEUNIT.J | 50-2PK | | | ACE 1324 | EXTRA STRE | Maintenanc | Personal C | First Aid | | 41.49 | HALM0668.J | HALM0668.J | Excedrin? | ACME UNITE | 0.20 | ACMEUNIT.J | 50-2/PK | | | ACE 1336 | MOTRIN IB | Maintenanc | Personal C | First Aid | | 50.69 | SACM4383.J | SACM4383.J | Motrin? IB | ACME UNITE | 0.30 | ACMEUNIT.J | 50-2/PK | | | ACE 1500 | REFILL-ADV | Maintenanc | Personal C | First Aid | | 47.70 | HACE0564.J | HACE0564.J | Advil? Tab | ACME UNITE | 1.00 | ACMEUNIT.J | 50-2/PK | | | ACE 1901 | "SCISSORS- | Maintenanc | Facility M | Scissors | | 6.90 | XACM1260.J | XACM1260.J | Kleencut? | ACME UNITE | 1.00 | ACMEUNIT.J | 12/EA | | | ACE 2500 | FIRST AID | Maintenanc | Personal C | First Aid | | 37.58 | NOA.JPG | NOA.JPG | "Weatherpr | ACME UNITE | 1.60 | ACMEUNIT.J | 1/EA | | | ACE 4000 | "FIRST AID | Maintenanc | Personal C | First Aid | | 30.84 | ACM01500.J | ACM01500.J | First Aid | ACME UNITE | 1.20 | ACMEUNIT.J | 1/EA | | | ACE 4090 | TYLENOL-X- | Maintenanc | Personal C | First Aid | | 44.75 | SACM4386.J | SACM4386.J | Of course, there's a bunch more products listed here, but then it keeps going and ends with "Updated" Ok, now what. Edited August 2, 2005 by Daddyslipdisk Quote Link to comment Share on other sites More sharing options...
Daddyslipdisk Posted August 2, 2005 Author Share Posted August 2, 2005 Alright. Well, while waiting for a reply I have managed to have it import with no errors whatsoever. I had to add /home/globeche/public_html to the front of the $TEMPDIR lines of easypopulate.php. BUT now the only issue is that when I go into the store, it only shows the very first product of the import and none of the others below it. There are no delimiters or wierd characters that I can see that are causing problems. There's a "registered trademark" logo, the r with the circle around it, but the fields beyond that imported fine, so obviously it didn't care about that. What could it be? Ok, I've been playing around and I went into easypopulate.php and changed the $tempdir line to the full absolute URL and it actually imported the first product of the 300 products! Just one product, not all 300. So we're getting somewhere, but here's the message I get now: Warning: move_uploaded_file(http://www.globechemicalcompany.com/catalog/temp/first300-test2.txt): failed to open stream: HTTP wrapper does not support writeable connections. in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/tmp/phpY0wxBM' to 'http://www.globechemicalcompany.com/catalog/temp/first300-test2.txt' in /home/globeche/public_html/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpY0wxBM User filename: first300-test2.txt Size: 122557 | ACE 12408 | BAYER ASPI | Maintenanc | Personal C | First Aid | | 33.58 | SACM4065.J | SACM4065.J | Bayer? Asp | ACME UNITE | 3.00 | ACMEUNIT.J | 50-2PK | | | ACE 1324 | EXTRA STRE | Maintenanc | Personal C | First Aid | | 41.49 | HALM0668.J | HALM0668.J | Excedrin? | ACME UNITE | 0.20 | ACMEUNIT.J | 50-2/PK | | | ACE 1336 | MOTRIN IB | Maintenanc | Personal C | First Aid | | 50.69 | SACM4383.J | SACM4383.J | Motrin? IB | ACME UNITE | 0.30 | ACMEUNIT.J | 50-2/PK | | | ACE 1500 | REFILL-ADV | Maintenanc | Personal C | First Aid | | 47.70 | HACE0564.J | HACE0564.J | Advil? Tab | ACME UNITE | 1.00 | ACMEUNIT.J | 50-2/PK | | | ACE 1901 | "SCISSORS- | Maintenanc | Facility M | Scissors | | 6.90 | XACM1260.J | XACM1260.J | Kleencut? | ACME UNITE | 1.00 | ACMEUNIT.J | 12/EA | | | ACE 2500 | FIRST AID | Maintenanc | Personal C | First Aid | | 37.58 | NOA.JPG | NOA.JPG | "Weatherpr | ACME UNITE | 1.60 | ACMEUNIT.J | 1/EA | | | ACE 4000 | "FIRST AID | Maintenanc | Personal C | First Aid | | 30.84 | ACM01500.J | ACM01500.J | First Aid | ACME UNITE | 1.20 | ACMEUNIT.J | 1/EA | | | ACE 4090 | TYLENOL-X- | Maintenanc | Personal C | First Aid | | 44.75 | SACM4386.J | SACM4386.J | Of course, there's a bunch more products listed here, but then it keeps going and ends with "Updated" Ok, now what. <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
lee246 Posted August 2, 2005 Share Posted August 2, 2005 Not sure if this will be of help but a similar question was asked in the official easypopulate thread. Check it out and see if it helps. Link To Thread. Quote Link to comment Share on other sites More sharing options...
Daddyslipdisk Posted August 2, 2005 Author Share Posted August 2, 2005 No, I saw that. That's set correctly. hence why the first product installed perfectly, but something is going wrong after that first row and then it disregards everything else. Argh!!! Not sure if this will be of help but a similar question was asked in the official easypopulate thread. Check it out and see if it helps.Link To Thread. <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
lee246 Posted August 3, 2005 Share Posted August 3, 2005 Another problem I had when uploading my shop was that EP didn't recognise or allow ', so I opened my product sheet with notepad, and did a find and replace, I replaced all ' with nothing, and then reuploaded it into EP. This solved it for me. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.