FME Form

I encountered a challenge with writing to Excel using a template in FME. Despite setting it up correctly, FME wasn't reading the Excel template sheet. This issue persisted in FME 2020 but seemed to be temporary solved in the 2022 and 2023 versions.Progress Made:Identified a Excel plugin we use at work in Excel as a potential cause.Our IT support thinks the windows update for Excell 2023 is the probably reasonExplored potential reasons like multiple Python versions, recent Windows updates, and potential conflicts in the .xlsx files. However I dont want to uninstall my python versions due to other development projects. Cant uninstall windows updates since its restricted due to company policyReinstalled FME to overwrite any potentially corrupted files without success.Various troubleshooting attempts: rebooting, re-saving the FME workspace, re-saving the .xlsx save to 2007 xls template, etc.Upon uninstalling th

I try to upload a file with the FTPCaller with FTP. It works manually through windows browser, FileZilla and with WinSCP without problems.But i cannot get it to work with FME. As far as I can tell the setting is correct.  The error message does not give me any information that can point me closer to the issue. What is the issue and how can I solve it?Upload failed (at start/before it took off) 

Hello, I use the Affiner Transformer to transform from a local coordinate system to the RD83 national system. Now I want to reverse the transformation, but I don't know how to adjust the 6 parameters. A/E = 1.00002B = -0.00002C = 5300000D = 0.00002F = 5600000 Can someone help me please? Thank you.

 Hi,I added a multi-select choice parameter to my FME form, but there are more than 100 values to choose from. Is there a way to let the user select multiple options per click, similar to the Shift+click shortcut in Windows? Thanks,

Hi, I'm having trouble appending one feature from a geodatabase, with another feature from a different geodatabase. To put it simply I want to turn 2 features into 1 feature. I'm using the terminology ("append") from this article, so I hope I've phrased this question correctly Combining Multiple Streams of Data (Append vs. Merge or Join) (safe.com). The schema is the same, I've attached a .gdb with the example data within it. Note: this is part of a much larger question, of how to append two separate .gdbs together (both with the same schema), but I figured I'd start on this mirco level and expand what I can learn from this forum to solve the bigger task at hand. I've attached a pic of the my attempt (this mess

I have an IFC file containing information about sewage pipes. In theory, it should contain two types of object classes (with geometry), namely IfcDistributionChamberElement (Manhole) and IfcPipeSegment (pipe). These classes use their subclasses as connectors, namely IfcDistributionPort (at each object node). Finally, these IfcDistributionPorts should be connected to each other using a relationship class called IfcRelConnectsPorts. In IfcDistributionPort have attribute named FlowDirection with value (source or sink) like in or out. The attached image shows a depiction of the connection.My question is how to create a shapefile containing line features to represent the flow direction so that when I upload the shapefile into QGIS, I can use arrow symbols on the lines.

When I configure the parameters in FeatureReader to resolve domains and subtypes, it seems to have done it because when I connect it to an attribute manager I can see resolved fields. However, when I finish my process and connect them to a FeatureWriter the User Attributes tab doesn't show that it's going to assign domains to the fields that have been resolved.  I'm using FME Form 2023.1.0. I've had success dealing with domains using these two transformers before I upgraded to 2023.1. Also not sure if it's relevant, but I'm working with an ArcSDE GeoDB. 

Excel Reader: Found named range '_xlnm._FilterDatabase' on sheet 'Datenfelder'. This is a Microsoft Excel internal name so FME will not show it as a sheet. If you wish to read this named range, please rename it Excel Reader: Unable to recalculate formulas and refresh pivot tables for Excel file 'Failed to open workbook. Ensure this is a valid Excel file'. %1

Hi all, I have a line and attributes for the length and angle of the line and text.What I would like to have is a vector outline of the text centered over the line. Is there anyway to position the text over the line other than using an Offsetter after the TextStroker? Is there a reason that the height of the text generated by the TextAdder is only about 70% of the value provided in the Text Size parameter?

The error ends with "Please ensure that destination file is closed and check destination filepath" - most reports are generated but the very large ones fail (160 mb). Periodically these will work without an issues. Any help figuring this out would be greatly appreciated. Thanks!

Hi everyone!My current workspace here is designed to convert Esri GDB feature classes into CAD DWG files. As of right now it works but there's a few issues I couldn't solve: The workspace is meant to work as a template without having the user to have to manually change what file they'll be reading each time. Currently it's hard set to a specific point file.There should only ever be 1 single GDB file being processed at a time, but the GDB file is expected to have multiple feature classesWithin each GDB I'm also expecting that I have to deal with incompatible feature classes which simply need to be skipped.Valid feature classes will all have the following attribute fields:FillColorFieldStrokeColorFieldLayerTypeField So I need t

I am currently struggling to find detailed documentation on how we can add a custom project to FME, and simply use it with PythonCaller's, if anyone knows of a good guide for reference it will be much appreciated.

We are using FME 20222.2 and have created a worskspace to translate an input GML file into a proprietary XML format using a XSLTProccessor. It works as expected.We wanted to add a similar translation to transform an excel file into the same proprietary XML format. However, that requires XSLT 2.0 and it seems the XSLTProcessor only supports XSLT 1.How can we construct an XML based on an XSD and complete the attributes from an Excel file ?Is there some demo/example somewhere ? I didn't find one.

I hope I can explain this in a way that makes sense.I'm working on a fibre network where the main cable(s) leave the 'network hub' and connect to a building at the end of each respective route (see below, network hub = yellow, building = red). The goal is to number every node (ascending) from the end of a branch, working backwards towards the network hub (fibre allocation). What I'm hoping will work is creating a virtual merged line (for every building node) that contains the merged cables along the route back to the Network hub. Once this is achieved, I'm pretty sure I can handle the numbering of the nodes along the way, but even after hours of research I haven't been able to trace the route back from any given node, and merge all cables along the way. Has anyone worked on something similar in the past? Any help at all would be greatly appreciated. Blue below would be an example of one virtual merged line. Thank you in advance.

Hi!I have about 8 file geodatabases containing 3-6 feature classes (with different schemas) in each geodatabase. I have a standard set of 4-5 attributes (with blank values) that I need to add to each feature class. Is there an easy way to keep the original schemas from the original feature classes, while also having the ability to add new attributes? Thanks for any info!

I have a list of addresses; each address has a lat/long point that closely represents the center point of the parcel of land associated with that address.I have a single line street network (SLSN).With each address point, I would like to create a line (LineBuilder I suspect) from the address point to the closest point/spot on a line segment of the SLSN (which may not be a vertex defined on the line).I say closest to a point within the line (defined or not defined) because that would represent the shortest path from the address point to the SLSN. Once I have these lines built, I will remove the SLSN geometry and add in the parcel geometry and determine the intersecting point of the "newly" created lines (with the corresponding address attributes associated with the line) and the parcel geometry.This intersecting point would be the best approximation of the mid-point of the parcel line segment (for the address) and the corresponding SLSN.Kn

When the FTPCaller Transformer uploads a file, is there a way to set a parameter where when it uploads the file it actually moves the file out of the source folder and not copy the file?

Hi, I´m using workspacerunner for many process. I would like to see specifically ERROR in each process runned. How can I for save the log with this snipped for each process? Thank´s 

Hi, I am attempting to load CAD DWG into a File Geo database that has pre defined schema and domains. I get about 117 errors when I attempt this and would like some direction on how to resolve. my writer has an XML workspace Document imported. Am I to use the Attribute value mapper to 'code' all domain or sub type values? Thanks!!

Hi, I have some data placed in around 0,0 in EPSG:3857 -- WGS84 Web Mercator (Auxiliary Sphere) I would like to move that to Vietnam, which means an offset on: By doing this process, the data scales down in size, around 4 to 5 meters.I would expect this to be due the long travel distance, but I really don't understand why, which also doesn't matter for me, but I would like to know if anyone knows how to fix this? Maybe if the data wasn't in 0,0 but closer to the actual place, it wouldn't change the size, so maybe there are some tricks to do this. I created another question which is the same, but I think people skip it, since I'm talking about an OBJ to a new location, so I tested on a File geodatabase, and it's the exact same thing, so it's not an OBJ issue. I actually think it could be easier to trick th

Hello everyone, I am trying to write a custom FME transformer using the FME Plug-in SDK with Java. I installed the FME Plug-in SDK and successfully followed the steps of the Java tutorial document (after installing the SDK, the tutorial document is located at '<FME>\pluginbuilder\samples\doc\FMEPlugInSDK_Java.pdf'; I attached it to this posting; especially section 4 "Installing and Testing a Transformer" is relevant to my question; ). In section 4 of this document the custom transfomer defined in file 'CenterOfMassCalculator_Java.fmx' is installedafter installing, the FME workspace '..\java\test\function_test.fmw' is run which contains the 'CenterOfMassCalculator_Java' transformer as second element in the translation flow Eventually, running 'function_test.fmw' in the FME workbench results in that the method 'execute(.)' of the Java class '<FME>\pluginbui

Hi, A simple case; insert some excel data into an oracle table and afterwards move the source file.The workflow consists of the following components: The data is written to the oracle table but no features appear from the output port on the featurewriter.Does anyone have a clue to why there is no output?Transformer documentation states that after succesfull writing all features appear from the output port.Thanks!

I have a sorted list and want to output as a PNG, which transformer should I use? I couldn't go direct from a sorter to a PNG Writer?

Anyone have any ideas about how to extract the data from this formatted html document? Ideally, the data would be extracted to a table linked to named images in a folder.

I have an FME workbench set up in Flow that grabs an XML file from an HTTP location - in that application the access is denied and no features are read. This same workspace when downloaded into a desktop workspace and when run with FME Form has no problem reading the XML into features and I can run the process successfully. What gives? Edit - I noticed the client was using the FME Server 2022.2 but provided me with FME Desktop version 2022.1. I updated the FME Desktop version to 2022.2 and now the HTTP requests register 401 unauthorized in both applications so I think this is less about any issue between Form and Flow and more about some nuance between versions... I can still connect to HTTP just fine in 2022.1 on same machine, same creds in a variety of transformers\\readers - but in 2022.2 no dice. Something changed between point versions but do not see this in Issues documentation.