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 data including note

  1. costincristescu
    Member

    Hi,

    At devisrenovation.lu I'm using a form and I'm exporting the data in a .csv file. But one thing I don't know how to export is the note field (I'm adding a note to each of the entries.)

    How can I achieve that please?

    Thank you!

    Posted 11 years ago on Tuesday April 9, 2013 | Permalink
  2. Currently this is not possible due to the complexities involved. The entry export CSV file is a simple CSV file where each row represents an entry.

    Because an entry could contain multiple notes, adding them to the CSV export would make things much more complex.

    It would become so complex the likelihood that the end result would be used would be minimal given the parsing that would need to take place to import such a complex CSV file. The vast majority of our users simply wouldn't use it because they wouldn't have the capability to then write the import routine necessary to import the data into wherever they need to import it.

    Exporting data as a CSV isn't ideal for complex situations such as this where you could have a row that contains child rows of data associated with it. It's a situation where something such as an XML export would make more sense.

    Because XML is typically so custom based on the use case and the schema required it's not something we currently offer as an export option.

    You would need to write some custom PHP to query the data and return it in a custom format. Then you could pull in Notes at the same time and format the output however you see fit as it would be a custom implementation that you'd have complete control over.

    Posted 11 years ago on Wednesday April 10, 2013 | Permalink
  3. costincristescu
    Member

    Thank you for replying. What I need is to have a field not visible to visitors but in which I can add a note at a latter time.

    Can I maybe create field, hide it to visitors and in which I can write after that? So it will be easier to export it....

    Thank you!

    Posted 11 years ago on Wednesday April 10, 2013 | Permalink
  4. David Peralty

    You can have nearly any field as an admin-only field without issue. It is in the advanced settings for fields.

    Posted 11 years ago on Wednesday April 10, 2013 | Permalink
  5. Yes, you can add a field to your form and set its visibility to admin only. You do this by editing the field, selecting the Advanced tab and select Admin Only for its visibility.

    Posted 11 years ago on Wednesday April 10, 2013 | Permalink

This topic has been resolved and has been closed to new replies.