Authoring

See attached images. I'm trying to read a Geotiff of an engineering drawing. When I view it in 3Dpaint the pixel values vary between black, grey and white. But when I read it in FME all the pixel values are either black (0,0,0) or white (255,255,255). I want to sharpen the image by filtering out the grey pixels. But how do I read the file to expose the "grey" pixel values?

I have a gdb with domains with a lot of feature classes and tables. They all have 8 fields that are the same and the remaining fields vary from feature class to feature class. I want to populate those same 8 fields with the same value for all the features but maintain their schemas. I tried doing this with an attribute manager and writing with the template file geodatabase with the attribute definition set as dynamic. I've also tried adding the values to the attribute definition. I know there must be a way, I just can't figure it out! TIA

I need to write to a single excel file with multiple sheets using a template. I've created a template with multiple sheets formatted as I need them but when I write to excel, it will only write one of the sheets and leave the others blank.

import osimport requestsimport jsonimport cv2 directory = r'C:\\boatlaunch'for filename in os.listdir(directory): if filename.endswith(".jpg") or filename.endswith(".jpge") or filename.endswith(".JPG"):  print(os.path.join(directory, filename))  filenamepath=os.path.join(directory, filename)  url = "https://<servername>/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/EnvironmentAffair?createDirectories=false&overwrite=false"  head={   'Authorization': 'fmetoken token=<mytoken>',   'Content-Disposition': 'attachment; filename="test.jpg"',   'Content-Type': 'application/octect-stream',   'Accept': 'application/json'   }  print(head)  filedata = open(filenamepath,'rb')  print(filedata)     res = requests.post(url,data=filedata,headers=head)  print(res.status_code)  print(res.text)  print(res.request.headers)

In the ExcelStyler, it is possible to add a border style to a row.  It gets a value like:version<semicolon>1<semicolon>cell_border_style<semicolon>BORDERSTYLE_THICK<semicolon>cell_border_color<semicolon>0<comma>0<comma>0However, I only want to apply it to the bottom of that row, which is not available in the interface. Does anyone know whether it is a possibility to extend the current formatting value and apply the border style to the bottom only? Maybe something similar to:cell_border_type<semicolon>BOTTOM<semicolon>but then with the right values

We have a custom transformer Updater in FME 2019.0.2.0 which uses a DateTimeStamper to extract the current date and time into an attribute. Geographical location is Denmark.The custom transformer is called at 4 different places in the workspace and the last two are reporting the following message (only shown for custom transformer number 3): 2019-06-26 10:57:43|  50.4|  0.0|WARN  |Updater_3_DateTimeStamper: Failed to parse '20190626105743.717495+02:00' as a datetime value. For FME datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm. For ISO datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm#ISO-8601-Duration-Format2019-06-26 10:57:43|  50.4|  0.0|WARN  |Updater_3_DateTimeStamper: Failed to evaluate expression '@DateTimeCast(20190626105743.717495+02:00,datetime)'.  Result is set to

Anybody an idea why this combination would not work?The Shutdown script seems to not executed.Startup scriptdef initializeArcFM(): import win32com.client global app app = win32com.client.Dispatch('Miner.Framework.Dispatch.MMAppInitializeDispatch') runtime = win32com.client.Dispatch('Miner.Framework.Dispatch.MMRuntimeEnvironmentDispatch') app.Initialize(0x5) runtime.RuntimeMode = 0x4 print "ArcFM runtime mode", runtime.RuntimeModedef cleanupArcFM(): global app if app: app.Shutdown del app print "ArcFM shutdown"initializeArcFM()Shutdown script cleanupArcFM()

I have recently installed FME Server I have been working through some tutorials, and reviewing the examples installed on the server, to see if I can automate some things I currently do manually.  The first one I am working through is actually based on one of the tutorials in the server training material (Ex 3.3 here).  What I am hoping to achieve is that we can have an FME Server tool that the user can access, select from a list of arcgis online feature layers (things like watermains, property boundaries, etc), then the user can draw a polygon on a map to define the extents, and FME will output this data to the user, including ALL attributes within the selected Feature Layer. Currently I have the attached template, it kind of works, as in it successfully exports the correct spatial data, but for the life of me I cannot work out how to get the attribute data of the selected feature layer to be export to the XLS output file. As previously mentioned, the second thing I am trying to work o

I am trying to generate centerlines from parallel line pairs which are transformed into bounding boxes, then areas. This works but the centerlines do not extend all the way to the edge of the area/bounding box:There does not seem to be any settings in either bounding box, area builder, or centerline replacer to change this. Am I going to have to add a snapper? Any reason why it does not go to the edge? Thanks,@larue​ 

Hallo! I'm trying to set the folders in the zip-file for my data download service, as discribed in this question It works the first time I set the folders. But when I need to do a change in the zip-file order, the value of the 'Path to zip-file' are 'stuck'. Even if I edit them, they go back to the value they were initially set to. How do I get around this? Best regardsKicki M

Trying to calculate distance (Have been using nearestneighbour) but now require were we have a set of points in table 1 and a set of area features in table 2.We need to calculate the distance from each point to the nearest area feature but not its centroid, the requirement is to find the distance from table1 point to the nearest edge or vertex of an area feature from table 2 happy to hear ideas on how to do this thanks

We are trying to automate updating the metadata on feature classess, in particular at the level of the Entity and Attribute Information level for the fields in our feature classes.I have tried both methods of updating from an XML file or directly from the file geodatabase as metadata, but I can't seem to expose the information down to the field level of XML detail.We are basically trying to update the Definition & Definition Source of all attribute fields in the feature class from an table. see highlighted area below to show help explain.Is there something simply I am missingThanks  

I would like to know if there is any way that I can host an Fme Server application on my organization's website (for example) that is published using cPanel. What I would like to do is that through a public website, some of our clients can access a server application. I know that I can connect some other web application to the fme server using rest API or url webhooks if the server has a public IP address, which can be accessed from an external network. Can anyone enlighten me on this issue? I am just getting started in web development and these questions come to mind. Thanks

I'm looking for this article: https://www.safe.com/blog/2020/10/build-virtual-conference-booth/Does anybody know why it is taken down?

Hi I'm creating a DWG-file witch gets it name from the published parameter outfile. This works fine when I call the workbench directly from the desktop. But if I upload the workbench to the FME-server and then using the Data Download Service I get the default name instead of the supplied parameter.Here is an example of a http-request to the fme-server:http://localhost/fmedatadownload/SPIV/spiv2dwg.fmw?export_spiv_data_id=99&outfile=newname.dwg I first thought I somehow failed to supply a value for the outfile-parameter, but since the other parameter is working fine, I don't think that could be the problem... Regards Nils P.S I'm using FME Workbench and server 19.1 resp 19.0

HI, I've not used the HTTPCaller using a POST request and body attribution.The API call constructed by the developer has been provided like this:var client = new RestClient("https://sww.smartchartapi.co.uk/api/Authentication/request");client.Timeout = -1;var request = new RestRequest(Method.POST);request.AddHeader("Content-Type", "application/json");request.AddHeader("Cookie", "ASP.NET_SessionId=xcqkvogm2bp2yxshsgx1ncbg; AspxAutoDetectCookieSupport=1; __AntiXsrfToken=e680dfae824a472088c01d6672ba8471");var body = @"{" + "\\n" +@"  ""username"": ""SWWAPI""," + "\\n" +@"  ""password"": ""***""" + "\\n" +@"}";request.AddParameter("application/json", body,  ParameterType.RequestBody);IRestResponse response = client.Execute(request);Console.WriteLine(response.Content); I've set

I have to tables from ms sql server.table A: Task_postingtable B: Task_analysis They are joined by the transaction_id field. Now I need to get all Fields from A and add line_cost, Line_qty and Line_unit from B. What transformer is the best for this? I tried to use databasejoiner, but in the section "fileds to add" I cannot find the fields from table B 

My workbench run successfully but when I enable parallel processing on a custom transformer, and 'FME has stopped working' error/APPCRASH occurs.  I have tried:using only one group to process to rule out having too many parallel processes, I have tried setting to minimum, moderate processing. I have tried publishing to FME server and running.  All fail as long as parallel processing is enabled on the custom transformer. Does anyone know the solution for this?

Hi all,I am using an excel file containing several tabs. Each tab corresponds with a feature type in my data. And each feature type/tab has its own specific set of attributes I would like to write to several formats.  Whenever changes are made to this excel file (changing names of attributes, adding attributes, adding tabs, etc.), it does not update automatically. Even if I set the parameter 'Scan Schema in Dynamic Workflow' to 'Yes'. Every time changes are made, I have to delete the workspace resource and add it as a new.  Anyone having similar problems? Or solutions to this problem?Thanks!

I'm having trouble getting a dwg writer to write multiple files. What is syntax in FME desktop v. 2019.0 If I write .... *. Dwg - then there are errors - probably because it writes all dgn files to the same dwg file - If I do not write anything there are also errors.

I have a bunch of line pairs where each individual line has been assigned a UUID and is stored in a list: UUID_PARTS{} with indices 0 and 1.  Also have some aggregates of three which contain the same lines as the pairs, plus an additional line. They also have the same list attribute, where the indices are 0, 1, 2. The pairs and trios of lines are currently separated, but could be combined if needed. Have tried both list-based feature merger and regular feature merger on UUID_PARTS{0} or UUID_PARTS{1} with various settings, but no luck. My goal is for this to be flexible enough so it does not matter what index the matching UUIDs are and also handle aggregates with more than three parts, if possible. Any ideas? Thanks, @larue

I have a custom transformer that I have been periodically updating for a couple of years and I had it working so that whenever I opened a workspace that used the transformer it would ask me if I wanted to update to the latest version (yes). However, I tried editing the transformer in 2021.0 and the versioning seems to get lost. When I saved it, it is saved as version 1 (instead of v23) and when I opened a workspace that used it, it did not ask if I want to update to the latest version - unless I am missing something this is a massive pain because it means manually replacing the transformer, reconnecting all the inputs/outputs, and reassigning published parameters. I was able to recover my previous versioning info (which involved reverting back to 2019) but workspaces still do not ask if I want to update to the latest version of my custom transformer - is there a way to get this working again?

I want to create a sequence of numbers starting from 1 but ending at a certain point which it will decide from attribute value coming from the SQL executor, suppose the value came out as 100, then I would want to create sequence of numbers upto 100. How ?

Hi All, I am trying to identify the orientation of a line (clockwise/anticlockwise or left/right) so that I can use Orientator transformer if a line has been drawn anti-clockwise. In older post this seems to be achieved by using Azimuth Calculator on FME Hub; however, this does not seem to be currently available. Is there any transformer I can use or workaround to achieve this? Thanks,Ana

Hi list.This issue has been touched on several times, but I don't see a solution for me in any of the answers.I have to read a number of Excel spreadsheets, and being spreadsheets, they vary very much in both content and structure.I can read the spreadsheets with FeatureReader just fine, and I get both schema features with an attributes{} list of attributes, and generic data features with attributes in an unexposed state.How do I utilize the schema features to dynamically expose whatever attributes are present in the data ?Exposing attributes seems to be a design time issue only, and I haven't found any way to expose attributes dynamically.Alternatively, can a (MS/SQL) writer accept a list of name/value items, and output these to the database as fields with values ?I also need to merge several fme_feature_type's (i.e. multiple Excel sheets/tabs), so Dynamic Schema Definition won't work for me, I think.Cheers.