Using transformers to modify data.
Recently active
Hello everyone, I need help with the graphs below. I need to maintain the original structure for the graphs. Using the line builder changed the output structure, as you see below. I have an extensive dataset, some lines are correct, but some created their structure and direction. IMG 1.0 and IMG 2.0 are the original graphs. Some lines have around 500 vertices each, but I used a generalizer and changed from 500 to 2 vertices per line. I don't want them to reduce that much. I am looking at around 200 vertices maximum for each without changing the original graph formats. Which transformer can solve this? Thank you so much.
I have encountered a problem when formating a datetime. A log is raising a warning when the value is null. In order to avoid warnings in log I try to setup a condition in AttributeManager. I would like to reuse (copy/paste) the condition definition so I try to use "@CurrentAttribute". It's working as expected in Attribute Value part, but not in the test condition (see attached image).If I use @CurrentAttribute() ATTRIBUTE_HAS_A_VALUEI get <null> results despite the attribute has a value. Any suggestion how to set up the condition for current attribute correctly?
Hi community! I would like update a column in my table with a variable. For that, I put in a VariableSetter my value that I retrieve after a Tester and with a VariableRetriver I recall my variable, and I want to insert this value of this variable in all the lines of my Code_Comma column.But it's doesn't work.Someone can help me please ? Thanks
I am using the FeatureReader to connect to an ESRI SDE. I have specified the features to read, and selected Output Ports: One per feature, BUT out put ports are not being created for the features I specified. In only the default ports are available. I am having a similar issue with another FeatureReader that is pointed to a FGDB. I had to change the directory path for the FGDB and now all of the output ports are gone. I reset all of the "Features to Read" but like the above, I am not getting out put ports for the features I have specified. In the above there are no Output ports for the features specified.in the above only some of the Output ports for the features specified are available.
Hi All, I'm very new to FME so excuse my noobiness. I'm bring in a roughly 20 shapefiles and running them through a attribute filter to pull out the ones with a matching project number, from there i'm exporting them out as a .csv. As it currently stands all results are put into one spreadsheet. not ideal. i would like them all in one spreadsheet but as separate tabs for each individual layer. As a work around i've made each layer its own attribute filter running to its own .csv writer, then i'm copying them into a single spreedsheet.
Is there a way to create a raster of polylines, showing the counts rather than density per area magnitude? I have 17,000 lines and I'm trying to recreate the below graphic/visualization:
We have a workspace on a FME Server that creates PDF files using Adobe Geospatial PDF Writer in FeautreWriter.The files are transported into another system via PDF.js. Apparently PDF.js can't transport tagged PDF-files (?). Can I somehow make the FeatureWriter creater non-tagged PDF-files?Or is there other ways to get around this issue?
I have a json-file (see attachment) that contains the coördinates of a circular route. It looks like this:{ "segments": [{ "geometry": { "type": "LineString", "coordinates": [ [50.814103, 4.521174], [50.81309, 4.521811], [50.80626, 4.536902], [50.80482, 4.538866], [50.80573, 4.541452], [50.80621, 4.543173], [50.80705, 4.545501], [50.80755, 4.546541], [50.80777, 4.546841], [50.80919, 4.547739], [50.8096, 4.548199], [50.81052, 4.550243], [50.810663, 4.551096] ] }, { "geometry": { "type": "LineString", "coordinates": [ [50.810663, 4.551096], [50.81065, 4.555264], [50.81071, 4.555622] ] },... I want to convert it to an ESRI line feature class, but I'm stuck. The geojsonreader gives no error, but also no result as reader. Json-fragmenter gives me the list of vertices in an attribute, but I can't fix it to convert these points to
How do I Copy SHAPE column from an ESRI GDB feature class to a non spatial Postgres database?
Dear FME Community,I am currently working on a project that involves a vector point file containing electricity power plants. As part of my quality control process, I need to check if there are any power plants that overlap with the point file.I am wondering if there is an automatic way to check for this overlap, as there would be two situations, one where point file is overlapping with power plant in satellite imagery, or else it is not. I want to ensure the accuracy of the data and identify any potential errors. We can hover to locations and find it, but can there be something more in an automated way?I would greatly appreciate any advice or suggestions from the FME community on how to best approach this quality control challenge. Thank you in advance for your help!
Hi! I have a workspace where I mainly use a PDF reader to read around 5000 pdf:s in folders and subfolders (defined by the dataset “…\\**\\*.pdf”).The workspace is large and quite complex but the thought is to take the pdf file name, which is an object ID, and combine it with other files that contain the IDs coordinates, etc. The pdfs contain other info on the objects that get extracted through its predetermined local coordinates.The workspace has worked excellently, but since recently it doesn’t complete. The only change I recall is that the amount of pdf:s keep increasing as times goes by. I’d say that last time it worked was then it contained around 3000-4000 files.I also find the reasons for the error to be sporadic. Mainly the workspace runs though a few hundred pdf:s, but eventually I get the message that the pdf cannot be opened “because the file is not in PDF format, or because it is corrupted”. Sometimes the program just crashes. The pdf can be individually read with no issues
Hi,I have a workflow where I need to forecast particular values. The formula to calculate this forecast value (in Attribute A) needs to reference the previous feature in Attribute A, but the AttributeManager doesn't allow you to reference ajacent features (in this case, previous) for the same attribute. Is there a way I can do this? I wonder if a looping process would help. Thanks
I have a request to convert some postgis geom data into TopoJSON. However they want the output to be single combined file similar to what is produced by https://mapshaper.org/ I can easily create individual TopoJSON files in FME. (Simple read postgis and connect to TopoJSON writer.) But I have not figured how I can produce a combined file with multiple objects in it like what is done with mapshaper.org site. I uploaded sample TopoJson output files from FME and the sample combined file from mapshaper. I figure this will likely need some type of python code, which is fine, but I'm hoping to not install any additional modules outside what FME provides. Currently using FME 2020.2. That is what company uses. But I can use new FME version if it had options for doing this in some update.
In this article - Woody describes a custom HTTP caller using a parameter to call PBI API. Idea: Power BI Writer (safe.com), I don't really need a writer, I am looking for a way to use the HTTP caller and liked the post about using parameters.I have followed Microsoft's instruction for registering an APP. I can use MS docs to call the API to refresh a dataset. I have done the same with Postman. I am stuck trying to do the same with FME.Thank you - Tim Woods
Hi,Ich use a String Replacer that cleans all values from "??".Mode: Replace TextCase Sensitive NoText to replace ??Replacement Text(Replacement Text is empty as just I want to delete all ??) This Workt fine in FME Server 2021on FME Server 2022 I get an Error:"StringReplacer_4 (StringReplacerFactory): Internal error: Failed to build ICU replace pattern. String was '"Große Mohreng. 9, 1020 ??, Österreich"', replacement pattern was '??' "
I try to color features by attribute value. Tried both the FeatureColorSetter and the KML Styler. I have the color in an attributes for each feature both as hex "#FFCC00" and as decimal "255,204,0" but both don't work when i feed them to "Fill Color" in the KMLStyler or FeatureColorSetter. How do I have to format the color values?
Not sure if this is a known issue or not, this is in FME 2020.2 GeoJSON processed by the GeometryReplacer results in a line with 0 coordinates, it is not rejected which is what i would expect to happen e.g. {"type":"LineString","coordinates":[[[0,0],[100,0]]]}Processing this with the GeometryReplacer, results in this geometry
I tried generalizer and spike removal. The spike removal works to remove the twisted lines, but it leaves small cuts everywhere. Any advice how to clean the small cut lines and reduce the number of vertices? Thank you so much!
Hi, I have a point cloud of a rail line. I also have a guideline of the position of each rail (within +/- 0.1m) What I want to do is fit a template to the point cloud at increments of 0.5m along the guideline. This is to extract the location of the running edge. Does anyone know how to do this? I currently do this in Topodot, but that is a semi-manual process which is time consuming. I'd like to automate it
I have 3D polylines that I’d like to split at specific elevations (3,000’, 5,000’, 7,000’, and 10,000). Any ideas are welcome!
Mdenoise is an denoising algorithm for topographic use that preserves sharp edges. It's part of GDAL, so I was wondering if it maybe was integrated in FME, but under another name? Or is there an transformer that works in a similar way? Some background to mdenoise:https://personalpages.manchester.ac.uk/staff/neil.mitchell/mdenoise/
Hi, I have a DFX file and would like to convert to an OBJ file, however it does not convert cleanly. Has anyone come across this and converted correctly. Many thanks
I'm parsing data from an SFTP call to get the file name. I'm returning _list values that have all the FTP properties of each file. I use an AttributeCreator get the length of this string as an attribute (ListStringLength=69) --- @StringLength(@Value(_list))-rwxrwxrwx 1 user 278361 date 00137 0001539147T ABCDEFG1234567.jpg I'm also using the AttributeCreator to get the starting position of the file name based on the prefix as another attribute (StartingPosition=33) --- @FindString(@Value(_list),"00137 0001539147T")278361 Mar 21 09:49 00137 0001539147T ABCDEFG1234567.jpg From here, I tried to simply subtract. But that didn't work.@Value(ListStringLength)-@Value(StartingPosition) = a string value 69-33 So then I added an SQLExecuter and did the math in SQL and output the FileNameLength.select @Value(ListStringLength)-@Value(StartingPosition) as FileNameLength From here, I added an AttributeCreator to get the FileName. @Substring(@Value(_list),@Value(StartingPo
Hi I have the intersection points in point feature. I want to have attribute field as the street address as 2 St/3 Ave. The street network has line features. is it possible to get this happened to point feature at intersection? thanks in advance.
I have several Feature Classes in a FileGDB and would like to convert these into a Geopackage. Therefore I would like to remove/not read the different schema-names / Schema-prefixes.A Feature Class "WAS_LABEL/WAST_TEXT" would be read as "WAST_TEXT" without the schema-name/prefix.Is there an easy way to achieve that? The FeautureClass-Names in the geopackage need to be "flat" without schemanames...