Mind identifying what the issue was to all of those that received the first notification? :)Quote:
Originally Posted by Blenderite
Otherwise, glad that the issue was resolved.
Printable View
Mind identifying what the issue was to all of those that received the first notification? :)Quote:
Originally Posted by Blenderite
Otherwise, glad that the issue was resolved.
What is the best program to edit the CSV files? I am having troubles with OpenOffice. I tried Notepad++ but it got pretty confusing.
When I edited it, it was a double post. But I don't see the other one. I am going to have to remember what I posted about lol!Quote:
Originally Posted by mc12345678
So, open office has been the best program to use mostly because of it's direct support of UTF-8 character handling, date formatting and CSV formatting. I have recently seen instructions by internet search that have identified a way to maintain UTF-8 encoding when using the commercial program Microsoft Excel. The last time I tried it the major issue I encountered was how the date was formatted upon export and that it was not YYYY-MM-DD. That format is what is expected for date fields if they are to be contained in the upload... If the date field is not to be modified then would want to not include the field in the CSV file.Quote:
Originally Posted by Blenderite
I have also seen some capability in Beyond Compare to manipulate CSV data, but then don't have spreadsheet related versatility.
What issues wth OO are being experienced?
OO does open it fine and edit it fine, but when I import the edited file, it doesn't import correctly. All the data entered is randomly mixed up with other columns and stuff. It makes me think that maybe I am not saving it correctly so it is importing wrong. Is there a specific method to save it to make sure it doesn't get messed up?
More than likely that step is probably the issue. See post #10 about Open Office Settings for Export. Certainly the software has been updated a bit, but same basic process still seems to apply.Quote:
Originally Posted by Blenderite
I followed step #10 and added a couple of items. Here is the error it throws: http://www.pasteall.org/pic/91219
No rows imported, or did only some of them? Contents of the file being imported? (Possibly post the first few lines if those did not import.) Before pasting, please click the # symbol in the toolbar above the text box, then paste.
Nothing was imported.Quote:
Originally Posted by mc12345678
That is what Notepad++ shows. That is after I exported the file from OO. I notice that there is no double quotes.Code: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
,1,,Laconiko Olive Oil - 16.9 fl.oz,"Laconiko olive oil is a fourth generation family of olive oil producers whose estate is on the sandy beaches of Southern Peloponnese, just outside Sparti, Greece. The relatively small number of olive trees on their estate, surrounded by orange and grapefruit trees, allows for an olive oil that is unique and wonderful. The family is committed to bringing a true extra virgin olive oil to the States. Brothers, Diamantis and Dino, reside in Gainesville, VA, but take turns returning to their family's olive estate to work the land with their father. Laconiko olive oil is on Weston A. Price's ""best"" list for their shopping guide. http://laconiko.com/index.html Each bottle is 500mL/16.9fl.oz.",,,,,25,0,0,0,1,1,0,0,,2015-07-27 15:23:09,6,,"Honey, Olive Oil, Tea, FireCider",--none--,1,0,0,0,0,0,,,
,1,,Laconiko Olive Oil - Value Size - 67.6 fl.oz,"The 2-litre value size of the Laconiko Olive Oil. Save $25 by purchasing this size! <p> Laconiko olive oil is a fourth generation family of olive oil producers whose estate is on the sandy beaches of Southern Peloponnese, just outside Sparti, Greece. The relatively small number of olive trees on their estate, surrounded by orange and grapefruit trees, allows for an olive oil that is unique and wonderful. The family is committed to bringing a true extra virgin olive oil to the States, this years harvest has a low acidity of 0.13% (to be an extra virgin acidity must be below 0.8%). Brothers, Diamantis and Dino, reside in Gainesville, VA, but take turns returning to their family's olive estate to work the land with their father. Laconiko olive oil is on Weston A. Price's ""best"" list for their shopping guide. http://laconiko.com/index.html",,,,,75,0,0,0,1,1,0,0,,2015-07-27 15:26:34,4,,"Honey, Olive Oil, Tea, FireCider",--none--,1,0,0,0,0,0,,,
,1,,Wild Alaskan Salmon,"Wild Caught Bristol Bay, Alaskan Salmon Filet Portions $18/lb. (NOW IN SMALLER PORTIONS! .4 lb./package). <p> We came across a northern Virginia native who has relocated to Bristol Bay Alaska as a fisherman! Here is the fisherman's description: ""Wild caught in Bristol Bay, Alaska, the largest true certified wild sustainable salmon fishery in the world. After being caught, fish are bled on the spot for higher quality, then stored in 33-35 degree refrigerated seawater until off loaded to tender-ships. Tender-ships transport the salmon from the fishing grounds to the salmon processing plant where the fish are filleted, de-boned and flash frozen. This entire process takes place from the water to the freezer all within 24-30 hours. I have been a Professional Commercial Fishermen in Bristol Bay, Alaska, for seven years. Originally growing up in Fairfax, Virginia I started off by bringing back personally caught fish for family and friends to enjoy. After taking extreme care of our fish on the fishermen's side, I have seen the poor quality of salmon offered in local stores. Therefore, I am offering the highest quality salmon available. Our salmon comes directly from me the fishermen then to you, the consumer.""",,,,,18,0,0,0,0.4,0.4,0,0,,2015-07-27 15:32:29,445.24,,Salmon,--none--,1,0,0,0,0,0,,,
Well, the "error" is reporting what is true with that file. The first column that has the header: v_products_model does not have any data in it.
As to the double quotes, there are occasion of double quotes in the file where basically at least in one instance a comma (field separator) was within the section of information to be updated. Notice in the first row of data the comma after Southern Peloponnese.