General

the basic gist I've gotten from the forums and examples is:httpCaller>jsonFragmenter>jsonExtractor and I can make that work in a couple of simpler examples. My ignorance is showing when I get to a larger _response_body. I've attached an example json file that is the response for this specific API call, and I would just post my whole workbench but it includes an API key that I don't want to expose.Thanks in advance for any guidance you can provide. I'm basically trying to flatten the entire response into a table.

I published a FME Workspace with a FMEServerJobSubmitter in FME Server, I can run the FME Workspace and the FMEServerJobSubmitter starts the subsecuent FME Workspace, however if someone else in my team wants to run the same workspace, it fails with error "FMEServerJobSubmitter (ServerFactory): Failed to access FME Server web connection 'lopeztor FME Server'", I shared the repository where the FME Workspaces are and the web connection used.

Hi all,I want to replace in this:12/3 >> 12 A 313/2/5 >> 13 B 2 A 5Could you show me how to make regex? Thank you

hello everyoneI want to ask a question. Is there also a transform FME similar to the area solar radiation tool in arcgis?If so, can you tell me which one?Since I couldn't find such a transform, I added the area solar radiation function in the Arcgis Model builder and exported it as a python script. So I wanted to create a new transform but I couldn't succeed.can you help me with thisrsvp

In a dgn I have some itemtypes (Data Inspector), see attachment. When I try to expose them by the exposer in FME I can't read this fields...they stay empty.How can i read these fields? In the attachment my (start) workbench. Thanks a lot!

I am trying to install the custom transformer GeographicAreaCalculator which was downloaded to C:\\Users\\GUANA\\AppData\\Roaming\\Safe Software\\FME\\FME Store\\Transformers\\GeographicAreaCalculator/fmx on my FME desktop. I follow this article https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Coordinate_Systems/Workbench/Sharing_Custom_Resources.htm to publish my workspace while adding this fmx file. The publishing succeeded, but when running the workspace on the server, it stills say this custom transformer does not exist on the FME server.

I've recently been using a lot of rasterio and rasterstats in python which operate orders of magnitude faster on my PC for basic operations such as zonal statistics than my approach in FME:Clip rasters by polygons, then RasterStatisticsCalculator. Is there a more efficiently way of doing these sorts of operations?

In ArcGIS, we have been using the geodesic area calculations to calculate polygon areas in square kilometers from a geographic coordinate system such as WGS84. See http://dmahr.com/2015/07/geodesic-areas-arcmap-field-calculator/. I don't seem to find a similar reprojection in FME. is there an one that is closet?

I have a list which contains these values:nl restservicesMonumenten_raadplegenMapServer   nl restservicesBR_GroenstructuurplankaartMapServer  nl restservicesBR_GroenstructuurplankaartMapServer   nl restservicesBijzondere_BomenFeatureServer   nl restservicesBR_BAGFeatureServer  nl restservicesBR_BAGFeatureServer   nl restservicesVERG_TOEZOPLOSFeatureServer   nl restservicesVERG_TOEZOPLOSFeatureServer   nl restservicesVERG_TOEZOPLOSFeatureServer   nl restservicesVERG_TOEZOPLOSFeatureServer   nl restservicesPROJ_Mut_editFeatureServer   nl restservicesPROJ_Mut_editFeatureServer   nl restservicesPROJ_Mut_editFeatureServer   nl restservicesPROJ_Mut_editFeatureServer   nl restservicesPROJ_Mut_editFeatureServer In want to clean up this list by removing the duplicate strings. However, I want to keep the number of times each string occures. Finally, I want to get this list which stores after each string the number of occurence as shown in my first list: nl restservicesMonumenten_raadplegenMapSer

I have an exported KML from Google Maps Engine with different routes. I need to remove the points in FME without removing the routes. Is there a way I am missing?

I have multiple xml files, each with the same structure as shown below: <Metadata>   <MDI key="MAXIMUM">9</MDI>   <MDI key="MEAN">4.2018685725509</MDI>   <MDI key="MINIMUM">0</MDI>   <MDI key="STDDEV">2.3097856863945</MDI>  </Metadata>I want to create a table with using the MDI Keys as the column names, and the element values as the rows from all the xml files, as illustrated below. Can do a single file with AttributeTransposer, but could not figure out a simple way to load all the files together, feeling awkward with limited knowledge of FME XML transformers. Need some expert help here.  

Hi! I am trying to solve a task where I need to turn table rows into columns where their corresponding attribute values would be transposed altogehter. The essential moment is that there is n number of repeating rows (in my case every 3 rows) in the key column which would be layed out as attribute three (3) columns with respective attribute names as explained below: Original schema: ............................................... Wished result: I manage to transpose the table, however I encounter a set of challenges in finilizing formatting of the table:The hidden attributes cannot be dynamically exposed (of course), however setting them as User parameters for semiautomatic processing does not seem to work either as AttributeExposer picks up parameter name and not the value given by the user (ver. 2020.1).After table transposal attribute values that share the same name become separate columns (eg. Rad1(1), Rad1(2)...). I wonder what procedual steps I should follow in order to rearrange

After i run LineJoiner, i can see that data has been modified (number of objects has been reduced), but when i open the shapefile i QGIS, the lines are still segmented even though there are no gaps in between.  Altough it has joined some lines, but now all that are connected (sharing same vertexes) I have FME Workbench 2016.1 ​

I would like to further examine the results out of the coordinateExtractor transformer. Is it possible to write the output to a file? I can view the results in the Display Control panels.

Here you can see the complicated geometry, I want to cut it at the red arrow. Based on this line, that intersects the geometry: I tried this using a couple of methods, where the FME hub transformer PolygonCutter got the best result. However I did not get 2 features in the end, and the geometries where not exactly the same as the input. The only thing I want is just a simple cut on the place of the line, that splits the geometry in 2 pieces. So I can assing different values to both of them.

I have a line & point shapefiles, I want to create a one-to-many spatial join so that the line would get all the point attribute information which are present in its surroundings, i tried some methods but no proper result, can someone please suggest ?

Welcome to What’s Up Wednesday, your weekly FME.  WebinarsDo you want to be a data extraordinaire? You have until March 19th to apply to be a contestant on our newest online game show. Do you know everything about data and want to compete to win a $150 Amazon Gift Card? Apply now. The game show (webinar) will be on March 23rd at 8 am PDT. With the upcoming release of FME 2021, we have a couple of webinars to show you what we’ve been up to this past year. Unveiling FME 2021 - March 9th Scaling FME: What’s Possible Now and What’s Next - March 25th Introduction to Data Stream Processing - March 30th  FME World FairInterested in speaking at the FME World Fair in May? The deadline to submit your abstract is next Tuesday, March 9th.  Free TrainingNext week we will be hosting our free Getting Started with the FME Platform course. Sign up today.  On March 23rd, we will be hosting our free Esri Geodatabase and FME Desktop course.  BlogEver wonder what the difference between Geodatabase and Geos

Dear Experts,We have Smallworld 4.3 and I have installed FME 2020.2.3.0 (Build 20820 WIN32). I have installed Translator 4.3 and copied the sworldswaf dll and fmf in FME installation folder and metafile folders. FME is able to read the ds file but unable to extract the feature types. I have gone thru the link. As explained, I changed the dll file to 4.2.2 version and checked but result is same... I have attached screenshots for reference with FME and FMENOFACTORY services. Can some one suggest me if I'm missing anything... Thank you,Pratap

Hello I have a metadata json file that I would like to transform to xml.Is there a particular route using transformers to do this? I have tried importing the json with a reader the using a xml templater and then writing as an xml but the result is no then viewable in the FME data inspector. Any suggestions? Thank you

Picking any country from https://osm-boundaries.com/Map >download tick all_tags gives this in FMEHowever in attribute manger I can only see the 7 input attributesThe all_tags looks like thisWhat I'd like to do is extract the non "name" tags as unique attributes E.G. is_in, ISO3166-2, wikkidata etc. Some of the tags are like is_in:country : VALUEand keep the rest as a JSON string (keeping the values as is maintaining diacritics)Some features have more unique tags than others so my output PostGIS table will have all possible columns and any feature with out a particular tag should be a NULL string I can then write to a PostGIS database Can someone tell me how to extract the all_tags JSON string as described?

I am trying to create a 2D oriented bounding box around the point cloud of a roof with a boundingboxreplacer and the appropriate option, but the result is the same as a standard 2D bounding box. I expect an rotated bounding box. What am I doing wrong?

HiI want to know for all records with a certain project number whether certain other attributes are the same. For example, all the records with projectnumber A97652 must have the same startdate and owner, if ist not the same then i must change the one that's different. I think i need a transformer with a group by function. I have tried the matcher but it doesn't do exactly what i want. Does anyone know wich transformer i have to use? 

Hi, I have to do a SOAP request to an API inside a workspace and I have to use Digest Authentication.The URL is in HTTPS protocol, I have a "SOAPAction" header and a body with a text/xml Content-Type. Inside the HTTPCaller I checked the "Use Authentication" box and entered the right credentials.I also use Fiddler on the same machine to see which request is sent. So, my problem is that i get a 500 internal server error because "there is no body, SOAP XML message". It's weird cause i really have the specified body, but when i see it in Fiddler, there is indeed no body, there's just the headers. The thing is, when i use a Basic Authentication, the problem is not there, a body is present in the request... (of course the request is then rejected because of the wrong authentication though). What am I missing in the configuration of this transformer ? Thank you for your answers !

Hi, I have two CSV readers containing the same informations but with different range of value.  Let's say that I have something like this:Reader_1:[ATTRIBUTE_1](UINT8)[ATTRIBUTE_2](DOUBLE)And Reader_2:[ATTRIBUTE_1](UINT64)[ATTRIBUTE_2](DOUBLE)(FME has choosed the datatype automatically) Since both reader have the same attribute's name, I connect both reader's output to a "sorter" transformer.  And here, a weird thing happens, the sorter output ATTRIBUTE_1 as UINT8 (I expected that FME would choose the biggest datatype, not the smallest one). But some value are bigger than 255:Is that a miracle ?  Then I use a StatisticCalculator to find the max value of ATTRIBUTE_1 group by some other attributes and the output is, this time, limited to 255.  So why FME do not pick the biggest datatype ? How can a FME_UINT8 variable be bigger than 255 and what can I do to calculate my statistics correctly ? Of course I can manually change the ATTRIBUTE_1 datatype, but that does not explain that weird be