Import CSV not working - technical details inside
Hello!
I've got a Sendy installation that has been working great so far, but I'm trying to import a list and it's not working.
Here's the server setup:
- LAMP on Ubuntu 14.04
- VPS with 2GB+ of RAM
- memory_limit is at 256mb, max_upload and max_post are both at 300mb, max_execution is 600
I've got a cron job setup properly for both automated sending and automated CSV importing. I've verified that they both work AND I've manually visited import-csv.php.
When I upload the CSV, I see it pop up as a temp file in the csvs directory under uploads (usually named 1-2.csv). As soon as the cron runs or I manually visit the import-csv.php page, the CSV disappears.
I cut the CSV into a 10 line file for a test and it failed to import as well. No errors that I can see in any logs, but I'm not sure if Sendy has its own logs as well.
My status indicator next to the list just says (0%) in green text then fades after a minute or so.
I'm a software engineer so feel free to get technical on me 
Thanks in advance!
Comments
Hi,
You should never manually visit import-csv.php. It gives Sendy a false positive, your cron job may not be working but when you visit import-csv.php it makes Sendy think that the cron job executed the import-csv.php script. From then on when you import a CSV it'll be stuck at 0%.
Send me your CSV file so I can check if it's an issue with your CSV, or your cron job is the issue.
Thanks.
Best regards,
Ben
Thanks for the help Ben.
I was just visiting the page manually for debugging. I actually did some modifications first.
It turned out that the problem was that one of the custom fields had data which was causing issues. I didn't have time to narrow it down, but it could be due to length as some of the column values for that custom field were pretty huge.