Authoring

Folks,I have a series of points in one MI table and intersecting lines in another table in a telco network. I need to test each point and get all of the intersecting lines. The result being the ID of the point in one field and a comma delimited list of the IDs of all the intersecting polylines.For other work in this task I've been successfully using SpatialFilters that work well for 1:1 but 1:N where the N's need to be aggregated into a single result seems to be evading me.I don't need a spatial result for this process.Your advice appreciated.

I would like to process/transform individual files (shape) on a dynamic workspace. I have managed to setup dynamic input/export of the files from folders and have some global transformations. All that works fine. But I also want to apply additional transformations to some of the individual files. In order to do this I need to break out the files from the "flow", do the transformations and then join them back again. How do I do this? Specifically the separating and merging. I found references to a feature called Fanout, but this seems to have been replaced?

Not sure if I am doing something wrong, or if it is a bug. I am trying to use Creator + FeatureReader (intersect) to read Planet Data. It might be I havent sent in the right coordinate system? Or something else? Have anyone else tried Planet Data + FeatureReader?

Hi, I'm using a WorkspaceRunner on a workspace that normally starts reading an excel sheet at line 10. When the WorkspaceRunner is applied, it reads all the lines, as though there were no "Start Row" set. To fix this, I tried to set the "Start Row" as a parameter and have the WorkspaceRunner pass that, but this still does not work.

I recently just upgraded to the newest beta version and noticed that some of my FME Hub transformers were stated as "incomplete". I looked at the parameters and couldn't tell why it wasn't working anymore. I then rolled back to the latest release version and had the same issues as well. Is there an easy way to trouble shoot why some functionality would break? I just ended up rolling back to a previous version that works correctly for the time being.The transformers that are giving me issues are the RegexAttributeSplitter and AttributeConcatenator.

I'm afraid that there could be a potential bug here: Updating CSV Writers in FME 2017The attached GIF movie shows a repro workspace created with FME 2017.0.0.1 build 17271. Changing MITAB to ESRISHAPE is OK, but changing ESRISAPE to MITAB causes crash.

Hey Folks,how do you set an output attribute in a custom transformer. I could always just use an attributecreator after and set attribute a to the output field. but would rather handle it in my custom transformer.Attribute A = 1 before transformerAttribute CustomOutputValue = 2 after transformerAttribute A = 1 After transformerbut I want Attribute A = 2 after transformer.note - the numbers in above example are simplified.Thanks,Doug

Hi,Occasionally I need to convert multiple input sources to multiple outputs. I of course use the "generate" option for this to get started.But if I later find, that the many individual connections each need a new (and identical) transformer inserted (e.g. AttributeCreator), how do I do that in an easy way (i.e. without having to add the transformer manually to each connection which is tedious even with copy'n'paste) ?2016 inserts a single transformer on one of multiple selected connection, whereas 2017 collects all selected connections as joint inputs to a single transformer. So someone has been looking into this.Another similar situation:I again have a lot of auto-generated SQL Server output feature types, and want to change the table handling in each from the default "Create If necessary" to "Drop and Create", and also want to change the attribute handling to "Automatic" on each.How do I do

I want to automate the closing of FME Quick Translator when I run a .fme file. I have a .fme file that is triggered by windows scheduler to run a .fme file. This obviously opens Quick Translator and runs the routine. At the end of the routine the quick translator stays open. Is there a way I can set the .fme file to close quick translator once the routine has finished successfully?Many thanksSeb

Hi, I am fairly new to FME. I currently have 286 old gdb that consist of 15 feature classes, they needs to be updated to a new gdb. Some of the updates includes: changing a point to polygon, merging feature classes, changing fields name, and also mapping value for subtype. I have already figure out how to update an individual gdb.I was wondering if it is possible to batch process, and update all of the gdb. Right now, I am playing around with batch deploy, but I can't seem to figure out where to start. Can you please help me out? It would be very much appreciated :-)Thanks,Vincent

FME 2016 (but happens in 2017 too).A simple workflow:Input -> Dissolver -> Aggregator ->OutputBoth the Dissolver and Aggregator are set to group by an ID, the features are ordered by that ID, and the transformers are set to know this. Parallelism is off for the Dissolver. The result is that features flow smoothly through the workflow, and there is no caching of features at any point. Exactly as desired.However, if I then change the Dissolver to use Parallelism (any level) (to see if I get more speed), and change nothing else, this flowing stops. Now, all features appear to be cached by the Dissolver after the dissolving process has finished by the child threads, and are only released to the Aggregator at the end of the workflow.Anyone else experience this? Is this the expected behaviour? I can't see anything in the docs about the Input Ordered and Parallelism being mutually exclusive, but maybe I missed it.

Hello Everyone,I would like to build a workflow that would prompt users to enter a range (or ranges!) of time (HH:MM:SS to HH:MM:SS) that would be used as a filter an Excel sheet for rows within the ranges. Unfortunately, the AttributeRangeFilter will not permit this time format and I do not want to ask the user to convert to Epoch Time themselves. Any helpful advice will be appreciated

I'm having a bit of a struggle with batch processing of images. I have a set of (usually iPhone) inspection images with GPS coordinates that are to be downscaled and put into a MapInfo TAB as points with a hotlink field containing filename. Using either the JpegGPSPointreplacer (or with Stringreplacer and Expressionevaluator both) works - when I'm using workspace. But, when I batch deploy the workspace the factory pipeline empties between each image and then restarts, effectively overwriting the TAB-file with only the last processed image. Scaling works great using Rasterresampler. The result being a lot of downscaled images and a TAB-file with only one point, containing the last processed image. What have I missed?

Is there a way to export a list of scheduled jobs from FME Server to a txt file or some other format?Thanks in advance.

What I think have in inspector is list. But for some reason FME is thinking its not, because ListElementCounter is not finding it.Someone can explain why so? Its first time for me I have list"ish" features.pic from inspector.

Hi,I try to calculate the difference between to dates. I need the result in Years. From the FME HUb I get the DateDifferenceCalculator. I runs good for difference in days or weeks. But how can I get the result in month or years?

Hello,I am using a FME Server 2014 SP1 with two engines and the corresponding FME Desktop version. We designed a process, which should trigger other workspaces in a specified order, but the complete process should run on only one engine, which is, according to the tutorial, possible and which I could confirm (see list point #4 below). For doing so, we have used the FMEServerJobSubmitter Transformer. Actually our process is very similar to the following tutorial (at least in regard to the technical aspects) https://knowledge.safe.com/articles/1413/fme-serve...Since we are running different services, we need a Job Routing Configuration, which we have realized within t

Hello,I have this problem when trying to open a directory with a python parameter.The line in my script causing the error:f=open(os.path.join(FME_MacroValues['path_orders'],ftp.nlst()[0]),'w')IOError: No such file or directory: '$(FME_MF_DIR)orders\\\\1234567.WI02290100.vg'How do I tell FME to send the full path as a string and NOT $(FME_MF_DIR)?

Apologies for cross posting.   What i'm trying  to achieve is from this Excel table  ----------------------------------- | Name     |  Listed_Item    | ----------------------------------- | Mr A     |  [1234]                  | | Mr B     |  [6352], [2344]    | -----------------------------------  TO  ----------------------------------- | Name     |  Listed_Item | ----------------------------------- | Mr A     |   1234               | | Mr B     |   6352               | | Mr B     |   2344               | -----------------------------------   I using StringReplacer to remove the "[ ]". Beyond that, I not sure how to go abt it. If anyone can just point to me the transformers needed to produce this.  Thanks.

HiI have an FME process that uses as its inputs a GDB file and its associated XML schema file. I want to generate the XML from the GDB at runtime, and I have a python startup script to do this in ESRI - this works. My issue is with populating the parameter for the XML reader to set the location (for the generated file). I've read through some of the articles and previous questions, and this one seems to be what I'm looking for, although given I'm not python literate/new to it, I wasn't able to make the solution work for me - apologies for the ignorance. https://knowledge.safe.com/questions/4296/set-published-parameters-in-a-python-startup-scrip.htmlI think I need to add 'import fmeobjects' and 'return ResultsXML' added to my current script (below), but when I do so I get an error about return state

Hi,In workspace_01 I have a WorkspaceRunner transformer that runs workspace_02 that uses a SQLExecuter transformer. The SQLExecuter utilizes a parameter to receive the Named Connection required (e.g., gisdata_01@SDEDB or gisdata_02@SDEDB, etc..) that's working great.However, the issue happened within the workspace_01 with the WorkspaceRunner, unless I select from the available named connection to assign, the workspace_02 won't work successfully; i.e. assign by 'Attribute Value' or 'User Parameter' from the sub menu.A closer look into the log window revealed how the parameter was interpreted/passed to the workspcase_02 as:--SDE_NAMED_CONNECTION {\\<at>Value<openparen>_Named_Connection<closeparen>}While it should be:--SDE_NAMED_CONNECTION' `gisdata_02@<at>SDEDB' `#FME 2016.1Please help