EasyPopulate

[red_fraggle]

Bout to pull my hair out here. The docs on easypopulate are vague to me at best. I need to know if easypopulate autocreates attributes from data put in the attribute columns in the imported tab delimeted text file im creating for our products. Or do i create the attributes in admin and then use those attributes in the columns im importing?

What would be nice is if i could look at a few sample lines of someones product flat file to see how mutiple colors and sizes are generated in attributes on import.............




Cliff....

I notice that if you go into phpmyadmin and then go to EXPORT that you can export data as a CSV file formatted for excel - wouldnt that be easier.

Just tried it - works great - put the table names at the head of the columns also - it generates nice lists, - all you need is phpmyadmin

[gheffron]

PhpMyAdmin works like a charm, but is a more complicated process -- what with having your data spead across multiple documents (in Excel first, then saved to CSV). I wish I could get Easy Populate to work so I can easily edit the whole database quickly, but it keeps giving me the following error messages when I try to upload:

Warning: Unable to create '/usr/local/apache/htdocs/oscom//catalog/temp/EP2004Mar11-new.txt': No such file or directory in /usr/local/apache/htdocs/oscom/admin/easypopulate_functions.php on line 32

Warning: Unable to move '/tmp/phpY5vVHa' to '/usr/local/apache/htdocs/oscom//catalog/temp/EP2004Mar11-new.txt' in /usr/local/apache/htdocs/oscom/admin/easypopulate_functions.php on line 32

File uploaded.
Temporary filename: /tmp/phpY5vVHa
User filename: EP2004Mar11-new.txt
Size: 263470
Warning: file("/usr/local/apache/htdocs/oscom//catalog/temp/EP2004Mar11-new.txt") - No such file or directory in /usr/local/apache/htdocs/oscom/admin/easypopulate.php on line 651

Warning: Invalid argument supplied for foreach() in /usr/local/apache/htdocs/oscom/admin/easypopulate.php on line 674

There was another user who asked this question, but he solved it randomly and couldn't figure out how he did it. Anyone have any insights?

Cheers,
Greg

P.S. By the way, line 674 in my easypopulate.php file is:

foreach ($readed as $read){
$newreaded .= $read;
}

line 651 is:
$readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name);

}

[gheffron]

I should have read the easypopulate readme file more carefully!

Because I don't have a "/catalog/temp/" directory, I had to go through easypopulate.php and change all mentions to "/temp/" (which is a directory I do have). Worked beautifully! I uploaded 400 products in no time at all. Woo hoo!

Last question: is it secure for me to have my catalog in my main OSCommerce directory? Should I do anything with permissions to make it more secure?

[gheffron]

Note: Easypopulate rocks now. I can download the database, change large numbers of entries, and reupload in minutes. Truly the way to go...