FME Form

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 and longitude to x and y in EPSG:3857.AI returned:import pyproj def lat_long_to_xy(lat, long):    in_proj = pyproj.Proj(init='epsg:4326') 

Dear fellow FME users, I am trying to delve a bit into the Rcaller in combination with asking data from a website (CBS). I have a bit of R experience, but not so much with the Rcaller. With Rstudio the code works without a problem, however I don't manage to succeed in FME desktop 2022.2.1.0I am running the code below. I am aware that you need to adjust the R code a bit before making it work in FME desktop, so I was wondering whether I have to adjust the current code. In my case the Rcaller is running and it seems like it's doing nothing or stuck. I therefore I assume that the code is probably not working. Can someone else test and see how I have to adjust the current code?  Furthermore I am looking for blog posts that delve into the Rcaller. I would like to learn more about the rcaller and make myself a bit more proficient.# Run once:install.packages("cbsodataR") library(cbsodataR) # Downloading table listtoc <- cbs_get_toc()head(toc) # Downloading entire dataset (can take up to 30s

example of text string Bike :SS Lightning;NDIS #:;Prefname:Jacob;GEOG CODE:46429;Referred By: Newsletter;NDIS Planner:;Continual EOI:;Customer Type:46021;Date of Birth:;RidingCommunity:Short stature;Support Co ordinator:;notification_billing:1;notification_reports:1;Allied Health Company:;Allied Health Contact:;Allied Health Position:;notification_marketing:1 not all features contain all of the field names. I want to end up with columns Bike, NDIS#, GEOG COde etc and the data for each attribute in a excel spreadsheet. Thanks

Looking at article Working with Geodatabase Field Aliases: Altering Alias Values (safe.com) I am trying to run the same directly to an AGOL hosted feature layer. I have created the requisite "_alias" field to match those that I need alias values for, but no dice. Also tried adding the same fields (matching the attribute manager) to the writer attributes (manual setting) but the result simply created additional fields with the "_alias" suffix. Is this possible with this writer?

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