alwayspaws Posted June 27, 2017 Share Posted June 27, 2017 How can I fix the below problems for csv imports, please? How can I reduce the font size of header tags in the descriptions? They are way too big. See first screenshot please. Short descriptions are missing after csv import. See second screenshot, please. First screenshot: Second Screenshot: Thank you! Link to comment Share on other sites More sharing options...
Traumflug Posted June 27, 2017 Share Posted June 27, 2017 How can I reduce the font size of header tags in the descriptions? That's the HTML editor on the product page, right? This editor doesn't use Frontoffice CSS, so appearance can be quite different from what you can see on the actual FO page. That's why there's this "preview" eye to the right of the dog dress. Link to comment Share on other sites More sharing options...
alwayspaws Posted June 27, 2017 Author Share Posted June 27, 2017 Yes, but I don't know how to make the font smaller via CSV. If I had an idea of the settings, I can add the code to the CSV. Am I missing something? Link to comment Share on other sites More sharing options...
Traumflug Posted June 27, 2017 Share Posted June 27, 2017 It's HTML. Font size isn't set by pixels, but by heading type. <h2> (2nd class heading) for large letters, <h5> (5th class heading) for small letters. If this still doesn't match your idea you have to edit front office (S)CSS. Leftmost of these editor buttons switches to a plain HTML view. Link to comment Share on other sites More sharing options...
alwayspaws Posted June 27, 2017 Author Share Posted June 27, 2017 I'm aware of the HTML editor & have used it many times. I manually edited one product and it looked better so I'll tweak the HTML coding the way I want and then add that code to the descriptions on my CSV's. I have a feeling I should leave the FO CSS alone. Why aren't the short descriptions imported by my CSV? Thanks! Link to comment Share on other sites More sharing options...
jnsgioia Posted June 28, 2017 Share Posted June 28, 2017 What program are you using to store your information on your computer and is it exporting the short description to the csv file correctly? Link to comment Share on other sites More sharing options...
Traumflug Posted June 28, 2017 Share Posted June 28, 2017 @alwayspaws, perhaps you should provide some of your CSVs for demonstration the problem. The shorter, the better, as long as the problem shows up. Link to comment Share on other sites More sharing options...
alwayspaws Posted June 29, 2017 Author Share Posted June 29, 2017 @jnsgioia said in CSV problems - missing short descriptions, headers too big: What program are you using to store your information on your computer and is it exporting the short description to the csv file correctly? OpenOffice Calc and yes. Thank you. Link to comment Share on other sites More sharing options...
alwayspaws Posted June 29, 2017 Author Share Posted June 29, 2017 @mdekker said in CSV problems - missing short descriptions, headers too big: I was wondering the same. I can't reproduce any of the CSV issues you report https://github.com/thirtybees/thirtybees/issues/262 @Traumflug "perhaps you should provide some of your CSVs for demonstration the problem. The shorter, the better, as long as the problem shows up." Short descriptions are no longer missing. They are called "summary" per @jnsgioia which I forgot. Sorry! The field example (x,y,z...) has no spaces so I first entered tags with no spaces, but then Michael said to make sure there is a space in between tags so I put a space between each tag. No difference. Tags from product page in admin are cut off: Tags: dog collars collar charms char (see screenshot, please) My tags for this product from my csv are: dog collars, collar charms, charm for collars, patron saint of all animals, St. Francis Attached is a csv that has only five single products. No combinations or anything special. 014987597871916-29-17-test-blank-short-description-tags-cut-off-product-tags.csv Link to comment Share on other sites More sharing options...
jnsgioia Posted June 29, 2017 Share Posted June 29, 2017 @alwayspaws In the upload steps did you check that your short description column was under the summary header? This is a screen shot from my upload this morning: Link to comment Share on other sites More sharing options...
alwayspaws Posted June 29, 2017 Author Share Posted June 29, 2017 @jnsgioia You are exactly right. Thank you! I'm going to edit my post to reflect the tags problem. Link to comment Share on other sites More sharing options...
alwayspaws Posted June 30, 2017 Author Share Posted June 30, 2017 @Traumflug @mdekker I still have the cut off tags problem. My csv is in the earlier reply. Thanks! Link to comment Share on other sites More sharing options...
Traumflug Posted July 1, 2017 Share Posted July 1, 2017 Now I actually tried with the CSV above and see, uhm, there is no way to import tags: Twelve fields, none of them for tags. About field separators. CSV means "comma separated values" and that pretty much explains what's expected. Nevertheless 30bz has ; set as default field separator. As far as I can see, one should change this to , and multiple value separator to ;. This matches the given CSV file, then. Now, this CSV has such a multi-value field for tags. But instead of using ;, it puts all tags into one long string. This explains why it's knocked off at 32 characters. For the fix I have to guess a bit (can't test, see above): the field with tags should change from "dog collars, collar charms, charm for collars, patron saint of all animals, St. Francis" to dog collars; collar charms; charm for collars; patron saint of all animals; St. Francis See the quotes removed and , replaced by ;? That's the point. About how to fix this in the spreadsheet. Obviously it's a good idea to set ; as field separator for CSV export to match 30bz' default. That's probably the better choice for languages with , as decimal separator anyways. On how to generate multi-fields in a spreadsheet? No idea. Didn't know spreadsheets actually allow to do this and a quick google brings nothing like this up. Which raises the question: how did the PrestaShop guys expect this to work? Link to comment Share on other sites More sharing options...
Traumflug Posted July 1, 2017 Share Posted July 1, 2017 P.S.: the Categories column in this CSV file separates multi-value fields correctly. Link to comment Share on other sites More sharing options...
Traumflug Posted July 1, 2017 Share Posted July 1, 2017 P.S.: Found my mistake, I tried to import categories, which have no tags. Trying to import products had tags, then. And the result is: tag imports worked with the modifications guessed above, at least for the one product I tried: Link to comment Share on other sites More sharing options...
Havouza Posted July 1, 2017 Share Posted July 1, 2017 That would make many imports easier if you use MS excel Link to comment Share on other sites More sharing options...
yaniv14 Posted July 1, 2017 Share Posted July 1, 2017 I always use Google spread sheet to create CSV for import (File -> Download as -> CSV). I find it best to deal with unicode. Link to comment Share on other sites More sharing options...
Traumflug Posted July 1, 2017 Share Posted July 1, 2017 The question is how to create a multiple value field and whether/which spreadsheets can do this at all. :-) Right now I'm reworking tag import a bit to recognize a single string with comma separated values, too. I think it's best to allow the same type of entry as when adding tags manually. Link to comment Share on other sites More sharing options...
Traumflug Posted July 1, 2017 Share Posted July 1, 2017 Another one: having these shortened tags shown as separate tags on the backoffice product page is a hoax, obviously created by JavaScript. Looking into Backoffice -> Catalog -> Tags reveals them as a single tag with commas inside. Link to comment Share on other sites More sharing options...
Traumflug Posted July 1, 2017 Share Posted July 1, 2017 Here we go: https://github.com/thirtybees/thirtybees/issues/285 Link to comment Share on other sites More sharing options...
alwayspaws Posted July 3, 2017 Author Share Posted July 3, 2017 So issue #286 is open instead: https://github.com/thirtybees/thirtybees/pull/286 @Traumflug "Right now I’m reworking tag import a bit to recognize a single string with comma separated values, too. I think it’s best to allow the same type of entry as when adding tags manually." Yes, please! I have MS Office for the Mac but after 2 years of back and forth, everyone said that OpenOffice is best and that Excel doesn't import correctly. I create csv's from OpenOffice calc. @mdekker - I was told the exact opposite for Excel, but if it will work fine in thirty bees, I don't mind going back to it again. The only thing is MS Office is much more of a memory hog than OpenOffice. @Traumflug - I looked at the BO - catalog - tags and see what you mean but they are still cut off in case you need to know this: dogs,jewelry,charms,Saint Franci What I would like is to have the csv import fields of field separator and multiple value separator to be the same all the time. When I import products, it's one way and when I import categories or combinations it's another way: they are either comma and semicolon or semicolon and comma. I have to keep going back to the csv import page to change them. Thanks! Stephanie Link to comment Share on other sites More sharing options...
Havouza Posted July 3, 2017 Share Posted July 3, 2017 An xlsx file should be much easier to handle in my opinion, but what do I know Link to comment Share on other sites More sharing options...
alwayspaws Posted July 3, 2017 Author Share Posted July 3, 2017 @Havouza YOU know everything! Link to comment Share on other sites More sharing options...
alwayspaws Posted July 3, 2017 Author Share Posted July 3, 2017 I can try to use .xls but I need to know the exact parameters first for each of the fields that have multiple choices. Link to comment Share on other sites More sharing options...
Havouza Posted July 3, 2017 Share Posted July 3, 2017 I used a module that used xls. Then you never had to bother about separators. But ofc the importer must be built for it. Mine could use csv xls and xlsx Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now