FME Form

Hi, I have a problem that is bugging the *** out of me. By know it's a question of FME pride since I assured my colleague that FME was the way for this :) I have a rather sizeable SQL table containing measurement data from gauges. It is listed in a fairly common way (described by the attached picture). For analytical pictures I would like it to turn the attribute "name" inte columns that have their value displayed for each time step. This is for data analytical reasons.  I have tried with attribute pivoter without success, working with lists, creating a structured table than make a join. The problem is that the amount of names is so large that I can't make any manual type-ins for name etc. It has to be dynamically otherwise it won't work Please, any suggestions or will I have to admit defeat and hand it over to a sql colleague. It will give him alot of work (and also he will laugh in an evil way). Thanks in advance

This image of my output display on a CesiumJS website demonstrates where I am up to. I am trying to convert GDB multipatch to C3DT.I can control colour through either geometrycoloursetter or appearancesetter but I cannot figure out how to prevent dark shading on top of models nor create defined edges to accentuate the geometry.I want the edges to look like this:

Is it possible to write object data to a dynamic block with AutoCAD RealDWG writer?

The line combiner when used in 2018 and 2021 behave differently for the same input data. In 2021, the output does not correlate to the explanation on the FME help.  For the following dataset, the output expected is as shown in the 2018 output screenshot however, for 2021, despite the configurations being set as per the result which is expected does not yield the same results. It appears that for some reason the duplicate lines(?) are not merged as expected. In the example below, K1, K2 etc. are kring_id and the numbers are _overlap (As set in line combiner)  The help states that duplicate lines are accepted by the line combiner for 2018 and 2021. Here are the transformer settings from 2018 and 2021 that are used in the workspace.  2018 - Break Across Attribute ValuesIf this parameter is set to Yes, two lines with the same values for the attributes selected above will not be combined if the node at which they meet is also connected to another line with different values for these attribu

Hi,I use ZipExtractor to unziped a file, then put it in a folder, but when I go to use PythonCaller to read the files from the folder, it still hasn't finished unzipping all the files.How do I make it use the next task only when the previous task has finished?Thank you

My project covers the whole state of NSW, and the workspace has many many transformers. What I want to know is how to lock the bounding box of the map in the Graphics View. If I'm debugging one particular area of interest, the map jumps to some sort of saved view for each and every transformer. I spend the day zooming and panning the map to get back to my area of interest. I click another transformer to see what the data was doing at that point. then have to zoom and pan again to get back to my area of interest. What I want to do is lock the Graphics View to my area of interest. I can see the hover for "2D" button is "Lock the current view in 2D", but it doesn't lock anything consistently. Sometimes it even centres the map on another state where there is no data. Other times it drops me in the ocean and I have to zoom out until I see land, pan, and zoom in again. Is it possible to keep the bounding box of the map in the Graphics View fixed?

I would like to be able to populate a user parameter dropdown choice list from the results of a sql query and/or stored proc every time the workbench is run. As in, the dropdown choices need to always be able to reflect the database results every time. This seems unusually difficult to do. I need the dropdown to always reflect whatever the latest values in the database are, every time the workbench is called. Using Workbench 2021.2.1.0 (20211203 - Build 21797 - WIN64) Any help is greatly appreciated.

Hey there,So i've modified the Data Downloading script on FME Server and am having some issues exporting to a dwg with object data. The script lets them pick from a tree list what to download and then export to DWG and it completes fine but the issue is if I only download one layer, say contours, its including every single feature class as a layer in the DWG even tho its empty. I can see it creating object data during the FeatureWriter process.  Is there an option to not include layers if they're empty im not seeing? thanks for any help.

Hello,I wish to copy polygon data from SQL DB to ArcGIS Online. The only way I have found that seems to work is in attached image. Having to delete the data before I can insert the update seems incorrect albeit appears to work.I assume there is a better way?Thank you

I have a raster with downpour data (with water depth in different areas) and a vector layer with sewer pipes data. I want to know the maximum water depth of a sewer pipe. I have found an ArcGIS Analysis tool called Sample, is there anything like that in FME?https://pro.arcgis.com/en/pro-app/latest/tool-reference/spatial-analyst/sample.htm

I have excel file where i need to separate all columns please help me out

I have FME workspaces deleting and writing records to the StagingAddress table in an ESRI GeoDatabase. For every agency, the STAGINGADDRESS table is purged using the DatabaseDeleter transformer and then the subsequent workspaces insert records into the STAGINGADDRESS table and then transferred to the ADDRESS table. This process is repeated for multiple agencies.For every cycle, the purging part with the DatabaseDeleter transformer takes the most time.Can I use some other transformer to speed up the purging part? How about using SQL Executor? I am not sure if it will cause any issues, hence asking.

I have multiple layers in my GDBI know I can get the correct projection using share from arcgis pro, but I don't have an arcgis pro subscription for this account, only arcgisonlineI will need to keep updating the layers keeping the projection in arcgisonline 28992 thank you in advance for your help

I have read many posts and articles about FME and geodatabase domains, and nowhere can I find any mention of reading the domain name. I can resolve the domain code for any given feature, getting the <attribute>_resolved value. I am pretty clear on how I have to go about extracting all of the domains in a geodatabase. Given a full domain definition, I can create the coded_value(...)-formatted native_data_type value for a schema feature; however, I can find no reference to how to extract the associated domain name for a feature class in an existing geodatabase, at least with pure FME. This seems nuts, and I feel I must be missing something fundamental. Anyone have any pointers here? Any help is much appreciated.

HiI am using fme to work out the spatial relationship between two polygon datasets. Some requesters will have multiple suppliers and I have enabled the list to store the references for each supplier. Following this transformer, I have use a list concatenator to show these references in one field. This works great when I have only one predicate selected. Where multiple are selected, I have created a second list concatenator for the relationships{}.pass{}. Unfortunately, both these can contain different number of values. For example, there could be two suppliers, but one of these could pass intersect and within and the other just intersect. My difficulty id knowing which pass attribute relates to which supplier. Please can someone let me know what I am doing wrong? Many thanks 

Is there a simple way to rename a attribute name so a user defined field name set in a customer transformer parameter?

I've tried Attribute Reprojector, but that doesn't seem to help. I just need the lat/long.

We have a workspace on FME server (2021.2.6) with a published parameter ProjectName.We're submitting jobs through the REST enpoint, using json for the parameters.Now we have a project name with an single quote (apostrophe), like:A'damThis results in a code 400 - bad request. So, what is the correct way to send this string in the json? What we have tried:A%27damThis works, but then we need to decode the string in workbench.A\'damThis works, but server interprets this as as a double quote.A"damWe also tried to replicate this in submitting a job from the fme server interface but then the parameters are sent as form data, not as json...

My workspace isn't complex yet if I make a small change inside and AttributeManager, FME Desktop hangs for a good minute. The CPU does spike while it hangs.Has anyone else run into this issue before? This is a clean install on a beast of a machine so I shouldn't think its resource related.

When I select NTLM the workspace successfully runs on FME Desktop and FME Server with all features read as expected. When I select Kerberos, the workspace successfully runs on FME Desktop but not FME Server.  The following error is observed in FME Server: “ArcGIS Portal Feature Service Reader: Using authentication ‘Kerberos’ ”“ArcGIS Portal Feature Service Reader: Logging into ‘https://<my ArcGIS Portal host>/portal/’ as user ' ' ”"ArcGIS Portal Feature Service Reader: Could not log into https://<my ArcGIS Portal host>/portal/sharing/rest/generateToken as user ' '. Check your credentials and try again. The error code from the server was '400' and the message was: 'Unable to generate token. 'username' must be specified, 'password' must be specified." Ideally we would like to use a more secure authentication method than NTLM. ArcGIS Portal is not currently setup to use OAuth and I’ve attempted to use the other authenticati

I use FME 2022.1.0 - if i use a Shape-File with x Points + Attribute: Radius then add an Bufferer Transformer + the right settings for Circles. I get an INVALID_PARAMETER_BUFFER_AMOUNT Error In 2021.2 FME 32bit it is working flawless. Is this fixed in FME 2022.1.1 ? Greez Michael

What is the order of operation for fme_db_operations when sending the results to a writer?  If I have a feature counter attached to the Unchanged Port of the Change detector and test the number of records, can I analyze and terminate the workbench before the Deleted, Inserted, and Updated records get processed in the Writer?

I have a large XML (4GB+) I have trouwble to read. I need all elements, however: pand_bagpandid (2) only becomes a feature when it's the only element selected. If I check 1, I get alle elements execpt pand_bagpandid, when I select individual elements (3) I still get all elements except pand_bagpandid, if I only select pand_bagpandid I do get it, but I don't get any of the other elements. I am inexperienced with xml and have ben struggeling with this for quite a bit now. The xml fragements show the same behavior. Flattening, fragmenting or exposing attributes didn't work for me either

Hello FMEers,Here's your weekly dose of news from the world of FME. Scavenger Hunt ResultsThe Scavenger Hunt just finished and the results could not have been closer:  Team Nordend won from Team Zipster by just 65 points. And it wasn't just close in points, it was also close in time. Team Nordend made the winning submission just seconds from the game closing. I thought that was a deliberate tactic, but it appears that they really did get the winning solution at the last second:  So congratulations to them, Team Zipster, and Team Transformer - in fact, to anyone who participated. And thank you all for taking part. The whole idea was to learn a little about FME while having fun and to help build teamwork. It seems we succeeded:  If you want to have a go at solving the problems for yourself - or just check out the answers - then you can find most of them on the community: Fun with Flags Puzzles/Solutions (easy level)Where in the World Puzzles/Solutions (medium difficulty)Brain Teaser Puzz