Using transformers to modify data.
Recently active
I've just been exploring the Compare worksapces tool in FME 2023. Great to be able to integrate this as both a diff and merge tool. But I noticed that currently there is no way to compare CustomTransfomers or CustomFormats. Any plans to add this to the workflow? A large part of out FME projects are CustomTransfomers which we use in final workspaces. For now the only way to compare a CustomTransfomer is to have it embedded in a workspace. This makes it Impossible to use as a Diff or Merge tool in Git. @mark2atsafe - pinging you here Mark to get Safe's take
I am working with conductor lines and need to create a routine that establishes connectivity of lines out of the substation. Essentially the first line out of the sub would be line 1, the second line would be line 2 and its parent would be line 1. Line 3 parent would be line 2, etc... I have tried TopologyBuilder, but this doesnt account for flow.
Hi, I want to write geometry and attribute data to a dxf file. How do I make sure that the attribute data is saved in the dxf file? All I get now is the geometry in the dxf.
I’ve been building some automations in FME Flow with optional parameters (date or numeric fields) that can either be filled or be blank when run outside of an automation. When I try to save an automation with one of these optional parameters filled in, it saves fine, but as soon as I try to save an automation with a blank optional parameter, it loads forever and doesn’t commit the change. As I've said, it seems to affect date and numeric fields. Has anyone else come across this issue before? Currently have 2021.1 (upgrading soon)
Hello, I am creating a list in a pythonCaller which contains lists inside. Similar to this example: mylist=[[4, 5, 6], [1, 2, 3], [9,8,7], [10,14,13], [5,9,10]]. How can I expose this list to pass it to the next transformer ? The usual way of feature.setAttribute('mylist{}', mylist) is not working. My script is working fine when I am running it outside of FME. I am getting the following error in FME:"Python Exception <TypeError>: Could not convert attribute value to a supported attribute type.Error encountered while calling function `processFeature'PythonCaller_3 (PythonFactory): PythonFactory failed to process feature"
Hi Guys,I'm just trying to read my group content from arcgis online and do some query from "last modified date" on service level.Anyone know how we can read/convert this format? Seems DateTimeConverter cannot recognise it.. Thanks!
Hi. I need to convert all the values from each row in an Excel sheet to a different word doc. Is this possible woth fme? With the custom transformer TableAdder I could convert the whoke sheet, but I need to create different word docs for eacht row. Each row had a unique value in the field KEY and it would be usefull to add the KEY value to the word filename.
Hi,I am using the FeatureWriter to write data to postGIS. I am using the featureWriter instead of the postGIS writer because I must run a series of SQL after write. I am using the writer in dynamic mode.I need to set the data as MultiPolygon, but the geometry type it is writing is just the generic "geometry". I set the Geometry under the General settings to postgis_multipolygon but it does not "stick". Every time I a open the Writer it is set back to unfilled and red. Appear to be a bug!? I am running FME Desktop 2018.Suggestions how I can overcome this?Kind Regards
I use a XSD Driven XML Writer to compose a XML file. Afterwards I read the file and send it with the HttpCaller to a SOAP Endpoint of some application.Is is possible to skip the "Save to File" "Read from File" part and directly write into a XML attribute of some feature?
Hi, do you know what the problem could be? I have a backup of the MS database, which I load into FME and write to the postgres DB with Postgres writer, but I have no data in postgres. Maybe a datatype? But FME reports no errors. Thank you
I am using the aggregator transformer to take multi part polygons across NI, grouped by Local Government District, so when the data is displayed and selected on a map the records in one district will be selected as a multi part. I want to keep all unique identifiers and addresses for the records, as well as other attributes. I have currently got all the attributes to remain by using the assemble hierarchy section in the transformer using LGD as parent id and unique id as the id, but the group by doesn't seem to be working as the records are being selected as individuals polygons, not multiparts.
How do I set a xml element to xsi:nil=true in a XSD Driven XML Writer?I tried to set with "name.nil" xml_boolean. No luck. I changed the type from xml_boolean to xml_char. No luck.I created a feature_type for <name> element and set the attribute via a "nil" attribute. No luck. The output shall look like this: <aixm:name xsi:nil="true" nilReason="inapplicable"/>nilReason works without problems.
Dear all , It's a hollow PIPE , I want to extract XYZ for each a) centre point (c1)b) face centre point (v1&v2) + face INNER vertex point (vf1&vf2)c) radius (e.g. distance from v2 to vf2)d) total length (e.g distance from v1 to v2) thank you for kind support
I have different gdbs at different level in a folder.In each gdb there is the same dataset. I want to merge (usually with a junction) the similar datasets from the gdbs (all dataset has the same structure). But I not sure of what reader should I use:I use a reader with feature Type Name as "any schema".And Reader "PATH\\**\\*.gdb" Then I put a FeatureReader , but I cannot get attributes from all the dataset. Any Help will be appreciate.
Hello everyone,I am having random timeouts on FMEServer when i am trying to connect to a PostgreSQL database (using FeatureReader/FeatureWriter) or when i am trying to realize a simple get/post with HTTPCaller. The timeouts seems to happen randomly, mostly when there are multiple simultaneous jobs.The HTTPCaller timeout is partially solved by activating the option "Retry Failed Requests", but sometimes the maximum value of "Maximum Retry Attemps" (10) is not enough (i.e. the timeout is still there after 10 retries). For the FeatureReader/FeatureWriter there is no retry option available.A similar problem was found here It seems that i have an unstable connection to my postgres db, sometimes it will read from it and other times I get this error message: (safe.com) but there is no hints to the source or solution of this error.Some details:FME Server 2022 Build 22792 with 5 enginesUsing Linux (RHEL 8.7) with dockerThanks in advance
Hello All,British National Grid Long/Lat (OSGB 36) [EPSG: 4277] seems to be missing from FME's suite of coordinate systems - or am I mistaken? I have a table with Longitude and Latitude data in this projection and I want to create points from them, and then convert them to British National Grid (Meters) (OSGB 36) [EPSG: 27700]. I can try to use the Reprojector transformer, but I can't see EPSG: 4277 anywhere.Is there anything which I could use instead? Or is there another solution such as creating a custom coordinate system?Many thanks,Jane
Dear All, I have the following setting : I've created a User parameter of type "choice" where the user can tick which attributes he wants to keep and send to the Writer (column1, column2, column3, etc.). With the MultiChoiceParamSplitter followed by a ListExploder, I can get a table where the attribute "_choice_param_values" holds the attribute names the user has selected (e.g. column1, column3), but how can I use it then in the AttributeKeeper (or any other transformer that would do the job) ? I've tried to pass the table as input with "_choice_param_values" as Attributes to Keep but it does not work at all... Or maybe, from the outset, I didn't tackle the issue from the right angle and you have suggestions about how I could I achieve what I want in a totally different way around ? Any ideas are welcome, as I've run out... NB : I've seen the (seemlingly related) post below but it did not solve my issue.Having trouble passing user pa
I have a batch file (.bat) that I need to run. What Transformers would I need to use to get this to run using a workspace in FME Desktop?
Please can you tell me how i do this?
I need to do a transformation, like pivot table, using Python, and for that I would need to install libraries, like "pandas"... How can I install custom libraries to FME Python ? I created a environment with Anaconda, installed pandas there, but now, how to use that environment in my PythonCaller?
I am trying to mosaic 228 ECW tiles into one uniform image using RasterMosaicer transformer. The individual tiles are quite large as the 228 individual tiles together are 15GB. I am finding the process using RasterMosaicer extremely slow and is taking close to 24 hrs to complete using FME desktop. Just wondering what the best method is to mosaic these tiles and have a resulting image equal to the size of the individual input tiles, 15GB...or less.
I'm having trouble removing buffer segments correctly when generating a buffer around a line dataset with roads.Input data (road lines with road name and city): When buffering this, I end up with:This method has a lot of overlap that i'm not able to process properly. Is there a way to buffer it like this or process the _overlap >= 2 in a way that this is the result:I tried the areaonareaoverlay and correct the overlap afterwards but did not get the desired result.
When using a FeatureReader to read CSV file, one can manually select in the "Parameters" section which attributes we want to read from the file. Very short question : does something equivalent exist for reading only a selection of attributes in a reader that loads "Esri ArcGIS Portal Feature Service" data ? Thanks in advance
Dear All, I am facing the following very weird issue. I want to test for several attributes if, for each of them, there are some features that contain a specific value.To do that, I have created a Custom Transformer that takes as input 2 user parameters (defined exactly in the same way, published and required) : 1) colname = the name of the attribute ; 2) progname = the value to test if the feature is equals to. When I go back in the Main, right-click on the custom transformer > Properties, in the prompt I can see well the 2 user parameters (colname, progname). But when I click on "Run to this" custom transformer, the prompt only asks for 1 of the 2 parameters (always 'progname', even if I switch the order of the parameters in the parameter manager of the custom transformer). In the Translation log, I see that the following command line is run :fme.exe myscript.fmwThis results in translation failure with the error message :Undefined macro `progname' dereferenced in file [...]When I
I'm trying to write data to a csv. I have a uniqe identifier that has two leading zeros. When writing to a csv file the zeros are removed. When viewing the feature information window the attribute has a string value. When doing the same in the written csv it says 64 unsigned integer even though I have set it to string in the writer parameters. What am I doing wrong? Making sure FME writes it as a string will keep the leading zeros right?