FME Form

See below my Workspace to generate a CSV file from a SQL View:The CSV looks good except I need to put double quotes (“ “) for certain text strings. For example under Ledger Type column, AA should be ‘AA’.Please let me know which of the String Function(s) in AttributeManager I should use to put double quotes around text strings (or other Transformer you deem more efficient):Also, how can I replace all the comma separators in the CSV file with pipes character ’|’ instead.Many thanks!

Hi All,Question regarding using Esri Template Geodatabase and Change Detection. Or anytime using Templates in writers really. When using a Esri Template Geodatabase and selecting "Overwrite Existing Geodatabase" does this process actually Delete Existing Geodatabase and Replace with a New Geodatabase that includes whatever magical newly transformed output was created up to that point in the workspace?Example Scenario: When detecting changes between two Geodatabases a set of "changes" is produced and then we write that out to an existing geodatabase with same schema. To set this up we tell the writer the destination gdb and also identify a Template Geodatabase and select "overwrite existing geodatabase". In this case does the write delete the gdb and reassemble with existing data and applied changes from source?or SourceDB>>UPDATES>>[CreateNEWDestinationDB]>>ApplyUPDATEStoNEWDestinationDB>>[DeleteExist

Surveyors are collecting data on-site and taking photos as attachments unto an ARCGIS Feature Layer. Depending on the infrastructure category, I need to display these survey results across multiple ARCGIS Feature Layers. Is this possible without saving the attachments locally first?

Hello ! I use a SystemCaller in order to copy files.This files come from 2 differents folders and have to be copied from to different ways (command lines are differents) and - in addition- I want the user to choose if he wants to "copy/Y" or "Ycopy" the files.So I have 2 types of command lines from 2 publics parameters but they have the same values "Copie SANS sous-dossiers" and "Copie AVEC sous dossiers":AndSo when the user run the workbench he has 2 parameters to choose but they are named the same way:It is possible to link

I think the current messaging set up for each case could do with some improvements as well that would optimize both the user's and experts' experience and increase overall efficiency. An example would be an easily found "Reply" button at the top of messages sent from FME experts. I honestly think that FME has one of the best user support systems in the bizz and I usually don't submit too many suggestion cases for other software because of the headaches their systems usually cause. However, because of how responsive/active your team is, and how much they've helped me personally with many issues in the past while being a great experience almost every time, anywhere I can help improve an already great system, I'm game. :)

Hello sir / madam, So I have two attribute "_zmax" and "ROOFLEVEL". So I want to test if "_zmax" value is within 5m of "ROOFLEVEL". If yes, then "Pass". If not, then "Fail".  So if "_zmax" is 10m, then acceptable value should be 5-15m.Might I ask how to do that?Should I use attribute manager transformer? Thank you in advance.  

Oracle has been supporting table and column names up to 1000 chars since 19c. ArcGIS desktop 10.7.1 and Pro 2.8, and later, also support long entity names for Oracle. But the latest FME 2022.0 Oracle SDE writer still limit user attributes in the Feature Type panel to be 30 chars. This puts quite a big limitation on our table design. Hope FME can accommodate long Oracle entity names soon.

Hello. I need to calculate the distance in metres from a set of points to a singlehotspot location, but have it calculate the shortest distance along a line roadnetwork (to the hotspot). I have three datasets: Table 1: several 'home' locations (points)Table 2: one hotspot 'destination' location (point) Table 3: a road network (lines) The road network layer does not contains things like no left turn, one-way, pathways, best avoided roads, dead-ends etc. etc. That's absolutely fine, as I just need a crude distance along the network.  Also, the home locations may or may not be on the network, so I may need to introduce a tolerance for where a point doesn’t snap to a network line. I need the shortest distance added to table 1 as a new column in metres. I’ve looked at ShortestPathFinder and LengthToPointCalculator but they don’t seem appropriate. 

Hello I have an *.ifc file and wanted to read in FME and delete records .  How to read the file what is correct format ? After i add as reader (individual or single merged ? ) there are lot of features in it i am intrested in   i am intrested in working with Plates and keeping rest of the things same. SO this is how the graphical representation looks like of Plates  I just want to delete all plates that are in yellow colour and keep rest of them  HOW DO i DO that as i dont see any attributes where this values of plates are stored   it

Error message with filename wb-xlate-...

I know this question has been asked but in the comments it was said that this was solved in 2017 but just in the last half year it happened to me twice. Both times I was using FME Desktop 2021.2.1, I was copying a part of a pipeline to a blank workspace and copying the user parameters as well. Then I solved by recreating manually the workspace and addig each and every transformer one by one. This time not even that helps, there's always a value it's complaining about or it's messing up fetching the values from user parameters, even after you recreate them.  I even tried to create a new workspace that had NO relation to the rest and when I created a user param with value XY and printed it in a pythoncaller it printed XY DEFAULT MACRO FME_FACTORY. Now this messed up my whole workspace and am about to lose a lot of work, how can this be repaired/solved?

I am building a Workspace which takes an integer as one of it's parameters. Depending on the value of the parameter it will query a different ArcSDE layer. I have an AttributeValueMapper to map the number to the layer name e.g.Number : LayerName1 : dbo.layerA2 : dbo.layerBetc After this I have a FeatureReader where the Feature Types to Read value is set to @LayerName as set above. This all works nicely - the data comes out of the Generic port. However, I also want to detect and report on any layers that don't exist. So if dbo.layerA is being set in the AttributeValueMapper but does not exist in ArcSDE, how do I detect this? I thought it would come out of the Rejected port of the FeatureReader, but it doesn't. I do get a WARNing line in the log saying the layer could not be found in the geodatabase, but there is seemingly nothing I can use in the Workspace. I already have a NoFe

FME Desktop 2022.1: What is the equivalent tool of “Euclidean distance” of ArcGIS Pro in FME? I couldn’t figure of if all Raster tools that are available in ArcGIS Pro have equivalent tools\\transformers in FME For example, what is the equivalent tool of “Euclidean distance” of ArcGIS Pro in FME?   

Hi, I have a street network of 3D polygons and the set is not 100% topologically correct. There may be small gaps or overlaps between consecutive road polygons. And normally two consecutive polygons should share the same set of vertices at their junction (materialized by the line separating 2 adjacent polygons).  This would be very easy to solve in 2D using transformers such as the Snapper, AreaOnAreaOverlayer, AreaGapAndOverlapCleaner or TopologyBuilder . But these transformers seem to support 2D only and as a result will not take the z information which is stored in each polygon vertex coordinate. Roads crossing at different z value (bigger than a tolerance of x meters) should not obey to the same rules as those roads which are consecutive.Do you see a possible solution using FME? I was thinking about classifying polygons according

Hi,New in XML transformers, I'd like to know in FME Desktop 2022 how can I read and parse data contained on this XML: <SOAP-ENV:Envelope><SOAP-ENV:Body><ns1:GetSiteValuesResponse><ns1:siteValues><ns1:siteRAIId>1558</ns1:siteRAIId><ns1:x>144.882271794492</ns1:x><ns1:y>-37.825548770183602</ns1:y><ns1:enabled>true</ns1:enabled><ns1:reportedTime>2022-07-26T23:58:04.878</ns1:reportedTime><ns1:currentValues><ns1:laneNumber>1</ns1:laneNumber><ns1:panelValue>Blank</ns1:panelValue><ns1:annulusFlashing>false</ns1:annulusFlashing></ns1:currentValues><ns1:currentValues><ns1:laneNumber>2</ns1:laneNumber><ns1:panelValue>Blank</ns1:panelValue><ns1:annulusFlashing>false</ns1:annulusFlashing>&l

when trying to use the select file from web - azure blob storage option on a reader. I can get to the container and i can select files that are at the top level in that container but if i want to go into a folder to select a file in the folder i get an error. ( see screenshots )Any help appreciated

Hey Guys,  I'm extracting AutoCAD Parcel information (LotPlan Name) and converting it to MTEXT within the drawing.  The MTEXT needs to be a specific Font. However, the Font required isn't available within the DWGStyler transformer. Can I add a new AutoCAD Font style to FME?

I have a workspace that writes a simple CSV file a little over 10 MB in size using a FeatureWriter. I then use an Emailer to send the file to myself but receive a 'Message size exceeds limit' error. (Error wording is - Emailer: SMTPSenderRefused: Could not complete request. Message: (552, b'5.3.4 Message size exceeds fixed limit', 'myemail@company.com')) Is this limit imposed by the Emailer transformer itself? I can email the file to myself as an attachment manually without issue so I don't think it's our company email server. Wondering how I can overcome this issue. Running FME Desktop 2020.1.2.1 (Build 20624). Thanks, Aaron

Hello, I've got an FME workspace which uses the LineBuilder then aggregates the lines using the Aggregator which grouping the line features into aggregates grouping by an attribute. However, I'm getting the following error message:FileGDB Writer: Failed to write Geometry to feature class 'BUS_ROUTE' with geometry type 'esriGeometryPolyline'. Dropping containing feature.I've tried using GeometryCoercer after the Aggregator but this doesn't work as the GeometryCoercer cannot coerce IFMEAggregate features into lines. Any help would be much appreciated, thank you.

For exemple, I would like to have "This feature A overlaps 5% of the feature B" and "The feature B overlaps 30% of the feature A" (I have one dataset) For now, I used "AreaOnAreaOverLayer" to have overlaps. Then, I calculated the area of the overlaps and the features to know what part of the feature the overlap represents. However, at the end, I have for a feature the percentage that represents the overlap compared to one feature, but I haven't the other feature. I only have " Field 1: Feature A / Field 2: 80%" . That's allI want another field that tell me the name of the other feature. Thank you for helping   

Hi, I've downloaded a json file that contains geometries defined as an array of coordinates. A portion of this json file is described below. One json feature can have one or more geometries. I can't find the proper way to parse this json file and transform this array of coordinates to a polygon. Do you have any solution ?  Thanks for your help.{ "identifier" : "2", "country" : "REU", "name" : "[FM][D 2] La grande montée/Plaine des cafres", "type" : "COMMON", "restriction" : "PROHIBITED", "restrictionConditions" : "", "region" : 931, "reason" : [ "OTHER" ], "otherReasonInfo" : "Zone dangereuse", "regulationExemption" : "", "uSpaceClass" : "", "message" : "Vols interdits sauf lorsque la publication d'information aéronautique l'autorise explicitement ou avec l'accord du gestionnaire de la zone lorsqu'il est désigné par l'information aé

Hello!  I am generating a few TIN surfaces which i want to use in Unreal Engine. This means that i will need to generate a UVmap to be able to texture it in engine.  My current setup looks like this: (Ignore my Apperance setting and image rasterizer, i was trying to see if generating a georeferenced texture would work in the appearance setter.). My TIN surface is far away from Origin, so what i am doing is removing the xmin and ymin extracted in the bounds extrator for the offset in the texture coordinate setter. I have tried to do the same thing for the appearance setter aswell.  It seems to generate a UVmap, but the UV is VERY offset in regards to where i need it to be. the scale is correct though.  

We are using SQL Server 2014 deployed as 3 node cluster with 1 primary and 2 secondary. We need to connect to the READONLY secondary. To do that you the set the Application Intent=readonlyBut i cannot find the parameter setting in the database connection for SQL Server.

my question:i have an Ifc file structured like IfcProject -> IfcSite -> IfcBuilding -> IfcBuilding Storey -> IfcSpacetrying to convert to gml i fail to convert IfcSite to GmlLandUse. the export structure is:CityModel -> LandUse -> Building -> BuildingPart -> Roomwhen i remove the writer for LandUse, the structure exports as expected like:CityModel -> Building -> BuildingPart ->Roomids and parent ids are inherited from CityModel to LandUse to Building.... suppose ids and parentids are correct LandUse has no geometryany help appreciated

HI EVERYONE, I have a problem where I need to update ENERGY ADE using FME workbench but there is nothing appeared, I would like to ask, is it any of you have been work with it? I really need the helps since this is my final project.