CSV problems - missing short descriptions, headers too big



  • How can I fix the below problems for csv imports, please?

    1. How can I reduce the font size of header tags in the descriptions? They are way too big. See first screenshot please.

    2. Short descriptions are missing after csv import. See second screenshot, please.

    First screenshot:

    0_1498579858524_header font too big and too much space between sentences in descriptions.jpg

    Second Screenshot:

    0_1498580107125_admin missing short descriptions for products.jpg

    Thank you!


  • Global Moderator

    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.



  • 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?


  • Global Moderator

    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.



  • 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!



  • What program are you using to store your information on your computer and is it exporting the short description to the csv file correctly?


  • administrators

    I was wondering the same. I can’t reproduce any of the CSV issues you report :stuck_out_tongue:

    https://github.com/thirtybees/thirtybees/issues/262


  • Global Moderator

    @alwayspaws, perhaps you should provide some of your CSVs for demonstration the problem. The shorter, the better, as long as the problem shows up.



  • @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.



  • @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

    0_1498763639615_tags cut off.jpg

    Attached is a csv that has only five single products. No combinations or anything special.

    0_1498759787191_6-29-17-test-blank-short-description-tags-cut-off-product-tags.csv



  • @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:
    0_1498762321399_scrn.jpg



  • @jnsgioia You are exactly right. Thank you! I’m going to edit my post to reflect the tags problem.



  • @Traumflug @mdekker I still have the cut off tags problem. My csv is in the earlier reply. Thanks!

    0_1498864904306_tags cut off - 2017-06-30 at 7.17.52 PM.jpg


  • Global Moderator

    Now I actually tried with the CSV above and see, uhm, there is no way to import tags:

    0_1498901564199_CSV import.png

    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?


  • Global Moderator

    P.S.: the Categories column in this CSV file separates multi-value fields correctly.


  • Global Moderator

    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:

    0_1498905162397_upload-4a0da188-4b8e-4493-89f2-7dcea84f5179


  • administrators

    Hmmz, we haven’t documented it , but you can also import an xlsx (Excel) file directly. That’ll internally do the right conversion for you.



  • That would make many imports easier if you use MS excel



  • I always use Google spread sheet to create CSV for import (File -> Download as -> CSV).
    I find it best to deal with unicode.


  • Global Moderator

    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.


Log in to reply
 

Looks like your connection to thirty bees forum was lost, please wait while we try to reconnect.