Best Answers

I have developed a python script to walk though directories picking dwg files that fit the pattern I want. I would like to add the script to a user parameter and pass/link the parameter to a reader source. For testing purposes I started with a simple script to return a single dwg, linked it to the reader source, and it failed with error...'Update Reader Failed'. My simple Python User Parameter scrips is as follows:----file = r'C:\\data\\dwgfoldertest\\Test1.dwg'return file-----Any pointers would be appreciated. If I get the simple test working, I'll move onto the more complex Python oswalk script which will return a string of dwgs separated with commas, so if you have any tips on how FME will behave with that next step, that would be appreciated also. Thank you,Tyler FME(R) 2020.1.2.0 (20200902 - Build 20620 - WIN64)

I have 210 rasters, I am trying to create one mosaic for every 10 of them. The titles will be something like:raster_0_10raster_10_20raster_20_30I created a custom transformer to loop the rasters. There are two variable called "from" and "to". I increase them with 10 for the failed data. Whatever I do, either it keeps updating the first raster or it fails.I attached the workbench, unfourtunately I am not able to give a sample data but I provided the CSV file of the namings. Thanks,Caner 

I have countless roof surfaces as MultiPatches from which I would like to determine the highest point (x,y,z) using FME. I can determine the highest Z-value of a roof surface without any problems, but I always get only the Z-value and not the corresponding X and Y coordinates. One possibility would be to calculate a small elevation model for each roof and then use the X and Y coordinates from the cell with the highest Z value, but I would like to avoid this diversions if possible. Is there another more efficient way in FME to determine the highest point (X,Y,Z) of a multi-patch area?

I have multiple (210) jp2 files, FME reads them but the extents seems the same for all of them. Therefore they sit top of each other. If I check the raster files in ArcGIS Pro, they are next to each other and extents are different.The coordinate system is not in the list of FME. I created a custom one using the tool below.https://demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw? The coordinate system is ESRI:102717.https://epsg.io/102717 One warning that I am getting when I run the workbench is JPEG2000 reader: `<MYLOCALPATH>\\w_10890984_12_17100_4bd_2017.aux' exists but could not be opened. File contents may be invalid, or the file format may not be supported. 

HiWant to delete all rows from my SQL table. Created the following FeatureWriter to set to delete:However, ran it in my workbench and the database records are still not deleted. Anything that I did wrong? Thanks.

Hi there,I use FME Desktop to bulk-load to elasticsearch. I'm building a new application based on elasticsearch 7.1.1 but mapping types were removed ahead of this version;https://www.elastic.co/guide/en/elasticsearch/reference/current/removal-of-types.htmlAre there plans to update the reader/writer to be compatible with elasticsearch 7?Thanks,Campbell

Hi!Since few time I have an error at the begining of the translation.PDF Reader: Failed to open document "xxx\\*.pdf"because it does not exist or because the reader does not have permission to access the fileI replace the path by "xxx" for this post.The path is good and I have permission because when I choose just 1 file manually it works. The problem seems to come to the relative path with the " * ".I don't see that is the problem.Can you help me? Thanks!

We get the error "Can't connect to HTTPS URL because the SSL module is not available." when running a workspace on FME Server but the same workspace run from FME Desktop is okay. FME Desktop 2020.2.1.0 (20201130 - Build 20806 - WIN64)FME Server 2020.2 Build 20787 - win64 ```2021-1-26 19:19:35 | ArcGIS Feature Service Reader: Requesting metadata for Feature Service at 'http://mapservices.gov.yk.ca/arcgis/rest/services/GeoYukon/GY_Biophysical/MapServer'2021-1-26 19:19:48 | ArcGIS Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='mapservices.gov.yk.ca', port=443): Max retries exceeded with url: /arcgis/rest/services/GeoYukon/GY_Biophysical/MapServer?f=json (Caused by SSLError("Can't connect to HTTPS URL because the SSL module is not available."))' ```Digging around on Stack Overflow and similar s

I have simple workspace doing a point densification and generalization on polygons: I have three published parameters:the input (Shapefile), the output directory and the output name (Shapefile). I call it from a batch file (it is replacing another tool in a longer chain of commands) like this:fme workspace.fmw  --DestDataset_SHAPEFILE z:/ --ftp_feature_type_name_exp bThis works as intended, taking the default input (z:/a.shp) and writing to both directory and filename I define in the parameters (z:/b.shp)fme workspace.fmw  --SourceDataset_SHAPEFILE z:/b.shp --DestDataset_SHAPEFILE z:/ --ftp_feature_type_name_exp cUsing the --SourceDataset_SHAPEFILE parameter does not work. There is no error message, but it seems the workbench either does nothing or falls back to the default values for all parameters. How can I call a workspace with different input/output data, from console? These are purely geometric operations, so I don't think schema should be an issue (it is the same in these exampl

I try to recreate a raster using FME which was originally produced using GlobalMapper. The input is a pointcloud, I use the NumericRasterizer and then send it to the GeoTIFF FeatureWriter. We visualize the result in ArcMap 10.7. We also have contours generated. When I zoom in to a contour line it looks like the new raster is slightly shifted: GlobalMapperFMEI did some googling and tried different settings using the RasterCellOriginSetter but this does not seem to change anything. What can I do to fix this? Update: I can't reproduce this issue in QGIS so it looks like it is not correctly interpreted by ArcMap.

Has anybody tried reading data from a PI Historian database with FME?I know it has both ODBC and JDBC connection options.If so, could you share some knowledge?Thanks, Erik Jan

ProblemThe problems are caused by the underlying functionality of how FME Core downloads the email attachment and with the default FME Server Cleanup setup One of the functionalities that will be broken with this, is, for example, Backing up the FME Server. Resulting in a `COM.safe.fmeserver.configuration.migration.FMEConfigurationException: java.io.FileNotFoundException:` for the attachment. This is reproduced with the following steps:Create an Automation Trigger of an email (SMTP)Define a custom "Download Attachments To (optional)" path. Preferable something that is not covered by the default FME Cleanup, like`$(FME_SHAREDRESOURCE_DATA)/custom/mail/received/`Make sure this is triggered and the attachment is downloaded to the locationNotice that the FME Server seem to create symlinks in `$(FME_SHAREDRESOURCE_DATA)/custom/mail/received/` which are linking to the default mail attachment resource `$(FME_SHAREDRESOURCE_SYSTEM)temp/emailattachments`Wait for the default "Dele

Hi, I have two datsets which I want to combine using a key. One dataset contains busisness names of companies and the other dataset contains more or less the samen names but there are smalll differences in some cases. I want to join both datsets on the keys which are most equal to each other.  For example: Dataset A:Amsterdam Cars B.V.Rotterdam Cars Deluxe Dataset B:Amsterdam CarsRotterdam Deluxe Cars Any ideas how to solve this issue? Maybe something with the FuzzyStringComparer?

I am trying to download all rasters from a recent USGS LiDAR Project. The files can be found here: The National Map (prd-tnm.s3.amazonaws.com) Is there way using FME to download all the files in this folder to my local machine?

I have 3 shapefiles and and 1 spreadsheet I need to import into 1 PostgreSQL/PostGIS table ADM1_area (Shapefile) is linked to the spreadsheet via a name column however due to differences in spellings this may need manual intervention How Do I bring up both the Shapefile name column and the spreadsheet name column and where necessary manually map the values across the two? for instanceMyPlace = My Place (Or one source might have diacritics ) This is probably a manual process as REGEX would take to long The preferred name spelling will then map to the name column in PG table and all other spelling concatenate to a list in alt_names column  The other 2 shapfiles are ADM2_area and ADM2_pointthese form 1 database row that has both geometry and point_geometry columns and are linked to the ADM1_area row via ADM1_name column this needs to be the same name used before and may need intervention When I created the PostGIS connection I could only see how to had 1 geometry column not two? T

I cannot get the ExcelWriter to use the ExcelStyler's formatting. I have found a demo worksheet in another question which works fine. I have deleted the writer and replaced it with my own (I think identical) writer, but it's not working and I have no idea why! I have attached both worksheets. If someone could point out the difference between the two I would be very grateful. I've tried a diff checker against the XML code in the files, but nothing is jumping out at me.

I'm getting confused when writing to a gdb with regard to feature operation parameters. The options are Insert, Update, Delete, and fme_db_operation. What I am looking to do is write only changes. Add rows if required, subtract rows if required, modify rows if required, and no modifications to unchanged rows. In other words, compare tables, then update only changes. It is not clear to me in the documentation that any one parameter does this. Let me know. Thank you, TylerFME Workbench 2020.2

So in the Coordinate System Gallery, one can see what units that coordinate system uses (ex: foot, meter, etc.). I need to access the unit of the picked system programatically so I can perform conversions if needed, but I don't see this information available as a feature attribute or property. Is this possible in any way, perhaps with some custom python? Thanks.

Hello Safers,One of our client wish to use FME to do a search inside all the documents in their sharepoint site.Here is an example of the search:  With Microsoft Search REST API, I can login to sharepoint then run this query in my browser: https://CLIENTDOMAIN.sharepoint.com/_api/search/query?querytext=%27195400002108700%27 I then obtain the same results in XML format: I wish to obtain the search’s result with FME. I tried HTTPCaller with Sharepoint Microsoft Authentication and it is not working. It said Unauthorized I also tried to use all other type of login (Basic, NTLM, etc) , with the same results. Can you tell me if something like what I want to accomplish is doable, or FME is limited right now to do something like this? I also tried with SharedPointOnlineConnector, but that only give do listing of the items, I cant make any queries.Thanks

I have a folder containing hundreds of tif and related extension files e.g. NS26.tif, NS26.aux and NS26.rrd. I want to rename them adding a suffix i.e. NS26_c.tif, NS26_c.aux etc. I can manage this using filecopy to the existing folder but because the filename has changed overwrite won't work so I end up with new and old in same folder. Any suggestions?

A dataset of 900 records contains a string attribute. This string varies in length and contains always a X- and Y-coordinate. Example:":5.781699137962022,"rijksdriehoekX":181934.095,"rijksdriehoekY":474580.092,"rijksdriehoekZ":0 I just want to get the part in bold and created a Regex to select this part. My idea is to replace the complete string and just keep the string part with the coordinates (bold part).  My Regex: rijksdriehoekX":[0-9]{6}.[0-9]{3},"rijksdriehoekY":[0-9]{6}.[0-9]{3}Any ideas how to solve this issue? 

Hi,I am trying to set up an FME Server App that accepts multiple spatial file types (json, kml, shapefile) as a "file drop" from the non-FME user, to then spatial filter against hundreds of "footprints", to then email the user back a email with the zipped "footprints".I am having an issue creating a workspace with multiple feature readers that, when published, doesn't end with a fatal error because a single reader cant read the input file. My workspace starts with a creator going to the multiple feature readers (kml, json, shapefile), they all go into a spatial filter against the "footprints". The Feature readers all have a Published Parameter for the file to be read, the workspace parameter is to "Continue Translation" for rejected features.Thanks! FME(R) 2020.0.3.0 (20200605 - Build 20252 - WIN64)FME Server 2020.0.0.1 Build 20202 - win64

I am using a 'PythonCreator' and 'PythonCaller' transformer to create a series of SQL select statements. The latter are used in a 'SQL Executor' transformer to read many features from an oracle db. Eventually, these features have to be written to .json files.   Because I initially used the PythonCreator, all the feature have 'fme_feature_type' set to 'PythonCreator'. When using the GEOJSON writer in FME Desktop 2017.0 (build 17259, 64 bit) , this results in an error message: 'Unknown feature type 'PythonCreator' passed to the JSON writer'. Other writers (SDF, shape, excel, etc.) work fine.If I use an attribute manager to set the 'fme_feature_type' attribute to other values, the writer works fine.   Could anyone explain why the writer has problems with an fme_feature_type named PythonCreator? I could not find an answer in the documentation on the GEOJSON writer; so that is why I am asking it on this platform.

Hi, I have extracted the list in JSON file to an excel file using ListExploder. However the result didn't come out as expected: Any suggestions on which transformer can I use to get the expected result as attached: Thank you in advance.

HiAdded Reader to extract from Access db source and then insert into destination SQL db (right hand side) and it worked fine:Wanted to add a writer to delete all db records (on the far left) before the reader. However, unable to connect that writer to the reader. Any advice on how can I execute that Delete Writer before the Reader? Thanks.