Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

Hi,

 

I have installed the Easypopulate v. 2.90B and everything works for exporting products now after i took away the # 'v_products_price1_qty' => $iii++,

 

But when i try to import an productfile i get this error:

 

File uploaded.

Temporary filename: C:\PROGRA~1\EASYPH~1\\tmp\php9E.tmp

User filename: EP2006May30-1503.txt

Size: 6342

| MG200MMS | matrox/mg2 | Matrox G20 | | www.matrox | Matrox G20 | | www.matrox | Matrox G20 | | www.matrox | 299.99 | 23.00 | | 30.05.2006 | 32 | Matrox | Taxable Go | EP_STATUS_ Updated

| MG400-32MB | matrox/mg4 | Matrox G40 | | www.matrox | Matrox G40 | | www.matrox | Matrox G40 | | www.matrox | 499.99 | 23.00 | | 30.05.2006 | 32 | Matrox | Taxable Go | EP_STATUS_ Updated

| MSIMPRO | microsoft/ | Microsoft | | www.micros | Microsoft | | | Microsoft | | www.micros | 49.99 | 7.00 | | 30.05.2006 | 2 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-RPMK | dvd/replac | The Replac | | www.replac | Die Ersatz | | www.replac | The Replac | | www.replac | 42 | 23.00 | | 30.05.2006 | 13 | Microsoft | Taxable Go | EP_STATUS_ Updated

| DVD-BLDRND | dvd/blade_ | Blade Runn | | www.blader | Blade Runn | | www.blader | Blade Runn | | www.blader | 35.99 | 7.00 | | 30.05.2006 | 17 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-MATR | dvd/the_ma | The Matrix | | www.themat | Matrix | | www.whatis | The Matrix | | www.themat | 39.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-YGEM | dvd/youve_ | You\'ve Go | | www.youveg | e-m@il f?r | | www.youveg | You\'ve Go | | www.youveg | 34.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-ABUG | dvd/a_bugs | A Bug\'s L | | www.abugsl | A Bug\'s L | | www.abugsl | A Bug\'s L | | www.abugsl | 35.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-UNSG | dvd/under_ | Under Sieg | | | Alarmstufe | | | Under Sieg | | | 29.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-UNSG2 | dvd/under_ | Under Sieg | | | Alarmstufe | | | Under Sieg | | | 29.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-FDBL | dvd/fire_d | Fire Down | | | Fire Down | | | Fire Down | | | 29.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-DHWV | dvd/die_ha | Die Hard W | | | Stirb Lang | | | Die Hard W | | | 39.99 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated

| DVD-LTWP | dvd/lethal | Lethal Wea | | | Zwei stahl | | | Lethal Wea | | | 34.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-REDC | dvd/red_co | Red Corner | | | Labyrinth | | | Red Corner | | | 32 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-FRAN | dvd/franti | Frantic | | | Frantic | | | Frantic | | | 35 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| DVD-CUFI | dvd/courag | Courage Un | | | Mut Zur Wa | | | Courage Un | | | 38.99 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated

| DVD-SPEED | dvd/speed. | Speed | | | Speed | | | Speed | | | 39.99 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated

| DVD-SPEED2 | dvd/speed_ | Speed 2: C | | | Speed 2: C | | | Speed 2: C | | | 42 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated

| DVD-TSAB | dvd/theres | There\'s S | | | There\'s S | | | There\'s S | | | 49.99 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated

| DVD-BELOVE | dvd/belove | Beloved | | | Menschenki | | | Beloved | | | 54.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated

| PC-SWAT3 | sierra/swa | SWAT 3: Cl | | www.swat3. | SWAT 3: El | | www.swat3. | SWAT 3: Cl | | www.swat3. | 79.99 | 7.00 | | 30.05.2006 | 16 | Sierra | Taxable Go | EP_STATUS_ Updated

| PC-TWOF | gt_interac | The Wheel | | www.wheelo | The Wheel | | www.wheelo | The Wheel | | www.wheelo | 99.99 | 10.00 | | 30.05.2006 | 16 | GT Interac | Taxable Go | EP_STATUS_ Updated

| PC-DISC | gt_interac | Disciples: | | | Disciples: | | www.strate | Disciples: | | | 90 | 8.00 | | 30.05.2006 | 17 | GT Interac | Taxable Go | EP_STATUS_ Updated

| MSINTKB | microsoft/ | Microsoft | | | Microsoft | | | Microsoft | | | 69.99 | 8.00 | | 30.05.2006 | 16 | Microsoft | Taxable Go | EP_STATUS_ Updated

| MSIMEXP | microsoft/ | Microsoft | | www.micros | Microsof I | | | Microsoft | | www.micros | 64.95 | 8.00 | | 30.05.2006 | 10 | Microsoft | Taxable Go | EP_STATUS_ Updated

| HPLJ1100XI | hewlett_pa | Hewlett Pa | | www.pandi. | Hewlett-Pa | | www.hp.com | Hewlett Pa | | www.pandi. | 499.99 | 45.00 | | 30.05.2006 | 8 | Hewlett Pa | Taxable Go | EP_STATUS_ Updated

| TEST1 | hewlett_pa | Denne vare | | www.pandi. | Denne vare | | www.hp.com | Dette er e | | www.pandi. | 500.00 | 4300.00 | | 30.05.2006 | 8 | Hewlett Pa | Taxable Go | EP_STATUS_ !New Product!

1136 - Column count doesn't match value count at row 1

 

INSERT INTO products ( 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 ( 'hewlett_packard/lj1100xi.gif', 'TEST1', '500.00', '', '1', CURRENT_TIMESTAMP, "30.05.2006 15:03", NULL, '1', '4300.00', '8', '9')

 

[TEP STOP]

 

The file im importing is:

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_name_3 v_products_description_3 v_products_url_3 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_tax_class_title v_status EOREOR

MG200MMS matrox/mg200mms.gif Matrox G200 MMS www.matrox.com/mga/products/g200_mms/home.cfm Matrox G200 MMS www.matrox.com/mga/deutsch/products/g200_mms/home.cfm Matrox G200 MMS www.matrox.com/mga/products/g200_mms/home.cfm 299.99 23.00 30.05.2006 15:03 32 Matrox Taxable Goods EP_STATUS_ACTIVE EOREOR

MG400-32MB matrox/mg400-32mb.gif Matrox G400 32MB www.matrox.com/mga/products/mill_g400/home.htm Matrox G400 32 MB www.matrox.com/mga/deutsch/products/mill_g400/home.cfm Matrox G400 32MB www.matrox.com/mga/products/mill_g400/home.htm 499.99 23.00 30.05.2006 15:03 32 Matrox Taxable Goods EP_STATUS_ACTIVE EOREOR

MSIMPRO microsoft/msimpro.gif Microsoft IntelliMouse Pro www.microsoft.com/hardware/mouse/intellimouse.asp Microsoft IntelliMouse Pro Microsoft IntelliMouse Pro www.microsoft.com/hardware/mouse/intellimouse.asp 49.99 7.00 30.05.2006 15:03 2 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-RPMK dvd/replacement_killers.gif The Replacement Killers www.replacement-killers.com Die Ersatzkiller www.replacement-killers.com The Replacement Killers www.replacement-killers.com 42 23.00 30.05.2006 15:03 13 Microsoft Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-BLDRNDC dvd/blade_runner.gif Blade Runner - Director\'s Cut www.bladerunner.com Blade Runner - Director\'s Cut www.bladerunner.com Blade Runner - Director\'s Cut www.bladerunner.com 35.99 7.00 30.05.2006 15:03 17 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-MATR dvd/the_matrix.gif The Matrix www.thematrix.com Matrix www.whatisthematrix.com The Matrix www.thematrix.com 39.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-YGEM dvd/youve_got_mail.gif You\'ve Got Mail www.youvegotmail.com e-m@il f?r Dich www.youvegotmail.com You\'ve Got Mail www.youvegotmail.com 34.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-ABUG dvd/a_bugs_life.gif A Bug\'s Life www.abugslife.com A Bug\'s Life www.abugslife.com A Bug\'s Life www.abugslife.com 35.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-UNSG dvd/under_siege.gif Under Siege Alarmstufe: Rot Under Siege 29.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-UNSG2 dvd/under_siege2.gif Under Siege 2 - Dark Territory Alarmstufe: Rot 2 Under Siege 2 - Dark Territory 29.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-FDBL dvd/fire_down_below.gif Fire Down Below Fire Down Below Fire Down Below 29.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-DHWV dvd/die_hard_3.gif Die Hard With A Vengeance Stirb Langsam - Jetzt Erst Recht Die Hard With A Vengeance 39.99 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-LTWP dvd/lethal_weapon.gif Lethal Weapon Zwei stahlharte Profis Lethal Weapon 34.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-REDC dvd/red_corner.gif Red Corner Labyrinth ohne Ausweg Red Corner 32 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-FRAN dvd/frantic.gif Frantic Frantic Frantic 35 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-CUFI dvd/courage_under_fire.gif Courage Under Fire Mut Zur Wahrheit Courage Under Fire 38.99 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-SPEED dvd/speed.gif Speed Speed Speed 39.99 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-SPEED2 dvd/speed_2.gif Speed 2: Cruise Control Speed 2: Cruise Control Speed 2: Cruise Control 42 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-TSAB dvd/theres_something_about_mary.gif There\'s Something About Mary There\'s Something About Mary There\'s Something About Mary 49.99 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR

DVD-BELOVED dvd/beloved.gif Beloved Menschenkind Beloved 54.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR

PC-SWAT3 sierra/swat_3.gif SWAT 3: Close Quarters Battle www.swat3.com SWAT 3: Elite Edition www.swat3.com SWAT 3: Close Quarters Battle www.swat3.com 79.99 7.00 30.05.2006 15:03 16 Sierra Taxable Goods EP_STATUS_ACTIVE EOREOR

PC-TWOF gt_interactive/wheel_of_time.gif The Wheel Of Time www.wheeloftime.com The Wheel Of Time www.wheeloftime.com The Wheel Of Time www.wheeloftime.com 99.99 10.00 30.05.2006 15:03 16 GT Interactive Taxable Goods EP_STATUS_ACTIVE EOREOR

PC-DISC gt_interactive/disciples.gif Disciples: Sacred Lands Disciples: Sacred Land www.strategyfirst.com/disciples/welcome.html Disciples: Sacred Lands 90 8.00 30.05.2006 15:03 17 GT Interactive Taxable Goods EP_STATUS_ACTIVE EOREOR

MSINTKB microsoft/intkeyboardps2.gif Microsoft Internet Keyboard PS/2 Microsoft Internet Tastatur PS/2 Microsoft Internet Keyboard PS/2 69.99 8.00 30.05.2006 15:03 16 Microsoft Taxable Goods EP_STATUS_ACTIVE EOREOR

MSIMEXP microsoft/imexplorer.gif Microsoft IntelliMouse Explorer www.microsoft.com/hardware/mouse/explorer.asp Microsof IntelliMouse Explorer Microsoft IntelliMouse Explorer www.microsoft.com/hardware/mouse/explorer.asp 64.95 8.00 30.05.2006 15:03 10 Microsoft Taxable Goods EP_STATUS_ACTIVE EOREOR

HPLJ1100XI hewlett_packard/lj1100xi.gif Hewlett Packard LaserJet 1100Xi www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 Hewlett-Packard LaserJet 1100Xi www.hp.com Hewlett Packard LaserJet 1100Xi www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 499.99 45.00 30.05.2006 15:03 8 Hewlett Packard Taxable Goods EP_STATUS_ACTIVE EOREOR

TEST1 hewlett_packard/lj1100xi.gif Denne varen er min www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 Denne varen er min www.hp.com Dette er en testvare www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 500.00 4300.00 30.05.2006 15:03 8 Hewlett Packard Taxable Goods EP_STATUS_ACTIVE EOREOR

I have copied one of the other products and just made som changes to names and sow on.

 

When i tried to upload the original productfile only, i got an error in every product description because some of the names was something like the bug's life. Is there some way i can make the script ignore this and insert it with the bug\'s life on itself?

 

Best Regards

Thomas B

 

I have now figured out what was wrong, it had an products_price1 value in the script i had forgotten to delete.

But its some other things i am wondering about when i comes to deleting products.

I saw that you could use EP_STATUS_DELETE instead of EP_STATUS_ACTIVE.

But i have an store where i only get an text file every day that i import to my store. I don't now what products that are new or old and deleted.

 

And i saw that the products wasn't deleted even if i delete it in the product file.

Does anybody now how i can manage to make this work?

 

Hope someone can help me.

 

Best Regards

Thomas B

Link to comment
Share on other sites

When one has for example a T-shirt store, and naturally all diffrent sizes (S, M, L, XL) and Colors ( blue, red, green ) and ofcourse diffrent Quantites for them ( 2 blue XL , 1 red XL , 3 Green XL ) its possible to show this on the stores product info page with a dropdown or when its out of stock WITH THE QTPro Contribution.. But it takes a while just to assign these attributes to one product from the admin.. thats why espacially Cloth store owners want a quicker solution such as uploading an EXEL SHEET ready with the products attributes such as SIZE, COLOR and QUANTITY (and uploading the images apart with FTP). When you search for a contribution for this, one finds out about the EasyPopulate Contr. and installs it.. but then after the installation also finds out that its not possible to edit the diffrent Quantities for each T-shirts diffrent colors with sizes in the exel sheet which you donloaded from your EasyPopulate interface in the admin since there are no exel coloumns to put the Quantities in. I have gone through the whole Forum and have seen that there is no solution for The EasyPopulate and QTPro for Oscommerce users who try to sell products such like T-shirts. Its probably a hard thing to do the coding of it. If anyone finds a Solution. please let me know.

Bora

Michelle, ma belle, these are scripts that go together well !!

Link to comment
Share on other sites

Hai,

 

I had the same problem and saw your solution.

Changed to $DOCUMENT_ROOT and (in my case) /catalog/temp/ with chmod = 777.

 

Now I get this message:

 

File uploaded.

Temporary filename: /tmp/php8I4BI7

User filename: EP2006Jun01-1010_test1.txt

SIZE_EP63115

 

But nothing changed in the database.

 

Does anybody have a solution or a hint for me!

 

thanks

Gauthier

 

 

 

 

 

 

Hey I think its working :D

I scanned the forum and found out

 

define('DIR_FS_DOCUMENT_ROOT', '/hsphere/local/home/blastr/blaststore.com/');

 

needed to be

 

define('DIR_FS_DOCUMENT_ROOT',$DOCUMENT_ROOT);

 

and

 

$tempdir = "/catalog/temp/";

 

needed to be

 

$tempdir = "/temp/";

 

it seems to work fine now..

 

the same thing was pointed in the manuel ( telling to read the easypopulate.php ) but I just did'nt get it. it said;

 

// Please set DOCUMENT_ROOT to $DOCUMENT_ROOT in your /catalog/admin/includes/configure.php

 

I only tested it with one product only and I catched the shopping cart showing double quantity..

I also need to test if the Quantity tracking works fine when a product is bought..

lets see what comes up next.. its too early to tell if the site is actually working properly..

Link to comment
Share on other sites

Now I get this message:

 

File uploaded.

Temporary filename: /tmp/php8I4BI7

User filename: EP2006Jun01-1010_test1.txt

SIZE_EP63115

 

But nothing changed in the database.

 

Does anybody have a solution or a hint for me!

 

thanks

Gauthier

 

Sorry Noerd >_< , my knowledge is'nt enough to guide you, I'm also a beginner, good luck with your EP! :lol:

Michelle, ma belle, these are scripts that go together well !!

Link to comment
Share on other sites

I'm in need some of help, if anyone on this board could solve my probably I would be forever grateful.

 

Currently I can upload just fine with Easy Populate. Using 3.00 MS-2

 

As of right now I can't seem to make any subcategories past the 3rd one. If I decide to add a 4th subcategory, it creates the category, but none of the products are issued. I know my store can handle the 4th subcategory, because I've done so manually. I would appreciate it if anyone could help solve my delima.

 

Also, what's the easiest way to setup Easy Populate so I could upload more than 150 products at a time. Over my LAN network, I didn't have a problem with timing out, but now that my store is on a Server (MidPhase) I can't seem to upload more than 150 products at a time without IE going into a 404 Error page. Keep in mind I've tweaked around with the settings within EasyPopulate.php setting the Timeout rate to something like 1500 and the max product rang to 500, but no dice.

 

Thank you very much, Love the community.

Everyone seems very helpful!

Link to comment
Share on other sites

I'm in need some of help, if anyone on this board could solve my probably I would be forever grateful.

 

Currently I can upload just fine with Easy Populate. Using 3.00 MS-2

 

As of right now I can't seem to make any subcategories past the 3rd one. If I decide to add a 4th subcategory, it creates the category, but none of the products are issued. I know my store can handle the 4th subcategory, because I've done so manually. I would appreciate it if anyone could help solve my delima.

 

Also, what's the easiest way to setup Easy Populate so I could upload more than 150 products at a time. Over my LAN network, I didn't have a problem with timing out, but now that my store is on a Server (MidPhase) I can't seem to upload more than 150 products at a time without IE going into a 404 Error page. Keep in mind I've tweaked around with the settings within EasyPopulate.php setting the Timeout rate to something like 1500 and the max product rang to 500, but no dice.

 

Thank you very much, Love the community.

Everyone seems very helpful!

 

Try to index the product_model field in your database, it should increase the speed dramatically

Edited by pixclinic
Link to comment
Share on other sites

Try to index the product_model field in your database, it should increase the speed dramatically

 

I'm sorry, but if you could elaborate for me on how to doing so. I'm not so great when it comes to database modifcation around SQL.

 

Thank you for the input, greatly appreciated!

Link to comment
Share on other sites

I'm sorry, but if you could elaborate for me on how to doing so. I'm not so great when it comes to database modifcation around SQL.

 

Thank you for the input, greatly appreciated!

 

Nevermind, I figured it out. Didn't notice the Indexes option in PhpMyAdmin

 

I'm still confused about the multiple subcategories. Anyone know why it won't go beyond the 3rd?

 

I would greatly appreciate it!

Link to comment
Share on other sites

Hi

 

Ive installed the easypop mod v2.76c as per the install instructions. I have added the temp folder and CHmod it to 777 also removed the extra / in the easypop.php

 

Now when i download the complete tab file to edit and leave it as is then try to upload it again to test the workings of easypop i get the following error:

 

File uploaded.

Temporary filename: /tmp/phpFn5etg

User filename: EP2006Jun02-1503.txt

Size: 24094

 

Warning: file(/home/teachkor/public_html//catalog/tempEP2006Jun02-1503.txt): failed to open stream: No such file or directory in /home/teachkor/public_html/admin/easypopulate.php on line 667

 

Warning: Invalid argument supplied for foreach() in /home/teachkor/public_html/admin/easypopulate.php on line 690

 

 

and this is the script on line 667 : $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name);

 

and on line 690 : foreach ($readed as $read){

 

 

whats going on, how can i get the easypop to work?

 

please help thanks.

Edited by gamefuse
Link to comment
Share on other sites

Hi

 

Ive installed the easypop mod v2.76c as per the install instructions. I have added the temp folder and CHmod it to 777 also removed the extra / in the easypop.php

 

Warning: file(/home/teachkor/public_html//catalog/tempEP2006Jun02-1503.txt): failed to open stream: No such file or directory in /home/teachkor/public_html/admin/easypopulate.php on line 667

 

Warning: Invalid argument supplied for foreach() in /home/teachkor/public_html/admin/easypopulate.php on line 690

and this is the script on line 667 : $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name);

 

and on line 690 : foreach ($readed as $read){

whats going on, how can i get the easypop to work?

 

please help thanks.

 

 

hey gamefuse try this..

 

set DOCUMENT_ROOT to $DOCUMENT_ROOT in your /catalog/admin/includes/configure.php

 

define('DIR_FS_DOCUMENT_ROOT', '/hsphere/local/home/blastr/blaststore.com/');

 

in my case needed to be ,

 

define('DIR_FS_DOCUMENT_ROOT',$DOCUMENT_ROOT);

 

I also saw in the Warning: file(/home/teachkor/public_html//catalog/tempEP2006Jun02-1503.txt):

 

after public html there are 2 slashes and no slash after temp

 

this is probably caused by the

 

$tempdir = "/catalog/temp";

 

it should be,

 

$tempdir = "catalog/temp/";

 

ofcourse here I suppose you have the catalog folder as your root?

I hope that helps

Bora

Michelle, ma belle, these are scripts that go together well !!

Link to comment
Share on other sites

hey gamefuse try this..

 

set DOCUMENT_ROOT to $DOCUMENT_ROOT in your /catalog/admin/includes/configure.php

 

define('DIR_FS_DOCUMENT_ROOT', '/hsphere/local/home/blastr/blaststore.com/');

 

in my case needed to be ,

 

define('DIR_FS_DOCUMENT_ROOT',$DOCUMENT_ROOT);

 

I also saw in the Warning: file(/home/teachkor/public_html//catalog/tempEP2006Jun02-1503.txt):

 

after public html there are 2 slashes and no slash after temp

 

this is probably caused by the

 

$tempdir = "/catalog/temp";

 

it should be,

 

$tempdir = "catalog/temp/";

 

ofcourse here I suppose you have the catalog folder as your root?

I hope that helps

Bora

 

OK thanks for that Ive made the changes suggested, and this is what I get now:

 

Filename: EP2006Jun02-2311.txt

 

Warning: file(/home/teachkor/public_html/catalog/temp/EP2006Jun02-2311.txt): failed to open stream: No such file or directory in /home/teachkor/public_html/admin/easypopulate.php on line 685

 

Warning: Invalid argument supplied for foreach() in /home/teachkor/public_html/admin/easypopulate.php on line 690

 

and line 685 in easypopulate.php is : $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $localfile);

 

and line 690 is : foreach ($readed as $read){

Link to comment
Share on other sites

OK thanks for that Ive made the changes suggested, and this is what I get now:

 

Filename: EP2006Jun02-2311.txt

 

Warning: file(/home/teachkor/public_html/catalog/temp/EP2006Jun02-2311.txt): failed to open stream: No such file or directory in /home/teachkor/public_html/admin/easypopulate.php on line 685

 

Warning: Invalid argument supplied for foreach() in /home/teachkor/public_html/admin/easypopulate.php on line 690

 

and line 685 in easypopulate.php is : $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $localfile);

 

and line 690 is : foreach ($readed as $read){

 

what I see from here, "public_html/admin/easypopulate.php on line 685" Ithink you have to remove the catalog from the

 

$tempdir = "catalog/temp/";

 

so in your case ,

 

$tempdir = "temp/";

 

or

 

$tempdir = "/temp/";

 

hope that works

Bora

Michelle, ma belle, these are scripts that go together well !!

Link to comment
Share on other sites

I searched the topic a number of times, but I didn't find a relevant answer.

 

I installed the Easy Populate 2.76c release, and followed the instructions to a tee. In any event, when I go to download the complete sample file or even have it create the file in the folder, it does absolutely nothing. Internet Explorer (and Firefox), pretend they are loading by showing activity in the green bar in the bottom of the browser but do absolutely nothing.

 

Does anyone have any ideas? I'm at wits end with this and would greatly appreciate any help provided!

 

Thanks in advance! :)

Link to comment
Share on other sites

what I see from here, "public_html/admin/easypopulate.php on line 685" Ithink you have to remove the catalog from the

 

$tempdir = "catalog/temp/";

 

so in your case ,

 

$tempdir = "temp/";

 

or

 

$tempdir = "/temp/";

 

hope that works

Bora

 

 

Still no joy get this error now:

 

File uploaded.

Temporary filename: /tmp/phpZ1C2Wy

User filename: EP2006Jun03-1806.txt

Size: 24146

 

Warning: file(/home/teachkor/public_html/temp/EP2006Jun03-1806.txt): failed to open stream: No such file or directory in /home/teachkor/public_html/admin/easypopulate.php on line 667

 

Warning: Invalid argument supplied for foreach() in /home/teachkor/public_html/admin/easypopulate.php on line 690

Link to comment
Share on other sites

Hi

 

I have a onlinestore with over 5000 products. When i try to download the complete tab-delimited file using EP 2,76 i get time-out problem the page just goes on a blank. I could download it before when i only had 1000 products but now it doesnt work. I have tried other versions of EP but some doesnt have all the fields i need. I need all the fields that i get with EP 2,76. I'm in desperat need of help and what to do. I'm not that great with sql so in detail help would be very appreciated.

 

Thx in advance

Link to comment
Share on other sites

I installed the Easy Populate 2.76c release, and followed the instructions to a tee. In any event, when I go to download the complete sample file or even have it create the file in the folder, it does absolutely nothing. Internet Explorer (and Firefox), pretend they are loading by showing activity in the green bar in the bottom of the browser but do absolutely nothing.

 

I'm having exactly the same problem. Surely, there must be an answer to this!

Link to comment
Share on other sites

Brewski: I have the same problem. I have 23,000 items to upload and I discovered that my ISP is the one terminating the SQL update as a timeout, even though there are no error (or other) messages. I use www.1and1.com and they have escelated the issue and will let me know of a resolution.

It cannot be an EP problem, because all EP does is simply loop on the upload file inserting/updating each item until it reaches the end.

I finally split the file into 6,000 items and it uploaded successfully

 

I also added the index to products, which increased the insertion from several hours to about 4 minutes for 5k items. Here is the SQL command you can run from the SQL admin:

 

ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );

 

Note the backticks ` not the normal single quote ' and observe the spaces as shown.

Link to comment
Share on other sites

Still having problems with this contrib.

 

When I DL the contrib there is no SQL file in the package, and I am unable to find it in the readme or anything.

 

DL Version: EP_v2_76c_MS2

 

I have a thought that this might be my problem as when uploading a file I just get:

--------------

File uploaded.

Temporary filename: /tmp/phpCeA2CV

User filename: EP2006Jun05-1212.txt

Size: 385

--------------

 

I can dl the files ok, but when editing them and just changing something as small as the title then uploading the changes are not implemented.

 

Any help with this appreciated.

Link to comment
Share on other sites

videobus i dont have problem uploading i only have problem to download the complete file because it times out. Is there a way to split the downloaded file so it doesnt try to download everything into one file?

Link to comment
Share on other sites

videobus i dont have problem uploading i only have problem to download the complete file because it times out. Is there a way to split the downloaded file so it doesnt try to download everything into one file?

 

Have you tried sending the file to the temp folder on your server and then downloading it?

Edited by jackrabbit
Link to comment
Share on other sites

I have a thought that this might be my problem as when uploading a file I just get:

--------------

File uploaded.

Temporary filename: /tmp/phpCeA2CV

User filename: EP2006Jun05-1212.txt

Size: 385

--------------

 

I get this too. I recently upgraded to PHP5. I have a website I setup about a year ago and EP still works on the same server, but on my most recent site EP fails to work. Not sure why... only differences that I can think of are that the EP version is newer, and the osc version is newer (update 051113). Anyone know what's wrong?

Link to comment
Share on other sites

Is there a field size limit to csv files? All of my big descriptions are getting cut off. I'm pretty sure they're all getting cut off at the same spot, which would mean there is a limit, or it's some other thing. Anyone know?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...