Transformers

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 

I have two datasets, one of tabular data and one of geometric data. I merge the two of them using a FeatureMerger (with Feature Merge Type set to "Attributes only").When I try to write the data through a ArcGisOnline Writer, I get the "ArcGIS Online Feature Service Writer: Encountered a feature without a coordinate system. All features being written must have a coordinate system". From the translation log I also get the line   Number of Coordinates: 27 -- Coordinate Dimension: 2   (294813.33947753906,5044870.2619018555)(294822.10748291016,5044891.483886719)(294829.1926879883,5044888.6036987305)(294836.28631591797,5044885.723327637)(294843.37170410156,5044882.853088379)   (294850.4735107422,5044879.972717285)(294857.5504760742,5044877.092529297)(294864.6441040039,5044874.222290039)(294871.72930908203,5044871.341918945)(294878.8065185547,5044868.461730957)   ...Skipping coordinates...   (294891.4180908203,5044838.588684082)(294884.3162841797,5044841.469116211)(294877.22271728516,5044844.

Hi All,I want to create a 2d or 3d buffered zone to signify an exlusion zone form utility services to allow visualize the risks while worling around them. Any help is welcome. Please mind that teh string line is originated by i-molel. Kind Regards

Hello, I have an legacy LRS where the line work is Spatial but the From and To are typed in manually. I wish to correct the FromKM and ToKM with correct Line measurements, and make the field 3 decimal KM. I have built the following workbench:* filter out one Roadname for sample* Extract Geometry* Get the @abs(FromKM - ToKM) * 1000 for meters* Get Geometry length* measure differenceI need to be able to use the Geometry Length to create a new from/to KM

Hello, I have this object (brepsolid). The goal is to create geometry based on its volume. I want this to look like a solid mass based on the boundaries of the cylinder. I have tried SolidBuilder but it just converts the geometry to brepsolid. Is it because I should be using enclosed spaces? I would really appreciate any ideas on handling this. Kind regards, George Floros