1. Guest, for a limited period of time, you can buy MailWizz with a discount of 40% for both license types. Grab it now!

List Export results in tiny corrupted ZIP file

Discussion in 'General discussions' started by Papapooch, Jul 6, 2018.

Tags:
  1. Papapooch

    Papapooch Member

    Joined:
    May 25, 2017
    Messages:
    102
    Likes Received:
    9
    S.E:
    2019-01-05 13:10:43
    L.T:
    Regular
    L.C:
    3
    Hi,
    Has anyone had this problem?
    We are on version 1.5.1. waiting for the next version with the slow sending fixed before we upgrade.

    We tried exporting one of our average sized subscriber lists of 45,000 names using the List Tool for exporting to CSV. We opened the specific list we wanted and then selected Tools.
    The screen showed that the export was successful with 0 errors.

    We received a small ZIP file of only 347k!
    And it could not be opened.

    Is there a fix for this?
     
  2. laurentiu

    laurentiu Member Staff Member

    Joined:
    Mar 13, 2018
    Messages:
    63
    Likes Received:
    8
    @Papapooch - Did you try command line export ?
     
  3. Papapooch

    Papapooch Member

    Joined:
    May 25, 2017
    Messages:
    102
    Likes Received:
    9
    S.E:
    2019-01-05 13:10:43
    L.T:
    Regular
    L.C:
    3
    @laurentiu - We are trying to get the list contents with all the custom field values. I think that the command line may only give the basic fields in mw_list_subscribers.

    Thanks for answering. I will try command line. Wish I knew how to construct the view that will give me all the fields.
     
  4. laurentiu

    laurentiu Member Staff Member

    Joined:
    Mar 13, 2018
    Messages:
    63
    Likes Received:
    8
    @Papapooch - What values you have in backend -> settings -> import/export -> exporter setting?
     
  5. laurentiu

    laurentiu Member Staff Member

    Joined:
    Mar 13, 2018
    Messages:
    63
    Likes Received:
    8
    @Papapooch -
    It will give all fields form your list.
     
  6. Papapooch

    Papapooch Member

    Joined:
    May 25, 2017
    Messages:
    102
    Likes Received:
    9
    S.E:
    2019-01-05 13:10:43
    L.T:
    Regular
    L.C:
    3
    here are the values in the Exporter settings in a screen shot. I will now try the command-line export. I also include export steps taken. list export process.png export file corrupt.png exporter settings.png
     
  7. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,266
    Likes Received:
    613
    S.E:
    2018-11-06 14:46:35
    L.T:
    Regular
    L.C:
    6
    If you cannot open it with another unzipper, then download it again, perhaps it was just a network hicky that created a corrupted file.
     
  8. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,266
    Likes Received:
    613
    S.E:
    2018-11-06 14:46:35
    L.T:
    Regular
    L.C:
    6
    The slow sending has been fixed, the patch is on the forum.
    Get in touch if u need it upgraded ;)
     
  9. Papapooch

    Papapooch Member

    Joined:
    May 25, 2017
    Messages:
    102
    Likes Received:
    9
    S.E:
    2019-01-05 13:10:43
    L.T:
    Regular
    L.C:
    3
    @frm.mwz Thanks so much for helping. I may upgrade MW this Sunday.
    I was able to get the list to export with all the custom fields using the command line.
    The CSV file exported was 3 mb and it was just fine.

    That CSV was much larger than the zip file that was produced by the Frontend.
    I tried 7-zip and Winzip to open the ZIP...both failed.
    And I had tried several times to export from the Frontend with the same results.
    It looks as if the front-end export fails to produce a valid file for lists of approximately 50k names or more. But I still need to verify that by exporting some smaller lists to make sure they work well.
    BTW...we have 30 GB of memory on the server so I don't think that is the problem.

    At least now we have a way to export with confidence.
    Thanks
     
  10. laurentiu

    laurentiu Member Staff Member

    Joined:
    Mar 13, 2018
    Messages:
    63
    Likes Received:
    8
    @Papapooch - Put lower values on exporter settings and try again.
     
  11. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,266
    Likes Received:
    613
    S.E:
    2018-11-06 14:46:35
    L.T:
    Regular
    L.C:
    6
    This between the webserver settings and php settings, probly it times out somewhere, so align those values and it should work. The cli is better though, as you did :)
     

Share This Page