Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

Im having a problem uploading Model/Price/Qty txt files after they are downloaded with EasyPopulate in the first place. I make 1 change to a price to see if it works and it doesnt change anything... Here's the error:

I have a few mods installed including Some 6 image mod with htmlarea, Linkmatics Attribute Sets, Who's Online Enhancement, Skype Us mod, CVV mod, plus a couple of others that i cant remember right now...

 

Anyone got any ideas? It's not tab based, not eoreor based, not permissions based or any of those other simple solutions... would a Windows Server be at fault here? Im so sick of them now, im changing to Linux at the next problem that arises...

 

in your EP file, search for the line were there is the INSERT

 

there is a problem next to your product_image_med: there is a double quote missing.

check also next to the product model, there is probably a quote missing.

 

here is how the match between the fields and values looks like when itemized

 

FIELDS

products_image
products_image_med
products_image_lrg
products_image_sm_1
products_image_xl_1
products_image_sm_2
products_image_xl_2
products_image_sm_3
products_image_xl_3
products_image_sm_4
products_image_xl_4
products_image_sm_5
products_image_xl_5
products_image_sm_6
products_image_xl_6
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)

VALUE

''
"
""
""
""
""
""
""
""
""
""
""
""
""
""
" '111113'
'10.95'
'1'
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP
NULL
''
''
'1000'
'NULL')

Share this post


Link to post
Share on other sites

I am trying out the Easy Populate Contribution. In fact, I setup a test site specifially for this, and I am only using the products in the default store.

 

When I download to my local computer it works great. However, after making a few changes in the file on my computer (I changed a couple of movie names and a model number), the changes don't upload.

 

I DO NOT get an error message. It looks like it works fine.

 

If I go into oscommerce calalog and make changes, again, they download fine. It's just no upload changes show up.

 

Any ideas what I did wrong.


Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Share this post


Link to post
Share on other sites
post your data file here. best to use two or three products when doing the initial testing.

 

Here is the test file I used. I changed the move "The Matrix" to "The Matrix TEST" and I changed its number to "DVD_TEST." Although I got no error message, the changes didn't upload. These are the default products in the oscommerce setup. I set it up just to test things

 

 

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_tax_class_title v_statusEP_DELIMITE EOREOR

MG200MMS matrox/mg200mms.gif Matrox G200 MMS "Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series: the first graphics card ever to support up to four DVI digital flat panel displays on a single 8&quot: PCI board.<br><br>With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs.<br><br>Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD." www.matrox.com/mga/products/g200_mms/home.cfm 23 0000-00-00 00:00:00 9/11/2006 11:18 32 Matrox Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

MG400-32MB matrox/mg400-32mb.gif Matrox G400 32MB "<b>Dramatically Different High Performance Graphics</b><br><br>Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry's fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC's arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer.<br><br><b>Key features:</b><ul><li>New Matrox G400 256-bit DualBus graphics chip</li><li>Explosive 3D, 2D and DVD performance</li><li>DualHead Display</li><li>Superior DVD and TV output</li><li>3D Environment-Mapped Bump Mapping</li><li>Vibrant Color Quality rendering </li><li>UltraSharp DAC of up to 360 MHz</li><li>3D Rendering Array Processor</li><li>Support for 16 or 32 MB of memory</li></ul>" www.matrox.com/mga/products/mill_g400/home.htm 23 0000-00-00 00:00:00 9/11/2006 11:18 32 Matrox Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

MSIMPRO microsoft/msimpro.gif Microsoft IntelliMouse Pro "Every element of IntelliMouse Pro - from its unique arched shape to the texture of the rubber grip around its base - is the product of extensive customer and ergonomic research. Microsoft's popular wheel control, which now allows zooming and universal scrolling functions, gives IntelliMouse Pro outstanding comfort and efficiency." www.microsoft.com/hardware/mouse/intellimouse.asp 7 0000-00-00 00:00:00 9/11/2006 11:18 2 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-RPMK dvd/replacement_killers.gif The Replacement Killers "Regional Code: 2 (Japan, Europe, Middle East, South Africa).<br>Languages: English, Deutsch.<br>Subtitles: English, Deutsch, Spanish.<br>Audio: Dolby Surround 5.1.<br>Picture Format: 16:9 Wide-Screen.<br>Length: (approx) 80 minutes.<br>Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." www.replacement-killers.com 23 0000-00-00 00:00:00 9/11/2006 11:18 13 Microsoft Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-BLDRNDC dvd/blade_runner.gif Blade Runner - Director's Cut "Regional Code: 2 (Japan, Europe, Middle East, South Africa).<br>Languages: English, Deutsch.<br>Subtitles: English, Deutsch, Spanish.<br>Audio: Dolby Surround 5.1.<br>Picture Format: 16:9 Wide-Screen.<br>Length: (approx) 112 minutes.<br>Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." www.bladerunner.com 7 0000-00-00 00:00:00 9/11/2006 11:18 17 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-TEST dvd/the_matrix.gif The Matrix TEST "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch. <br> Audio: Dolby Surround. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 131 minutes. <br> Other: Interactive Menus, Chapter Selection, Making Of." www.thematrix.com 7 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-YGEM dvd/youve_got_mail.gif You've Got Mail "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch, Spanish. <br> Subtitles: English, Deutsch, Spanish, French, Nordic, Polish. <br> Audio: Dolby Digital 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 115 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." www.youvegotmail.com 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-ABUG dvd/a_bugs_life.gif A Bug's Life "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Digital 5.1 / Dobly Surround Stereo. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 91 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." www.abugslife.com 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-UNSG dvd/under_siege.gif Under Siege "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 98 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-UNSG2 dvd/under_siege2.gif Under Siege 2 - Dark Territory "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 98 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-FDBL dvd/fire_down_below.gif Fire Down Below "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 100 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-DHWV dvd/die_hard_3.gif Die Hard With A Vengeance "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 122 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Fox Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-LTWP dvd/lethal_weapon.gif Lethal Weapon "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 100 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-REDC dvd/red_corner.gif Red Corner "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 117 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-FRAN dvd/frantic.gif Frantic "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 115 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-CUFI dvd/courage_under_fire.gif Courage Under Fire "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 112 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Fox Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-SPEED dvd/speed.gif Speed "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 112 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Fox Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-SPEED2 dvd/speed_2.gif Speed 2: Cruise Control "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 120 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Fox Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-TSAB dvd/theres_something_about_mary.gif There's Something About Mary "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 114 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Fox Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

DVD-BELOVED dvd/beloved.gif Beloved "Regional Code: 2 (Japan, Europe, Middle East, South Africa). <br> Languages: English, Deutsch. <br> Subtitles: English, Deutsch, Spanish. <br> Audio: Dolby Surround 5.1. <br> Picture Format: 16:9 Wide-Screen. <br> Length: (approx) 164 minutes. <br> Other: Interactive Menus, Chapter Selection, Subtitles (more languages)." 7 0000-00-00 00:00:00 9/11/2006 11:18 10 Warner Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

PC-SWAT3 sierra/swat_3.gif SWAT 3: Close Quarters Battle "<b>Windows 95/98</b><br><br>211 in progress with shots fired. Officer down. Armed suspects with hostages. Respond Code 3! Los Angles, 2005, In the next seven days, representatives from every nation around the world will converge on Las Angles to witness the signing of the United Nations Nuclear Abolishment Treaty. The protection of these dignitaries falls on the shoulders of one organization, LAPD SWAT. As part of this elite tactical organization, you and your team have the weapons and all the training necessary to protect, to serve, and ""When needed"" to use deadly force to keep the peace. It takes more than weapons to make it through each mission. Your arsenal includes C2 charges, flashbangs, tactical grenades. opti-Wand mini-video cameras, and other devices critical to meeting your objectives and keeping your men free of injury. Uncompromised Duty, Honor and Valor!" www.swat3.com 7 0000-00-00 00:00:00 9/11/2006 11:18 16 Sierra Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

PC-UNTM gt_interactive/unreal_tournament.gif Unreal Tournament "From the creators of the best-selling Unreal, comes Unreal Tournament. A new kind of single player experience. A ruthless multiplayer revolution.<br><br>This stand-alone game showcases completely new team-based gameplay, groundbreaking multi-faceted single player action or dynamic multi-player mayhem. It's a fight to the finish for the title of Unreal Grand Master in the gladiatorial arena. A single player experience like no other! Guide your team of 'bots' (virtual teamates) against the hardest criminals in the galaxy for the ultimate title - the Unreal Grand Master." www.unrealtournament.net 7 0000-00-00 00:00:00 9/11/2006 11:18 13 GT Interactive Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

PC-TWOF gt_interactive/wheel_of_time.gif The Wheel Of Time "The world in which The Wheel of Time takes place is lifted directly out of Jordan's pages: it's huge and consists of many different environments. How you navigate the world will depend largely on which game - single player or multipayer - you're playing. The single player experience, with a few exceptions, will see Elayna traversing the world mainly by foot (with a couple notable exceptions). In the multiplayer experience, your character will have more access to travel via Ter'angreal, Portal Stones, and the Ways. However you move around, though, you'll quickly discover that means of locomotion can easily become the least of the your worries...<br><br>During your travels, you quickly discover that four locations are crucial to your success in the game. Not surprisingly, these locations are the homes of The Wheel of Time's main characters. Some of these places are ripped directly from the pages of Jordan's books, made flesh with Legend's unparalleled pixel-pushing ways. Other places are specific to the game, conceived and executed with the intent of expanding this game world even further. Either way, they provide a backdrop for some of the most intense first person action and strategy you'll have this year." www.wheeloftime.com 10 0000-00-00 00:00:00 9/11/2006 11:18 16 GT Interactive Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

PC-DISC gt_interactive/disciples.gif Disciples: Sacred Lands "A new age is dawning...<br><br>Enter the realm of the Sacred Lands, where the dawn of a New Age has set in motion the most momentous of wars. As the prophecies long foretold, four races now clash with swords and sorcery in a desperate bid to control the destiny of their gods. Take on the quest as a champion of the Empire, the Mountain Clans, the Legions of the Damned, or the Undead Hordes and test your faith in battles of brute force, spellbinding magic and acts of guile. Slay demons, vanquish giants and combat merciless forces of the dead and undead. But to ensure the salvation of your god, the hero within must evolve.<br><br>The day of reckoning has come... and only the chosen will survive." 8 0000-00-00 00:00:00 9/11/2006 11:18 17 GT Interactive Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

MSINTKB microsoft/intkeyboardps2.gif Microsoft Internet Keyboard PS/2 "The Internet Keyboard has 10 Hot Keys on a comfortable standard keyboard design that also includes a detachable palm rest. The Hot Keys allow you to browse the web, or check e-mail directly from your keyboard. The IntelliType Pro software also allows you to customize your hot keys - make the Internet Keyboard work the way you want it to!" 8 0000-00-00 00:00:00 9/11/2006 11:18 15 Microsoft Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

MSIMEXP microsoft/imexplorer.gif Microsoft IntelliMouse Explorer "Microsoft introduces its most advanced mouse, the IntelliMouse Explorer! IntelliMouse Explorer features a sleek design, an industrial-silver finish, a glowing red underside and taillight, creating a style and look unlike any other mouse. IntelliMouse Explorer combines the accuracy and reliability of Microsoft IntelliEye optical tracking technology, the convenience of two new customizable function buttons, the efficiency of the scrolling wheel and the comfort of expert ergonomic design. All these great features make this the best mouse for the PC!" www.microsoft.com/hardware/mouse/explorer.asp 8 0000-00-00 00:00:00 9/11/2006 11:18 10 Microsoft Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR

HPLJ1100XI hewlett_packard/lj1100xi.gif Hewlett Packard LaserJet 1100Xi "HP has always set the pace in laser printing technology. The new generation HP LaserJet 1100 series sets another impressive pace, delivering a stunning 8 pages per minute print speed. The 600 dpi print resolution with HP's Resolution Enhancement technology (REt) makes every document more professional.<br><br>Enhanced print speed and laser quality results are just the beginning. With 2MB standard memory, HP LaserJet 1100xi users will be able to print increasingly complex pages. Memory can be increased to 18MB to tackle even more complex documents with ease. The HP LaserJet 1100xi supports key operating systems including Windows 3.1, 3.11, 95, 98, NT 4.0, OS/2 and DOS. Network compatibility available via the optional HP JetDirect External Print Servers.<br><br>HP LaserJet 1100xi also features The Document Builder for the Web Era from Trellix Corp. (featuring software to create Web documents)." www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 45 0000-00-00 00:00:00 9/11/2006 11:18 8 Hewlett Packard Taxable Goods EP_STATUS_ACTIVEEP_DELIMITE EOREOR


Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Share this post


Link to post
Share on other sites

The tabs don't show up, but there are tabs in it.

 

Is there a better way to get it to you?


Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Share this post


Link to post
Share on other sites

you don't have a delimiter in your EP

 

could you post your easypopulate.php file BEGINNING (just the first 100 lines)

 

Thanks

Edited by pixclinic

Share this post


Link to post
Share on other sites

i wonder if anybody can point me in the right direction.

 

i'm very inexperienced with php, but i can appreciate how awesome this module is (because i was updating OS commerce by hand and i was looking for a way to do it with a spreadsheet). this module is great. i've managed to get it to work uploading a file and all the products (text) show. however, i've got broken links to all the images. i've been looking everywhere to see if there is a path to set for the images in the config file? also, i;ve uploaded all the images to the "temp" dir in the root, but they;re not being picked out

 

if anybody could le tme know where the images should go by default, or where the path to the images dir is so i can edit it i will be most pleased.

 

thanks again for this great work

jg

:D

Share this post


Link to post
Share on other sites
i wonder if anybody can point me in the right direction.

 

i'm very inexperienced with php, but i can appreciate how awesome this module is (because i was updating OS commerce by hand and i was looking for a way to do it with a spreadsheet). this module is great. i've managed to get it to work uploading a file and all the products (text) show. however, i've got broken links to all the images. i've been looking everywhere to see if there is a path to set for the images in the config file? also, i;ve uploaded all the images to the "temp" dir in the root, but they;re not being picked out

 

if anybody could le tme know where the images should go by default, or where the path to the images dir is so i can edit it i will be most pleased.

 

thanks again for this great work

jg

:D

 

your images must be upoaded in the catalog/images folder, NOT IN THE TEMP!

and in your flat file, just the image name, like thepicture.jpg, not images/thepicture.jpg

Edited by pixclinic

Share this post


Link to post
Share on other sites
you don't have a delimiter in your EP

 

could you post your easypopulate.php file BEGINNING (just the first 100 lines)

 

Thanks

 

When the file comes down, I get "EP_DELIMITER" throughout. I needed to take those out in order to load it correctly into Excel. I then saved the file as TAB Delimited.

 

Should I replace them?

 

I haven't touched the easypopluate.php file which I downloaded just last night, so the problem should not be in there. But if you need it to help me, I'll post it.

 

Thank you for helping me.


Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Share this post


Link to post
Share on other sites
When the file comes down, I get "EP_DELIMITER" throughout. I needed to take those out in order to load it correctly into Excel. I then saved the file as TAB Delimited.

 

Should I replace them?

 

I haven't touched the easypopluate.php file which I downloaded just last night, so the problem should not be in there. But if you need it to help me, I'll post it.

 

Thank you for helping me.

 

That's what I asked, I need to see the 100 first lines of your EP file.

Share this post


Link to post
Share on other sites
That's what I asked, I need to see the 100 first lines of your EP file.

 

 

Here it is:

 

<?php

// Current EP Version
$curver = '2.90';

/*
 $Id: easypopulate.php,v 2.90 2006/04/14 Davide Duca @ www.eurobigstore.com

*/

require('includes/application_top.php');

//**** File Splitting Configuration ****
// we attempt to set the timeout limit longer for this script to avoid having to split the files
// NOTE:  If your server is running in safe mode, this setting cannot override the timeout set in php.ini
if (EP_SET_TIME_LIMIT == 'true') {set_time_limit(330);}

//**** Size of products_model in products table ****
// This is automatically set to the maximum defined size of products_model in the products table.  We check to make sure all models are no longer than this value.
global $modelsize;
$table_definition_query=tep_db_query("describe " . TABLE_PRODUCTS);
while ($product_definition=tep_db_fetch_array($table_definition_query)){
  if ($product_definition[Field]=='products_model'){
 if (substr($product_definition[Type],0,7)=='varchar'){
   $modelsize=substr($product_definition[Type],8,strlen($product_definition[Type]));
   $modelsize=substr($modelsize,0,(strlen($modelsize)-1));
 }
  }
}
//**** Price includes tax? ****
global $price_with_tax;
$price_with_tax = (EP_PRICE_INC_TAX =='true' ? 1 : 0);

global $separator;
if (EP_DELIMITER == '\t') {
 $separator = "\t"; // oscommerce stores escaped delimeters in mySQL as a string and not an actual tab.
} else {
$separator = EP_DELIMITER;
}

// change this if you want to download selected product options
// this might be handy, if you have a lot of product options, and your output file exceeds 256 columns (which is the max. limit MS Excel is able to handle)
global $attribute_options_select;
//$attribute_options_select = array('Size', 'Model'); // uncomment and fill with product options name you wish to download // comment this line, if you wish to download all product options
// VJ product attributes end

//*******************************
// If you are running a pre-Nov1-2002 snapshot of OSC, then we need this include line to avoid
// errors like:
//   undefined function tep_get_uploaded_file
if (!function_exists(tep_get_uploaded_file)){
	include (DIR_WS_FUNCTIONS . 'easypopulate_functions.php');
}
//*******************************

// VJ product attributes begin
global $attribute_options_array;
$attribute_options_array = array();

if (EP_PROD_ATTR == 'true') {
	if (is_array($attribute_options_select) && (count($attribute_options_select) > 0)) {
			foreach ($attribute_options_select as $value) {
					$attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " where products_options_name = '" . $value . "'";

					$attribute_options_values = tep_db_query($attribute_options_query);

					if ($attribute_options = tep_db_fetch_array($attribute_options_values)){
							$attribute_options_array[] = array('products_options_id' => $attribute_options['products_options_id']);
					}
			}
	} else {
			$attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_id";

			$attribute_options_values = tep_db_query($attribute_options_query);

			while ($attribute_options = tep_db_fetch_array($attribute_options_values)){
					$attribute_options_array[] = array('products_options_id' => $attribute_options['products_options_id']);
			}
	}
}
// VJ product attributes end

global $filelayout, $filelayout_count, $filelayout_sql, $langcode, $fileheaders;

// these are the fields that will be defaulted to the current values in the database if they are not found in the incoming file
global $default_these;
$default_these = array(
	'v_products_image',
	#'v_products_dim_type',
	#'v_products_length',
	#'v_products_width',
	#'v_products_height',
	#'v_products_mimage',
	#'v_products_bimage',
	#'v_products_subimage1',
	#'v_products_bsubimage1',
	#'v_products_subimage2',
	#'v_products_bsubimage2',
	#'v_products_subimage3',
	'v_categories_id',
	'v_specials_price',
	'v_specials_date_avail',
	'v_specials_expires_date',
	'v_products_price',
	'products_price1',
	'products_price2',
	'products_price3',
	'products_price4',
	'products_price5',
	'products_price6',
	'products_price7',
	'products_price8',
	'products_price1_qty',
	'products_price2_qty',
	'products_price3_qty',
	'products_price4_qty',
	'products_price5_qty',
	'products_price6_qty',
	'products_price7_qty',
	'products_price8_qty',
	'products_qty_blocks',
	'v_products_quantity',
	'v_products_weight',
	'v_date_avail',
	'v_instock',
	'v_tax_class_title',
	'v_manufacturers_name',
	'v_manufacturers_id',
	'v_products_dim_type',
	'v_products_length',
	'v_products_width',
	'v_products_height',
	);

//elari check default language_id from configuration table DEFAULT_LANGUAGE


Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Share this post


Link to post
Share on other sites

there we go

 

look for

 

global $separator;
if (EP_DELIMITER == '\t') {
 $separator = "\t"; // oscommerce stores escaped delimeters in mySQL as a string and not an actual tab.
} else {
$separator = EP_DELIMITER;
}

 

and replace it by:

 

global $separator;
$separator = "\t"; // oscommerce stores escaped delimeters in mySQL as a string and not an actual tab.

 

that should do it

Share this post


Link to post
Share on other sites

Thank you, that came down absolutely perfect and I didn't have to replace EP_DELIMITER.

 

Trying to upload changes .... I am going from temp directory... I get the following error:

 

User filename: EP2006Sep18-1806.txt

 

Warning: file(/hsphere/local/home/netkraft/shelburnefallsdelivers.com/EP_TEMP_DIREP2006Sep18-1806.txt): failed to open stream: No such file or directory in /hsphere/local/home/netkraft/shelburnefallsdelivers.com/admin/easypopulate.php on line 732

 

Warning: Invalid argument supplied for foreach() in /hsphere/local/home/netkraft/shelburnefallsdelivers.com/admin/easypopulate.php on line 7

 

The temp directory is there. The file is there. And they are both 777.


Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Share this post


Link to post
Share on other sites
Thank you, that came down absolutely perfect and I didn't have to replace EP_DELIMITER.

 

Trying to upload changes .... I am going from temp directory... I get the following error:

 

User filename: EP2006Sep18-1806.txt

 

Warning: file(/hsphere/local/home/netkraft/shelburnefallsdelivers.com/EP_TEMP_DIREP2006Sep18-1806.txt): failed to open stream: No such file or directory in /hsphere/local/home/netkraft/shelburnefallsdelivers.com/admin/easypopulate.php on line 732

 

Warning: Invalid argument supplied for foreach() in /hsphere/local/home/netkraft/shelburnefallsdelivers.com/admin/easypopulate.php on line 7

 

The temp directory is there. The file is there. And they are both 777.

 

It looks like you haven't installed your language files correctly (and that would make sense because what I did with your previous post was just a dirty fix - not calling the language file) but this time, you will have to go back to the install instructions and check that you have installed the easypopulate.php language file in the admin section and not the catalog section (common mistake)

 

if the installation instructions don;t mention a language file, then just add to your admin>includes>english.php the following, before the last ?>

 

define ('EP_TEMP_DIR', 'temp');

 

where temp is the exact name of your directory

Edited by pixclinic

Share this post


Link to post
Share on other sites

This just worked for me (using EP2.75a). Just thought I say thanks and give it a bump. This thread is huge.

 

I was having the same problem and found it was because I was running PHP version 5.. I found this FIX in this topic but not really talked about a lot it worked for me!

First check to see what version of PHP 5 you are running.

 

If you're not sure, go to admin > tools > server info ...php version # will be at the top.

 

I suspect it's PHP5.

 

IF THAT IS THE CASE,

 

In your easypopulate.php file

 

Find

 

array_walk($readed, 'walk');

 

replace with this

 

//array_walk($readed, 'walk');

foreach ($readed as $readed_record) {

walk($readed_record);

}

 

If it's NOT php5, don't change anything at this point.

I really can't rember who the post came from because I have been working on this site for two weeks straight with VARY little sleep! Sorry

 

ADAM

Share this post


Link to post
Share on other sites

Right here we go! Apologies if this solution is somewhere in the 'easypopulate thread' but i have trawled it and can't find a thing.

 

I'm using EP 2.76 - i've installed it with no errors. I have a temp directory with all the relevant permissions (777). When i go to admin and try to download an EP file like 'Download Complete tab-delimited .txt file to edit' i get nothing - in fact i get nothing from any of the download links. No errors - nothing.

 

I've tried uploading the sample file but i get nothing again (no errors) - the page just refreshes.

 

I'm obviously missing something simple but i can't for the life of me work out what it is.

 

Can anyone help - it's driving me mad.

 

Many thanks

 

Mike

Share this post


Link to post
Share on other sites

post your configure.php file, also what your temp file setting is in your easypopulate.php file, what version of php you are using.

 

Right here we go! Apologies if this solution is somewhere in the 'easypopulate thread' but i have trawled it and can't find a thing.

 

I'm using EP 2.76 - i've installed it with no errors. I have a temp directory with all the relevant permissions (777). When i go to admin and try to download an EP file like 'Download Complete tab-delimited .txt file to edit' i get nothing - in fact i get nothing from any of the download links. No errors - nothing.

 

I've tried uploading the sample file but i get nothing again (no errors) - the page just refreshes.

 

I'm obviously missing something simple but i can't for the life of me work out what it is.

 

Can anyone help - it's driving me mad.

 

Many thanks

 

Mike

Share this post


Link to post
Share on other sites

I am also having the exact same problem of nothing happening when trying to use easy populate. I have read previous posts and made all the changes I could find. I am using WAMP5 under WindowsXP. I did make the PHP5 changes mentioned in the easypopulate.php file. Is anyone else having this problem using WAMP5 for Apache, MySQL and PHP?

 

Here is the top part of the configure.php. This is on a local machine.

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://localhost'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://localhost');

define('HTTPS_CATALOG_SERVER', '');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where the pages are located on the server

define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN); // absolute pate required

define('DIR_WS_CATALOG', '/catalog/'); // absolute path required

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); // absolute path required

define('DIR_WS_IMAGES', 'images/');

..................

DB server is set to 'localhost'

 

Thanks

Share this post


Link to post
Share on other sites
Right here we go! Apologies if this solution is somewhere in the 'easypopulate thread' but i have trawled it and can't find a thing.

 

I'm using EP 2.76 - i've installed it with no errors. I have a temp directory with all the relevant permissions (777). When i go to admin and try to download an EP file like 'Download Complete tab-delimited .txt file to edit' i get nothing - in fact i get nothing from any of the download links. No errors - nothing.

 

I've tried uploading the sample file but i get nothing again (no errors) - the page just refreshes.

 

I'm obviously missing something simple but i can't for the life of me work out what it is.

 

Can anyone help - it's driving me mad.

 

Many thanks

 

Mike

 

I am having the same problem. Same version...on a UNIX machine.. the only thing I modified was subimage1 - 6... I haven't tried to upload yet..but I can't download from any of the links, it just refreshes the page. I even turned off attributes (code below) even though I use QT PRO because someone on here said attributes might be the problem. I have almost 200 products in my store.

 

// change this to false, if do not want to download product attributes
global $products_with_attributes;
$products_with_attributes = false; 

// change this to true, if you use QTYpro and want to set attributes stock with EP.
global $products_attributes_stock;
$products_attributes_stock = false;

Share this post


Link to post
Share on other sites

I'm thinking this has to do with the temp directory variables if using oscommece on a local machine. In a book on oscommerce, the author says he had to change the temp directory to "temp/"; (removed leading forward slash), in order to get easypopulate to work for him. I've tried a number of changes to the temp variable with no luck. I'm curious if the variable $DOCUMENT_ROOT should be used in configure.php if testing on a local machine.

If anyone has had luck with easypopulate using PHP5 on a local machine, please post your configure.php file and let us know if you made changes to the default temp variable.

 

Thanks

Share this post


Link to post
Share on other sites

Hi All,

I'm running the EP 2.76c. It works great except for it places the price in the wrong field. It places into the Gross field and not the Net.

 

Have I done something wrong or is this a known issue

thanx

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×