Transformers

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 

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    

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

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.

Hello, Currently I'm trying to get a 3d model out of a 2d drawing. Now when extruding different areas and clipping those with each other to get the right solids i encounter a problem. When the boundaries of the different polygons are overlapping (for example: walls and rooms) I encounter the problem that FME sees a very tiny difference between them which leaves me with this very small boundaries where the overlapping lines are.Is there a way of solving this problem? I have messed around with the clipper parameters but for now I didn't manage to get any success. I also thought about buffering the certain areas by a very small amount to just get over the edge but I don't really like that solution; as this makes the model inaccurate. Also I guess this has to do with the floating point problem? When extruding i don't get the exact length bu

Hi All,I hope you are well and healthy! I wanted to drop a quick message to give you some updates on our move to a new community platform. As mentioned long ago (far too long -- sorry for the lack of updates!) we plan to migrate to a Salesforce-based platform and we've been working hard behind the scenes to make this happen.  We are getting close (estimated release date of June 15) so I wanted to start the conversation with you all on what might change and how you can be involved.Firstly, revamping the community means we can take a chance to highlight your efforts. I've been working with our design team to do just that. We should have some special recognition for you that will live publically on the community.  Secondly, we love for you to get a chance to see it firsthand before we go live. We'll look to allow some beta testing and we'll set up a private group for feedback.Lastly, I want to expand the program and add a

We currently use a JMS service that we connect to as a client, via some simple Java code (a Solace JMS service, that we are not the administrators of).We are struggling to connect to the service using a JMSReceiver in FME Desktop. For simplicity, we have copied all of the relevant JAR files into the FME /plugins directory.If we specify the Username in the transformer property, it is not recognized by the initial context factory (the context class returns a "Username must be specified" error). Instead, we have to use the "Additional Provider Properties" and specify:java.naming.security.principal=myusernamejava.naming.security.credentials=mypasswordUsing my network traffic monitoring tool of choice (Wireshark), I can see the initial connection to the URL. However, the server returns a "The username or password is incorrect".Questions:What is the JMSReceiver doing with the Username and Password fields?Is thi

Is there a way to reject or fail all features containing same value? Right now I would ideally like a way to route all features containing same value to failed port. Currently, for example, if I clone 1 record 3-time, two features fail and one feature pass. How do I route all features that have non-unique values to failed port?

Hi everybody,I have problems to show geometry after SQL statement.Inputs:-PostGIS public database: geometry (polygons) & table I am using the SQLCreator transformer and my query (SQL Statement) works properly but in Data Inspector only the table result of my query is showed but not spatial elements.I´ve tried to use 'GeometryExtractor' in order to extract the geometry column, It does but neither shows spatial elements. Any idea? I don´t know what I am doing wrong?Thanks,Juanjo

Hi,  I try to make lines from points to the nearest polygon. I used Counter as unique ID for the points, and a geometry remover because I thought is necessary to obtain points from the vertex creator. However, it still does create lines. Also the result I want (LineBuilder) are obviously weird. Whats going wrong here?  Thanks!