Page 295 of 363 FirstFirst ... 195245285293294295296297305345 ... LastLast
Results 2,941 to 2,950 of 3630
  1. #2941
    Join Date
    Jul 2012
    Posts
    16,768
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by mesnitu View Post
    Hi

    Maybe this as been answered hundreds of time, but by search it's not easy to find.
    I've started working in a different way. Now the a lot products are already online in a "general" category.
    So, I'll be updating and not inserting.
    This process will create a linked category. Is there a way around it ?

    Thanks
    Yes and no. Can't recall someone indicating that just because they "updated" the record(s) (submitted the same file exported as an import where each record has a unique primary key) that the product became linked.

    So, here's how a linked product can be generated when using just EP4 (I can't at the moment speak for the bookx addition you've made) when reviewing the import file:
    If a record has a primary key that matches an existing primary key in the database but the category is different, a linked product will be created/updated.
    Note, if at import the database doesn't contain the associated primary key, but the file has two entries in it where each has a different category, then when the second record is encountered, that second record will cause the product to be linked to the new category and all associated data will be updated to match the most recent occurrence.

    That's really all that will create a linked product.

    So to avoid generating linked product, always use a unique primary key for each individual product. EP4 has two types of primary key available with the possibility to code additional: products_model and products_id.

    To remove linked product, I suggest rereading the instructions, but by setting a row's status to 7, then the category identified on that row will become the master_categories_id. The current master_categories_id will be unlinked from the product. If there are multiple linked categories for a single product then it may be advisable to use this process for all records and then to "add" those desired to be linked after the linkages have been reduced down to a single master_categories_id. There are a number of ways to work through this situation, but that particular method would resolve the situation for all cases.

    If you are getting linked product on import, either the primary_key data already exists or is duplicated in the import or there is something wrong with the bookx addition.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  2. #2942
    Join Date
    Aug 2014
    Location
    Lisbon
    Posts
    594
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by mc12345678 View Post
    To remove linked product, I suggest rereading the instructions, but by setting a row's status to 7
    Wonderful!
    Status 7 works perfectly!
    Thanks!
    “Though the problems of the world are increasingly complex, the solutions remain embarrassingly simple.” ― Bill Mollison

  3. #2943
    Join Date
    Jan 2015
    Posts
    430
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    zencart 156
    php 7.3
    EasyPopulate V4

    When clicking on easy populate in the admin i get an an error. If someone could assist me or lead me in the right direction i would appreciate it.

    [17-Dec-2018 19:27:53 Europe/Berlin] Request URI: /xxxxxx.com/power/easypopulate_4.php, IP address: ::1
    #1 sizeof() called at [C:\xampp\htdocs\xxxxxx.com\power\easypopulate_4.php:655]
    [17-Dec-2018 19:27:53 Europe/Berlin] PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in C:\xampp\htdocs\xxxxxx.com\power\easypopulate_4.php on line 655

    [17-Dec-2018 19:27:53 Europe/Berlin] Request URI: /xxxxxx.com/power/easypopulate_4.php, IP address: ::1
    #1 sizeof() called at [C:\xampp\htdocs\xxxxxx.com\power\easypopulate_4.php:661]
    [17-Dec-2018 19:27:53 Europe/Berlin] PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in C:\xampp\htdocs\xxxxxx.com\power\easypopulate_4.php on line 661

    Code:
     $file_count = 0;
                //Display the information needed to start use of a filetype.
       (line 655) $plural_state = "<strong>" . (sizeof($val) > 1 ? EP_DESC_PLURAL : EP_DESC_SING) . "</strong>";
                if (EP4_SHOW_ALL_FILETYPES != 'Hidden') {
                  echo "<tr><td colspan=\"8\">" . sprintf($filenames_merged[$key], "<strong>" . $key . "</strong>", $plural_state) . "</td></tr>";
                  echo "<tr><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_FILENAME . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_SIZE . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_DATE_TIME . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_TYPE . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_SPLIT . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_IMPORT . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_DELETE . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_DOWNLOAD . "</th>\n";
                }
    
       (line 661)      for ($i = 0; $i < sizeof($val); $i++) {
                  if (EP4_SHOW_ALL_FILETYPES != 'Hidden' || (EP4_SHOW_ALL_FILETYPES == 'Hidden' && ($files[$i] != ".") && ($files[$i] != "..") && preg_match("/\.(sql|gz|csv|txt|log)$/i", $files[$i]) )) {
                    $file_count++;
                    echo '<tr><td>' . $files[$val[$i]] . '</td>
    					<td align="right">' . filesize($upload_dir . $files[$val[$i]]) . '</td>
    					<td align="center">' . date("Y-m-d H:i:s", filemtime($upload_dir . $files[$val[$i]])) . '</td>';
                    $ext = strtolower(end(explode('.', $files[$val[$i]])));
                    // file type

  4. #2944
    Join Date
    Jul 2012
    Posts
    16,768
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by chadlly2003 View Post
    zencart 156
    php 7.3
    EasyPopulate V4

    When clicking on easy populate in the admin i get an an error. If someone could assist me or lead me in the right direction i would appreciate it.

    [17-Dec-2018 19:27:53 Europe/Berlin] Request URI: /xxxxxx.com/power/easypopulate_4.php, IP address: ::1
    #1 sizeof() called at [C:\xampp\htdocs\xxxxxx.com\power\easypopulate_4.php:655]
    [17-Dec-2018 19:27:53 Europe/Berlin] PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in C:\xampp\htdocs\xxxxxx.com\power\easypopulate_4.php on line 655

    [17-Dec-2018 19:27:53 Europe/Berlin] Request URI: /xxxxxx.com/power/easypopulate_4.php, IP address: ::1
    #1 sizeof() called at [C:\xampp\htdocs\xxxxxx.com\power\easypopulate_4.php:661]
    [17-Dec-2018 19:27:53 Europe/Berlin] PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in C:\xampp\htdocs\xxxxxx.com\power\easypopulate_4.php on line 661

    Code:
     $file_count = 0;
                //Display the information needed to start use of a filetype.
       (line 655) $plural_state = "<strong>" . (sizeof($val) > 1 ? EP_DESC_PLURAL : EP_DESC_SING) . "</strong>";
                if (EP4_SHOW_ALL_FILETYPES != 'Hidden') {
                  echo "<tr><td colspan=\"8\">" . sprintf($filenames_merged[$key], "<strong>" . $key . "</strong>", $plural_state) . "</td></tr>";
                  echo "<tr><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_FILENAME . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_SIZE . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_DATE_TIME . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_TYPE . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_SPLIT . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_IMPORT . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_DELETE . "</th><th>" . EASYPOPULATE_4_DISPLAY_EXPORT_TABLE_TITLE_DOWNLOAD . "</th>\n";
                }
    
       (line 661)      for ($i = 0; $i < sizeof($val); $i++) {
                  if (EP4_SHOW_ALL_FILETYPES != 'Hidden' || (EP4_SHOW_ALL_FILETYPES == 'Hidden' && ($files[$i] != ".") && ($files[$i] != "..") && preg_match("/\.(sql|gz|csv|txt|log)$/i", $files[$i]) )) {
                    $file_count++;
                    echo '<tr><td>' . $files[$val[$i]] . '</td>
                        <td align="right">' . filesize($upload_dir . $files[$val[$i]]) . '</td>
                        <td align="center">' . date("Y-m-d H:i:s", filemtime($upload_dir . $files[$val[$i]])) . '</td>';
                    $ext = strtolower(end(explode('.', $files[$val[$i]])));
                    // file type
    Don't know what version is being used or what changes have been made, but:
    Go up a few lines before 655 to this code which is just after the start of the foreach loop:
    Code:
    (EP4_SHOW_ALL_FILETYPES != 'false' ? $val = $filetypes[$key] : '');
    and change it to

    Code:
    (EP4_SHOW_ALL_FILETYPES != 'false' ? $val = ((isset($filetypes[$key]) || array_key_exists($key, $filetypes)) ? $filetypes[$key] : array()) : '');
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #2945
    Join Date
    May 2004
    Posts
    10
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Can someone post a correct CSV file for category import with multi level categories?
    I did a simple 1 main 3 sub cat creation within admin and then export. There was nothing for parent_id. Created my new file and imported but it does not assign parent id.

    Only thing I could find on subject was the readme file on Github but it was unclear

  6. #2946
    Join Date
    Jul 2012
    Posts
    16,768
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by FlipC View Post
    Can someone post a correct CSV file for category import with multi level categories?
    I did a simple 1 main 3 sub cat creation within admin and then export. There was nothing for parent_id. Created my new file and imported but it does not assign parent id.

    Only thing I could find on subject was the readme file on Github but it was unclear
    Are you sure you're posting to the correct forum thread? The parent_id is not included in the export of the category information, neither the meta nor the model/category file(s).

    Category assignment (generation of a category) is done through the product assignment. The details about the category are handled through either of the two other catefory files.

    The format for a category designation using this plugin is to use the carat (^) between each category starting at the top of the tree such that if say there were women's shoes as compared to men's shoes, with shoes being a main category off of the store, then the categories field would have shoes^men\'s for shoes that are to be assigned as men's shoes, and shoes^women\'s for shoes to be assigned as women's shoes.

    The code will determine the parent id for each category based on finding the category or identifying the need to create it. At the last category in the path, the product is to be assigned to that last category when the product is first created. If it already exists then it is linked to that category, basically.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  7. #2947
    Join Date
    Sep 2013
    Location
    Texas
    Posts
    315
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by mc12345678 View Post
    Are you sure you're posting to the correct forum thread? The parent_id is not included in the export of the category information, neither the meta nor the model/category file(s).

    Category assignment (generation of a category) is done through the product assignment. The details about the category are handled through either of the two other catefory files.

    The format for a category designation using this plugin is to use the carat (^) between each category starting at the top of the tree such that if say there were women's shoes as compared to men's shoes, with shoes being a main category off of the store, then the categories field would have shoes^men\'s for shoes that are to be assigned as men's shoes, and shoes^women\'s for shoes to be assigned as women's shoes.

    The code will determine the parent id for each category based on finding the category or identifying the need to create it. At the last category in the path, the product is to be assigned to that last category when the product is first created. If it already exists then it is linked to that category, basically.
    This may be redundant but when I first started using EP4 I too struggled with importing "Categories" and a csv file Download/Upload that allowed for entering new Category ID's. IMHO the documentation is a bit vague on this for some of us.

    As MC pointed out it can be done thru a Full-EP2018Dec20-230629.csv file.
    Just create a new product with a new category and a new category with ID will be created.
    I don't use sub categories but the readme says to use the carat (^) to add those.

    The README.txt file ( included in attachment) in the zEasyPopulate-4.master-ZC.zip plugin download (section 3) spells that out.

    The attached file would create a new Category called "Prod 001". The system will assign a new Category ID.
    Be mindful of the settings in the Admin area ( Layout Settings > Categories with 0 Products Status ).

    See these two files in the attached zip.
    Hope this helps a bit.
    Attached Files Attached Files

  8. #2948
    Join Date
    Dec 2016
    Location
    South Africa
    Posts
    34
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Hi all

    I have just loaded a new v156 with ep4

    It is the same EP4 I have on my current site which has v155d

    The new install doesn't want to accept my old files for uploading products - is it because v156 is using DB Collation: utf8mb4 and the older v155d is using DB Collation: utf8?

    All my other settings are exactly the same

    Thx
    Russel

  9. #2949
    Join Date
    Jul 2012
    Posts
    16,768
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by Russalpcs View Post
    Hi all

    I have just loaded a new v156 with ep4

    It is the same EP4 I have on my current site which has v155d

    The new install doesn't want to accept my old files for uploading products - is it because v156 is using DB Collation: utf8mb4 and the older v155d is using DB Collation: utf8?

    All my other settings are exactly the same

    Thx
    Russel
    Possibly, what message(s) are received? Certainly an interesting possible issue. Definitely want to be able to take advantage of the extended character set.

    Now something interestingly said was same EP4 version on both sites, please elaborate.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  10. #2950
    Join Date
    Sep 2013
    Location
    Texas
    Posts
    315
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by mc12345678 View Post
    Possibly, what message(s) are received? Certainly an interesting possible issue. Definitely want to be able to take advantage of the extended character set.

    Now something interestingly said was same EP4 version on both sites, please elaborate.
    I just downloaded from ZC 1.5.5f and imported into ZC 1.5.6 with EasyPopulate-4.master-ZC from the Plugin's page.

    On occasion clicking "import" from the red banner immediately after uploading the product file doesn't always work for me.
    Using "import" from the form has always worked for me.

    Double check the name of the file you are importing for spaces and characters like %$ etc..

 

 

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. BackUp ZC [Support Thread]
    By skipwater in forum All Other Contributions/Addons
    Replies: 285
    Last Post: 23 Dec 2020, 10:40 AM
  3. Wordpress On ZC [Support Thread]
    By hira in forum All Other Contributions/Addons
    Replies: 1858
    Last Post: 17 Jan 2014, 01:24 AM
  4. ZJ Black 2 support thread
    By Liamv in forum Addon Templates
    Replies: 1
    Last Post: 15 Feb 2010, 02:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR