I take it from the silence that either the question is glaringly obvious or that is just impossible to acccomplish. Regardless could someone please respond to help me figure out this problem? Is there anyway to copy/paste or export records from a table or list layout to excel without it all being all put in one long vertical column? Does filemaker server have this capability and would I need to shell out some cash to upgrade from filemaker pro?
Thank you thank you
Thank you for your post.
With Instant Web Publishing enabled, FileMaker cannot save/export to an Excel file. Our Development and Software Quality Assurance (Testing) departments are aware of this issue, but no additional information is available.
Since you are trying to bring the data into Excel, use the SYLK format. Symbolic Link (SYLK) is a Microsoft file format used to exchange data between spreadsheets. SYLK files usually have a .slk suffix (if on Windows).
If you need additional information or clarification, please let me know.
Thank you so much for taking the time to answer my post about exporting/copying from online to excel. I have tried to research SYLK as you suggested but I'm not clear on how this might work. Would sylk somehow allow my database users to access the published database from online to bring into excel? Or would I do something with SYLK on the computer that hosts the database that might offer some solution once accessed online? I would greatly greatly appreciate any details you could provide as Im completely unfamiliar with how SYLK works and how this might help solve this issue.
If this turns out to not offer what we require for accessing our database online, would exporting/copying be possible with an upgrade or other filemaker product... would filemaker server have this capability?
We have talked privately, but let me make a public apology.
I misread your original post. I thought you had Instant Web Publishing turned on and you were working with the FileMaker Pro database. In this case, exporting to Excel is a problem.
When accessing a FileMaker Pro database file via Instant Web Publishing, you cannot export at all, so I apologize for giving you incorrect information.
FileMaker Server only serves up FileMaker Pro files and allows others using FileMaker Pro to use the files. FileMaker Pro can host up to 10 users at one time. If you need more users to access the file, then FileMaker Server would be required. No matter which product you use, Instant Web Publishing will not allow you to export the data.
Have a look at custom web publishing as this uses php and there is a class set to make .xls files on the fly. I've used it and it works really well. If you get a copy of Server Advanced you also get a very nice little wizard to make custom web php web pages.