FME Form

After upgrade to 2023.1.2 FME Form from FME Desktop 2022.2 Microsoft SQL Server Non Spatial Writer start writing empty attributes for all text fields but Datetime field still populating. Have anyone encountered this issue before? I tried changing TYPE to text, varchar_max, char, non of these works on FME Form 2023.1.2I have replaced that writer, replaced the workspace with brand new canvas, still no luck. But when I run the same exact workspace in FME Desktop 2022.2 the table populates fine. To make it even more confusing, within the same workspace I have another SQL Server writer but it just goes to another table, both version are able to populate all records.Something interesting I saw on the log for 2023.1.2 version is that before it showed 11 record written to the table, 120 attributes were truncated. (not sure why?), but in 2022.2 version there's no warning on this issue.I also attached log files from both versions.

Hi, I am just wondering if it is possible to read the content of Web App published to Esri Portal. I want to know what layers have been grouped in which layer group. I think ArcGISOnlineConnector has to be used, but I can only get the general information (even after exposing all available attributes). The Web Application has multiple layer groups with different layers included.  

I have a workspace that was just pulling data and joining schema from two feature classes from an enterprise geodatabase. Then, we had a business need to add two new fields to the output feature class. (I cannot add them to the input feature class). Now, when I run the workspace, it overwrites the edits to those two new fields. Does anyone have suggestions on how to set this up in FME so that the two new fields (flagged and flagged description) aren't overwritten? Here is a screenshot of the workspace. Thanks!

Working Key: 1472_3_81445Not Working Key: 1472_E2b_81445 

Python = np.cross(XYZ, ABC) ????

I have data with different cp-code formats (like ASCII, UTF-8, etc.). So some chars are not readable. Is there a transformer that can convert my data to readable chars? I dont know the cp-code of the incomming data. So auto-convert to i.e. utf-8 possible?

I installed the HOME version for my own private research. I am trying to register for a license but cannot activate it.　​ -I checked the progress in Task Manager, but it doesn't seem to be working. -I have used it once in 2019 and it worked then. (Same Machine, OS:Win10)​​FME version: FME Desktop 2022.0.0.1 for 64-bit Windows (Build22339)OS: windows11, 64bit ​

I have a workflow that creates 3D scenes and exports them to glTF, FBX and OBJ. The glTF and FBX work fine (the trees, buildings and terrain are seperated objects that I can individually selected in a software like Blender). The OBJ writer merges all the meshes together, so selecting individual objects is impossible. Even when simply reading a FBX file, with 472 seperate features, and exporting to OBJ without any transformation, the OBJ writer merges everything together. I tried all the parameters in the OBJ writer but nothing seems to work to get seperate objects. Does any one know what I should do ?

I'm working with the PowerPointStyler and PowerPoint Writer for the first time, and have gotten pretty good results. I'm applying statistical analysis to my data, and then outputting these statistics as a bar chart to a pptx. My template pptx has graphical images as headers and footers of the slides.  One issue I'm experiencing is that the bar chart it creates is the entire size of the slide. So I'm getting overprints with the chart and the template graphics. Is there a way shrink the graph to a custom size from the transformer/writer in FME? Secondly, I'm wondering about the text size of the labels within the chart. I don't see a way to change the size of the labels from FME. Am I overlooking that functionality?

We (Red Geographics) often organize masterclasses to show and tell people on how to do something in FME.Our last masterclass of the year is going to be the opposite. In the Anti-masterclass we're going to tell people how NOT to FME. It's gonna be a fun way to end the year and share some funny situations, oops-moments and things to avoid. I'd love to get some examples from FME experts from all over the world. What has been a blunder or a funny mistake you want to share that we can incorporate into our (Dutch) webinar?

I am working on a web application project and will like to include energy consumption, inlet flow and outlet flow, temperature readings visualizations in the 3d model buildings in Cesium

Hello , i am confused in my workspace .i would like to extract the coordinates of start point and end point of the lines .So I used coordinates extractor index 0 , and other coordinates extractor index -1 .so I got the coordinates .but how I know , this coordinates belong for which point id ( I mean which side of line is start and which side is -the end ) and depends on what ?my target to get the coordinates and the relates points id to it .I would like to get theses attributes ID line | id point start | coordinates (x)start | coordinates (y) end | id point end |coordinates (x) end |coordinates (y) end as example .see picture , I need to extract the coordinates of each line ( start and end ) and know which id of the point that relates to this coordinate Fme 2021  

Hi,We have FME server FME Server 2022.2.2 Build 22782 using SSO to login. We have role based acces to functionality using sync with Windows AD. All users can login to FME server using 'Use Windows Credentials 'except one person who has the same role(s) attached to him as other users. Different browsers were tested fmeserver log is attached to this call. Error is at line 295 Kind regards,Gerro Zegeling 

The firs one query is  And the second one is Then I need to do a join with this second query and create a list with the results.I dont know if with the SQL Executor transformer I can replicate this two querys.  Any idea? Thanks

I can't open the following dataset on FME work bench.

I observed some issue by when executing workbench, I used following software and version mentioned below:              ArcPro Version – 2.9.0             Python Version -- 2.9             FME Workbench – 2021.1.3.0    I need some help on this. 

We would like to automate all the steps in deploying and configuring FME FLOW. Most of the steps in the application itself can be done via the API, however there is no option to do this for the proxy settings. We have tried many things already:-Setting the environment variables in windows-Running mcd-scripts to set the proxy for windows and FME itself (https://docs.safe.com/fme/2019.0/html/FME_Server_Documentation/AdminGuide/Using_FME_Server_wit)-Looking all over the v3 & v4 API documentation-Looking in all the FME flow config files-adding the proxy settings in the server.yml file in the tomcat folderAll above didn't work So do you still have a suggestion? We assumed it might have to do with security that it is not so easy. Thanks in advance, Matthijs

Long time listener, first time caller.Newish to FME and was attempting to use a user parameter for the first time to allow the user to input the number of days they need to pull data. I have the parameter and the initial formula working fine. DaysPulled is my user parameter: @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P$(DaysPulled)D),%Y%m%d) The problem I'm running into is later on in the flow I need to use that user input and add a number to it, effectively turning the user parameter into DaysPulled +1 and DaysPulled+2. I've been beating my head against the wall trying to modify DatePulled using add, sum, +1, etc and can't find the right format to get what I need. Example of failed attempt.@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P@add(1,$(DaysPulled))D),%Y%m%d) Can anyone point me towards a solution?

New to FME. I can't figure out why my writer (a .gdb) isn't writing anymore. I built a step by step PointOnArea inspection on 4.5mil addresses against specific shapefile polygons. I keep all 4.5mil and I just add a column that represents each polygonarea. In AttrMgr I reassign the 1's and 0's to Yes or NO. Everything runs awesome until I try to write the data. It stops immediately. The transformer message is very long but pretty much says something is wrong with every column and row.

Which FME version is compatible with SQL Server 2022

Hello FME community, I am new to working with PDFs in FME and Python. I have two input files as following: 1.   The first file is a PDF named “all_maps.pdf” with around 1000 pages. Each page represents a single map, and the page number serves as the ID for each map. 2.   The second file is a shapefile named “main_map.shp.” It contains mesh squares for the entire area, and each square represents a map in the PDF file with a unique attribute called “ID.” This ID corresponds to the map ID (page number) in the PDF file.  My aim is to combine the outputs of both datasets into a single PDF file, totaling 1001 pages. The primary map in the “main_map shapefile” should be on the first page, followed by the other 1000 maps, each with clickable links for every square on the first page. The objective is for the user to click on a specific square and navigate to the corresponding map in the same file. For instance, if the user clicks on square number 60, the PDF should scroll down to page number 61

Hi all,I'm new to FME and there is a lot to learn. I have been trying to research into how to generate a heat map (Hot Spot Map) in KML for Google Earth using FME Workbench (2019.2). I can't find an approach or forum that explains how to do it. Could anyone provide some tips on the process of transformers required to generate this? I currently have all my data plotted on Google Earth, I want to transform the plots into heat maps of dense areas.  If anyone has knowledge on this, I would love to discuss this. Thanks in advance!

I am unable to see FME badges on my board. I completed FME basic training and some parts of FME advance and server. Please share the link for that.

I saw a filter area in Visual Preview and wanted to inspect my data to make sure I got the same number of rows as my source data has which was 92,688. I did not. I'm not sure why. I filtered on the column that has 92,688 entries, but what was returned was 93,231 (543 empty rows/records). I have no empty rows in any of my source data either. I'm using FeatureJoiner to bring over a column that was not in my original data. The two source files have a common attribute: LocationID. The Source file has 4,500,626 rows, and my joining source file has 92,688. When I joined the data it came back with the 4,500,626 rows with my added column and data (92,688). So why does my filter show 543 blank rows more?

Hello, I want to rotate my point cloud using 3drotate along the Z Axis. The thing is the rotation is made around the origin 0,0,0. So i extracted the centerpoint of my point cloud to use it as an Origin but I don't know what to put in Direction to still rotate it around Z axis Thank you