The file provided above, which does reflect what you described, was not generated by this version of EP4 as provided. At a minimum a modification has been made to use a $csv_delimiter of ";"...
If you want to continue to use this delimiter instead of the programmed comma (,) then you will need to make a change to your files downloaded now and in the future until such "delimiters" can be chosen in the admin.
Open admin/easypopulate_4.php in a plain text editor, preferably one that shows line numbers.
search for:
$csv_delimiter and should find at or around line 6 the following:
If you wanted to have everything semi-colon separated, then would change this to:Code:$csv_delimiter = ","; // "\t" = tab AND "," = COMMA
I do somewhat discourage this change though because there is other code that for example upon export will save the file with the extension .txt instead of .csv because it is not "comma separated"...Code:$csv_delimiter = ";"; // "\t" = tab AND "," = COMMA
That said, I suggest actually clicking one of the links in the program to generate a new csv file of your product, then view the file/import it... Remember to backup before making changes and routinely.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Short answer – Yes
Long answer – I did three back-ups in three different ways;
1 Filterable Exports: only changed ‘status’ equals all.
2 & 3 - Category Export/Import Options: did both.
The ‘Categories Only (with Metatags)’ is the only CSV file that displays the categories that has no products in that category.
I cannot work out how ‘Categories Only’ works. If you are to import that CSV file, how does it know which category is a sub-category and under which category to put the sub-category?
Learning Fast.
Eden Craft Supplies
This file just happened to exist in the directory that is/was referenced. EP4 does not create a file until the admin chooses either a clickable export link or uses the dropdowns at the top of the screen.
Also, part of what jeking was referencing was that the filename of an import file plays a part in how the program operates. Please see the instructions addressing filenames. The filename provided in the zip was newimport2.csv. On import this file would be treated as if it contained information to fully describe a product accessing it's products table, the categories table(s), and metatag information. There are a few files that must begin with a particular series of characters in order to process them for their intended function. For example, the full import/export doesn't address attributes of a product, and the attributes file(s) don't necessarily have useful information for the full products part so they don't usually get processed as part of the full product information. The only "special" part of the filename is whatever exists(ed) when an export was performed to include the characters from the first letter up to and including ep...
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Ok, I have attached the file generated by EP4 (Export).
When I try to import it - I only see the errors (see screenshot attached).
The filtered dropdowns relate to product... No product, no information... Therefore an empty category would not appear on the export of a list of products.
As to the two other selections. The 'Categories Only' list each product (by model #) and the category(ies) to which it is referenced. This helps to identify linked product, to see to what categories a product is placed, and in actuality offers a way to further link a product to other categories.
The category with metadata option is the detailed category information much like if you were editing the category in ZC admin. It does not display the relationship of one category to another. That "relationship" is done when assigning a product to a category.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Bookmarks