General

Hi All, I'm putting a workflow together to help me QA some data and the final output will be an excel file with some fields as info, Below an example of the desired output which the header is bigger thna the normal rows and the QA QC field says pass in green and fail in red: Is this possible using the ExcelStyler or need to use the FeatureWriter? Thanks 🙂

I am sending this date, Oct-23, through the DateTimeConverter. I have set t he input format as %b-%y2099. The DateTimeConverter is failing to parse the date with the message "Attribute(string: UTF-8)         : `fme_expression_warnings{0}.message' has value `Failed to evaluate expression '@DateTimeParse(Oct-23,%b-%y2099,repair)'. Result is set to null'". What am I doing wrong? I have attached a sample project that demonstrates the failure.My FME Form version is FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64). https://docs.safe.com/fme/2023.1/html/FME-Form-Documentation/FME-Transformers/!Transformer_Parameters/Date-Time-Functions.htm#Format

Hi how can I include the following api curl post in an http caller? curl -X 'POST' \\ 'https://<a domain>/upload' \\ -H 'accept: text/html' \\ -H 'Authorization: Bearer <a password>' \\ -H 'Content-Type: multipart/form-data' \\ -F 'filter=<a textstring>' \\ -F 'file=@<a filename>' \\ -F 'adddata=false' \\ -F 'type='  

Hi all,I am just wondering if someone can assist or provide pointers on how to generate a navigation tree in FME writing to a GeoJSON file, to be opened in arcGIS pro. My input/reader file is a CSV. For example, in the arcGIS navigation tree, data of types of poles should present as follows: Pole-> Steel->->Blue->->-> Pole A->->-> Pole B->->-> Pole C-> Plastics->-> Blue->->-> Pole D->-> Red->->-> Pole E

Hi all, I have a dataset (CSV) of different types of trees (type, colour, flower, etc) and I want to open this dataset in ArcGIS Pro. I want it to have a navigation tree and a heatmap based on dense areas.  I am new to FME and wondering how I do this and what the best output file format is for the structure I am wanting? I am struggling to find any direction of approach to this specifically. I have done similar in KML with Google Earth, although couldn't implement a heat map, and it is slow with my dataset.

Also is there any article to show step by step process for converting from IFC to geodaabase that can be used in arcgis pro

I frequently use Form/Desktop to grab data from SDE or from Geodatabases.  Creating the reader(s) is pretty easy. Load the dialogue, point at the connection file, load the list and select your feature class, and then press ok. This brings in the tables and features just fine. However, it seems like it never fails that I need to bring in another table or feature class from the same connection. If I save and close the workbench, I have to start the reader dialogue again. When I bring in another feature class or table, the new table also shows up as a different connection in the navigator pane. It makes troubleshooting a little harder when I have several different readers in the navigator that ultimately point to the same database or folder.  Is there a way to reuse the existing connections? The navigator and the properties don't have a way where to "double click" into the connection and add another table or feature class to the c

From my testing, when reading data that is branch versioned from an ArcGIS Enterprise Feature Layer, it seems there is a limitation on the FME Reader side as to how many layers can be in the ArcGIS Feature Service. For example, if I publish a service which has one layer, the FME reader can read successfully. But, if I publish as service which has multiple layers, the FME Reader reads the schema, but fails to read features.  Are there any known requirements or limitations in FME readers and writers when connecting to branch versioned ArcGIS Enterprise Feature Layers? Has anyone else seen this behavior? If so, what workarounds do you use? I would like to avoid having mulitple published services for a logical grouping of data. Thanks in advance! 

Hi, I have a number of points which I like to create triangle polygons from to form a sort of elevation wall. The desired way of creating them is to have the lower ground (red points) as focus. Let's say the first two points (A and B) derives from upper green points, then the third point (C) would be the closest vertical red point. Please see illustrated image and attached file. Thanks!

I have a large GeoTIFF file (11Mb after using compressing JPEG 75% and building Paramyd 6 Level Bicubic). And then tiling it with WebMapTiler, the result is 115,851 tiles.My Workspace:FME 2023.1 takes 1h15m to complete tiling and writing it.FME 2023.2 takes so long time and uses a lot of RAM and I can't wait, I don't know how long it will take actually. Do I mistake something?Everybody help!Many thanks. 

In my network I have multiple closures (Green Circles). Downstream from these closures I have risers (Blue Circles). I also have multiple boundaries (Red Polygons) which contain an x number of risers.  I need to calculate within each boundary which is the first riser that the cable hits after the closure. I need to mark these risers as value = 1 in each boundary as shown in illustration. Ive got as far as using a shortest path finder to try navigate to each of my Risers from each of my Closures but without much success Does anyone has any guidance on what method I can use to determine this?

I have installed FME Form 2023 on a virtual machine and when I try to run FME Workbench via a Remote Desktop session, the Workbench's main window does not display anything. I can see the title bar and, if I click at the right places, the different menus, but nothing regarding the workspace.  I have installed at least two different revisions of FME 2023 with the same behavior. However, with FME 2022, everything seems to work flawlessly. So the issue looks to be related with 2023 only, inside a Remote Desktop session (no issue when using on my laptop).  I tried to enable the GPU rendering after reading this link (https://knowledge.civilgeo.com/kb/enabling-gpu-rendering-for-microsoft-remote-desktop/), but that didn't change anything. 

I have a dgn file which when I read into FME loses a line and I cannot figure out why. When I view the file in Bentley View I see the following:-In FME :-  Would anybody have any suggestions as to why this may be? I appreciate that the line is a BSpline Curve, which can cause problems, but others come through OK. Any parameter you may know of that I can change to allow the features to be read?I have attached a clip of the dgn in case someone would like to replicate the problem.Many thanks for any words of wisdom 😀

I'm attempting to filter through all the files within a specific location to identify what shapefiles and feature classes exist within that location (dealing with over 500,000 files). I'm using a Directory and File Pathnames reader to kick off the workflow which is recognizing that there are zip folders within the location, but stops at the zipped folder and won't read the files within them. Is there a way for me to read in the files from the zipped folders as well? Thanks!

Did you notice "AI Assist" has been added to PythonCreator/PythonCaller in FME 2023.1?I tried it.It's not a question, just a chat. It would be nice if you can share your experiences on the AI Assist.Create a new method to calculate coordinates of the extents for a web map tile.AI returned:def calculate_tile_extents(x: int, y: int, z: int) -> tuple:    """Calculates the extents of a web map tile given its x, y, and z coordinates."""    n = 2.0 ** z    lon_left = x / n * 360.0 - 180.0    lat_bottom = math.degrees(math.atan(math.sinh(math.pi * (1 - 2 * y / n))))    lon_right = (x + 1) / n * 360.0 - 180.0    lat_top = math.degrees(math.atan(math.sinh(math.pi * (1 - 2 * (y + 1) / n))))    return (lon_left, lat_bottom, lon_right, lat_top)Good, but I want to convert latitude, longitude to x, y in EPSG:3857 finally.Create a new method to convert latitude an

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?), b

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

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 

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