FME Form

I have a coordinate system definition from a ESRI shape *.prj -file.It seems to be EPSG:3411, even if there are small differences in the definition. How can I create a costum coordinate system to use on both FME desktop and server?The tool her https://demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw does not work. I would appreciate any help with this:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/coordinate_sys_custom_about.htm Thanks. Here are the definitions: *.prj-filePROJCS["NSIDC_Sea_Ice_Polar_Stereographic_North",GEOGCS["GCS_Unspecified datum based upon the Hughes 1980 ellipsoid",DATUM["D_Hughes_1980",SPHEROID["Hughes_1980",6378273,298.279411123064]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Stereographic_North_Pole"],PARAMETER["standard_parallel_1",70],PARAMETER["central_meridian",-45],PARAMETER["false_

We are migrating data from Smallworld Electric Office 5.x data into ESRI Enterprise Geodatabase(SDE), while doing the process we came across one difficulty to export the data for the table named "Cable Existing Phase" which stores the relationship between main tables and unit tables in Smallworld native environment.We used the below parameters for the Smallworld readerReader: Smallworld 4/5Service: FMEExpose Internal Tables: On Please refer to the screenshot of the tables which we are getting after using the "Expose Internal Tables" as ON. Here we are missing a table called "eo_cable_exi_phase". Without the "Cable Existing Phase" table in the target environment, we can't build the relationships between feature classes. Is there any alternative approach or any other plugin (SBS) to resolve the issue     

Hi all,I have a set up FBX mesh tiles in one coordinate system (GDA94 MGA56) and need to reproject to another (BCSG02). When I try do that in FME, my 3D meshes get flattened to 2D images. What am I missing here? I am using the out of the box FBX reader & writer, and a reprojector transformer? Thank you!

I am having trouble understanding the documentation for the JSONUpdater tool. I've put together a simple workspace (attached) that demonstrates my partial success. I want to create a GeoJSON file from a shapefile. I can successfully do this with FeatureWriter. So far so good. See screenshots 1. and 2. below.  Now I want to add a key-value pair to the root of the JSON object that would identify the edition of the collection -- as shown in screenshot 3. So I include the JSONUpdater transformer. as pictured in Screenshot 4. below. I've tried a lot of options in this transformer but nothing I do has any effect on the json file. Can someone give me a hint? Screenshot 1: Workbench diagram Screenshot 2: FeatureWriter ParametersScreenshot 3: Geojson I get. Screenshot 4: GeoJSON I want.Screenshot 5: JSON Updater Parameters.

I am working with highway paths with point values and path lenths in kilometers.

After we upgraded to v1.0.0 we starting getting a ton of datatype errors.The Athena Query was working fine and writing results but the connector was choking on such things as decimal to int casts, and some random strange errors on cols we have never had issues with before. I started to resolve some of them by switching to bigint, but then another one in the stream would fail. Ugh. We have close to 75 Athena Mappings, so we reverted back to the previous version. Solved everything. If we had not, we would have to modify things like casts and decipher some other strange errors on many of those 75 mappngs. Anyone else having issues with v1.0.0?

In my example below I have two different attributs: the asset and group, group A being highest priority then B and then C. I would like to keep only 1-A, 2-B , 3-C and 4-A. How do you filter the other ones out?Asset - Group1 - A1 - B1 - C2 - B2 - C3 - C4 - A4 - C

Hi FME users! I have to read some ShapeFile from FTP. I use a FTPCaller to get all the files that I need, and then user a FeatureReader to read ShapeFile directly from FTP. I can get the geometry, but not the attributes...Do you know why if I read from FTP, no attributes are read but only geometry ?Thank you for your help!Francis M.

Is there a possibility to use group by on a NeighbourhoodPairFinder? I would like to find two closest points to a point (in the same file) and get the resulting lines to combine (in a effort to draw lines through a set of points).  The points are on either side of a road and they must not crisscross. I do not want to use the road centerline file (as spatial filter). I have an attribute (side of road) and would like to find the points based on this group by however, the NeighborhoodPaitFinder does not have this. Only the NeighborFinder has this.

Wondering if anyone can help - I've got a file geodatabase with coded-domain values, which is being updated by my writer with additional values and coded domains, following the instructions here: https://community.safe.com/s/article/working-with-geodatabase-domainsScenario 2: Writing to a new table using an existing domain This works absolutely fine with a geodatabase, however if I try to create a zipped version of it I hit the following error. 2021-06-28 11:24:49| 8.5| 0.3|INFORM|Created and connected to the ArcGIS 10.0 File Geodatabase at 'C:\\Users\\*\\AppData\\Local\\Temp\\wbrun_******\\fmetmp_8\\_auto_zip_dataset_******\\geodatabasename.gdb'2021-06-28 11:24:49| 8.5| 0.0|INFORM|Fast deletes enabled2021-06-28 11:24:49| 8.5| 0.0|ERROR |The attribute definition used is invalid for the non-existent domain 'Suitability'. For a coded value domain the proper syntax is 'coded_domain(domain_name:field_type:name_1:value_1: ... name_n:value_n)'. For a range domain

Hi All, I am trying to identify the orientation of a line (clockwise/anticlockwise or left/right) so that I can use Orientator transformer if a line has been drawn anti-clockwise. In older post this seems to be achieved by using Azimuth Calculator on FME Hub; however, this does not seem to be currently available. Is there any transformer I can use or workaround to achieve this? Thanks,Ana

I am trying to extract the orientation / angle / direction of a 2 node line. I cant believe there isn't a transformer that simply extracts the orientation of a line but I cant find one. Anyone found one? I want to be able to compare the orientation between two lines which are close to each other to determine if they are in the same (or similar) orentiation. Thanks

  i have tried to use intersector and topolgoy builder to identify nodes that intersectedbut i am not sure how could i recognize only the node of starting branch because some node has 3 overlaps and one at the end has only two overlaps .it means only two lines intersected with eachother ,So it will be hard to recognize by overlaps because At some branches to red point ,the lines intersected to eachother ,so it will have also 2 overlaps. each line has his own id but from the vertex in front of Grey Arrow has 2 or 3 Lines till reach End point .the main line has many connected linesi have tried with neighbor finder but my main problem how could i recognize the the vertex in front of Grey Arrows .Is there way to use neighbor finder and add Tester to stop at Vertex in front of Gray ArrowFME 2018 Thanks for help in Advance    

Hi all!I am trying to style the headers of my excel list, based on their name.With the Excel Styler I figured out how to style several values, using conditional values.However, what I want is to style headers, not values. How can I define header of column to style? Is it possible?Thanks in advance!

Hello,I’m trying to work with Cordex NetCDF files (Europe).The main, challenging, issue I’m facing is the rotation of coordinates used by Cordex.Googling and trying for some days I found a Proj4 string that seems to work. At least it works in a python caller with pyproj lib.  crsROT = CRS("+proj=ob_tran +o_proj=longlat +o_lon_p=-162 +o_lat_p=39.25 +lon_0=180 +to_meter=0.01745329")crs4326 = CRS('EPSG:4326')x=feature.getCoordinate(0)transformer = Transformer.from_crs(crs4326, crsROT)p1 = transformer.transform(x[1], x[0]) The process is understandably very slow. Some improvement can be applied working with list of coordinates, but I hope FME can provide some better standard solutions.I put the same Proj4 string in a PROJReprojector. Also considering that working with raster and then to clip the desired region is faster. The parameters I’m using are in the attached image.Unfortunately, the results are completely different. Both applying the transformer to vector or Raster

Hi, I installed FME Desktop 2021 and the Reader from Arcgis Portal can not generate the Token.   I generate the token externally and it is fine the user an password are fine. I tested with The GIS Administrator who has all privileges and I get the same result.  The connection running the FME a 2020.1 in another machine is fine.  How can make it work? Thanks.   

I have a list which has two elements {make, model}. I can receive multiple make, model in in this list. So, I can get values like:{make = Toyota, model =camry},{make = Toyota, model =Prius} and so on.I need to use these values create a sql in the format - select * from cars where (make=toyota and model = camry) or (make = toyota and model - Prius); How do I achieve this in FME? I dont know the no. of values that I will get in the list. Please advise, I am very new to FME

This is how I it get, with different tabs. And below is how I want it.

I have a table that has x and y coordinates. I am trying to write to an sde point feature class and it is failing. The error message is that 'line' features can't be put into a point feature class. Each record has one x and one y value. The log says there are 2 coordinates (which is why it's trying to make a line), but I have no idea why its seeing 2 x values for any record.  I exported as lines and got the correct number of lines of 0 length. They actually are in the right place in GIS. Light on details, but if anyone has hit this snag and recovered, I'd love to hear about it. There is NOTHING weird about this table. Sensitive data so I can't provide details. Actually, it is only some records - an identifiable set - the other records will create points. I see nothing different about the records that fme wants to turn into lines. Thank you,Randy McGregor

"4;30;4;20;SW,SE",,, Here is my attribute string, I want everything between the quotes to be split at the ; and the rest to be split at the commas. (There are no values held there in this example.) Please help. m

Original e57 is exported from Recap with appropriatecoordinate system assigned. Comes out in slices even if I'm just reading and writing file without any transformations. Another symptom is that the file size is drastically reduced upon export. I've just recently started getting into the world of FME, so most probably doing something fundamentally wrong.  Would appreciate any help.

I don't see any options for the MSWordStyler to layout the page to be Landscape instead of Portrait. Is there a way to make a page that I'm writing to a MS Word file to be Landscape, similar to the options in PDFPageFormatter?

Hello,I often use SQL creator and SQL executor to extract data of my dB.My select-queries always include the oracle geometry (stored in a SHAPE column).However, I noticed only in some cases the geometry is extracted in my workflow.I have, to this day, not been able to understand in which cases this works and in which it doesn't (I then add a feature merger to re-append the geometry to the features).Can someone explain this to me?Thank you

spreadsheets together and then insert them into the two inputs. Is there a way I can do this merge via FME by selecting all the worksheets I want merged? As currently it takes 1hour+ to do this manually! Also I would love to have the ability to extract multiple jpg image filepaths from multiple folders in one go. Is there a way i can just select a folder and say I want all jpg image filepaths extracted from all folders within? I have the ability to do this in Command Prompt but it takes a long time and I know FME would be much faster if it can do it. Any help would be very much appreciated, thank you

Dear FME community,I would like to know, if it is possible to convert a simple .obj-file into a .dwg-file. dwg is the standard for Autodesk AutoCAD. AutoCAD is not able to open .obj files.  Originally I had gml/ cityGML and .xyz-files which I converted to . obj-files. If there is no way to convert .obj directly into .dwg, maybe it is possible to convert gml/ cityGML and xyz-files into .dwg-files. I would be very happy if you could give me any hints.Thank you very much in advance!  Christian