cheshire-cat

I meant to export XML with XSTL converting option you suggested?

Ok, thanks for the explanation, it seems to be a very powerful export tool! I am not acquainted with the XSL syntax, so it would be hard to modify it if I need to, but I might give it a try. Can I just export xml using Export Records [No dialog, "PATH", "FMPXMLRESULT"]?

Thanks! Both are very elegant solutions. Concerning the second one I am looking for a Filemaker-only solution that directly exports the file to the assigned location on the server, so I really want to avoid additional converting steps. I never used the ExecuteSQL function before, so I need to try it and see whether it exports corresponding records and not the whole table as you describe. I am afraid I will end up doing the loop, but I have no idea about Filemaker syntax unlike R or Python which are quite intuitive.

A B C 1 Sep 2020 25 2 May 2022 15 Hello, please forgive me the use of wrong terminology because I am rather new to Filemaker. I need to export a table with variable number of records crossreferenced in my current table in a row by row way, meaning I want to add some information before and after the records in every row and be able to choose the separator between the records and between the rows. To make it easier to understand I gave an example of the table above. If I use the following function it gives me only the first row ignoring all other rows: List(Table::A;Table::B; Table::C) I can get individual values from the row X using the following function: GetValue ( List(Table::A) ;X) So I can get the records from the row X one by one using this function, but I don't know If there is a way to get the whole row X as a list. Next, I am considering making a loop based on the above expression going through all the rows exporting the following tab separated file: Date (TAB) Sep (TAB) 2020 (TAB) 25 (TAB) End Date (TAB) Sep (TAB) 2020 (TAB) 25 (TAB) End There are more (variable number!) rows in the table and the expressions Date and End are more complex combinations of other records but I made it simple for the purpose of the question. Is there an easier way to do that than using a loop? If no, how would the loop look like? Any help would be much appreciated. Many thanks in advance!

Thank you, that's exactly what I was looking for!

I am sorry if this question was already asked here, but I couldn't find the exact answer to it here or elsewhere yet. And I am new to the Filemaker administration so please forgive me the use of the wrong terminology. I am starting to work with a database that contains a bunch of sensitive data, so I am looking for a way to copy the database structure including tables, relationships and layout without the data content (records) in order to work on that "empty" database to include new tables, change the layout, implement new functions and scripts before applying changes to the original database. Is there a way to do that? Many thanks in advance!