General

Hi everyone,please, do you have any idea how to clip elements from solid with no volume?For example feature like in attachment?Thanks a lot!Lubo

I was trying to convert geoJSON data for one floor to IMDF. I saw a video regarding the conversion of YVR airport and was wondering is there was a template or existing workflow available that I could refer to to work on the same. Any help is appreciated!

I got a good one! I am working with the RCaller transformer and doing some good things on the workbench side. I decided to automate a process for non-R programmers to create ggplots of their sensor data. This process worked great on the ol' laptop, so I migrated to my FME Server. I have worked through the version of R (downgrade) to 4.1.3 per FME documentation. I had to change the default path of the libraries as well to make everything play nice. I have run this file on the SAME server as the FME Server install and it runs without error in workbench on that box. When I run the same file in server I am getting this message: 2023-1-19 14:40:45 | RCaller_2 (InlineQueryFactory): Encountered an error when starting R interpreter. Check that R is installed and that the R interpreter path is set in Workbench's "Translation" settings ( http://fme.ly/rcaller ). Message was: Process failed to start: The system cannot find the file specified.It is at least consistent. I&#39

If the Authentication - Credential Source: Anonymous why even require the additional Embedded Credentials - Account Name?

HiI tried to join two linear datatset using this approachI created (snipper) center point from one lines dataset and then I used the spatial relator to join the info to the 2 lines dataset but due to the mismatch of the coordsys of two datasets(I suppose) the center point doesn't touch the line (see picture)I suppose that this is related to the tolerance during reprojection do you have same experience ? thx PS I solved creating a buffer for the center points Francesco

Hi!I have a work process that writes into googlesheete, I get quite a few errors:Python Exception <ApiError>: API Error 400 INVALID_ARGUMENT: 'This action would increase the number of cells in the workbook above the limit of 10000000 cells.'I saw what was being done here:https://community.safe.com/s/article/Known-Issue-Cell-limit-error-when-writing-to-Google-SheetsWhat can solve my problem is the ability to delete the sheet by fme..Is there such a possibility?

is it home use license and 30 days trial are different ?

From a program called topocad I receive building models drawn from drone point cloud. In order to build more complicated parts of the building, they are generated using extrude-> intersect. This creates geometry problems when imported into sketchup with tiny segments, duplicate overlapping points and as result, polygons, or missing polygons. I have tried to snap and repair using areagapoverlaycleaner, 3d snapper, geometry validator with no luck. I'm missing something in the process of data cleaning in fme so I ask for some tips. #1 gml->gml routine . #2 double lines created that snap to vertices .001 mm apart. #3 how it looks when imported

Hi all.When running a FeatureReader normally, it outputs the schema feature for a given dataset before all features. This enables writing to a dynamic writer.However, when attaching the dynamic writer to a previously run (and cached) FeatureReader, and then asking for playback, it seems that the schema features are apparently _NOT_ played back before the corresponding features from the same transformer, crashing the writer.Is it true, is this really WAD ?It kinda ruins the idea of incrementally building and debugging a workspace.Cheers.

Hi I'm currently trying to combine 2 datasets based on a shared set value where table 1 attribute 1 ex. = 500, and table 2 Attribute1 also = 500, and there would be duplicate 500 values in both datasets so to do an effective Join I'm attempting to also join on *closest mileage value, the mileage is not exactly the same between the two tables so it would need to be within rage or closet to sort of function where first the join would be attribute 1 being the same between both tables and then joining table 2 to table 1 where the mileage from table 2 is cloest to table 1 mileage.

Hello all, I am trying to write some data to my SDE geodatabase(file), and I tried two transformers to achieve my goals: Feature writerI got an error: invalid cursor state from the database. When I filtered one row and run the writer, the data were successfully injected, but some of the injected data are different from the intended data. For example, a foreign key needs to be injected as 5 but it's injected as null or 2 in a different row. Please see the setting below. Python CallerI used Geometry extractor to write the shape attribute, Shape@XY with the value (longitude, latitude), and then used arpy.cursor.insurtRow to insert the data under the input function using feature.getAttribute method. I got an error: the INSERT statement conflicted with the FOREIGN KEY constraint.  Thank you,Tae

Using the AttributeConcatinator transformer, how do I represent a blank space in the Separator String: data entry?

I run this command from the command line: C:\\Progra~1\\FME\\fme.exe C:\\BIDW_Prod\\FMETemplates\\FINANCE_finance_EDW_CALL.fmw and get this error: Feature specification `NO_LOGGING' in mapping file row `FACTORY_DEF * TeeFactory FACTORY_NAME SQLCreator_<Rejected> INPUT FEATURE_TYPE SQLCreator_<REJECTED> NO_LOGGING OUTPUT FAILED FEATURE_TYPE * @Abort(ENCODED,SQLCreator<space>output<space>a<space><lt>Rejected<gt><space>feature.<space><space>To<space>continue<space>translation<space>when<space>features<space>are<space>rejected<comma><space>change<space><apos>Workspace<space>Parameters<apos><space><gt><space>Translation<space><gt><space><apos>Rejected<space>Feature<space>Handling<apos><space>to<space><apos>Continue<space>Translation<apos>)' is not valid -- it has a

I have a stream of features containing polygons and multipolygons.I would like to identify only the polygons and promote them to multipolygons (containing one polygon). I tried GeometryAggregator but it is converting multipolygons into geometryCollection(multipolygon) which I don't want.Must be something simple that I just can't see. Any help appreciated.Simon

Hi, I have a need to convert ellipsoid heights to a height datum (Australian Geoid 2020). I currently have the geoid in a dat/gem/gdf/gsb. Is there a way I can open and of these in FME to make one of the grids that FME accepts? I wish to use the CSMapReprojector I have tried to rename the dat file from Geoscience Australia as a txt but that does not work This is the list FME accepts, via a gdc filehttps://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/CoordSys/vertical_grids.htm Does anyone have any ideas? I can seem to find anywhere to convert any of these formats

When overlaying polygons I can get points, lines and polygons in a single result GeometryCollection. I'm sure this is a simple question (and have searched the knowledge base etc), but how do I use FME Workbench to detect such GeometryCollections and then extract just the polygons from the GeometryCollections?

hello all,I am trying to get FME workbench to output into excel file this part of the log file.any suggestions very much appreciated.thank you!

Hi, I have a workspace where run is disabled when "Prompt for user parameters" is on. When i disable this option run is active. This is the only workspace where this happens. Any ideas?  

Hello , i have attribute contains may values as streetname (park: mo (beside))street name (park: far away )How could I use test filter at first to find which value contains parentheses inside it ,I mean as (beside) which value has no parentheses inside it then the values that include parentheses after string as ( park: mo (beside))i would like to extract only the word beside at new attribute .all values include parentheses ( at the beginning but I am interested in the second parentheses ,how could I get the all values that contain two parentheses then extract the string inside the parentheses as beside word .thanks for help FME 2021

Hello , I am not sure how to use Regex expression First example :street name 34 (56)street name 56 ( 44 )street name 55(70) or street name 55( 70 )I would like to extract the number between parentheses and add - before the number so it should be street name 34 - 56 second example : street name 56 (text)street name 40 ( text )street name 10(text)street name 40( text )i would like to extract the text between parentheses and create it in new column  third example :street name 20 ( GdR 20 ) street name 22 (23-50)I would like to extract it and add - before the value in parentheses So it should be street name 20 - GdR 20thanks in advance FME 2021

In a file geodatabase (GDB) to GDB translation, I am writing dynamically to a blank (unpopulated) template GBD that has relationship classes. From a source GDB I am reading features both from feature classes that participate in relationships and from the relationship feature classes themselves. I get the usual geodb_feature_has_relationships and geodb_oid format attributes on the participant features, and I get the usual geodb_type (= geodb_relationship in this case), geodb_rel_origin_oid, and geodb_rel_destination_oid format attributes on the relationship features; however, to keep the workspace generically dynamic and reusable, I need to determine--during translation--the names of the origin and destination feature classes for the relationship classes being read. Of course, I know what those feature classes are before runtime, but the dynamic, i.e., non-prescient, workspace does not. Is runtime determination of the origin and destination feature class names of an existing relatio

Hi, I am working on two excel-files that I wanted to merge with address. Unfortunately I am struggling to merge with the address since they are formatted differently for each excel file. For example: Alex Olssons Road 50 - Alex Olssons road 50 There are more strange cases where there are lower and upper case letters between each spaces. I wanted change the attribute for addresses in both files so that all the letters are in uppercase and all spaces are removed to make it easier to merge. For example: ALEXOLSSONSROAD50 Any ideas what transformer I should use?      

Currently reading in e57s, filtering the geometries to point cloud and raster. Running some routines on the point cloud to reduce the number of points and would like to combine the original rasters back into the e57 writer. So far, point cloud comes out fine, but no images. Thanks

Hey everybody,I have a huge csv file with the attribute field "modify_date" and the date is in "Timestamp" - format (so for example 746841600000).I would like to have it in ISO Date format (1993-09-01 02:00:00).Is there any transformer which can do that? The Date/Time Converter is not able to do that... Thanks in advance.Cheers,Fabian

This question comes just after a question about lines snapping I asked: https://community.safe.com/s/question/0D5Dm000005KcrfKAC/linecombiner-with-attribute-not-working Input data are snapped and combined lines, which form a whole network. Each lines being snapped before, there should not be small holes between these. In order to have a proper network and edges and nodes relationship, I use the TopologyBuilder.From 3935 lines as input, it creates 3935 edges and 3502 nodes. But in these nodes, there are a few duplicates with a distance of 10e-6 meters... Even if before that, the lines have been snapped with 1 meter value.The location of these duplicates is often at nodes where the touching lines come from different datasources (Postgis / Shapefile), but have been snapped before and with the same attributes. Do you know how to fix that ? Here is the configuration for the TopologyeBuilder: