Column names in export file

[fmsavey]

I am exporting summary fields grouped by a particular field as ".mer" files that will be imported by our payroll system (ADP). The column names in the export file must match the column names in our payroll system so I have named the fields in my FM database the same as in the payroll system. The problem is, when exporting summary data, FM changes the summarized column name. A summary field in FM called "O/T Hours" becomes "O/T Hours by File #" when grouped by File #. I know I can't have FM change the column names (right!) and I don't want to edit the export file manually. So WHAT CAN I DO?

What I thought was going to be a very simple solution is turning into a complicated one.

[jteich]

XML-Export using an XSLT stylesheet is definitely able to solve this problem. If you have no experience with XSLT transformation this might become a bit tricky for you.

I think I have an expample file for this kind of problem. Will post it if you want.

-jens

[jteich]

As a starting point you could use this XSLT:

<?xml version="1.0"?>



	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

	xmlns:fmp="http://www.filemaker.com/fmpxmlresult"

	exclude-result-prefixes="fmp">







+++HEADERLINE+++



	

		;

Just customize the +++headerpart+++ and try to export your data as XML using this stylesheet.

-jens

[fmsavey]

Thank you. My solution was to export the summarized data and then import it into another table and then export it again this time of course without the need to summarize. Doing this preserved the column names. Your solution seems more efficent. Unfortunately I have no xslt experience. Can anyone recommend a site where one might get a lesson!