FME Form

Hi all,I have issues using FeatureReader transformer when reading all .xlsx files from folder. During execution of the entire workbench it will load just couple of them. But when I use Run From This (from FeatureReader) it will load all files.I'm using FME Desktop 2022.2 version. Thanks,Bogdan

I have this block of XML. <?xml version="1.0" encoding="UTF-16"?><place place_id="11703">  <gas_price type="regular">22.19</gas_price>  <gas_price type="premium">24.19</gas_price> </place> I used an XMLfragmenter to break up the big block of XML from the data source into the above snippets for different stations. But I can't figure out how to extract these using the XML transformers.  I am trying to get a result like this: ID | Price Premium | Price Regular11703 | 24.19 | 22.19 I know I'll probably have to transpose the data, but even before then I can't get the XML extractor or flattener to do anything to this little JSON snippet. Is there an obvious query to extract this using one of the transformers? Thanks

Is there a way to add logic to User Parameters? Example: If one option is selected then another will be disabled?

Hey.I am trying to implement a REST logic to one of my etl's. I have few parameters where i input data. For example a string where the user should input a WKT or GeoJSON geometry. We are passing this parameter to the ETL with the REST Api service, we are manipulating the geometry and i want to print out the resulted geometry in GeoJSON or WKT format in the response body of the etl. Right now i am getting a response that contains only the job details but no results.

I want to assign the correct town name to address that are off a street in one town but addresses are in another town. check the pic below. in attributes town left and town right both are B while town right should be A for geocoding purposes. address points a separate layer has correct town name. is there any way to correct this using FME?  

Hi all, I'm looking for the optimal way to create a 'mesh' of potential flow paths to use with the ShortestPathFinder. Currently I feed my workspace a polygon of interest, then to a point cloud of required spacing. Turn that into individual points and then connect them up in the 8 points of the compass using a NeighbourFinder/ListExploder/VertexCreator. My query with this is at the end I have to use the Matcher to remove lots of geometric duplicates where point A has connected to point B, and point B has connected to point A. Line direction is irrelevant to this task so I was wondering if anyone has any ideas as to how I could optimise this process?

I need to develop a .NET app to execute somo FME workspaces with FME Desktop.Before doing that, I would like to check if there is a license available (there are only two floating license). Is there a way of achieving that? I could assume that if the process doesn't start is due to license problems, but I was wondering if there is a better way. Thanks for any help provided.

Hi All,Hoping a fresh set of eyes may be able to identify why the workbench below performs differently when run on its own and when called on using a workspace runner. The intent of the workflow is to read a table of gps points and filter them into 'Runs' between a Start and End time. I have two branches for testing right now. One writes to a spreadsheet and one to csv. I am expecting that all the runs will be written out to the spreadsheet while each run will be written out to their own csv file using the unique RunName. I don't think it is an issue of datetime format. The workspace below runs with test values in the User Parameters but when the Workspace runner reads the table of Start/Stop Runs and feeds the StartTime EndTime and Runname to the workbench only one csv is output while the spreadsheet contains a larger but incomplete dataset of filtered gps points. So the spreadsheet gets more data but incomplete while only one csv is written out when I am

Hi we are trying to use the ftpcaller to upload a file to an SFTP server. We can upload the file successfully with the filename "file12345666.gz" When we try to upload the file with the filename "file.csv.gz" it does not upload successfully.  We have debug logging turned on and logs look like it appears to upload successfully, and the file size is correct but it simply does not appear on the remote server. It seems to be a bug with the ftpcaller. Anyone noticed this or have a work around at all?

Hi there,I tried to use a ‘User Parameter’ as the ‘Selected Attributes’, but it didn’t work. As you can see the first screenshot below, the HU100 are different between two input resources with GEOID 00037. However, they are listed in the 'Matched' tab. If I use hard coded text 'GEOID HU100' as the 'Selected Attributes', then the Matcher will work fine and the two records will go to 'NotMatched' tab (see the second screenshot below). Could anybody tell me what's wrong with the 'User Parameter'?

In FME 2021, the "Medial Axis" option for CentreLineReplacer was removed - does anyone know of a succinct way to replace this?2020.1: CenterLineReplacer (safe.com)2021+: CenterLineReplacer (safe.com)I found this a very useful feature when combined with a preceding HullAccumulator for auto-generating a new shared network routing close to multiple destination points:

I have a survey and those filling out the survey are asked if a condition has passed or failed. There are close to 50 questions like this. When a condition has failed it is expected that the person filling out the survey will include details on the failure. The table that collects this information has schema similar to this: Condition1, Condition1 Comments, Condition2, Condition2 Comments, Condition3, Condition3 Comments; ad nauseam. I have created a TestFilter to test for the different conditions. Now for each specific failure I have a corresponding outport. The records that go through these outports will be turned into Cityworks Work Orders. Thankfully, they are all considered the same work order (a generic one). I'm a bit puzzled with how to manage the comments. How can I grab the corresponding comments for a failure? It would be good to also have the ability to report more than one failure and grab all of the comments. I hope I've provi

 Here it says it should recocnize Recap files: https://docs.safe.com/fme/2021.1/html/FME_Desktop_Documentation/FME_ReadersWriters/recap/recap.htm

Hello everyone,My colleague encounters an error when running the featureader when the spatial filter is different from <No Spatial filter>. When spatial filter is set on <No Spatial filter> then no error occurs, however my colleague really needs to make use of one of the filters. When he sets the spatial filter on something different, he gets the following error (see image below)He is trying to read features from an oracle database.The problem doesn't occur when he is using fme desktop 32 bit, but then he gets performance issues. 64 version can't be used due to higher version of arcgis pro that is not compatible with fme desktop 2021 64 bit. The error mentions that the table has no spatial index, but it's weird thing is that this problem doesn't occur with fme desktop 32bit version. Does anyone might know what the cause might be of this error?

Hello,I have been trying to solve this issue for several days now and I can't get a result. I have a set of points within the database that I am sending against the polygon of interest . To clarify to which category each point belongs, points inside the polygon are known points without a question tag (?). Points out of the polygon are unknown points; therefore, a question tag exists before the point name (?). There is a track formed of these points that variously goes into the polygon, from the polygon, and it creates the definition of points within the track, which can look like this: 1. ?APKO ?DANKO POPKO FERI LAKO POKO ARN DAN2. APKO DANKO POPKO FERI LAKO ?POKO ?ARN ?DAN3. ?APKO ?DANKO POPKO FERI LAKO POKO ?ARN ?DAN 4. ?APKO ?DANKO POPKO FERI LAKO ?POKO ?ARN ?DAN JAKO DMZ POPO5. APKO DANKO POPKO ?FERI ?LAKO POKO ARN DAN The aim is to remap the points with question tag (?) into the value withou

Hello. Does anyone have knowledge of how to determine the sequential order of segments based on already created geometry? Or any other option? For example, I have L616 tracks where I need to combine the points in the list of fixes into one value. If I use the aggregator, I have values in one column, but the values are not consecutive, see the aggregator attachment - the aggregator writes segments - DENKO BINPO VELAB MISKA ETNEL PEKOT DESEN continues KEROP NIVIS VAL REDVA ?KOGAT ?BITLA and ends NIT TABIN ALAMU. It should be correctly DENKO BINPO VELAB MISHKA ETNEL PEKOT DESEN continues NIT TABIN ALAMU and ends KEROP NIVIS VAL REDVA ?KOGAT ?BITLAIndividual segments that have an expected trajectory from top to bottom are in the attachment. Thank you very much

I've had some success with the Poisson surface but was interested to see the results from Marching Cubes, however, it never outputs a surface with this option for me.

I have 2 datasets of points created from the vertex extractor transformer. The 2 points have the same X, Y coordinate but differ in Z. I want to create vertical lines between these 2 points. I think this should be possible using the vertex creator transformer with 2 transformers after each other but can’t get it to work.

Does the constant interpolation method in the surfaceDraper transformer takes into account X, Y and Z coordinates (2.5D) or is it only looking at the closest 2D value in X and Y coordinates?

I am wanting to display underground infrastructure using FME AR, but have been unable to have the app display an object below the horizontal plane.The model will always end up placed ON the plane, with the feature in the model with the lowest Z coordinate determining the vertical position of the rest of the features. This question was asked 2 years ago, but there was no good answer. Manually offsetting an object in the model downwards causes it to display at ground level, which offsets everything else upwards by the same amount. I know displaying things below ground is possible (on iOS), thanks to Dmitri Bagh's tutorial and workspace here for creating virtual holes: https://www.linkedin.com/pulse/augmented-holes-how-see-under-ground-dmitri-bagh/ (He links the workspace template for download in the youtube comments) I am using th

Structure is *.zip\\text1.zip\\File.txttext2.zip\\File2.txt

I've been trying to match the closest curve to a series a points.I tried the NeighbourFinder with ListStatistics and a Sorter, but it wasnt giving good matches to the points I have (likely because it's looking at points in all directions, not just points perpendicular to the curves). Any ideas how to match the curve closest to the points?Curves are grouped by _segment_id.

Hi I have a feature service that is apart of a Survey123 survey. The survey will indicate if something has failed in a variety of ways.  I currently have a workspace that has a testfilter transformer looking through 50 different attribute columns looking for the word Fail. Then from each output port there is an action that is taken. Is there a transformer that I could use to search the whole attribute table for the word fail instead? Thanks!

I can't fathom how to do this as a newbie. My feature has two attributes, start_coord and end_coord.On a row by row basis, I want to create a line out of these two points. They are currently WKT POINT geometries that I have created from coordinates.  I have attempted to use LineBuilder but that appears to build a line out of all my features (rows) so 44 rows output one messy line.  I suppose the PostGIS approach would be something along the lines of:ST_MakeLine(ST_GeomFromText(Attribute From Feature), ST_GeomFromText('Attribute From Feature'), ST_GeomFromText('Different Attribute From Same Feature')) Any advice would be wonderful. 

Special Pi Day Post Workbench that approximates π by generating a lot of random points within a square area and filtering the points within the 'circle' area. Inspired by Math Parker. Keep in mind that a buffer does not generate a perfect circle, rounding random numbers has a negative effect on the randomness and with more random points there will be a more consistent result.