Best Answers

The attached workspace demonstrates the problems I'm having with @ReplaceRegEx and user parameters.  What I'm trying to do is create an output folder name QC within the folder where the input dataset is located.I've created a private user parameter named OutputFolder of type Folder (output) and set it's default value to:@ReplaceRegEx($(SourceDataset_MAPINFO),"^(.+)\\.+$","\1\QC")The intent of the workspace is to simply read the input dataset, create the output folder QC within input dataset folder, and finally write the input dataset to the output folder.When I run the workspace I get the following error messages:Could not create output folder `@ReplaceRegEx(C:\temp\InputGeometries.tab,^(.+)\.+$,\1\QC)' for use by MAPINFO writerCould not create output folder `@ReplaceRegEx(C:\temp\InputGeometries.tab,^(.+)\.+$,\1\QC)' for use by MAPINFO writerDestination Feature Type Routing Correlator(RoutingFactory): Could not create output folder `@ReplaceRegEx(C:\temp\InputGeometries.tab,^(.+)\.+$,

The title says all: what's the best way to send features to a WorkspaceRunner?I tried to use a WKT but for a reason I don't get, it add some `--` in parameters and the WKT received is invalid:Command line arguments are `C:\Program Files\FME2016\fme.exe' `./pg2dxf_reseau_eau.fmw' `--Perimeter' `POLYGON ((507248 137339' `--507484 137669' `507865 137441' `--507629 137111' `507248 137339))'...WARN  |Invalid WKT encountered: POLYGON ((507248 137339

Hello,I am trying to modify the contents of a series of json files, though I only need to remove all of the leading text before the "{"rings"" text. I will have upwards of 130 files to go through, and each has slightly different text to remove. I was thinking of using a StringReplacer to find all the text that I want to remove, then just set the "Replacement Text" to nothing. I'm assuming I need to use regex in the StringReplcaer to identify the series of text in each file that I need to remove. The example of text that I need to remove is:{"displayFieldName":"","fieldAliases":{"OPS_AREA":"OPS_AREA","OBJECTID":"OBJECTID"},"geometryType":"esriGeometryPolygon","spatialReference":{"wkid":102100,"latestWkid":3857},"fields":[{"name":"OPS_AREA","type":"esriFieldTypeString","alias":

I have a collection of surfacess that want to run a Dissolver on.  The problem is that while all the surfaces are planar, they are in 3D-space and aren't necessarily parallel to the XY-plane.  Dissolver seems to only work with 2D surfaces.   Any ideas?     Thanks Dag

I'm a novice in Python so excuse me if I ask something stupid. I read a lot pieces written on this subject but I can't get it to work...I would like to use ArcPy on FME server 2016.1. I followed these instructions but I get stuck on the step where I need to repackage:Install the package with the following command:python -m pip install <package_name> --target C:\Users\<user>\Documents\FME\Plugins\PythonFor example, to install a package named PyExecJS:python -m pip install PyExecJS --target C:\Users\<user>\Documents\FME\Plugins\PythonWhat package do I need to choose to get ArcPy included?

Does FME have a transformer for "hiding", as opposed to "removing" an attribute? I am using the FeatureReader to dynamically read a feature class that is specified by parameter. This script is then called for many feature classes. The attributes of any one feature class are thus not exposed.However, for some features I need to access the ID field of the feature class, for example, "FID". I do this by an AttributeExposer in a custom transformer that is only called for a particular feature class. But I don't want the ID field to carry on as an attribute when it is time to write the feature class to the output table. It would be great if I could then "un-expose", or "hide" the attribute, back to the level of visibility it had when I used the feature reader. Is it possible?

I had the chance to assist a Dale's presentation recently and I noticed his homepage on his MacBook's browser.Do you know what he's using when he opens a new tab? It is not Google nor Safe, I can tell you this!Thanks!

I have the following root template in an XMLTemplater:Where {fme:process-features("FEATURE_CLASSES") occurs I want to insert the following subtemplate within the sequence elements, grouped by an attribute so that it repeats according to how many feature classes I have:The result, however, loses the nesting and leaves elements retreating to the root element level - the subtemplates start inserting at row 6 with the first element showing in the correct position:What can I do to avoid this, or is it just a case of using a separate templater for the subtypes and then appending them into the root in an XMLAppender?

Hi,I use the LandXML template to create a LandXMLI would like to insert all the vertex in cgpointwith the template i can export 1 coordinate with Name and Code but i when i try to process my files (multiples points) its not working

INSERT INTO `stations`.`observation` (`station_id`, `date`, `time`, `energy`, `power`, `average`, `temperature`, `voltage` ) VALUES ( 1, @Value(interval_start), @Value(_timeOutSubstring), @Value(_dataEnergyOutString), @Value(_dataPowerOutString), @Value(_dataPowerAvgString), @Value(_dataTempString), @Value(_dataVoltString) )

I have the following string in an attribute: "Jan 1 1960; Jan 1 1900; Jan 1 1960; 01/05/1890; Jan 1 1960; Jan 1 1960; Jan 1 1960; Jan 1 1960; Jan 1 1960; Jan 1 1960; " I need to extract the earliest year from the attribute, since this is input from a reader the attribute will have different values, but the year will always be in a 4 digit format. I want to use a regular expression to extract the earliest year, in this case it would be 1890. Is this possible?

I like to rename all my attribute names using a list in Excel For example:- Current attributesAaaa | Bbbb | Cccc- Renaming listAaaa | Address Bbbb | Basenumber Cccc | ContactID- New attributes:Address | Basenumber | ContactID What are my options?

Hi AllI've built a workbench that generates an Excel file. What the end goal is to have this work bench accessible through a web page and allow the user to download the result as a .xlsx (not a zipped .xlsx).I've tried two ways to get this working:DataDownload This works however the .xlsx is returned in a .zipDataStreamer This method works when running the workbench from FME Server (a download window appears) but when using the JS API you simple get the .xlsx return as a string (like if you tried to open a .xlsx file with notepad). Myself and a colleague have tried a number of ways to get this working by playing with the parameters (specifically opt_response format). I've included the JS in its current state below...      <script type="text/javascript">    var repository, workspace        window.onload = function() {            FMEServer.init({            server : "https://*******************",                token : "********************************"            });            re

Hey, I'm getting a unique constraint error coming from an indexThe error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [ORA-00001: unique constraint (FACILITY.A17846_IX1) violated]}Is there a switch in the writer I can set?? I have tried GRID 1 = Nothing and GRID 1 = 0 and both fail.Thx Brian

Can we do location search based on lat/long in data inspector.I'm trying to locate few points on the polygons.

<?xml version="1.0" encoding="utf-8"?><SDDOT>  <item>...</item>  <item>    <id>497751</id>    <status>active</status>    <categories>      <category>        <name>conditions</name>      </category>    </categories>    <descriptions>      <description>        <phrase>dry</phrase>      </description>    </descriptions>    <locations>      <location>        <route>US-212</route>        <direction>Both Directions</direction>        <start>          <lat>45.0056</lat>          <lon>-102.8765</lon>          <milepost>71.713</milepost>          <landmark>            <place>Mud Butte</place>          </landmark>        </start>        <end>          <lat>45.0231</lat>          <lon>-102.0451</lon>          <milepost>112.715</

I am trying to publish workspaces via the REST api. Ideally I would like to programmatically get the workspaces dependencies before publishing to make sure the resources are on the server. When I manually publish via Desktop I get a warning about dependencies, I would like to access this info before publishing with REST. I am making the REST calls with Python so if I had a way to get the dependencies with Python that would be real neat.

Can somebody please help me understand how to use the python caller? I have looked at tutorials, older code and even help for the error i get which is - Python Exception <NameError>: global name '_file_contents' is not definedI am unable to resolve this. I need to match the coordinates in my shapefile to the coordinates in my point cloud file and extract the point cloud classification data. I have a number of unresolved issues with my logic but my important question is the followingHow do I import and manipulate attribute values in a python caller in fme?In my workspace, I have a shapefile with 12 points. I am extracting the coordinates of it and storing it as a string in the _file_contents variable [in format (x,y),(x,y), ]. I need to perform a lot of manipulations on this but to understand if I am using the transformer correctly, I am performing this first basic function of removing the last comma from my string. However, I keep getting the error I have posted above.I h

I have a dataset with a name field and an index field which is in order. I want to output a shapefile that orders the FID numbers like so in order but I can't figure out how to output the file without it randomnly assigning any number as the FID. It needs to be ordered correctly so any help with this one would be appreciated.FID Id Name0 1 Northland1 2 Auckland

I am having issues dissolving large sets of data, the Dissolver works fine and achieves the results I would expect but when I increase the number of data going in the process becomes painfully slow and often results in a crash because of memory.

Hello,I have a shp file with ZIP code level polygons. I need to combine all of them to give me polygon for the state, is it possible to do in FME?I tried to use the Aggregator, which took all my polygons and showed 1 output, but when inspecting the file, there was no geometry.Thank you!

Hi,I've tried to facilitate using the SpatialRelator with the "Input Ordered" set to "By group". And set the "Group By" value to a common attribute.I sorted both my Requester and Supplier inputs by the same value. But even though the log file shows the expected groups, all groups have no matches (typically "0 BASE(s)").Please advise as to how this functionality is supposed to work.I got the process running by setting "Input Ordered" to "no" (keeping the "Group By"), but I think that this is not as efficient.Cheers.

I tried looking for similar queries but I need some help with this asap. To explain my question further, I have a point cloud with x, y, z and the fourth column is a componentID (after having done connected components) I have a text file which consists of a string of component ID values.I am trying to filter the point cloud based on the number of component ID values in my text file. So, I have a couple of questions.1. I am trying the basic method by filtering the point cloud based on the value of the component but I keep getting the following error PointCloudFilter(PointCloudEvaluationFactory): Attribute 'C1' is specified in an expression but is not present on the feature. Please ensure the feature has all referenced attributesI am not really sure how to solve this. Because if I use an attribute creator to assign values to C1 independent of the values from text file, it works fine. But when I integrate it with text file it goes into error.2. My text file will not always contai