Transformers

Hi Folks,we are trying to save json request/response data into oracle database using SQLExecutor and getting following error java.sql.SQLSyntaxErrorException: ORA-01704: string literal too long Request that we are trying to save is more than 6000 characters. Appreciate your suggestions ?

I have the problem that the characters >< that I have inserted in the AttributeCreator are converted to > and < in the XML Templater.

I have a coordinate system definition from a ESRI shape *.prj -file.It seems to be EPSG:3411, even if there are small differences in the definition. How can I create a costum coordinate system to use on both FME desktop and server?The tool her https://demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw does not work. I would appreciate any help with this:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/coordinate_sys_custom_about.htm Thanks. Here are the definitions: *.prj-filePROJCS["NSIDC_Sea_Ice_Polar_Stereographic_North",GEOGCS["GCS_Unspecified datum based upon the Hughes 1980 ellipsoid",DATUM["D_Hughes_1980",SPHEROID["Hughes_1980",6378273,298.279411123064]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Stereographic_North_Pole"],PARAMETER["standard_parallel_1",70],PARAMETER["central_meridian",-45],PARAMETER["false_

We are migrating data from Smallworld Electric Office 5.x data into ESRI Enterprise Geodatabase(SDE), while doing the process we came across one difficulty to export the data for the table named "Cable Existing Phase" which stores the relationship between main tables and unit tables in Smallworld native environment.We used the below parameters for the Smallworld readerReader: Smallworld 4/5Service: FMEExpose Internal Tables: On Please refer to the screenshot of the tables which we are getting after using the "Expose Internal Tables" as ON. Here we are missing a table called "eo_cable_exi_phase". Without the "Cable Existing Phase" table in the target environment, we can't build the relationships between feature classes. Is there any alternative approach or any other plugin (SBS) to resolve the issue     

Hi all,I have a set up FBX mesh tiles in one coordinate system (GDA94 MGA56) and need to reproject to another (BCSG02). When I try do that in FME, my 3D meshes get flattened to 2D images. What am I missing here? I am using the out of the box FBX reader & writer, and a reprojector transformer? Thank you!

I am having trouble understanding the documentation for the JSONUpdater tool. I've put together a simple workspace (attached) that demonstrates my partial success. I want to create a GeoJSON file from a shapefile. I can successfully do this with FeatureWriter. So far so good. See screenshots 1. and 2. below.  Now I want to add a key-value pair to the root of the JSON object that would identify the edition of the collection -- as shown in screenshot 3. So I include the JSONUpdater transformer. as pictured in Screenshot 4. below. I've tried a lot of options in this transformer but nothing I do has any effect on the json file. Can someone give me a hint? Screenshot 1: Workbench diagram Screenshot 2: FeatureWriter ParametersScreenshot 3: Geojson I get. Screenshot 4: GeoJSON I want.Screenshot 5: JSON Updater Parameters.

After we upgraded to v1.0.0 we starting getting a ton of datatype errors.The Athena Query was working fine and writing results but the connector was choking on such things as decimal to int casts, and some random strange errors on cols we have never had issues with before. I started to resolve some of them by switching to bigint, but then another one in the stream would fail. Ugh. We have close to 75 Athena Mappings, so we reverted back to the previous version. Solved everything. If we had not, we would have to modify things like casts and decipher some other strange errors on many of those 75 mappngs. Anyone else having issues with v1.0.0?

In my example below I have two different attributs: the asset and group, group A being highest priority then B and then C. I would like to keep only 1-A, 2-B , 3-C and 4-A. How do you filter the other ones out?Asset - Group1 - A1 - B1 - C2 - B2 - C3 - C4 - A4 - C

I am trying to extract the orientation / angle / direction of a 2 node line. I cant believe there isn't a transformer that simply extracts the orientation of a line but I cant find one. Anyone found one? I want to be able to compare the orientation between two lines which are close to each other to determine if they are in the same (or similar) orentiation. Thanks

  i have tried to use intersector and topolgoy builder to identify nodes that intersectedbut i am not sure how could i recognize only the node of starting branch because some node has 3 overlaps and one at the end has only two overlaps .it means only two lines intersected with eachother ,So it will be hard to recognize by overlaps because At some branches to red point ,the lines intersected to eachother ,so it will have also 2 overlaps. each line has his own id but from the vertex in front of Grey Arrow has 2 or 3 Lines till reach End point .the main line has many connected linesi have tried with neighbor finder but my main problem how could i recognize the the vertex in front of Grey Arrows .Is there way to use neighbor finder and add Tester to stop at Vertex in front of Gray ArrowFME 2018 Thanks for help in Advance    

Hi all!I am trying to style the headers of my excel list, based on their name.With the Excel Styler I figured out how to style several values, using conditional values.However, what I want is to style headers, not values. How can I define header of column to style? Is it possible?Thanks in advance!

I have a list which has two elements {make, model}. I can receive multiple make, model in in this list. So, I can get values like:{make = Toyota, model =camry},{make = Toyota, model =Prius} and so on.I need to use these values create a sql in the format - select * from cars where (make=toyota and model = camry) or (make = toyota and model - Prius); How do I achieve this in FME? I dont know the no. of values that I will get in the list. Please advise, I am very new to FME

This is how I it get, with different tabs. And below is how I want it.

I have a table that has x and y coordinates. I am trying to write to an sde point feature class and it is failing. The error message is that 'line' features can't be put into a point feature class. Each record has one x and one y value. The log says there are 2 coordinates (which is why it's trying to make a line), but I have no idea why its seeing 2 x values for any record.  I exported as lines and got the correct number of lines of 0 length. They actually are in the right place in GIS. Light on details, but if anyone has hit this snag and recovered, I'd love to hear about it. There is NOTHING weird about this table. Sensitive data so I can't provide details. Actually, it is only some records - an identifiable set - the other records will create points. I see nothing different about the records that fme wants to turn into lines. Thank you,Randy McGregor

"4;30;4;20;SW,SE",,, Here is my attribute string, I want everything between the quotes to be split at the ; and the rest to be split at the commas. (There are no values held there in this example.) Please help. m

Hello,I often use SQL creator and SQL executor to extract data of my dB.My select-queries always include the oracle geometry (stored in a SHAPE column).However, I noticed only in some cases the geometry is extracted in my workflow.I have, to this day, not been able to understand in which cases this works and in which it doesn't (I then add a feature merger to re-append the geometry to the features).Can someone explain this to me?Thank you

I am getting an invalid layer message when trying to open a raster in QGIS. This raster I have imported into Postgis using FME. I was using column=rast . I have set the coordinate system as the reader, but when importing the SRID is not being written.  Invalid Layer: Raster layer Provider is not valid (provider: postgresraster, URI: PG: dbname='xxxxx' host=xxxxx port=5432 user='myuser' password='mypassword' sslmode=disable mode=2 schema='myschema' column='rast' table='GEOTIFF' Any tips, how to fix this?

Hello everyone, I need your help with AnchoredSnapper, basically I have two vector layers:  - linear layer which is in the form of a road network. - point layer (Camera positions).  I would like to attach these camera points to the road network, what I have problems with is the areas where we have road intersections, I don't know how to configure it so that it snaps the points to the right segments, if you go to the image link, i tried to show you that the last point is attached to the correct segment, but in reality it is going to be snapped on the other segment which is closer to it. So if you have any answers, I'm interested, and thank you link image: https://zupimages.net/viewer.php?id=21/25/2nrm.png

Hı,I want to extract certain color codes from the photograph. I tried but I couldn't. I want to get the white areas in the sample image . how can I do it. Thank you

Hi, I am new to FME and have just started doing the intro to desktop training material. I am doing Exercise 1.1 where it asks me to run the process but I keep getting this message KML: Cannot open dataset `C:\\FMEData2019\\Data\\Boundaries\\LocalAreas.kml'KML: Error initializing reader and I don't know how to fix it? Can anyone please help? I would appreciate it .

The online custom coordinate system generator does not appear to be working anymore.  @daveatsafe​  - any ideas?

Hello everyone, this is my first time writing in the Forum, by the way I am coming to you for a little problem on FME. To get you up to speed, I have two layers:- Road network: consists of several numbered segments.- Point layer that represents the camera location. After the application of Anchored snapper in order to attach the camera positions on my road network, my goal is to assign to each entity of the attached point layer, the distance from the origin of the segment on which is attached of the road network, please find attached an image by which I have tried to present my problem, thank you in advance for your help. Link Image: https://www.zupimages.net/viewer.php?id=21/25/1sxs.png

Hi I’m finding when reading an Excel Worksheet containing only headers in Row 1 and no other data that I have one feature read with <missing> values for all columns.Surely if there are no rows there should be no features read?Process:New Excel Workbook containing one Worksheet and create the header in row 1 as follows:In cell A1 enter MyCol1 and use the right arrow to store that value in the cell and move to cell B1.Enter in cell B1 MyCol2 and use the left arrow to return to cell A1.This ensures that no other cells have been interacted with.Read this Workbook with an Excel reader and it returns one feature with missing values for MyCol1 and MyCol2.If you actually have data in row 2 you also get one feature read correctly.Thanks

Hi all,I'm trying to read from a Postgresql DB (postgis) applying a spatial filter using the SQLCreator transformer.Here's the sql statement set in the transformer:SELECT capture_start, capture_end, metadata_url, status, project, geom FROM "public"."Metadata_Index" WHERE ST_Intersects(ST_Transform(ST_GeometryFromText('POINT(142.94 -37.28)',4326),7844), geom) This is the error I'm getting - it's logged as a warning but definitely what is failing the process:2021-06-23 13:07:41| 1.7| 0.0|WARN |Error executing SQL command ('declare "public_custom_query_crsr" cursor for SELECT capture_start, capture_end, metadata_url, status, project, geom FROM "public"."Metadata_Index" WHERE ST_Intersects(ST_Transform(ST_GeometryFromText('POINT(142.94 -37.28)',4283),7844), geom)'): 'ERROR: GetProj4StringSPI: Cannot find SRID (7844) in spatial_ref_sys'I've read through the docs available on the Safe websit

Hi there, I want to know if there is any method to read specific sheet only by using Excel Reader, e.g. I have multiple Readers in the same workspace to input various datasets, one is EXCEL, the other is IFC. If I want to read the sheet whose name is the same as my IFC Reader's source data name. Any method to achieve this? I guess fme_basename helps, but not sure how to achieve this. Thanks in advance.