Is there a way to export fields from n table i.e. the Directory to a csv in order to create data mappings for a spec for instance?
There are a few different methods. If there is an application built over the table, then you can use the “Export to CSV” form action on the list view. If there is not an application built with the view you desire, another option is to create an Interactive Report over the table. The report has options to export to either csv or pdf.
It’s also possible to explicitly create a Data Export Definition (DED) from your chosen table to a .csv. This includes field mappings from the table’s fields to columns in the .csv with your chosen labels and it can include a predefined filter or sort as well as detailed data mappings from subtables or table lookup related fields.
DEDs are useful when you need to bulk export data or do so with predefined mappings. Interactive reports or an application’s built-in export functionality are great for on-the-fly exports that include specific filter criteria - in other words, you can look for the data you’re interested in before choosing to export instead of exporting first and filtering later.
1 Like
Will give this a shot! Thank you
1 Like
Thank you. I will try this Interactive Report route, I just need a quick export of all the fields on the table which should be quicker than creating a DED.
2 Likes