FME Form

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)

Get distance between multipoints within a feature in meters. Attached is file with testdata.

"Calculatearea" is the file containing the original data, Test1-3 are the different approaches I have tried shown in the workspace.

Hello everyone, I have road file. May i know how to find slope percent at every 12m.

I have a problem setting up a WMS background maps in FME from this site. https://kortforsyningen.dk/indhold/webservice-liste. I have tried a few different services but can't get any of them to work. AGOL maps work ok. The layer list is read ok so I assume the token is valid but the background map doesn't show when the workspace is run. Anyone got any suggestions how to fix this?

I would like to do this with the on-board resources of FME. The PDF-Reader can read out the metadata, but can I use the PDF-Writer to overwrite it without changing the rest of the file? An idea:How does the FME read out the metadata? If a library such as exiftool is used for this, then this could also be done using a command line with the SystemCaller.

For example: File 1 has 5 users changing data in the file. So data from File 1 would start updating, one after the other (I assume.) Meanwhile, File 2 has someone changing data at the same time. So those changes would start updating File 1. Is there a possibility of losing data between the files? Is this the best practice to achieve the goal. I am worried about losing data between the updates. Does this make sense?

I'm trying to filter records for the last three years of data but want to avoid having to edit the transformer on a yearly basis (ie. TestFilter: Year= 2021, Year= 2020, Year = 2019 - necessitating a yearly update at the change of the year). I'm hoping to find a way to set up an attribute filter or test filter that can be set on the relative time frame (ie. Year = this year, Year = last year, Year = two years ago). I'm guessing there is a simple way to do this with the text editor but I haven't been able to figure it out!

I have a table that i managed to extract 2 coordinates, but the coordinates don't show up for all rows how can i do this? Another question is that I'm going to process several files with different values ​​for these two fields, how can I repeat the values ​​for each different file too?   Thanks 

sql creator load the data always ,but sometimes i do not need this data to load and it takes long time .Could i write function inside sql creator that it should delay till we see if another specific transformer (tester - passed) has data or not .if yes so u should work ,if not so do not load ur data . How couldi achieve that ? Thanks in advance .FME 2018

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

Most of our pipelines use revit/dwg/dgn/csv files and for our ETL procedure we would like to store all these inputs using the same filetype in staging. Is there any type of data that would support this? other alternatives?

Using FME Desktop 2021. I have an existing field LicenseNumber with null values and with numeric values. I want to create a new field called License_Values into a table if the following conditions are met: Condition 1If LicenseNumber is null Then assign null values to License_Values Condition 2If LicenseNumber is not null (it has values) Then assign 123 to License_Values I tried AttributeCreator with a Condition value but it does not work at all. All it does is assign 123 to every record in the new field called License_Value (Condition 2) and it does not write the null values to License_Value (Condition 1) . My final objective is to have the new field with null values and 123 as long as the conditions are met.  Thank you, much appreciated.

Hello again, apologies for the questions, i am fairly new to FME and this one is baffling me. To me, this is a fundamental question, but through much research, I haven't found a solution as yet. I try to research before I post in forums.  IS there any way to write a bearing of my 3D Object on writing out to KML ?  Maybe I should rephrase this as I CAN actually rotate the object. What I would like to do as an option, is somehow have this parameter/attribute in the KML file so that when you click on the properties of the KML, you can input the Angle/HEading/Bearing at this point.  The ultimate goal would be to get all bearings from a CSV / External Data source, along with the model type to be used, and on writing to KML would have the correct model at the correct bearing. This is a big one actually and fundamental to a particular use case I'm looking at. 

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

Hello, I'm trying to extract a number out of my comments column. I'm not sure how to write the expression? or if I'm using the right transformer? I'm still new with FME. The number I am trying to extract is 8 digits and is put in comment field with this format "/ 12345678 /" an example of the format is below. VB BLVD / 59208085 / L06-514 / ATT 8547 Is there a way to extract this number?  Thank you!

How in FME would you check that two floats are "close", given testing floats for equality can be a challenge? e.g. "-23.123" as listed in an XLS compared to "-23.12300005" stored in a point feature class? In Python I use the math.isClose() or assertAlmostEqual() Thanks 

Has anyone experienced SMTP email simply not being sent using either the Emailer Transformer or the FME Server Automation Email External Action? I've had each of these things happen to me once, but the same Workspace or Automation run in most instances does send the email. The log file from a sent and not-sent email looks almost identical to me, I've attached both. These are workspace runs with the Emailer Transformer sending the email. I've asked our IT department if they can look into anything, but they can't say much since SMTP is just a relay. Also the fact that it works correctly most of the time makes it difficult to troubleshoot much further.Any thoughts or things to look into would be helpful.Thanks!

I have a SDE feature class that has a date field and another table that contains only 1 record with a date. I would like to query out the records from the feature class where the dates are greater than the date in the other table. The dates in the feature class and in the other table will change. I do not have a way to join the 1 record to the feature class records but I want to use the same 1 date to filter all records. The table with the 1 record could be text file or most other formats.Thanks, David

How to add points with numbers (1,2,3,4,......) over each point in pdf file .i have 20 points and i would like to write in pdf file but i have to count points and add the counting over each point .and what is the best method to resize the point ?How could i achieve that ? Thanks for helpFme 2018  

I am using Teradata JDBC4 Jar file placed in folder path of FME, when provided JDBC connection String like "jdbc:teradata://servername/DATABASE=DB_NAME"the libraries are getting loaded correctly but unable to establish connection. Attached error screen snippets

I convert input features to XML using XMLTemplater. Everything is fine as long it is done through the same sub-template. When I try to process some attributes (coordinates reading) by calling another sub-template it fails. This sub-template works properly **OBJECT Sub-Template**{<object  id="{fme:get-attribute("id")}"  visible="{fme:get-attribute("visible")}"  lon="{geom:get-y-coord()}"   lat="{geom:get-x-coord()}" ></object>} This one, calling another sub-template, doesn't work.**OBJECT Sub-Template**{<object  id="{fme:get-attribute("id")}"  visible="{fme:get-attribute("visible")}"  {fme:process-template("XY")} > Here is the syntax error: unexpected character "{" near line 4, column 5 .</object>} **XY Sub-Template**{ lon="{geom:get-y-coord()}"   lat="{geom:get-x-coord()}" } I did try a lot of things but I still don'

Hi, I would like to ask, does anyone know how to divide data into individual sets based on the same ID? For example, the result will be 5 groups of attributes with the same XOBJECTID.Thank you!!!

Hi everyone,  I have a simple workbench where I added a reader that reads 20+ featureclasses from a nationwide dataset from a file geodatabase.From there the workbench selects 11 featureclasses and uses the clip transform (clip polygon is a province) to clip out a certain area and saves it to a new file geodatabase. Problem with the workbench is that it has milions of features, and the machine I run it on will run out of memory after 5+ hours of processing.  Is there a way to split up the workbench so it will read/transform/write the workbench in 1 to 3 feature classes and waits till the memory is free again before starten the next 1-3 features classes? (maybe with embedding multiple workbenches?) thanks in advance! 

Hi FME colleagues,Neighbor finder transformer finds the nearest neighbor and allotting the same candidate to multiple bases. In my requirement, I need to pair the points from two set of data, but one base one candidate, that means one candidate should not be paired with more than one base.for ex : I have two sets of data, one is Blue and the other is REd. Now, first, the blue base comes and finding its closest candidate (good). Now the second base comes in and finds the same candidate which is already paired with the first blue base. this should not happen in my case, if it's already paired(i mean the closest candidate to some other base) then remove it from the candidate set. the candidate set should go smaller and smaller through the fme process. now what our neighbor finder does is matching with all bases to first(1) candidates. many to one. can we achieve this using any transformer? or any workaround within FME using python caller?