A space to discuss FME Form
Recently active
I am trying to use the string search command to extract the file names from a text string, Path attribute. by reverse searching the path string in order to establish the location of the last sub directory i.e. \\ @FindString(@Value(Path),\\,-0,caseSensitive=TRUE) The forward search works but I can't get the reverse (right to left) to work! using a negative startIdx
When rerunning my entire workspace, the transformers don't run one by one. They run to where all the transformers are being used at once and it takes an astronomically long time. It's faster if I run each transformer individually. Is there a setting to make each transformer run one at a time when I rerun my entire workspace?
Examples:10 > 105.1 > 5.0999999046325610.1 > 10.10000038146972720.1 > 20.10000038146972717.6 > 17.60000038146972720.3 > 20.2999992370605478.4 > 8.3999996185302735.3 > 5.30000019073486207.97 > 207.97000122070312
I'm struggling to find documentation or an article for this problem I am running into. I have a validation tool I created that checks for all sorts of different errors within a GDB. The errors that are caught are then written to ArcOnline where the data can be visualised. The validation tool handles mostly missing/null data. Once the null/missing data is found or fixed, you run the validation tool again to update the ArcOnline data. What I am trying to achieve is that the updating of the data is replaced based on a specific attribute- 'Project_ID'(PID). The ArcOnline layer could have entries for 'PID_1', & entries for 'PID_2'. If the tool is ran again and some existing errors have been remedied for 'PID_1', only those with 'PID_1' will be removed and updated, and those with 'PID_2' are left untouched. (When running the tool, the input data will never have conflicting Project IDs. So it is ran on a project to project basis.) Hopefu
Hi there I am trying to connect a reader to sharepoint to read some information in. When I press authenticate this is the error that I get. I was wondering if anyone knew how to fix this? All the best-Ed
Hello, FME Desktop users and educators, I hope you are all doing well. Today, I'd like to discuss a pressing issue I've encountered with FME Desktop while using it alongside classroom management software for teaching and geospatial data processing. It seems that there are compatibility challenges between FME Desktop and certain classroom management platforms, and I'm eager to hear your insights and experiences on this matter. As a geospatial instructor and avid FME Desktop user, this software plays a vital role in my classes for data integration and transformation. However, since incorporating classroom management software into my teaching methods, I've come across the following issues with FME Desktop: Screen Sharing Glitches: Attempting to share the FME Desktop interface during live classes or collaborative data processing sessions often leads to screen sharing glitches and freezes. These interruptions disrupt the flow of the lesson and hinder students' ability to
I have the lakhs of electric line features in FGDB , I want to find out the line features which are overshoot and correct those . Can you please help me with the FME workspace ?
Hi, I am using a FeatureWriter to create a Geopackage. Although I set the Spatial Column name as "SHAPE" it is changed to lowercase "shape" in the output. Can I prevent this behavior somehow or is there a workaround for this (e.g. renaming the spatial column with sqlite in a PythonCaller)?
Our salesforce writer credentials need to be updated as a workspace is moved between environments, there doesn't seem to be any easy way of verifying that the values copied and pasted are correct without running the workspace Any suggestions?
Either directly or using Python?
Hi guys, i'm having an issue when i run my workspacerunner. Undefined macro `UNIT' dereferenced in file `G:\\wb-xlate-1690810120428_4936' I't s workbench build in an older version (2021) of FME. And now i want to run it in 2022 FME version. But it keeps saying that error. I also tried to create an new workbench, with new readers.....but it won't work. What I am doing wrong? :(
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 workspace E:/supply/Stand
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?