ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

how do I include the weblog title to export in CSVee

January 19, 2011 2:26pm

Subscribe [2]
  • #1 / Jan 19, 2011 2:26pm

    Eastwood Design

    605 posts

    here is my code

    {exp:csvee filename="filetosave.csv" query="SELECT field_id_5, field_id_6, field_id_7, field_id_8, field_id_34, field_id_9, field_id_10, field_id_11, field_id_12, field_id_29, field_id_30, field_id_31, field_id_32, field_id_33, field_id_34, field_id_35, field_id_42, field_id_43 FROM exp_weblog_data WHERE weblog_id =12"}

    How do I include the title in these weblog entries?

  • #2 / Jan 20, 2011 5:23pm

    John St-Amand

    865 posts

    The title isn’t just field_id_1 or field_is_2?  I’m guessing you probably tried that, just thought I’d ask.

  • #3 / Jan 20, 2011 5:40pm

    Eastwood Design

    605 posts

    The title isn’t just field_id_1 or field_is_2?  I’m guessing you probably tried that, just thought I’d ask.

    I didn’t try that but I am pretty sure field_id_1 is just for the first custom field you create.  I am using a workaround of just a weblog entry and then using a php script to export the csv file

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases