General

I have a gazillion zip files with shapefiles and their sidecarts. I want to generate a list with the shapefile name and CRS. Attempts so far: Use a reader, specify shp, read the zips: doesn't work, FME doesn't know the systems and CoordinateSystemExtractor returns almost nothing The system is named in the prj, so I could extract it with the Python caller: nope, you can't specify prj in the reader, so good luck reading prj from the zip. Extract the zips creating a mess (at this point I am already better off using plain Python), ctrl+f prj and load them as text, then try to expose the fme_basename with the AttributeExposer: FME doesn't show it (if I expose the fme_basename right in the reader, in "Format attributes", it does show it however but that's not what I want) storm off to the forums <-- you are here So is there a sane way to do thi

Nice to meet you all. I appreciate your help.I could write the excel file with fme_dataset when I generated the workspace immediately. I could find fme_dataset in the user attributes.However, when i reopened .fmw, the fme_dataset in user attributes disappeared and could not write the field into excel.Besides, fme_dataset could not be imported to user attributes and fme_dataset00 would be imported automatically instead.

I got a feature reader that reads in excel data. If data exists i create points from that data. If data doesn't exist i need to create a point myself based on center of a polygon with "centerpointreplacer" transformer. How can I chose flow based on that scenario? If I can create points from excel then I dont want the centerpointreplacer to run.

How to access a zip file from an FTP site that has their zip files embedded in a grid?  Before I used to access it by hitting the URL Link like this (hover over the link and copy the url):  http://www.abacusdatagraphics.com/abadata/<file_name.zip> But now, they have changed their site and have the zip files in a modern grid like shown on the screenshot below: If I hover over the zip file I want, it does not display the URL link anymore. I either click on the check box and click a download button or click directly on the file and it starts downloading.  So How can I tell FME to obtain this file now without having the URL link ?  When I tried accessing the zip file, I used the following form

Hi,  I want to create a published parameter where the user get to choose their own excelfile in the workspace as the reader. The writer is set to read a column with the header "Fastighet". But the input attribute can vary depending on how the user are writing it e.g. "Fastigheter" "fastighet" "Fastigheterna" and so on. So my first problem is that I really dont know how to set up the configuration for the publish parameter so the user can choose which excelfile they want. And secondly how do I make the script understand how to read the header name/column name and what sheet to choose.

Hi, I am migrating FME 2017 workspace to 2020 version. in startup script, python script is having import cx_Oracle statement. when i published the workspace on FME Server 2020 version, i get below error. Python Exception <ModuleNotFoundError>: No module named 'cx_Oracle' please share your ideas to fix it. 

For MODIS LAI images in an FME output folder, how do I select appropriate images based on date ranges? Image date is given in year + Julian day e.g. A2021123 for 2021 May 3?

Welcome one and all to the collection of daily recaps of the FME World Fair!Did you get lost in the funhouse and miss a presentation or are you too busy training to be a lion tamer to catch all the action? Check out a summarized play by play of each day! All presentations will be available on the Hubb event platform until June 30th, but will also be available on our website and Youtube channel.  Want to contribute to these recaps? We have presentations in multiple languages, we invite you to submit a recap in your native language. Daily Recaps:

I need to transform a CSV file where all the values for a given date\\time are in a single row:to multiple rows for a given date\\time:I tried to follow the example at https://community.safe.com/s/article/transpose-a-table-using-fme, but could never figure out how to get data combined the way it is needed.Any help you can provide is greatly appreciated!Lowell

Hi, i had no trouble installing the msi file for FME Desktop 2020 but i can´t install the .exe for the 2021 version, Windows 10 always returns an error saying it can´t find the file. Tried unblocking the file, tried saving with a smaller name, nothing worked. Any ideas?

 workbench  Log contains: 2021-05-07 12:07:41|  0.0| 0.0|INFORM|FME 2020.1.1.1 (20200817 - Build 20614 - WIN64)2021-05-07 12:07:41|  0.0| 0.0|INFORM|FME_HOME is 'C:\\FME\\FME-2020\\'2021-05-07 12:07:41|  0.0| 0.0|INFORM|FME Desktop Professional Edition (floating)2021-05-07 12:07:41|  0.0| 0.0|INFORM|Permanent License.2021-05-07 12:07:41|  0.0| 0.0|INFORM|Machine host name is: OPTW-2021-02442021-05-07 12:07:41|  0.0| 0.0|INFORM|START - ProcessID: 14748, peak process memory usage: 37980 kB, current process memory usage: 37980 kB2021-05-07 12:07:41|  0.0| 0.0|INFORM|FME Configuration: Command line arguments are `C:\\FME\\FME-2020\\fme.exe' `D:/3-calcul/17-geode4D/geotiff/2-fme\\wb-xlate-1620382050570_14140' `LOG_STANDARDOUT' `YES' `LogCountServerName' `{ac

FME process is getting stuck while processing a particular table

I would like to how this mapping works when SpatialFilter does spatial relationship between bases and candidate. As per "Pass Criteria: Pass Against One Filter. Each address point only needs to fall inside one polygon – not all of them." Lets take consider example if I have base as Parcel shape file and candidate as building centroid. When I am applying SpatialFilter with pass criteria as "Pass Against One Filter" then map one building centroid to one parcel if match to one but if match to more than one like vertically overlapping parcel or stacked parcel. then how its link to one parcel out of those ?  Overlapping means like sandwich layer.  Any help here ?

I have a hard time to get the XMLXQueryExtractor to do what I need. I wish it was more simple like JSON :-)I want to extract the value 2.2 from this sample:<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Leveringsinformatie xmlns="http://www.kadaster.nl/schemas/klic/leveringsinformatie/v20180418" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:gml="http://www.opengis.net/gml/3.2"> <version>2.2</version></Leveringsinformatie>The documentation states I need

Hi, I'm interested to learn more about FME. I went to download the free trial to check out the program but am met with a 404 error when I click on the FME Desktop download link on this page > https://www.safe.com/fme/trial/#desktop Any suggestions?

My installation of FME Desktop for Mac has been running more and more sluggish for some time. The interface is very slow to respond. With the latest 2021.0 it has become annoyingly slow. It is not the actual processing that is the issue, but the software itself. There is a delay in scrolling around the workspace, menues and transformers are slow to open, and so on. I tried to uninstall all traces of FME Desktop and reinstall, but it did not help.It is running on a new and maxed out Mac Mini so hardware should not be the issue. Looking at the stats there is lots of unused memory and procesing power. Any ideas on what I could do to speed up performance?

I have added MS SQL Spatial writer in FME DESKTOP 2020.1.1.1 and I can view the table attribute other than geometry attribute. Can you please help how to view/access the Geometry field in MS SQL Spatial Writer

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

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