Transformers

Hello, I am writing to an excel sheet with an existing template. Before the writer, I am using a counter (starting at 0) and attribute creator to then use "Use attribute names as column positions" and "Row number attribute". My attributes are B, C and D which are various strings and B_row_number (@Evaluate(16*@Value(_count)+10)) and CD_row_number (@Evaluate(16*@Value(_count)+16)). I would like the output sheet to look like the image below: Unfortunately, I can't assign different "Row Number Attributes" to arrange it this way (B using B_row_number, and C,D usin CD_row_number). I get the feeling there is a simple workaround I'm not seeing. Any help is appreciated! Thank you.

Good morning I want to generate a json file that accompanies a photograph and I want the name of the json file to be the name of the photo which is contained in a 'Photo' attribute I also want as many json files named with the name of the photo as there are photos in my source directory. I tested in the json output to put the Photo attribute in the entity name but it doesn't work. Thanks

So the result should be a point cloud that has points in a grid of 1m x 1m. Personally I would make a DEM with cell size 1m, but that's not what they want. So I have a boundary of the project area. I make a 2dgrid with cell size 1 meter. I clip the grid, because it's made on the hull of the project area and not the project area itself. Then I use the grid to make points in the center of each cell and also use the grid to clip my point cloud. I use the pointcloudstatisticscalculator to get the mean of the z values within one cell of the grid. So I can use the X en Y from the center point and have to add the Z from the statisticscalculator. I merge the data together based on the counter I added. Then I use the vertexcreator to make points with the correct X, Y en Z. If I inspect these, everything looks good. In the data inspector we see that the points have the correct X, Y en Z. The problem is that I can not write the data as point cloud. Not as xyz file and not as las file. I get this

There are many FME transformers that allow you to select one or more attributes for analysis. In this case, I have about 350 attributes in a CRCCalculator and I would like to select about half of them. It would be much easier if could select them in a group rather than individually. Is this possible? I've tried using the standard shift-click - clicking the first checkbox and then doing a shift-click somewhere down the list on another checkbox to grab everything in between - but no luck. Is it done another way? I'm using FME 2020.1.2.1 (Build 20624).

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_VALUE I 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 vertices/line. Someone who can help me out?

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 iss

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 Text Case Sensitive No Text to replace ?? Replacement Text (Replacement Text is empty as just I want to delete all ??) This Workt fine in FME Server 2021 on 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/