Eventualo Forum

eventualo.net

1. 

   sd75003
   Member

   Hi AloEasy Mail, the plug-in is great. thank you. one question about importing CSV files. When I try to do so from a CSV Excel file, a list of all of the emails appears but next to each one is a message saying that they are not correctly formatted. Perhaps I am doing something wrong? Any thoughts would be welcome.

   Posted 1 year ago #
2. 

   alo
   Key Master

   You could use double quotes to delimit each field, as gunu suggested here.
   Otherwise maybe it could depends on excel exportation or "save as" options.

   Posted 1 year ago #
3. 

   Lucian
   Member

   Hello!

   I tried as gunu suggested but no luck.What is left to do?I need to import aprox 1000 email addresses..
   Also , does it exist an export function?

   Thanks!

   Posted 1 year ago #
4. 

   gunu
   Member

   Lucian,

   in Linux - Open Office - save as CSV (file-type and checked ON filter settings) with the ; as field separation but make the row " (as text separation) empty and try again. Be aware input only works under Linux -Firefox NOT Windows Firefox.

   Good luck

   Posted 1 year ago #
5. 

   Lucian
   Member

   Hi Gunu ,

   Thanks for the quick reply!I have Windows installed , not Linux.There is no method to import using Microsoft Office 2007 ?

   Thanks!

   Posted 1 year ago #
6. 

   gunu
   Member

   it has failed so far to import the CSV file under Windows. Only under Linux it worked.

   I do not know how far Alo is with this function to make it work under Windows.

   Posted 1 year ago #
7. 

   Lucian
   Member

   Thanks Gunu!

   I will try to see if I can get it working.

   Posted 1 year ago #
8. 

   gunu
   Member

   Lucian,

   If you want to import you addresses with Linux you can.... :)

   Got to here: http://www.ubuntu.com/desktop/get-ubuntu/download

   Download the file, once you've finished downloading your file, you'll need to create a CD.

   "Burning a CD means that you can trial Ubuntu without affecting your current system."

   If ready boot your computer from the CD and choose "Try Ubuntu without any change to your computer" After it starts you can use Firefox (Ubunu recognize your internet connection) In Firefox log in to your site and import the CSV file.

   It's a workaround but it works...

   Posted 1 year ago #
9. 

   Lucian
   Member

   Hey Gunu!

   I made it work!I changed some codes into alo_easymail_subscribers.php and it's importing fine now!

   Seems that I cannot post the codes so it can help others in our situation.Any idea?

   Posted 1 year ago #
10. 

    gunu
    Member

    Lucian,

    can you put the lines, with the numbers, in a post and explain what you changed?

    Posted 1 year ago #
11. 

    gunu
    Member

    See for an example: http://www.eventualo.net/forum/topic/28

    Posted 1 year ago #
12. 

    Lucian
    Member

    Still , I can't insert the codes.It gives me an error when posting.Maybe if I will upload a .txt file somewhere and post the link here?

    Posted 1 year ago #
13. 

    gunu
    Member

    OK it would be great if you upload a .txt file an post a link.

    Posted 1 year ago #
14. 

    gunu
    Member

    Code is disabled?

    Example:

    $mail_engine = @wp_mail($recipients[$r]['email'], stripslashes ( $sending_info->subject ), $updated_content, $sending_info->headers);

    Here it seems to work

    Posted 1 year ago #
15. 

    Lucian
    Member

    Sorry , seems that I don't know how to use the code tag on bbpress.

    http://www.megafileupload.com/en/file/257640/import-csv-txt.html

    I changed the delimiter from ";" to "," .Make sure you use the new one.

    Test it and let me know!

    Thanks!

    Posted 1 year ago #
16. 

    gunu
    Member

    File to change : alo-easymail_subscribers.php

    LINE 268 :
    AFTER

    "text/csv"

    place this

    || $_FILES['uploaded_csv']['type'] == "text/comma-separated-values" || $_FILES['uploaded_csv']['type'] == "application/csv" || $_FILES['uploaded_csv']['type'] == "application/excel" || $_FILES['uploaded_csv']['type'] == "application/vnd.ms-excel" || $_FILES['uploaded_csv']['type'] == "application/vnd.msexcel" || $_FILES['uploaded_csv']['type'] == "text/anytext" )) {

    LINE 279 :
    $data = fgetcsv($handle, 1000, ";"

    REPLACE WITH:
    $data = fgetcsv($handle, 1000, ","

    No change, NOT a valid CSV file

    Some characters missing?

    Posted 1 year ago #
17. 

    gunu
    Member

    changed the delimiter from ";" to "," and changed code line 268

    Now changed the CSV file with the "," and it is still working under Linux but not under Windows...

    Posted 1 year ago #
18. 

    Lucian
    Member

    Working fine at me.

    On line 268 , remove the type conditions

    && $_FILES['uploaded_csv']['type'] == "text/csv"

    see if it's working like that.

    Posted 1 year ago #
19. 

    gunu
    Member

    Strange.

    CSV import not working on IE7 - IE8 - Firefox 3.6.8 and Safari (for Windows)3.1.2

    Windows XP

    I tried different changes in the script but it is not working here.

    Ubuntu Linux = OK

    Posted 1 year ago #
20. 

    gunu
    Member

    Found a Windows solution here !

    The original "alo-easymail_subscribers.php" file.

    Changed only at the end of line 268

    ['type'] == "text/csv" )

    To

    ['type'] == "text/plain" )

    Renamed the original CSV file extension from .csv to .txt

    Worked in Windows on IE7 - IE8 - Firefox 3.6.8 and Safari (for Windows)3.1.2

    Also worked in Ubuntu Linux.

    Also tested the delimiter ";" and ",". Worked both, what you prefer you must change on line 279

    It also recognizes errors in emails.

    Posted 1 year ago #

RSS feed for this topic

Reply »

You must log in to post.