If you are uploading many lists and the list field/column names are the same from list to list, make a template version of your list and then copy it to use for a new list.
Let’s say my lists always include the following fields:
Instead of constantly having to create a new list, add the additional 4 fields and then rename them, create an empty list (or you can use an existing one that works for you) with the fields of interest.
When it’s time to upload a new list with these fields, just copy the template list to create a new list, rename the list, and upload your file.
This process also works if your new list has a few more fields in it compared to the template list. Copy the template list and just add the extra fields you need for the new list.
Here is what makes this tip the most efficient:
- all lists have the same number of fields,
- the fields are named the same,
- the field order is the same, and
- the data file you’re uploading starts with the emailaddress field.
You can always add/delete fields and rename them. If the fields are the same, but not the order, you can take care of that during the file upload (when you tell JangoMail the order of the fields in your list).
Here is a step-by-step example:
1. In the Lists section of the user interface, create a new list. Name the list with something that stands out as a template (in terms of being able to identify the list later for you and other users who access your account).
2. Inside the list, go to the Fields tab.
3. Add as many fields as needed with the blue button on the right. Don’t worry about the names yet.
4. What the list looks like before renaming the newly added fields.
5. Pick a field and click the pencil icon to edit the field. In this example, I’m renaming NewField to FirstName in the Field Name text box. This box is the only one that must be changed; the other options on the popup are optional. See the note below. Click Save and return to the fields page.
Note: When you edit a field, there will be several additional options. These determine how fields may appear and be used in our website opt-in form and the list member modification form. They aren't necessary to adjust at this time, unless you will be utilizing either of those features.
5. Continue the renaming process until done.
6. Go back to Lists, and click the copy icon to create a new list.
7. The new list will start with a name of the old list, with “(Copy)” appended to the name. Rename the list as needed. Just copy the fields, no data in involved here.
8. Back in Lists, select the new list and start your data import.