Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • ewuski 97 posts 263 karma points
    Aug 22, 2023 @ 00:38
    ewuski
    0

    Issues importing subscribers to mailing list

    We've been recently trying Newsletetr Studio (first time) on our localhost - to try if it works for us and whether it is better for us than other tools.

    We've been running into issues just right at the begining - when trying to import subscribers from csv file.

    We are using Umbraco 10.0.0 and NS v 10 also.

    1. When importing data from semi-colon delimited csv we have the following issues:

      a. if we have first row as column names the NS appears to be trying to automatically map columns to those defined in Settings - that is good. Unfortunately, mapping them incorrectly - putting the entire data (with semi-colons and all delimited details) under first column.

    enter image description here

    b. When trying to import without the column names row, - not all columns are displaying first 3 rows data in previw despite they are correctly delimited. We tried with only 1 row, 3 rows etc. just to try it out how the import will behave. If we are successful in importing the rows at all, some data (that is not showing in preview before moving to next step) are not imported, eg. these fields for the improted rows show empty.

    enter image description here

    Are we doing something incorrectly? Shall we look out for something specific when importing or is it a bug?

    ALSO

    1. I thought there was a way in previous versions of NS to import subscribers straight from custom db table by using a SQL query?

      Maybe there is a way to import programatically straight from our API instead?

    2. How to remove selected subscribers from the list or update subscribers in batch (instead to go into each subscriber and manipulate data individually)? If we have an updated list of subscribers we would like to import/ update them in batch instead trying to locate the ones that changed manually as this is not efficient.

  • Markus Johansson 1924 posts 5831 karma points MVP 2x c-trib
    Aug 22, 2023 @ 08:46
    Markus Johansson
    0

    Hi!

    Thank you for trying out the package and sorry to hear that you have issues with the import!

    It certainly looks like something goes wrong here, would it be possible for you to share a file with similar data but replace anything that might be sensitive? I just need a few rows to try to reproduce the problem. Could you send it to markus [at sign here] enkelmedia.se?

    Reg. your other questions.

    1 There is something called a "Recipient List Provider" that is basically C# code that can fetch recipients from any source. This way data will always be up to date from the original data source. https://www.newsletterstudio.org/documentation/package/11.0.0/develop/recipient-list-providers/

    2 We do not support this with the current import feature but it might be something to consider for the backlog. What kind of information are you storing that might need to be updated?

    Cheers!

  • ewuski 97 posts 263 karma points
    Aug 22, 2023 @ 09:04
    ewuski
    0

    Thanks for quick reply.

    I will get the examplary records sent you.

    1. For example when a user unsubscribes from the list at our end or fills in his surname, he gets a promo code etc. then we'd need to synchronise our recipient list with NS.

    Also is there any recipients export tools in NS if we need to synchronise the data the other way round, eg. if a use unsubscribes using NS link?

  • Markus Johansson 1924 posts 5831 karma points MVP 2x c-trib
    Aug 22, 2023 @ 13:10
    Markus Johansson
    0

    Hi!

    Great! I got your file and just to share the solution here if anyone else has the same problem. The file had different separators for column headers and the row columns which is not supported, the same separator need to be used.

    ex:

    firstname,lastname,email
    john;doe;[email protected]
    

    needs to be:

    firstname;lastname;email
    john;doe;[email protected]
    

    or:

    firstname,lastname,email
    john,doe,[email protected]
    

    1.

    I understand, at the moment we do not support this with the built-in import feature but maybe there is a way to update these fields programmatically or maybe the Recipient List Provider-approach might work for you?

    2.

    There is no export for the recipients but the data is in the database.

    It feels like this import/export way of working might introduce synq-issues, wouldn't it be better to for example have the website (either the Newsletter Studio recipients-feature or a custom table) be the single source of truth?

    And if someone unsubscribed "on your end" you could just update this directly in the CMS?

    Cheers!

  • Markus Johansson 1924 posts 5831 karma points MVP 2x c-trib
    Aug 23, 2023 @ 23:15
    Markus Johansson
    0

    Hi!

    Just wanted to let you know that the import-issue has now been fixed. There is a release for all supported versions of the package.

    https://www.newsletterstudio.org/installation/

    V10-specific information: https://www.newsletterstudio.org/versions/10/

Please Sign in or register to post replies

Write your reply to:

Draft