Import CSV > Should column titles have quotes

Hello –

I exported a CSV from s2Member, copied and pasted data into the columns already listed in the exported CSV and made sure cells have double quotes.

Two questions:

1. (Kinda dumb but): Should the column titles also have quotes? Like ID (or “ID”) or Email (“Email”)?

2. I have a column of dates e.g. 11/14/09 – do those also need quotes? And if so how can I add the quotes to the dates column. If I try and convert like I did the text, it bungs up the dates. I’ve looked around for an answer online but none seem to work. I’m really hoping they just don’t need quotes!

Thanks.

2. I have a column of dates e.g. 11/14/09 – do those also need quotes? And if so how can I add the quotes to the dates column. If I try and convert like I did the text, it bungs up the dates. I’ve looked around for an answer online but none seem to work. I’m really hoping they just don’t need quotes!

To import Users you should ensure that all data fields are properly encapsulated by double-quotes, and separated by commas, as detailed here:

Knowledge Base » Import (or Mass Update) Users

That being said, s2Member should be able to parse non-encapsulated values, as long as they do not contain commas. I just tried this in a test installation and it seems to work just fine, but you may run into issues with this if you try anything too fancy. I’d recommend using quotes whenever possible.

thank you!