General

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:

I have an issue with a httpcaller trying to call an app server. It makes the same call for a number of times for different customers replacing only the custumer name in the URL. For most calls it is working but for at least one call I get the error HTTP transfer error: Server returned nothing (no headers, no data) after exactly two minutes. On the app server it processes the call for about 8 minutes before returning an answer. However it seems the httpcaller has already "given up" by this point. Timeout is set to 1200 seconds.  It seems to be an issue with FME or the workbench of some kind, but I just can't figure it out. I hope somebody can help.  Regards Rasmus

I have troubles in using the LineCombiner, with 2 different datasources as input. The first is fme_line from Postgis (MultiLineString, but deaggregated) and the second is fme_line from Shapefile. Both have the same projection system, are in 2D, and have the same attribute schema: only "troncon_id" as string which should be used as merging attribute. I would like to join common line between the two datasources and produce a unique dataset. Hower, the resulting data a correctly merged when coming from the same datasource, but not merged for lines with the same troncon_id and common point (Qgis snapping option). They do not overlap or intersect.Here are the parameters used:An example of not combined lines :

Can FME server run multiple jobs at same time?I found FME server can run a job at a time. Others are in queue. Can we set FME server to run multiple jobs at same time? such as 2-3 jobs a time?

Hi, We have a complex FME bat, compound of 3 FME schemas that we produced in 2019 and it works with 2019.2.3.2 FME version. It is true that it takes about 24 hours.  With the newer versions of FME, meaning everything that is newer than 2021 or even latest's versions from 2020 we get the 'Adjusting Memory Resources' message while performing PointOnArea. We tried different options currently available on FORUMS, try split the data even more without results and and we would like some more ideas.  Below is an extract of the log file. 2022-11-13 10:43:20|4389.2| 15.4|INFORM|PointOnAreaOverlayer (OverlayFactory): Computing relationships between 11770563 input areas and 23979 input points 2022-11-13 10:54:54|4554.8|165.6|INFORM|ResourceManager: Optimizing Memory Usage. Please wait... 2022-11-13 12:40:57|10158.7|5603.9|FATAL |Insufficient memory available -- error code was 2 - please read the FME Help section 'Adjusting Memory Resources' for workarounds.  Thank you!