FME Form

I have to read several shapefiles that are in a second level zipped file. As an example:C:\\compressed1.zip \\compressed2.zip\\ layer.shp I get to reach the first level but when I try to reach the second level, FME gives me failures.Any idea? Thank you very much

Hi Gurus, How can we connect HANA DB using SSO? As per help available https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/sap_hana_nonspatial/add-sap-hana-connection.htm it tells you to specify the user name & password which is basic authentication. How can we use the SSO to connect to HANA DB. We already have many products like tableu or SAP BO they already connect using SSO. Thanks,Ajay

I'd like to learn how to extract end nodes (as opposed to nodes at intersections) from a list of nodes coming out of the TopologyBuilder. I'm only putting in a few alignments that intersect in the TopologyBuilder. I've seen some similar questions here but there wasn't enough detail in the answers for me to catch on. An example workflow or screenshot would be great.  

I would like create a MSWord document that includes a table that has 3 columns. The first two columns are just attributes, but the third should be a thumbnail image, whose path is stored in an attribute.  I can use the MSWordStyler to generate a table, I can also use it to add the pictures. What I haven't been able to figure out is how to add the pictures in the 3rd column of the table.

I have the xml file relating to a Geocortex Essentials site, from which I'm attempting to extract elements as FME features. However, I can't even get beyond parameters > elements to match, as I get this error: It seems to infer a format error? (I'm entirely new to XML, btw), but this site is functioning ok. Any ideas? Many thanks

Hi, I was asked to write a raster of an Digital Terrain Model to an Esri ASCII Grid file. However, the aim of the end user was to maintain a precision of 3 decimal values for the pixel values, so that the file size would not get too large.  To illustrate the question I created a short sample workspace.A visual preview of the RasterNumericCreators result is shown below;At the red dot (row,col) = (0,2), we can see that the pixel value is equal to '0.0250313' (using a ~'data value encoding' of 'Real32'). After the RasterCellValueRounder, we see that the value for this specific pixel is changed to '0.025' (as desired);However, when I write out the Raster to Esri ASCII Grid, and open the result in a text editer, I see the following (only first rows/columns shown);Specifically, the indicated pixel is written out with a value of '0.02503128908574581'. For this dummy file, the file size is 9.54 kb. If however I manually update the raster file so that the

I am trying to use the looping functionality to calculate the cumulative sum of values to match a certain value (budget). Those that are less or equal to that value are saved out as output and those that don't match should go to the loop and be processed again till all the features are processed. Any idea to make it working. Thanks

Hello all, I am trying to create a report header that is an image (left justified), some text (Centre Justified) and another image (right justified) but can seem to figure it out.  The images remain constant but the text will change as I want to create a "map book" series based on an attribute. My guess is that I need to add it as CSS but just need some direction as that is not my forte 🙂 Cheers Dean

I would like to try and create a map series using HTMLReportGenerator that will contain a map and a table where the user can select a feature in the table and the map zooms to the selected feature (or a new map is displayed) with the relevant information. Is this possible?

Hello, I have a satellite raster in GeoTIFF format and am trying to generate a grey8 image for selected RGB colours. Similar to what is in the attached image. Above is the RGB satellite image and below is a grey8 image for the selected RGB values with a "falloff" or "threshold value" similar to the photoshop selection filter.  I tried RasterExpressionEvaluator and the examples to give me some ideas but I'm not able to make it do what I want. This video shows the exact output I am trying to achieve - https://www.youtube.com/watch?v=Ha3HdYBzU_Q Ideally, I would like to split an RGB image into "n" most common colours using a "falloff" value, and export them as a greyscale "mask". Then I would import them as a blended texture in unreal engine. Appreciate any help!/Sanjay 

I am currently trying to extract the dominant value from a given row and populate a field with the dominant value from one of the dominant fields while associating it to another value in another field.  This is how to interpret the table in general.AreaCount1 is the count for area one in AreaName1 field.AreaCount2 is the count for area two in AreaName2 field.so... on and so forth. For example:For UniqueID 10 the dominant attribute from the six AreaCount columns is 1736 (see image below). I am able to extract the dominant value by creating a new DominantValue field and applying this math function @max(@Value(AreaCount1),@Value(AreaCount2),@Value(AreaCount3),@Value(AreaCount4),@Value(AreaCount5),@Value(AreaCount6)).   The math fucntion provides me with 1736 as the dominant value from AreaCount3 (highlighted in the image above). Now... I am trying to associate the dominant value with the AreaName that it is associated with. So for UniqueID 10 that has a dominant value of 1736 the dominant

I am trying to write from Excel to Azure. The writer table has no primary key as it is just a staging table and doesn't need one. FME will not allow me to write to it unless I set a primary key. Azure lets me write to the table within the server so it seems like it is only FME requiring a primary key. How do I get FME to write to a writer with no primary key? This is the error message (I am not creating a new table):Microsoft SQL Server Non-Spatial Writer: Failed to create Azure table 'dbo.test_survey' because no clustered index or primary key was specified. If creating a new table, go into the 'User Attribute' tab and set the 'Index' column to 'clustered', 'clustered_not_null', or 'primary_key' for a column And these are the settings

Hello everyone. I know there might be not too many using the DatasmithWriter (since I didn't find any question about it here yet). But I hope maybe someone can help or has an idea. I'm using the DatasmithWriter and got a surface that has a raster placed with the AppearanceSetter. This Raster has an Alpha Value (it's a branch, so everything around is meant to be transparent).When I write the DatasmithFile it tells me Raster could not be written (nothing more).When I remove Alpha Band it works, with Alpha it doesn't.I read Details about Datasmith, it says 32Bit, Alpha8, Int8.This is all the case for my Raster so im running out of ideas what might be the problem. Thank you in advance for any hints.

I'm reading in data from a filegdb which has an attribute of type float. I'm then writing the data to an ArcGIS Portal featureservice which has an attribute type of double. The data is read into fme with a type of 32 bit real and a value of 77.56, when this ends up in the Portal featureservice this ends up with a value of 77.55999756 Now I think I understand where the 77.55999756 comes from as if you convert 77.56 to 32 bits of binary and back again you get 77.55999755859375 But what I'd really like is for the double field to end up with a value of 77.56 (77.56000000000000227373675443232059478759765625) . Now i can achieve this by converting the attribute to a string and then to a 64 bit real value in FME before sending as an update to the writer. This then returns a value of 77.56 when i read the data back into FME which matches the value in the gdb. It also matches what would happen if I went into the portal front end and manually added the 77.56 value The question is, is

Hey There,I hope another set of eyes on this might help. I am having trouble with Python scripts and the Python Caller. I generate the error 000816, which I have tracked down to a possible conflict between 32 and 64 bit versions of Python conflicting with ESRI geoprocessing tools. I have attached a screen cap of the log. I have highlighted where I think FME is using 64 bit but I have set the Preferred Interpreter to the 32 bit in the Tools. Any thoughts? Many thanks and all the best!c.

I have a date being read in from a SDE geodatabase. It is in M/D/YYYY. I have the user input a year. I want to test it against the year in the table and only select the years that match. Is it possible to parse out the year in the tester or do I have to add in a DateTimeConverter Transformer to change the format?

We have an fme server installation running on linux with dynamic docker engines set up. We are using FMEServerJobSumitter but missing the control limit offered on the WorkSpaceRunner by the maximum concurrent processes or similar. I have gone over a few documentation and knowledge base articles to find how to limit the amount of dynamic engines processing on a certain queue to avoid exhausting all licensed engines available globally on FME Server . How safe recommends this ?  Regards,Jorge Vidinha

HI !i'm starting using FME 2018 and i would like to do something very special i don't know if i can do it ? So,i want to match two table with one attribute but sometimes this attribute is not the same in both.exemple :Table 1 : "restaurant le Bistrot" Table 2 :"auberge le bistrot" the special key word are not always at the same place. my first idea was to separate every word from one of these table in list with attributesplitter and using a "tester" searching at least 2 word from lists for making a match with my first Table but that doesn work. even with "matcher" do you know if my request is possible ? thanks !! Charles.

Hello Experts,I have a file in which I have 2 columns id and distance. The distance corresponds to the ids. The issue is that some ids are duplicates and the distance is different. I want to identify the ID which has closet distance associated. See the image attached. Any help would be appreciated.

Hi,I would like retrieve the date of a Excel file (in the reader). The date write in the Windows explorator.I would like write this date in a field 'version' of my new file (in the writer)Thanks a lot, 

Hello,I am trying to execute below plsql statement using SQLExecuter.But the declared variable (mId) is not populating select statement "mId" value. DECLARE mId number;BEGIN  select MAX (id) INTO maxId from @Value(table);  insert into @Value(table) (ID,@Value(columnsStr)) VALUES (mId, @Value(ValueStr));END; /FME_SQL_DELIMITER / Expected output during execution: insert into table1 (ID,name) VALUES (10, 'test'); FME Output during execution: insert into table1 (ID,name) VALUES (mId, 'test');  Thanks,G 

I tried to use WorkspaceRunner to perform a batch processing, but I didn't get the result I wanted.For example, I run 4 fme.exe at the same time in child workbrench and set the output result to same location. No matter the output location is Esri Geodatabase with 4 different names or with 1 same name, sometimes one or more fme.exe fail to write the correct result, some features will be missing.But when I set 4 different Esri Geodatabases as output locations, I can get the correct result. And this happens only when I use File Geodb Open API Writer, File Geodb didn't work either.I'am thinking maybe FME can't write to the same GDB at same time? Is there any solution to situation? Otherwise I have to do an additional Fanout processing.Thank you.

Trying this workspace, I get an error saying 'owner' feature type does not exist. The FeatureWriter output format is SpatiaLite and a template.sqlite database is used. For both feature types "Use existing" table handling is selected. Parcel geometry type is wkb_polygon and owner is wkb_none. The 'owner' table exists in the template. Could it be a FeatureWriter error managing SpatiaLite?  

Hi, Running a script to truncate an existing feature class in a sde that has attribute rules attached thru ArcPro. The warnings state the below items - table must exist - it is there, can see it via Catalog and SSMS. User has DBO. Running 2021.x FME, 2.9.2 ArcPro. Any ideas as to what I may be missing? Did set the compatibility to ArcPro, used sde connection created by ArcPro.Thanks,Lorinda2022-04-06 12:41:23|  1.2| 0.0|INFORM|Transactions are being used by the Esri Geodatabase Writer2022-04-06 12:41:25|  2.9| 1.7|ERROR |Esri Geodatabase Writer: Feature Class or Table 'IDF_Stormwater' must exist when Table Handling is set to 'Truncate Existing'2022-04-06 12:41:25|  2.9| 0.0|ERROR |GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details2022-04-06 12:41:25|  2.9| 0.0|STATS |GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): Finished sorting a total of 0 features.2022-04-06 12:41:25|  2.9| 0.0|INFORM

I have set up job routing rules and I want to test that the routing rule is working fine. I have added CPU%, Memory Peak Usage, and Queue in Display Column on the grid, but there seems to be a lack of functionality on the grid or I am missing something basic.  Usecase: I want to see all the jobs which finish within 2 mins, use < 20% CPU, use <2GB memory. and want to make sure they all were assigned Micro queue. -> I am trying to filter by queue but filtering by queue is not an option.-> Grid is configurable to hide and show columns, but I can't sort by columns or add any kind of calculated field in the grid.  Is there any easy way to export this data to excel? I tried dashboards but they don't have the fields I am looking for, maybe if someone who understands the database schema of the FME server can guide us I can get help from our FME Author to adjust the workspace/dashboard to include these extra fields & filters to make administration little bit easy. I am o