Transformers

I want to loop number of times (22), so, created Custom transformer. Tried embedded, didn't work, so now Linked Always with fmx.1. Unable to work out whats the issue, it works if just run for only one iteration (test purpose), so, seems no issue in both main & fmx (custom). 2.But an issue to loop, or going to next iteration 3.Could not change CustomTransfomer>Transformer Pramaters>Advanced > Maximum number of iterations or Attribute to holdl iteration count !? 4.However, I have used 'LoopRecs' for iteration from main to loop transformer and added 'MyCounter' for loop test. 5.Please note, added sampler, just to run 3 times for testing, but actually wanted to loop based on 'LoopRecs' variable, which is passed thru main to custom. Whats issue here ? I have spent a lot of time figuring out . . is this a bug ? tried to get help from our FME tech support here , no response.. Can anyone help PLEASE , getting really frustrated to figure out the issue ! 

The problem I am facing is I cannot figure out how I can send Answer value for Observation Question to the FME Server. I have been using this syntax: {"Address":"~~Location~~", "InspectionId":"~~InspectionId~~","Observation_Id":"~~ObservationId~~","Facility_Id":"~~Facility_Id~~","AnswerValue":"[~~AnswerValue~~]"} Also, I can find API documentation for the InspectionAnswer, but I am having trouble setting the right Syntax, so it will send Answer Value to the FME Server. Can someone help, please?Thank you

Has anyone worked with spatial indexing using GDB/SDE as output format? The spatial indexing function only appears for SQL Spatial formats. Any response is very much appreciated. Thank you!

I tried to create a global temp table in an SQL database to bypass limited database privs. Here is my FeatureWriter setting:No errors were given, but the temp table was not created on the SQL server tempdb. I tried using the fully qualified name tempdb.dbo.##MyTempTable for example to no avail. Appreciate any suggestions! 

hello, I'm having several java.lang.NumberFormatException: warning when writing to MS Azure SQL database. It does not prvent the workspace to run properly however, it create a very long log file with hundreds of thousands of warnings. Is there a way to correct that so that I won't have such warning anymore? Thanks

Unable to use Windows/IWA to login to FME Server Web Interface. Have followed all the steps, ensured the SPN is correct, ensured the service account is set correctly, done all the browser checks, and confirmed the Tomcat properties are right.Going to the URL <server name>/fmetoken/sso/generate throws a 403-Forbidden with a description "The Server Understood the request but refuses to authorize it". Going to the URL <server name>/fmetoken allows me to generate a token by using userid only. Adding the domain to the front of the username causes the token generation to fail. So it appears that it's something tied to the domain and how the users credentials are being passed but that leaves me unsure of how/where I missed a configuration that strips the domain during passing of the credentials in order to get a good token returned.Here is the message that appears when attempting to login:Here is the message from the sso generation

i am currently working on a task, extracting geometry from IFC file and point cloud and building solid meshes and compare them getting the differences. but as I use generated point cloud solid meshes and IFC solid meshes from IFCwall IFCdoor IFCwindows and IFC Column. but the geometry is always invalid when i put them in to CSG builder. how can i compare difference of two big geometry and what kind of geometry accept CSG builder ?

I try to make a custom transformer to do linear referencing of point features to a maximum of 10 polylines. Inputs are point features and polyline features with or without measurements. The custom transformer would output a list with the combination _kp{0}.KP, _kp{0}.DCC, _kp{0}.selectedRoute. The KP is the distance along the polyline, DCC is the perpendicular distance to the polyline (negative values on LEFT side of the polyline, positive on the RIGHT side), and selectedRoute name is the name of each polyline. At the end of the custom transformer FME shows the list being created for each feature, but it can not be used in the attributemanager following the custom transformer.

I am feeding all feature services in an ArcGIS Online group into a FeatureReader. I don't know the services or their attributes ahead of time. I can read all the records from these feature services but how do I dynamically expose their attributes? I can see them in an Inspector so they are there. I want to compare each feature service and its attributes with a corresponding feature class and its attributes in an SDE geodatabase.

Hello ,i am struggling with get the relationship between classes .i have Exported xml from arc catalog and I would like to find the relationship between classes .I have used the workspace here https://community.safe.com/s/article/geodatabase-xml-workspace-document-schema-readerlist exploder for data element ,I have chosen relationclasses but it seems for me , it does don’t show all relationship classes with others ( some are missing ) My target to find name of feature class and the feature classes related to it FME 2021 please if someone has sample workspace ,I will be appreciated .Thanks in advance

I'm currently using a CSV reader, Database Joiner and ESRI Geodatabase Writer. The join is working perfectly:  But when I connect the joined output to the geodatabase writer no records are written to the feature class in the file gdb and I get an error saying "Cannot write a non-area feature to an area feature class": I have tried both Drop and Create and Truncate Existing for Table Handling.  Any suggestions are greatly appreciated.

Hello, I'm trying to convert datetime format with SchemaScanner dynamically but I haven't been able to. I have Oracle tables (thousands) and am trying to migrate the data to Google BigQuery.Since it's nearly impossible to create an individual reader for each table and the corresponding writers, I'm using a dynamic Oracle reader and a dynamic BigQuery writer.In the data migration process, I need to convert datatime from Oracle to a different format so that BigQuery can ingest the data. When I was researching for an automated way to convert the datetime data, I came across the SchemaScanner transformer which in theory can detect datetime columns and convert the format dynamically. I've tried to place a SchemaScanner between a dynamic reader and a dynamic writer but it doesn't seem to do anything.In the "Date Handling" section of the SchemaScanner Parameters, I chose "Convert Input Date Format to FME Date" and I chose "Yes" for "

The ESPG library contains some reprojection methods. Is there an easy way to import a reprojection method from the ESPG library? For example, can you copy the text from https://epsg.io/8450 to create a new reprojection method in FME?

Hello everyone, I am trying to split a text with the attribute splitter. The text is formatted this way : text1 ( number1), text2 ( number2), text 3 (number3)… I want to extract only the value of the numbers to put it in another attribute. Can you help?

I am trying to read in two separate .dwg files, make changes, assign layer names with Feature Writer inputs, and then output to a single .dwg file. But, the data is not combined and it outputs two files from their respective reader instead.My hunch is that the Feature Writer is seeing different schemas coming in, but I can't figure out how to combine. This is one of those "seems easy, what am I missing" issues..I guess?

Hi everyone, I have some seismic cross sections that are in bitmap format. I would like to transform them into vertical georeferenced cross sections, something like this (https://gis.stackexchange.com/questions/295586/displaying-cross-sections-3d-volumes-in-qgis-3-x), and export them as 3D object if possible (I'm not sure wich format would be suited for that). I can create lines that represent the acquisition lines for those seismic images but I have no idea how to "hang" them vertically below the line. Does anyone has an idea if it's feasible in FME ? Thanks

Hello FME community, I would like to use batch file and FME to create a tool that is able to export an Excel file to a shapefile and transform the coordinate system at the same time.with batch file i get parameters from user. The sheet name and name of the columns can be different for each transformation. when I try to run the process for different file, Sheetname and Column name should be same as previous file and create shapefile without column or empty columns. I need my Read and Writer to automatically recognize new sheetname and Column name   

I have 2 PointClouds I want to merge their components using PointCloudMerger, however their x,y,z and coord values differ. They both represent scan of same building, but one has been set with global coordinates. I have applied Reprojector/CommonLocalReprojector but their location still differ. How do I change one of the PointCloud x y z values to be same other than forcefully changing it? And if I must change them by force what type are their in (Real64, Uint64, Int64, ...) ? Alternatively, how can I pass the component value from each point to other point cloud through an index method as both Point Cloud have same number of points and should have same index.   

I need to take serial tabular data and join or pivot it to columns joined on the common field UniqueID. I've been reviewing joins and mergers but cannot determine how to create this transformation.The resulting data columns should be UniqueID, longitude, latitude, Cat1,...Cat9 Thank you,Gilbert

Hi Is it possible to read a portion of a Cloud Optimised GeoTiff using a bounding box? I'm trying to use the GeoTiff reader with the search envelope set but just get an "Error occured during translation" message after the Geotiff is opened.  Thanks Tom

The output needs to be a horizontally flat line that is built on the values from the measure field. I would also like to insert a vertex at every measure change.

Hi,I think the best FME Transfomer for such type of extractions is the "XMLXQueryExtractor", but I do not know how to build the query.The XML is contained within an attribute and could be something like this: "<?xml version="1.0" encoding="UTF-16"?><value xmlns="http://spec.tn-its.eu/schemas/"> <gml:measure uom="kph" xmlns:gml="http://www.opengis.net/gml/3.2">50</gml:measure> </value>" For that particular case, I wanted to extract that "50" value from that XML.Thanks!   

I have a model that has to select rows(points) out of a large collection of large csv files. To encrease performance I want to go throught them one by one. What is the best way to do this?

Hi Guys,I am not familiar with Land XML files .....but i need to get a geometry out of this files...i attached a screenshot of my xml format structure...there should be lines in it....but i don't know to do it....i did it with this xml_fragment attribute and Geometry Replacer or GeometryExtractor but nothing happened Thx for helpFranco

I have got data as below  AssetID X Y Z A. 0 0 1B. 1 0 0C. 0 1 0D. 1 0 1E. 4 5. 6F. 9. 8. 7G. 6. 9. 5  am able to extract max of each row min of each row  how to obtain medium of each row as simple as possible ?  am using @max ( value of x , value of y, value z)@min ( value of x , value of y, value z)  medium ?????( plz note it’s not average or median of 3 value ) It’s exactly absolutely value the same as it is in excel files.