8920 replies to this topic

[VJ]

Hello,

An updated version of Easypopulate (v2.72) is now available for download, here.

This includes an option to turn off product attribute data when downloading the tab-delimited file.

Support for this new version will continue in this thread.

VJ

[KerryG]

I am ready to pull my hair out. I cannot seem to get easypopulate to work.

If I use the upload function, the only staus returned is this:

File uploaded.
Temporary filename: /localservices/phpupload/phpBMJ4UC
User filename: MinkaLavery.txt
Size: 35247

But no records are added.

I don't see anything wrong with the data or the configuration options (I did set the max categories to 2). My client is all ticked that I havent been able to get his data loaded yet and has a dozen spreadhseets waiting for me. I am really stuck. I can provide a link to the text file or I have pasted in two sample records below. I could really use a hand figuring this one out.

Here is a sample of my data:
v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price Wholesale Cost v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_tax_class_title v_status EOREOR
1687-14 1687.jpg 3 Light ceiling flushmount with Alabaster glass shade <br> Nutmeg metal finish. "Calavera Collection<br>Transitional Design<br>Width: 22.5"" x Height: 12.5""<br>Lamps:3 x 60Watt Medium Base" none $263.89 $203.92 $119.95 0 12/29/2003 22:33 12/29/2003 22:33 0 Mika Lavery CEILING FIXTURES & FLUSHMOUNTS Transitional Taxable Goods Active EOREOR
466-63 466.jpg Single Light ceiling flushmount with etched Marble glass <br>Nouveau Bronze metal finish. "Nouveau Collection<br>Transitional Design<br>Width:11"" x Height:7.375"" <br> Lamps:1 x 60Watt Medium Base." none $36.30 $28.05 $16.50 0 12/29/2003 22:33 12/29/2003 22:33 0 Mika Lavery CEILING FIXTURES & FLUSHMOUNTS Transitional Taxable Goods Active EOREOR

Kerry

[prohostco]

I have it working just fine when I empty the database and upload the .txt file into an emtpy database -

But when I upload into the database with the products already loaded- it has problems like:

1054 - Unknown column 'products_mimage' in 'field list'

It loads the first product, then the above error occurs.

Is anybody else having problems similar to this?
Thanks - Lynn

[Marth]

VJ,
  Thanks for EP - wanted to make a quick post to ask you to check your PMs here - left you a message.

Thanks!

[E.T.]

Hi,
Hope it's ok to jump in here.
I need to get 1,000's of items into Osc (actually about 20,000 - 2,000 of which will have attributes). I think that Easypopulate is the only option - but the limit of about 300 records per import file, would make this a fiddle. I guess the timeout value cannot be increased easily on a shared server for the import process alone. This is not likely to be a one off process and maybe required weekly.
I'm sure plenty of sites have had to do this. Any suggestions would be greatly appreciated.
Thanks, Antony

[reasonable]

VJ I sure hope you're still following this.

I've been using this since the first attributes fix was figured out by manually adding the fields in the file. Been able to get it all to work until now. This thread http://forums.oscommerce.com/index.php?showtopic=73572 is where I originally posted looking for help. The only attibute mod besides easy populate currently installed is the products attributes item editor 1.3 however the problem exists if I use clean versions of all the files. If I turn the attribs off in EP I can export a file. If they are turned on then I cannot export.

Any help would be greatly appreciated.

Thanks,

Edited by reasonable, 14 January 2004 - 07:50 PM.

[Sagan]

Whenever I upload an EP database file I get duplicate categories and subcategories if the the category name has a comma in it.

For example, when uploading a sample database on my test site:
http://epg.physicsisbroken.com/catalog/ind...1376f96d9622bef

Any idea how to fix this? I am using the latest version (2.73 I think).

Also the uploaded product URLs do not seem to be working.

Any insight on this would help. Thanks.

Edited by Sagan, 15 January 2004 - 06:30 PM.

[niknakgroup]

Quote

Whenever I upload an EP database file I get duplicate categories and subcategories if the the category name has a comma in it.

Am no wizz with these things, but am guessing that whilst working on your files you are saving them as .csv and then saving as tab delimited at the last save before upload. Either way, best to avoid commas and the & sign in your category description - try missing the comma (very few people notice it is gramatically incorrect) and replacing "&" with "+" - if you are using excel this is dead easy, just highlight your category columm (all of it), press "Ctrl" and "F", type in ",", hit find. Then click replace, leave it empty and hit replace all. This delets all the commas. Do the same again, but find "&" and replace with "+" - hit replace all again. Should take about 30 seconds and should fix the problems for you. If it doesn't, scream back at me on the board and I'll scratch my head and ponder it some more for you.....

[Sagan]

niknakgroup, on Jan 16 2004, 12:20 AM, said:

Am no wizz with these things, but am guessing that whilst working on your files you are saving them as .csv and then saving as tab delimited at the last save before upload. Either way, best to avoid commas and the & sign in your category description - try missing the comma (very few people notice it is gramatically incorrect) and replacing "&" with "+" - if you are using excel this is dead easy, just highlight your category columm (all of it), press "Ctrl" and "F", type in ",", hit find. Then click replace, leave it empty and hit replace all. This delets all the commas. Do the same again, but find "&" and replace with "+" - hit replace all again. Should take about 30 seconds and should fix the problems for you. If it doesn't, scream back at me on the board and I'll scratch my head and ponder it some more for you.....

That doesn't work too well for me. My client wants to download an updated database everyday from his wholeseller, in the form of a .csv file. I rigged up a simple excel file to rearrange the columns and modify the dates so I can easily save it as tab delimited file. I suppose I can mess with excel some more to replace text, but I am looking for a more automated process rather than spending an hour every day converting one format to another.

[reasonable]

There is a setting in the easypopulate.php file to change the file to csv instead of tab delimited. Uncomment the csv setting and comment the tab. Problem being is that every comma is going to be interpreted as a new field. It would be much simpler to remove the commas from the categorie names in the original file. At least from my view point as a non-programmer and only mid-level user.

[chique]

Hello, i have a question, maby for Vj ?

I have a site in 3 languages, Easy populate is working great, except that it only makes new catagories in de default language, and in the other languages it moves the category box or coolmenu box. Please take a look at My Webpage and jou will see what i mean. The default language is dutch, when you look in english you will see that the categorie box has moved, and that not all the categories are there.

So what i think there has to be done is to ad a few lines for the catagories from other languages in Easy populate.

But i realy don't know how to do that  

Can somebody please help me

with regards,

Don

[reasonable]

Okay here we go again with the non-programmer questions.

I do not understand php so I am not sure my assumptions are correct here (I'm sure someone will tell me if I'm wrong) but I am trying to understand this.

1. I see only three files that are called in this script and they are standard includes of application_top, database_tables, and application_bottom and do not include categories or any other admin or catalog files.

2. All the logic appears to be file layout and sql functions.

Since I cannot download a file that contains attributes would it make sense that there is a problem reading from the database? As I said earlier I can download a full file if I turn the attribs off.

Is it possible to set the timeout beyond the 330 in the file even though I am doubtful that it would help?

Does anyone know how to modify EP so that it can be run from the command line using the cgi version of php? I managed to figure out how to get past my initial problem with that but then started getting parse errors that go beyond what would seem logical to comment the lines out to avoid (i.e. commenting out the version seems more logical than commenting out the file includes).

Thanks,

[Sagan]

I discovered the source of the problem I had. Not a problem with Easy Populate at all, but something that may want to be added to avoid problems.

By default, OSC creates the database with character limits (32 characters for a category name). A few of my sub-category names were longer by one or two characters, so they were being truncated and causing Easy Populate to not recognize them as category name together and therefore giving me duplicate categories. A simple check could fix this from being a problem.

Good work on Easy Populate, works great!

Edited by Sagan, 16 January 2004 - 09:00 PM.

[shari]

Quote

By default, OSC creates the database with character limits (32 characters for a category name). A few of my sub-category names were longer by one or two characters, so they were being truncated and causing Easy Populate to not recognize them as category name together and therefore giving me duplicate categories.

Yes- that happened to me... I just now finished deleting the 132 repeats of the same category.   For future reference, is there a way to go through and delete these rogue entries that doesn't involve three screens? (Not that I plan on having it happen again, but you never know.....)

Shari

[monterey93940]

guys help.

i added the retail price column with EZ fields.

now when i load up

i get this error

--------------------------------
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '
'100' 'NULL')' at line 23

INSERT INTO products ( products_retail_price, products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '', '2', '20', '1', CURRENT_TIMESTAMP, "0000-00-00 00:00:00", "1/18/2004 22:27", '1', '12', '12',
'100' 'NULL')
-----------------------------

i can use os to add and delete stuff but when i use EP i get the error above and then the items that are there gets duplicated.

Please help been playing around for weeks.

[by4x4]

Wow - it looks like this is the program (EP) for me, but I am 90% sure I will run into trouble (as a non-programmer) and it appears as though the guru (VJ) has gone AWOL.  Here's a preemptive cry for help as I throw caution to the wind and dive into EP.  Wish me luck  

[roku]

I am hoping someone might be able to help me with this error.
I have installed EP_v2_73_MS2 then updated the easypopulate.php for oscommerce-2.2ms2 and I get the following error:

Warning: main(includes/database_tables.php): failed to open stream: No such file or directory in/Library/WebServer/Documents/admin/easypopulate.php on line 157

Fatal error: main(): Failed opening required 'includes/database_tables.php' (include_path='.:/usr/lib/php') in/Library/WebServer/Documents/admin/easypopulate.php on line 157

Where am to get this file ""database_tables.php"" from?
Did I install the wrong package?

Any help with this matter would be greatly appreciated.

Regards,
roku

[reasonable]

roku,
if you're running MS2 then the file should be in your catalog/includes folder. if not then you need to get one of the older versions that works with MS1.

[hoolahoous]

I installed ur contrib on a fresh install of OSCommerce. I got following error when I tried to download the complete file.

"1054 - Unknown column 'p.products_master' in 'field list'"

I then tried to Download Model/Price/Qty tab-delimited .txt file. That downloaded succesfully but but when uploading got the exact same error as above.

It was a FRESH install. I didn't modify anything (in DB or in code except the changes mentioned in manual)

[MDANET]

hi there i am long time user of oscommerce but i have changed lanes to a new commerce site called cube cart i like the layout much better than oscommerce and it is easier to work with but saying that it does not have any way of adding multiple products and categories at one time.

i am just wondering if the creator(s) of easy populate would like to look at making a version of easy populate for cube cart i am willing to offer the use of a cube cart installation and access to the cube cart folder via ftp.

so if you are willing to expand your development please let me know so i can setup the relevent needs.

my email is anthony@mdanetworks.com


kind regards
Anthony