FME Form

Has anybody tried using a Loupedeck with FME? I just got myself one, primarily for my Illustrator work and photo editing (hobby) but since it's programmable I figured I'd give it a try with FME too. Basically it's a little thingamajig that connects via usb and has a bunch of programmable buttons and dials. It comes with presets for various applications like Photoshop, Illustrator, video editing etc but you can also create your own mappings for any application. I've mapped most of my often-used transformers to it as well as some general tools (zooming, running etc).

Hello , i have read text file but I see only one column in FME Important data starting from fifth column fifth row include the name of each column | col1 |col2|col3|col4| col5|rest of columns include data like this |..0383004|Abcd…………|383903…..|Dhaka Gheny 2|………|I see in one column all data ,as what I explained above .i would like to get the data into excel file .i would like to export the name or number between | | so I need to have five columns and each column include the data that belongs to this column as text file  thanks in advance FME 2021   

I create alayer by overlapping some polygons and save the results in an oracle tabe. When trying to open that table in ARCGIS, I receive the error message [The number of points is less than required for feature]After doing some research, it was stated that the arcsdegridSanpper can be used before the writer but it now depreciated and therefore can not be used in my workbench since I'm using FME 2021. How can I solve this issue?

One thing I prefer to do when building a new FME tool is to log the input parameters in a startup python script in order to facilitate debugging when things go wrong. A sample of the code I use is below.import fmeobjects fmeobjects.FMELogFile().logMessageString("Input parameter 1: ") + FME_MacroValues["parameter1"], fmeobjects.FME_INFORM)fmeobjects.FMELogFile().logMessageString("Input parameter 2: ") + FME_MacroValues["parameter2"], fmeobjects.FME_INFORM)This has worked great for a long time, however it's cumbersome because I need to manually enter the names of the parameters. I'm curious if there is a method for returning the names of parameters dynamically in the startup python script, and then loop through them to include in the log file. If this is possible, I could keep my startup script the same between all tools and simply copy it into new tools without having to modify. 

How to get home licence in fme 2023 version

i have multi rows coming from the source and I want all that rows in one single row and layout same as I mention below Data Source coming like thisI want Output like this in one single Row and the same layout

When viewing (in FME server) my workbench that I uploaded tot FME server I see different Advanced Feature Type Parameters settings then in my Workbench on FME desktop. In my workbench the settings of my writer are 'insert, drop and create' after I upload the same workbench to FME server the settings in server seems to be 'insert, create if needed'.Why is that? I do not expect the settings change while uploading tot FME server. If I run the workbench from server the outcome is that the writer used the 'Drop and Create' and not the 'create if neded'...this behavior is confusing settings in my Workbench on desktop: the settings in FME server of the same workbench after uploading to server:

Hi together, I am trying to add new geometries to an existing dataset, but always my new geometries got rejected. I was using the FeatureMerger, FeatureJoiner and Dissolver, but it will not work at all to add them as new elements.  Does anyone has a suggestion to me what to do? Thank you very much :)

I am trying to extract a PDF attachment from an ArcGIS Online feature layer and write it to another online program using the HTTPCaller. (I can do so with CSV attachments.) I can see the PDF is being read by FME Desktop (2020.1.2.1 - build 20624); it's in the arcgisonline_attachment{0}.data attribute but I'm not able to successfully write the PDF contents to the other program. Other forum posts indicate I should use the BinaryDecoder first but it won't decode using either option - Binary64 or HEX. I get an "Invalid Base64 character '%'" or "Invalid HEX character '%'" error. I tried using no decoder and writing the contents of the arcgisonline_attachment{0}.data attribute to the output location directly but get the following error: Received HTTP response header: 'HTTP/1.1 400 Bad Request: Invalid .pdf file.'. What do I need to get the contents of the PDF in the proper format so I can upload it?

We have photos in jpg format that were taken with a DJI drone. Usually all EXIF data are easily accessible using the JPEG reader, but not the DJI custom metadata. We need to access the data that shows up when opening the image in a text editor: I tried reading the files with a text reader, but that gives several thousand lines of text and no way of seeing which line of text is connected to which image. This should be a common problem for everyone with a DJI drone? Any suggestions for now and maybe a DJI photo reader or DJI EXIF reader in the future?

I am automating a process of creating a Service Request on City works suing an Email (IMAP) topic and notification on FME Server. However, when email is received, my Workspace reads (JSON reader) it as an html instead of plain text and charset- utf=8; I have JSON extractors and HTTPO caller later in the Workspace and therefore due to this problem fails to create SR. I am attaching an image from the log file. Any feedback is much appreciated.

Happening in Parent just before Workspace RunnerExcerpt from log:WorkspaceRunner_2: Running FME Workspace E:\\supply\\Standard_Supply\\SQL_Server\\10km_Buffer_to_SQL_Supply/SQL_Server_County_10K_Buffer_Supply.fmw with command line:2023-07-25 16:30:02|  1.0| 0.0|INFORM|WorkspaceRunner_2: {C:/Program Files/FME2021/fme} E:/servername/Standard_Supply/SQL_Server/10km_Buffer_to_SQL__Supply/SQL_Server_County_10K_Buffer_Supply.fmw --INPUT_POLYGON E:<backslash>supply<backslash>Common_Dependencies<backslash>Esri_Shapefile<backslash>10k_Buffer_Local_Authorities<backslash>COUNTY.shp --QUARTER 2023Q3 --OUTPUT_COORD_SYS IRELAND-ITM --SQL_SERVER_BACKUP {\\<backslash><backslash>servername<backslash>e<dollar><backslash>SQLData<backslash>CountyCouncil<backslash>ITM<backslash>2023_Q3<backslash>COUNTY<backslash>2023Q3_COUNTY_ITM.bak} 16:30:05|  1.0| 0.0|WARN |WorkspaceRunner_2: Failed to run w

I am trying to change the authentication from local to windows authentication in Cityworks. What changes do I need in HTTP Caller parameters? Is the chosing NTLM (username, password) under "Authentication" section enough or do I need to add something under "Header" or other parameters?

Hi folks, I have LAS files that are in zipped and stored in a folder. There are 16 LAS files to each zip. Furthermore there are about 100 zips in the folder I'm accessing the data from! The zip files are about 2.5GB on average and I would like to process each zip at a time (sheet1.zip, sheet2.zip etc). I'm adding height attribution to building polygons using a clipper which is a blocking transformer, then the point cloud statistics calculator. I can use the Directory reader to produce a list of zipped files and feed these into a Feature Reader, then use a clipper to clip the LAS data to the building polygons. However the clipper is a blocking transformer which will wait for the FeatureReader to finish. Ideally I want one building polygon dataset for each zip (sheet1.shp, sheet2.shp etc). I need to somehow loop back to the start of my workspace and start again with the next file on the list produced by the directory reader. Anyone have any ideas?

I'm trying to make a dynamic transformer that uses a feature writer to create a temporary file in some format (FFS, CSV, Parquet, doesn't matter) and I need to supply a schema line for the Feature Writer to accept the incoming features. Most readers won't supply one such line, and even though FME is keeps track of some sort of attribute type tag that AttributeMapper is now able to modify, and that

I'm looking for information regarding writing features to geopackage with geometry compatible with Geomedia. I have found the article dealing with Geomedia geometry in Oracle (listed below), but nothing for geopackage. In my testing, FME successfully writes, but the tables are not visible in Geomedia. https://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/oracle_spatial/GeoMedia_Geometry_Repres.htm

This is more format than FME related but I want to make sure that FME is not the cause of a problem I have with reading a geopackage. I created a workspace that downloads a geopackage from an API and reads it with a FeatureReader for further processing. The geopackage contains a point, a line and a polygon layer but for some reason all 3 layers have the geopackage_type "geopackage_linestring" and fme_geometry "fme_line" in the format attributes (example in the attachment). I created a separate Geopackage with the same geometry types in QGIS and here FME returns the correct types so I'm guessing the geopackage from the API has some SQLite metadata that is not defined correctly. I already checked the metadata in QGIS but here the layer informations show the correct types for each geometry. What or where could be the cause of this problem?

Is there by any chance some kind of 'Paste as Text' option when Copy-Pasting text (often from online sources) to Annotations in Workbench? Personally I sometimes copy online sources to Annotations. However, I constantly struggle that also formatting is copied. For example, when I copy the following from this FME Community question;and paste it in an Annotation of FME Workbench, the result is;Whereas I would like to get;Is there some option/menu in FME Workbench to do so? I'm looking for something similar to the 'Keep Text Only' paste option in Microsoft Office.

Hello friendly FME Community! I'm trying to implement a GeoFencing service which will calculate the time spent by vehicles in particular areas. In short, I have a set of points (with timestamps) and set of polygons (geofences) against which I want to calculate how long these points were inside these polygons.  I did make a workspace which does this using SpatialFilter (which identifies if points were inside polygons) StatisticsCalculator which calculates min and max timestamps and DateTimeCalculator which calculates the interval between this min and max timestamps. The problem is that vehicle can move out of all polygons and then get back which will distort the calculation as the period that vehicle was outside the polygon will be included because last timestamp will be inside the polygon. Is there any trick or technique in FME which allows to follow up these gaps and exclude them from calculation described ab

I have a few AutoCAD drawing files (.dwg) that have a number of 2D and 3D lines and polylines. My goal is to extract all the vertices of each individual line so that I can store it within my GIS database (PostgreSQL). Additionally, I want to extract the layer name and a few other attributes.  Is there a way to extract this data and convert it into a Shape file (.shp) ?  Cheers

I am unable to find online if FME can read data from Power BI. We currently us an SSRS to pull data from multiple sources and write them to a xls file. According to our developers Power BI can't write an xls file the same way so we were wondering if FME can reach into Power BI to pull data out as a reader in the workbench.

Hi, I have a scenario with a random string test; "Häradålderön" which my goal is to se the result to "Haradalderon". Basically replace any [ä, å, ö] with [a, a, o] letter.  I guess using regular expression could do it, but I find it tricky since it might be three sequences to search for ä, å, ö. Any ideas appreciated!

I would like to write some messages to the Log, at the end of a successful Translation.For example, the source schema & table name and the destination schema & table nameIs there a FME Transformer that can write a user parameter to the Log? With some surrounding text?

I am trying to get the result when both "insert" and "unchanged" have values, but if one of them doesn't have a value, it's going to fail. Can anyone please help?

Hi. I aim to reproject the coordinate system EPSG:25832 to a metric coordinate system. Which destination system do you recommend?