FME Form

I have a DGN with linked word/excel/pdf documents and I am wanting to extract the filenames and connect to the relevant geometry within GIS. When I open the DGN in MicroStation I can see the linked documents but when I open in FME Inspector, they disappear. See attached image of links in MicroStation. I thought they may be pulled through into a 'linkage' field but they don't look to be.

I have a workspace that reads other workspaces, to do an inventory. I have looked for the Startup Python Script but I can't find it, does the FeatureReader not read that information?

I just started using FME and my first goal is to compare values from DWG attributes and Excel rows. Each Excel row corresponds to a DWG file, I use AttributeKeeper to filter out the same number of columns in each transformer and would like to test each column in the DWG file to the Excel file to see if they match. If they don't I want to add that row, where one of the columns is filename, to a new Excel file and output it.  I've searched this forum extensively but can't find a topic that matches my specific question. Some help on how to continue would be appreciated.  This is an example of my input from both Excel and DWG. I want to know if "Value1" in File1 of the Excel file is the same as "Value1" in "File1" of the DWG file, and so on. The filenames are always the same but the column names differs. 

Not sure which forum to post this in, feel free to move it if not relevant here. I'm revisiting the 12 Days of FME 2022 challenges, which were great fun last year and i wanted to challenge myself again this year. (https://community-fme-server-support.fmecloud.com/fmeserver/apps/FMEUCCommunityCafe/12Days-Details/streaming/fmedatastreaming/12Days2022/ContestDetails.fmw)  It seems that the datasets aren't available anymore though. Does anybody have the input datasets for each of the challenges that they could share please?

I am working on an AutoCAD to AutoCAD conversion where I am changing the text of text and Mtext objects and writing out the changes. The AutoCAD writer uses the input file as a template as the only parts I want to change are the text elements (whether text/mtext/attributes in a block). I am having a problem where Text entities (autocad_entity = autocad_text) are being written as MText entities in the output which is effecting the positioning of the text. This is happening for all text entities (autocad_text), where I have and haven't made changes Is there any reason why text entities would be written as Mtext, when they are clearly defined as text entities in FME? I have posted some images of before and after below for reference:Text Settings in FME just before writingAutoCAD file read into FMEAutoCAD file written from FME

Hi everyone, I have encountered the following issue: when writing to a Spatialite database a polygon with more than one hole, only one hole is created and the others get lost (see attached workspace). By the way, everything goes fine if I write, for example, to shape or geopackage. I'm using FME 2022.2.5.0 (20230329 - Build 22795 - WIN64). Could it be a bug? Thanks

FME Desktop 2021.3 Python Interpreter ESRI ArcGIS Python 3.7Hi I am trying to pass a user parameter that includes the ampersandi.e. username@domain, which I then use within a python caller to login to ArcGIS PortalWhen I look at the value of the parameter, I get username<at>domain hence I am unable to connect to my portal.I have tried to format using string functions str() and strip(). But it doesn't work Any suggestions ?? 

Hello, is there a way to test an integer's length within the TestFilter transformer? I have an integer column that can be freely populated with values, but I need to flag rows that are not 6 characters long. Is there some operation in the Test Clauses window that I can use to test for this?

Hello,  We recently upgraded from FME version 2022.0.0.0 (20220428 - Build 22337 - WIN64) to 2023.1.1.1 (20231011 - Build 23636 - WIN64).After the upgrade one of my tools gives the following error: GEODATABASE_SDE writer: The encoded string is not a valid US-ASCII string: ''AsfaltverhardingPlaatsori\\xC3\\xABntatie'' This happens at a GEODATABASE_SDE writer. The writer uses the following settings:Feature operation: fme_db_operationTable handling: Use ExistingUpdate Spatial Column(s): YesActions preceding the writer determine what kind of db operation is needed Problem: It tries to process a 'ë' but fails to do so After some debugging and looking at other similar questions on the forum, I think it has to do with the locale/character set. In FME 2022 the process encoding was set to UTF-8. When I look at the locale/encoding used in our ArcGIS Pro enviroment (3.1.3) via Python I get 'Dutch_Netherlands, 1252'. This mismatches with encoding used by FME in the

It seems ok when adding smaller data layers but couldn't add bigger layers. I was getting memory not enough error message but my memory is only used one third.

I ve got some problems with expandig of an Zipfile. With HTTPCaller i download the (free available) file "https://service.geo.llv.li/download//gwr/gwr_li.zip". after then i try it to expand with ZipExtractor. As a result it rejects it always with the error_message: "Unexpected error: File name in directory 'gwrli_Spaltenerklärung.pdf' and header b'gwrli_Spaltenerkl\\xe4rung.pdf' differ." How can i resolve this?

I am creating a flow that runs a number of tests on an Excel spreadsheet and spits out the results into another Excel spreadsheet. The incoming spreadsheets will almost always be in different folders (same parent directory, but each project has its own folder within that), and I would like the outgoing spreadsheets to go to the same folder as input, and have the same filename but with the suffix of 'FME Test Results'. I am currently managing this manually, and wondered if there is a way to do it using FME.I have found several answers that seem to get partway to my goal, but don't seem to fully get there.Thanks,

I want to create a workbench that accumulates the flowrate through a drainage wastewater pipe network which has some flow monitors in between pipes and some at branches. I want to accumulate the flowrate such that: The flowrate of a pipe leaving a branch (with no flowmonitor) is the sum of the flowrates of the two pipes entering the branch (leftmost diagram)The flowrate of a pipe leaving a flowmonitor is the flowrate recorded by that flowmonitor (middle diagram)The flowrate of a pipe leaving a branch that has a flowmonitor is the flowrate recorded by that flowmonitor as shown in (rightmost diagram) 

Very disconcerting that Chat and Phone Support options have been removed from Safe's website. I guess now that you’re all full of Flow and Form you don’t need to handle people anymore. Note to self: should I ever run a business, find the demarcation line where things grow too big to provide decent customer support and ensure it never goes past that bound.

Hallo, I am looking for a way to access Sharpoint list attachments in FME.I have tried using FME Reader Microsoft SharePoint List or Transformer SharePoint Online Connector, but the attachments are not retrievable.Are there any plans for FME to add support for attachments?Can anyone suggest another way to download attachments in FME? I would be very grateful for any help with this task.

Hi everyone, Happy new year :) I have created a series of FME scripts that translate DWG file to a feature class in a FGDB.I want to ensure that any time the DWG source file is updated, that the feature class is updated accordingly.Would the "Insert" and "Truncate Existing" option in the Writer be the correct option to choose here? Essentially the user would be updating / adding/ removing polygons from the layer in the source DWG file and I want to ensure that the feature class in the FGDB is also updated.In this case the feature class in the FGDB already has been created and exists currently.  Thanks so much in advance!

In SharePoint you have the ability to add file attachments to records in a List object, can FME access these at all? I've tried the FME List Reader, which just gives a Yes/No field on if an attachment is present, and the SharePointOnlineConnector, but I can't seem to get it to view List objects at all.

Thus, the work of each work area is reported dynamically with each work time. For example, work was done on the plots layer on 1000 plots, 800 were updated and 200 were deleted in Excel form.

The data I am working is real time vehicle AVL GPS data that is dumped into a Feature Class using ArcGIS GeoEvent Server. The Point Feature Class has 104 records.  My objective is to have my workspace act as a "listener" and send me an email every day M-F @ 10a letting me know that GeoEvent Server is reading these records.  Of the 104 records (more records are added each month, so 104 is not static), there are 17 that are not the current date so they are routed to Failed in the Tester. There will always be records in this data that are not the current date.  My question relates to the Tester, the way I have my workspace set up now, is if there are no records in Passed and all 104 records are routed to Failed, I will not get an email. Is there another transformer that needs to be added or maybe a parameter change in one of the existing transformers in my workspace? I want to also get an email if no records are routed to Passed, is this possible?

We used an XMLTemplater (2022.2) to generate an xml message using Excel file input with some optional columns.The XML template contains some if structures like this :            {            if (fme:has-attribute("STATUS")) then <Info> <keyName>STATUS</keyName> <value>{fme:get-attribute("STATUS")}</value> </Info>            else()            }The output xml is correct, but contains empty lines for every missing column, which we want to avoid.Leaving out the else() clause is not allowed as it results in a parsing error.How can we avoid those empty lines in the output xml ?

Is there a way to remove an existing Workspace Parameter from the FME Server Job Submitter? 

This is the original uniquevalue Data with the number of existing features. 1140 Metadata.Worksets203 Metadata.ViewInformation182 Metadata.FamilyInformation105 Metadata.MaterialInformation20 Electrical.CableTrays16 Electrical.CableTrayFittings8 Metadata.PhaseFilters7 Metadata.LevelInformation6 Metadata.StyleInformation5 Metadata.LinkInformation4 Metadata.PhaseGraphicOverrides2 Metadata.ProjectPhases2 SitePoints1 Architectural.Railings1 Metadata.FileInformation in Tester transformer I used (Architectural.Railings / Electrical.CableTrayFittings / Electrical.CableTrays)  The Original coordiante system was : XY-MMI used CoordinateSystemSetter and set CRSM.MTM-10 and then chang it to EPSG:3857For the writer I used I3S with i3s_3d_object Geometry     

It looks like it displays the correct value but for some reason when you click on it or look in the "Feature Information" it looks like it's the truncated version of my string. When I try to preform other operations it'll use that truncated version too which sucks.

Hello FME Experts! I have been struggling with this for several weeks and I'm hoping someone may have some insight.  I have a set of data that contains buildings that were manually digitized from roofline data. From this set, I have scaled the polgyons based on the type of roofline (scaling factors predetermined). This resulted in some properties with multiple roofline types to separate from each other. Think of a home with some steep and less steep rooflines - the scaling was done on each polygon. In addition, I used @Takashi Iijima​ 's workbench and modified it slightly to right angle polygons where possible.  Now, I have an issue because I have polygons that should be adjacent (have shared boundaries) but because of the scaling, they are no longer attached (and because these were manually digitized, there were previous gaps in the data).  I would like to physically MOVE the polygons to allow them to have a shared boundary without changing the shape (much).  I tried using a c