+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / 6.1 Mewsletter Subscriber import

6.1 Mewsletter Subscriber import

5 posts, 0 answered
  1. Markus
    Markus avatar
    2763 posts
    Registered:
    25 Nov 2005
    16 Aug 2013
    Link to this post
    Now I start looking at newsletter campains and as usual come with questions and ideas.

    When I save an excel file as csv it will save it with semi-colon seperatation not comma. Might be a regional setting. I am using Excel 2010 German version.

    Would it be possible to give 3 option on import tab,  semi-colon and comma?

    -----------

    Subcribers are show with first name and last name combinde. Would it be possible to have that splitted in the overview?

    Vorname = Frist name
    Nachname = Last name

    Markus
  2. TMatt
    TMatt avatar
    104 posts
    Registered:
    06 Feb 2011
    18 Aug 2013
    Link to this post
    Hi Markus,

    you can choose the CSV formart when you use "save as". And then you can Change the delimiter of the CSV.
  3. Markus
    Markus avatar
    2763 posts
    Registered:
    25 Nov 2005
    19 Aug 2013 in reply to TMatt
    Link to this post
    Dear TMatt

    Excel will save the csv as comma or semicolomn seperated csv files according to the country and language settings. In Swiss german the "Listentrennzeichen" seems to be semicolomn by default.

    Of course I could change it there but this is a bit strange. Ecxel does not let you choose if you want to save seperated by comma or semicolumn. it just gives you the option to save the CSV as sperated list.

    See attachment.

    Therefore I stay by the feature request to have 3 import options.

    Markus
  4. Kaloyan
    Kaloyan avatar
    272 posts
    Registered:
    02 Dec 2016
    21 Aug 2013
    Link to this post
    Hi guys,

    @Markus
    Actually this depends on the regional settings of the computer. Excel uses the List separator setting when creating a CSV files.This setting can be changed in Region and Language -> Additional settings in control panel.

    Regards,
    Kaloyan
    Telerik
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Markus
    Markus avatar
    2763 posts
    Registered:
    25 Nov 2005
    21 Aug 2013 in reply to Kaloyan
    Link to this post
    Dear Kaloyan

    Thank you very much confirming what I just wrote in my last post.

    However I still think it would make sense for both options , and ; seperated because 

    a) you have to figure out first that the spearation is different
    b) then you have to figure out that you can not change the default in excel
    c) then you have to find the regional settings
    d) then you have to have rights to change that
    e) then you need a pat on the back because you were so smart but wasted 2 hours searching

    So having the option to import ; or , would save all that hassle.

    Markus
5 posts, 0 answered