Transformers

I'm given a location of files. I'm using the directory and files reader to get all the files in that directory. I then use the featureReader to get only the csv files. There are 181 attributes so instead of exposing them, I'm specifying a feature type to read. The csv files all have the same attributes, just in different orders. For instance one file could have attribute1,attribute2,attribute3 and another file would have attribute2,attribute1,attribute3. I'm using attributeManager to calculate some values and because all the files have the same attributes, I just used the order of the first csv so the order of the attributes leaving attributeManager is always attribute2,attribute1,attribute3.I am writing out csv based on the name from the path_rootname (to a different folder). The issue is that I need the output files to retain the same attribute order as the input csv. Because all features enter the AttributeManager, they all come out with the order from that

I have an issue where I am trying to create a PDF output but the data is not filling the objects defined. The data object is defined to fill the majority of the page but as seen below the output only fills a portion of the page.  Is there a way to force the data to fill the area defined? Here is the workspace that I am using -

I am trying to use SQLExecutor to either insert or update a record in a table stored in Oracle - please see sql below. It gave me the following error. any ideas why? declare counts int; begin select count(*) into counts FROM employee where emp_id = '@Value(empid)'; case when counts = 0 then INSERT INTO employee VALUES ('@Value(empid)','@Value(firstname)'); when counts = 1 then UPDATE employee SET firstname = '@Value(firstname)' WHERE emp_id = '@Value(empid)'; end case; end; An error occurred while accessing a table result for feature type `'; message was `Execution of statement '......did not succeed; error was `ORA-06550: line 7, column 14:PL/SQL: ORA-00933: SQL command not properly endedORA-06550: line 6, column 30:PL/SQL: SQL Statement ignoredORA-06550: line 9, column

I'm using a Clipper with a polygon feature to clip for features in a DGN file within a project boundary. For some reason it rejects the Clippee features. After looking at the Clippee features I'm seeing that there are NULL geometries in the file.Can anyone explain how the NULL causes the Clipper to fall over?Is Clipper the best way to clip for objects within a boundary? Workbench is attached without the geometry filter to filter out the NULL geometries.  

Hey,  <-- I saved the template with source data here I am currently using a trial licence to see if FME is what my organisation is looking for, so please bare with me as I am very new to FME and the terminology.The first task I am trying to achieve is converting a large CAD document for use in our GIS System (I see this is very common, and I have watched several youtube tutorials and a few Safe videos, so I understand the basic concept). I have created my first Project, it works for 90% of my data, its the last 10% I am stuck and needing advice on. As you can see i have my CAD input on the left, a few filters and the likes, and it outputs to my GIS tables on the right. It is the 'Annotation4_History' that is causing me grief, and I am unable to decipher the e

gps coordinates and time stamps from aerial images

I have a parent workspace that successfully launches child workspaces via FMEServerJobSubmitter.These launch successfully and complete but then the parent workspace does not release the features to the next transformer.It's running on FME Server 2018.1.2 - Build 18590 - win64I have it to submit jobs in parallel and to wait for jobs to complete which are the settings required but it isn't releasing the features once the child workspace completes.Log file just hangs with the following lineFMEServerJobSubmitter_2(ServerFactory): http://******** - Running workspace '*******_Child.fmw' in repository '******** Child' in parallel...Names redacted for security reasons.As mentioned, child workspaces run successfully.Nothing in the log files or monitor log files to suggest anything strange is happening and this processed has run successfully before.Any thoughts?

HiWhen I created my Reader, I can read all my data and especially my geometry column but this column doesn't display . I try different coordinate system but it does not match. Same issue.What's wrong with this Reader ?Thanks

I am trying to find duplicates in my xml data and from that I would like to apply condition.  here is my xml doc  <results>    <book>        <id>1</id> <status> published</status>    </book>    <book>        <id>1</id> <status> not published</status>    </book>    <book>        <id>2</id> <status> sold</status>    </book></results>From the above xml, I want to find book id where id's are repeated and the status is published then return .<book>  <id>1</id> <status> published</status> </book>using XQuery  . Could you please help me on this. Thanks in advance.

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

...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:0

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)

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

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?