How to import contacts and use rules

Greetings developers and fellow users. This plugin looks very promising to what we are trying to accomplish with email reminders.

According to the documentation on how to create rules, you can import your contacts file in .csv format.

My contacts file has the following fields:

Name, email, phone number, submission date and pay status.

Pay status is either PAID or NOT PAID.

We would like to say, if pay status (our custom field) equals NOT PAID, then send a reminder after a certain period of time.

Here are the issues that I am having.

1, the imported file has labels (field names) jumbled into one cell. The values are separated by semi colon as per your requirement.

After importing file the file and saving to the database, they do not appear when I attempt to create a rule.

Please help me understand what I am doing wrong.

Thanks very much in advance.