EasyPopulate 4.0 Support Thread

mc12345678:

Ahh, now I understand the situation. For EP4 to know where the folder is now located, it must be entered/changed in the configuration section for EP4. Now that the folder temp has been renamed to say papa AND moved to the secret admin directory, the data in the field should reflect what it takes to get from the store's directory to the folder in the secret admin. So if the admin directory is for example named storeadmin and the papa folder is inside there then the path that should be entered in the configuration area is storeadmin/papa.

So if 'store' is your admin directory, then it should be renamed as it is/was posted here for all to see.

I finally have it working thanks for your help, this will help me tremendously, I will rename the directory now, hopefully nothing changes after I do so.

I am using EP4 in a 1.5.3 site. Using Open Office and comma delimited... Saving as a CSV file. Upload and import. Getting the following error for all products: No model field in record. This line was not imported. Attaching csv file for you to see.
Thanks for any help you can give me....
~anne

Records are not saved correctly...

Each column (v_products_model for example) is not properly delimited...

Right now everything is separated by a tab, and instead of a double quote, the text is surrounded by a single quote. These differences cause issues for the upload.

What seems like the "easy" way to correct the example that was uploaded is to open the file, selecting:
Character Set: Unicode (UTF-8) seemed to work
Language: Default - English (USA)
From row: 1
separated by: Tab
With Text Delimiter as the single quote.
Checkbox for Quoted field as text marked.
No other indicators.

Then, the first column will have a " at the beginning of each cell which should be removed.
The values in the v_products_name_1 column should have extra spaces removed (LL. Bean bag-Small for example)
The last column has extra data at the end of each row for that column. (",,,) Those could be mass removed with a search and replace..

Then once all of the issues have been corrected perform a save as: file type: Test CSV (.csv) (*.csv)
check the checkbox for Edit filter settings. Select Save and then in the questions asked save it the following way:
Character Set: Unicode (UTF-8)
Field delimiter: , (comma)
Text delimiter: " (double quote)
I set it to Quote all text cells and Save cell content as shown, but wasn't sure about the quote all text cells. I believe chadderuski had some good guidance about how to save the file(s).

The above "directions" are from working with Open Office Version 4.1.1.

Thanks! I will try this tomorrow.

stellarweb:

So I set up an admin area in a separate folder that ties into the current database and EP works fine! Not the greatest solution, I am sure, but the best I know of for now until USU gets updated.

I have the exact same problem. Please help as I have no idea how to do what you described.

Tried removing and reinstalling easy populate with no luck. I am using ZC 1.53

keith z:

I have the exact same problem. Please help as I have no idea how to do what you described.

Tried removing and reinstalling easy populate with no luck. I am using ZC 1.53

Please see this post: http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1260554#post1260554

The issue is not fully/properly incorporating USU into the store. There are instructions on how to do that. The solution offered above was to create a new admin subdirectory with all of the same configure.php settings, but only offering EP4 in that admin directory.

hi

i want upload a description data with easy populate

i can use i file whit simple file csv with fileds: v_products_model and v_products_description_2 ???

i have a error and dont possible atachement csv file!!! where is the error log of easy populATE4 ??

THANKS

salvo72:

hi

i want upload a description data with easy populate

i can use i file whit simple file csv with fileds: v_products_model and v_products_description_2 ???

i have a error and dont possible atachement csv file!!! where is the error log of easy populATE4 ??

THANKS

Errors captured/documented by EP4 are in an errorlog listed in the files to be imported/downloaded. New errors are added to the end of the file. If this file has been in the file list for a long time it may contain multiple errors that do not relate to the current issue.

Btw, I am not entirely sure that the code currently supports only a total of two columns being in the upload file. I would have to look to see what changes might be necessary to support that.

Hi, I have installed EP4 on a 1.5.3 zencart site. I have noticed I get the following when using this add-on

"An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer"

When I check my logs folder, the error is as follows.
"[29-Nov-2014 16:01:47 Europe/London] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/izzy/public_html/ZC153-test5/renamedaddy/easypopulate_4_import.php on line 881"

I don't know what I have done wrong :(
I do not get this error on a 1.5.1 site.

All help appreciated!

izzysoup:

Hi, I have installed EP4 on a 1.5.3 zencart site. I have noticed I get the following when using this add-on

"An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer"

When I check my logs folder, the error is as follows.
"[29-Nov-2014 16:01:47 Europe/London] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/izzy/public_html/ZC153-test5/renamedaddy/easypopulate_4_import.php on line 881"

I don't know what I have done wrong :(
I do not get this error on a 1.5.1 site.

All help appreciated!

Which ver of EP4 was installed on ZC 1.53 and what plugins are also installed on the ZC site?

I also was having the language error

EP4 FATAL ERROR: No default language set.

and followed the posts here looking for the fix. The quote below didnt really explain to me how it was done. BUT overwriting the query_factory.php file with the default 1.5.3 file worked. I will just replace it with the SEO one later but Im posting here to perhaps ask how the below method works exactly? Is it an entire extra ZC install or just an extra admin folder? I tried an extra admin folder with default ZC 1.5.3 files but that didnt work for me.

Perhaps the fix can come from within the query_factory.php file ?

Im also running 1.5.3 and USU and EP4.

stellarweb:

Happy dance! The site has Ultimate SEO URL's installed and one of the files includes/classes/db/mysql/query_factory.php is what was causing the problem. Unfortunately, since this mod has not been updated yet for 1.5.3, I have to use that file for the USU to work. So I set up an admin area in a separate folder that ties into the current database and EP works fine! Not the greatest solution, I am sure, but the best I know of for now until USU gets updated.

Chargin:

I also was having the language error

EP4 FATAL ERROR: No default language set.

and followed the posts here looking for the fix. The quote below didnt really explain to me how it was done. BUT overwriting the query_factory.php file with the default 1.5.3 file worked. I will just replace it with the SEO one later but Im posting here to perhaps ask how the below method works exactly? Is it an entire extra ZC install or just an extra admin folder? I tried an extra admin folder with default ZC 1.5.3 files but that didnt work for me.

Perhaps the fix can come from within the query_factory.php file ?

Im also running 1.5.3 and USU and EP4.

The proper fix is to install USU correctlly... Core files and overrides should be 1) compared against default versions of the version used in the plugin. 2) those changes should be incorporated into the store's 1.5.3 version of the file(s).

As for the separate admin directory, if the file that is an issue truly is includes/classes/db/mysql/query_factory.php then it would require a separate install of the entire fileset with the daatabase pointing to the same as thelive store.

Also, I thought that in this thread which is about how EP4 operates and how to install it (not how to install other plugins) there were some links to posts in the USU thread to resolve this issue, ie. One was to a set of files modified/incorporating the ZC 1.5.3 changes. BTW, while whatever file is replaced with the default ZC 1.5.3 version, how functional is the site? Any issues?

Some of the below links apply:
Diva Vocal's summary on the issue: http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1260554&highlight=ultimate#post1260554
Mc12345678 response to a similar question with a link to USU where an "updated" set of files for ZC 1.5.3 was posted on the USU thread: http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1260149#post1260149
Mc12345678 post on USU with files merged for ZC 1.5.3: http://www.zen-cart.com/showthread.php?199064-Ultimate-SEO-2-200-%28new-features%29-Support-Thread&p=1260148#post1260148

Hi, thanks for your reply.
In answer to your question about how the site worked with the 1.5.1 version of query_factory.php that is included in USU, it works to a point, clicking products gives a page not found and I didnt do much to test it, I havent added new products for example. No errors popup at least. Replacing the query_factory.php file with 1.5.3 version and it all works again.

I tried the files you linked to but I do still have the language error. query_factory.php is very different from 1.5.3 to the USU 1.5.1 version, I compared the 2 and its vast. Seems to me the fix would be within changes to that file? The zip linked from your post replaced a few other files but not query_factory.php.

Looking at the differences between the standard 1.5.1 version and the modified for USU 1.5.1 version theres not much difference, more than I could edit with my php knowledge though. Ill ask if perhaps the author can supply a 1.5.3 version of that file.

mc12345678:

The proper fix is to install USU correctlly... Core files and overrides should be 1) compared against default versions of the version used in the plugin. 2) those changes should be incorporated into the store's 1.5.3 version of the file(s).

As for the separate admin directory, if the file that is an issue truly is includes/classes/db/mysql/query_factory.php then it would require a separate install of the entire fileset with the daatabase pointing to the same as thelive store.

Also, I thought that in this thread which is about how EP4 operates and how to install it (not how to install other plugins) there were some links to posts in the USU thread to resolve this issue, ie. One was to a set of files modified/incorporating the ZC 1.5.3 changes. BTW, while whatever file is replaced with the default ZC 1.5.3 version, how functional is the site? Any issues?

Some of the below links apply:
Diva Vocal's summary on the issue: http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1260554&highlight=ultimate#post1260554
Mc12345678 response to a similar question with a link to USU where an "updated" set of files for ZC 1.5.3 was posted on the USU thread: http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1260149#post1260149
Mc12345678 post on USU with files merged for ZC 1.5.3: http://www.zen-cart.com/showthread.php?199064-Ultimate-SEO-2-200-%28new-features%29-Support-Thread&p=1260148#post1260148

Hi, hoping someone will be able to help. I am using v1.5.3 of zen and EasyPop v4.
My file is reporting as imported successfully however on in the database only 3 items appear out of a possible 10?
I have tried to test out if some field names are too long but it seems fine, so not sure why no all products are in the category. The only that populates is BEST WESTERN PLUS THE GONVILLE HOTEL

"v_products_model","v_products_type","v_products_image","v_products_name_1","v_products_description_1","v_products_url_1","v_specials_price","v_specials_date_avail","v_specials_expires_date","v_products_price","v_products_weight","v_product_is_call","v_products_sort_order","v_products_quantity_order_min","v_products_quantity_order_units","v_products_priced_by_attribute","v_product_is_always_free_shipping","v_date_avail","v_date_added","v_products_quantity","v_manufacturers_name","v_categories_name_1","v_tax_class_title","v_status","v_metatags_products_name_status","v_metatags_title_status","v_metatags_model_status","v_metatags_price_status","v_metatags_title_tagline_status","v_metatags_title_1","v_metatags_keywords_1","v_metatags_description_1"
"Gourmet",1,"http://assets.redletterdays.co.uk/images/img435/productLarge/AFC","Arsenal Emirates Stadium Tour","The magnificent Emirates Stadium has become a landmark piece of modern architecture dominating the north London skyline. Marvel at the building from the outside and then follow in the footsteps of your Arsenal heroes by joining the Emirates Stadium Tour. You will see all the areas which are crucial to the team on a match day - from a walk down the players' tunnel, to a seat in the first team dressing room. Visit the Directors Box and press conference facilities. Along with state-of-the-art facilities, the club have incorporated some stunning features from the hallowed Highbury ground as well as some extra personal touches from inspirational and long-term Arsenal manager, Arsene Wenger. This tour is a must for any true fan of the Gunners.","www.awin1.com/pclick.php?p=102695293&a=123486&m=1983",,,,20,0,0,20,1,1983,0,0,,"12/03/14 12:11",0,"Red Letter Days","Gifts, Gadgets & Toys^Experiences","--none--",1,0,0,0,0,0,,,
"Gourmet",1,"http://assets.redletterdays.co.uk/images/img435/productLarge/MRS","Moorhill House Afternoon Tea","Enjoy an afternoon tea for two at Moorhill House - a hotel and restaurant on the outskirts of Burley in the New Forest. The hotel overlooks splendid gardens and lawns and provides a quiet atmosphere in which to relax. Head to the hotel restaurant (or if the weather is fine","www.awin1.com/pclick.php?p=3168928567&a=123486&m=1983",,,,27,0,0,20,1,1,0,0,,"26/11/14 18:46",0,"Red Letter Days","Gifts, Gadgets & Toys^Experiences","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83007/grounds-and-hotel-/moor-hall-hotel-grounds-and-hotel-22-83007.jpg","Moor Hall Hotel Spa","Come on in to the country character... and the unrivalled hospitality offered by the family run BEST WESTERN PREMIER Moor Hall Hotel & Spa! Surrounded by greenery (and exceptional staff), you'll have ample opportunity to enjoy the great outdoors of Sutton Coldfield and nearby parkland, within easy reach of Birmingham, the NEC, the motorway network and attractions such as Drayton Manor Park and Cadbury World. We're the business as far as business guests are concerned, not only offering well equipped ensuite bedrooms, but taking care of the ins and outs of organising your conferences in one of 7 rooms too! We have four poster rooms for those special occasions, and a choice of 2 restaurants will leave you spoilt for choice. And as for leisure facilities, our indoor pool, jacuzzi, sauna, steam room, aerobics room and spa with four treatment rooms will take care of your pampering preferences. Address: Moor Hall Drive,Four Oaks,Sutton Coldfield,West Midlands,B75 6LN,England","www.awin1.com/pclick.php?p=105706645&a=123486&m=2671",,,,101,0,0,101,1,2671,0,0,,"27/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83027/grounds-and-hotel-/lansdowne-hotel-grounds-and-hotel-07-83027.jpg","Lansdowne Hotel","This traditional privately owned seafront hotel lies close to shops and theatres, so buying handbags and putting on your glad rags is par for the course here in Eastbourne! BEST WESTERN Lansdowne Hotel has sea view lounges and a welcoming foyer. Individually furnished bedrooms are a delight to behold (and sleep in!), while our South Coast setting puts you 2 miles from Beachy Head and within easy reach of Brighton too. For indoor entertainment guests are invited to play games galore... or aim for a high break during their break in our two snooker rooms. High standards and friendly service are ever present. Address: King Edward’s Parade,Eastbourne,East Sussex,BN21 4EE,England","www.awin1.com/pclick.php?p=105706646&a=123486&m=2671",,,,35,0,0,35,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83294/grounds-and-hotel-/wroxton-house-hotel-grounds-and-hotel-52-83294.jpg","BEST WESTERN PLUS Wroxton House Hotel","A blissful Banbury break lies in store here at BEST WESTERN PLUS Wroxton House Hotel! In the comfortable cosiness of our 17th Century thatched manor house - dating in parts from 1649 - you'll be perfectly placed in this unspoilt Cotswold village location. Though we're a mere 14 miles from Shakespeare's Stratford-upon-Avon, 25 miles from Oxford and 4 miles from junction 11 of the M40, our idyllic retreat will win your heart in the Heart of England! All 32 bedrooms, most of which were completely refurbished in 2009, are simple, luxurious and welcoming. A truly memorable dining experience awaits in our AA rosette award winning Restaurant '1649'. And if you're visiting on business or arranging a special gathering, we also have a dedicated team to take the headaches out of hosting a big event! Address: Silver Street,Wroxton,Banbury,Oxfordshire,OX15 6QB,England","www.awin1.com/pclick.php?p=105706675&a=123486&m=2671",,"2014-12-03","2014-12-03",85,0,0,85,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83296/grounds-and-hotel-/salford-hall-hotel-grounds-and-hotel-02-83296.jpg","BEST WESTERN Salford Hall Hotel","Tudor, yet timeless, the romantic BEST WESTERN Salford Hall Hotel is a delightful manor house that opens up the gateway to Shakespeare country and the Cotswolds. "To stay or not to stay", that is the question. Though our delightful setting, amiable staff and four-poster beds in some rooms should make it an easy one to answer! We're also blessed (and proud as punch) to be able to offer charming accommodation in Tudor Court, a lovingly restored coach house and granary. Good food and even better company can be found in our friendly award-winning restaurant, and we'll do everything possible during your break to make it an unforgettable one. Address: Abbots Salford,Stratford upon Avon,Warwickshire,WR11 8UT,England","www.awin1.com/pclick.php?p=105706676&a=123486&m=2671",,"2014-12-03","2014-12-03",60,0,0,60,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83315/grounds-and-hotel-/duke-of-cornwall-hotel-grounds-and-hotel-04-83315-OP.jpg","BEST WESTERN Duke of Cornwall Hotel","We're proud of our individuality here at BEST WESTERN Duke of Cornwall Hotel, and we're sure you'll be hugely impressed by it! In Plymouth, close to the centre and waterfront, this beautiful Victorian-Gothic building provides the ideal base for exploring Devon, Cornwall and The Eden Project, with equally tempting attractions waiting for you on your return in the elegant surroundings of our 1 AA rosette restaurant. All bedrooms are uniquely designed with stylish interiors. For foreign forays, our hotel is the closest to the cross channel Ferryport, and you'll be just half a mile from Portsmouth Hoe and even closer to the famous Pavillions if you want to keep things British! Business travellers, families and couples will be more than welcome, so whatever your reason for relaxing here on the South Coast, you can look forward to an unforgettable break. Address: Millbay Road,Plymouth,Devon,PL1 3LG,England","www.awin1.com/pclick.php?p=105706677&a=123486&m=2671",,"2014-12-03","2014-12-03",76,0,0,76,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83346/grounds-and-hotel-/old-tollgate-hotel-grounds-and-hotel-07-83346.jpg","BEST WESTERN Old Tollgate Hotel and Restaurant","Join us for a stay in Steyning! Just 10 miles from Brighton, amidst glorious countryside and a village setting of Bramber, BEST WESTERN Old Tollgate Hotel and Restaurant has an award-winning carvery, described by critics as 'visual a la carte', comfy-cosy rooms and standards of service that are as high as your spirits will be. We're also within easy reach of Gatwick Airport, which is handy for holidaymakers, and mainline stations. Many historic houses and gardens nearby can be found nearby (via motorway links) but at the foot of South Downs hills now a National Park with miles of walking, riding, fishing and golf nearby you might be tempted to stay closer to home! Address: The Street,Bramber,Steyning,West Sussex,BN44 3WE,England","www.awin1.com/pclick.php?p=105706682&a=123486&m=2671",,"2014-12-03","2014-12-03",76,0,0,76,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83351/grounds-and-hotel-/the-gonville-hotel-grounds-and-hotel-23-83351.jpg","BEST WESTERN PLUS The Gonville Hotel","Let us be the architects of a wonderful stay here in the centre of Cambridge! Overlooking a 25 acre open park, BEST WESTERN PLUS The Gonville Hotel offers easy access to the impressive buildings and stunning designs that make this university city, with free car parking an added bonus for getting out and about to points of interest such as Anglesy Abbey and Duxford Imperial Museum (both just 6 miles away). Our accessible accommodation is an ideal base for your stay or event, so whether you want to tour on foot or by public transport (or online with free WiFi!), you'll be perfectly placed to explore our wonderful surroundings. For entertainment value, Cambridge offer both! Pubs, restaurants and cafes cater for a wide range of tastes, and there are numerous nightlife opportunities all over the city from clubs and theatres to multiplex cinemas. Address: Gonville Place,Cambridge,Cambridgeshire,CB1 1LY,England","www.awin1.com/pclick.php?p=105706683&a=123486&m=2671",,"2014-12-03","2014-12-03",199,0,0,199,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,

Because the model number is the same causing the follow on model information to replace whatever was previous.

Must have unique model numbers to prevent that.

I am not creating unique data for v_products_model (ps anyone know how I can remove the data from the above post?)

mc12345678:

Because the model number is the same causing the follow on model information to replace whatever was previous.

Must have unique model numbers to prevent that.

Hi thanks, yes suddenly found that, (should have looked better) apologies. Many thanks for confirming.

hols.club:

I am not creating unique data for v_products_model (ps anyone know how I can remove the data from the above post?)

In your data setup, the first column.

how modified the file php for this...

you can give me a support or customize the file?

mc12345678:

Errors captured/documented by EP4 are in an errorlog listed in the files to be imported/downloaded. New errors are added to the end of the file. If this file has been in the file list for a long time it may contain multiple errors that do not relate to the current issue.

Btw, I am not entirely sure that the code currently supports only a total of two columns being in the upload file. I would have to look to see what changes might be necessary to support that.

how modified the file for this

how delete the control

you can give me a support or customize?