General

Hi,I have a workspace that needs to read data from a variable folder and write to that same folder. However the exact folder name is not given but rather depends on two parameters (BEKnr and Model) that are entered at the start of runing the workspace but also includes a part that is not exactly known and can vary (versionnumber, v*).To read the data I can easily use * for this variable but for the writer this is not working. For instance: I need data to be read from tis folder; G:\\Team_Hydrologie\\FEWS\\ATTRIBUTENTABEL\\11_Maas\\Dommel\\v2_FEWS. Using an attribute creator and feature reader referring to the location as: $(FME_MF_DIR)\\$(BEKnr)\\$(Model)\\v*_FEWS I get the reader to work.But to write to this same folder the use of the * doesn't work. (To be clear, there will always only be one folder that fits the criteria above, only one folder will have the _FEWS suffix. )How can I do this? Without the user having to indicate the exact folde

I was wondering what are the limit of the 'Compare and merge' feature included in FME 2022. I have a request to note all the changes made in the workspace and I want to find a way to list those changes. The problem is that I get an error: Unable to compare workspaces. (I have 800 transformer in it with multiple Custom Transformers). I know this is a bit unrealistic...Thank you

After upgrading our SDE on SQL Server to SDE 11.0 using ArcGIS Pro 3.0.3. FME workbench is not able to read feature types correctly from the database. When importing a feature type using a reader, FME cannot read any fields. Same thing is happening when using FeatureReader. Has this been tested that FME 2022 works with SDE 11.0?

Hello. I am in need of dynamically moving data from one spatialite database to another.Both of these databases (.gigdb files) in this case use same schema. However in the example files I have attached one file (DTMK-2022_07_1.gigdb) has one more feature in feature type (table) a0100000321 than the other file. I would like to copy this extra feature to the second file, same table name. I have encountered several problems.Our company uses FME 2021.1.2 -> there the now obsolete spatialite writer does not allow me to create uppercase / camelcase attribute names, so even when manually creating attributes in the writer, it does not allow me to and then I lose them in the translation. Dynamic writing also converts them to lowercase and I get plenty of error messages saying that my schema does not match.Now my second problem: I am trying FME 2022, just released. When trying the new Spatialite writer, now I get correct attribute names, so that appears to

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

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.

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>Translati

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 name