General

I want to extract specific lines from a log file, based on an regex. However, instead of getting a whole line as match returned, or even better a list of matches, I am getting <null> returned. What I want from the log file are all the warnings. I used an AttributManager and set the Attribute Value for the new attribute to @SubstringRegularExpression(@Value(_log_attr),^.*\|WARN\s{2}\|.*$,0,0,5)The last parameter is already misleading, since I usually do not have an idea of how many warnings there might be in an arbitrary log file, but for the sake of my test it would work.I would expect that the first match (out of 5) is returned. Ideally, a startIdx of -1 would give me the last of the five matches, but that doesn't work either. For the fun of it I was testing the same expression within a StringSearcher and here, there is a match. However, the attribute containing the matched result, who is supposed to return "the portion of the original search string that matched the regular expr

Hello, I was using a HTTP caller with a web connection fine on FME Desktop and Server - This was running fine on a daily schedule. I then realized that the HTTP caller needed to run in a loop so I got it working on both Desktop and server fine. The issue is, the workbench will only work for one day on the server, and then it returns a '401 Unauthorized' the next day. I find that if I re-publish the web connection, the workbench runs fine......until the next day. Does anyone know if this is a glitch or if there is some work around? The workbench was previously running fine until I added the loop and there hasn't been any changes to web connection each time I publish Any help is welcome!  Many thanks, Sam

I have a lot of LAZ files and generate a couple of polylines in ArcGIS. for these polylines I need to extract the points classified as 'ground' from the LAZ files.What transformer allows me to do that, and how to deal with polylines intersecting with several LAZ files?

Hi.I am wanting to utilize a webhook to kick off a process and have set up a sample site based on Send Source Data to FME Server with HTTP POST (safe.com).This example uses a text file to kick off the process but I am wanting to use the webhook URL with a parameter (key field). Is this possible? If so, what would I use as the initiator of the workspace and how would I pull in the parameter?  Any help would be most welcome! 

I'm trying to create an xml document where part of the information in the comment is coming from an attribute. However in the XMLTemplater everything within a comment is output untouched, including {fme:get-attribute("_comment")}. Thoughts on how to work around this?Attached is a sample workspace demonstrating the issue. Build 2022.0 If I create an attribute in advance: <!-- comment should resolve attribute @Value(_creation_instance)--> and use {fme:get-attribute("_comment")},then the braces are replaced with &ly; and >.If I use {fme:get-xml-attribute("_comment")},there are some xml parsing warnings:XMLTemplater (XMLTemplaterFactory): The following error occurred near line 1, column 51 of the query:XMLTemplater (XMLTemplaterFactory): invalid content passed to fn:parse-xml(): loader parsing error: Extra content at the end of the documentand the resultant xml does not contain the comment at all.

Hi all,  I have a strange error message in FME Server. I try to create a sqlite file, but it says it is locked. This file did not exist before running the Workspace. Transaction starts at 0.73 2021-12-2 16:37:35 | SQLite 3 Writer: Opening `\\fme-server******\resources\data\GIPOD\GIPOD_Beta_Token.sqlite' for write operation74 2021-12-2 16:37:37 | SQLite 3 Writer: Failed to open database '\\fme-serve********\resources\data\GIPOD\GIPOD_Beta_Token.sqlite'. SQLite3 Engine error: `database is locked'75 2021-12-2 16:37:37 | SQLITE3 writer: A fatal error has occurred. Check the logfile above for details76 2021-12-2 16:37:37 | JSONExtractor (JSONQueryFactory): A fatal error has occurred. Check the logfile above for details77 2021-12-2 16:37:37 | HTTPCaller_3 (HTTPFactory): A fatal error has occurred. Check the logfile above for details78 2021-12-2 16:37:37 | AttributeKeeper (AttributeKeeperFactory): SQLITE3 writer: A fatal error has occurred. Check the logfile above for details79 2021-12-2 16:3

Group ID should start from 1 for each unique Attribute 1 value and the smallest value of Attribute 2 for each Attribute 1 value should get it as follows:

Hello!  I'm trying to implement Otsu's method of image thresholding on an incoming raster, using the PythonCaller transformer.  I  have the following code block in the PythonCaller parameters, although my Python isn't great, so there may well be issues with it:import fmeimport fmeobjectsimport numpy as npclass OtsuThreshold(object):    def __init__(self):        pass    def input(self, feature):        #implement Otsu thresholding in native Python with numpy        #get the image from the feature        image = feature.getAttribute('image')        #compute the histogram of the image, then find the peak of the histogram         hist = np.histogram(image, bins=256, range=(0, 256))                maxVal = np.max(hist[0])        maxLoc = np.argmax(hist[0])        #perform Otsu thresholding        T = maxLoc        thresh = np.where(image > T, 255, 0)        #set the attribute value        feature.setAttribute('image', thresh)        #pass the feature on to the next transformer        se

This is probably very trivial topic but I cannot get the correct result from this: @ReplaceString(@Value(ATTRIBUTE),,,.) So idea would be to change e.g input value 1,6 to 1.6. Or should I change some FME attribute value to have decimal separator as . instead of , ? EDIT:I get it working by this workaround. Maybe there's is some fancier solution

Hi, I have 2 lines and they have real elevation value (z value). I want to add lines which exaclty middle of 2 lines. Also the new line should has actual z value . ( average z of 2 lines). How can I do?

My workbench consists of a ArcGIS online Feature Service Reader and Excel file that are the original and revised parts in the ChangeDetector. Then the Updated, Inserted, Deleted and Unchanged go to the same ArcGIS online Feature Service Writer now. This works perfectly fine and updates my ArcGIS Online Feature Service. The automation in FME Server also works if I change the excel in the Workbench.  My goal is that others can upload an Excel via an Workspace Server App and then see the change in ArcGIS online. If I use the upload function in the Workspace App and try to upload the updated Excel file it doesn't update the ArcGIS online feature service.  Is it not working because I'm using a localhost? I am trying to update from my server as well so I thought that should not be a problem. Or do I have to do it a whole different way in the workbench?

New workspace >> add Creator >> add VariableSetter >> define a variable name and a value >> add VariableRetriever >> connect Setter to Retriever.>> Run --> I get warning about Retriever being used without corresponding Setter. This doesn't make sense, they are clearly connected.Question 2: why does the Setter output use the name of the Creator (_creator_instance) and not the name I defined in the settings?      

Failed to open readerFailed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' readerFailed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationFailed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationFailed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' readerFailed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationFailed to obtain any schemas fr

I have adress points representing persons and attributes for each point including a categorization into age intervals. I also have a polygon grid to which I want to sum up all persons in each age interval to each grid cell. My output should be the grid polygons with a sum for each age interval, like this:"grid ID" "age 0_5" "age_6-17" 1 12 56 2 23 109 3 4 13I've tried several solutions eg. with "point on area overlayer" combined with the "list summer" but havn't been able to make it work. I use the 'generate list on an ouput area' option but my resulting "sum_" from list summer returns only "0" for all rows. Do I miss something with the lists buidling? Or any other ideas how this can be done? Thanks 

Specifying password on excel feature writer, for instance 'XXX_X', not possible to unprotect the sheet with same password.Excel edited is already protected with the same password. If protect sheet specs are not informed, excel becomes unprotected. Seems weird behavior...

Hello,  Just want to ask what is the specific condition in order for Create as Needed in the table handling be triggered? Thank you.

Hi I am looking for information on how to appropriately use the FME Command in a python loop using subprocess.popen to call the argument. I am struggling to find info on how to achieve this. I am getting syntax warnings in my command when I use subproces.popen. But if I past directly to the cmd prompt I dont have issues. So Im missing something. Any help is appreciated. Please ignore all my comments :P

Hello,I'm converting a ESRI gdb (of 21 layers) to shp with FME Desktop. Seventeen of the layers contain map objects - they're all good. But four layers do not contain map objects (2 x points, 2 x polys). For a very good reason, that I won't go into detail about here, I need to force at least one map object into those four empty shp datasets (a point into the point layers, a polygon into the polygon layers). The point can be in a random location, or one I specify. The polygons can be absolutely tiny. The values can be null. Is this possible within a FME workflow?

Is there still fmeobjects package supporting python 2.7 in FME 2022.2?I need to run an FME workspace in ArcMap, which uses python 2.7 and realized there is no fmeobjects for Python 2 in the FME installation folder. Is there an alternative way to do the job?

I've created a workbench in FME Database Edition 2022.1.3 that reads the existing metadata of a feature class in an ArcGIS Enterprise Geodatabase (SQL Server), and updates certain components of the metadata based on a table in another database where the feature class name matches the "Name" field in that table. This works for one feature class in the GDB at a time. Is there a way to iterate over all feature classes in the GDB and run the workbench against each one, one at a time? I've tried adding multiple feature classes as a Single merged feature type, and as individual feature types, and it is not updating the metadata as expected. It seems to update the metadata to the same values for all feature classes. thanks

I have a workbench that uses the FileCopy writer to move and rename an uploaded excel sheet, this works well when testing through desktop but when run via FME Server (the file is uploaded into a parameter) the following Warning is thrown and the file doesn't get moved; 2022-12-8 13:48:54 | File Copy Writer: Ignoring the destination filename 'DummyFile.xlsx' because the source dataset '""C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\upload\\Data Updates\\Geo-CustomerServices-TradeEffluentImportToSQL.fmw\\dbryant\\DummyFile.xlsx""' was not a file. Destination file names are only used when the source dataset is a file Is this a known limitation of FileCopy? I could use a SystemCaller and/or Python to get the same result but equally feel that this should work.

How to convert ArcGIS Online Quick Capture Latitude and Longitude coordinates to a projected X and Y coordinates?

I'm trying to create a count that changes whenever it sees an empty row in a dataset. For example, I have the first 3 columns and would like to create a column similar to Test2 (see image below) that has a new count whenever there is an empty value in Test in the preceding row. Any ideas would be greatly appreciated!

I created a Service account called svc_fme, and it has write access to a folder. The service account is what is setup for running the FME Server components except DB. Thinking same logic as Esri Service access for FME Service. I have an ETL on FME Server that is not writing to the desired location. How do I set this up?

I am getting following error while executing the workspace on FME server. However, workspace is working fine on the Desktop. Please suggest.The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {}