Transformers

I am a newbee, I have a spreadsheet that I need to have the data sorted by closed status and date column based on a particular date. Thanks for any help to where I can start.

I have a database table with about 5 million objects. Each object has positions (lat, long in two fields). I want to read only the objects that lie within polygons (features read from a spatial source). Is it possible without reading all objects?

I'd like to buffer only one side of a line. According to the FMEpedia articles below, in FME 2012 and later the Bufferer transformer should have this as an option. I'm using FME 2013 sp4 (13547) and the transformer doesn't have it as an option. Am I missing something?  http://fmepedia.safe.com/articles/Samples_and_Demos/Buffer-On-Left-or-Right-Side-Only http://fmepedia.safe.com/articles/FAQ/Whats-Great-2012  I did find the MultiBufferer from the FME Store but I can't get it to output a polygon, just a line that is offset the distance I wish the buffer to be.  Michael

Hi Everyone I am slightly bamboozled and wanted to know if someone knows where I am going wrong or if this is a potential bug.I have had used the FME Cloud and FME Server for loads of FME Server Apps, and havent come across this issue so far. I get the following warning after running a fme server app I am converting a .dwg file to an excel file.  If I use a feature_reader set for readings dwg:Autodesk AutoCAD DWG/DXFI get the warning, that the no output can be generated. But if I read an ifc and convert it to excel, all is well.  Is there maybe a problem reading dwgs? Why is there no output generated? The FME Server Jobs show that the job is completed without any errors. I have uploaded a .dwg and .ifc and the workspace regardsFred 

Is there a transformer that will convert a multilinestring to a linestring object? I'm trying to load road centrelines in an oracle spatial database, but the road centreline table in oracle uses GTYPE 2002 (line). Multilinestring is 2006, so I can't apply a spatial index. Any suggestions please?

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 morningI 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' attributeI 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

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_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?