Transformers

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...

Here is an example: I want to remove the small dots inside that circle. Thank you.

I am doing a simple SQL query that I created MS Sql Server. I pasted it into the SQL Creator and ran it, and it was successful. I then go to expose the attributes by populating them from the SQL Query, and nothing shows up. Below is my query. Can someone please tell me how to fix this. I have tried using the Delimiter statement at the top, but that doesn't work either. Here is the query: With AcscerRecdQry as (Select lpm.permit_no as PermitNumber, lpm.permit_id as PermitID, lpm.version as PermitVersion, gc.code_desc as PermitStatus, soclpm.soc_id as ScheduleID, soclpm.schedule_name as ScheduleName, (soclpm.ACSCERYearDue - 1) as ACSCERRptPeriod, soclpm.ACSCERYearDue, Case When (IsNull(soclpm.received_dttm,'') = '') Then 'No' Else 'Yes' End as ACSCERRecd, 'Permit Schedule Does Not Exist' as QA_Issue From nms.dbo.latest_permit_master lpm Left Outer Join (Select Distinct slpm.permit_

Hello everyone,I am trying to convert dgn (Microstation) to dwg (Autocad), but for some reason the blocks are in my dwg unrotated. In Microstation those are called cells. Does anyone know how I can get the cells rotated in the dwg file? The igds_rotation attribute does show the rotation values in case of Microstation (see below for some example values)and I read somewhere online that the attribute name that holds the rotation value in case of autocad was 50. I could be wrong though. In the output (dwg) the cells are unrotated. It might thus be due to the fact that I stored the rotation value for autocad under the wrong name. 

Hi , we wanna create 3D extruded Polygons based on 2D polygons.As Input we have geojson with geometry type multipolygon. With the Surface Draper we can drap 2D Polygons on the Surface. So for all vertices I get a z-value. This is actually working. Then we extrude these 3D polygons with the Extruder! But I get a strange result in the inspector: For us it is important that we have a GeoJSON with extruded 3D Shapes which fit our tin! This is right now not the case our polygons are extruded with same height but they have differences in height to each other.  Is it possible to do this like this way:Or do I have to change the geometry type inside the format? Hope someone can help me? Thanks in advance! 

I used several models. once without transformers and once with EsriReprojector, reprojector, and ...In all cases, the results are not in correct projection.even I force to create prj file and it has the correct projection but output dwg has UTM projection with wrong coordinates

HelloI have a DWG with blocks, when i use autocad_rotation the attributes are NOT rotated.Is it possible to roate also the attributes?Have a good day. 

Hello I am trying to write some polygon data from a csv file which contains the geometry data to an esri sde database, all the conversion is fine until i come to write the data when i get the error below. It says that the Number of parts in shape is incorrect for its geometry type. What does this actually mean. The data is building a polygon, which it does. I have added in a geometry filter to get the areas and polygons followed by a geometry coercer set to fme_polygon... Any ideas how to fix this or what could be wrong?? Error while updating feature in the table/feature class 'OS_NGD_BLD_FTS_BUILDINGPART'. The error number from ArcObjects is: '-2147215922'. The error message from ArcObjects is: {Number of parts in shape is incorrect for its geometry type}Storing feature(s) to FME feature store file `\\\\dnfme01\\FMEWorkbench\\Workspaces\\Ordnance Survey\\National Geospatial Database\\OS NGD Buildings Daily Update_log.ffs'++++++++++++++++++++++++++++++++++++++++

I am trying to migrate leaderline annotation from AutoCAD to ESRI. While reading the leader anno from dwg, the reader reads it as 4 individual components and not a single entity. Is it necessary to define all geodb_text_leader* attributes. With the attached Workbench only the text gets migrated and not the leader line. I have attached the sample dwg file, workbench and the GDB for better understanding.

Looking for a way to add a feature to a data flow based on a test condition where the feature count of the data stream is 1 or more? If there are no features being read from the reader source, no feature will be added. Best way is probably to test feature count equal to null.

Is this possible to automate in FME?  Is it also possible to run a script at an interval in fme, e.g. once per week?

input String is :10303 ARLINGTON AVE,RIVERSIDE, CA 92505Census Tract: 0410.03  Output String needs to be: 10303 ARLINGTON AVE,RIVERSIDE, CA 92505 I'm using the StringSearcher with the follow RegEx([A-Za-z0-9]+( [A-Za-z0-9]+)+),[A-Za-z]+, CA \\s\\d\\d\\d\\d\\d The result I'm getting is empty.

Unable to export Miss Dig 811 GML file to shapefile or google earth format.I had to rename the extension from GML to txt so i can upload it.