FME Form

FME Desktop 2022.1 Build 22618: How to perform the “AttributePivotor”? I couldn’t figure out how to apply the “AttributePivotor” in order to derive the “R” table from “Q” table as per the screenshot. The data is attached       

FME Desktop 2022.1: Why clicking the gear sign of a transformer gets the displayed table disappeared? I couldn’t figure out if there is a way to keep the displayed table appearing when clicking the gear sign of a transformer as per the screenshot below   

FME Desktop 2022.1 Build 22618: How to connect C or D drive to FME to be able to drag and drop data decently? For example, in ArcGIS Pro, there is a catalog pane from which C or D drive can be connected to be able to drag\\drop data decently. Do we have such facility in FME?    

Hello, I am trying to build a process where files are being generated on a Windows Server. I am wanting to takes these files convert them from .doc to .pdf then upload them to a SharePoint location then delete the files from their original location on the Windows server. I believe I can see to the the format conversion and SharePoint upload but am really struggling to figure out how to connect to the Windows Server which requires different permissions from my normal user account to read the files in the specific folder. What Reader/Connector should I use to be able to connect to the Windows Server to gain access to the files? Thanks

Hi. I need some advice please. I have a 5x data branch at the end of WS. Each branch contains a defined attribute, see note. This attribute is part of the DepartureLeg. Each departureLeg contains a startpoint and an endpoint, two points (it can be one of the variants of five branches ( airportstartpoint, navaidendpoint... etc. ) and each departureLeg is part of a Departure. Chronologically, it goes like this. A departure contains several departureLegs and each departureLeg has two points ( airportStartpoint, navaidStartpoint, navaidEndpoint, etc. ) This is how I need to group it, but I can't. I think I have all the ids I need.

Hi, I'm struggling reading geometry from an xml file. When looking at a part of the (0.7Gb) large xml, I can see it has coordinates that reference a location I do not expect:<gml:LineString srsName="urn:ogc:def:crs:EPSG::4258" gml:id="GEOMETRY_98ce8c1e-3676-4a60-b2a8-d7e63fe97d1d"><gml:posList srsDimension="3">51.77106873325691 5.459700336196274 49.41166353587596 3.2520665388839736 47.937498062913775 8.934025947231504 51.771400476701494 5.460105669526139 49.412014702926356 3.25205099130662 47.937476504785614 8.934700858000644 51.77170841095756 5.460502642204418 49.412240574188026 3.252040990938717 47.93746470527796 8.935070205423436 51.771910436397455 5.46090045825306 49.41302764854071 3.2520061426583493 47.9374374566226 8.935922993715176 51.77277383456701 5.462819713112839 ...</gml:posList></gml:LineString>The 3D coordinates seem to alternate, which might have something to do with a side view from the data, I guess. When I look at the data in the viewer, it loo

The documentation for the IGDS (DGN) reader states that "Design files consist of a header, followed by a series of elements. The header contains global information including the transformation equation from design units to user coordinates, as well as the dimension of the elements in the file" . My question is how do I read only the header information - coordinates and dimensions etc. I have a large number of files and I just want to the header info from each one. I know how to run the batch processing part with the workspace runner but can't figure out how to set up the reader.

I've been trying to convert them to PNGs and TFWs but with everything I've tried so far, Cesium tells me "Missing or invalid spatial reference system".

I am trying to solve the application allocation issue through FME. The scenario is I have a list of applications and a list of places with limited spaces.  My initial thought is to sort applications by date, every time, send only one application to the neighbour finder and then change the place's available spaces.  The issue that annoys me is it seems like two loops running parallel but also linked together. Not sure what's the best way to design this type of loop? My loop design seems like just creating an endless circle.Any guide would be much appreciated.

I have a dataset where polygon sometimes have a long and narrow part like in this image (upper narrow part of the highlighted polygon): I am looking for a way to cut polygons like this in two parts so that the small polygons becomes a separate shape.Any idea how to do this automatically? 

FME Desktop 2022.1 Build 22618: How to filter the content of a file geodatabase (gdb) based on its feature classes (layers), For example, in the screenshot below, I wanted to get the two feature classes (layers) from the geodatabase but couldn’t figure out the best practice to perform this         

I am. try to group all CellValue as you can see I am getting 4881593 records so I need group them please find the workspace

I have many files in this ascii format. The RRC has MAGNETIC TAPE USER GUIDE with field descriptions that contain beginning and ending positions. I have attempted to use the schema mapper with csv file that describes this but have yet to figure out how to make that work.please help,Files are located here. The file looks like this...The format description is like total bytes per record 308 bytes. MASTER FILE TAPE RECORD SEGMENT KEY NAME DESCRIPTION 01 DAROOT DA ROOT SEGMENT 02 DAPERMIT DA PERMIT MASTER SEGMENT 03 DAFIELD DA FIELD SEGMENT 04 DAFLDSPC DA FIELD SPECIFIC DATA SEGMENT 05 DAFLDBHL DA FIELD BOTTOM-HOLE LOCATION SEGMENT 06 DACANRES DA CANNED RESTRICTIONS 07 DACANFLD DA CANNED RESTRICT

I have some workbenches that take a over a hour to run and I'd like to get the command line arguments to create a batch script without having to run the workbench

Hi All, more or less the same as this query, but checking if anyone has any suggestions on a solution for downloading emails received to an account monitored by fme server? The email & content is used as a topic/trigger to start a workspace, i now need to also download a local copy of the email itself (eml,msg file). Is there a way to do this though fme?

I have a dataset with 3 attributes (REF_ID, orde, DMdrempel) and one (DHMdrempel) has formatting (colouring) applied.There is a 1 to many relation between REF_ID and orde, a 1to1 between DHMdrempel and orde (although sometimes values of DHMdrempel can be identical).I want to create a pivottabel as this one but with the formatting applied:I apply an attributepivoter with parameters set as follows: group rows by REF_ID, group colums by orde and attribute to analyze is DHMdrempel.Because of automation purposes and because I don't know the (maximal) number of 'orde'/columns, I cannot use the attributeExposer (or at least I think I can't). I therefore use a Dynamic writer to create my excel file.But I want to include the formatting (colouring) of the DHMdrempel into my pivotted table but I can't find out how to do this. Can you help me?

I have an ETL doing one thing, running SystemCaller to run a python script. This works fine in Workbench but is not working on Server even though the log shows an EXITCODE of 0. Both desktop and server are windows 64 environments, FME 2019.0.1.If we log in to the server box and call the script from cmd, it works just fine. We tried logging in as the fme user account and it ran just fine as well. Its only when running on FME Server that we are having problems. I have tried referencing the python script from a directory drive and copied to the Server box, doesnt seem to matter. Some clues. The log for the job has an exitcode of 0. When running successfully on Workbench we can see in the log where SystemCaller executes the Python and it logs everything the script does. The log on Server executes the Python and moves on to the next Transformer (no log from the python script running).The Python script being ran must import other Python scripts. When I remove these other scripts as

Hi everyone,I have a script with a reader that connects to an ArcGIS Enterprise database through a connection file.  My question is: Is the connection file information embedded in the script itself, so if I move the script to another location, that do not necessarily have access to the connection file, will it still work? Or is there a way to make sure that my script works whether it has access to the connection file or not? Thanks 🙂

The attribute values is from GitLab pipeline which is called in JSONFragmenter and stored in Attribute Keeper. Now need to pass these attribute value to an azure file storage connector.But the Azure Storage connector is not taking the Attribute values, only parameters are working.Able to pass the published parameters as well as the private parameters.Kindly help me with this.

Hi, I'm working with a mesh feature with around 200 vertices and edges.I saved it to my local PC in 3ds format.I guess the file size is too large than ordinary 3ds file(maybe 4~5 times bigger compared with almost the same file.)I found that 3ds writer in fme is using native fme entity rather than 3ds entity type.(similar question: https://community.safe.com/s/article/fme-creates-large-autocad-dxf-files)I couldn't find any parameters or methods to do the similar thing...Is there any way to reduce my 3ds file output? Thanks a lot. ​

I currently use this WHERE on my reader:[Last_Updated] < DATEADD(week,-1,GETDATE()) or [Last_Updated] IS NullI now have a need to use the items that are older than 1 week, then another need to process those items that are less than a week old. I have added a TestFilter, the NULL test is easy, it is the 1 week item that brings me unstuck. Is this possible to do?  Or do I need to add another step in my chain of processes? Thanks heaps.

FME 2022 Build22153: Calculating the value of an attribute fails, In the screenshot below, I wanted to calculate the “BuildingPercent” attribute field by dividing “BuildingArea” field on “BoundaryArea” field but appears not to work. It doesn’t perform the calculation. What could be the issue here? The data and the workbench are attached    

Hi,I have several obj files for a city. I succeeded to convert these obj files into cesium 3D tiles. At the result of tiles, texture of models created darknessly. To solve this situation, I used AppearanceSetter, then set Shininess value. However, textures of models got lost. How do I set shininess value of my building with textures? I want to share created models by using AppearanceSetter:I want to share without AppearanceSetter:Its my workflow:Thanks for your interest.

We just updated to 2022.1 and now I'm getting an error when using the Tester.That's what I did:I  used a Creator and created an attribute "attr1" with the value 5 in an AttributeManager.Now I add a Tester with "attr1 = 5" then I get this error: Tester (TestFactory): The clause 'TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>attr1<closeparen>,Tester) = 5 ENCODED }' within 'FACTORY_DEF * TestFactory FACTORY_NAME Tester INPUT FEATURE_TYPE AttributeManager_OUTPUT TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>attr1<closeparen>,Tester) = 5 ENCODED } BOOLEAN_OPERATOR OR COMPOSITE_TEST_EXPR <Unused> FEATURE_TABLE_SHIM_SUPPORT Yes PRESERVE_FEATURE_ORDER PER_OUTPUT_PORT OUTPUT PASSED FEATURE_TYPE Tester_PASSED OUTPUT FAILED FEATURE_TYPE Tester_FAILED' is incorrect.  TEST must look like: TEST <value> <operator> <value> [ENCODED]The clause 'TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>V