Transformers

I have lab data that is reported in rows, one row for each analyte for each sample. I need to create a single record for each sample, with the analyte values as columns in the record - build a single record of analyte values for each sample.to this:

Hey guys, I have XML Meta data files which I read and aggregate to one table to write them in a ArcSDE. The SDE is an Enterprise Geodatabase and the platform is SQL Server. To Connect to that SDE I need username and password. I use the FME Workbench directly in ArcGIS Pro and my connection to the database is existing. When I use the Writer "ArcSDE Geodb" FME is asking me for "Connection file". How do I get such an file? Or is there another way to publish the output directly in the SDE? Thank you in advance!Take careCheers,Fabian

Hello! I have a problem while trying to read the data from postgresql (I'm not an expert). Everything seems fine with database connection (test is successful - also I'm able to connect with the same parameters from psql).The reader is created, I can see the attributes of chosen postgresql table.Everything goes well until I hit the RUN button.Then I get two types of errors: Error executing SQL command ('SELECT c.relhasoids AS oids FROM pg_class...Error executing SQL command ('declare "public_xxxxx_crsr" cursor... Does anybody have some experience with this and can share some guidance. Thanks in advance!  

I have several IFC files, each one has its own structure.I managed to save some of the data as a polyhedralSurfaceZ in postGIS, but some of the data structure is more complicated, and saves as a geometry collection of several types. I only managed to save it to postGIS when the geom type is the general "GeometryZ" but then I cannot used the indexing power of postGIS and queries take forever, and some don't run at all ( like st_volume) is there a way to transform the geometry collections to a solid that will be saved as polyhedralSurfaceZ? example of such data:GEOMETRYCOLLECTION Z (CURVEPOLYGON Z (COMPOUNDCURVE Z ((....some also have PolygonZ , some have POLYHEDRALSURFACE Z   

Hello everyone, is there any way how to write custom file properties (metadata) to Sharepoint, please? Thanks a lotLubo

An Oracle table with 16339 features is called in a workflow. After that a tester selects items with conditions: CODE begins with RK or CODE begins with PK. All but 4 items are selected. The workflow works without problems in FME Desktop, but fails on FME Server. As an alternative I put an SQL query in the tabel reader: CODE LIKE 'RK%' OR CODE LIKE 'PK%'. To my surprise it - again - works in FME Desktop but fails on the server. So it seems the problem lies in the Oracle database table. Any thoughts?

In a same dataset I have two columns that I want in a same column. How can I do that ? Thanks

For example, as you see on the screen, I would like an only feature for Roda (and Mira too) in a first column and all the color in another column . Here, I have many line for Roda and Mira, I would like an only. How I can do that ? Thanks!

Hi, Im trying to write a scripted parameter to allow only specified EPSG codes from the CsmapReprojector and apply the correct transformation . Based on a chosen source and destination CRS selected by the user a certain transformation is applied. This works fine, except when I try to use the <Auto> parameter. According to the documentation I should "Use the alternative blank string and NULL_FME respectively when passing in as an attribute." Unfortunately when I use "" as blank string in my script, the workspace fails because "Parameter 'TRANSFORMATION' must be given a value."  So how do I pass a "blank string" that triggers the automatic transformation in CsmapReprojector? My script looks something like this:  import fme if fme.macroValues['SOURCE_CRS'] == 'EPSG:25833' and fme.macroValues['DEST_CRS'] == 'EPSG:31468':  return 'DHDN_to_ETRS89/01_local_grid_FME (Reversed)'else:  return "&quo

Hello, I am in the process of developing a 3D noise model using FME to process the geospatial datasets ready to convert into noise modelling files. As part of this process, after having draped road centrelines to make them 3D, I need to then generate an elevation surface from the 3D road centreline geometries that will be used to drape bridges and breaklines so that their elevations align (there is a reason why we want to do this rather than draping bridge and breaklines to DTM/DSM which I can explain if required).  Appreciate any advice on how best to approach this?

Hello,I'm currently having a problem with my PostgreSQL and Postgis writers.When the feature operation is set to "INSERT", the INSERT is perform on all columns of the table instead of just the columns that are specified in the attribute definition.It result in empty data on columns that arn't defined in the feature attributes but have a default value in the DB. For exemple :I have a table with 4 columns (column_1, column_2, column_3, column_4).The column_3 have a default value ('my_default') In my script, I have a feature to INSERT some data into this table. This feature have an automatic attribute definition (to avoid defining every new column each time I modify my script).But my customer havn't any data for the column_3 and the column_4.So, the feature in FME have only column_1 and column_2 defined in it's attribute definition (beacause I chose the automatic definition option).After I run the script, the result I'm expecting is this one :column_1column_2column_3column_4data1.1data1.2

I have no problem adding the WMS reader to the canvas (selecting layers etc.), but as soon as I try to read the data I get an error: '<WMS> Exception detected for the GetMap operation, requested Content-Type, 'image/jpeg', returned Content-Type, 'application/xml'.' This is the WMS creating the error: https://service.pdok.nl/hwh/luchtfotocir/wms/v1_0?request=GetCapabilities&service=wms The layer is '2020_ortho25IR'. Does anyone know what is creating this error? Thanks. FME desktop 2021.2, W10 

hi everyone,I will give some background information beforehand. I have one dgn file that consists of many models (each model does represent a floor of a building) and the dgn file consists roughly of 1.5 million features (yeah, that's a lot for one building). The idea of my current script is that at first the dgn file is read, some transformation steps take place and finally each floor will be written to a seperate dxf file. So far so good, since each floor/model needs to exported to a sepereate dxf file. However, after some time only a few adjustments are to be made (e.g to only one floor and thus only one model is adjusted in the whole dgn file. Therefore I would need to run the script to overwrite the output of that specific model/floor since changes have occured.  I would like to know if there is a possibility of reading the dgn file and only taking the features of that one model that has changed within a certain time. This might reduce the computing time of the script treme

I have some 3D Data with existing appearances - I just want to make a few of them brighter. I can use the AppearanceExtractor to get the unique appearances, and I can see that with the ApprearanceSetter I can apply one based on a trait I can also see that it's possible to just update an existing appearance. I just can't figure out how to just update it based on the appearance name as this doesn't seem to be a trait For some reason I can't figure out how to do this - has anyone achieved this?

Apologies for asking what I expect is going to be a very basic question. However I would like to read all files of a particular format (eg dxf) in a folder, apply a coordinate reprojection to them and then output them to a different folder. To read the files from a particular folder I believe I would use the Directory and File Pathnames Reader? To apply the reprojection transformation I would use the csmapreprojector, however to write the many files (eg dxf) out to a different folder I am not 100% of the methodology (and or writer) for that.Many thanks in advance

Hello, Im working with this WMS:https://service.pdok.nl/kadaster/netcapaciteit/wms/v1_0? When I access it with a feature reader then it gives me these layers here:And when ran it just gives me a white area cover of where the data is in the world (right place and all, just no symbols). I am accessing the same data in ArcGIS Pro and there I can query "IndicatiefVerzorgingsgebied" based on symbology and see that it has some 8 sublayers: So my questions are:How can I query and expose these sublayers in FME and make them appear as something else than a white area coverage? And bonuspoints if there are any ideas how to expose the feature specific attribute values as well, such as station, netbeheerder, status, totalecap... and so forth

nID='1' nOperTime='2022-07-31 23:51:56' szUserName='default' EventType='Save Config' Remarks='Saved -P2P- config.IP:Local LoginUsername:default Group Name:user' I want to split this into nID, nOperTime, szUserName and EventType I've tried using the KeyValueAttributeCreator transformer to do this with:- Key,Value Delimiter: =Key,Value Separator: <a single space> After this runs I see thousands of columns created with name 1,2,3,4... which appear to be the value of nID rather than the key. I wonder if the issue is the quotes and if so is there a solution that will see quoted fields as a single value?

I am fairly new to FME and am having a tremendous issue with attempting to transpose columns into rows. I have tried the other fixes to transposing rows to columns but to no avail. Here is the sample sheet I am trying to transpose. And under the inspector it tabulates into thisThe issue is that I am wanting to combine the rows of A and C into columns and having rows B and ROM status falling underneath these columns stated above. Columns E, F, and G are not needed. I have tried using the transposer transformer as well as attribute pivoter with an aggregator but does not work. Any help would be greatly appreciated, and will answer anything I did not clarify.

come si esegue un INTERSECT tra un vettore polygon ed un vettore point?

When running workspaces pre 2022 in FME 2022.'GeometryFilter' sorts out Points, Areas and <Unfiltered>, when I send them into GeometryFilter_4 the <unfiltered> features exit through the Area-port. 

Hello FME enthusiasts, I am slowly getting better within FME – but now and then I simply get stuck. In my example, I load a simple .xlsx File with a borehole identifier (BID) and a complementing link to its online available drilling profile (URL). The goal is to extract the profile for each BID via ImageFetcher and to write it into a single .pdf File via the fanout option. Works great so far, but I just cannot figure out how to provide the BID as additional information (here: headline directly in each .pdf) via the PDFPageFormatter. Whatever I do, only the fetched raster image is written as .pdf File. This is more a general question, as more information could be added to the .pdf File (e. g. date and time of image extraction). Please see my attached FME template file. I am quite sure the solution is simple, but I need some help/hints. Thank you in advance! Kind RegardsAlexander

See below my Workspace to generate a CSV file from a SQL View:The CSV looks good except I need to put double quotes (“ “) for certain text strings. For example under Ledger Type column, AA should be ‘AA’.Please let me know which of the String Function(s) in AttributeManager I should use to put double quotes around text strings (or other Transformer you deem more efficient):Also, how can I replace all the comma separators in the CSV file with pipes character ’|’ instead.Many thanks!

Hi All,Question regarding using Esri Template Geodatabase and Change Detection. Or anytime using Templates in writers really. When using a Esri Template Geodatabase and selecting "Overwrite Existing Geodatabase" does this process actually Delete Existing Geodatabase and Replace with a New Geodatabase that includes whatever magical newly transformed output was created up to that point in the workspace?Example Scenario: When detecting changes between two Geodatabases a set of "changes" is produced and then we write that out to an existing geodatabase with same schema. To set this up we tell the writer the destination gdb and also identify a Template Geodatabase and select "overwrite existing geodatabase". In this case does the write delete the gdb and reassemble with existing data and applied changes from source?or SourceDB>>UPDATES>>[CreateNEWDestinationDB]>>ApplyUPDATEStoNEWDestinationDB>>[DeleteExistingDestinationDB]I know that is

I think the current messaging set up for each case could do with some improvements as well that would optimize both the user's and experts' experience and increase overall efficiency. An example would be an easily found "Reply" button at the top of messages sent from FME experts. I honestly think that FME has one of the best user support systems in the bizz and I usually don't submit too many suggestion cases for other software because of the headaches their systems usually cause. However, because of how responsive/active your team is, and how much they've helped me personally with many issues in the past while being a great experience almost every time, anywhere I can help improve an already great system, I'm game. :)