General

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

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.   

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?

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

Thank you very much in advance for your help :) with kind regardsChristian Lendl

When I add a Reader in FME Workbench 2019.2, I cannot connect to a PostgreSQL FDW (Foreign Data Wrapper). I can select (check) the FDW schema, but I cannot open the list of tables. (The FDW is in a PostgreSQL table and I can access the PostgreSQL schemas just fine.) DataGrip can open the FDW schema and its tables just fine using the exact same connection (host, database, username, and password). There seems to be almost nothing in Google about FME and PostgreSQL FDW. Is it impossible, or is it just too obvious for me to figure out?

Hi I want to combine a folder of geotiffs satellite imagery files together in a row into a single geotiff. I dont need the coordinate sys of the geotiff output, just the pixels and its value to be stitched together. Basically trying to do the same as this question https://stackoverflow.com/questions/30227466/combine-several-images-horizontally-with-pythonTried the solutions posted there but the python pillow library does not seem to read geotifsAnyone have an ideas on how to do this?Thanks

I have attachments stored as blobs in an Esri File Geodatabase that I am using RasterReplacer to save them as JPGs. When viewing the photos through ArcMap the orientation is correct. However once they run through FME and RasterReplacer saves them as JPGs, some of them are up side down. Anybody have any thoughts on this?

I have a user parameter configured as follows:My user selects about 200MB worth of JPG photos to upload and have processed. In doing so, he gets the following error: This is a user that is working in the field and likely has poor connection quality. However, there is a lot of data to upload. If I attempt an upload with OneDrive or a similar service, it will typically recover/resume an upload as connection issues occur. I do not know if connection issues are what is happening here because the error tells him nothing.  Is there a way to dig deeper into the reason behind this issue? Because the workspace never gets a chance to run, I don't know how to diagnose this or develop around it. If my assumption

When I clip a Line with the clipper transformer I get a multipart line with one common length, and I need to split It in singlepart line features and for each line a length.

Hello I do an excel with FME and I want to add a title to my summary table. How can I do with FME ? Thank you

Hi, I am using FME Desktop 2020.0 and as soon as I try to write into a FGDB, FME crashes with this error meassage: "An error occurred while attempting to create the feature class 'unmerged_transport'. The error number from ArcObjects is: '-2147024893'. The error message from ArcObjects is: {FDO error: -2147024893} A fatal error has occurred. Check the logfile above for details" Same workbenches working fine on other PCs. We installed FME and ArcGIS new on my PC but the problem ist still there. Any suggestions? Thanks in advance

Hi. I have a polygon dataset showing planning applications. I want to find out if any of the polygons intersect others in the same feature class. I have tried feeing the data into the are on area overlayer twice and it has come up with some results however, it says in the instructions there should be no self intersections within the layer, so I think I need a different transformer Has anyone got any suggestions please?

I created an FME server App that runs a workspace. The workspace generates a Zip file but I could not work out how to set it as an output so I could define it as the download content. As a work around I put in a FileCopy writer to simply make a copy of the zip file as that transformer is recognised as an output when publishing to the server. It has worked once as far as I can tell but in most cases when I run it I just get 'Completed' but no download link. It is odd because there are no errors in the log when I look at the completed process. How do I ensure that a Server App returns an error (if appropriate) or ensure the Download URL is always shown?

Hi I am new to FME, and just trying to create a simple flow where I take to inpust from ms sql database and store the result in another ms sql database.The qyery for the jin of these to look like (pseudo code) select ....FROM dbo.GLWHERE COMPANY = 1 AND ACCOUNTING_YEAR = 2021 AND TEXT <> 'Project'AND CODE_f IN (SELECT PROJECT_ID FROM dbo.PROJECT WHERE COMPANY = 1 AND PROJECT_GROUP IN (10,30)) Running in query editor I get the correct result.But when trying to use FME deskltop and transformer as tester and featurejoiner I get a 2x result.So what transformer should I use ? Thanks for your help Dan

Hello! Thanks for joining us for another edition of What’s Up Wednesday.  OGC and FME 2021FME 2021 is now certified as OGC compliant for 4 key standards: GML, KML, Geopackage, and GeoTIFF! We are also registered for having support for over a dozen more formats. If you are interested in the full list, see the OGC website.  FME TrainingIf you’re looking for something to do in your free time this summer, check out a free live online FME course! If you’d like to learn something on your own time check out a recorded course or the new FME Academy

Hi. I have two directory with lots of PDF. I want to merge the PDF with the same name of each folder. Also the name is little bit different between the folder:Ex: folder a: Carte_PZ1_juin2020Folder 2: Log_sondage_PZ1_mai2021 Can you help me.Thank you :) 

The upgrade to FME Desktop 2021.0.3 Build 21326 was carried out yesterday morning (Desktop / Server)Issue 1 I have a workspace which used to work until the upgrade.Simply put, a downloaded CSV file is read then written into a truncated Postgis table.This table is responsible for the functioning of this site including its contents as FME generated. (https://molevalley.cloudmappin.com/mmv/) The scheduled workflow reported that it was successful through an e-mail notification. However when I checked the site this morning, the address lookup failed to work therefore no one could use the site. During investigation I realised that the table was empty. (Truncated but no data)  Took a closer look and saw t

We want to use Snakegrid projector transformer in FME Server, How we can use it. Snakegrid is coming with its licences , and its working at FME desktop application. But we have workbench which is having Snakegrid projector ,we want to publish this wokrbench on FMe Server.

I have a network of lines. I would like to check if there are overlapping lines or portions of line in said network. Which transformer should I use?

Hi list.In the curiosity department, I have a workspace, that seems to finish , but misses some data, adding a small FATAL error message "Expression: false": What triggers this ???

I have a list of permits joined to address points. About 100k points after that join. I want to join those 100k to the parcels which have about 40k so there would be some parcels that are 'stacked' and have 5 rows. I'm trying SpatialFilter, SpatialRelator and PointOnAreaOverlayer and not having any luck. I'm using 2021.0 desktop.

Hi all, I have a data set with a start_date column and an end_date column. What I need to do is determine which date ranges overlap, similar to this: https://www.get-digital-help.com/find-overlapping-date-ranges-in-excel/" alt="http://https://www.get-digital-help.com/find-overlapping-date-ranges-in-excel/ I am fairly new to FME so I apologise in advance!

i could read all atributes and create a table from a geometry instance. i know yath i could use "geometrytraitextractor" but i put each name to expose each one.but i need expose all, and i dont know how do that