Transformers

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?

 I have a shapefile of polygons where every polygon represents a vegetation class with attributes like the  class code, class description and (R,G,B) values.I can rasterize with ImageRasterizer to generate a 4 band RGBA32 geotiff file with (R,G,B,A) values correctly assigned. The different vegetation classes is stored in a lookup table with this structure (no more than 50 entries):ID,CODE_CLASS,DESCRIPTION_CLASS,R,G,B1,100,Description class 1,255,255,02,200,Description class 2,24,95,205...To reduce the size of geotiff file I have generated 1 Band Greyscale (GRAY8) Geotiff (also with ImageRasterizer).  The result is correct, but I don't have any control about the value stored in band 0 and my lookup table describing vegetation class. QUESTION: How can assign the lookup table in rasterization process to 1 Band Greyscale (GRAY8) ?Is there a way to do this ?  Than you very much in advanced !

I am trying to extract png files from the website https://spark-viewer.wivolo.com/ I can extract the png files individually using the png raster but I have several png files I want to extract out. I was trying to extract a list of these png files so I don't have to do this individually. Unfortunately I am chasing my tail and going around in circles not progressing this. It doesn't appear to be a list as I have tried html table ie. trying to get a list of all the png images to extract. I also tried html extractor but this also isn't working. I'm hoping someone can point me in the direction to generate a list so I can extract all png files without doing this individually.

Hi Community,I have a lot of lines which are generated from raster centerpoints. All the lines consist of 2 vertexes. I would like to aggregate all the lines that touch to one feature. I tried this using the Linecombiner but this transformer doesn't connect lines when more than two lines come together. Any suggestions?

when we use the transformer to send SMS to an international number, we are getting this error ( The 'To' number 9665657892 is not a valid phone number)as you can see it removing the + sign from the number ( the number is only for reference)same test was done on twilio platfro and its working