Transformers

I see how to update individual fields of a record in a database at https://community.safe.com/s/article/update-only-certain-columns-in-a-database-table which seems straight forward enough. However, when I try this workflow on a SharePoint List I get an error. Does anybody know if this workflow works with SharePoint? If not, any pointers on how to update individual fields in a SharePoint List? Thank you.

Hi all,I have attributes streets for example below. I want to extract the attribute14 Le Thanh Nghi >> 1412B Gia Quat >> 12B3 Ngach 6 Ngo 12 >> 3Tran Hung Dao >> Null (Have not number) Could you tell me how to use regex function to make it?Thank you

i would like to reduce the features from dgn file to write in Adobe Geospatial PDF , any ideas please .thanks in advance .

I am working on a pipeline that will take unsanitised Revit and Rhino models to IFC to GDB. The discussion I would like to have is:I have looked at the older threads about this, and have found some good FME workbenches. the best of the workbenches do have unpredictable problems, for example i got this error "Expression: edgeCurves_[edge].has_value()". I will begin recording the fatal errors here and see if people have ways to address it.I havent found a way to build a GDB file that retains the layering in the original file. Anyone have done this before? Or is it not possible because of the IFC format?

Hello, I have polygon from postGIS DB and raster file. I want to use clipper to get part of raster file that is inside polygon which is used as clipper. Here is the clipper: It should be a 10x10 km box.Please take a look at min extents: 520000.0 , 6160000.0  And here is the clippee (raster file) And now I'm very surprised with clipper output (inside):  I don't know why that .3 appeared at decimal place? Do you know what am I doing wrong?My expectation is that it should start with border of clipper which is exactly 6160000.0  

Hi, I'm trying to create a single xml template that can handle dynamic attribute names. The attribute name to be used is stored in another attribute. Please have a look at how i set up the xmltemplater to write the attributes names:ROOT:<root> <a>head</a> <feat>{fme:process-features("SUB")} </feat></root> SUB:<f> <{fme:get-attribute("attr")}>{fme:get-attribute("value")}</{fme:get-attribute("attr")}></f> Where 'attr' holds the attribute name and 'value' the value.  I get the following error:The following error occurred near line 2, column 6 of the query: invalid expression: syntax error, unexpected character "{"An error occurred while parsing the 'SUB' sub-templateSo clearly this is not the way to go. Is this possible in anyway or do I have to define specific SUBs (conditional) for every possible feature schema? Thanks! 

I'm using FME Server and Desktop version 2018.1.2, I have a webhook in Cityworks when a service request is closed it should trigger a FME server process where it generates a pdf report and emails it to the requesterI have a parent workspace that gets the JSON from FME Server topic message. The workspace checks if a file exists and then runs two workspaces based on yes-no tree. The child workspace reads the same JSON and uses a cityworks connector transformer to authenticate to cityworks api to get service request details. The child workspace runs as a stand-alone process and successfully authenticates to Cityworks to get a token. However when run as achild workspace fails with the following error CityworksConnector_HTTPCaller(HTTPFactory): HTTP/FTP transfer error: 'Couldn't connect to server'CityworksConnector_HTTPCaller(HTTPFactory): Please ensure that your network connection is properly set upCityworksConnector_HTTPCaller(HTTPFactory): No proxy settings have been entered. If you requ

I noticed some strange behavior - when inspecting the data with the wild card to view all records with any value per attribute (in the Visual Preview or in the separate Inspector window) when there are couple of hundreds of records and tens of attributes (71 in this particular case) the tool is mixing the selected attribute and displays count of filtered records for the second one to the right (like in the picture below: I filter for all records with ObjSyleVoc value, and it is giving me the number of ObjUsageContextVoc. It also displays the updated table view for ObjUsageContextVoc, not the selected in the filter bracket. ) Any ideas why it is happening? It works for smaller tables...   

Hello all, I have a table that I need to pad with missing ranges following a small, specific rule set. Lets say I have the following table (in the attached spreadsheet):I would like to result in this table, which has new rows inserted with start and end values whos ranges were not represented in the initial table. These new rows have been flagged as "free" (also in the attached spreadsheet):The knowns and the rules are as follows:The quantity of groups is not knownThe quantity of subgroups is known, in this case 1,2,3The allowed range is known for each subgroup, in this case 0-10, 10-20, 20-30As a rule, ranges should not cross subgroup boundaries (see row 9 in output table)All values from 0 to 30 should be represented in each group To simplify the example, the ranges overlap. The real data type has decimal precision, which would result in the following ranges:0 <= SUBGROUP1 < 1010 <= SUBGROUP2 <2020 <= SUBGROUP3 <=30 Thank you in advance for the help.

Hey,I would like to know how I can split a Line from FeatureType A at the Intersection with the Line from FeatureType B. But then just keep the Lines from FeatureType A.With the Intersector I keep the lines from both the Feature Types. How can I keep the lines from only one of those FeatureTypes? Is there any Transformer I can use?Thank you,Best regards.

Can anyone help me with creating a workspace for comparing two DEM models? Let's say that an area was scanned twice and now my task is to create a map showing elevation difference. I would like to export a raster with RGB colour scale.

 Ideally I can read in the whole gdb and export to a csv that simply states the feature subtype and its total count of features. I know that exposing the "geodb_subtype_name" needs to happen to get those values. Can I avoid importing all of these and simply go from my single gdb reader, to the transformers that will give me the totals of each subtype? Below shows all the features that will then have subtypes within each one. I need to know the total of each subtype.

I was trying to write data from a JDBC connection to an ODS via a JDBC connection. Some times i am facing the below issue 2021-02-25 20:34:57|1245.3| 0.0|INFORM|MS Azure SQL Database Spatial (JDBC) Writer: Committing feature 197000com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2670) at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1990) at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6494) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7741) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7700) at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.doInsertBulk(SQLServerBulkCopy.java:1615) at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.access$200(SQLServerBulkCopy.java:58) at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy$1InsertBulk.doExecute(SQLServerBulkCopy.java:709) at com.microsoft.sqlserver.jdbc.TDSCo

parameters to set for versioning

I'm reverse geocoding (XY coordinates to addresses) and I'm getting some business names back instead of the actual address. The data I need is in the full JSON response, but I don't know how to access this information.  After looking closer into the JSON results I found that the address I'm given is a short hand version of the data. I want the _arcgis_longlabel, instead of the _address field. How can I extract this specific attribute from the json response?   

Hello,I've tried to use ZipExtractor to unzip file (zip available here: https://drive.google.com/file/d/1BTSAYP5dJ86T5LV1-vM3ayRTkUNuiDVZ/view?usp=sharing) and error occured ("error_file" in attachment). I obtained messages:"Unexpected error: [Errno 2] No such file or directory: 'C:\\\\Users\\\\eliza\\\\Desktop\\\\S2A_OPER_MSI_L1C_TL_EPA__20150715T095303_20160812T015357_A000319_T34UFA_N02_04_01\\\\S2A_OPER_PRD_MSIL1C_PDMC_20160812T191123_R036_V20150715T094306_20150715T094315.SAFE\\\\S2A_OPER_MTD_SAFL1C_PDMC_20160812T191123_R036_V20150715T094306_20150715T094315.xml'"and "|ERROR |Error encountered while calling method `input'|FATAL |ZipExtractor_PythonCaller (PythonFactory): PythonFactory failed to process feature" I've tried to search Python script in ZipExtractor but I could not find solution.When I browse unziped file by ZipExtractor I can't find all files that I can find when I unzip zip file myself. It's my ZipExtractor:Than

Is it possible to make the httpcaller Request URL dynamic so that it includes the attribute from a record going to the htttpcaller?For example: If I have records 1, 2, and 3 going to the httpcaller and I have a base URL of https://api/, can I dynamically make the URL https://api/1, https://api/2, and https://api/3 for each corresponding records?

I have a SDE reader and trying to convert to MBTiles format. I'm using MBTiles Vector Tiles writer. But quite not sure about the various parameters like zoom levels, Tile set metadata that need to set.For instance, for zoom levels - There are pre-defined 0 - 22 Zoom levels. What would be the zoom level like for state, county, zip code? And is there any significance for the metadata fields? Thanks, Tagging ​ @Mark Stoakes​ , @Takashi Iijima​ 

Hi guys, this seems like it should be a simple thing to do but I can't find a way to do it. I have a point feature class that needs to be turned into polygons. The first point for each polygon has a "Start" attribute but the rest are missing. The table is ordered so that the points are sequential so I want to use a GroupID from the first point and apply it to the all the points until the next feature that is a "Start".  I've tried a line builder to GroupBy "Start" and it will draw the line but won't include the Start point.I'm using FME 2020.1 Cheers, Dave.

I have developed a python script to walk though directories picking dwg files that fit the pattern I want. I would like to add the script to a user parameter and pass/link the parameter to a reader source. For testing purposes I started with a simple script to return a single dwg, linked it to the reader source, and it failed with error...'Update Reader Failed'. My simple Python User Parameter scrips is as follows:----file = r'C:\\data\\dwgfoldertest\\Test1.dwg'return file-----Any pointers would be appreciated. If I get the simple test working, I'll move onto the more complex Python oswalk script which will return a string of dwgs separated with commas, so if you have any tips on how FME will behave with that next step, that would be appreciated also. Thank you,Tyler FME(R) 2020.1.2.0 (20200902 - Build 20620 - WIN64)

I'm trying to convert some Time and Date to UTC but I get this issue from DateTimeConverter: AttributeManager: The input datetime '20161106012242' falls inside a daylight savings transition and is ambiguous in the local timezoneAttributeManager: Failed to evaluate expression '@TimeZoneSet(20161106012242,local)'. Result is set to null.Does anyone know what's going on?

The PBKey is a unique records to Spectrum Geocoder assigns to each address in their database that can be used to link to other data from Pitney Bowes, now Precisely.

I have 210 rasters, I am trying to create one mosaic for every 10 of them. The titles will be something like:raster_0_10raster_10_20raster_20_30I created a custom transformer to loop the rasters. There are two variable called "from" and "to". I increase them with 10 for the failed data. Whatever I do, either it keeps updating the first raster or it fails.I attached the workbench, unfourtunately I am not able to give a sample data but I provided the CSV file of the namings. Thanks,Caner 

The image I've attached represents a road; the grey line is the top of an embankment and the red line represents the bottom of the embankment.  I would like to find the difference in height between these lines at perpendicular points.  Hopefully I've explained this clearly. I would be grateful for any suggestions! :)

I have the new version. The old one used to do this very easily.