8 Replies Latest reply: Feb 26, 2015 4:01 PM by Grant Perkins RSS

    Problem exporting in Datawatch Modeler v12.0.5 - Path is not of a legal form

    Robert Niesen

      I'm new to using Datawatch Modeler after having used Monarch Professional 10.5 for about 5 years.  I'm having problems doing exports.  Was able to export just fine yesterday, but today I can't get them to work.  I'm getting a message that the export failed saying "The path is not of a legal form."  I don't understand this, because the directory I'm sending the export to is the default path that is assigned by Modeler when you install it.  I'd appreciate any help anyone can provide.

        • Re: Problem exporting in Datawatch Modeler v12.0.5 - Path is not of a legal form
          Lovely Gonzaga

          Hi Robert,

           

          We can try to replicate this issue. If you send the files to support@datawatch.com, then we can try your files on our end and verify the error.

           

          Thanks,

          Lovely Gonzaga

          Datawatch Global Support

          • Re: Problem exporting in Datawatch Modeler v12.0.5 - Path is not of a legal form
            Bernadette Caritativo

            Hi Robert,

             

             

            Is it a different export from yesterday? Does the file name contains special/invalid characters?

            If you are exporting to a file server, it could be that at that moment it is inaccessible.

             

            Regards,

            Bernadette

             

             

             

              • Re: Problem exporting in Datawatch Modeler v12.0.5 - Path is not of a legal form
                Robert Niesen

                I’m not sure what the problem was before, but I’m now able to successfully export summaries.

                 

                Regards,

                 

                Robert Niesen

                  • Re: Problem exporting in Datawatch Modeler v12.0.5 - Path is not of a legal form
                    Olly Bond

                    Hello Robert,

                     

                    In Monarch, you can call your summary a name like "Betty's Music Store", and when you export this to Excel then Monarch does a really good job of turning this into something that Excel allows as a worksheet name like "Betty_s_Music_Store". When you export summaries, you can tell Monarch to make a new file for each key value, or for each filter, so Monarch has to work pretty hard to turn the names you chose for these, or which appear in your data, into valid worksheet table names, or valid Windows file names.

                     

                    You might find that the error is caused by illegal characters that Windows can't cope with in file names - which include "\", "#", and "$". As well as these characters being problematic anywhere they appear, watch out for filenames with leading or trailing spaces, or files called "." or "..". Basically, if you can manually browse to the folder and create a new file and rename that file as "something.xlsx" or "whatever.txt", then Monarch won't have any problem doing the same.

                     

                    In Options, where you find the standard export path, it might be worth trying to copy that path and test that you can open it in Windows Explorer. Perhaps the drive letter or the server name of the share might have changed.

                     

                    Best wishes,

                     

                    Olly

                  • Re: Problem exporting in Datawatch Modeler v12.0.5 - Path is not of a legal form
                    Robert Niesen

                    Well, I'm having problems again.  I'm having a number of exports that run and run for a very long time and never complete.  Even though it doesn't complete, it does create an Excel file with 0 bytes when I cancel the export.  When I try running it again, that's when I get the error message about the path not being of a legal form.  It would appear that the overwrite file when output files exist option is not working properly.  I just recently upgraded to Version 12.4.1.3719 32-bit version, and the problem persists even in it.

                     

                    It seems that my exports are not completing when I have the 'Embed the page Setup header in the worksheet title' option checked.  I normally have this and the 'Include Formulas to facilitate editing in Excel' option checked.  I've had numerous exports fail when I have both checked, but then it will successfully export it when I uncheck the 'Embed the page Setup header in the worksheet title' option and change the name of the export file (although the export still takes longer than I would expect even for a summary that doesn't really have that many rows and which I had just generated and have displayed).  This is something I never had a problem with in Monarch Professional 10.5, but I'm having all kinds of problems with exports in this newest version of Datawatch Modeler.  I really need to have this header information appear in my exported spreadsheet, because this is how I document what input file, summary, filter, etc. that I've used for creating the exported spreadsheet.  I don't want to have to go back and input this information into the spreadsheet manually after I've exported it.

                     

                    Although Datawatch Modeler is now handling some huge input files that Monarch 10.5 choked on, in general I've found it to be very frustrating.  It seems extremely slow and unstable, and the GUI is a mess and extremely unintuitive.  There was absolutely nothing wrong with the old interface.  Instead of making my life easier, it's taking me much longer to do things in Modeler than it did in Monarch.  And yes, I actually worked through the entire Learning Guide to help with the learning curve due to the major changes to the interface.  I actually discovered several things in this Learning Guide that just flat out don't work as advertised in this guide.  I've been using Monarch 10.5 for over 5 years, and have become very proficient with it; so the problems I'm having now are very frustrating.