Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * - 15 votes

Easy Populate & Products Attributes


8796 replies to this topic

#1261 ifalu

  • Community Member
  • 36 posts
  • Real Name:Ian Falu

Posted 15 December 2004, 02:30

Sorry for my desesperation but I was uncommenting other pieces of codes I coouldn't find that one in particular.

Thanks for your great job

#1262 sty1129

  • Community Member
  • 12 posts
  • Real Name:Mike Steel

Posted 15 December 2004, 07:02

Mibble, on Dec 14 2004, 02:44 PM, said:

means the path is still incorrect or the permissions are not correct.  what do you have in your easypopulate.php file for the temp file path.

<{POST_SNAPBACK}>



Hi,
I have:
$tempdir = "/magazin/temp/";
$tempdir2 = "/magazin/temp/";

The permissions are set to 777.

#1263 Macus

  • Community Member
  • 6 posts
  • Real Name:m. acus

Posted 15 December 2004, 11:44

Hi,

I am working with Milestone Version and installed Easypopulate.
It worked great and did a good job.

However I stopped working with the shop some months ago. As I tryed to run Easypopulta again it just stopped working.

I have following problem:

File uploaded. 
Temporary filename: /tmp/php2hjdDQ
User filename: EP2004Dez13-1010.txt
Size: 1370
| 1000154 | 1000154 | FSC PR RX2 | FSC PR RX2 | | 2714.66 | 0.00 | | 0000-00-00 | 0 | Fujitsu Si | Systeme | PC | Server | MWSt | Inactive Updated
| 233;10001 | 100347;ht | 10039;100 | 123456;ha | 123456;ha 
|

As you can see Easypopulate only imports the first row. But it seems to get "confused" with further lines (2 and more). It seems that Easypopulate is not able to find the seperator which I tried first with tabs and in this example with semicolons. The first line is imported correctly. Additional lines make problems.

As I installed a new and clean testshop and just uploaded the newest Easypopulate Script it gets the same problem.

Has someone a solution? We updated the Server some weeks ago with PHP5. I changed the upload.php as it is described in the bug report.

It seems that there is a conflict with something. I hope you can help me.

Thanks
Macus

#1264 Mibble

  • Community Member
  • 13,404 posts
  • Real Name:JAO
  • Location:MA (US): 42n22, 71w04, Massachusetts

Posted 15 December 2004, 12:51

Warning: file(/home/store/public_html/magazin/tempEP2004Nov05-14021.txt):

if you take a look at your path from your previous post, you will see that you are somehow missing the / at the end of temp, (look at the sentence above)

once you can get that portion fixed, then it will work

#1265 Macus

  • Community Member
  • 6 posts
  • Real Name:m. acus

Posted 15 December 2004, 12:56

@Mibble

Can you also help me with my problem :rolleyes:
I havent found a solution yet <_<

#1266 Mibble

  • Community Member
  • 13,404 posts
  • Real Name:JAO
  • Location:MA (US): 42n22, 71w04, Massachusetts

Posted 15 December 2004, 12:59

take a look a few pages back, there was a fix for php5

#1267 Macus

  • Community Member
  • 6 posts
  • Real Name:m. acus

Posted 15 December 2004, 13:52

Mibble, on Nov 26 2004, 12:40 AM, said:

this on the server?  one thing you can do, is setup a system locally running 4.3.9, and then create a database there.  then upload the products from the database to the live server.
then use easypopulate to create more of the products locally, then restore just the tables for the products to your server.l

<{POST_SNAPBACK}>


:huh: Do you mean this?

:'( This isn't a good solution for me :'(

#1268 Mibble

  • Community Member
  • 13,404 posts
  • Real Name:JAO
  • Location:MA (US): 42n22, 71w04, Massachusetts

Posted 15 December 2004, 13:54

no there is a code change, i dont remember the exact code however it is within the last 5 or so pages.

#1269 Macus

  • Community Member
  • 6 posts
  • Real Name:m. acus

Posted 15 December 2004, 14:02

(w00t) :thumbsup:

Find
array_walk($readed, 'walk');

replace by this

//array_walk($readed, 'walk'); 
 foreach ($readed as $readed_record) { 
   walk($readed_record); 
 }




Thanks a lot

Edited by Macus, 15 December 2004, 14:03.


#1270 sergiorocha

  • Community Member
  • 11 posts
  • Real Name:Sergio Rocha

Posted 16 December 2004, 00:43

Hello,

Before posting usually a read all forum, but 64 pages is to much.
I having a problem with ep with the contribution separated prices per customer.

Wend I download the list price/model/quantity the regular price is fine (ex:150) but the group price shows like 140.0000.

Any idea what is need to group prices appear without .000 ?

Thanks,

Sérgio

#1271 Top_Speed

  • Community Member
  • 357 posts
  • Real Name:KJ Miller
  • Location:SU-ville (Syracuse)

Posted 16 December 2004, 00:58

Can anyone upload v_products_tax_class_id and get it to work?

Changing the number from 0 to 1 still makes the products not taxed and 1 should be "Taxable Goods" The records for the newly uploaded products are fine except this field.

Am I missing something?

Thanks, Ken

Edited by Top_Speed, 16 December 2004, 00:59.

define('PROJECTS', 'Something that goes on forever!');

#1272 Mibble

  • Community Member
  • 13,404 posts
  • Real Name:JAO
  • Location:MA (US): 42n22, 71w04, Massachusetts

Posted 16 December 2004, 01:50

this is what my tax class is set to:
Taxable Goods

and it all works

#1273 inquisitivemind

  • Community Member
  • 203 posts
  • Real Name:Edwin
  • Location:Australia, Melbourne

Posted 16 December 2004, 01:58

Hi All!!!

I really need some help! I have been using EP for quite some time and i think it a great contribution! But in the last couple of days it just stoped working... when i try to import a file from the temp directory i just get one line of text:

Filename: new.txt

When i try and upload one i get:
File uploaded. 
Temporary filename: /tmp/phpLK6t1F
User filename: new.txt
Size: 379864

I have checked the temp path directory and it is correct in fact if i change it i get errors... I have checked the permissions and the are all 777 for the files and the folder... i have tried the php 5 fix just in case no luck... i spoke to my web host and asked if they changed something and they said no.

I'm really out of ideas as to what could be causing this... ANY help would really be appreciated!!!!

Cheers,

Edwin.

#1274 mike9999

  • Community Member
  • 202 posts
  • Real Name:Michael
  • Location:PA

Posted 16 December 2004, 02:14

Mibble, on Dec 14 2004, 12:38 AM, said:

if ($v_date_avail == '') {
//  $v_date_avail = "CURRENT_TIMESTAMP";
  $v_date_avail = "NULL";

<{POST_SNAPBACK}>


	if (ltrim(rtrim($v_products_quantity)) == '') {
  $v_products_quantity = 1;
	}
	if ($v_date_avail == '') {
//  $v_date_avail = "CURRENT_TIMESTAMP";
  $v_date_avail = "NULL";
	} else {
  // we put the quotes around it here because we can't put them into the query, because sometimes
  //   we will use the "current_timestamp", which can't have quotes around it.
  $v_date_avail = '"' . $v_date_avail . '"';
	}

	if ($v_date_added == '') {
//  $v_date_added = "CURRENT_TIMESTAMP";
  $v_date_added = "NULL";
	} else {
  // we put the quotes around it here because we can't put them into the query, because sometimes
  //   we will use the "current_timestamp", which can't have quotes around it.
  $v_date_added = '"' . $v_date_added . '"';
	}

Is this right mibble?

#1275 Mibble

  • Community Member
  • 13,404 posts
  • Real Name:JAO
  • Location:MA (US): 42n22, 71w04, Massachusetts

Posted 16 December 2004, 02:18

are you having problems with it?

#1276 mike9999

  • Community Member
  • 202 posts
  • Real Name:Michael
  • Location:PA

Posted 16 December 2004, 02:54

v_products_model	v_products_image	v_products_name_1	v_products_description_1	v_products_url_1	v_products_price	v_products_weight	v_products_quantity	v_manufacturers_name	v_categories_name_1	v_categories_name_2	v_categories_name_3	v_tax_class_title	v_status	EOREOR
L&A-1way	l&apromo.jpg	name  <BR><BR>description  195	2	32	L&A Designs	Yamaha	Raptor  Taxable Goods	Active	EOREOR

With the changes in my previous post I get this error
Warning: Invalid argument supplied for foreach() in /home/ripperra/public_html/mall/catalog/admin/easypopulate.php on line 1422
| L&A-1way | l&apromo.j | 2001-2003 | 2001-2003 | | 195 | 2 | 32 | L&A Design | Yamaha | Raptor | | Taxable Go | Active Updated
| | | | | | | | | | | | | |

It does update, but without the date it still blanks it out I get this

This product was added to our catalog on .

I guess what I would like to do is just get rid of updating anything in the database in reference to the dates added or available if they are not in the upload. I dont know why it would work the other way around if there are options to download just model, price and quantity EP files to edit. When you upload them again it changes all the "new items"

Edited by mike9999, 16 December 2004, 02:56.


#1277 inquisitivemind

  • Community Member
  • 203 posts
  • Real Name:Edwin
  • Location:Australia, Melbourne

Posted 16 December 2004, 03:03

Mibble, on Dec 16 2004, 12:18 PM, said:

are you having problems with it?

<{POST_SNAPBACK}>


mibble,

were you refering to me? If so then yes i am having problems since the data does not get uploaded...

Cheers,

Edwin

#1278 sergiorocha

  • Community Member
  • 11 posts
  • Real Name:Sergio Rocha

Posted 16 December 2004, 03:10

sergiorocha, on Dec 16 2004, 12:43 AM, said:

Hello,

Before posting usually a read all forum, but 64 pages is to much.
I having a problem with ep with the contribution separated prices per customer.

Wend I download the list price/model/quantity the regular price is fine (ex:150) but the group price shows like 140.0000.

Any idea what is need to group prices appear without .000 ?

Thanks,

Sérgio

<{POST_SNAPBACK}>


I put this question because if i live the group price as it came from export, the sript dont work, if i 140.0000 to 140 everything go rigth.

Thanks in advance,

Sérgio Rocha

#1279 Mibble

  • Community Member
  • 13,404 posts
  • Real Name:JAO
  • Location:MA (US): 42n22, 71w04, Massachusetts

Posted 16 December 2004, 03:39

in the download, there is a separate ep file, which someone else created for pricing. which one are you using?

#1280 sty1129

  • Community Member
  • 12 posts
  • Real Name:Mike Steel

Posted 16 December 2004, 06:58

Mibble, on Dec 15 2004, 12:51 PM, said:

Warning: file(/home/store/public_html/magazin/tempEP2004Nov05-14021.txt):

if you take a look at your path from your previous post, you will see that you are somehow missing the / at the end of temp, (look at the sentence above)

once you can get that portion fixed, then it will work

<{POST_SNAPBACK}>



Sorry, but this problem i already solve it.
The new error look like:

Warning: file(/home/store/public_html/magazin/temp/EP2004Dec13-0909.txt): failed to open stream: No such file or directory in /home/store/public_html/magazin/admin/easypopulate.php on line 657

Warning: Invalid argument supplied for foreach() in /home/store/public_html/magazin/admin/easypopulate.php on line 680