PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Export Unread, Starred, something...

  1. I've seen a few people asking similar questions, but no solutions as actually posted of yet. The date range thing is nice with export, but I have a client whose site receives a lot of entries in a day, and so if they export by date, they run the risk of losing entries logged later in the day. It would be REALLY nice to be able to add the ability to export by "unread" or by "starred" as well as by date. Can anyone walk me through that? I've seen posts where the recommendation is to edit the export functionality in the plugin export code, but I can't find it, nor do I know how I would call the "star" or "read" status...
    Another possible solution would be to move the posts to trash automatically after export. But I have NO CLUE how to implement that.
    Site needs to be done in 2 weeks, so I'll need to get moving on this...
    Thanks for your consideration/help!

    Posted 12 years ago on Thursday October 18, 2012 | Permalink
  2. is_starred and is_read are both values stored with the lead in the database. However, they're not included in the export, nor are they available to use in the field selections FOR the export. However, there are two filters you could use:

    http://www.gravityhelp.com/documentation/page/Gform_export_fields
    This will add fields to the entry export selection list.

    http://www.gravityhelp.com/documentation/page/Gform_export_field_value
    This will allow you to populate these new columns you added to the selections.

    You could use gform_export_field_value to populate the two new fields, maybe "Starred" and "Read" with the values which are stored in the lead table. That would at least populate the export with the values for Starred and Read. You could not use it as a selector for the export, but you could process the CSV and know if the entry was starred or read.

    If not that, I usually use the entry ID which is unique, to know what the last entry was that I exported. I end up having one spreadsheet usually, of all the leads, so I just pick up new record which come after the last one I previously exported and stored in the spreadsheet.

    Posted 12 years ago on Thursday October 25, 2012 | Permalink
  3. Wow. That was awesome. This has everything the client should need. I was thinking about using the entry id, but my concern is the client has a turnover of employees, and this record could be lost. The ability to export read/unread etc as an export field ensures that someone could come in out of nowhere and be able to know from day 1 what are new entries and export them.

    Posted 12 years ago on Thursday October 25, 2012 | Permalink
  4. Let us know if you need help implementing that or if you run into a snag. Sorry for the delay in our response.

    Posted 12 years ago on Thursday October 25, 2012 | Permalink
  5. No worries. You guys are usually super fast. One of the reasons I love this plugin.

    Posted 12 years ago on Thursday October 25, 2012 | Permalink
  6. thinksoda
    Member

    Hi there,

    I'd love to be able to export just the 'Starred' values from a form. Maybe something for the next version?

    NK

    Posted 12 years ago on Monday December 3, 2012 | Permalink
  7. I'll tag it as a feature request. Maybe it can be added as an enhancement in a future version.

    Posted 12 years ago on Monday December 3, 2012 | Permalink