Transformers

For example, if I have a length of 12356 meters, I would like to have 012+345.Thank you.

Hi, How can I copy the style (Presentation: color, symbol, size, zoom levels) of another shapefile file to my current project. thanks. I'm using Workbench 2020.2

I am trying to configure a FeatureReader to use WMS to request a map in the SVG format (image/svg+xml). I have two options with respect to the output format (jpeg and png) but using the "Open text editor..." functionality I can input the image/svg+xml my self. It fails when I run the workspace and according to the translation log the FeatureReader probably doesn't recognise the format and defaults back to PNG. Even though I have thought of WMS as always returning a raster image, https://en.wikipedia.org/wiki/Web_Map_Service describes it as also being able to return SVG and WebCGM. I haven't browsed through the WMS specification though. I have found this idea https://community.safe.com/s/idea/0874Q000000TlLiQAK/detail which ask for the option to read a plain SVG file so I guess reading SVG is outside the scope of FME so far (even though writing SVG should be available)?

This question is in follow-up to this earlier post, which is, so far, unanswered ... After consulting with some CAD colleagues, I am starting to think that user attributes added to plain features (in my case points), not blocks, by the CAD Writer are invalid for AutoCAD. In fact, a Google search turned up no mention of user attributes outside of blocks ... and opening the output CAD file in FME shows no sign of the User Attributes defined in the Writer. Sigh.

Hello,I am using FTP Caller to call a file with a name like this:   A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_27.csvMy problem is that the last two digits (here 27) are random...So I tried to replace the last two characters, like this:   A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_??.csv   A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_*But it doesn't work and it returns an error.I know I can list all the FTP files in an attribute and then search for the right file with "String Seracher" but I thought it might be easier!PS: The @Value(_timestamp) part works correctly and returns the date in the format used in the file naming. Thanks in advance  

I am reading CAD point blocks with Explode Blocks unchecked. FME represents these features as points (fme_point), as expected; however, if I then try to write these points back out to a new CAD file, the writer rejects all of them, saying that the blocks are not defined in the CAD file. I don't want blocks written out. I want simple points written out. Now, if I explode blocks on read, only one of the four blocks/feature types in the CAD file produces the insertion points as points. The other three produce all the lines, arcs, etc. but no points. So, how do I go about getting the points for all the blocks and then writing them out to CAD as plain points, i.e. no blocks.

Hello, I have a set of polygons to which I'm trying to attach an image texture (grass polygon + grass jpeg). The image is in pngformat, resolution is 1140x1140 and covers approximately 5x5 meters. I've used the tiler to tile the grass area into 5x5 tiles and used the Polygon texture in the MapnikRasterizer with the Local alignment option.  I would expect the image to be fit into the entire polygon tile but it's not. It's instead cut into a smaller image and fit like that. Example workspace and image are attached.  Is there something I'm doing wrong? I would like the image to fit the polygon tile and that's it. Any recommendations? Thanks

I am using several FeatureReaders (ArcSDE) and they have a connection file that I paste in. I want this to be a parameter so that I do not have to update several readers when I want to change the connection file. When I create the parameter and try to run it then I get an error that says "Too many recursive macro substitutions". What is the best way to fix this? Thanks. 

Steps in my transformation:1) Translate X,Y2) Scale around a specific coordinate (Local Coordinate System)3) Rotate around the same specific coordinate as in step (2) Thanks,Tomer

The plan is to be able to assign floor heights dynamically based on my FLOOR_ID attribute. To be clear, the sheet with the geometry and the sheet with a list of floor heights both have FLOOR_ID as the name of the attribute. Was hoping to use conditional values, but not having any luck. Here are some screenshots for context:Above, is the preview from my Excel Reader showing the FLOOR_ID and height values. This is on a separate sheet from one with all the geometry, FLOOR_ID and other data. Error coming from ListKeyValuePairExtractor.  This configuration does not work, but there were no other choices. Was hoping to do something like this in the 3DForcer, but it errored before it got there. Any help is appreciated! Thanks,@larue 

I've created a workbench where I simply need to add four columns into multiple features. I've tried a few different ways. The data has metadata in it so I just want to truncate the table or drop and create so it retains the metadata.I used a dynamic writer, the error is random.I tried a more manual way by just exporting "Create if needed" into an empty GDB and importing Metadata afterwards. Still no luck. Weird errors.I tried an even more manual way by pushing one feature at a time through and having a non-dynamic output. This was random, sometimes it would work, but sometimes it wouldn't. I finally got this to work and pushed through 20 features before it decided to stop working and error "Cannot write a non-point feature to a point feature class" but the output is set to polygon! I've made several new writers and readers and workbenches, and used different features and new GDB's and I can not get this to work.   

I have run a hadoop job and set multiple reducers in the reduce phase, then I have customize a counter to sum the results of multiple reducers. However, the data type of the result in each reducer is double, while the increment method of conuter only supports the long data type. If the conversion from double to long is forced, the precision will be lost. How can I solve this problem?

I am using Httpcaller to read the catalog. Getting the response body.then using a HTMLExtractor but the links are not coming as a http they are like this: <a href='catalog.html?dataset=xxxx/xxxxx/Archive/name1.nc'><tt>name1.nc</tt></a></td>then using a ListExploder to get just the links like: catalog.html?dataset=xxxx/xxxxx/Archive/name1.ncthen I was creating a URL attribute to concatenate the URL( http:////xxxx.yyyyyy.xx:8083/thredds/catalog/xxxxx/xxxxx/Archive/catalog.html? )and the list ( catalog.html?dataset=xxxx/xxxxx/Archive/name1.nc) to have an URL to downlaod the data as: http://xxxx.yyyyyy.xx:8083/thredds/catalog/xxxxx/xxxxx/Archive/catalog.html?dataset=xxxxx/folder/Archive/name1.ncBut I donæt manage to download it.I get the following error:HTTP/FTP Transfer: Failed to create file 'R:\\xxxx\\Downloaded\\yyyy\\' for resource download 'http://xxxxxdocker02.dddddd.no:8083/thredds/catalog/xxxxe/xxxxxx/xxxx/catalog.html?dataset=dd

I'm tring to convert some CityGML to b3dm tiles. Source data in EPSG:3857 - center is x=4183074.86, y=7496562.311 but tilles in output get some strange values: x=2855853.53, y=2197566.80. How to save the 3857 coordinates?

Hi, I have a question about how to perform a Multiple LEFT JOIN, because I need to categorize certain ROWs of my TABLE A (all the fields always have information), based on the combination of criteria that I have in TABLE B, the categories are defined in the column RESPONSIBLE TEAM of TABLE B, many of the fields in TABLE B are empty and when this is the case, it is possible to select any value (wildcard), if I do a simple LEFT JOIN it works correctly, but I can't do more than two LEFT JOIN to be able to do the categorization I need.I am using InlineQuerier.this is what I am using: select * from "TABLE A" LEFT JOIN "TABLE B"  on "Country" like "_Country"and "State" like "_State" is not null or '%'and "City" like "_City" is not null or '%'and "CODE" like "_CODE" is not null or '%'and "Description" like "_Description" is not null or '%'

I am using a CsmapAttributeReprojector to convert between a source coordinate system and my own local destination coordinate system. I expect that the Y value should only change, however, this change does not take into account a negative value So if the source Y value is -50Instead of adding 200 to - 50, it adds 200 and 50 which results in 250 instead of 150. I have a python script that reads the header of my CSV file and finds the Y column in the header and this value is given to the reprojector, this does find the right column but as said above, my transformations aren't subtracting

Hi Guys, no so sure if this questions belongs here:  1st> what's the best way to have an internal (to the workbench) datasheet (4 columns x 20 raws of values). Is it in the workspace resources?  2nd: I am reading +storing a sequence of characters from a file (a file that I am uploading and processing). I want to compare this sequence (a name) with the aforementioned database in question 1 (actually with one column of the database), So when getting a coincidence name=cell A1 , I will store or been able to retrieve the values of the other cells within the same raw (cell A2, cell A3, and cell A4) .  Thank you very much!  Jorge

I am trying to use CurveFitter on a set of contour lines but am not getting useful results. As you can see some of the lines overlap, even after a very light processing. How can this be avoided? I tried both settings of Preserve boundries, but that did not make much difference. 

Is it possible to containerize a dataflow ? Something like this:Where we split our dataflow, we apply some specific transformation on one of the containers and then the rest of the dataflow is similar for both container. During the end of the workflow, both container will be isolated.  Is that possible ? For simple workbench this is useless, but if, for example, I have a lot of "group by" transformer in the "End of the workflow" part, then it will be useful. 

I have 2 large Mapinfo tables - Hedges (lines) and Gardens (polygons). I want to retain all hedges outside gardens, including those which have ends touching the gardens. I want to remove all hedges running along (coincident with) garden boundaries. I attach an image showing with red crosses these lines. All others should be kept including those touching the boundary at an angle.Is this possible using the SpatialFilter or SpatialRelator? I've tried various ways with both these but I am not able to achieve this. In Mapinfo I achieved it by the SQL query "Not Obj Within Any (Select Obj from Gardens)". Is there an equivalent in an FME transformer? The only other way I can think of is by buffering the gardens slightly and then using the Clipper to remove all hedges within the gardens (and the buffer would remove those running round the garden boundaries).Many thanks if you can help!Jane

Hi,We are implementing Informatica in our gas/electric utility. We will use this information to test calling the FME Server job from Informatica: https://knowledge.safe.com/articles/636/integrating-fme-server-and-informatica-powercenter.htmlWhat is the best way to let the Informatica job know that the FME Server job is finished?Also does anyone know of other organisations that use an Informatica/FME Server integration?Thanks,Annette

Hello Thereis it possible to get access to the GDB Schema of the utility network of Esri, without having An ArcGIS productThanks 

I am using a SQLExecutor transformer to execute a large number of SQL queries (writing to a Sybase IQ DB via JDBC connection as a work around for the Sybase Writer that didn't work for my specific translation). I've found that not all of the features that are routed through the translation and should be written via the SQLExecutor are actually getting written. There is an error "java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.". I'm thinking that this is related to the "Query Timeout" default of 30 seconds. However I'd like to confirm this so when does the commit part of the SQLExecutor query actually happens. For instance if 30 features get routed to the SQLExecutor do each of those get written one by one or all in a batch at the end? Thanks in advance to anyone who has any info on this!

Hi. I have trouble using the csgbuilder to form a unified solid(IFMECSG). In my database, every building has so many small parts and I need to union them. Every building should be a unique(one) building. I want to write them later to Citygml as building. The writer does not accept a multiSolid, so I need to do the union through csgbuilder. But the problem ist that this transformer do the union just for one small part and reject all the remaining parts. I also used the group by parameter but the result is the same. Can you please help me?

I have a workspace that is run on a daily basis. Its duration is about 6 minutes. Sometimes it gets stuck on the line: Processing base feature(s)... If I compare the logs of a succesfull and failed execution there aren't any different numbers that are about to be processed. There's also no warning of resources, memory etc.. The failed workspace just gets stuck (and stops logging) and after 20 minutes it's timeout (as scheduled). Execution time for both succesfull and failed processes up to the 'Processing base feature(s)...' line is about the same: 5 to 6 minutes. Does anybody have advice on how and where to look for clues to prevent the workspace getting stuck