BenFremer Posted October 12, 2005 Share Posted October 12, 2005 Does anybody have any recommendations for importing an existing catalog of over 20,000 items into an OSCommerce store? The database to be imported is currently an access database. The excel upload contribution to upload a .csv file to add to the catalog hasn't gone especially smoothly yet. Does anybody have any recommendations for what can be done to import this huge database? Thanks, Ben Link to comment Share on other sites More sharing options...
Wendy James Posted October 12, 2005 Share Posted October 12, 2005 Have you tried Easy Populate? http://www.oscommerce.com/community/contributions,500 Works well with large amounts of data. Wendy James Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep. Link to comment Share on other sites More sharing options...
BenFremer Posted October 12, 2005 Author Share Posted October 12, 2005 Thank you for that. It looks like Easy Populate will work better (it is at least in English instead of German), but when I try to upload a file, I get this error: Warning: move_uploaded_file(/home/fpwebsit/public_html/osCommerce/catalog//catalog/temp/EP2005Oct12-0909NEW.txt): failed to open stream: No such file or directory in /home/fpwebsit/public_html/osCommerce/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/var/tmp/phpQuRPpy' to '/home/fpwebsit/public_html/osCommerce/catalog//catalog/temp/EP2005Oct12-0909NEW.txt' in /home/fpwebsit/public_html/osCommerce/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /var/tmp/phpQuRPpy User filename: EP2005Oct12-0909NEW.txt Size: 2786 Warning: file(/home/fpwebsit/public_html/osCommerce/catalog//catalog/temp/EP2005Oct12-0909NEW.txt): failed to open stream: No such file or directory in /home/fpwebsit/public_html/osCommerce/catalog/admin/easypopulate.php on line 666 Warning: Invalid argument supplied for foreach() in /home/fpwebsit/public_html/osCommerce/catalog/admin/easypopulate.php on line 689 Do you have any idea what this means, or does anyone know of any other options? Thanks, Ben Link to comment Share on other sites More sharing options...
shunned_one Posted October 12, 2005 Share Posted October 12, 2005 Thank you for that. It looks like Easy Populate will work better (it is at least in English instead of German), but when I try to upload a file, I get this error:Warning: move_uploaded_file(/home/fpwebsit/public_html/osCommerce/catalog//catalog/temp/EP2005Oct12-0909NEW.txt): failed to open stream: No such file or directory in /home/fpwebsit/public_html/osCommerce/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/var/tmp/phpQuRPpy' to '/home/fpwebsit/public_html/osCommerce/catalog//catalog/temp/EP2005Oct12-0909NEW.txt' in /home/fpwebsit/public_html/osCommerce/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /var/tmp/phpQuRPpy User filename: EP2005Oct12-0909NEW.txt Size: 2786 Warning: file(/home/fpwebsit/public_html/osCommerce/catalog//catalog/temp/EP2005Oct12-0909NEW.txt): failed to open stream: No such file or directory in /home/fpwebsit/public_html/osCommerce/catalog/admin/easypopulate.php on line 666 Warning: Invalid argument supplied for foreach() in /home/fpwebsit/public_html/osCommerce/catalog/admin/easypopulate.php on line 689 Do you have any idea what this means, or does anyone know of any other options? Thanks, Ben Ben, Check the permissions and ownership of the temp directory used to store the files. If your web server does not have read and write access to the directory and its contents this is the error which will occur. If the directory does not exist, create it. If it does, make sure AT LEAST group read/write access is set. Your server may require more - ease the restrictions on access until the error goes away. David Link to comment Share on other sites More sharing options...
Guest Posted October 12, 2005 Share Posted October 12, 2005 read thru the contribution support for easypopulate and post all questions/comments there. this is most likely a setting wrong in your admin configure.php and the temp directory Link to comment Share on other sites More sharing options...
BenFremer Posted October 12, 2005 Author Share Posted October 12, 2005 read thru the contribution support for easypopulate and post all questions/comments there. this is most likely a setting wrong in your admin configure.php and the temp directory Thanks! I'll give that a try and keep working on it. Thanks everybody, Ben Link to comment Share on other sites More sharing options...
BenFremer Posted October 13, 2005 Author Share Posted October 13, 2005 I can't find a place to post my Easy Populate questions at the Easy Populate. You were correct about the temp directory. I have fixed it to remove the error message. I now get the message: File uploaded. Temporary filename: /var/tmp/phpQuRPpy User filename: sample_output_file.txt Size: 80290 But--the catalog isn't changed at all after I upload the sample output file. Can please direct me where to go again if I missed it? Thanks, Ben Link to comment Share on other sites More sharing options...
Guest Posted October 13, 2005 Share Posted October 13, 2005 go here: http://www.oscommerce.com/forums/index.php?sho...80entry720219 and then click on reply, that is how the questions get added in the contribution support threads. Link to comment Share on other sites More sharing options...
BenFremer Posted October 13, 2005 Author Share Posted October 13, 2005 ('DIR_FS_DOCUMENT_ROOT', '/home/fpwebsit/public_html/finishlinedemo/catalog/'); // where the pages are located on the server Perhaps having the whole "/home/fpwebsit/etc..." is what is needed? It is oddly also downloading what should be as a tab delimited file with semicolons, and replacing r's, n's, and s's with space characters. I'm hoping to become an expert in this someday. Until then, I pray for advice. Thanks, Ben Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.