Let's take a few steps back: what is your overall goal? From what I've gathered you're first converting the MWD files to TXT, then to XLS, then you merge those XLS's and finally turn them into CAD lines. But with every step as a separate workspace you might introduce a lot of overhead. Every WorkspaceRunner runs the child workspace for every feature passing through.
My recommendation would be to try and do as much as possible in a single workspace. But I'd really like a bit of explanation before I dare to give a definitive answer. (I do see you have documented the workspaces and used Best Practices, which is really good, and it's likely that the answer to my questions is in there. It's just in a language, Swedish I presume, that I don't speak)
Let's take a few steps back: what is your overall goal? From what I've gathered you're first converting the MWD files to TXT, then to XLS, then you merge those XLS's and finally turn them into CAD lines. But with every step as a separate workspace you might introduce a lot of overhead. Every WorkspaceRunner runs the child workspace for every feature passing through.
My recommendation would be to try and do as much as possible in a single workspace. But I'd really like a bit of explanation before I dare to give a definitive answer. (I do see you have documented the workspaces and used Best Practices, which is really good, and it's likely that the answer to my questions is in there. It's just in a language, Swedish I presume, that I don't speak)
Hi,
Yes, I know it´s a bit of an overkill too have so many workspaces,
Since I´m fairly new to the FME-world, I´m unaware of bestpractice for control & transform the data the way I want. I´m sure there arebetter ways. The .txt & Excel-steps could probably be merged into oneworkspace.
The final goal is, like you say is to translate the data fromthe "MWD"-Files to DWG-files(one per Excel-File) with CAD-lines, witheach line on a separate layer, to allow the end-user to keep track of whichLine/Holes they are looking at.
Yes, you are correct, Swedish is that fine collection ofstrange letters & words. Ihave attached a translated version of the workspaces. Hope this helps!
example-files.zip
//D