Transformers

Hello,I'm a beginner in FME and I need to run a model that was made by my colleague.When I run it, I get error message:CS-MAP Reprojector: User specifed transformation 'SERBIA_to_MONTENEGRO' will be used for 'EPSG:31277mgi' -> 'EPSG:32634'Geodetic transformation (SERBIA_to_MONTENEGRO) not found in dictionary.CS-MAP Reprojector: Transformation 'SERBIA_to_MONTENEGRO' could not be loadedReprojector: Could not create reprojection engineStoring feature(s) to FME feature store file `C:\\Users\\dusan\\Desktop\\Transformacija_CG_GK_u_UTM_V1_log.ffs' As I understand this, I need to configure local coordinate system. My question is, what files I need to change to have this custom coordinate system in FME? Thank you in advance!Marko

We made buildings in Minecraft from 3D data. One problem is that the facades have twisted blocks, Is is possible to change the block orientation so the blocks point in the same right direction for every house?

Hello,I was given a PDF with survey benchmark information on it. Each page in the PDF is has information on one benchmark (see attached "Benchmarks_sample.pdf". I wanted to get this information into a tabular format so I can have a list with the columns: BenchmarkID, Easting, Northing, Description. All of the info for the columns are within the PDF but I'm having a hard time extracting the information into the columns. I'm using the PDF2TextReader from the FME Hub (https://hub.safe.com/publishers/timalbertvictor/transformers/pdf2textreader) which works pretty well for extracting the data. However, I am having a hard time isolating the pertinent information to the appropriate column.Any tips/help on this matter would be helpful. Thanks!  

Hi to all,I'd like to add to my insert procedure a specific sql function for example add a to_tsvector(my_column). I've tried to add it in different manners but the result is always my value with the function name written in the column. Is it possibile to do what I want with a writer or I have to use an SQLExecutor and write my desired insert statemenet?Thank you

Hi,Is there a way to do both operations at the same time? I want it to update the existing ID's and insert the new one in a access database so i can store the data. There is not always an update required , sometimes the existing ID's are not given again.Thx!Nathalie 

Hi Community,I have a simple task I thoughtm but I can't get it to work. I have a long string (URL) with lots of forward slashes. I would like to find the last one or actualy I would like to get the string after the last forward slash. To find the last forward slash I used the @FindString function: @FindString(@Value(exampleURL),"/",-1). It returns -1 instead of the actual place of the slash. When I search from the beginning it works fine: @FindString(@Value(exampleURL),"/") it returns 5 which is the postion of the first slash in an URL. What am I doeing wrong?Thank you

No real question, but I want to share some insights for my Belgian colleagues. In FME, there are two 31370 coordinate systems: EPSG:31370 and Belge_72.Lambert_72_FME. They are exactly the same, except for the Esri WKT Description. The first one contains false easting and northing up to 5 decimals, the second one only three (like the OGC WKT). Until ArcGIS 10.6, you have to use the EPSG:31370, with the additional decimals.Starting from ArcGIS 10.7, ESRI changed the description of the coordinate system and applied the OGC values with 3 decimals.  Opening a filegeodatabase with EPSG:31370 in ArcGIS 10.7 leads to a 'custom coordinate system', not recognised by the software. Using the Belge_72.Lambert_72_FME coordinate system in FME avoids this issue. I hope this post will help some people saving some time.

How this can be achieved in FME?https://support.esri.com/en/technical-article/000011817Source data – 2D point geometry with attributes 'FROM' and 'TO' (elevation values stored). The goal is to create 3D lines from those values.

Is it more efficient way to separate outputs based on multiple attribute value? In this case, I have 3 attributes and 3 testers, alongside 3 attribute renamers. The goal is to have all three attributes merged horizontally (by adding features) in one attribute, filtering out empty values. See the attached workspace.  

Stupid question, but I'm wondering how much post-processing I need to do on the output of a ShortestPathFinder before writing it into say, an FGDB.So, a Path is not a Line feature in FME, it seems to be really an aggregate of its component segments, and each segment has a direction indicator on it so that the Path "knows" how to virtually act as a line with the correct virtual Vertex order, regardless that the component segments that are its aggregate, could alternately be running in opposite directions from each other, and one of a Path's segment's start vertex be an adjacent segment's start vertex as well (ie. The adjacent segments run in opposite direction to each other)However, if I put the output straight to say, SpatiaLite or FGDB, then the writer needs to downconvert the Path to Line. Fine, this is desirable behaviour in my case.My question is though: In what order do the vertices get written? In the direction of the Path, or does it depend on the orien

Hi!I have lines connected to a feature. I would like to give a number to my lines on clockwise orientation in relation to this feature.Do you have an idea?Thanks! 

Hello FME´ers,please, there is one big challenge to generate walking route for postman in census. What I have:- points (households) - one point can represent one or more households, accorging to attribute value- lines (streets)I need to generate routes for postman that contain visiting of 50 households per day, every household must be visited only once. Every route should be unique.Please, is there any idea, how to figure this challenge?Thank You so much!Lubo

Hello,How is that possible that the log is showing inconsistent timestamp values?  

Running the VoronoiDiagrammer is producing some very weird results. Mainly huge strangely shaped polygons around the edges covering the whole globe as seen in the first image. The image below that is from qgis (same input data) and shows the output I was expecting. Anybody know what is going on?

I can't seem to line up my elements/attributes on this lookup table I'm creating. Thanks in advance!Below is the screenshot of the XML attribute I'd like to create a feature from.Below is the parent-children tree of the elements I want to retrieve from my XML file.This is the screenshot of my workspace and configuration. Enable Flatenning is checked and all options are default.This is the result I'm getting from the workbenchBelow is the expected result  DomainNetworkNamenetworkSourceIdNetworkSourceNameAssetGroupCodeAssetGroupNameAssetTypeCodeAssetTypeNameElectricDistribution6ElectricDistributionDevice1Arrester1Distribution ClassElectricDistribution6ElectricDistributionDevice2Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice3Capacitor1Fixed CapacitorElectricDistribution6ElectricDistributionDevice4Circuit Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice5Elbow1Load BreakElectricDistribution6ElectricDistributionDevice6Fuse1Automatic Secti

 Hello,I am trying to find a soultion of workflow in FME, as to the attached image.My first attempt was to use the "NeighborFinder" and check if a footprint touches another. Then group/ list those (light blue circle). Then perhaps do another "NeighborFinder" check within a i.e. distance of 15, and make that a merged list (dark blue circle).I appreciate any idéas. Thank you!

I'm looking for a workflow suggestion or a transformer suggestion. I'm a light user of FME and I have Drill Traces, 3D Polyline files, that are missing their DrillHole ID. I have a DrillHole point file with the correct HoleID in it. The DrillHoles are typically within 0.02m of the beginning of the drill trace. I'm looking for a way to populate an Attribute added to the Drill Trace file to add the Hole ID to it. Both files are Shapefiles. I have attached a screen shot showing the Drill Hole and the Drill trace. I have about 7000 of these I need to match so doing it manually is not an option. Is there a proximity transformer or something that will pull the Hole ID into an attribute into the Drill Trace file from from the Hole point file that is closest to the beginning of the trace? Thank you! 

I would like to create some viewports that are circular and also one shape like this  Is there an autocad attribute I can set to make viewports in irregular shapes?

Hi,I am trying to use FME to get some excel data formatted into columns so I can use them for analysis. The problem is there are headers which I need to populate as a column. I can clean out the totals and blank rows with tester filter but I am not sure how to get the C HALL at the top of the group to populate in a column. I tried using variable setter but it gives me C Hall all the way through for all the lines. Any help is appreciated. So I need the attached data to look like this - C HALL4/1/2019    DATEEVENTROOMATTENDANCETotalEventsEvent Location4/1/2019Event ABuilding C121C HALL4/5/2019Event BBuilding C251C HALL4/11/2019Event CBuilding C3001C HALL   337  D HALL     DATEEVENTROOMATTENDANCETotalEvents 4/15/2019EVENT 1P1201D Hall4/22/2019EVENT 2P1401D Hall4/6/2019EVENT 3P2401D Hall   100  R HALL     DATEEVENTROOMATTENDANCETotalEvents 4/15/2019EVENT FC1101R Hall4/22/2019EVENT GC2101R Hall4/6/2019EVENT HC1151R Hall   25    

Hi,I'm using this to cut a line at two specific points per row of data - line a too and from. The length changes and i get bits on both sides of this line. Is there a simple way to keep the section between the cut points and ignore the rest. The section changes in size for each iteration. Sometimes the largest, sometimes smallest.thanks

If I zip the output of the attribute file writer (example: c:\\test.zip\\photo.jpg) and then use a fanout expression on my text file writer to send the data to the same test.zip file.... Only the text file will be present in the output. However, if I write them to (2) separate zip files the process works. However, I need my output in the same zip file. Does anyone have thoughts why it does not work when they point to the same output file?

Hi,i would like to define a list in the "PythonCaller" Transformer using incomming feature attributes. In addition, the list should be group by an attribute and sould output the same as the "ListBuilder" below. ListBuilder with incomming attribuit group by "Vorschrift" (=attribute) Definition in PythonCaller. how should the python code looks like for define a list using incomming attributes? desired output (=output of the ListBuilder above)    

Hi all.I've been working with outputting data in dynamic schemas, and wanted to debug something using the Redirect to FME Data Inspector feature. This fails, showing "no schema" as the data's only attribute.Is this WAD ? Shouldn't this feature work just as the proper output does ? Or does dynamic schemas only work in proper writers ? This make debugging somewhat more problematic.Instead I cloned my writer, sending its output into a test folder, and that seemed to work as expected.Cheers

Hi, I have a dataset of lines (from one lat/long to another lat/long).  I also have various polygons from an online dataset. I want to find out where the line crosses a polygon and then it the flag 'True'. My guess is to use spatialrelator, but not sure what parameters to set.  My line is the requestor, and I believe my polygons should be the supplier. However, not sure what to select as the 'spatial predicates to test'. Or if I even use this method at all.

with the new 2019 Version there is a new Feature:  i had these and worked with it then the IT reinstalled FME.I still have 2019 but now these Inspectors within the Transformers are gone.Is there an Option to activate or deactivate these?