FME Form

Hello, I am new to FME and am taking over support for our FME extracts between Smallworld and MicroStation. I am seeing an issue where MicroStation is not honoring the colors I am assigning in the .fmw file. I tried the Level Overrides setting and that was not the cause. I seems to be an issue with the cells themselves, but I am not sure. Other cells seem to work fine but I am so far unable to make a distinction between the ones that work and the ones that don't. Hoping anyone has encountered a similar issue-- any information is appreciated.

I've just been exploring the Compare worksapces tool in FME 2023. Great to be able to integrate this as both a diff and merge tool. But I noticed that currently there is no way to compare CustomTransfomers or CustomFormats. Any plans to add this to the workflow? A large part of out FME projects are CustomTransfomers which we use in final workspaces.  For now the only way to compare a CustomTransfomer is to have it embedded in a workspace. This makes it Impossible to use as a Diff or Merge tool in Git. @mark2atsafe​ - pinging you here Mark to get Safe's take

I am working with conductor lines and need to create a routine that establishes connectivity of lines out of the substation. Essentially the first line out of the sub would be line 1, the second line would be line 2 and its parent would be line 1. Line 3 parent would be line 2, etc... I have tried TopologyBuilder, but this doesnt account for flow.

Reading a feature class from file geodatabase and writing it in another file geodatabase fails,   I wanted to read a feature class from file geodatabase and write it in another file geodatabase but it appears not to work          What might be the issue here?     Thank you   Best   Jamal 

Hi, I want to write geometry and attribute data to a dxf file. How do I make sure that the attribute data is saved in the dxf file? All I get now is the geometry in the dxf. 

two seperate shape file are there for trees and poles respectively, how to create there 3d visualisation with appropriate texturing.

I logged into FME Server several days ago and had no problems. Today when I logged in I get this message. Any ideas on a fix? (Our FME Server environment includes a Load Balancer between FME Server 1 and FME Server 2); I am logging in using the Load Balancer URL.

I’ve been building some automations in FME Flow with optional parameters (date or numeric fields) that can either be filled or be blank when run outside of an automation.  When I try to save an automation with one of these optional parameters filled in, it saves fine, but as soon as I try to save an automation with a blank optional parameter, it loads forever and doesn’t commit the change. As I've said, it seems to affect date and numeric fields.  Has anyone else come across this issue before?  Currently have 2021.1 (upgrading soon)

Hello, I am creating a list in a pythonCaller which contains lists inside. Similar to this example: mylist=[[4, 5, 6], [1, 2, 3], [9,8,7], [10,14,13], [5,9,10]]. How can I expose this list to pass it to the next transformer ? The usual way of feature.setAttribute('mylist{}', mylist) is not working. My script is working fine when I am running it outside of FME. I am getting the following error in FME:"Python Exception <TypeError>: Could not convert attribute value to a supported attribute type.Error encountered while calling function `processFeature'PythonCaller_3 (PythonFactory): PythonFactory failed to process feature"

Hi Guys,I'm just trying to read my group content from arcgis online and do some query from "last modified date" on service level.Anyone know how we can read/convert this format? Seems DateTimeConverter cannot recognise it..  Thanks! 

Hi. I need to convert all the values from each row in an Excel sheet to a different word doc. Is this possible woth fme? With the custom transformer TableAdder I could convert the whoke sheet, but I need to create different word docs for eacht row. Each row had a unique value in the field KEY and it would be usefull to add the KEY value to the word filename.

I am looking to rewrite a process to use FME instead of SSIS. The process reads data from .trk files. But I am not able to find any reader for .trk files in FME. Please suggest.

Hi All, Just wondering if anyone might be able to spot something I am trying to troubleshoot. I have tried all things I could track down forum-wise. I am stuck connecting to ArcGIS Portal 10.61. I used to be able to but after an upgrade to Pro 3.0 (not necessarily the case but happened around the same time) I have not been able to connect. I can connect to ArcGIS Portal 10.91 fine. This is using the Reader and the Hub Portal reader/transformers. I get the following when attempting a connect via get token or via web service. I downgraded to Pro 2.9 just in case but no luck. Running latest pre-2023 version of Form. Any pointers would be greatly appreciated. Thanks All!c.Connection attempt using get token Using Python interpreter from `C:\Program Files\FME\fmepython310\python310.dll' with PYTHONHOME `C:\Program Files\FME\fmepython310'Python version 3.10 loaded successfullyArcGIS Portal Feature Service Reader: Logging into '

Hi,I am using the FeatureWriter to write data to postGIS. I am using the featureWriter instead of the postGIS writer because I must run a series of SQL after write. I am using the writer in dynamic mode.I need to set the data as MultiPolygon, but the geometry type it is writing is just the generic "geometry". I set the Geometry under the General settings to postgis_multipolygon but it does not "stick". Every time I a open the Writer it is set back to unfilled and red. Appear to be a bug!? I am running FME Desktop 2018.Suggestions how I can overcome this?Kind Regards

Hello, I read CSAR raster files with the FME reader for this type of file but when I look at the layers, only one numeric value is given for each pixel in the contributor layer (see red circle in attachment). If the CSAR file is opened in CARIS, three metadata values are available: feature ID (which is a character), start and end date of the measurement. Am I missing a step to be able to read this information in FME ?  Thank you!Kind regards, Yasmin

After installing FME on my computer, all of my files have defaulted to open in FME. For example an xlsx will now open in FME unless I specify that it should be opened with excel. Any suggestions on how to resolve this issue?

I use a XSD Driven XML Writer to compose a XML file. Afterwards I read the file and send it with the HttpCaller to a SOAP Endpoint of some application.Is is possible to skip the "Save to File" "Read from File" part and directly write into a XML attribute of some feature?

Hi, do you know what the problem could be? I have a backup of the MS database, which I load into FME and write to the postgres DB with Postgres writer, but I have no data in postgres. Maybe a datatype? But FME reports no errors. Thank you

How can I compare 2 lists and find match elements as per the attached snap:I have 2 different data sate and I need to match attributes as per the element in dataset 2 list2 elements are mandatory and in dataset 1 list1 elements are should contain list2 elements. if list 2 has 3 elements and list 1 has 5, list 2 elements 3 must match list 2 elements, and the rest 2 elements of list 2 are optional. kindly refer to Snap for a better understanding.  

I am using the aggregator transformer to take multi part polygons across NI, grouped by Local Government District, so when the data is displayed and selected on a map the records in one district will be selected as a multi part. I want to keep all unique identifiers and addresses for the records, as well as other attributes. I have currently got all the attributes to remain by using the assemble hierarchy section in the transformer using LGD as parent id and unique id as the id, but the group by doesn't seem to be working as the records are being selected as individuals polygons, not multiparts.

How do I set a xml element to xsi:nil=true in a XSD Driven XML Writer?I tried to set with "name.nil" xml_boolean. No luck. I changed the type from xml_boolean to xml_char. No luck.I created a feature_type for <name> element and set the attribute via a "nil" attribute. No luck. The output shall look like this: <aixm:name xsi:nil="true" nilReason="inapplicable"/>nilReason works without problems. 

Dear all ,  It's a hollow PIPE , I want to extract XYZ for each a) centre point (c1)b) face centre point (v1&v2) + face INNER vertex point (vf1&vf2)c) radius (e.g. distance from v2 to vf2)d) total length (e.g distance from v1 to v2)  thank you for kind support

I have different gdbs at different level in a folder.In each gdb there is the same dataset. I want to merge (usually with a junction) the similar datasets from the gdbs (all dataset has the same structure). But I not sure of what reader should I use:I use a reader with feature Type Name as "any schema".And Reader "PATH\\**\\*.gdb" Then I put a FeatureReader , but I cannot get attributes from all the dataset. Any Help will be appreciate. 

I am running checks on data. Any fails in checks, they will be written to a tab in the spreadsheet. If there are no fails, the tab won't be created. In the case of failures, is there a way for me to print a message to say "Checks ok" into a new tab?

Hello everyone,I am having random timeouts on FMEServer when i am trying to connect to a PostgreSQL database (using FeatureReader/FeatureWriter) or when i am trying to realize a simple get/post with HTTPCaller. The timeouts seems to happen randomly, mostly when there are multiple simultaneous jobs.The HTTPCaller timeout is partially solved by activating the option "Retry Failed Requests", but sometimes the maximum value of "Maximum Retry Attemps" (10) is not enough (i.e. the timeout is still there after 10 retries). For the FeatureReader/FeatureWriter there is no retry option available.A similar problem was found here