General

How to derive a coordinate from Geocoder transformer (latitude and longitude) attributes

I WOULD LIKE COMBINE /MERGE 2 TABLES( ONE SHAPE FILE AND ANOTHER EXCEL FILE ) BOTH HAVE A UNIQUE ID .THE DATA IN SHAPE FILE IS BUILDING LOCATION AND THE EXCEL FILE CONTAINES MEMBER DETAILS OF EACH BUILDINGS EACH COLUMS TO BE COMBINED WITH MEMBER DETAILS FROM EXCEL SO AS EACH ROW IN EXCEL FILL MEMBER DETAILS IN SHAPE FILE OF BUILDING COLUMN

INCLUDE -- failed to evaluate Python script `def ParamFunc(): import cx_oracle schema  any one faced this problem? please share Ideas to fix it.

Hi Can you please advice on how can i force the excel writer to use new line for multiple records. For example making a list of IDs instead of having the whole text as one line. Below is an example where the red is what i want to avoid, having to do it manually in excel, the green what I want to achieve.   

Hello, I work with autocad and FME 2016, I transform a point type block defined by its name, insert point, x scale and y scale as well as its rotation The attributes are contained in the point, the lines in this block are only skin. I want to convert this point to a line with only 2 vertices, with the insert point as the first point and the second point defined by the x and y scale + rotation. I'm stuck because I don't see how to do it. Thanks for your help

I have an excel sheet, and need to read the value that's displayed in the cell, rather than what the actual saved value is.I haven't had much luck being able to find any way to do this. I was hoping the <attribute_name>.formatting attributes would contain this value, but it doesn't seem like it is. This is messy data, and values in this column might be text, might be a number, might be rounded to different decimal places, or might be padded with .0 in case of integers. So any solution would have to be on a per cell basis rather than making any global assumptions on how a number ought to be formatted. If there's a solution that works in FME Desktop 2017 that would be preferable, but I'm willing to use later versions if necessary.

Dear All.I have made an absolut simple workbench with LAS reader to a Recap writer. Nothing fancy.But it seems to have a limit of an amount of files that I can read and write. right now the limit is about 70 files in write.I have searched and asked around at the office, but cant get an answer.I have 100gb available space and plenty of memory, so that is not the issue.Attached is the script.Hope there is a solution, since there are about 1.000 files that needs to be converted which will result in about 10.000 files written. 

Hello. I have a georeferences Collada file, which is placed in Jersey EPSG:3109. If I load the file in Global Mapper (BlueMarbel) I get the correct position, but in FME the 3D model is being placed in North West Russia: What is the reason for this, and how can I fix it? I've uploaded the file here: https://drive.google.com/file/d/1ddN133UlQx2BVAqtq7fNzY7k15G6XYjD/view?usp=sharing

ERROR |BADNEWS: java.lang.StackOverflowError class std::unique_ptr<struct JavaSession::ErrorInfo,struct std::default_delete<struct JavaSession::ErrorInfo> > __thiscall JavaSession::exception(struct JNIEnv_ *,class _jthrowable *)(c:\\code\\fme\\foundation\\util\\java\\fmeutil_jni\\javasess.cpp:748) - class std::unique_ptr<struct JavaSession::ErrorInfo,struct std::default_delete<struct JavaSession::ErrorInfo> > __thiscall JavaSession::exception(struct JNIEnv_ *,class _jthrowable *)(c:\\code\\fme\\foundation\\util\\java\\fmeutil_jni\\javasess.cpp:748)

Is there a way to limit the size of Microsoft Excel Spreadsheets to say 250 Rows, so that the Writer ends up spitting out multiple Spreadsheets for Work Packages that you can then assign to members of a team?

The problem: We have duplicate ID's across various tables, an example being: Table 1ID 1 = UNI-ID1-234211ID 2 = UNI-ID1-234211 Table 2ID 1 = UNI-ID2-230011ID 2 = UNI-ID2-230011ID 2 = UNI-ID2-230011 I want to find the duplicate ID's and then increment the last part of the ID, but retain first lowest value. For example: Table 1ID 1 = UNI-ID1-234211ID 2 = UNI-ID1-234212 Table 2ID 1 = UNI-ID2-230011ID 2 = UNI-ID2-230012ID 2 = UNI-ID2-230013 I've isolated the duplicates with a Matcher already. I've split the ID based on hyphen to get me 3 parts to the ID, _list{2} gives me the last part.  I assume I'll need to push it through a looping custom transformer maybe? or can it be done with Listing techniques too?  Thanks for your help,

Hi. I am searching for a solution to convert the result of my workflow which is a multi solid to different surfaces including ground, wall and roof. Is it possible in FME? I have searched a lot but it seems to be impossible.

Hi. I have a cityGML file containing Roof, Ground and wall surfaces. The Ground Surface has been changed, so I should Change the Roof Surface now. But I cant find a way to do it. Can someone help me?

How can I convert with "AttributeCraetor". For example, I want 123,34 to 123.34. commas to dot thanks

I have a 3D point dataset (no point cloud) and a 2D line dataset. The lines only consist of a start node and an end node. The point dataset is identical with the start and end nodes. My goal is now to transfer the height information from the 3D point dataset to the 2D nodes of the lines in order to obtain a 3D polyline. Is there a way to do this in FME?

When I download the GTFS file, the latitude and longitude are present in the Shapes and Stops dataset. Please, see attached.Bart GTFS data source link can be found at the bottom of their website page: https://www.bart.gov/schedules/developers/gtfsor via direct link: https://www.bart.gov/dev/schedules/

Welcome to the last What’s Up Wednesday before the FME World Fair. We will be pausing What’s Up Wednesday for two weeks during the World Fair to focus on some special content during the event. Stay tuned to this space!  FME World FairSpeaking of the FME World Fair, less than a week until Don and Dale kick off the event on Monday, May 4th at 8am PDT. Register for free and see the agenda.   BlogAnalyzing Job Statistics in FME Server: New job statistics were introduced in FME Server 2021, check out the latest blog post to learn more and how to enable them.  How to Make The Most of Survey123 Data: If you’re collecting data with Esri’s Survey 123, check out this blog post to learn how to integrate with other platforms and utilize your collected data.  TrainingIf the FME World Tour sparks your FME interest and you’d like to learn more, check out the Getting Started with the FME Platform free training course on May 26th at 10am PDT. This course features a whole new scenario for both FME Deskt

I am capable to use the wmts reader with 1 zoomlevel, but I want to use multiple zoomlevels. is there a way to do this?

I simply want to calculate the difference between two numerical values. (In this case elevation taken as an attribute)I want to add a new attribute with this information and thus sing the AttributeManager. My expression is as follow@Value(_elevation)-@Value(cover_z)But it come out as 1.87-3.14 in the new attribute. How do I make it actually subtract?I found that _elevation had comma as delimeter whilst cover_z had period as delimiter. I have tried to find out what datatype FME is interpreting the fields but there are no way of finding if FME see it as string or float?I did however try to wrap each attriubute in @int8(<float>) to cast it to numeric, that did not work.I used string replaces and got the to use the same delimiter, but that did not work either?I just want to do a simple subtraction between values... any advice?

Hello. I'm trying to convert Sketchup files to CityGML, i've been following this tutorial: https://www.youtube.com/watch?v=1_eHzACY_RA I'm very new to FME and CityGML in general, butI've managed to convert Shapefiles to CityGML using a similar workflow. The skp files does not contain any attributes, and only consists of polygons. I run the sketchup file through a AttributeCreator to create a gml_id -> CityGMLGeometrySetter (od2MultiSurface) -> CityGML Writer (Buildings - Automatic User Attributes): If I inspect the CityGMLGeometrySetter I can see the 3D models in the Graphics tab, but it dissapears in the Writer. Am I doing something obviosly wrong? Why is the geometry not being loaded in the CityGML writer? Any help or pointers to tutorials explaining some basics that I might be missing is appreciated. I can also upload my workspace and files if that helps. Robin

Hi, I have created a custom projection file and put it in User -> Document-> FME -> CoordinateSystemsI have restarted my laptop. It does not appear in the gallery.I created it with a text editor. Am I putting it in the correct location for FME 2020?Is there a log somewhere to tell be if it has been read or there is an error in the file?Do I need the backslash on the end of each line? I was hoping to use the online tool to create the projection but I wanted to base the projection on GDA2020 , There does not appear to be a Datum to reference for 2020 in the dropdown in the online tool. Any assistance welcomed,Ian Hamilton

Hello,I have 100 pairs of (Rasters, corresponding shapefiles). How can I proceed to clip each one using its corresponding SHP, all pairs in one batch process ?Thank you very much !

Hi i am relatively new FME user. i am trying to complete a task but any path i pick i crash on a wall. I have an SDE drive with feature classes and table. Each feature class record has a primary key which is linked to my tables through a foreign key field. I need to know who many times a primary key value is found in my tables, create a new feature class and give in separate fields named (1st visit, second visit etc) some information about the table the record was found.What is the best path and how to get there.

I installed FME 2021.0.1 Server into a ubuntu 20.04 server (AWS EC2 instance).The installation has been successfully done, I ran "/opt/fmeserver/Server/startServer.sh" to start the FME Server instance, then performed initial settings including licensing and so on. Then, I stopped the instance with "/opt/fmeserver/Server/stopServer.sh", and the following messages were shown on the console.Stopping FME Engines...Stopping FME Core...Stopping Web Socket Server...Stopping Cleanup Service...Using CATALINA_BASE:  /opt/fmeserver/Utilities/tomcatUsing CATALINA_HOME:  /opt/fmeserver/Utilities/tomcatUsing CATALINA_TMPDIR: /opt/fmeserver/Utilities/tomcat/tempUsing JRE_HOME:    /opt/fmeserver/Utilities/jreUsing CLASSPATH:   /opt/fmeserver/Utilities/tomcat/bin/bootstrap.jar:/opt/fmeserver/Utilities/tomcat/bin/tomcat-juli.jar Using CATALINA_OPTS:Using CATALINA_PID:  /var/run/catalina.pid$CATALINA_PID was set but the specified file does not exist. Is Tomcat running? Stop aborted.It seems that the Appl

Hi,is it possible to loop through a FeatureJoiner? I created a custom transformer and I activated the setting to allow blocking transformers. My goal is to remove the first 3 rows and the connected IDs in the rows further down.2 Screenshots (hopefully) help to understand the problem).Thanks!