8922 replies to this topic

[VJ]

Quote

1) The file is to large to import in excel, not all the atributes and catagories are showed.

2)All the atributes are assigned to every single product, so say I have a dress in small, medium and large. Now all the other atributes are there as well in the excel file, so now I have a dress with S,M,L,XL,RED,BLUE,WHITE,34,36,38, S/M,M/L,L/XL ......and it go's on. So now I have reached the maximum imported column in excel. (256 pc).

Hello Don,

1.  This is not really a limitation of this code, but you could try my latest code update, which has this option to handle just the product models and attributes. That would probably save a few columns. If you still have excess columns, you could try to hack the code to make it handle 1 language or 1 attrib set, at a time (just a thought!).

2. Well, attributes are not actually assigned to every single product. Attributes are assigned to a product, only if the corresponding value price cell contains a "non-empty" value. Otherwise, the attribute options/values are listed beside each product, but are not assigned to them.

If you think your tab-delimited file is messed up in any way, you could email it to me (just make sure you zip or tgz it... I'm on a slow dial-up  ).

HTH,
VJ

[VJ]

Quote

I like this new mod, however, I have one problem. My products and their attributes are running on MS1 and while I managed to get all the products moved from MS1 to MS2 using EP, your new one is not MS1 compatible. Any chance of you making one that is compatible with both MS1&2. I would like to be able to download the attributes from MS1 and upload to MS2.

Well, it turned out to be quite easy, in the end. Just comment out this line in easypopulate.php, and it works just fine in MS1 .

require(includes/database_tables.php); // comment this line

VJ

[chfields]

I tried to delete that line and it gave me errors

[chfields]

Well, I've already switched my site to MS2 so it's too late.......I'll just have to add the attributes by hand....

[VJ]

I've been getting feedback from folks who have a lot of product attributes, that leads to the tab-delim file exceeding 256 columns (which is the max. column limit for most worksheet programs).

I've now added an option to download only selected product attribute options. For example, if you have the options - Colour, Size, Model, you'll now be able to select any particular option(s) to download (say, Colour and Model).

Look out for this configuration directive line, in easypopulate.php and make necessary changes:

global $attribute_options_select;
//$attribute_options_select = array('Size', 'Model');

You can download the latest easypopulate.php, here.

Keep your feedback coming, and thanks to all folks who've offered ideas/feedback :-).

VJ

[Avanzar]

I don't know if this is the right place but I am new at this and require some heplp with Easy Populate. I have been successsful i intergrating it but am not abe to upload files. Downloading does not seem to be a problem. I receive this message "Warning: move_upload_file(......):Failded to open Stream:No such file or directory.

I followed the instructions to the letter. I created a /catalog/temp file as per the instructions and still nothing.

Can anyone give me a suggestion?

Edited by Avanzar, 24 November 2003 - 05:26 AM.

[DS_Sultan]

I have found that a default install of EP will actually ADD path to your upload.  If you look closely at the message it says something (or at least mine did) about the path being catalog/catalog/temp... etcc..

What I did was to edit the easypopulate.php file variables area and change the path to just temp.  Take out the word catalog.  Then mine uploaded just fine.  I of course have a different issue but that is just me workin out the bugs.

Hope this helps.

[VJ]

This program is now available for download, as a contribution, here.

Support for this program will continue in this thread.

VJ

[casechopper]

I read this in the manual
------------------------------------------------------------------------------------------
3.3 For adding link to the Admin, edit file admin/includes/boxes/tools.php by after this line:

        tep_admin_files_boxes(FILENAME_SERVER_INFO, BOX_TOOLS_SERVER_INFO) .

include this line:
tep_admin_files_boxes(FILENAME_EASYPOPULATE, BOX_TOOLS_EASYPOPULATE) .
-----------------------------------------------------------------------------------------

But I can't seem to find those line of code in the tools.php file. Is there an update to the manual that I'm missing?

[VJ]

casechopper, on Nov 28 2003, 03:37 PM, said:

I read this in the manual
------------------------------------------------------------------------------------------
3.3 For adding link to the Admin, edit file admin/includes/boxes/tools.php by after this line:

        tep_admin_files_boxes(FILENAME_SERVER_INFO, BOX_TOOLS_SERVER_INFO) .

include this line:
tep_admin_files_boxes(FILENAME_EASYPOPULATE, BOX_TOOLS_EASYPOPULATE) .
-----------------------------------------------------------------------------------------

But I can't seem to find those line of code in the tools.php file. Is there an update to the manual that I'm missing?

I just looked at the 1readmeFIRST.txt, and this is what I found:

3. For adding link to the Admin, edit file admin/includes/boxes/catalog.php by adding this line:

'<a href="' . tep_href_link('easypopulate.php', '', 'NONSSL') . '" class="menuBoxContentLink">Easy Populate</a><br>'.

After:
 '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '"
class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES .
'</a><br>' .

By the way, which version of EP do you use?

HTH,
VJ

[casechopper]

Thanks, I guess I should read files with titles like that I'm using 2.71-MS2

[freerap]

Any chance this might be modded to work with MS1 please ?? Easypop is awsome and the only way we populate our store but the attribute addition will make it really good. Have you thought about adding the ability to insert the data for Linda Header Tag Controller ??

[VJ]

freerap, on Dec 1 2003, 03:43 AM, said:

Any chance this might be modded to work with MS1 please ?? Easypop is awsome and the only way we populate our store but the attribute addition will make it really good. Have you thought about adding the ability to insert the data for Linda Header Tag Controller ??

I've managed to get this mod to function, in my MS1 setup, by making a simple change. Just comment out this line in admin/easypopulate.php.

require(includes/database_tables.php);

I haven't tested this extensively, but it should be worth giving a try .

As for header tags, this new EP version retains the ability to handle data for Linda's Header Tag Controller, from previous versions. You just have to follow the manual and make some minor changes.

HTH,
VJ

[bathory]

arg. ih ave a huge store with loads of options and this would be a huge lifesaver except that excel gives me a pop up that says "file not loaded completely" and all it has is the headers and not all teh stuff i already added to DB. I have no idea why this is since I'm not an excel whiz.

ideas?

thanks
-bathory

[VJ]

Quote

arg. ih ave a huge store with loads of options and this would be a huge lifesaver except that excel gives me a pop up that says "file not loaded completely" and all it has is the headers and not all teh stuff i already added to DB. I have no idea why this is since I'm not an excel whiz.

Please refer to my posts (in this same thread) on Nov. 21, 23 for clues.

HTH,
VJ

[bathory]

excellent thanks!
success!

Edited by bathory, 13 December 2003 - 07:34 AM.

[MattM]

VJ -

Can I ask you to take a look at my post in this thread?

Basically I'm trying to add a field to EP that will handle this mod.

[titus]

Hi vj,
I went through the forums on oscommerce.com but didn't really find an answer to my problem…

I am using this version:
-------------------------------------------------
Easypopulate v2.71-MS2 (with attributes)
-------------------------------------------------
Last updated: November 27, 2003
Author: Vijay Immanuel aka VJ <www.vjdom.com>, based on earlier releases by various developers (for more details, see history.txt)
License: GPL (please see license.txt)
-------------------------------------------------

Thanks if you can find the error with the below information. Don't bother if it takes you too long, I just thought you might probably have the answer in a second or so… The problem is that I get an error when doing an import. Have a look yourself (no passwords required yet…). I emailed you this post with the real URL and everything so that nobody in the forum fusses around with my site...  

http://www.xxxxxxxxxxx.de/admin/easypopulate.php

Can you figure out why I am getting this error:

Filename: sample_output_file.txt
1064 - You have an error in your SQL syntax near 'AND cat.parent_id = 0 AND des.categories_name = 'Buecher'' at line 6

SELECT cat.categories_id FROM categories as cat, categories_description as des WHERE cat.categories_id = des.categories_id AND des.language_id = AND cat.parent_id = 0 AND des.categories_name = 'Buecher'

I did change the input locales on my computer to US format, so that the prices are displayed with the dot as a decimal seperator, not the German comma….
BTW, when re-opening the text file in Excel, everything looks just fine...

Thanks vj, and keep up the great work!!!

Titus.

Edited by Johnson, 26 December 2003 - 01:53 PM.

[VJ]

Quote

Can you figure out why I am getting this error:

Filename: sample_output_file.txt
1064 - You have an error in your SQL syntax near 'AND cat.parent_id = 0 AND des.categories_name = 'Buecher'' at line 6

SELECT cat.categories_id FROM categories as cat, categories_description as des WHERE cat.categories_id = des.categories_id AND des.language_id = AND cat.parent_id = 0 AND des.categories_name = 'Buecher'

I did change the input locales on my computer to US format, so that the prices are displayed with the dot as a decimal seperator, not the German comma….
BTW, when re-opening the text file in Excel, everything looks just fine...

You probably have a problem with your default language id. Check if it shows the right value.

VJ

[titus]

thanks! Problem resolved :-))


Ciao, Titus.