Transformers

Hello. I realize there are several different date range topics, and I can't seem to find one that applies to my needs. My goal is to query or tag records within 90-, 270-, 365-day date ranges based on CurrentDate. I have not been able to get anything to work with FME tools, but normally the SQL query would be: Select * from [layer] where "expiration_date" >= CurrentDate+90 Any ideas? Thanks.

There is a transformer that does an operation similar to the repair geometry function of arctoolbox (ArcGis)?

Hi, I have a data set of lines that are part of polylines but i am missing attribute sequence. Attribute sequence is number (starting from 1) that represents order of lines for each polyline. Is it possible to add this attribute in a way that number 1 is first line of polyline, 2 second and so on? If not, how can I add this attribute regardless of position of lines in polylines? This is part of my data set. First column is ID of line and third one is ID of polyline. I need to add fourth column sequence that will have for example for polyline 0 line 142 value of 1, line 7 value of 2 and line 747 value of 3.

How to select a specific IFMEFace from a solid? I have created a solid and want to extract face 0 and face 5. I like to have them have a name. Later on would use those names to assign a specific texture to those two faces. "Part 0: IFMEFace " should have a name like "roof"

In our environment workspace development and published server are on different systemes, therefore the workspaces have to use not-previously-known fme web connections for communication, especially submitting calls to child workspaces. After some deliberation it seems that a scripted connection parameter that reads its value(s) from a configuration file would be the ideal solution to gain the necessary indepence of runtime environments. I found https://knowledge.safe.com/articles/844/setting-up-a-workspace-to-deploy-in-production-sta.html and https://knowledge.safe.com/questions/4296/set-published-parameters-in-a-python-startup-scrip.html but cannot figure out how to use these techniques for a connection parameter

Hi, I am making landuse change of 2 times but the data vector is so big. So I want to convert raster and make matrix landuse change in FME. Firstly, I will convert vector to raster and then find a intersect raster function. But I don't find the function to intersect raster. With vector, I used AreaOnAreaOverlayer function. Could you show me the function to intersect raster? Thank you

Morning, I would like to create a UUID in my workbench as a parameter and call it at various points through my workbench. The issue I have is that currently it keeps generating me a new UUID every time I call it. I am using the @UUID() function. Is there a way to populate the parameter once and persist it thoughout the workbench so I can use it in filenames, database table names etc. Many Thanks, Oliver

Hello, Firstly apologies if this question has already been posted. (or something similar) I have an aerial photograph of a large industrial site as a raster dataset in a gdb and the buildings on that site as multipatch. I am trying to apply the photograph as a texture on the roofs of the buildings in the multipatch. So far I have successfully used the planarity filter to separate out the roofs, applied a UUID to each roof level. I have then used these roofs to clip the raster of the full site to create individual rasters for each roof with the UUID associated with that roof. My issue is when I come to apply the texture back to the roof. I have tried to use an AppearanceStyler and then an AppearanceSetter along with a GeometryPropertySetter, but I keep getting the following error "fme_rejection_code (string): MISSING_REFERENCEE_KEY" Below is the current configuration I have My question is where am I going wrong? I cant find anything about MISSING_REFERENCEE_KEY on here or google! Thanks

Hi All, I have a shapefile that consists of polylines (some lines are curved) and I want to calculate new attributes for the start, end, and middle xy coordinates for each line. The final results should be the original geometry but with 6 new attributes. Note that the middle coordinates need to be on the line, not the bounding box. Any thoughts on how to best accomplish this task? Regards, Michael

The TestFilter does not indicate an error (in FME 2018.1; build 18502, win64).Normally an error is indicated by a red icon on the transformer However, when I use the testfilter and something is wrong I do not see this red icon. When I look at the "TestFilter parameters window" I still don't see that something is wrong. I need the look at the "Test Conditions window" to see what is wrong. This is indicated by the red row (see image below). It would be helpful if the icon would turn red and if you could see what is wrong in the "TestFilter parameter window".Would it be possible to implement this?

Hello, we are having a problem trying to read a MongoDB collection using a FeatureReader. We are reading a large database and only require data which falls within a bounding box. The FeatureReader constriants for MongoDB include a spatial filter - but selecting one creates the following warning: `MONGODB' does not support querying by spatial predicate, but supports envelope queries. It also advises that equivilent results will be performed by FME locally, but this does not work. Envelope queries are supported, but it takes a huge amount of time. If MongoDB does not support spatial queries within FME, can anybody suggest an alternative to the Envelope query, which seems to take much longer than should be necessary. Thanks

Ciao a tutti. Sto cercando di convertire un DWG con layer scritti in russo in shapefile. FME Data inspector mi mostra i testi in cirillico, mentre l'esportazione in SHP mi sostituisce tutti i caratteri con punti di domanda. Ho provato a usare tutte le combinazioni possibili con lo strumento AttributeEncoder senza risultati

I want be able to replace part of a generic table name with the current table name in the SQL statement within the sql transformer. for example <LAST_YR_RIN_SCHEMA> with R_2017_01_01 is this something that can be done in the workbench? i was told to use a private parameter but that wouldnt work and also to use a creator followed by attribute_creator followed by the sql_executor which is also not good as i only want to replace part of the table name not the entire name as shown in screen shot above. thanks for your suggestions.

I created a custom coordinate system using FME's online tool and placed the resultant files in the proper local FME folders. I can select these new coodinate system but when I try using them in a workbench, FME crashes hard when it accesses the new coordinate system. Something seems wrong with the new CS and is confirmed when I try to check the properties of it in the Coodinate System Gallery. What looks suspicious is the Ellipsoid value is missing. I used the ESRI WKT to define the parameters in the online tool and filled out all of the other empty boxes with the exception of Source.

Hi, I was wondering if it is possible to spatially sort (or even group) line data based on direction of flow? I work for a waste water company and we are required to send out extracts of our GIS data (as a spreadsheet) to our contractors so they can clean the sewers. Currently the data is not sorted in any logical order, ideally it would be in an order they could actually follow when in the field and do continuous runs of cleaning when possible. The screenshot below is an example, with some suggested ordering for each section (though there would be multiple acceptable orders): I don't know if it would be beneficial to group the data prior to trying to sort it? The order of the groups wouldn't matter too much, its just more to ensure the data always starts upstream in that group. Any suggestions welcome.

Hi, I'm just getting into adopting 2018 for my daily work. One thing immidiatedly annoys me in 2018, a feature that's been changed since 2017: Whenever I try to select a number of transformers inside a bookmark, using a selector rectangle, the bookmark moves !!! How do I turn this "feature" off ? I cannot really see why this (default) behaviour has been changed. The need to select transformers in a large bookmark outweighs the need to move a bookmark by clciking in the canvas, imho. Selection inside a bookmark has almost been made annoyingly cumbersome, Ctrl-Clicks and starting the rectangle selection outside the bookmark seems to be the only options now. Does it have something to do with the new collapsable bookmarks ? Cheers

Has anyone has success reading in either numeric or decimal data types from Red Shift? I am using 2018.0, and after successfully connecting to the Red Shift database, I cannot see any fields that have a numeric or decimal data type. I can see double precision and float types successfully.

I would like to know how I can do conversion of a map of characters, texts where I have different or special characters with accentuation.

Hello Is there a way we could copy only the schema ( table name and related attribute ) no data into another database, SQL server, and Postgres, multiple table at once Thanks

I have a dataset with a local origo. It is based on UTM 32N. I have been supplied with the seven parameters used for transformation into regurlar UTM 32N. Reading the FME documentation, I have tried to add a custom transformation using 7PARAMETER method, but I cannot access it from FME. The closest I get is the Csmapprojector, but it is not cooperating: I cannot use my defined transformation as the local coordinate system is not defined. (Having the parameters for the transformation already, this should be irrelevant - as it is in other software I used before). Trying to create a custom coordsys also isn't bringing me very far. For some reason, if I have my custom Coord I cannot see my custom transformation. And vice versa. From my MyCoordSysDefs.fme: COORDINATE_SYSTEM_DEF CustomerLocal.UTM-32N \ DESC_NM "Local for customer based on UTM32N" \ SOURCE "Customer" \ GROUP Project \ PROJ UTM \ UNIT METER \ PARM1 32 \ PARM2 1 \ QUAD 1 \ MAP_SCL 1 \ DT_NAME WGS84 XFORM_DEF CustomerLocal_to_UT

I am trying to do a -75 puffer on a polygon but due to the problem in the title I can´t get any further. Does anyone have any tips to make the bufferer work?

Hi all I have an attribute whose values are all written in PascalCase, for example "PleaseHelpMeOutHere". I'd like to add a space at any capital letter, making a more readable string "Please Help Me Out Here". I don't need to preserve the original attribute. To make it a little more complicated, some attributes have more than one capital letter, which I'd like to preserve (except for the last capital, which denotes a new word). For example "SOSHelpMeOutHere" becomes "SOS Help Me Out Here" My guess would be that using a StringReplacer with Regex would work, but Regex is a foreign language to me. I could always use a PythonCaller, but I'd prefer to avoid that if possible. Thanks

Howdy, I need to split a memo field (WrkDesc) that is over 2500 characters into several fields that are 255 characters or less (WrkDesc1, WrkDesc2, WrkDesc3, etc). Right now I laid out a bunch of SubstringExtractors which each grab a different section of the text (0-254, 255-508, 509-762, etc) and it works fine. However it seems like I should be able to do this within a single transformer like AttributeSplitter. In the AttributeSplitter help it says "Alternatively, instead of using a delimiter character you can provide a string in the format #s#s#s, where each number is the length of the substring you wish to extract." The way I interpreted that statement, for Parameter> Delimiter or Format String I inserted this: 254s508s762s1016s1270s1524s1778s2032s2286s2540s2794s and generated a list named _listWkDesc However the output is a single list element _listWkDesc{0} with a copy of the memo fields entire original text. I had expected to see a bunch of list elements each with 254 character's

Hello, I am attempting to modify the "" to fit our workflow. I've got it almost working, except there seems to be a scaling issue. The primary change is that we use DGN more than DWG. The buildings, ortho and terrain are shown, but the buildings seem to be scaled differently than the orthophoto. When I output a collada file, the buildings sit where they are supposed to over the ortho. I also have a geometry issue, so I had to pipe the "rejected" output to the PDF, which worked fine, except for the scaling issue. Below is a link to the test data. Thanks for any help!!! https://drive.google.com/file/d/1nXF1B4kNjoyH_ij2HTUImWgfMguORVfB/view?usp=sharing

I'm reading an ArcSDE polygon layer (British National Grid), running it through the Aggregator, then writing to a TDE. But I get a warning in the log "TDE does not support geometry on feature". I can't see much in the way of parameters to change to try and fix this. Any ideas? FME 2018.0.1.0 (20180518 - Build 18310 - WIN64)