General

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!

Hi, I am reading an Oracle spatial table (points) and i only want to write it to AGOL. I have 17624 records in the source. When the feature layer is created I only have 12.000 records. Or with another try I have 10.000 records. The table of the feature layer is also created and I see the atributes. In AGOL you get a thumbnail wich basically shows what you have created. That turns white so it looks like there is no geometry. When I open the layer the map is zooming to the right extend but also no points to view. i tried written the feature layer again with only one attribute in it. That went well. How can I solve this issue.FME desktop 2022.2.0.0. (build 22765)

I have a workspace that reads data from a long list of DWG files and writes specific features to a SHP file. The status the drawings could be anything, including corrupt so I have Rejected Feature Handling set to Continue Translation. When the workspace runs, I can see in the log that some DWG files are skipped for various reasons. A new problem occurs when it hits the attached DWG file. It is a Civil3d file and the log shows that FME finds a resource to read it, but then it just sits there and nothing happens for a few minutes until I get an error.  For now I have deleted the file from the list, but it would be better if the workspace would simply skip it and go on to the next file. How do I do this?

I am trying to set up a database connection to my Snowflake 30-day free trial account. The connection parameters are shown below. When I test the connection, it takes a long time (about 5 minutes), and then get a Read timeout error as shown below. I have no problem login to Snowflake web console using https://IN17188.us-east-2.aws.snowflakecomputing.com. I use the account "IN17188.us-east-2.aws" in the FME database connection Account Name parameter. I use FME Desktop 2021.1.1. Anybody experienced this issue? I just try to follow the FME - Snowflake tutorial - https://www.safe.com/training/recorded/connect-data-even-geospatial-snowflake/ net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to IN17188.us-east-2.aws.snowflakecomputing.com:443 [IN17188.us-east-2.aws.snowflakecomputing.com/3.20.44.68, IN17188.us-east-2.aws.snowflakecomputing.com/13.58.248.132, IN17188.us-east-2.aws.s

Hi. I'm trying to use FME to calculate the distance between a point on the perimeter of a polygon and another point nearby (within 10 miles). I'm using the latitude and longitude coordinate system but I need distances in miles and have not gotten very far on my own. Can anyone point me in the right direction? I'm already using NeighborFinder but can't seem to get the distances right. Thank you.

Hello FME Community,I have a shapefile that contains an ID column. the ID must be unique, but I have data records that have come twice.Only ID is the same and other columns are different.with DuplicateFilter I filter Duplicate. so I get features that came twice. I would like to know that which feature with which feature have the same ID.Thanks in advance for your help.

I know the possibilities of headers, italics and bold in creating the workspace app, however I was thinking it would be also nice to give some text different colors. I was trying the markup code from the following stackoverflow link, however the text didn't appear in color on the workspace app :(. So I was wondering whether it's possible to style text in color in the workspace app.  I tried the following methods:<span style="color:blue">some *blue* text</span>.$\\color{color-code}{your-text-here}$ 

i have 4 reader+writer pairs. after the last reader-writer pair runs and completes, how do i get sqlexecutor to run only after the last pairing has completed?