English

Controlling CSV/TAB Headers

Because of its age, FileMaker has a variety of options sprinkled in a bunch of different places regarding exporting data. Some of these options relate to getting the exact export of data you need from the software.

In this video I cover a variety of specifics related to exporting data. One feature in particular is controlling the export headers you may need on your custom export. If you've ever needed to provide an output file of either CSV or TAB, and you'd like to have full control over the headers, then look no further.

You'll find all the details about formatting for custom output, injecting your own desired headers and how to deal with the output on mobile FileMaker Go vs. the Desktop client. Need customized exports? Watch this video and learn from the provided file.

Tags:
CSV
AttachmentSize
ControllingCSV:TABHeaders.zip1.65 MB

Manipulating CSV Exports

Exchanging data between systems has always been a matter of format. The output systems needs to output in the expected input format for the inbound system - and it works the same way when going in reverse.

When it comes to data interchange formats, some of the most prevalent are arguably CSV (comma separated value) and Tab delimited.

The problem with these formats however, is that one person’s CSV is not necessarily another’s. The CSV “standard” actually has no standard. There is an RFC (Request for Comments) document to act as a guideline, but it’s not an “official” standard.

For FileMaker, the standard CSV export format is lacking one very important aspect. It does not include the field names as possible headers in the resulting file.

Added to this, is the fact that you can’t just specify any encoding format on all the various export options. You are limited to the formats specified by FileMaker per export type. There are some systems where you absolutely need a more up-to-date encoding format such as UTF-8.

FileMaker also exports hard returns as the vertical tab character and this needs to be fixed for some importing operations. This video and technique file addresses all of these issues and showcases how to take advantage of some of FileMaker’s other export formats in order to make sure your data does its interchange with other systems in the expected fashion!

Tags:
CSV
AttachmentSize
ManipulatingCSVExports.zip280.29 KB