Transformers

It seems that the RasterExtensCoercer removes every attribute which name is prefixed with underscore, if you set Raster Extent or Data MBR Extents to the Extents Type parameter.See the attachment. (FME 2020.0.1)

Hi,I kindly need to know how to transform a file in .csv format into a file in .pxy format or a .txt format. Many thanks,Mamdouh

Heya, I'm having some trouble writing a two csv tables (share a relationship via a common ID in both tables) to a esri feature class and related table (linked via relationship class - global ID / parent globalID) which have a set pre-configured schema.Here are the steps i have taken and some screen shots of my process to load the csv data to the feature class schema (part 1/2).Part 1/2 - load geocoded main csv table data into esri feature class  The csv default for each field is read as a text field, thus the Esri reprojector is trying to pass all these text fields into a set schema. Do I need to include a schema mapper? If so, what does that table look like and in what format does it need to be in. Or, do I need to define all the fields in the CSV reader? The csv is being created correctly no problem and the data are same in the same projection and in the same region as I view them all in the preview with feature caching. The writer to write to Awhina Schema cannot be run - it&#39

Using TableAdder to create a table with more than 1 content-row results in the rows not being aligned.I have tried with and without different group-by options.Inside the tableAdder the error becomes obvious, less so to fix.Data for placing the boxes in the Y-axis depends on the _count variable, and so the boxes ends up being displaced a half-height for every iteration.Has there been updates to Counter without TableAdder being udated?I managed to get the output I wanted, by removing a counter transformer and changing the code for y-placement, but I am left wondering why the plug-n-play transformers are broken?

Hello there!I have a little problem with solving this issue.need to create a geometry (with creator) which should be used as an "selector" maybe via intersect or overlap of features.This features are comming from featureReader (ArcGis-Online Portal). They should be intersected (or overlapped or similar) with created geometry, and as a result should be plain Excel Data, that inhalts only interected features. The problem is, that in my result excel data are no features inside.It looks like the were no "intersection". No features in created geometry. (but they are there) . I tried it with intersection and also with overlapping .Not pretty sure what is the problem. Maybe I just do not see some setting? the result Excel is includedAny Ideas?Thanks 

Good morning. I've been facing all morning a FME crash that I do not understand. So far I have tested my workspace with two version: FME 2018.1 and FME 2020.0 both 32-bits. The process fails with both of them.My source data is a Personal Database (MDB) without spatial information. In one table I have data about "group layers" and in other about "layers".A group can contain layers and other groups. I must build a JSON with that info.To build the JSON with the groups, I have used the following JSONTempalter: ROOT contains:{    "version": "1",    "tipo": "3",    "servicios" : [            fme:process-features("GRUPO")        ]   }GRUPO contains:{    "Nombre_ES": fme:get-attribute("NOMBRE_ES"),    "Nombre_EN": fme:get-attribute("NOMBRE_EN"),    "grupos" : [        fme:process-features("SUBGRUPO", "PARENTID", fme:get-attribute("ID"))    ]}And SUBGRUPO contains:{    "Nombre_ES": fme:get-attribute("NOMBRE_ES"),    "Nombre_EN": fme:get-attribute("NOMBRE_EN"),    "grupos" : [        fme:process

I am trying to figure out how to insert empty lists into a JSON Templator as an empty bracket like this:"materials" : [],Currently, I can't only get it to look like this: "materials" : [ { "materialBridgeId" : null, "materialTypeName" : null, "materialName" : null, "quantity" : null, "tamsUnitOfMeasureId" : null, "tamsUnitOfMeasureName" : null, "tamsStockpileId" : null, "tamsStockpileName" : null, "isDerivedFromCirus" : null } ],Any thoughts on I can achieve the empty elements listed above?Thanks!Mark

I have a sorter, but I do not want it to sort if the first row in Field B has a value. I am guessing this will need a combination of transformers.

Hi,I have created a FME Desktop workspace that imports data into the MS SQL database which runs successfully as a scheduled task if I am logged in the server. But it fails when I'm off the server and gives me this kind of error message. (I got a blank SQL provider error)2020-05-07 22:00:21|  11.5|  0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using SQL Server 2012 Native Client...2020-05-07 22:00:22|  12.3|  0.8|ERROR |Microsoft SQL Server Non-Spatial Writer: Failed to connect using SQL Server 2012 Native Client. Provider error ''. Connection string 'Provider=SQLNCLI11;Data Source=;Initial Catalog=cadasdb_equalizer;User ID=;Password=********'2020-05-07 22:00:22|  12.3|  0.0|ERROR |Microsoft SQL Server Non-Spatial Writer: A suitable Microsoft SQL Server Native Client is not found. Install Microsoft SQL Server 2012 Native Client from http://www.microsoft.com/en-ca/download/details.aspx?id=29065 . Please expand 'Install Instructions' and download 'sqlncli.msi'2020

How do I expose (or what Format Attributes contains the info) the AutoCAD Map 3D Misc data "Annotative", "Block Unit" and "Unit Factor" so that it appears with the OD and other attributes I exposed on the Reader? Thanks.

Hi I cant seem to find a way to test files on filesize. It's not a format attribute or something you can import with the files... You can do it with python probably, but I'm not a programmer. (I tried and failed :) ) All I want is: TESTERfilesize > 1 183 000 bytes    

HiI would like to run this script that need Selenium using python callerAnyone can help me ? thx Francesco

Hello,  In my workspace, I use LenghtCalculator to have the "Distance" from line. I'd like to have three Numbers after .  I use Stringformatter on this attribute with Format String .3f but all value not have this setting.  Someone can help me to fix this?  I have also tried Attribute Manager with Math Opérator "ROund (Distance, 3). It's the same things.  Best Regards  

Hello,I have created a workspace to download attachments from Survey123 for ArcGIS which works perfectly, apart from one thing. Some of the attachments are stored in related tables and as a result don't pull have the sample ID field included and this is causing issues further down the workflow.I need to create a workflow that compares the parent ID field against the whole globalID column. If it finds a match, then it copies the sample ID field to the appropriate line and replaces the NULL field.Does anyone know how to do this? GlobalIDParentIDSampleID1234NULLSamp 14564NULLSamp 2548441234NULL54564844564NULL45848545NULLNULL

It seems FME supports reading Sketchup and colors - through attributes like RenderingOptions.GroundColorRGB . However it does not seem to write these attributes if you have an fme_color on an object. I have tried creating an RenderingOptions.GroundColorRGB = 0.59999999999999998,0.74117647058823533,0.56470588235294117 - however it does not seem to work. How do you set colors properly in FME for them to be displayed within Sketchup correctly?

 i have three lines intersected in the same point the intersected point and the three points known for me ,i want to make barrier at the third line at right side .so the third line will not be part of the network id by network topology builder .the point in the third line has special attribute and i can recognize it so i did buffer on this point but i found the line above this point connects to the another two lines and i do not want that . i want the whole third line seperated from this network id and it will connects to another network that third line connects to . each line has his own ID if i used topology builder ,it create extra intersected node but with id only one point above for the three line how could i solve that  Any suggestion ,thanks

Hi,I am able to use iCloud as data provider in the FME AR app, but when I try to open the same file in Google Drive the file is greyed out.Does anyone else have the same problem?/Daniel

Hi, can someone please take a look at the behavior of the <Rejected> port of the DateTimeConverter and check if it's as expected:https://knowledge.safe.com/questions/113416/different-date-formats-in-the-same-date-column.htmlThe behavior is described in my answer and the comments below it.Possibly the same issue: https://knowledge.safe.com/questions/91296/datetimeconverter-rejected-port-null.html 

Hello,I have multiple invoice CSVs I pull in every month with about 300 records each. It eventually goes into a database table that is used as a lookup.The CSV has an invoice_date column and at first I thought the invoice dates were all the same format (M/D/YYYY >> 2/1/2020), however, some invoices have dates coming in the following format: (YYYY/MM/DD >> 2020/02/01).I was wondering if there was a way to standardize this so I don't get NULL date values in the translation when the date format I'm looking for isn't recognized. I'm having a hard time doing a condition because both the date type use the "/" character as a separator. If it was a "-" or something then I can use a condition to search out the special character and parse those dates using a particular format. Any help on this matter would be very helpful!Thank you.

When using a SQLCreator or Creator, I can't get the VariableRetriever to attach attributes to the created data. It works correctly with any other data but not the creator(s). Can anyone else replicate this behavior? FME 2020.1.0.0 (20200305 - Build 20510 - WIN64)  Works correctly with a shapefile input _value is left null for the creator and SQLCreator records

Trying to use the PointOnAreaOverlayer to merge points and bounding polygons. While I suspect some points may be outside the polygons most should be inside. The result I'm after is that each point will inherit the polygon attributes, but it seems that no matter how I configure the Transformer the Polygon attributes are always <null>. Any help or examples would be well appreciated.

Hello there, I tried to comment on content of post https://knowledge.safe.com/questions/52852/seperate-a-single-field-values-into-two-xml-elemen.html# but for some obscure reason wasn't able to do so.My question is a follow-up to the remark of @takashi in the other post concerning the tokenizer function:Note: <bnr:foreignKey> elements would not be created if fme:get-attribute($fkey) was empty.I ran into exactly that kind of situation. What would I do to avoid this?I'm thinking about an if then else conditional statement but fear I am not capable of doing that. Assuming that $anykey is empty - would such a construct work?{    if ( fme:get-attribute($anykey) ne "" ) then    {    for $k in fn:tokenize(fme:get-attribute($anykey), '#')    return         <mri:keyword>              <gco:CharacterString>{$k}</gco:CharacterString>         </mri:keyword>    }    else    {    return         <mri:keyword>              <gco:CharacterString/>        </mri

Hello:I created a workspace with a python caller to access a Zoom api endpoint. I copied the same python code from Zoom's code generator and the code runs fine. I copy the same code into a python caller and I receive the following errors. I have no proxy I am going through. I have very limited python experience. Any help would be appreciated.Errors:Python Exception <SSLCertVerificationError>: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1076)Error executing string `import<space>http.client<lf>import<space>fme<lf>import<space>fmeobjects<lf>#<space>Template...Factory proxy not initializedPythonCaller (PythonFactory): PythonFactory failed to process featureCode:import http.clientimport fmeimport fmeobjects# Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer par

Hi Guys,Can any one guide me on how to perform "INPUT" I have to as "OUTPUT" I require...Input will be GDB object class tableOutput will be excel spreadsheet.Schema of the table will be dynamic as I will use different tables. I have provided spreadsheet as an example to understand better...Thank you

I have a tabfile that I want to migrate to a database. But first, I need to correct som geometryerrors. I have a polygon layer with some lines on polygon, please see picture below. I want to have them removed. One other thing that is weird is that when I use the transformer GeometryFilter the line object won't filter as lines. They will filter as areas.I Appreciate all the help I can get.