FME Form

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_

At our organization we have an extensive FME server installation with a lot of machines for the engines and cores. We have Apache tomcat 9.0.50 installed, but have a lot of issues with this version of tomcat in combination with fme server 2021.1. Our decision was to install a newer version, 9.0.68., recommended for fme server 2022.2. We succeeded to upgrade tomcat without deinstalling FME server. However we are interested if we can expect issues.with this version in the future. If you need more information please let me know.

Hi,there are lots of qstns about one to many joins.I want to understand what transformer to use to achieve a one to one spatial join based on geometry? I have a line in GIS that I want to analyse to see if there a geometry join to a line in CAD. This works fine with the SpatialFilter if there is only one line. however when GIS and CAD has two lines in close proximity the SpatialFilter is creating a many to one join by joining the Two GIS lines to the same CAD line. How do I create the one to one join please? thanks in advance

I am currently working on a project where I need to combine more than 20 personnel geodatabases  into a single one. The geodatabases have the same table field structure and also have attachments and relationships classes. I am using FME to perform this operation.I have  difficulty in achieving this effectively. I have tried using the "Feautre Merge” and tool in FME, but it seems that this tool does not take attachments into account. Therefore, I am looking for an alternative solution to combine these geodatabases while retaining attachments.I am sure that there must be a solution to this, and I would like to know if anyone could help me find a suitable solution. If anyone has worked on a similar project or has in-depth knowledge of FME, I would be delighted to hear your advice and suggestions.  

Hello, I have a table which needs to be written to PostGIS. One of my dataset columns contains a list of buffer distances for example 300, 200, 100m. It would be ideal to write this as an array to PostGIS for example {300, 200, 100}.  If the table already exists with an array column in PostGIS, FME will update the array correctly. If the table doesn't exist I can't see how to set the column type as an array in FME. Is it possible? Thanks :)

I need to clip the road with a bridge, and in the section of the road, where the road overlaps the bridge, change its attributes. Thanks in advance for your response

Hello everyone,  I used "featureReader" to read all CSV files from a specific directory via DirectoryPath and it works fine with me but I am surprised a little bit why I got duplicate data.  For example, if I have 3 files, it counts the read 9. What is the best way to ready all CSV files fast and quickly?  Do you advise to enable the cache files?  

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. 

I'm looking for a way to upload to an azure file storage with a new filename. I eventually want to expose an FME server app that will allow the user to upload any raster file, and then will upload that file to the Azure Storage and call a few REST APIs afterwards. I have a basic workbench working on my machine that can implement the workflow.  The issue is, we can't have any spaces or periods in the filenames in the Azure storage, but I want to allow the user to upload rasters without changing the name. I have not found a way to be able to rename the file before or during the upload. I have experimented with using a Feature writer transformer with the File Copy writer to create a temporary file then using the temp file path in the Azure File Storage Connector but I'm struggling to even rename copies there. I realize I could probably do hacky stuff like use a systemcaller to rename the file, but if I need to do that I'm not sure what the ad

In Salesforce, they have a feature called "Platform Events" where the fields are defined in Salesforce. Does FME have an existing connector or an app for this and can FME also publish changes to the "Platform Events"?Thank you

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 h

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. 

Is FME version 2021 able to work with ESRI Geodatabases in ArcGIS 9.0 and 9.3 formats?

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_

Hello everybody,I want to connect Survey123 and my FME Workbench. I try to get the results of my survey but I just find informations about the create a webhook. So I can only get a new or edited input.Can I read all the current results with FME?Thanks!

I have a disconnected Python Caller which is suppose to do some data cleaning in target dataset before Reading data from source and writing them into Target Can you please let me know how I can make a sequence here before reading the data from source to ran and do the job of Python Caller First?   I tried to connect/put the Python caller before Reader but as you know where is no way to add it before reader , out of the box Thanks

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.

The main goal of my question is to assign measures to neighbouring lines. The black line has measures which i would like to assign to the red lines. I have tested for one line only and thus tried using the LineOnLineOverlayer and set a tolerence level of 10, the positive thing is the neighbouring whole line gets assigned measures, however some vertices remined snapped to the blackline(the one with measures),still trying to figure out why.The idea is1.) I assign measures to the red lines(A,B,C,D) from the black line, 2.) How do i vary the tolerance so that all the lines get captured.Any ideas will come quite handy. Thanks,Keller.

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.

I was excited about this new feature announced at FME UC 2022 and as soon as I saw the beta for 2023 dropped (and I also really want to test this on Server Apps), I downloaded to test. However it seems broken. The drop-down isn't revealing anything. Shouldn't it reveal one of the other parameters as input? Or am I missing something? Thanks.

Hi,We have a python clone in ArcGIS Pro where we have pandas and psycopg2 installed. We have a standalone script that runs fine when run in IDLE (ArcGIS Pro). We want to integrate this into a workflow in FME (preferably without using system callers etc.).In my various testing of compatibility settings and in the main options (including setting the clone with the python home) I only ever have luck with psycopg2 as I think it installed in the FME libraries.Anyway, I believe the correct settings areMain Options/Translation:WS Params/Scripting/Python Comp: Python 3.6+I also explicitly set the Esri ArcGIS Comp to ArcGIS Pro too. When set like this I get the following error about the "encodings" module in the log: