Transformers

Hello,FME 2019.0.1 build 19253I noticed the JSONFragmenter raises an error if the specified file path contains spaces.JSONFragmenter (JSONQueryFactory): The clause 'FILEPATH_OR_URL folder name/test-geojson-structure.json' within 'FACTORY_DEF * JSONQueryFactory FACTORY_NAME JSONFragmenter INPUT FEATURE_TYPE Creator_CREATED MODE EXPLODE EXPLODE_FORMAT JSON REJECT_EMPTY_LISTS YES EXTRACT_ATTR No JSON_ATTR <Unused> READ_FROM_FILE YES FILEPATH_OR_URL folder name/test-geojson-structure.json OUTPUT_ATTRIBUTE _result EXPLODE_QUERY json<openbracket><quote>features<quote><closebracket><openbracket>*<closebracket> RECURSIVE_FLATTEN <Unused> OUTPUT EXPLODED FEATURE_TYPE JSONFragmenter_FRAGMENTS OUTPUT REJECTED FEATURE_TYPE JSONFragmenter_<REJECTED>' is incorrect.  The parameter to FILEPATH_OR_URL must be a constant value, a value-of (&) attribute, or an FME function callThe clause 'FILEPATH_OR_URL folder name/test-geojson-structure.json' wi

...and then also interpolate Z for every vetex. thanks! /Erik

Hello, I build a workspace which create an excel document. on the server.I build a Server App on the fme Server 2019.1 and it runs fine by calling the url and clicking the run button. But I want that the App starts automaticly with the url and not with clicking the run button. Is this possible?Thanks for your answers. Greetings from GermanyThomas

Hi there, I'm having trouble setting up NGINX with the windows version of FME server I have attempted to follow and adapt the instructions for Ubuntu here: https://github.com/safesoftware/fmeserver-nginxBut haven't had any luck yet, has anybody succesfully set NGINX on Windows FME Server that can help? In terms of my setup:I have FME server installed on one computer running Windows 10 and a docker install on a different machine of NGINX Proxy Manager on the same network which I have used for multiple NGINX installs. (https://nginxproxymanager.jc21.com/)Any help would be appreciatedMany thanksJoe

When using a Timestamper in Workbench, I get a result like:+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Logger_LOGGED'Attribute(string): `dateOfSnapshot' has value `20190902163230.4600884+02:00'Attribute(string): `fme_feature_type' has value `Creator'Attribute(string): `fme_geometry' has value `fme_undefined'Attribute(string): `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENull===========================================================================So, it says 16:32:30, with UTC +2:00When running  on FME Cloud, the timestamps in the interface have the right values (16:31:55)522019-9-2 16:31:55 | +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++532019-9-2 16:31:55 | Feature Type: `Logger_LOGGED'542019-9-2 16:31:55 | Attribute(string): `dateOfSnapshot' has value `20190902143155.516446175+00:00'552019-9-2 16:31:55 | Attribute(string): `fme_feature_type' has value `Creator'562019-9-2 16:31:5

Hi, I would like to extract data from a web page coded. I already get the password. The url is :https://www.portail-nextgen-telecom.tdf.fr. I need to read the url , find the data : Document Contractuel. Read it. If there is a value , get it. i tried with htlm extractor but the response is a script. I need a value. yes or no the Document contractuel is here. Anyone can help me ?

Hello all, I need a help about how to iterate an entire workflow in such a way,so that once I change the inputs,it will provide me with the specific output

Hey there,with Feature Writer I try to adopt a schema from a bunch of different shape files.I tried the same workflow with a ESRI Geodatabase before and it worked. So I published the Shape Files as Workspace Resources and commit them within the Dynamic Schema Definition.Which works fine with the Geodatabase, failed (a bit) with the shape files.In fact the transformed shape files are using the schema, but some of the ESRI data types were changed, namly for example the "Short Integer" changed to "Long Integer" (and also the Precision value changed). Does someone knows why this could happen? Thanks and best regards,André 

I have a state boundary and I want to use a map scale as a parameter to calculate the Tile width and Tile height (ground units) as attributes for the Tiler.Given a coordinate system, how do I calculate that width and height of that bounding box at a scale of 1:100 using an Expression Evaluator? Then do it again for the next scales 1:500, 1:1000, etc. 

Hi,I have a 3d building citygml and I have converted into 3d tiles using FME. When i am loading 3D tile(size 6.6MB, containing buildings) , it is taking the loading time of 6.3 minutes to load on the cesium globe. When i upload the citygml data to generate 3d tile, the generated 3d tile is taking 12sec to load on the cesium globe.I am not able to find the reason for this. How to minimize the loading time of FME converted 3dtile. I have attached the images of 3D tile.   

Hello, I want to extract from a .txt file the size of an object, it looks like: Size: 1575200 . I am using StringSearcher to find it in the text file, the regular expression is like : Size: [\\s\\S]*$It works well, but I want toget only the value, so 1575200 and not like Size: 1575200Do you have any idea?

I have multiple json files, each containing a database table schema definitions. For example, the extraction of one json file, breaks down to column names and data types (non-spatial), as shown in the attached Data Inspector image. How can I use this information to dynamically create a table in the database ?(Oracle).

I want to create a raster that shows the distance from each cell to the closest line in a set of polylines (a cable network). This is very easily done in e.g. QGIS, but I want to be able to do it in FME. I can't find any transformer that would allow me to do so. The closest I come is to use a 2DGridReplacer - creating a regular grid of vector points, then a Neighborfinder, and the rasterize it. But that seems the long way round.... any ideas?

I have a series of points, representing points at ten metre intervals along a road.The ten-metre intervals are the "driven distance" of the road, which is not necessarily the same as the geometric distance.Each point feature has its "driven distance" as a numeric attribute "TDIST". The units is kilometres.TDIST0.000.010.020.03and so onI can use LineBuilder to assemble the point features into a polyline feature.The result I want to achieve is to output the polyline feature to a file Geodatabase, with each node of the polyline having a Measure, where Measure is the TDIST attribute.I have considered the MeasureGenerator Transformer, but this will generate measures along an existing polyline based upon the geometric length of the line, not what I want.I already have the appropriate Measure values as the TDIST attribute of each point feature.I'm hoping to;1) convert the TDIST attribute of each point feature into a Measure of that point feature, then2) conve

Hello all,I am running FME(R) 2018.1.2.1 (20190319 - Build 18592 - WIN64)I have a dataset of points (along a road) and I want to use the LineBuilder to create lines.Each point has a ROAD_SECTION_ID (character field) which uniquely identifies the road.Each point also has a TDIST (numeric field) which is the distance along the road.I am trying to sort the points appropriately before they go into the LineBuilder. They should be sorted firstly by ROAD_SECTION_ID and secondly by TDIST.However, the result of the sort is wrong. The features are sorted firstly in ascending order of TDIST, then in descending order of ROAD_SECTION_IDI have reversed the order in the Sorter, but there is no differenceThe outcome is that the LineBuilder does not work like it should

I am attempting to write to CSV file where the filename includes date/timestamp. My situation is the same as the question here: https://knowledge.safe.com/questions/35824/write-csv-file-where-filename-includes-datetimesta.html. I've tried adding the timestamp to the name but it produces a CSV for each row of the original table. I tried a parallel Creator>DateTimeStamper> but it generates two CSVs. I tried using a FeatureMerger but I'm confused as to what to join on; My options are to join on _timestamp and a column from the source data, which don't match. Should I ask a new question for this particular instance of the problem or try posting on aforementioned thread?

I am trying to manage updates between a WFS and a GDB. Note that for this I am using the UpdateDetector as my organisation's current installed version of ArcGIS Pro (using the Data Interoperability tool) restricts me to FME 2018.The issue is that I have a number of fields which are being provided from the WFS in float format, and even when the figure is a whole number it is still represented as such (eg. 1700.0000). When this is stored in the GDB it is automatically trimmed to the whole number (1700) so it isn't being detected as a matching value and giving inaccurate information about updated records. I could in theory us the AttributeRounder to overcome this, but some fields have decimal figures containing useful information, eg. dollar values (2357.87) so rounding to 0 decimal places will remove this. I'd like a blanket solution that can be applied across all attributes- I need to apply the template to ~60 feature classes which require update management, and data changes

I have a workbench which takes two schemas, merges them using a FeatureMerger, takes the output from that and merges it with a third dataset schema. This is then fed into a SchemaMapper transformer, with:Source attribute -> Destination attribute mappingSource attribute -> Filter attribute value filterNew attribute = New attribute valueHowever, the output, when viewed with an inspector and when written to a GDB feature class, is identical to the input, albeit with the _schemamapper_row_ids attribute added (and appearing to be populated with data indicating the mapping has worked. My understanding is at the very least, the new attributes should be appearing to indicate the transformer is behaving as expected.

The goal here is to have FME query our up-to-date database for investigator names, use ChangeDetector to see what’s changed between a feature class in ArcGIS Desktop and our database, and update only what has changed in the local ArcGIS geodatabase layer.  So far the workbench successfully updates the investigator name (changes the value from “IS THIS REPLACED?” to “Sandy Jones”. The only problem is that it also fills in null data for the other fields that occupy the same row. Is there a way to have it leave those areas alone?Here is my workbench 

Hi,My problem/curiosity is similar to: some-polygons-disappear-with-dissolverdissolver-not-working-as-expected I'm working on FME desktop 2017.0.1.1FME level: RookieSituation: I put a buffer on a road network, and clipped a smaller buffer of that road network out of it. I want to assign a specific weight value to the remaining buffer. Working with two buffers created some extra lines within the polygons which I would like to remove before going on with further calculations. Before using the Dissolver transformer I used the AreaOnAreaOverlayer. Using the Dissolver transformer worked for all, but 6 locations. With working I mean removing the inner lines from the existing polygons. Two examples have been included with my issue. I tried CoordinateRounder, Snapper, and ArcStroker between AreaOnAreaOverlayer and the Dissolver. I don't have any experience with these transformers, but they didn't seem to solve the issue. Example 1, before the dissolve.Example 1, after the dissolve.

I try to relate boreholes (points) to 3D Solids from Cad. (autocad_original_entity_type = autocad_solid3d) FME does read the 3D Solids as surfaces. (fme_geometry = fme_aggregate / fme_type = fme_surface)The way I found to do this is to convert the surfaces to polygons with a SurfaceFootprintReplacer, then use a SpatialRelator to define the relation. But this takes a lot of time as I have quite a bit, quite big solids.So I wonder: Am I doing this correctly? Does an alternative solution exist?Thanks!

I am using the REST api to POST to transformations/transactdata. The Workspace that processes shapefiles works fine on Desktop and also runs in the cloud using Run Workspace, by dragging in a zipped shapefile. However, the job will not work through the API using any of these three methods:- when using the REST API interface, (POST /transformations/transactdata/< repository >/< workspace >)--- though I am able to see zip file data when choosing application/octet-stream as the Content Type, so I would think this would work- when using Postman- when submitting with POST from my own codeIn all cases I receive error 422, and a response like this:{ ... "priority":-1, "statusMessage":"Unable to open shape file `/data/fmeserver/resources/system/temp/tomcat/tempstore/fmerest/sourcedata/pgworkflows-shp2geojson_cloud.fmw/requestdata-ESRISHAPE_1.shp' for read", "status":"FME_FAILURE" } Can anyone provide insight? The full logfile is

I would like to convert GPS Time To North American Daylight Central Time

Hello!Can somebody please try to figure out why in some cases bufferer doesn't work. I have 2 streets with the same name. I'm creating buffer around them gruped by street name. I want those two buffers to become one buffer.But when I put buffer amount = 5 nothing is passed through bufferer. If I change it to 3 or 10 it works. For 1, again it doesn't work. I played with the buffer size but can't figure out some rule why it works with some numbers but not with the other.Here is the data if someone want's to try. 

Hello all! I am trying to import either a shape file, or a feature class polygon into Smallworld. It seems that I keep running into a geometry_acp error. Has anyone ran into this before or have any advice? I can't seem to get any other information from FME on what exactly is going on. I am using a GeometryValidator transformer but that doesn't seem to affect my results in anyway either. Any help is appreciated!