Using transformers to modify data.
Recently active
Hi, I'm trying to split some text, based on the value auf another attribute. Unfortunately the AttributeSplitter transformer doesn't accept attribute values comming from inside the workspace, only pubulished parameters as the delimeter. Is there a way to set up individual delimeters for every feature and carry out the splitting upon them?One Example:Text_line_data: 2018-06-11 08:39:23| 486.7| 0.0|STATS |62b88ad3-1c54-43b2-b010-479f2141a98a Here comes the text string im interested in. The string wil vary in length for every featureDesired delimiter: 62b88ad3-1c54-43b2-b010-479f2141a98a I',m looking for the string that succeeds 62b88ad3-1c54-43b2-b010-479f2141a98aThanks for your support!
Like Projection Standard parallel (s)Longitude of originUnit False easting \\ northing
I have several really old Arcview Project files, in apr. Has anyone built a custom Transformer for this?Seems like it might be doable as Arcmap 10x can read them.Thanks.
Hello,I have a field called SPECIES that could contain surveyed tree values such as E,AS,TA within each record; or perhaps the record could contain just AS or maybe JP,BS, etc. What I would like to do is categorize those values in that record into a new field value such as 'Stocked to Hardwood', 'Stocked to Softwood' etc. (see image). However, I'm having problems as what I would like to categorize as 'Stocked to Hardwood' (e.g. record with AS,TA) is getting flagged as 'Stocked to Softwood and Hardwood'. Is there any way I can use existing operators to categorize a value such as AS,TA to be 'Stocked to Hardwood' or do I need to break this SPECIES field up and extract each tree species separately and work with those?Thanks.
Hi! I have a problem! I need to export dbf file (FoxPro) to CSV. FME to read dbf file had changed fields with memo type - automatically to add numbers before text. I can’t remover numbers, because some text start by numbers. Please give me advice to solve this problem.
Hi FME'ers,I would like to build a workspace to generate and validate UK GEMINI 2.2 metadata. I can generate the xml using a template and updating the required elements from the feature. Validating it however is where I am stuck. The xml is validated using two ISO19139 schemas and the GEMINI schematron. These are available on github here:ISO 19139 XSD Schema (EDEN 2009-03-16) ISO 19139 Table A.1 Constraints Schematron (Medin/Parslow 1.4) GEMINI 2.1 Schematron 1.3 I am pretty new to xml schemas and schematrons. I think a series of XMLValidators would do the trick but I don't know how to configure them. Has anyone is FME Land accomplished this before?Many thanks,David McDermott
Hi,Any idea how to convert Collada / 3ds single sided faces to double-sided faces?Thanks,Y.
i am able to download a .TAR file, which contains a .GZ file, which in turn contains multiple .grb2 file (with no extension). i am needing to get these files into a directory and add in the ".grb" extension.
Good morning!I am trying to close walls at the intersection of another wall. I have tried using the anchor snapper to snap to the nearest lines, but it doesn't seem to fix all of them. Some walls are already closed. I have also attached my workbench. Thanks!David
Hi,I am writing out to a json writer and intend to stream this json using fme cloud.The output looks like [ { "STAGING_ID" : "9515", "USER_API" : "A2C3601C-40E9-48DC-A0C0-5D4DB0867A2E", "REQUEST_GUID" : "80318a93-f513-4e63-8c08-9e07250af0e2", "ID" : "120654", "UNIQUE_LOCATION_ID" : "5819", "UNIQUE_SAMPLE_ID" : "576683", "ROW_CREATED_DATE" : "18/05/2010", "LAST_EDITED_DATE" : "18/08/2017",etcIdeally I would like to add a few lines before the records return e.g.[ "status":"ok", "body" : { "STAGING_ID" : "9515", "USER_API" : "A2C3601C-40E9-48DC-A0C0-5D4DB0867A2E", "REQUEST_GUID" : "80318a93-f513-4e63-8c08-9e07250af0e2", "ID" : "120654", "UNIQUE_LOCATION_ID" : "5819", "UNIQUE_SAMPLE_ID" : "576683", "ROW_CREATED_DATE" : "18/05/2010", "LAST_EDITED_DATE" : "18/08/2017",Could anyone suggest how this can be achieved. I really don't want to manually template the output from the rows because they are dynamic and remove any null values.Many Thanks,Oliver
I have a bunch of images in MrSID format (150 or more) with sizes from 3Mb to 10Mb each, and I need to get the bounding box that contains them all.What is the fastest way of doing it? My approach is as shown in the picture. It takes 1 minute for 3 .sid files (6Mb each). If reading a single SID file is slow, let alone 150. There must be some better way of doing this. Any idea?
Hi,I have a folder which including multiple files vectors. They have different coordinate system.Example: road.tab (EPGS: 4326), water.tab (EPSG: 32648)I want to make a process converting coordinate look like here:Could you show me how to make filter to reproject?
To get hold of a parameters value in Python, you can easaly use ex. FME_MacroValues['COORDSYS'] If the parameter is of the type Choice with Alias, how do I get a hold of the alias in Python syntax?
The documentation for the PythonCaller points to this page to describe how to install python packages for FME: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Installing-Python-Packages.htmAt the bottom the target directory is listed as C:\Users\<user>\Documents\FME\Plugins\PythonBut, in that directory are several subdirs: python27, python 34, python35. Do I install instead to a version-dependent subdir?i.e.:python -m pip install <mymodule> --target C:\Users\<user>\Documents\FME\Plugins\Python\python36
Hello,I am wondering if I could update the coded-value domains in FME transformation without re-adding the writer.Because I have spent so much time on re-order the fields in the way I want for many feature classes( 30+), and I don't want to re-do them every time I need to update something in the reader, so I don't think I would want to re-add the writers every time or choose the automatic in attribute definition as it would change back the order to default...So my question is, if I use the manual option for attribute definition, could I still get the updated coded-value domain from the updated reader without re-configuring the writer? For example, I added the coded value "Inactive" into the "Status" domain (first image), how could the "Status" in the writer get the updated domain from the reader? I tried so many times, but didn't have luck yet. The error message saying " The attribute definition used is invalid for the non-existent domain
After using the Orienter on a line the attributes that are 'end sensitive' are no longer in the correct fields because of the flip. I used to use AttributeCopier (v2) which did a fine job. But an "upgrade" has broken the swap, overwriting so fields. I used to just not upgrade, but now the workbench just crashes. I cannot create a new workbench with the old AttributeCopier so I am stuck with a kludge using a whole lot of temporary variables unless there is a more elegant solution. Is there?Just to be clear, I need to do this:Source TargetLTO RFRLFR RTORTO LFRRFR LTOetc for every "end sensitive" attribute. (You will remember that not only do you have to reverse the data values, but it has to be mirrored as well when a flip is done because left and right are also swapped.)Preferably I would like AttributeCopier to revert to the original behaviour.
Hi there. I am trying to import a simple csv file to my CARTO on-Premise account. I could import files before I updated my FME Desktop to 2018.1. Now I am keep getting following error messages.Creating reader for format: CARTOTrying to find a DYNAMIC plugin for reader named `CARTO'FME API version of module 'CARTO' matches current internal version (3.8 20180209)Creating reader for format: CARTOTrying to find a DYNAMIC plugin for reader named `CARTO'FME API version of module 'CARTO' matches current internal version (3.8 20180209)CARTO reader: Directive '_MULTIUSER_ACCOUNT' has value 'NO'CARTO reader: Directive '_API_URL' has value 'cartojp.com/user/carto/api/v2/sql 'CARTO reader: Directive '_API_KEY' has value '**********************************a72a4e'CARTO reader: Directive '_PAGE_SIZE' has not been set. Using default value '500'CARTO reader: Opening account 'myonpremise'CARTO reader: CURL e
Good evening,Is there a way to do a lookup (like a FeatureMerger) within a Python script? I have multiple attributes that I need to lookup against a single list, but I'm not sure how to supply this out-of-band (supplier) to the python without muddying/creating duplicate features. Basically I'm trying to avoid creating 20 FeatureMergers for each attribute lookup I need to do. Cheers,Peter
Is there a way to quickly remove all attributes that contain no data, i.e. every row is null.I don't really want to run a python script, I am wondering if I can to some statistics to count and then something to remove the attribute.Many Thanks,Oliver
Hello. I am using FME 2018. So, I have created a workbench that generates polygons as output. But, some outputs that are generated are polylines and not polygons.Now, if I edit the polylines(in ArcMAP) that are made, it becomes polygon. I don't know if its a bug or something with PointOnAreaOverlayer.Any solutions for this? I have attached the inputs and wb.Thanks
Is there an equivalent to Raster Calculator in FME? I am aware of the RasterCellValueCalculator transformer, and the custom made NDVI transformer, but is there also a single transformer to calculate the results of multiple rasters (more than 2) and/or to apply a custom function on these rasters? And, since the Rasters have to be perfectly overlapping, is there also a transformer to reproject and resample an existing raster so that it will copy the properties of the other raster?Or do I need multiple RasterCellValueCalculator transformers behind one another to get the same result? This somehow does not seem very efficient.
I'm trying to add label points to dissolved polygons and my label point output is far less than the number of dissolved polygons input to the Label Point Replacer. If written to the Inspector the number of label points (~4400) equals the number of inputs but when written to a database the number drops to around 100. Does anyone know what might be the problem and how to fix this?
Hi I am trying to add a grid shift file in workbench 2018.I have followed the steps listed in this page:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/CoordSys/grid_files_adding.htmHowever there is no option to add a new file.Any help would be much appreciated.
How can I combine a list of the same feature into the same oneFrom this Ply_idLoc_nameLayer_idSpatial_relation1MTL1510OVERLAPS1MTL1511OVERLAPS1MTL1512WITHIN to thisPly_idLoc_nameLayer_idSpatial_relationMsg1MTL1510 OVERLAPS, 1511 OVERLAPS, 1512 WITHINThanks
I have some features that contain an attribute with a GeoJSON string, I also have a Multipolygon in WKT passed as a global parameter to the workspace, what I have to do is to parse each geometry from the attributes (in geoJSON) merge them into a multipolygon and test if this intersects at least once the geoJSON mulitpolygon. At the moment I cannot parse the GEOJSON from the attributes, I tried to use geometryExtractor but the transformer instead of extracting the GEOJSON string extracts the geometry of the incoming feature (which is unrelated), i tried the feature reader but I get an error because the reader is looking fro a file path while I submit an attribute. I parsed the geoJSON with the validation online and it id fine. How can I accomplish this?