taksmith

Tobias – yes!

I just found it a bit odd that the first cell (ie Row 1 column 1) imported and kept the quotes, when all the other cells did not (which is what I expected).

But anyway, as I said, easy to edit and I appreciate they are not really needed if the content is a single word – in our case it was “FIRSTNAME” – but would have been needed if I’d used “First Name”

Thanks again

Tom

Tobias

Really odd – I edited the csv file and took out the inverted commas around the first field name – thinking that it would not import properly – but it did, and did not place the inverted commas around the first field name in the resulting table. All the other field names have inverted commas in the CSV file – but import properly (without them)

As it is easier to do it in the CSV file than in WordPress (only because the table is sufficiently big that editing/updating takes a while)

Anyway – again, hope this helps

Tom

Many thanks – changing encoding from ANSI to UTF worked fine. I had checked for strange characters – and couldn’t find any.

Interestingly the first line contains field names and all came in correct – but the first one came in with the Inverted Commas – ie in the table there was

“Firstname”
Surname
DOB

etc

Easy to edit out of course

Hope this helps track it down or helps someone else

Thanks again

Tom

very useful, but I’d like dearly to see the users able to be mailed not hard coded – if i add a new role it does not appear in the list of users I can mail to. Thanks

I had the same problem and got into real trouble editing the classes.php code with unclosed brackets appearing in the sql SELECT string. But, if all you want to do is seacrch for complete strings (in my case I wanted people’s names – so didn’t want to find all “fred” or “bloggs” – just “fred bloggs” then add the following to the searchform.php form

<input type=”hidden” value=”1″ name=”sentence” id=”sentence” />

Then it doesn’t break up the search string. If I was really clever and needed it I’m sure you could make this a checkbox to at least allow the option