Transformers

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.

Hi, I have a few 100 IFCs that I need to process - all of which have a slightly different range of IFC Feature types.  Because their is not one IFC that contains all IFC features types, this has led to me having multiple readers to cover all feature types as shown in the image. I worry that this is not following best practice and is a risk when it comes to batch processing as each reader will need to be updated with each new file in the batch and also has a risk of data loss. I am wondering if I can create a generic reader that will cover all possible IFC feature types so that processing a large number of IFCs can be automated?

The Mapbox vector tiles (MVT) writer has parameters for minzoom and maxzoom. Is it possible to make the writer read these parameters from an attribute in incoming features? In addition to z0 - z22 , you can also select "Source" in the writer parameters, but there is no documentation on what "Source" means.

 I get a very vague error when running it: " Error running translation." and no other details. I have over 60 GB of space on the drive so it can't be a matter of space. Also 16 GB RAM and closed all other applications.

I am running into an issue while trying to import a 3D model made in SketchUp into ArcGIS Pro. My planned workflow was to: Reproject the spatial reference of the .skp file from XY-M to NAD83 CSRS Zone 10.Deaggregate the mass buildings to individual buildings.Convert the .skp (SketchUp) to .dae (COLLADA)Use the Import 3D Files 3D Analyst Tool in ArcGIS Pro to import the .dae model into Arc. Once imported into ArcGIS Pro, the spatial reference of the model appears to be in NAD83 CSRS Zone 10, but the model still ends up in the middle of the ocean, as if it didn't change projections. How should I go about importing the models so they end up in the correct location? Will I have to geo-reference each model? Thanks!

Hi, I have a big csv file with points that I want to transform to lines. The Linebuilder works fine when you have attribute that controls when to build a new line. But what is the approach if I want to start a new line when the next point is far away?

Hello, I am trying to read an excel file with FeatureReader but my excel file has an extra row before the true header row.  Row 1: Report TitleRow 2: Header RowRow 3-N: Data Is there a way to skip over the first row when reading in the file with FeatureReader? Thank you

I have a workspace that accepts both a raster input and a point vector input. I want to get the value of the raster at every single point. I know that the vector features will always be provided in WGS84 latlongs, but the raster might be any arbitrary coordinate system.  The simplest solution is to reproject the raster to WGS84. However, raster reprojection is very expensive compared to reprojecting a few hundred points. I want to be able to temporarily reproject the points to whatever CRS the raster is in. What is the best approach to this in FME?  So far I have been able to use the coordinate system extractor to set the crs as an attribute on the raster feature, but I'm struggling to get this single attribute from the single feature to use to set the reprojector input. Things I have tried unsuccessfully:Python scripted parameter (can't find a python API class that can load the raster and look at the CRS)Set a parameter within the workspace at runtime (apparently the parameter

Hi all,I have issues using FeatureReader transformer when reading all .xlsx files from folder. During execution of the entire workbench it will load just couple of them. But when I use Run From This (from FeatureReader) it will load all files.I'm using FME Desktop 2022.2 version. Thanks,Bogdan

I have this block of XML. <?xml version="1.0" encoding="UTF-16"?><place place_id="11703">  <gas_price type="regular">22.19</gas_price>  <gas_price type="premium">24.19</gas_price> </place> I used an XMLfragmenter to break up the big block of XML from the data source into the above snippets for different stations. But I can't figure out how to extract these using the XML transformers.  I am trying to get a result like this: ID | Price Premium | Price Regular11703 | 24.19 | 22.19 I know I'll probably have to transpose the data, but even before then I can't get the XML extractor or flattener to do anything to this little JSON snippet. Is there an obvious query to extract this using one of the transformers? Thanks

Is there a way to add logic to User Parameters? Example: If one option is selected then another will be disabled?

Hi all, I'm looking for the optimal way to create a 'mesh' of potential flow paths to use with the ShortestPathFinder. Currently I feed my workspace a polygon of interest, then to a point cloud of required spacing. Turn that into individual points and then connect them up in the 8 points of the compass using a NeighbourFinder/ListExploder/VertexCreator. My query with this is at the end I have to use the Matcher to remove lots of geometric duplicates where point A has connected to point B, and point B has connected to point A. Line direction is irrelevant to this task so I was wondering if anyone has any ideas as to how I could optimise this process?

Hi All,Hoping a fresh set of eyes may be able to identify why the workbench below performs differently when run on its own and when called on using a workspace runner. The intent of the workflow is to read a table of gps points and filter them into 'Runs' between a Start and End time. I have two branches for testing right now. One writes to a spreadsheet and one to csv. I am expecting that all the runs will be written out to the spreadsheet while each run will be written out to their own csv file using the unique RunName. I don't think it is an issue of datetime format. The workspace below runs with test values in the User Parameters but when the Workspace runner reads the table of Start/Stop Runs and feeds the StartTime EndTime and Runname to the workbench only one csv is output while the spreadsheet contains a larger but incomplete dataset of filtered gps points. So the spreadsheet gets more data but incomplete while only one csv is written out when I am expecting many cs