FME Form

I need to generate a list between two numbers and repeat a value the number of times between the two numbers. The values need to generate the number of rows between the higher ranked value and the lower ranked value. Below is the data I have now, and the second screenshot is what I need generated. Thank you for the help.What I have now:What I need: 

Hello,I'm having issues trying to connect to the my Portal that is using OKTA - Auth2 to login.I've seen a fee threads on here regarding this issue but does not really explain clearly oon what to do.  I get this error "OAuth2 Approval Please copy this code, switch to your application and paste it there: " I followed the steps to register FME in Portal. Filled in all the correct info in the Manage Web Services. I put in my crednitals and get that error. I don't even know if it;s an error. I just dont know what to do at this point ? OAuth2 Approval Please copy this code, switch to your application and paste it there: "  I've seen a couple threads, but didn't really give an answer just said to submit a ticket.

Hello,I can Successfully connect SharePoint list in workflow , can perform Insert operation with no issues, as soon as Change Detector finds the record updated from Original Key field with Revised Key field values with update transform in SharePoint list, i am getting error for FMEException -  where last part the PRIMARYFIELDError:Python Exception <FMEException>: FMEException: 929309: Microsoft SharePoint List Writer: Client-side error: '400 Client Error: Bad Request for url: https://cambridgeca0.sharepoint.com/sites/DesignDeliveryDigital/_api/web/Lists(guid'0c80c870-8721-4543-9550-0fedbed2eeec')/Items(PPM01256)' returned from SharePoint. Error message was: 'The expression "web/Lists(guid'0c80c870-8721-4543-9550-0fedbed2eeec')/Items(PPM01256)" is not valid.'  

Hello everyone, I've recently been doing some work using HTTPCallers to connect and authenticate to an API. The basic flow is that the first HTTPCaller hits the login endpoint. The credentials (username & password) are passed as application/x-www-form-urlencoded values. An XML response is sent which contains a Session ID. This is then passed through to all subsequent HTTPCallers via the header as Cookie - ASessionID=<Our session ID>. This all works very well, but I've been asked if I could move the whole authentication part into a nice secure easy to use Web Connection. I've done similar before, so thought this would be a fairly easy task, but alas, I've hit a bit of a wall when it comes to the Access Token Response. Unfortunately, the login call to this particular API only returns XML and will not return a lovely JSON response for FME to parse and handle. I was under the impression that FME should be able to look at a JSON or an X

Does anyone have (or know where I can find) the workspace and sample data for the Travelling Salesman blog post from 2016 (or later)?https://fme.safe.com/blog/2016/11/fmeevangelist158/ ThanksDavid

Hello, I’m struggling with the logic/approach on this one. I have a spreadsheet of fuel filters. So in the spreadsheet, it looks kind of like this: Unit#/Fuel 1/Fuel2/Air 1/Air212/abc123/abc223/airf123/airf12413/abc123/abc212/airf123/airf124 I want to create output data that looks something like this: Unit/Filter Class/Filter Number12/Fuel Filter/abc12312/Fuel Filter/abc22312/Air Filter/airf12313/Fuel Filter/abc12313/Fuel Filter/abc212 Hopefully this makes sense.Any thoughts on an approach, or some transformers I should work with? Cheers!​​​​​

Hello,  Using a SQl executersyntax: update <table name>  set date_start= to_char(sysdate -1,'dd/mm/yyyy')        where  DATE_START is nullcommitNo updates of the tables.Does FME have a problem with using Oracle “to_char(sysdate -1,'dd/mm/yyyy')”?Because the syntax works under ORACLE SQLPLUS  

Hi,I have two Oracle tables: POINTS_TABLE and LINES_TABLE. I’m trying to export both tables to DGN.  I’m using “Bentley MicroStation Desing (V8)” writer. In writer parameters, I filled out “Cell library file”, and now I’m trying to do something to fill “CellName”. How should I do it, to have different “CellName” value for POINTS_TABLE and for LINES_TABLE in my output dgn file?

I am struggling to save text as a hyperlink in Excel. I tried using this formula:=HYPERLINK("http://www.1spatial.com/fme","http://www.1spatial.com/fme")However, the outcome in Excel didn’t work as expected.  Does anyone have any idea why it behaves this way?

Using an Esri ArcGIS Portal Feature Service Reader to read attachments, RasterReplacer fails on the attachment blob with INVALID_FEATURE_CANNOT_READ_BLOB. Enable Attachments='Y' on the reader, the arcgisonline_attachment{} list is exposed, and arcgisonline_attachment{}.data contains data. I am able to manually download jpg attachments from Portal successfully. I've tried all the image formats in RasterReplacer against the jpg in Portal. Any help would be much appreciated. Thanks! FME 2019.2.1.0, Portal 10.6.1

HiI am having an excel sheet like below. I need to group them in Field name route and assign a value for route field .let's say (routeNo)  or any other unique value.the grouping is based on finding a value that is considerable above of other previous records below is 48. which is very big than other previous ones.Any help is highly considered. Route 1Route 2 

Overwritting .shp files gives mixed results so my workaround is to delete the .shp file(s) first and then create the new version.  But I can not figure out how to do that --I read somewhere that writers have a ‘delete’ setting for the ‘fme_db_operation’ parameter but I can not locate that anywhere.  Can anybody tell me if FME has the ability to delete the .shp files in a folder?  Thanks!  Lewis

Hi all I am trying to compare two databases which contain similar and different geometry files. I am trying to figure out which geometry's are the same and which are unique to each database.   A few big issues I have is the complex of the geometry and even the SAME geometry's has been captured slightly differently; even thou it's of the same area.I also have no data to help identify which geometry's are the same.Example of 2 similar complex geometry's - zoom in to show compilation differencesI am currently struggling to figure the best solution to my problem, the geometry can be complex with donuts and multiple areas representing the “same” geometry. I can't find the sweat when I simplify the data enough to get a match and not corrupt the data too much that everything m

IssueI have several 3D objects (coming from IFC) with variable appearance styles. In one case the style seems transparent. Both in FME inspector and in the final writer (Cesium3DTiles) these objects are kind of transparent.(see feature informations in annex)the dark-red “wall” seems transparant by contrast with the two parts ontopWhat I did so farChanged/Reset appearance (AppearanceSetter) → no effect checked on Geometry (GeometryValidator, VertexNormalGenerator, GeometryRefiner, etc) → no effectQuestionsHow can I make the transparent objects opaque? What’s the difference to the other objects?

I am getting this error with the HDF connector, it seems imp was removed in 3.12 which ships with FME 2024, it seems IMP is deprecated in python 3.12  that ships with FME, would a repoint to a custom python interpreter of 3.11 fix this issue ?  or any other thoughts  2025-1-21 12:20:37 | Message Type: fme::internal::_v0::py::Exception 59 2025-1-21 12:20:37 | Python Exception <ModuleNotFoundError>: No module named 'imp' 60 2025-1-21 12:20:37 | PythonFactory failed to load python symbol `hdfsconnector.hdfsConnector.HDFSConnectorFactory'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date

Hello, I have a pdf report that I need to parse out. I can read it and create a line by line list. It has a line with employee code/name, then subsequent lines with codes and their values associated to the employee. Here is a sample of the report and then what it looks like when it is read in. I can get it split nicely into rows/columns/attributes no problem. My issue is that I dont know how to break it up in each employees portion and add the employee number to each row.There would be a few hundred employees. So in the end I want to be able to spit out a table that has the columns:Employee num, Code, Description, units, extensions,etc I am very new to FME and just struggling to get it figured out. I dont know if I should be using some kind of loop, python code, aggreator etc. Any help would be greatly appreciated! 

Hi all, I’d like to classify polygons by shape, these might include: pie shaped, L shaped, T shaped.I was originally thinking that I’d have to convert them to raster and use some sort of supervised classification. Another method might be to convert them to centerlines and compare their linework: a T shape polygon would have 1 or 2 lines at the top, meeting at 90degrees to another line point downwards

Hello all, I would like to create a simple FME workspace in which PostGIS writer automatically reads attributes from the reader and adds an attribute with PrimaryKey (there are 30+ feature types in total). Is it possible to do it somehow?  I have seen and tested this method:postgresql - FME PostGIS writer define column as serial/PrimaryKey with pre-existing id values - Geographic Information Systems Stack ExchangeHowever, the goal is to set up a straightforward process with automatic attribute definition. I would really appreciate it if you could share what methods you use.

I need to update an ArcGIS Online feature service using something other than 'OBJECTID' field. In previous versions, I was able to set the "Update Key Field" in the 'Properties' dialog box of the AGOL Writer. In 2017.1 that option is gone. I can't find any documentation or examples on how to set the Update Key Field to something else.Any suggestions?

HiI need guidance / SupportI have an excel where FiletypeName: .MDBPath of the MDB is mentionedWorkspace should read the excel and go to tha path mentioned in the excel and read the mdb for each and it should individual for each   Workspace should go to that path and read the MDB file in which Different FC are mentioned and then write it back with same Name of MDB and Fc in GDB formatKindly Guide me how can i proceedI have attached sample data with excel and MDB

My user on the production MS SQL database has an ampersand (&) in their password and FME can't login with it.Is there any workaround for this without having to change the password ?This happens in both FME Desktop and Server.Edit @TiaAtSafe:The password also contains this special characters $&@=Versions:FME Server 2017.1.1.1FME Desktop 2017.0.1.1 (20170512 Build 17291 WIN64)

Hi! I have tried searching for an answer to this problem with no luck, so i thought i’d try making my first post in this forum!I am working with a polygon layer containing cities. I want to dissolve all overlappning cities by removing common boundaries and thus create fewer but bigger areas. The issue i have is that i want to sort this dissolving/mergeing by the population-attributute of the cities. In some cases there are  20+  polygons dissolved into one, and i want to make sure that the output polygon inherits the attribute information from the city with the largest population. I’ve tried using list-arrays of both population and city-names on the dissolved areas with little success, so i am very unsure of how to proceed.  Does anyone have any tips how to solve this?Many thanks!//Andréa  

Hello everyone,I am trying to run the Feature Outline Masks tool from ArcGIS Pro in FME using the PythonCaller transformer. I am new to Python and would greatly appreciate your assistance. I copied the script from the ArcGIS Pro tools website (as shown below) and made modifications to fit my data:# Import system modulesimport arcpy # Set environment settingsarcpy.env.workspace = "C:/data" # Set local variablesinput_layer = "roads.lyrx"output_fc = "cartography.gdb/transportation/roads_fom_polys"reference_scale = "25000"spatial_reference = arcpy.SpatialReference(4326)margin = "5 meters"

I have MSSQL ESRI Entrerprise Geodatabases that are non-versioned but have archiving enabled. As far as I have figured out, there are no ESRI tools that easily copy data with the full archive of the feature class.If it was versioned I could use the ESRI tools for replication…What is the current best methods for an operation like this?

I am using FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) - FME Forms.When running a workflow with the Data Inspector, from a file geodatabase with the SpatialRelator, the workbench appears to change coordinates on the fly. The dataset is in British National Grid (EPSG27700) with an expected data format of XXXXXX.XXX YYYYYY.YYY (depending on decimal places specified, ESRI being 3 decimal places resolution in metres).  An example is 283400.7988999998 377644.82890000001.However, inspecting the output, within the inspector attribute table and the feature information windows, this is replaced by an arbitrary grid XX.XXX, YY.YYY. An example is 66.069000000013411 97.342000000017881.  (These examples are different points). This doesn’t appear to be any projection or coordinate system with which I am familiar in this area and seems to be an arbitrary grid. Finally, when I click a point in the Inspector visual preview window, the coordinate system restores itself bac