Internal Server Error After a few imports
- Thread starter Matheus Muller
- Start date
Vpul Shah
Well-Known Member
Use Queue Import so in background it will run to Import.
I have met a different CSV file import misplacement issue. You can see in the attached file, I had imported the email, company name and the contac person's name by using the existing 3 variables of Email, First name and Last name. However, when I imported the data with the CSV utf8 or normal CSV, I found that part of the Last name (i.e, contact person's name) had been imported into the 2nd variable: First name (i.e. Company name). Could you please tell me the reason and how to solve this issue. Many thanks. David Ji from China.
In addition, I have attached the CSV file with the Utf8 format, which has 3 clear varibles with all filled data. Could you please tell me how to solve this subscriber list import misplacement issue?
In addition, I have attached the CSV file with the Utf8 format, which has 3 clear varibles with all filled data. Could you please tell me how to solve this subscriber list import misplacement issue?
Attachments
Last edited:
twisted1919
Administrator
Staff memberAre there any one who can help me solve the CSV file import misplacement issue? As you know, when the contact person variable is mixed with Company variable, the imported data is almost useless for us. Could you please tell me how to solve this problem mentioned in #24? As we are urgent to send the email campaign early next week.
I just tested this and seems that all it's working correctly, bellow a picture for example:
can you tell us which version of MailWizz are you using?
Thank you very much for your test with the CSV file Utf8 format, and It is quite strange that your uploaded result works very well. Currently, we haven't solved the CSV file utf8 format uploaded issue by ourself. However, we tried another way by uploading the CSV file to a mysql database, which are more user-friendly to double byte (Chinese character), then upload the file to Mailwizz by sql database. Through this method, we can use the uploading function of Mailwizz. However, we really want to upload the file through CSV file utf8 format directly. In fact, we had installed Mailwizz 2.68 on XAMPP with PHP7.4 on the windows server, and upgraded to Mailwizz 2.69 and 2.70 repectively. By the way, what addtional configuration you recommend us to do in order to accurately import the CSV file with Chinese characters in utf8 format.
Another question regarding to the importing the CSV file, as we are quite new with Mailwizz, do you know how to Change the First name (the company information) to the Company name variable? As we have lots of subscribers data with email, company name and contact person (B2B business), however, we haven't found the company name directly, so we currently use First name to input the variable of Company Name data, and use the Last name to input the contact person. Thus, if we want to use the really Company Name varible to upload the CSV file to solve the following misleading issue in campaign, what is your instruction for the CSV file preparation and the action for the list uploading interace on Mailwizz.
To clarify, there’s nothing special you need to configure in MailWizz to make the CSV import work correctly—even with UTF-8 and Chinese characters. The most important step is making sure your CSV file is formatted properly.
When you go to upload a CSV file in MailWizz, there is a "click here" link shown in the upload modal window. That link allows you to download a sample CSV file. I highly recommend using that as a reference for your own files. You can see it in the image below for clarity:
Also, if you'd like to use custom fields such as "Company Name" instead of reusing "First name", you can do that easily:
Steps:
- Go to your list → click "Custom fields".
- And add a field like COMPANY_NAME.
- When preparing your CSV file, make sure one of the column headers is exactly COMPANY_NAME.
- Then during the import, MailWizz will match that field accordingly.
Best,
Laurentiu
Thank you very much for your detailed explanation on the CSV file and Customer Fields, Laurentiu. Up to now, we have successfully to uploaded the sql file with 3 variables of Email, Company and Contact in the 1st attachment. And we have successfully sent 2 campaigns with our test namelist and uploaded template imported from mailwizz Gallery in the 2nd attachment. Could you please tell me how to add the information above the template in the 3rd attachment, like : Dear *** , as we know that you are in charge of the business of ***company, currently, we are conducting our business introduction compaign and please find the detailed offers for you as follows: Then, I can modify all the email template information into Chinese as our business compaign template. Could you please tell how to add the customized contact person's information and company information just above Email template. Your early reply will be highly appreciated!
Attachments
If you upload an external template to MailWizz then I recommend to use GrapeJs as builder in order to can update your template, using another template builder when you upload a template to MailWizz this will crash and will broke the template. For a best experience i recommend to use one template builder and build your own template from scratch, if you prefer to upload templates which are downloaded from internet, then you need to use GrapeJs or CKeditor to update these in campaign.
As template builder MailWizz have: Stripo, GrapeJS, and our Email Template Builder.
If you want to use builder you need to click on "Toggle template builder" button and the template builder will appear, but keep in mind what i said above, to edit with CKeditor simply use the buttons which are available on the screen from that content.
Best,
Laurentiu
Dear Laurentiu, thank you for your recommendation of Stripo, GrapeJS, and our Email Template Builder, and we will test further. In addition, after we had solved the variable issue, we have met a new SQL import issue. When we imported a list of 14988 subscribers by SQL, and the first 10K subscriber was imported correctly, however, for the rest 4988 subscribers was stopped and Mailwizz provided the error information. Could you please tell me how to import 14988 subcribers into one list instead of seperating them into 2 files? What should we do if the subscriber is over 10K to 20K, or over 20K? Your early instruction will be highly appreciated! After a quick look of the uploaded list in Mailwizz, I have found that 14988 subscribers seem to be imported into the list file in the 2nd attachment, and I have checked the detailed list in page 15 with 1K subscribers on each page. The 2nd and 3rd attachment seems that the SQL import action of 14988 subscribers have been done successfully. However, why I have got the error information in the 1st attachment. In addition, for future data import over 10K or 20K subscribers, how will you recommend us to do in a right way?
Attachments
Last edited:
For large files use CLI import is better and run in background and you will not get errors during the import, activate this on Backend > Settings > Import/Export > CLI import enabled , press the info button and there you will find what cron to add in order to work.
Best,
Laurentiu
Dear Laurentiu, thank you very much for your recommendation of using CLI import. I have enabled this function. However, in order to get the result soon to avoid future wrong feedback, I have changed the import at once to 20K. Do you think this can be workable for my case of the import of my 14988 subscribers?
Attachments
We recommend keeping this value lower to ensure data is uploaded to the database in smaller batches. However, the optimal setting may vary depending on your server's specifications. For best performance, we also suggest following the recommendations in this article: https://www.mailwizz.com/kb/performance-improvements/