Transformers

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.   Is there a way to just end up with the one bounding box feature which has the two attributes?

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 affected.We use FME to make a report of the Survey123 collected records so it is important that the dates are correct. I also see the issue if I read the data in FME Desktop.Has anyone experienced this sort of issue before?Thanks,Annette 

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 string 'Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=;Initial Catalog=GIS;User ID=;Password=********' My question is:  If t

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 ! Togmab

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 JSONFragmenter I don't experience this automatic conversion. Am I overlooking something and is this intended behaviour for the JSONExtractor, or is this some k

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 - WIN64)Thanks in Advance!!

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 you so much in advance!

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 !  

During my attempts to convert terrain made in FME (using the TINGenerator transformer) to IFC geometry, I have only managed to successfully store volumes. These are made by extruding flat surfaces to 3D extrusions. Then use the GeometryPropertySetter to set the Geometry Name to "Body". Then i store them with an Ifc writer named "IfcProxy". If I open this file with Solibri model viewer, it shows as a cube (screenshot 1).However, i cannot seem to store a flat object using this method. (Screenshot 2) Do you have any idea as of how to store flat geometry (instead of solid) using the IFC format writer?

I would like to import some Canadian grid shift files into another application but it does not natively read .byn files. Ultimately I would like to convert your fme-grids-b19253.zip package of Canadian grids into ASCII so that I can import them into my other application.

Hi im using DateTimeConvertor to convert the date format into this format YYYYMMDD. It is working fine but the problem is some features coming out of the Rejected port of the DateTimeConverter have had the date attribute values replaced with NULL. How do I resolve this issues?

Hi, I have a road network that I've been using the NetworkTopologyCalculator on to identify unconnected roads which I then discard to avoid drivers getting stick on an piece of road.But, what I've just had pointed out to me is that my method isn't catching all unconnected roads. Some unconnected roads pass under/over the valid road network, touching nodes, which the NetworkTopologyCalculator assumes are part of the valid road network. I have an elevation indicator for the start and end of each road segment, so I though by using the 3DInterpolator this would allow the NetworkTopologyCalculator to identify that the roads were not touching at bridges/tunnels, but this does not seem to be the case. Has anyone encountered such an issue, and if so are there any tools that might assist me here?ThanksRich.

Hi.I just tried (in 2018.1 x64) to add a Separator to the Page Content list. When I tried to move the Separator to the top of the page content list, both my previous Header and List items lost their settings.I also tried to put the Header and List to the bottom instead, but that resulted in much the same rresult.It looks like the settings aren't following the rearranged items.This looks very much like a bug to me.Cheers.

helloHow should I proceed to build the opposite (image) of a polygone (object) with respect to a line?