Export : Stop removing repeated values for related fields or grouped by exports

Idea created by Vincent_L on Aug 8, 2017
    Active
    Score9
    • User26869
    • robwoof
    • arnoldkegebein
    • hschlossberg
    • DamonCasey
    • jbante
    • robertnaud
    • Vincent_L
    • Markus Schneider

    Hi,

     

    To my dismay, when you export related fields (in one to many relationship), the fields of the main table are only "printed" once, their repetition is then left blank.

    Worse, even in with all records belonging to the same "local" table, if you use the sorted + grouped by fields (to get the unique combinations), the resulting file will have the grouped fields only written once individually, with blanks afterwards.

     

    so if you sort by manufacturer,color,car model the following dataset :

     

    Chevrolet    blue     viper1

    Chevrolet    blue     viper2

    Chevrolet    blue     viper2

    Chevrolet    blue     viper3

    Chevrolet    blue     viper3

     

     

    rather than having the useful :

     

    Chevrolet    blue     viper1

    Chevrolet    blue     viper2

    Chevrolet    blue     viper3

     

    you get the unusable :

     

    Chevrolet

                        blue

                                  viper1

                                  viper2

                                  viper3

     

     

     

    Obviously, the resulting files are completely unusable (except looking more legible to the human eye). I know some techniques to avoid the related table issue, but they're highly cumbersome, and not applicable for the second case

     

     

    I understand that this feature is deeply rooted in filemaker history (for some unfathomable logic), but we're in 2017 and we deserver to have useful exports. Of course make that an option (even though I deeply thing that making it default would do a huge service to all the newbies out there)

     

     

    P.S : I know I can, thanks to SQL, get the result I want. But that's:

    - Slower

    - Not easy for regular people to grasp.

     

    P.S.2 : If you've a better thread title, I'll happily change it :-)