Newbies FMphile Posted June 22, 2022 Newbies Share Posted June 22, 2022 Trying to found out why it is necessary to run a csv file through Mac Numbers (it is not recognized by Mac Excel), i.e., by importing into Mac Numbers and then exporting again as a csv file before it will be accepted by an external system. Looking at the "before" and "after" csv files with TextEdit, the "before" file appears to be blank, the "after" file is what you would expect - text with commas. FM 19 does not seem to have any relevant options to influence the process at all when scripting the Export Records step. Any suggestions would be greatly appreciated! Link to comment Share on other sites More sharing options...
Ocean West Posted June 22, 2022 Share Posted June 22, 2022 Script it but save it as merge and use csv as in file name. or use the file data functions. Link to comment Share on other sites More sharing options...
comment Posted June 22, 2022 Share Posted June 22, 2022 Please provide a way to reproduce this problem. Although I do not have Excel installed, I most certainly do not see a "blank file" when I examine a file exported as .csv in a text editor. Link to comment Share on other sites More sharing options...
ggt667 Posted June 22, 2022 Share Posted June 22, 2022 (edited) I never export TSV or CSV from FileMaker, I always export as XML, and then apply an XSLT to generate the TSV, LaTeX, CSV, MySQL, M$SQL, PostgreSQL, StoryBoards, CoreData, REST, DSL, or others to my liking. Edited June 22, 2022 by ggt667 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 673 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now