Transformers

I am trying to get the sql like json queries to get the documents from 5 days ago in descending order. ( filing_Date -5days)what transformer to use and how do i pass the query?

Hi, @takashiI am getting a json file out of a http call. This json is very big and there are many nested values. I need to get some certain values from this json. For example, I need to get the "OTXMP_GPSLatitude". This GPS latitude value is existing many times in the json. I tried to extract this value using many json extraction querys but I get an empty attribute. Some of the json querys I used are : (json["data"]["regions"][*]["OTXMP_GPSLongitude"], or json[*]["OTXMP_GPSLatitude"]). I will attach the json file. I hope that someone can help me getting all the coordinates from this json by one request or json extraction. Thanks in advance,

I am trying to read data from a PDOK (Dutch open data portal) WMS service but having a hard time. If anybody wants to try, it's this one: https://geodata.nationaalgeoregister.nl/top25raster/wms?request=GetCapabilities&service=wms (but others from the same service have similar issues).I'm using FME 2019, but 2018 shows the same issue, it also doesn't matter whether I use a WMS reader or a FeatureReader. I'm not getting any useful errors, but other software (Global Mapper) has no problem reading the service. 

Hi! I have a problem which I am not able to solve at the moment. I have codes (as a string) including letters and roman numerals, in a style similar to this: ABCDE IV-a I would like to change this to: ABCDE 4-a  I was able to split the string into parts, so that I have a new column with just the Roman numerals. But how do I change those roman numerals to numbers in FME?  Thank you!

I have 70,000 routes which I need to combine into one layer/ network. So where the lines overlap I want to simplify that to one line. The intersector does this, but its been running since friday (6 days) and still hasn't merged them yet. Can anyone suggest a way to tile this process maybe, or any other way to speed up the processing?

I want to output a feature with a list (CITY) into a correct JSON array as described below. However, that does not work. Can somebody help me with it? [  {  "CITY" : ["Frankfurt","Hamburg","Berlin"]  } ] 

Hello all, I have an AutoCAD drawing that has two features on it. One is the bearing information and the other called derivation.  I am trying to create a new polygon feature that defines the bounding box of all features in the DWG that has the two labels above as attribiutes in the polygon layer.Currently I am using a combination of bounding box accumulator and attribute creator but I just end up with three records in the output polygon layer. One that is the bounding box, one for the bearing attribute and one for the derivation attribute.   

I'm trying to re-edit a CAT input file definition I was able to nicely define while I was adding the CAT reader to a workspace using the ruler paradigm. Now that I have added the CAT reader to the workspace, I can't seem to find a way back to add/extend/change the definitions using that editor. Any way back to that editor? I'm using FME 2019.  

I have a hosted feature service in Portal for ArcGIS 10.6.1.I can read the feature service with FME 2019.0.0.1 Build 19246 - win32. However the date fields are read with a value that is 2 hours earlier.In Portal for ArcGIS, in the hosted feature data tab I see the date that we entered into the service via the Survey123 app: 5/27/2019, 12:00AMWhen I read the same record with FME the value is 20190526220000: Both the Portal for ArcGIS Server and the FME Server are set to UTC +1 with daylight saving time. The time for both servers is the same.The hosted feature service was made via Survey123 - thus the data sits in the Portal. The field above is filled in with the Survey123 form but I also see that the editor tracking fields are

Hi everyone, i have drawn lines to split areas into new areas. I use a chopper to drop the areas and an extenter to extend all lines (to delete gaps) then i use an intersector to cut of the lines with each other.finaly i use an areabuilder to create all areas.But not all areas are created the right why . (green lines are the lines i have drawn) is there a solution to this problem. (i have allso used an anchorsnapper same results)

When using FME (2017) to extract a largish amount of data (~6,000,000 rows x 40 columns) from an Oracle database, the process is sometimes stopped, assuming by a DBA due to the size. However, FME returns with a translation successful message in the log rather than failure. Is this a known issue? or am I doing something wrong? or is there a workaround to catching this type of error? Like getting FME to do a record count beforehand. Note while I can get around the issue by breaking down the query. I would like to know if FME can trap/detect this type of issue.

Within a fme workspace, i am using the SQL Executor transformer to update a database table using the following SQL script: UPDATE [GIS].[dbo].[cadastreNSW_ProposedPlan]SET authority = 1      FROM [GIS].[dbo].[cadastreNSW_ProposedPlan] AS plansINNER JOIN(    SELECT DISTINCT DP,pcl_flg    FROM [GIS].[dbo].[vAUTHLot]) AS authorityON REPLACE(REPLACE(plans.ppn, 'D', ''), 'P', '') = authority.DPWHERE plans.authority != 2 AND authority.pcl_flg = 'P' This SQL script uses an embedded database connection.  When I execute the FME workspace the SQL Executor runs with no problems, updating the table.  However, when other users run the FME workspace the get the following error in the log file:ERROR |Microsoft SQL Server Spatial Reader: Failed to connect using SQL Server 2012 Native Client. Provider error '(-2147217843) Invalid authorization specification'. Connection

Hi,We have installed FME Server build 2019.0.0.1.I want to adjust the download url pattern using Admin > Services.The installation document does refer to the option here: https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Changing-Web-App-Server-Host-Name-Port.htm But the option is not present in the Administrator interface. See screenshot below. Have I missed something or is there another way to configure this in FME Server 2019? Thanks, Annette

I need to calculate the sense in which a line was created. The sense of the needles of the relay or the inverse one. The "orientation_extractor" does not give me the result that I need

I am trying to build a workspace that takes esri geodatabase points and converts their attribute values to MText. I completed this tutorial https://knowledge.safe.com/articles/38908/autocad-workflows-reading-and-writing-text-mtext-f.html I set up my workspace exact same as tutorial but I can get no output from Labeller at all. I hooked up inspector to fileGDB and the data looks good so I am wondering why the Labeller won't produce output can anyone offer insight? I attached workspace. geodatabase_file2realdwg.fmwt

Good morning FME ninjas,I've used a ListExploder to get some opening hours - I'm now having below problem:Per record the opening hours for each day are written in a separate line. I'd like to have all values in one line. How would I bring this data together?Thanks, Eduard

Hello,I have a point cloud for which I would like to extract the coordinates of the single point where the point cloud reach its maximum value.I can use the pointCloudStatisticsCalculator to obtained the maximum value of x. Is there a way to obtain the corresponding ordinates (y) and altitude(z) values for that x without coercing the pointcloud?Thanks

Hello,I have some pixels of my GeoTiff file who have this RGB combination (255,255,255). I want to replace these pixel values by (0,0,0).But I don't want a replacement of pixels who have just one or two values with 255, (67,255, 255) stay (67,255,255).I have start with this :I have separate my 3 bands (RGB) with the RasterSelector, and I have apply RasterCellValueReplacer on each band. But, I wonder how to do the replacement only if the pixel has the value 255 on each band (RGB).Thanks a lot,Joc

Hello, I've a problem with data.I've a csv file with columns following : « libelle_objectif », « libelle_objectif_2 », « libelle_objectif_3 », « libelle_milieu », « libelle_milieu_2 », « libelle_milieu_3 », « libelle_typtravaux » , « libelle_typtravaux2 », and, « libelle_typtravaux3 ». I would like to reduce the number of columns so that there is just only column « libelle_objectif », « libelle_milieu » and « libelle_typetravaux ». I need to create new lines to include the data of column delete. In my case, I've this lines following (data1.png) :I would like to get the lines following (data2.png) :What process can I to use with FME to transform my data ? Excuse me for my english.Best ! 

Hi folks,While I was extracting a nested JSON object using the JSONExtractor, it seemed like I stumbled upon an issue. Consider the following JSON:{    "integer_0": 2019,    "string_0": "hello",    "boolean_0": false,    "nested_item": {        "integer_1": 2020,        "string_1": "bye",        "boolean_1": true    }}When I use the JSONExtractor with target attribute 'boolean_0' and JSON Query 'json["boolean_0"]', it creates an attribute 'boolean_0' with value 'false'. So far so good.If I however use the JSONExtractor with target attribute 'nested_item' and JSON Query 'json["nested_item"]', it creates an attribute 'nested_item' with value:{    "integer_1": 2020,    "string_1": "bye",    "boolean_1": 1}In this case it thus seems that the boolean value of the json object 'boolean_1' is converted from 'true' to '1'. When using the JS

I want to capture metrics every time someone runs the workbench on FME Server. The metrics will include the timestamp, project (a user parameter), the user (parameter), # of features read, # of features written, # of files written, and how long it took. I don't really care about the format (excel, csv, rtf, dbf, ...) just that it needs to be cumulative. The workbench is on the server for people throughout the company to use and I need to calculate usage and value added to the projects.Is there anyway to do this?

@takashiI have a 3D wedge shape polygon which I want to make into a solid with the base being the lowest z of the polygon. I have tried solid builder etc. but can't get the output. Any help will be much appreciated.

We get the message below when we run the FME workbench with the workbench scripting set to ESRI ArcGIS Pro 2.1/2.2 (Python 3.6)"ArcObjects could not be initialized. ArcGIS required for the specified Python Compatibility 'Esri ArcGIS Pro 2.1/2.2 (Python 3.6)' "We're using an App-V packaged version of ArcPro 2.3.1 for distribution. We've made sure the Python 3.6 folder was outside the package bubble and placed in the program files directory on the local machine. We've also added that python 3.6 to the windows path variable. I realize this not the typlical method of using these two application together, however, we have users that use FME and ArcPro on the same machine. Our software distribution is managed via App-V. How or what is FME looking for to determine if ArcObjects is installed? It doesn't appear to be the presence of the esri 3.6 python libraries.We're using version 2018.1.0.0 (20180717 - Build 18520 - WIN

Hello everyone! I am very new to the world of FME (and already very intrigued) and I am working on a use case that I can not quite figure out yet. So I have points going into a certain line. I want to then export the points to AGOL, but not all at once. I want to make it look like one point is moving across the screen in a certain line. So basicly I need to know if there is a way to replace the point on the screen with the point that is next in the attribute table. For now I want to just try this out by running the FME Workspace over and over to see if the point moves the way I want it to, but when I finally have it figured out I want to add it to an FME Server to make it look like a live data stream. I am sorry if this is a dumb question but I have been trying to figure it out for the past 3 days. I already tried the StringReplacer but maybe I am doing it wrong. I also have a counter in place What to do? Thank yo

Hello community,I have mutliples raster (jp2 with .tab) in multiples folders like the example below : folder_name_1+ -------001.jp2+ -------001.tab+ -------002.jp2+ -------002.tabfolder_name_2+ -------003.jp2+ -------003.tab+ -------003.jp2+ -------003.tab I want in output zipfiles that contains all files, and which take (as attributes) the name of the folderfold_name_1.zip (that contains 001.jp2, 002.jp2, 001.tab, 002.tab)fold_name_2.zip ... I have searched with filewriter, filecopy but i can't make it through.Have you any advices ?I work with FME(R) FME Professional Edition 2018.1.0.2 Thanks in advance !