Transformers

I used the ShortestPathFinder to generate the shortest path from a start point through a set of > 1,000 intermediate points to an end point. Therefore, the "From-To" line that is used as input to the ShortestPathFinder connects all of these points/stops. Only the intermediate points on the From-To line were set to be re-ordered and not the Start and End point. The ShortestPathFinder did output a "Path" line. Now, I simply want to figure out the sequence/order of these intermediate stops on the shortest path.I have allowed for U-turns in the shortest path and there are many segments in the path that overlap one another as U-turns are allowed. Therefore, two points/stops at a very close geographic location can be at completely different orders/sequences along the shortest path from one another. I tried several approaches already: 1) Use Chopper to convert all the vertices of the ShortestPath line to points, then Counter to order the points in a 'Count' attr

Hello, I have sql query from our db (sql creator) containing records as e.g.Id; Source, CreationDate1; WTT Australian Notice 123, 201903122; German Notice 12GG3 and VTS, 201904123; VMS and Canadian Notice 53T, 201903124; Canadian 78UU, 20190312I want to use a regex stringseracher for the source attribute and assign a value based on the search result.I have an excel table that contains the regex I want to search for in the db records and the value I want to assign e.g.Regex; Country Australian (Notices|Notice); AUSTRALIA Brazilian (Notices|Notice); BRAZIL Canadian|Canada (Notices|Notice); CANADAHow can I use this table as my regex string?My output should look likeId; Source, CreationDate; Country1; WTT Australian Notice 123, 20190312; AUSTRALIA2; German Notice 12GG3 and VTS, 20190412; null3; VMS and Canadian Notice 53T, 20190312; CANADA4; Canadian 78UU, 20190312; nullThanks for your help!

Hello,I am beginner in android development. I want to upload the model from mobile device to fme server and want to download the converted file to local storage of android. But I can't find any proper documentation about how to use fme api's with android studio.Someone please help me to get this work.. Or share me trick to use REST API's in android. Thanks, 

Hi,I was wondering where to find a sample working FME script that uses NDVICalculator transformer with a satellite image data.I remember Dimitri presented the concept way back during one of those FME World Tours (2016 or 2017?) in Calgary but I'm kinda lost where to look for it in the KnowledgeBase, or if it was even posted.Could you then kindly please advise. Greatly appreciate it.Thanks, WillyWilfredo de Vera, M.Eng.Sci., P.Eng.

I am trying to clean up dissolved features but area gap cleaner doesn't clean up the gaps.what am i doing wrong?Thanks

Hi, I have a file with a 10 points where I need to combine all points to multipoints. It shall produce 100 multipoints and each object should contain 2 points(one combination) .Its more or less a simple cross join without a database. I can produce all the points with unconditional merging in the feature merger but cant figure out how to aggregate them pairwise. The Featurejoiner will do the jobb but it doesnt allow me to keep the attributes Anyone have an idea? 

Hello,I would like to merge pointcloud data spatially.To do that, I create polygons representing the hull of point cloud data using the following steps:coerce point cloud data to individiual points,Bufferer every individiual pointDissolve the buffers that overlaps/intersectsCreate a polygon using hull replacerHow can I perform such operation without using a pointcloudCoercer because it is too much time consuming. Any idea on how to improve this part of my workbench?Thanks

Hello there, It's my first time dealing with CityGML. I am working on my university 3D buildings project and I am trying to figure out how change from EPSG:2180 coordinate system to EPSG:2179. I was trying to use CsmapReprojector, yet even tho FME considers it as success, there is no geometry after the process. I was also trying easy way to simply use writer, yet it losses additional atributes.  Also, is there any tool I can use to "mosaic" CityGMLs?

I am trying to use a GMLFeatureComposer for parsing the input data to the format of one input xsd file. While doing this translation, I am getting the error: GMLFeatureComposer(GMLFactory): Unable to find matching GML feature type from the parsed schemas. Not sure if this is due to any attributes missing in my xsd file or any other issue.

I have two shapefiles, x and y. I would like to filter the polygons in x to show only those that contain/intersect/touch the polygons in y. I've tried spatial filter but it doesn't give me any results. Any ideas?

So I have an Oracle table that has a Username field, Crew_Leader field, and a Crew_Number field.In my process I am reading from a table that has a username value in a field called Editor.I've been referring to this article: https://knowledge.safe.com/articles/19634/using-the-sqlexecutor-to-do-a-join.htmland decided to try to use the sqlexecutor transformer to run a query to join the Crew_Leader and Crew_Number fields to the table. However this seems to be very slow process as it tries to read over a thousand records. Do you know any other way I can accomplish getting the 2 fields from another table and then copying the values into fields in another table?Thanks.

Hi,I'm needing to use a custom python interpreter in 2019 on MacOS in order to use the pandas library.The option to use Custom Interpreters appears to be missing in 2019.0.0.1 - Build 19246. Is this normal behaviour i.e. has this functionality been removed?  Thanks,Campbell.

Hi Guys,i know maybe this was asked before and i searched the forum for this but i was not really successful in finding....if there is the same question please llink it:After my last post i have now set up a workbench which brings me following result: i have now 744 lines with same length of 1600m e.g with always a 50m shift first line begins 0 to 1600next from 50 to 1650next from 100 to 1700 and so onin an attribute i have stored a class number (1,2 or 3)so line 1 to line 16 class1then from 17 to 21 class222 to 51 class 1 and so onbut i have of course duplicate geometry always (with this shift)so i want long segments (and no duplicate geometry any more) where the class is the same BUT: on duplicate geometry parts i want to keep the line with the higher classi have part where i have class 2 and class 3 e.g.so i want the delete the geometry parts with 2 there and keep one with 3...hope i was clearly with my description otherwise ask meGreetz and ThanxFranco 

Hi  I'm looking for a quick way (hopefully) to identify fields that will have their values truncated on writing to output. Using the StringLengthCalculator works great but only on a single field, so I would need to string lots of them together - as my data is being written to a database with multiple tables and multiple attributes per table, I'm trying to avoid this. I need something like the StatisticsCalculator which can generate summary stats for multiple fields at a time,.. but the problem being calculating the string length first as StatsCalc works on the values. And my output values will differ to input values. I expect this is a comon problem - is there something I'm missing? Any ideas & help much appreciated,  Thanks Mary

Hi, Is there a way to download only a specific file from a ZIP file. In my case i want to read the textfile LinkUse.txt included in the ZIP stored at http://open.gip.gv.at/ogd/3a_routingexport_ogd_split.zip. Thanks in advance for any suggestions.

Hello!  I have a problem with creation a path between points, which are saved in JSON file. I tried a extract JSON file with using a JSONExtractor, and when I got coordinates of my points - but not in the form of a list.Next to this, I use a StringReplacer Transformer to get a list of coordinates. And the result looks like this:But when I try a read it to Path or LineBuilder, I don't have any result.Below, I uploaded a part of my Workbench, where I try to build a path. If anyone knows the solution of my problem, I will be grateful for any help or tips.Greetings,Karolina

Helo,  I want to filter from a CSV file all the features that have an ID present in the database (unique ID as it is the table primary key).For the moment I used a CSV reader to get my features from the CSV file and then used a Database joiner with join on the ID both in my table (primary key) and in the CSV. The cardinality is set to "1:1".This way I get in the port the features with no match in the database table.I'm not sure it is the fastest way (takes more than 50 sec to perform the join - ~400 000 lines in the table). Would it be more efficient to have all the ID's in a list and filter with this list ?I am a little bit lost how to do it efficiently. Any idea would be appreciated.

Hello,I need to calculate the percentage: for Example:need to get how many percent of "adresses"= Anzahl_DT have DT_DOWN under 50 (so DT_DOWN 16 and 50)the 100%= Anzahl_Privat= all adresses are 3693sum of Adresses under 50 = 1845+577I tried to built it with ExpressionEvaluator but I´ve became "null" result   the other problem here is: I do not want to have theese "missing" fields in outputhow or where can I edit them?It wa created with Esri Shape Writer and Reader; StatisticsCalculator and AttributeCreator 

I really like the capability to share a workspace in FME Server 2019.It would be really good if we could add content to the page for example so we can explain a bit more to the user.It would also be great if we could brand the self service page!Thanks

Hello all,I have a line dataset that I used the transformer chopper to break it into its start and end points.I now need to use the id of each of these points to add back onto the lines so I get a toPoint ID and a fromPoint ID on each line.I have looked at PointOnLineOverlayer but can't see how to add the IDs back to the line.Any assistance would be very much appreciated once again :)RegardsDean

Hi I have the following table after doing a database queryID overlaps Count Email0 2 1 PublicOps@sts.com0 2 1 PrivateOps@sts.com1 7 3 PublicOps@sts.com1 7 3 PrivateOps@sts.com1 7 5 PublicOps@sts.com1 7 5 PrivateOps@sts.com2 5 3 PublicOps@sts.com2 5 5 PrivateOps@sts.comFor each ID, I need to retain the records with maximum count i.e.for example above, I need to output to be ID overlaps Count Email0 2 1 PublicOps@sts.com0 2 1 PrivateOps@sts.com1 7 5 PublicOps@sts.com1 7 5 PrivateOps@sts.com2 5 5 PrivateOps@sts.com Following this, I need to join output with table 2 to determine if the count is higher than the level valuefor each ID. If it does retain in output, otherwise discard record from table 1 Table 2--------ID Level0 11 32 3  Hence output expected is: ID overlaps Count

Hello all,I am having a problem with the projection being stored against the output features.I am reading in a DWG file, setting the projection to EPSG:28354 and then writing to PostGIS.In the workbench it is showing the correct projection but if I display in data inspector or in QGIS, no projection is being stored with output data. The above image is within workbench (2019) and the coordinate system as expected.  In Data Inspector the coordinate system against the selected feature is "Unknown"Is there something additional that I need to do to get the projection to be stored with the output data?Thanks in advance for your assistance.Dean

Hi, the question ArcPy "import" statement tries to perform import action?https://knowledge.safe.com/questions/37659/arcpy-import-statement-tries-to-perform-import-act.html was raised in 2016 and doesn't appear to have a satisfactory answer.I have been experiencing the issue this week - adding import arcpy to the top of a PythonCaller. When the Workspace hits the python it hangs for 10 seconds then spits out thousands of lines (red, black and blue) around Autodesk 3DS before going on to successfully complete.While it is great that my Workspace runs successfully, it takes a couple of minutes when it should be just a few seconds.I am on FME Desktop 2018.1.1.0, ArcGIS 10.2 (Server is 10.0), running Python (ArcPy) 2.7. Environment variables are set and FME is looking at the right location in Options.Cheers,Mark 

Does anyone know how to read undefined attributes in s57 file? I have a .000 file but it contains a few undefined attributes. ESRI S57 viewer is able to read these undefined attributes but fme can't. I tried to modify the s57 attribute csv file under the fme directory by adding the undefined attribute to the list, but I got object class mismatch error when running the translation. Is it possible to read undefined attributes? any suggestions? I'm desperately in need of help to translate these undefined attributes.

hello, I use a professional licensed version of FME desktop 2019 in 32 bits. I have also instal a version of FME 64 bits (2018)I try to open a geoconcept map to extract data. I had install a the 7.3 version of geoconcept. In FMe, I can choose the map I want but when I try to open the table list in the transformer parameters, I obtain a error message : "Module 'GEOCONCEPT' is unavailable for use with this FME edition"When I check the log, It say the library was found but could not be loaded.  I dont know how solve my issueCan you help me? Thanksfully