FME Form

I am new to FME Workbench and I am using the latest 2024.1 version.When I tested to add CSV to ESRI ArcGIS Portal as a new point feature layer, it succeeded to create a new feature service in portal but failed to insert CSV data into the newly created feature service with following error message: “ArcGIS Portal Feature Service Writer: UPSERT failed for feature service 'Sample_Test': Append job failure: 'Operation rolled back.'”Then I have to re-run my workbench again, and this time it will insert all CSV data into the portal feature service without any issue.BTW, I am using “Create If Needed” as Feature Service Handling parameter.Could someone help me out to make this workbench adding CSV data to ArcGIS Portal in one process? Thanks.   

Hey,There is one blog on support.safe.com on working with esri shapefile data. There is a scenario and below explained the workspace attached to it.I am not getting how the Shapefile is created in below scenario. The shapefile was already given in the template file.Below is the link of the article - https://support.safe.com/hc/en-us/articles/25407430413837-Tutorial-Getting-Started-with-FME-DesktopHow the esri shapefile used in the reader is created? Thanks in advance

Hi,I understand that the Raster Expression Evaluator transformer doesn't work properly, only in the new version 2024.2.I would like to know how I can proceed with my workspace, as I want to keep only the raster pixels with values greater than 0.3. How can I solve this? Please find my sample attached: https://drive.google.com/file/d/1Yil9aZj5mkiTQi7lbvDJfFejWKQE4YTl/view?usp=sharing Thank´s

Hi,  I have an excel spread sheet that i have to read and load into a database table. The structure of the excel sheet is different from that on the database. Sample screen shot of the excel spread sheet is seen below. Columns J-S are county names, and the values associated with it are the cost for each county.I need the 10 county column names loaded as values into COUNTY_CD column in the database and its associated county cost value loaded into database column COST_PER_SQFT. So, for every row in the excel spread sheet I will have 10 rows in the database and each row represents data for each county. The database columns and the values to be loaded should like below

So, in the context of pipelines we run camera inspections registering different damages and features along the pipeline. We have registered pipelines by ID in a larger gis database. I already have a script running that reads the information and returns all the registerd freatures in the camera inspections and draws it in a arcgis. The issue is that sometimes the lines have bends even with the same ID. making it hard to create new points at the specified distance. So what i need is something that creates a point at a specific length from the starting point ID, that takes into account the geometric changes of the line.   in the example picture under, i want to draw a point at the POI. I have the distance(70m) from start. But there does not seem to be obvious functionality for this in FME. Any ideas?   

Hi!Is it possible to create (writers etc)  a Data Pump Script (DPS) file for store in Oracle in FME Form ?

Hi folks, I think this very useful article on the WorkspaceRunner could use some love:https://knowledge.safe.com/articles/1469/batch-processing-using-the-workspacerunner-1.html"Article created with FME Desktop 2013"I believe FME has evolved somewhat since those screenshots were made :-)

HiI have a DGNv8 3D CAD drawing of a bridge i want to load into FME since i have been tasked with converting it to a different format.The issue is that not all parts of the bridge loads/reads properly, most notably the deck of the bridge is missing. Most of the bridge is drawn using smart solids.Here is the bridge in MicrostationHere is the bridge in FME. All i have done is add a reader and an inspector.And if u look at the feature information for those missing parts it says nan. I have attached the dgn file in a z

Hello,I have a set of pairs of points that each have a uniqueID_start and unique_end field. I am trying to extract all of the line segments between each pair of points. The tricky thing is that the pairs can be several line segments long, and have other pairs intersecting them:There could also be several points on a single spot, but corresponding to different pair sets.It’s a mess! Any help would be wonderful!

Hello, I have a reader with a shapefile that has contour lines in it. I have connected that to the ContourLabeller transformer. I have taken the label output port of the ContourLabeller and run it to a DGN Styler where I have styled it. These parts are all working but when I write it using the DGN (V8) writer the label level is not created. What am I missing here? Thanks!

I have a kmz file. There is a point in it. When I open the kml file with fme, the screenshot is attached where it converts the geographical latitude and longitude from degrees minutes to decimal. Additionally, degrees have been converted from minutes and seconds to decimals by Tubitak, the leading institution in Turkey. The screenshot is attached. Does anyone know the reason for the difference? 

I need the coordinates of the intersection, where lines cross the railroad geometry.With SpatialFilter/SpatialRelator I can isolate the lines (from a larger dataset than shown here). But I cannot identify the coordinates of the intersection.In the drawing the red dots are the points I need, they are handdrawn for explation.Any ideas as to what I could do?Thank you :)  

Hi there,I have severale profiles, which fly somewhere in 3D space.The elevation always follows the z axis. The direction varies, but follows one direction in XY level.I started like this:BoundsExtractor get the bounds (aka rotation axis) GeometryRefiner do some geometry refining 3DRotator rotate around the axisResult:3D view

Hi FME fans, I am using the MS Sharepoint List writer to update values - this is using Feature Operation 'Update' using Row Selection 'sharepoint item id'.This works fine when I give it a new value, eg a different date, however if I set the value to null in FME the value in sharepoint doesnot change. How can I set the value to null?Thanks, Owen

Hi,I have a dataset with 8 images. Look below at the images together: After using the Raster Mosaicker, the output is 1 image like this: What could I have done wrong in the transformer, or what else is necessary?Thanks.

Hello everybody,I found many discussions about this topic, but, I just want to renew this discussion. Is there any way, how to convert word (docx) file to PDF format in FME, please?Thank You so much for all tips!Lubo

Hello Forum, I need to create a point layer of middle points of streets. I have a street network (lines) where each object is attributed with the name of the street. I tried coordinateExtractor, which does produces points on the line. However, in the vast majority of cases it selects the starting point. But I need the middle point of each line. So, I then used CentrePointReplacer to create the centre point of the each street’s bounding box. This works but it finds, unsurprisingly, the centre point of the bounding box. These bounding box centre points -unless rarely through extreme coincidence- are not actually on the street itself. I need them to be on the street. So, I now need to snap that point to the nearest street using the shared attribute value. For example, it look at the point record for Acacia Avenue in the bounding box centre points dataset and then snap to the nearest location in the street network whe

I’m trying to make a KML from a CSV with Geometry in WKT. I have got up to the Extract Geomery transformer but keep getting the INVALID_GEOMETRY_VERTICES error. Example i’m trying to extractLINESTRING Z (212197.02298451745 6343709.643456226 -405.22127891605567, 212199.2655298651 6343696.0119692795 -406.87294763726277, 212201.50807521114 6343682.380482333 -408.246661504635, 212203.75062055816 6343668.748995384 -409.3429700220356, 212205.99316590338 6343655.117508436 -410.1623117274895, 212208.2357112494 6343641.48602149 -410.7050143686031, 212210.47825659852 6343627.85453454 -410.9712950336693, 212212.7208019459 6343614.223047592 -410.9612602385047, 212214.96334728913 6343600.591560645 -410.674905969057, 212217.20589263522 6343586.960073698 -410.1121176798006, 212219.4484379844 6343573.328586748 -409.2726702479159, 212221.69098332908 6343559.697099801 -408.1562278832371, 212223.9335286767 6343546.065612854 -406.7623439939325, 212226.01318177005 6343533.424279183 -405.221278916

Hello, I was just wondering if anyone has successfully used the AutoCAD Dimension attributes to validate angles?I have a example drawing below where the angle of the lines is added as text in AutoCAD using the DIMANGULAR function in AutoCAD. When FME reads in the features, using ‘Explode Dimensions’ set to No, I get a series of attributes against the text point with the coordinates of lines used to determine the angle in AutoCAD. What I have found is that defpt2 to deft4 aren’t always in the order to create lines and test the angle between them and was wondering if anyone else has had success in validating angles from a DWG?

I’ve been successfully utilising the Microsoft Email Service via the Emailer transformer for sometime - I noticed last week that all emails scheduled to run via FME flow stopped working, and when I opened the workspaces to reauthorise Microsoft, I was met with the following error: “Unable to retrieve access tokenRequest to update access token failed. HTTP Error: HTTP/1.1 401 Unauthorized” My IT department can see on their end that the logins have been successful via FME Emailer Enterprise Application on Azure.  

Hello There, I’m hitting a brick walk with trying to get FME to talk to OS Downloads API, as anyone found any advice and guidance on this?

Hello, we are trying to use our FME server to run all of our data conversion via the API. We have created a workbench and uploaded it. We set the service to Job Submitter. When we run it we can not see were the output was written to.  The log indicates that job was run successfully but the log does not have any mention of an output location. We have tried to set the output File Geodatabase location to a network drive: “\\nos.noaa\MCD\FADS\FADS_Projects\FME_Workspace_Output\Weekly_Atons” and a local server drive: "F:\FME Server System share\repositories\Testing_Nate\ALL_USCG_Weely_Xmls_to_GDB\output\Weekly_Atons"Any help would be greatly appreciated 

Greetings, I used a setting that limits record input to 1,000 records before.I cannot find the setting to limit FME to read the first 1,000 records?? This is useful when testing a FME workbench that has large number of records. If anyone can point out the setting, it would be appreciated. ThanksClive

Hican you hlep me to understand if I can extract info from this webpage  https://viabilita.autostrade.it/it/viabilita/previsioniWhat I need is the info in the blue boxthxFrancesco 

I'm using an Aggregator transformer to group by an attribute and concatenate many attribute accordingly. I'm having a problem with the attribute column containing missing or null values. The Aggregator will populate the attribute containing missing or null values with the separator character when it should stay empty or null. Is this a bug? I've replicated the problem in the screenshot below