General

This is needed to send a zip file Base coded with a Soap request. Someone ?? Thanks Nick

Hi Community, I just wanted to know that for a pipe geometry co-ordianates...council ideally collect points for particular pipe as a polyline (meaning having more than two co-ordinates for a line).My Question is how to collect co-ordinates of starting and end point of a specific line out of given all co-ordinates defining a polyline?

Hello,I've created a process that executes a SQL query that I exportin a CSV file with a dynamic filename. "CANCEL_" + date of execution + ".csv" That part works fine. But I want to send the file by email with the transformer EMAILER. I can't figure out how to manage the dynamic filename. Everything I tried fail :( I've put the filename directly in the SQL query with the field name "fichier", that I retrieve in a variable.  Any idea?my error message Thanks a lot !

Hi, I tried to load data to existing dataset in BigQuery, but it always failed (said that my user account doesn't have bigquery.jobs.create permission, which actually I have the owner access). I have follow the step from https://community.safe.com/s/article/loading-a-single-file-to-bigquery Could someone help me on this?Thanks  

Hi I have a near infrared jpg. In the data inspector it says Band 0 (GRAY8). When I look at the NDVI calculator I see two ports (Red, Infrared). I've seen somebody used something like this: I don't know how to configure the testfilters so they give the correct output.  Can somebody tell me if that's the way to go and if so how to configure the testfilters?    

I'm adding an attribute to the output ports on the ListSearcher transformer, and it fails. The new attribute is created on the features, but the value became <missing>. Doing the same on other transformers works.  Have anyone else experienced this?(I'm on FMEdesktop build 20817)

Hi I would like to mosaic some geotifs togheter to make a DTM from a larger area. Some of the geotif tiles have a min of -9999. If you load the tile in QGIS it's completely blank. If you check the rastervalue's they give the correct height. So it's only cosmetic, the data is ok.  You can adjust the min in QGIS, resulting in a much better result.  I tried to change the min of the geotifs with a negative min in FME.  I use the rasterbandminmaxextractor followed by a simple tester. So far it works, but now I want to change the min to 0.  I used the attributemanager and I used the rastercellvaluereplacer. They both don't work. I've also tried the rasterinterpretationcoercer a bit, but it changed the values.  How should I fix this ?  

I have many tables in my ESRI SDE, within most of these tables they contain an Asset_ID, this colmn name varies, it could be many things including AID, AssetID, ASSETID, Asset_ID etc. I need to extract all rows from all tables where the Asset_ID field is present, and has been populated, then push the row into a GeoPackage. That part I am OK with, I just have never worked with the first part, iterating over n number of tables, searching for a varying field name. Can anyone provide any comments or samples to get me off the ground here? I greatly appreciate you taking the time. Kind regards, Ben

How can I turn off the alphabetical sorting of attribute names using the import feature of the attribute creator? There's a "Sorted" option in the wizard but it doesn't seem to do anything?

I was looking into connecting directly SQL server to arcgis and ran into issues when using the update feature in the writer's field, can this be fixed? as when I have it on update I get number of errors, I have found a work around that issue by setting up insert and truncate features instead of update but this is taking too long, any idea why I the update feature is causing issues? and can it be fixed?

As output from a workbench I get a table with some rows of data. This data is send to me via the Emailer.  I created a server app with this workbench and now want to get the information, which is send by the Emailer, directly as result in the Server app as a table (see attached image). The content of this table depends on the value of a Published Parameter. I created an image which shows the idea I have in mind:Any ideas?

Hi I just made a jpeg2000, but I can't seem to open it in Photoshop or Gimp. Photoshop says that it can't parse the file. Gimp says it can't decode the file.  yet I can easily open it in Qgis . Is there something I'm missing or is this normal? 

I have run into some quirky polygons and wanted to see how many nodes/points they consist of. In SQL Server, I can do:Select [SHAPE].STNumPoints()FROM <mytable>where id = 'abc' -- result: 45 When I use the CoordExtractor, I'm prompted to specify the indices of x-coordinates and y-coordinates I want to extract, or I can choose "All Coordinates' and then later extract those I'd like to take a look at. But it turns out, I can ask for index 100,000, and FME will return something that looks like coordinates. Am I not doing this right, or misinterpreting the nature of these indices? 

is there a way when using the AreaOnAreaoOverlayer to overlay by date, where it will drop areas if it does not overlay in the following ascending date?

Step right up, and explore this fair-themed edition of What’s Up Wednesday! FME World FairHave you heard, the FME World Fair will be coming to you live through your computer screens May 4 - 14th, 2021. We’ve decided to pack up our World Tour and bring all of our international and local presentations together. Best of all it’s free! Check out the teaser video.  Interested in presenting? We’d love for you to submit an abstract. We want to hear customer stories from around the world. Your presentation doesn’t have to be in English, see the list of Partner events on the abstract page to see all the available languages. You have until March 9th, to submit an abstract. Need Inspiration? See all of our past presentations from previous FME World Tours and FME User Conferences.  FME CloudTake a Ride on FME Cloud. You can now launch instances out of Stockholm, Sweden!  BlogImagine if mirror houses were made of hexagons instead of squares, it would be more confusing but yet more satisfying. If yo

Followed the example provided by @jovitaatsafe​, and the workflow appears to be exactly what I need to do with my data, where I have a number of points in different areas, and want to aggregate by count into hexagons.  The hexagons are also showing up in the ocean near Africa, so I'm guessing this is a map projection issue? But not sure where to resolve it exactly.

I've been sent some data - a simplified example would be like the below with XY coordinate points each with an attribute to say whether that location was covered or not. I need to create lines from these points, but I only want lines from the points that are 'Yes' covered, and each section of consecutive points that are 'Yes' covered needs to be a different line. Logically if I could ask the questions... "Are you a 'Yes' point?" and "Is the point before/after you a 'No' point?" I could find the first and last points of each line but I don't know how to do this in FME.Does anyone have any solutions or pointers?Thanks

Hi, does anyone know if Sketchup Writer is compatible with Sketchup version 2020? /Thanks

Hello FME Users,I have Road Dual carriage way do anyone have idea how to identify or flag Right and left side /part of Dual carriage way how It can be accomplish ?

Hello everyone,I want to download files from USGS. In my workspace I have a Creator connected to HTTPCaller.My HTTPCaller looks like this: When I Run the workspace I get error 'Error running translation'.When I paste this URL to browser and click enter, after about two minutes file starts download but I can't use this URL in HTTPCaller.Any ideas ?CheersAnn 

Hi Guys,I'm wondering why I cant use $(FME_HOME) System Parameter on DGN Writer parameter for path to seed and cell files? When I use this parameter I'm presented with an input error and can't run the workspace. Setting up correct path to seed and cell files is mandatory to any workspace built upon this file format. But it can't hold true that any client is requested to set up these FME specific path!?   Looking forward to hearing any suggestions from you! Thanks Whkarto

Hello! I used this instruction to create a web connection to our ArcGIS Portal: https://community.safe.com/s/question/0D54Q000080hBUjSAM/how-to-create-an-fme-web-connection-for-esri-arcgis-portal-feature-service-oauth-20 There is no problem using the ArcGIS Portal reader for reading the branched enabled service. The problem is when I try to use the ArcGIS Portal writer to write to the same service. I get the following error: ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was 'none' and the message was: 'The operation is not supported by this implementation.'. Details: ''A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsArcGIS Portal Feature Service Writer: Reconciling Branch Version 'sde.DEFAULT' against 'sde.DEFAULT'ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server

Hi all, I have a workbench which works fine using FME Desktop. The aim workbench initially is to download two excel files and put them in a folder. Then workbench takes those files and converts information. Main transformer being used is sharepointonlineconnector When attempting to use FME server, it is strangely is trying to create a folder from the workbench but the folder already exists and is mapped.  "Could not Create Folder" - Message Are there any ideas on what could be reason for this? I do think it is setup correctly but unsure on why it is not sticking to just downloading the files to the folder instead of attempting to create a new folder.  

Hi all,​I recently converted data in fme from dgn to osgb.​I then published to postgres table. I can see all the attributes including the shape column. I can see numbers and data in each field and each row. ​The weird part of this now is, I go to Arcgis Pro and try to view data. Majority of dataset 1000 records work fine but there is like 50 rows which when I click zoom in, it does not have the polyline to display even though all the attributes have been generated including shape column.​ I checked FME inspector and everything works fine I tried in geodatabase it works fine but just issue is with postgis.​Any idea on what this issue could be would be huge help. I also did not generate srid for postgres if it helps.​​​​

Hi, Think I put this in the wrong location, moving from Authoring to Desktop. I'm having a difficult time getting global variables to both set and retrieve. I've got a table that is updated with deltas from another table. I need to get the last used number of a unique id in the updated table so that I can create the next sequential number and append the unique id to the one being appended. I'm already using one set of variables (both setter and retriever) for determining when the last modification of the script log file was done in order to grab only the latest ones (this is ultimately going to be a triggered script in FME Server) - this part is working well and I'm getting the latest additions to the table for append.  The part giving me difficulties: Need to read the appendee table to get the max number of an id, ABC2021-00##; where 00## is the max number assigned (can't use count since there could be some deleted items - purposely tested this). Getting max using