Hello Simon.

Unfortunately…: No. CSV format, by it’s nature, requires at very least a separating character to distinguish between columns of data. This is bolstered by use of delimiting tokens, so that chances of misinterpretation of column boundaries is less likely.

May I ask why you would want no separation between columns?

I guess it’s in the name - CSV - isn’t it? (Slaps head). What I’m trying to achieve is a comma or tab between records, but no other characters around each record…

Could you just use the query module, then?

I could… but the file output is super-useful. I’ve cracked it with a dirty hack to the plugin. Cheers again!

Is there a way to filter the data by field? For example, I’m trying to pull entries from Freeform but I want to limit it to a certain form on the site. I tried using the WHERE clause, but that makes the plugin throw an error.

It does? Could you post up the sql you are issuing?

You bet, here it is:

Hmm, I can’t replicate the problem…

When you say it throws an error… how so? in the outputted file? or before? what IS the error?

Also, have you attempted running that query within the sql query form to ensure it’s not the query causing a problem?

( way too many ? but hey-hum :] )

For what it’s worth I tried a simple query

Does this work for you?

This is the most bizarre thing ever. I just revisited this issue today and the exact same code that I pasted above worked this time! I don’t know what was different, but it works flawlessly. Thanks for your help butcher!

Great plugin.

So I need to export some of the custom member profile fields for each member.

Any idea of how to do that?

Sure, just join the member data table ala:

butcher - wow that worked like a charm. Thanks!

Great plugin Daniel. Thanks for sharing it. It’s been really useful.

I wonder if you could help me. I am using the code below to get member info and one member custom field from certain member groups. My problem is that I am getting results from all member groups not just the pipe delimited selected group_ids.

Also do you know if its possible to format the display of m.join_date to read as a date rather than the amount of seconds from 1970, the start of the unix epoch, ala “1202917350”?

Thanks

Wondering if someone can help me out with the CSVee plugin.

I’ve added the following code to a blank template

I’m presented with

The following tag has a syntax error:

{exp:csvee}

Please correct the syntax in your template.

What did I do incorrectly?  Or, does this plugin not work with EE1.6.3?

Paul - Don’t know about your code. But I can confirm that it is working just fine in EE 1.6.3.

Thanks.  I got it working.  Great plugin.

In case someone’s trolling here with the same question posted by Brian M. earlier in this thread regarding multi-select fields in Freeform and export weirdness because each value is on a separate line, I came across that very thing today.

I checked in the Solspace forum, and someone did post an answer on how to fix it in Freeform. It’s very easy and it does work!

In mod.freeform.php search for this: (about line 850 in version 2.6.5)

// If the field is a multi-select field, then handle it as such.

        if ( is_array( $val ) )
        {
          $val = implode( “\n”, $val );
         
          $data[$key] = $REGX->xss_clean($val);
        }
        ...

The fix?

Replace
$val = implode( “\n”, $val );

With
$val = implode( “,”, $val );

That gives you a comma-separated list of your multiple values, which makes Excel very happy.

Hey

Great plugin, one of the best and just what I needed!
Although, I’m having problems with the character encoding, but I’m not sure if it’s on Excels side.

Opening the .csv-file using a text editor, I get this

“14”,“1”,“23”,”Äpple”,“1”,“André”

resulting in this

14   1   23   √Ñpple   1   Andr√©

Somewhat tells me this might be caused by Excel (2008 version for Mac), but I thought I’d ask anyway

Tnx
/André