CiviCRM Community Forums (archive)

Hi,

The csv is europe has different separators, so you are never sure it you need a column or semi-column (based on the version an language of excel).
Moreover, it assumes wincharset, no unicode AND excel doesn't let you change it.

Fe "workaround" is to rename the csv into txt (and for that you have to change the settings of windows so it displays the extension), go to excel, change the option to be able to open .txt, then you have a wizard where you can set both the separator and the charset.

That is not userfriendly at all.

Fortunately, if you generate an html table and set the type to excel, it works directly (well, with a warning message), but at least the format is respected.

I'd like to add on the export an option to choose if you want to generate csv or excel on the export.

As for the import, if you detect that there is only one column, try other separators (tab or , or and if one gets more than one column use it as the separator for this import.

X+

i'd like to make a few underlying items that we'd like to accomplish in the code sprint: (and which i think made the NY sprint quite successful)

1. No new features (if anything involves writing lots of new code, creating tables it is a new feature

2. Integrate / generalize community contributed code (gift aid is a good example here. In NY we integrated multi-job mailings, made progress on SMS / using names instead of ids etc)

3. Help improve apis (and standardize on the conventions used, fix a few of the most "broken" places)

4. Add lots and lots of unit and web tests

5. Add new "general" hooks as needed (mostly to integrate item #2)

lobo

The csv is europe has different separators, so you are never sure it you need a column or semi-column (based on the version an language of excel).
Moreover, it assumes wincharset, no unicode AND excel doesn't let you change it.

I think the above is referring to colons and semi-colons. Not trying to be clever or picky - just aware there are others with something other than English as their first language who may get confused by it.