Transformers

I have a pressing deadline but I have no PERL skill and need this attribute trimmed - Lot/Plan(separators).an example of an attribute:1/AB842550I am duplicating the column Lot/Plan(separators) into two columns - Lot and PlanAll characters to the left of this symbol "/" are the Lot numbers required in the Lot columnandAll the characters to the right of this symbol "/" are the Plan numbers required in the Plan column. Any and all help would be greatly appreciated.Thanks peter

Has anyone gotten FME Server to work with the Atos DirX Directory 8.4 server using LDAP v3? The LDAP server is on-site (not cloud).We are able to set up a successful connection but as soon as we try to import users and groups into FME Server 2018.1 it crashes with an unhandled exception in the logs:(Active Directory) Searching using filter "gdiReader"...Thread stack trace:getStackTrace(Thread.java:1559) / ensureNotNull(Validator.java:60) /createSubstringFilter(Filter.java:633) /searchUsers(FMEUidActiveDirectoryConnection.java:942) /searchForUsers(LdapSearchServer.java:411) /executeRequest(SecurityRequestsDispatcher.java:928) /handleRequestSecurity(FMEServer.java:384) /handleFMEServerClientRequest(FMEServer.java:285) /handleFMEServerClientRequest(RequestHandler.java:98) /processClientRequest(RequestHandlerBase.java:856) /readClientRequest(RequestHandlerBase.java:589) /handleClientRequest(RequestHandlerBase.java:772) /run(RequestHandlerBase.java:946) / run(Thread.java:748)LDAPSDKUsageExc

Hi!I have a question about how to convert a PNG palette to RGBA.My input features is in palette format (int8) storing all the RGBA values in one band.Now I would like to export it in PNG-format with the RGBA-values stored in four different bands instead. Does anyone know how to do it?

I have a feature class. There is a ID field in this feature class, like below: 101L1101L2101L3101L4101L5101L6101L7101L8101L9101L10...102L57102L58102L59102L60102L61102L62102L63... I plan to add a new field called AZIMUTH. I need to use ID field above to find the "next" feature, for example, if current feature ID is 101L4, I will try use 101L5, and use this "next" feature and current feature to calculate AZIMUTH. Can you tell me how to find 101L5 in this case? Better use transformers. If not possible use python is also OK.

I have a CSV file with Lat/Long for a point features and String for radius of exposure, I wish to create buffer for each well since their radiuses are different, I followed a tutorial but all the buffer went to one single point. Each point has 3 different radius, so I need to do this 3 times. In the attached tool I only used one radius at a time, this is for sensitive radius. The lat log is originally stored in NAD27 DD.

Hello people,I am new to GIS and FME. For my study we are using ArcMap. Ik have an shapefile and now I need to create a 5000 meter buffer around the shapefile. Therefore I must use the Bufferertool from FME. The result wil be written to a file geodatabase. Anytime I run the spatial ETL tool from FME I get an error and see no buffer of 5000m around the points of the shapefile.I have ad some screenshot. Does anybody know what I am doing wrong in my setup?Thanks in advance.Tijs

Hello everyone,I am relatively new to FME and have put together a conversion of 4 tables from a sql server database into a couple of embedded collections with a $lookup link in MongoDB. I've had a couple of issues getting the data directly into Mongo, but with a subset I have tested transforming it into a JSON and then loading the JSON into Mongo and that works fine. My issue is seems to be with memory when i try to run the full dataset through. I have been stripping the translation back into smaller chunks so that my machine isn't trying to run the full process at ones, but now I'm at the stage where I cannot strip anything away. The first bit of translation I am trying to do is taking the 6.7M row table and creating unique MongoID's for each row and then saving it as a JSON, which is pretty straight forward. However, each time I have tried to run this with the full dataset I get to approximately 3.5M rows loaded and then the JSON writer closes due to memory issues. Be

I need to create a point/line geometry out of the following input data:a) route: line geometry stored with measure values, including a route id fieldb) point/line event table without geometry, including a reference on the route id field, a measure value field (point event) / a start and an end measure value field (line event)Is there an existing transformer or a common known routine in FME to solve this problem?

Hello,I have a dng file that In print, the text information (i.e. codes) is in rectangular boxes linked (only visually I think) with arrows that point the corresponding geometry. However, When I imported the dng in FME, the geometry remains at the proper spatial place, but all text is moved to (0,0) therefore even the visual connection is lost.What I am trying to do, is to relate the text as an attribute in the geometry. However, it does not look like there is any sort of linking that could help me do this.I would appreciate any sort of ideas on how to process this, my question is too vague so I do not expect a specific methodology set. How could we relate text information from dng with its corresponding geometry?Thank you for your time.

the xml fragmenter refuses to recognize the xml in this doc (see attached). What am I missing?

I have a scenario where I need to convert the bit depth of a raster from 16 bit to 8 bit, or vice versa, but the type should remain the same. ie Gray16->Gray8, Int16 -> Int8, Red8 -> Red16, etc.Given that the RasterBandInterpretationCoercer does not accept attribute values for the Destination Interpretation Type parameter, is there an alternate method to testFilter for all allowed types, and 14 hardcoded RasterBandInterpretationCoercers?

I have an XML extract using a Soap interface that has a section with lists of user defined attributes. I have a schema for these but I am having trouble extracting the contents. I expect to be able to rename the fields based on the order after extraction. For example in the IDENTIFICATION path there are UserFields{1} to {5} that I want to extract and label like this 1 Manufacturer No Alphanumeric 40 2 Manufacture_Date No Date 11 3 Model_Number No Alphanumeric 40 4 Make No Alphanumeric 40 5 Serial_Number No Alphanumeric 40

Hi,I'm trying to download table data from Statistics Finland PX-Web API (documentation here http://pxnet2.stat.fi/api1.html). URL for example for the cube and the table containing population demographic data is: http://pxnet2.stat.fi/PXWeb/api/v1/fi/StatFin/vrm/vaerak/statfin_vaerak_pxt_001.px . Px-Web API can return table data in various formats, including csv and excel.Using HTTPCaller and GET or/and JSON-reader I've been able to receive nested JSON containing list of all the different variables of the desired table, but the problem is that this request does NOT retrieve the actual data.In my understanding I should send a specified JSON-query using GET/POST-command to API to be able to download the actual data. But I have no clue how to do this in FME. I've tried to go through JSON-readers schema scan using JSON-query, and I looked for the HTTPcaller but don't know if Query String Parameters or Body settings could help me with this. JSON-query should look somewhat like this:{  "query

I want to connect the orange and green points together to form 3d polylines (I'm in effect wanting to create a ray). The orange points represent a point on the ground and the green points represent the point in space where an image was taken of the point on the ground.

How to convert trimble sketchup (.skp)-files to Esri MultiPatch, with first alignment en clipping on a GIS-buildingunit-layer

How can i create a generic fmw file(X format to Y format) that can convert any x format file to y format.Instead of creating new fmw file for every(X format to Y format) conversion.Is that possible.

Hi guys,I am comparing 2 sets of data (6 months apart), in separate file geodatabases. There are approximately 18 feature classes in each database with a roughly 50,000 features in each class.Is there a way I can run a change detector on each feature class without having to add each feature class individually to the workspace?Cheers, Dave.

Hi. Me and my collegues have encountered this problem many times but we still haven't found an adequate solution. Please help! This is actually exactly what the Excel command Transpose does (when pasting copied data).I want this data to be transposed to this dataAnd if there a more ELEMENTS (after Zn) it should dynamically be included... We have looked at all the transpose posts here but we haven't found a good answer. ELEMENT, As, Ba and so on should be turned into attribute names for further use in the script. Any help will be gratefully accepted.Peter et al

Hi FME experts,  I'm having difficulties updating below:  Left is what I currently have, right is what I'd like to have. Have Want Toi et Moi (Villa) (Villa) Toi et Moi Wilgenerf ('t) Landhuis ('t) Wilgenerf Landhuis Gheestelic Hof (Het) (Het) Gheestelic Hof So if it finds anything in between brackets, take that and put it in front of the string. I've been trying the StringReplacer with the following RegEx: (\\(.*\\)) - but no luck so far.Cheers, Ed

I have a bulk soap extract that has a list of assets with attributes as properties, not elements. I cannot find in the many XML transformers what I need to do to get the assets back into a simple table with each property as an attribute.Here is a snippet of the first two AssetSummary elements.

When using a negative buffer value on too small polygons, they are always output as rejected features (since there is no valid part of the polygon to output). Is there a way to filter beforehand such that these features aren't rejected?

Hi,I have a polyline feature class in a File Geodatabase (10.3.1) describing the routes of pipelines. These are 3D polylines. Each vertex contains four properties: the first three describe the X, Y and Z coordinates, and there is a fourth "ID" property that contains an integer value. This "ID" property is never used by the feature class to hold any information regarding the vertex index. It's basically an empty tag. In my case this integer value was used to hold some status information. Now, I wonder if it is possible to access this "ID" property. I have not found a solution in FME Desktop. In the end I need to extract all vertices in order for each polyline, describing the X Y Z and ID values as field attributes in a table.The "ID" property was set using ArcObjects. It can also be accessed this way and I believe the ESRI's Geoprocessing framework (python) can read/write it as well. But for my solution and FME workbench would be a better

I am trying to get information from a QGIS project and layers and produce a new project based on new analysis results made on FME. (I know that the qgis project file is an xml and so I can read it as an xml, but i am trying to build a bridge between qgis 2.18 and fme desktop 2018)How to install the PyQGIS module and then using the custom python interpreter in FME Desktop?I am using QGIS-ltr 2.18.23 (from OSGEO4w64) and FME 2018.1.0.1 (Win64).

Hi,I have one table that I'm using for several schema mapping depending on the object.To do that my schema mapping is a combination of a test filter with several outports and each of these outport is connected a schema mapper (see below). All the schema mappers are reading the same table but their where clause is related to the the condition used in the Test filter.Is there a way to dynamically change the where clause inside the schema mapper transformer so that instead of having this complex custom transformer, I can use a simple single schema mapper transformer?  Thanks

Hi allI searched the Knowledge Center, but I didn’t found a solution (maybe I overlooked something).  I have an AutoCAD drawing with polylines containing arc and line segments and I want to write this polylines to a GeoPackage database.  The geometry of the gpkg feature class is »line (CompoundCurve)«.When I write the polylines to the database I don’t get arcs but only line segments. (refer to attached picture).  Is there a solution to write the data with lines and arcs in the database?I get the correct feature, when I’m writing »interlis« data to the GP database .