FME Form

data source CSV file each day populated with date stamp, my requirement need to load CSV each day to SQL server

Hi,I am new to FME, and I am trying to build an FME workspace that reads multiple .csv files from a folder and write each file to separate table in SQL server. Each CSV file:has different schema should became it is own SQL tableHere is what I tried so far:I used Directory and File Pathnames reader I used Feature ReaderThe <Generic> port of Feature Reader shows no data, I am assuming because the schema of each is different. the <initiator> port give me the correct file name and path.

Hi All,  I have been getting my head around FME Server and Webhooks with Survey123 data collection, and I am loving it! I can competently capture data via a Survey123 form, then trigger some FME automation to manipulate the data and email a specific user results dependant on what was captured in the Survey123 form. This is working well.  I would now love to take this to the next level by using the formal Survey123 Report rest API. So ideally I want to get a copy of the Survey123 report PDF that is generated each time the webhook is triggered, and email this PDF to particular people. I have been searching this forum and I do not see any tutorials or any mention of working with the Survey123 Report API itself. Has anyo

The website Dynamic Workflows: Destination Schema is Derived from a Lookup Table > Creating a Table-Based Schema > Geometry Type tells me that valid values for the `geometry_type` column are the values from the `fme_type` format attribute. It provides the full list of values under this link. The link is incorrect. This is the list of FME internal data types. These are NOT valid values from the `fme_type` format attribute and these are NOT values from the `geometry_type` column in the screenshot above in the tutorial.Where i

Is there a way through FME to automate the creation of plates (3D planar surface), from the following data:XYZ position (centroid) Shape: Always has 4 sides but not necessarily always a rectangle Dimensions info: Width and Length Orientation info: Azimut (DipDIR) and DIP

In the reader file I have multiple full names “John Doe”.  I want to ensure my Writer 1 / Output 1 should only have the first entry of John Doe and the rest of the John Doe entry should be mapped to Writer 2 / Output 2.  Ex.Name Address John Doe 31 xxx st John Doe 41 yyy st John Doe 51 zzz st  John Doe on 31 xxx st should go to output 1, and other two John Doe should go to output 2

I’m trying to add a new database connection (FME Form 2024.2). I haven’t had any problems with this in the past but today the Add Database Connection dialog just freezes when I click Save. I’m able to click the Test… button to test the connection and that works.I’ve tried various connections to various databases and get the same behaviour - I’m able to test the connection successfully but not able to save it, so it does not appear to be a DB connection issue.I suspect it’s a file lock / permission issue on the connections file/DB that is being used but I have rebooted the computer and that did not help. I’m trying to save the connection for my own user (not a shared connection).Has anyone else experienced this and know how to resolve it?

Remove space and Space* from the name ensuring John Doe*/ John Doe * converts to John Doe.  What transformer and parameters should be implemented?  Tried to use the Attribute Trimmer but it only removes either of it. 

Hey Everybody, In my work, I generally get the question from clients to build a FME Server Web Application. Often, the question involves a MS Excel file, which needs to be analyses and converted to points/lines/polygons (GIS). Mostly, I use a Creator to kick-off the Workspace and a FeatureReader to load in the Excel. Also, I force the FeatureReader to have one single output port (Generic) and load in the Excel file using a User Parameter when kicking off the Workspace. This means that I need to Expose all attributes individually in the Workspace.However, this limits the flexibility. When I want to create a Web App from the Workspace, the input Excel always needs to have the same columns (so a Template Excel as input). An potential extra column is therefore not exposed an not in the result of the Workspace. However, in some cases, it is for my clients not possible to always use an Excel Template. Or they want to add additional information. My question therefore i

I am reading dwg file, but i cant set him the right coordinate systemThe file i am reading is from autocad 2012In autoCad coordinate system is set to EPSG : 31277, i dont have that system in my fme workbench  Thank you in advanced 

I can't subtract solid geometry with the fme csg-builder.My goal ist to subtract the terrain (extruded by -10m) from buildings, to evaluate the volume that is above the terrain (subtract the basement under terrain). 3D-View:2D-View:  I tried several fme-transformer before plug them into the csg-builder. I used combinations of geometrycoercers and solid-builders with no success. My approach is to negative-extrude the terrain convert it to a solid and then substract it from the building-solids.The result ist always “nothing” (rejected):

I have various values in a 'code' field.A sample would be: A33, B111W, B12, C3V etc, etc.This issue is, there should be decimal points between all numbers, i.e, these should correctly read: A3.3, B1.1.1W, B1.2, C3V. There does not need to be points between the letters.I can string replace “33” with “3.3” and continue to do that for all values if I have to, but I’m hoping that there is a more efficient way of capturing these values and using regex or something to force decimal points between the numerical characters. I’m not well adept at using the stringformatter, but maybe there is something there? 

I have a FME 2022.1 Desktop workspace with dynamic reader and dynamic writer. The reader generates several lists in some feature classes, in addition to attributes.How can I parameterize e.g. ListIndexer or ListExploder transformers to treat all appearing lists within various features of various feature classes streaming through my dynamic workspace at once, not explicitly knowing their list names (and hence not being able to indicate them as transformer parameter) ?

I was just trying to load a wms into my fme workbench using the OGC WMS reader and i get the image with a resolution of 22m yet the image has a resolution of 8cm.I then loaded the same wms as a background map and it comes with the desired resolution of 8cm. Did i miss something or the calls made to the wms server using the background option is different from those made using the OGC WMS reader?i also realised that without setting the map width and height the resolution is very coarse then on setting the width and height, the resolution gets better, but i cant go beyond the maxheight and maxheight specified in the wms xml file. Below is the wms url.https://service.pdok.nl/hwh/luchtfotorgb/wms/v1_0?request=GetCapabilities&service=wms Kind regards,Keller.

I have error messages when trying to run python script. I installed fme.exe python -m pip install pywin32 before import win32com.client but encountered a lot of error messages. Please see script attached. Please help. Thank you.

Can anyone please explain why with only 1 feature being read, more than 1 can fail? Any help would be highly appreciated!Many thanks!!

Does FME support reading Geosoft Geodatabse with the extension .gdb? If yes, which reader can be used?

I am trying to create a workspace that identifies consecutive duplicate point in DWG polylines. and outputs their coordinates for future review.As per my example, Autodesk AutoCAD DWG/DXF (normal reader or FeatureReader) does some autorepair on the features while reading. The DWG feature has 12 vertex in AutoCAD but only 7 in FME.Please see attached sample feature in dwg format.I want FME to read the same geometrie that AutoCAD gives.Using FME 2024.2.1.0 build 24801 

For some reason when I run inlinequerier on FME server 2022 I get the following error. 64 2025-3-31 16:49:13 | InlineQuerier (InlineQueryFactory): The clause 'USE_FMEOBJECTS Yes' within 'FACTORY_DEF {*} InlineQueryFactory FACTORY_NAME { InlineQuerier } USE_FMEOBJECTS Yes TABLE_DEF Swap_Data Title<comma>text<comma>Hyperlink<comma>text<comma>Region<comma>text<comma>Status<comma>text<comma>Event_ID<comma>integer<comma>Usid<comma>text<comma>Market<comma>text<comma>SubMarket<comma>text<comma>ClosedOut<comma>text<comma>ErcNode<comma>text<comma>SSD<comma>text<comma>SSV_Ready_Date<comma>text<comma>Q_5640T_Date<comma>text<comma>FA<comma>integer<comma>County<comma>text<comma>SSV_Rejection_Note<comma>text<comma>sharepoint_item_id<comma>integer QUERY_DEF Swa

I would like to create clusters of line data (geometry) for sampling, the geometry would be connected within each cluster. So far I’ve thought of:Create a bounding polygon > split it into X polygons using Tiler or some other transformer > SpatialFilter. This would be the easiest I guess, but this would create dead ends at the geometry around the polygon boundary. Ideally, I would like a closed/self-contained ‘route’ but not really necessary. SpatialSorter > group every X rows. But I realize this doesn’t give a nice closed-off route either and you would have to manually see how many rows to pick to create a nicer cluster so probably better off with the first option.Any better ideas? Additionally, it would also be good to be able to define a criteria for sampling like having X km of main roads and Y km of small roads in each cluster but I suppose that can come afterwards by calculating the counts per cluster and choosing clusters to hit the q

I am using FME Form 2021. I have a Point Feature Class with 100,000 points that includes 4 ID fields, all of which are populated with unique IDs. I want to simplify the process of creating new unique IDs from the existing ones, so I no longer have to manually enter each one when I add a new point.For simplicity, I will refer to the unique ID fields as Field1, Field2, Field3, and Field4. For Field1, the maximum value is 141386; for Field2, the maximum value is 592124.What would be the best way to do this in FME? I am looking for general information like what transformers and parameters I need to use; I think I need to use the Counter Transformer.My goal is to add a new point in ArcGIS Pro and then run the FME workspace to generate the unique IDs for that point. 

I’m trying to discover why my stand-alone python script cannot now ‘import fmeobjects’ after an upgrade of FME Desktop 2022.2 to FME Forms 2023.2.2.The sys.append path that worked previously had a python version subfolder inside the installation’s fmeobjects folder, like this:if os.path.isdir(rf"{FME_HOME}\fmeobjects\{python_subfolder}"): os.add_dll_directory(FME_HOME) sys.path.append(rf'{FME_HOME}\fmeobjects\{python_subfolder}") sys.path.append(FME_HOME) os.chdir(FME_HOME) import fmeobjectsbut those python subfolders are no longer there inside the fmeobjects folder in the Form current installation, but rather are outside in their own ‘python’ folder now. Is this correct? It seems that most of the searching I’ve done has the path to the python version as a subfolder of fmeobjects folder.No amount of appending sys.path versions of the python_subfolder

I am writing data to an excel file but when I open the written file, the first row of the file (that includes the column headings) is hidden and I have to manually expand it to show the headings. Is there a way to fix this in the writer at all? 

Hello! I want to use my phone to visualize the FME model I created in laptop.I am using FME AR app now. I don’t know how to log in.What is the Host URL? What’s more, since the FME AR app is no longer available in app store now (I download it long time ago but cannot use this app through other device), which software should I use to create the AR project? 

In Form (2024.1) the FME Flow connection is overwritten when creating a new database connection.This behavior is in our Citrix environment. Why is this happening and what can I do about it? Doesn't have a clue at the moment.