Transformers

Hi all,I'm trying to read from a Postgresql DB (postgis) applying a spatial filter using the SQLCreator transformer.Here's the sql statement set in the transformer:SELECT capture_start, capture_end, metadata_url, status, project, geom FROM "public"."Metadata_Index" WHERE ST_Intersects(ST_Transform(ST_GeometryFromText('POINT(142.94 -37.28)',4326),7844), geom) This is the error I'm getting - it's logged as a warning but definitely what is failing the process:2021-06-23 13:07:41| 1.7| 0.0|WARN |Error executing SQL command ('declare "public_custom_query_crsr" cursor for SELECT capture_start, capture_end, metadata_url, status, project, geom FROM "public"."Metadata_Index" WHERE ST_Intersects(ST_Transform(ST_GeometryFromText('POINT(142.94 -37.28)',4283),7844), geom)'): 'ERROR: GetProj4StringSPI: Cannot find SRID (7844) in spatial_ref_sys'

Hi there, I want to know if there is any method to read specific sheet only by using Excel Reader, e.g. I have multiple Readers in the same workspace to input various datasets, one is EXCEL, the other is IFC. If I want to read the sheet whose name is the same as my IFC Reader's source data name. Any method to achieve this? I guess fme_basename helps, but not sure how to achieve this. Thanks in advance.

The article on shutdown scripts states A shutdown script runs after all of the transformers, readers, writers, and the log file are closed in a successful translation. In the case of a failed translation, the script will still execute but may fail as only fme.status and fme.failureMessage are guaranteed to contain valid values.I have a FME Workspace that has a "Translation FAILED" message.  The last three lines of the Translation Log are:Program TerminatingTranslation FAILED.Warning: not all FMESessions that were created were destroyed before shutdown.  This may cause instabilityTesting that I have done indicate that the FME Python Shutdown Script is not being executed.  I assume this is because some FMESessions are still open.  As part of testing I have removed the import or use of any FME related python

I have two tables that form a child parent relationship. The parent record has a primary key and some field data, and the child record has a foreign key and some field data. I am trying to append each child record's field data onto the end of each parent record. There can be anywhere between 1 and 99 child records for every parent record, and the field names from the child record should be repeating. I have attached some sample data to show what I am trying to achieve. The spreadsheet contains a parent table, a child table, and a final table showing the desired final format. Parent: Child: Final:

I can nowhere find information for this error?Does someone know how I can fix this?--Stored 82 feature(s) to FME feature store file `C:\\Users\\CENTRA~1\\AppData\\Local\\Temp\\wb-cache-03_Buffers_Bouwen-xPalBe\\Main_LineCombiner -1 152 fo 0 LINE 0 932eff0b162b454a4c8fc28137d419000e8ade26.ffsupdating'Saving spatial index into file 'C:\\Users\\CENTRA~1\\AppData\\Local\\Temp\\wb-cache-03_Buffers_Bouwen-xPalBe\\Main_LineCombiner -1 152 fo 0 LINE 0 932eff0b162b454a4c8fc28137d419000e8ade26.fsi'Finished saving spatial index into file 'C:\\Users\\CENTRA~1\\AppData\\Local\\Temp\\wb-cache-03_Buffers_Bouwen-xPalBe\\Main_LineCombiner -1 152 fo 0 LINE 0 932eff0b162b454a4c8fc28137d419000e8ade26.fsi'Expression: edgeCurves_[edge].has_value()FME Session Duration: 2 minutes 17.7 seconds. (CPU: 114.9s user, 19.7s system)END - ProcessID: 8116, peak process memory usage: 299160 kB, current process memory usage: 105972 kBE

My request is to transform the x,y coordinates which are in CC49 of the attached file into UTM 31 N (epsg 32631) The attached project does not change the coordinates and duplicates 3 times the data for each phase. Could you help me ? Thank you

I have a DEM raster and also a vector layer containing 20+ polygons. I would like to calculate the highest points within each polygon and then create a point feature for each high point, but I'm not sure how to enable the workbench to cycle through all of the areas.  There's a similar post explaining a workflow to calculate the highest points in a single area, but I would like to apply this to several different areas. Here's a link to the original post for reference: https://community.safe.com/s/question/0D54Q000080hQhISAU/find-position-and-value-of-highest-elevation-on-a-dem-raster

We get multiple problems when rendering complex data with the MVT Tileset writer: Small polygons vanish on different zoom levelsLines are on some zoomlevels so simplified, they look like a subway plan (see screenshot)Some content does not get rendered at all on some tiles, but is visible on neighbouring tiles at the same zoomlevel (see screenshot) The data we render consists of 5 input layers. Polygons and points are mixed in the tileset, but homogenous for each layer. The input polyogons are very complex (lots of vertices per polygon). We produce a single tileset with the input data.  MVT Tileset writer parameters are default.  We als tried with simplification parameter "2" with the same results. It is not really clear what number to use with the simplification parameter, the documentation is not clear. Maybe someone can provide samples how to calculate the number to fill in? 

Hi Support, I am trying to export the Smallworld Electric Office 5.x data into ESRI File Geodatabase(FGdb). I wanted to export the Cable Segment, Cable & Cable Existing Phase records with the same join relationships to ESRI, while doing that I am not able to choose the Cable Existing Phase table(eo_cable_exi_phase) even though I have selected 'Expose Internal tables' option(please refer attached screenshot). How can I export the Cable Existing Phase table data from Smallworld. I have verified in the Community articles and couldn't find any. Can you please help.

Hello, this is a pretty basic question, but I have been wracking my brain as to how to do it.  When I read data from an XML file, it treats each value in my data as a new feature/row. This means that when I convert the features into CSV format, I get one value per line, as opposed to a long string of values delimited by commas. (see the two pictures to get a sense of what I mean). Is there an easy way to fix this? The basic solution in something like excel would be to transpose the data, but there doesn't seem to be a simple functionality for that. (Additionally, if anyone after looking at my workspace has a better way to get my 'msec' values to be first in the csv, I'm all ears!) An

Hi everyone. I have a easy question but i can't be able to ressolve. I have a bulkattributerenamer. The reader is a Directory and path filename. The folder containt PDF (no spatial). The name of all the PDF begin with __, like __PZ440.pdf. I want to remove the __ for keep the PZ440.pdf But i have some trouble with the writer. I can't find the right writer. I know is a beginner question so thank you for help

I have two things that I am trying to accomplish with the current feature/attributes that I have joined. For each row of data, I need to write out 5 new rows. Also, in the new rows, some of the column values are the column names of the input feature. Here is an example: (Attribute Name: Attribute Value)input: ASSETNUM: 12345, VLVCOND:Good, TRNSOPEN:10, OPENDRTN: Clockwise, STRUCTUR:No, SURCOVER: Blue, INSPECTOR:Joe SmithOutput: ASSETNUM:12345, METERNAME:VLVCOND, OBSERVATION:Good, INSPECTOR:Joe Smith ASSETNUM:12345, METERNAME:TRNSOPEN, OBSERVATION:10, INSPECTOR:Joe Smith ASSETNUM:12345, METERNAME:OPENDRTN,OBSERVATION:Clockwise, INSPECTOR:Joe Smith ASSETNUM:12345, METERNAME:STRUCTUR, OBSERVATION:No, INSPECTOR:Joe Smith ASSETNUM:12345, METERNAME:SURCOVER, OBSERVATION:Blue, INSPECTOR:Joe Smith Any help would be greatly appreciated.

I have a 2016.1.1 workspace, reading from gdb, writing to dwg (Autodesk AutoCAD Map 3D Object Data).When I run it on Desktop, I get the following errors.2019-07-03 12:13:55|   5.9|  0.0|WARN  |Library 'D:\apps\fme_2016_1_1_64\plugins/realdwg/REALDWG.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this library2019-07-03 12:13:55|   5.9|  0.0|ERROR |Module 'AUTOCAD_OD' is unavailable for use with this FME edition2019-07-03 12:13:55|   5.9|  0.0|ERROR |Module 'AUTOCAD_OD' is unavailable for use with this FME edition2019-07-03 12:13:55|   5.9|  0.0|ERROR |FeatureWriter_3(WriterFactory): Module 'AUTOCAD_OD' is unavailable for use with this FME edition2019-07-03 12:13:55|   5.9|  0.0|ERROR |Module 'AUTOCAD_OD' is unavailable for use with this FME editionWhen I run it on Server, I get the same errors for some datasets, but not all.I synced back the production data to my local machin

Hello. I have a question. Is there a transformer that can filter based on attribute values? Something like SpatialFilter, but without spatial data. I have two datasets in the workspace and I need to compare one column in each dataset against each other and get only those rows in the output where the value will be the same. I tried to look for some more filters, but I didn't find anything functional. Thank you, very much

I have point table and polygon table in PostgreSQL / PostGIS The polygon table is a series of concentric polygons getting ever smaller / nearest the point See PictureEach point could be in 1 or many polygonsWithin this table is a level column  How do I perform a spatial query returning the join between the polygon contains the point where MAX(level) ? The result I’m expecting is 1 polygon per point (A polygon can contain 1 or more points)

why i can not use the FMESpatialIndex in pythoncaller? it will report the desktop can not support some function​

It is possible to ground truth one or a few prior or possibly mosaic them together and then to add georeferencing after.

The Writer is generating SQL for an Attribute that doesn't exist in the Feature, during an Update operation on a Postgres table. Here is the error message:Error executing SQL command ('update "schema_name"."table_name" set "date_created" = NULL,"date_updated" = E'2021-05-18T07:47:58.73945-07:00',"distance" = E'1.00' WHERE "unique_id" = E'51''): 'ERROR: null value in column "date_created" violates not-null constraint During an Update operation, date_created should not be changed. Although the data flow is read from the same table it's being written to, an AttributeManager specifically removes date_created from the Features on the ChangeDetector's Updated port. unique_id=51 is the very first Feature being fed to the Writer. Like every other Feature from the Updated port, its fme_db_operation Attribute is "UPDATE&quo

When I use FeatureWriter to output multiple GeoTiffs to a single KML Images file, all of the images are correctly registered. When I change the FeatureWriter to fan out the KML using a feature attribute, the the images are no longer correctly registered when viewing the KML in Google Earth. The individual GeoTIFFS saved to the \\images directory are correctly registered. Bug or am I missing something? This works ... This results in a bad KML file ... 

I have a workspace that generates multiple GeoTiffs that have feature attributes that I use for naming the files in Feature Writer. e.g. ...I want to modify the workspace and change the FeatureWriter to write the images to KML/KMZ.When I change the FeatureWriter to write KML I lose the ability to name the images. Is there a way to name the images before the enter the FeatureWriter?  

Hi, I'm currently trying to do a itinerary with my HTTPCaller with the posibility to have 2 itinerary. You can see the the request url that I'm getting. The query string parameters have a parameter called "Choixroute" which is the route choosen, going from 0 to 1. When the "choixRoute" is at 0,the result is the road option 1 . But, when I change it to 1, it is still the road options 1 and not the option 2. Is it something that I have to change in my HTTPCaller or in JSONfragmenter?  Thank you in advance, Ian

Hello, I am new to streaming using FME, and have a few basic questions about how to make it work. I am looking to use FME to stream data from a GNSS receiver. Data is produced as an XML stream. This requires filtering to get the necessary features I am interested in and then I write it to a CSV and ultimately upload to Microsoft Azure. I can get the basic Web>XML>CSV>Azure process to work, but I'm struggling with the time-looping aspects. The incoming data is continuous - I want to be able to package 1-minutes worth of data into a csv, then 15-minutes worth of csvs into a folder to be uploaded into Azure (to cut down on discreet uploads). I'm not sure where to even start, although the time windower and workspace runner transformers look promising? I will have access to FME Server to automate the pro

Hello, I have a problem and I am struggling to find the solution, I have several irregular polygons and, in this specific case, I need to extract areas where the width of the polygon is less than 8 meters (limit red lines). Has anyone been through something like this?

I could import it into 3DS MAX and then export it as a callada file, 3DS file or VRML file, but it still does not appear with independent elements.Do you have an idea to help me resolve this issue ? Do you know an FME transformer that could separate/disjoin my 3D file ?

I have an ERDAS Imagine file I'm importing with a FeatureReader block. The Imagine file does not have a time component. I would like to introduce the time component to the NetCDF, effectively making a single band NetCDF with a time, latitude, longitude and value. I cannot seem to work out how to introduce a timestamp into the NetCDF.  It would be sufficient to take the current timstamp and make a variable of (time, latitude, longitude).  Any suggestions?