EasyPopulate 4.0 Support Thread

[chuckrey]

Wait... detailed attribute export works as expected, but basic does not? Much of the query for both of those is the same. I mean they are each asking for different fields, but the from and where portions are nearly identical. A difference that stands out is that the detailed export adds a limitation of using the language assigned to the value of 1.

Fyi, in the past a recommendation has also been to remove and reinstall the software.

So I just finished removing EP 4.0 and reinstalled the latest from Github. I did not have any luck, same result of not displaying the data from Basic Attributes.....

However.. I tested an older version I have on my hard drive. Specifically Easy Populate 4.0.30 - Beta 06-27-2015 and it worked where all data is now downloading without an issue. The version that was not allowing me to export Basic Attributes is Easy Populate 4.0.37.13 - 05-03-2021

[mc12345678]

So I just finished removing EP 4.0 and reinstalled the latest from Github. I did not have any luck, same result of not displaying the data from Basic Attributes.....

However.. I tested an older version I have on my hard drive. Specifically Easy Populate 4.0.30 - Beta 06-27-2015 and it worked where all data is now downloading without an issue. The version that was not allowing me to export Basic Attributes is Easy Populate 4.0.37.13 - 05-03-2021

The question remains (for clarity) the detailed attributes export from the same store that is having an issue with the basic attributes export, works or only a single record? Could also identify php version and zen cart version, please? Done any phpmyadmin query testing of the database? I'll go back and try to review such an old version but without understanding why this one is not displaying all of the data for you but is for others makes it difficult to diagnose or claim specifically is a problem with the software, especially when the same software was reported as installed in a different store and reported as fully functional.

[chuckrey]

The question remains (for clarity) the detailed attributes export from the same store that is having an issue with the basic attributes export, works or only a single record? Could also identify php version and zen cart version, please? Done any phpmyadmin query testing of the database? I'll go back and try to review such an old version but without understanding why this one is not displaying all of the data for you but is for others makes it difficult to diagnose or claim specifically is a problem with the software, especially when the same software was reported as installed in a different store and reported as fully functional.

I am using php 7.2 and ZC 1.5.7c.
The Detailed Attributes is working without an issue as it exports all data. Basic Attributes exports one line of data. I checked the database and the data is all there and did not see any issue. I have another site that I can run the most recent EP and see if I have a different result, but will likely get that done in the morning.

[mc12345678]

I am using php 7.2 and ZC 1.5.7c.
The Detailed Attributes is working without an issue as it exports all data. Basic Attributes exports one line of data. I checked the database and the data is all there and did not see any issue. I have another site that I can run the most recent EP and see if I have a different result, but will likely get that done in the morning.

Okay, so when say "all the data is there" what query from EP4 was executed from within phpmyadmin to validate this statement? My question here is if there is a problem with the query or how the data is handled once the query has been executed. Further what about this store is causing a difference than the other store reported to work correctly.

[chuckrey]

Okay, so when say "all the data is there" what query from EP4 was executed from within phpmyadmin to validate this statement? My question here is if there is a problem with the query or how the data is handled once the query has been executed. Further what about this store is causing a difference than the other store reported to work correctly.

I misunderstood. I checked the data within phpmyadmin but did not run a query, sorry for my confusion. Can you please advise which query I can run and I will share the results?

Also, I checked the easypopulate_4_export.php file and replaced row 222-301 with the following and it worked, all data is showing when processing Basic Attributtes. Of course the code is coming from a previous version of EP4

/ these variables are for the Attrib_Basic Export
$active_products_id = ""; // start empty
$active_options_id = ""; // start empty
$active_language_id = ""; // start empty
$active_row = array(); // empty array
$last_products_id = "";
$print1 = 0;
$result = ep_4_query($filelayout_sql);
while ($row = ($ep_uses_mysqli ? mysqli_fetch_array($result) : mysql_fetch_array($result))) {

if ($ep_dltype == 'attrib_basic') { // special case 'attrib_basic'


if ($row['v_products_id'] == $active_products_id) {
if ($row['v_options_id'] == $active_options_id) {
// collect the products_options_values_name
if ($active_language_id <> $row['v_language_id']) {
$l_id = $row['v_language_id'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
$active_language_id = $row['v_language_id'];
} else {
$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] .= ",".$row['v_products_options_values_name'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
}
continue; // loop - for more products_options_values_name on same v_products_id/v_options_id combo
} else { // same product, new attribute - only executes once on new option
// Clean the texts that could break CSV file formatting
$dataRow = '';
$problem_chars = array("\r", "\n", "\t"); // carriage return, newline, tab
foreach($filelayout as $key => $value) {
$thetext = $active_row[$key];
// remove carriage returns, newlines, and tabs - needs review
$thetext = str_replace($problem_chars,' ',$thetext);
// encapsulate data in quotes, and escape embedded quotes in data
$dataRow .= '"'.str_replace('"','""',$thetext).'"'.$csv_delimiter;
}
// Remove trailing tab, then append the end-of-line
$dataRow = rtrim($dataRow,$csv_delimiter)."\n";
fwrite($fp, $dataRow); // write 1 line of csv data (this can be slow...)
$ep_export_count++;

$active_options_id = $row['v_options_id'];
$active_language_id = $row['v_language_id'];
$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
continue; // loop - for more products_options_values_name on same v_products_id/v_options_id combo
}
} else { // new combo or different product or first time through while-loop
if ($active_row['v_products_model'] <> $last_products_id) {
// Clean the texts that could break CSV file formatting
$dataRow = '';
$problem_chars = array("\r", "\n", "\t"); // carriage return, newline, tab
foreach($filelayout as $key => $value) {
$thetext = $active_row[$key];
// remove carriage returns, newlines, and tabs - needs review
$thetext = str_replace($problem_chars,' ',$thetext);
// encapsulate data in quotes, and escape embedded quotes in data
$dataRow .= '"'.str_replace('"','""',$thetext).'"'.$csv_delimiter;
}
// Remove trailing tab, then append the end-of-line
$dataRow = rtrim($dataRow,$csv_delimiter)."\n";
fwrite($fp, $dataRow); // write 1 line of csv data (this can be slow...)
$ep_export_count++;
$last_products_id = $active_row['v_products_model'];
}

// get current row of data
$active_products_id = $row['v_products_id'];
$active_options_id = $row['v_options_id'];
$active_language_id = $row['v_language_id'];

$active_row['v_products_model'] = $row['v_products_model'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];

$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
} // end of special case 'attrib_basic'

[mc12345678]

I misunderstood. I checked the data within phpmyadmin but did not run a query, sorry for my confusion. Can you please advise which query I can run and I will share the results?

Also, I checked the easypopulate_4_export.php file and replaced row 222-301 with the following and it worked, all data is showing when processing Basic Attributtes. Of course the code is coming from a previous version of EP4

// these variables are for the Attrib_Basic Export
$active_products_id = ""; // start empty
$active_options_id = ""; // start empty
$active_language_id = ""; // start empty
$active_row = array(); // empty array
$last_products_id = "";
$print1 = 0;
$result = ep_4_query($filelayout_sql);
while ($row = ($ep_uses_mysqli ?  mysqli_fetch_array($result) : mysql_fetch_array($result))) {

	if ($ep_dltype == 'attrib_basic') { // special case 'attrib_basic'


	if ($row['v_products_id'] == $active_products_id) {
		if ($row['v_options_id'] == $active_options_id) {
			// collect the products_options_values_name
			if ($active_language_id <> $row['v_language_id']) {
				$l_id = $row['v_language_id'];
				$active_row['v_products_options_type'] = $row['v_products_options_type'];
				$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
				$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
				$active_language_id = $row['v_language_id'];
			} else {
				$l_id = $row['v_language_id'];
				$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
				$active_row['v_products_options_values_name_'.$l_id] .= ",".$row['v_products_options_values_name'];
				$active_row['v_products_options_type'] = $row['v_products_options_type'];
			}
			continue; // loop - for more products_options_values_name on same v_products_id/v_options_id combo
		} else { // same product, new attribute - only executes once on new option
			// Clean the texts that could break CSV file formatting
			$dataRow = '';
			$problem_chars = array("\r", "\n", "\t"); // carriage return, newline, tab
			foreach($filelayout as $key => $value) {
				$thetext = $active_row[$key];
				// remove carriage returns, newlines, and tabs - needs review
				$thetext = str_replace($problem_chars,' ',$thetext);
				// encapsulate data in quotes, and escape embedded quotes in data
				$dataRow .= '"'.str_replace('"','""',$thetext).'"'.$csv_delimiter;
			}
			// Remove trailing tab, then append the end-of-line
			$dataRow = rtrim($dataRow,$csv_delimiter)."\n";
			fwrite($fp, $dataRow); // write 1 line of csv data (this can be slow...)
			$ep_export_count++;				
			
			$active_options_id = $row['v_options_id'];
			$active_language_id = $row['v_language_id'];
			$l_id = $row['v_language_id'];
			$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
			$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
			$active_row['v_products_options_type'] = $row['v_products_options_type'];
			continue; // loop - for more products_options_values_name on same v_products_id/v_options_id combo
		}
	} else { // new combo or different product or first time through while-loop
		if ($active_row['v_products_model'] <> $last_products_id) {
			// Clean the texts that could break CSV file formatting
			$dataRow = '';
			$problem_chars = array("\r", "\n", "\t"); // carriage return, newline, tab
			foreach($filelayout as $key => $value) {
				$thetext = $active_row[$key];
				// remove carriage returns, newlines, and tabs - needs review
				$thetext = str_replace($problem_chars,' ',$thetext);
				// encapsulate data in quotes, and escape embedded quotes in data
				$dataRow .= '"'.str_replace('"','""',$thetext).'"'.$csv_delimiter;
			}
			// Remove trailing tab, then append the end-of-line
			$dataRow = rtrim($dataRow,$csv_delimiter)."\n";
			fwrite($fp, $dataRow); // write 1 line of csv data (this can be slow...)
			$ep_export_count++;
			$last_products_id = $active_row['v_products_model'];
		}
		
		// get current row of data
		$active_products_id = $row['v_products_id'];
		$active_options_id = $row['v_options_id'];
		$active_language_id = $row['v_language_id'];
		
		$active_row['v_products_model'] = $row['v_products_model'];
		$active_row['v_products_options_type'] = $row['v_products_options_type'];
		
		$l_id = $row['v_language_id'];
		$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name']; 
		$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
	} // end of special case 'attrib_basic'

I believe I have found the issue. Please answer at least the below first question. I ask that the second be answered only if the answer to the first is yes.
1. On the other site where EP4 basic attributes were expiring propelling, was the primary key set to the default of products_model?
2. To be answered if the above was yes. What custom field(s) are identified for import/export?

In either case, thank you for reporting this issue. I can see that as>was trying to simplify the code more and also offer additional options that some of the code changes were incomplete for use by the many as compared to the few.

[chuckrey]

I believe I have found the issue. Please answer at least the below first question. I ask that the second be answered only if the answer to the first is yes.
1. On the other site where EP4 basic attributes were expiring propelling, was the primary key set to the default of products_model?
2. To be answered if the above was yes. What custom field(s) are identified for import/export?

In either case, thank you for reporting this issue. I can see that as>was trying to simplify the code more and also offer additional options that some of the code changes were incomplete for use by the many as compared to the few.

1. - Yes, products_model
2. I am not certain as to which setting you are referring so I am going to send all settings. Sorry.



Uploads Directory - temp/
Uploads Directory Admin/Catalog - true
Import/Export Primary Key - products_model
Import Language Override - language_id
Import/Export CSV Delimiter - ,
Export Language Identifier - id
Export Price Decimals - 2
Upload File Date Format - m-d-y
Default Raw Time - 09:00:00
Export Filename Date - Y-m-d
Upload/Download Prices Include Tax - false
Verbose Feedback - true
Show all EP4 Filetypes with Files - true
Replace Blank Image - false
Activate Blank Featured - true
Remove Blank Specials - negative
Make Zero Qty Products Inactive - false
Smart Tags Replacement of Newlines - true
Advanced Smart Tags - false
Auto-extend fields - false
Debug Logging - true
Maximum Quantity Discounts - 0
Split On Number of Records - 2000
Script Execution Time - 60
Convert Curly Quotes, etc. - 0
Convert Character 0x92 - 1
Enable Products Meta Data - 1
Enable Products Music Data - 0
User Defined Products Fields [this field is blank]
Export URI with Prod and or Cat - 1

Thank you for all your work, EP is a necessity and I am surprised this is not included w/ the install.