Zen Cart Logo
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Views: 1,301,192

Results 2,101 to 2,120 of 3,834
8 Jan 2009, 6:11 AM
#2101
savanah avatar

savanah

New Zenner

Join Date:
Apr 2008
Posts:
8
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

After I hit add to DB, it acts like it is adding the products, but nothing is added. I've used EasyPopulate before with no problems, but it was a few months ago so I have no idea what I am doing wrong. Any help would be greatly appreciated as I have a new supplier and over 4,000 products to add.

Upload Results

File uploaded.
Temporary filename: /tmp/php9odnSs
User filename: amulets.csv
Size: 12131

Upload Complete

8 Jan 2009, 6:44 AM
#2102
phazei avatar

phazei

New Zenner

Join Date:
Jan 2009
Posts:
31
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

The CSV version isn't compatible with data files from older versions.
Added some more details under "Upload Results".

8 Jan 2009, 11:19 AM
#2103
nagelkruid avatar

nagelkruid

Zen Follower

Join Date:
Nov 2006
Posts:
284
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

phazei:

The CSV version isn't compatible with data files from older versions.
Added some more details under "Upload Results".

Nice work.
I have been looking at this code to get a froogle similar output and i almost got it.

Last thing i need is a check if a product_id allready exists in the array and if it does, do not add it again. (this is because i have some products copied over different categories and i only want those once in the output)

I think i need to do something around line 762 while($row=) but i am really at loss :)

any ideas?

8 Jan 2009, 2:09 PM
#2104
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

phazei,

  1. I imagine the EOREOR was a "simple" way to handle cross platform issues with reading end of line.

  2. Concerning old mods: My philosophy is more aggressive concerning a re-write. (I don't even think Linda's header thing exits anymore... from like zen 1.2..???) There are so many mods out there that it would be better to have a stable non-beta version that works with a default 1.38 install. Once that's done, you can go back and add functionality. It will also make porting to zen 2.0 easier since there are significant changes coming.

  3. I would like to suggest a NEW thread for you CSV version. There are still many people using 1.2.5.4 and this is where they go for support. You're CSV version will only add to the confusion with the OSC ports, advanced ver, working and non-working free versions!

  4. To my knowledge no one has ever posted code that allows you to update quantity discounts with EP (not even the advanced paid version, though langer had talked about adding it), so quantity discounts is my baby (although it was a simple solution when I finally sat down to do it).

  5. Fixing product attributes is more important than other mods, but fixing this once 2.0 may be a more constructive use of time.

Just putting my thoughts out there!

-cj

8 Jan 2009, 5:05 PM
#2105
savanah avatar

savanah

New Zenner

Join Date:
Apr 2008
Posts:
8
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

phazei:

The CSV version isn't compatible with data files from older versions.
Added some more details under "Upload Results".

Okay, I don't understand what you mean. The CSV file that I'm using is the one that it creates when I download a full EP file from my existing site. Even if I remove all the products but one and change the remaining product code, it won't actually add the products, but it acts like it does.

8 Jan 2009, 5:31 PM
#2106
savanah avatar

savanah

New Zenner

Join Date:
Apr 2008
Posts:
8
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Okay, nevermind. Somehow I saved it as a CSV and didn't realize that wasn't what it started as. LOL - shouldn't stay up so late. Have it working now. Thank you.

8 Jan 2009, 9:52 PM
#2107
phazei avatar

phazei

New Zenner

Join Date:
Jan 2009
Posts:
31
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

nagelkruid:

Last thing i need is a check if a product_id allready exists in the array and if it does, do not add it again. (this is because i have some products copied over different categories and i only want those once in the output)

I think i need to do something around line 762 while($row=) but i am really at loss :)

any ideas?

That should be really simple one liner.
Line 1071:
$filestring[] = $tempcsvrow;
Change that to:
$filestring[$row['v_products_model']] = $tempcsvrow;
or
$filestring[$row['v_products_id']] = $tempcsvrow;

If there is a duplicate model or id, it will overwrite the same key instead of adding a new item.

chadderuski:

phazei,

  1. I imagine the EOREOR was a "simple" way to handle cross platform issues with reading end of line.

@ini_set('auto_detect_line_endings',true);
or to force it mac:
stream_get_line($fp, 4096, "\r");

chadderuski:

phazei,
2) Concerning old mods: My philosophy is more aggressive concerning a re-write. (I don't even think Linda's header thing exits anymore... from like zen 1.2..???) There are so many mods out there that it would be better to have a stable non-beta version that works with a default 1.38 install. Once that's done, you can go back and add functionality. It will also make porting to zen 2.0 easier since there are significant changes coming.

I agree, a rewrite is a waste of time until 2.0 comes out, it's going to be significantly different. I only wanted to make changes to the one easypopulate file. A rewrite should split it up into multiple files, or make a class out of it.
2.0 is supposed to come with a db backup system built in, so it probably won't even need easy populate.

Someone might as well change the version number on EP to work with 1.38, there aren't any changes between 1.36 that I've seen that affect it at all.

chadderuski:

  1. I would like to suggest a NEW thread for you CSV version. There are still many people using 1.2.5.4 and this is where they go for support. You're CSV version will only add to the confusion with the OSC ports, advanced ver, working and non-working free versions!

You're probably right.

chadderuski:

  1. To my knowledge no one has ever posted code that allows you to update quantity discounts with EP (not even the advanced paid version, though langer had talked about adding it), so quantity discounts is my baby (although it was a simple solution when I finally sat down to do it).

I haven't even looked at how ZC does quantity discounts. It's probably stored in a different table. Would need to add a link to a different type of file to download if it's more than one setting per product. If not, it could just be tacked onto the full file at the end like I did with the meta.

chadderuski:

  1. Fixing product attributes is more important than other mods, but fixing this once 2.0 may be a more constructive use of time.

That's the file that stores like different color or size options for the products, right? What's broken with it?

8 Jan 2009, 10:49 PM
#2108
phazei avatar

phazei

New Zenner

Join Date:
Jan 2009
Posts:
31
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I added a new thread:
http://www.zen-cart.com/forum/showthread.php?t=117204

Though it works the same, it's more of an update than a new contribution. But then again, this thread is getting unmanageably long anyway. But it is stickied, so that's nice.

And I uploaded it to the addons section. It would be better if they just tagged it on to the 1.2.5.5 one since it's basically the same. Maybe just make it 1.2.5.6

9 Jan 2009, 9:56 AM
#2109
nagelkruid avatar

nagelkruid

Zen Follower

Join Date:
Nov 2006
Posts:
284
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

phazei:

I added a new thread:
http://www.zen-cart.com/forum/showthread.php?t=117204

And I uploaded it to the addons section. It would be better if they just tagged it on to the 1.2.5.5 one since it's basically the same. Maybe just make it 1.2.5.6
If it would still work with txt files and had an export to csv option added to it you would be right.

I am not sure why you want it in csv, but you may have your reasons, i personally have a need to keep it outputted in txt but that's because i mainly use the exports to prepare the datafeeds for various websites out there.
If they want different output in headers, i simply make a new case, define the headers, and never look at or open the txt file again when it is done, just upload it to their website.

I guess .csv is indeed easier if you just want to export/import the products. I had trouble in the past with the txt version as my shop is running utf-8 and character encoding is always a pain for me, when i have more time i may start looking again at the csv output, it may have gotten better?

Anyway, still great you are working on this and i will surely be checking the new thread out often. See you there...

9 Jan 2009, 9:49 PM
#2110
nagelkruid avatar

nagelkruid

Zen Follower

Join Date:
Nov 2006
Posts:
284
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

phazei:

That should be really simple one liner.
Line 1071:
$filestring[] = $tempcsvrow;
Change that to:
$filestring[$row['v_products_model']] = $tempcsvrow;
or
$filestring[$row['v_products_id']] = $tempcsvrow;

If there is a duplicate model or id, it will overwrite the same key instead of adding a new item.

I think that works in your version because $filestring is declared an array. In the text output it is a string and i get error.

10 Jan 2009, 2:23 AM
#2111
phazei avatar

phazei

New Zenner

Join Date:
Jan 2009
Posts:
31
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

nagelkruid:

I think that works in your version because $filestring is declared an array. In the text output it is a string and i get error.

Yeah, that will only work in my version. It might be a pain in the old version.

nagelkruid:

I am not sure why you want it in csv, but you may have your reasons, i personally have a need to keep it outputted in txt but that's because i mainly use the exports to prepare the datafeeds for various websites out there.

CSV files are basically text files, they just have certain rules that make things easier. The file it was using was some proprietary thing that the original creator made up instead of using a standard that took care of all the problems he had in the code. He wasn't a very experienced coder. He didn't even bother using PHPs built in time and date functions, he had 2 pages of code to manually parse them.

In the main easypopulate.php file in the configuration options, if you change the deliminator to "\t" (tab) and the encapsulate to " " space, then it will be just like it was, without the EOREOR.
If you need to remove linefeeds in boxes, it does that for the froogle options. It takes a line of code that can be added to the other options.

The main reason it's not compatible is because I added the columns on the end for the meta data. If you import an old file, the meta data won't be there, and if you have some already, it will be overwritten with NULL.

10 Jan 2009, 9:21 AM
#2112
nagelkruid avatar

nagelkruid

Zen Follower

Join Date:
Nov 2006
Posts:
284
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

phazei:

In the main easypopulate.php file in the configuration options, if you change the deliminator to "\t" (tab) and the encapsulate to " " space, then it will be just like it was, without the EOREOR.
If you need to remove linefeeds in boxes, it does that for the froogle options. It takes a line of code that can be added to the other options.

The main reason it's not compatible is because I added the columns on the end for the meta data. If you import an old file, the meta data won't be there, and if you have some already, it will be overwritten with NULL.
Thank you for explaining that.
Don't get me wrong, i REALLY want to switch to the CSV option as it is allready much better for its original use; exporting/importing products :wink: Especially with the metatags incorporated.

I'll just have to find the easy way to keep that froogle output as i want it but with the above info and a few if (ep_dltype=froogle) i am probably good to go with the csv one.

cheers,
Jeroen

12 Jan 2009, 3:41 PM
#2113
naturalflow avatar

naturalflow

New Zenner

Join Date:
Jan 2009
Posts:
2
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm wondering if someone know which version of Easy Populate to use (and a link to download it) with the 1.3.7 version of Zen Cart that I use and don't want to update by fear to screw everything up..

Thanks a lot

12 Jan 2009, 4:05 PM
#2114
naturalflow avatar

naturalflow

New Zenner

Join Date:
Jan 2009
Posts:
2
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

naturalflow:

I'm wondering if someone know which version of Easy Populate to use (and a link to download it) with the 1.3.7 version of Zen Cart that I use and don't want to update by fear to screw everything up..

Thanks a lot

Sorry for that post, I find my answer here: http://www.zen-cart.com/forum/showthread.php?t=60409

14 Jan 2009, 9:47 PM
#2115
silver_falls avatar

silver_falls

New Zenner

Join Date:
Jul 2008
Posts:
11
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I installed EP and was wondering if anybody has figured out how to automate the enabling of "call for pricing" when using EP. Or better yet, if v_products_price = 0 then "call for pricing". I am using Zencart version 1.3.8. I have about 20,000 products to upload, with $0 price (since our business is based on request for quote). It would take years to input that data by hand. I'd greatly appreciate any help.

15 Jan 2009, 6:36 AM
#2116
h_2_o avatar

h_2_o

New Zenner

Join Date:
Jan 2009
Posts:
20
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

php 5.2.8
mysql 5.0.67

i've installed easy populate and it exported the inventory correctly once into the tempEP directory. however anything i try to do now it just logs me back out into the admin page for zencart. anyone know why it might be doing this?

thanks

15 Jan 2009, 2:56 PM
#2117
lkzone avatar

lkzone

New Zenner

Join Date:
Jan 2008
Location:
Georgia
Posts:
68
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Easy Populate just quit working. I'm using 1.2.5.4 and haven't made any changes to my site since it last worked.

When I enter the file name into the "Import from temp directory" field box (the file is indeed in the temp directory and I've used copy so spelling is not an issue) I get a page returned from IE saying this page cannot be displayed (like a 404 I think)

I was able to download the "Complete" file so the module is working in that aspect.

I checked with hosting provider (Website Source) and they say everything is okay on the dbase side.

Any ideas on where to look for problem?

thx:blink:
~Lynne

15 Jan 2009, 6:16 PM
#2118
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I looked thru forum trying to find if my issue has already been posted. I did not see anything, please forgive me if I missed. I am using zencart v 1.3.8.

I started with small file of 5 records. And getting this error.

Warning: explode() [function.explode]: Empty delimiter in /home/xxxx/xxxx/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241

When I go to line 241...I see this code.
$date_bits = explode($separator, $excel_date[1]);

Not sure what it means. I do not have any dates listed on my .txt file.

15 Jan 2009, 6:47 PM
#2119
silver_falls avatar

silver_falls

New Zenner

Join Date:
Jul 2008
Posts:
11
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Silver Falls:

I installed EP and was wondering if anybody has figured out how to automate the enabling of "call for pricing" when using EP. Or better yet, if v_products_price = 0 then "call for pricing". I am using Zencart version 1.3.8. I have about 20,000 products to upload, with $0 price (since our business is based on request for quote). It would take years to input that data by hand. I'd greatly appreciate any help.
After looking at the code for the Call_For_Price on/off toggle, it shows:

<tr>
<td class="main">Product is Free:</td>
<td class="main"><img src="images/pixel_trans.gif" border="0" alt="" width="24" height="15"> <input type="radio" name="product_is_free" value="1"> Yes  <input type="radio" name="product_is_free" value="0" CHECKED> No </td>

      </tr>
      <tr>
        <td class="main">Product is Call for Price:</td>
        <td class="main"><img src="images/pixel_trans.gif" border="0" alt="" width="24" height="15"> <input type="radio" name="product_is_call" value="1" CHECKED> Yes  <input type="radio" name="product_is_call" value="0"> No <span class="errorText">*Product is marked as CALL FOR PRICE</span></td>
      </tr>

      <tr>

        <td class="main">Product Priced by Attributes:</td>
        <td class="main"><img src="images/pixel_trans.gif" border="0" alt="" width="24" height="15"> <input type="radio" name="products_priced_by_attribute" value="1"> Yes  <input type="radio" name="products_priced_by_attribute" value="0" CHECKED> No </td>
      </tr>

So, if a toggle is set to "no", after value="0" shows CHECKED> No </td>
If a toggle is set to "yes", after value="0" shows > No <span class="errorText">*Product is marked as CALL FOR PRICE</span></td>

Again, I am looking for a way that I can import my products using EP, but not have to go back into Admin, manually edit each product, and set the toggle to Call For Price = "yes".

15 Jan 2009, 8:53 PM
#2120
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Silver Falls,

I've sent you a PM. My own custom version does this already and I can send it to you after a mod or two. I've added a couple custom columns to the products database and will have to remove those entries first.

-cj