Transformers

Hi Everyone I have been trying to read pdfs and save to jpeg. The issue seems that I can only write 3 Bands to the Jpeg Writer(R,G,B). Once I remove the Alpha8 Channel, the background turns black. I have tried multiple ways of fixing it, but to no avail, I am stuck right now. I found this excellent Article on the forum, but I still seem to have the issue with the Colour Values, can someone please help out? Is there an elegant way of fixing this? I can succesfully export png, but can't crack this Jpeg Writer! Any help or advice will greatly appreciated. Fred  

Hi. I'm trying to read a pdf of a 2D CAD drawing. The file opens ok in Microsoft Edge browser but when I use the Adobe Geospatial PDF reader it is only reading a fraction of the elements in the file - a few text elements.  I've tried playing around with the reader parameters but cant figure out why its not reading the whole file. Any idea what i'm doing wrong?  

I'm reading archived tables with the GEODATABASE_SDE format, i.e. with connection file. I'm trying to access the special archive views for this occassion. The ones that SDE creates automatically which has the "_EVW" postfix. Though I cant see them in the list of available geometry tables. I'm connecting as the schema owner with a FeatureReader. How does this work? Does FME figure that out automatically? For example if I read features from table "SAMPLES", the question actually directs to SAMPLES_EVW view? Or does it work any other way. I did some tests and created a logger which helped me out with the number of features read.  For one of the tables I got the logger saying that it "Cloned 841467 input feature(s)" When counting the records in the database I got the numbers:Table: 840 225EVW-view: 840 227 Three different numbers is what made me write this question. So how does this actually work?    

Hi. I am using GeometryValidator for some buildings as multisolids. All of them has been created together, but after the GeometryValidator, some of them come out from Failed part. I need all the 3D buildings. Can I repair them before the GeometryValidator?I set the set of issues to Detect to Surfaces and Solids. Thanks 

I have saved MVT tiles locally like this, c:/3006/0(zoom level)/0(Tilecol)/0(Tilerow).mvtInformation about the tileset below.<TileMatrixSetLink><TileMatrixSet>3006</TileMatrixSet></TileMatrixSetLink> <TileMatrix><ows:Identifier>10</ows:Identifier><ScaleDenominator>14285.71428571428623399697</ScaleDenominator><TopLeftCorner>8500000.000000 -1200000.000000</TopLeftCorner><TileWidth>256</TileWidth><TileHeight>256</TileHeight><MatrixWidth>4096</MatrixWidth><MatrixHeight>4096</MatrixHeight> When I RUN the Workspace I get this translation log (see link) and no GeoJSON file is to be seen. What do I do wrong? https://docs.google.com/document/d/1u-BgtK6lU4SUKFFPjG-lv4Gs2VYHLc7AIOXo-Is_QB8/edit?usp=sharing 

Hello,I am trying to POST an XML using the HTTP Caller, but get a 415 error.I have an API tool for the application that I am trying interact with, and manage to POST the XML with success.I have seen other posts that suggest it is the header of the XML / Content Type option which is incorrect, but I have tried all the options I can think of. Any help would be appreciated. I have pasted the XML I am using below, and attached the test  workbench I'm using. Note that I have deleted credentials / sensitive information.Cheers<?xml version="1.0" encoding="utf-8" standalone="yes"?><Mail> <TotalAttachmentCount>0</TotalAttachmentCount> <Confidential>false</Confidential> <RichMailText>false</RichMailText> <MailSubject>TEST2</MailSubject> <ToUserId>1476934057</ToUserId> <MailTypeId>2154</MailTypeId> <MailFormFields> <MailFormField identifier="DesignPackage_singleSelect">N/A - Not Applicable</MailFor

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