Transformers

After using the Orienter on a line the attributes that are 'end sensitive' are no longer in the correct fields because of the flip. I used to use AttributeCopier (v2) which did a fine job. But an "upgrade" has broken the swap, overwriting so fields. I used to just not upgrade, but now the workbench just crashes. I cannot create a new workbench with the old AttributeCopier so I am stuck with a kludge using a whole lot of temporary variables unless there is a more elegant solution. Is there?Just to be clear, I need to do this:Source TargetLTO RFRLFR RTORTO LFRRFR LTOetc for every "end sensitive" attribute. (You will remember that not only do you have to reverse the data values, but it has to be mirrored as well when a flip is done because left and right are also swapped.)Preferably I would like AttributeCopier to revert to the original behaviour.

Hi there. I am trying to import a simple csv file to my CARTO on-Premise account. I could import files before I updated my FME Desktop to 2018.1. Now I am keep getting following error messages.Creating reader for format: CARTOTrying to find a DYNAMIC plugin for reader named `CARTO'FME API version of module 'CARTO' matches current internal version (3.8 20180209)Creating reader for format: CARTOTrying to find a DYNAMIC plugin for reader named `CARTO'FME API version of module 'CARTO' matches current internal version (3.8 20180209)CARTO reader: Directive '_MULTIUSER_ACCOUNT' has value 'NO'CARTO reader: Directive '_API_URL' has value 'cartojp.com/user/carto/api/v2/sql 'CARTO reader: Directive '_API_KEY' has value '**********************************a72a4e'CARTO reader: Directive '_PAGE_SIZE' has not been set. Using default value '500'CARTO reader: Opening account 'myonpremise'CARTO reader: CURL e

Good evening,Is there a way to do a lookup (like a FeatureMerger) within a Python script? I have multiple attributes that I need to lookup against a single list, but I'm not sure how to supply this out-of-band (supplier) to the python without muddying/creating duplicate features. Basically I'm trying to avoid creating 20 FeatureMergers for each attribute lookup I need to do. Cheers,Peter

Is there a way to quickly remove all attributes that contain no data, i.e. every row is null.I don't really want to run a python script, I am wondering if I can to some statistics to count and then something to remove the attribute.Many Thanks,Oliver

Hello. I am using FME 2018. So, I have created a workbench that generates polygons as output. But, some outputs that are generated are polylines and not polygons.Now, if I edit the polylines(in ArcMAP) that are made, it becomes polygon. I don't know if its a bug or something with PointOnAreaOverlayer.Any solutions for this? I have attached the inputs and wb.Thanks

Is there an equivalent to Raster Calculator in FME? I am aware of the RasterCellValueCalculator transformer, and the custom made NDVI transformer, but is there also a single transformer to calculate the results of multiple rasters (more than 2) and/or to apply a custom function on these rasters? And, since the Rasters have to be perfectly overlapping, is there also a transformer to reproject and resample an existing raster so that it will copy the properties of the other raster?Or do I need multiple RasterCellValueCalculator transformers behind one another to get the same result? This somehow does not seem very efficient.

I'm trying to add label points to dissolved polygons and my label point output is far less than the number of dissolved polygons input to the Label Point Replacer. If written to the Inspector the number of label points (~4400) equals the number of inputs but when written to a database the number drops to around 100. Does anyone know what might be the problem and how to fix this?

Hi I am trying to add a grid shift file in workbench 2018.I have followed the steps listed in this page:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/CoordSys/grid_files_adding.htmHowever there is no option to add a new file.Any help would be much appreciated.

How can I combine a list of the same feature into the same oneFrom this Ply_idLoc_nameLayer_idSpatial_relation1MTL1510OVERLAPS1MTL1511OVERLAPS1MTL1512WITHIN to thisPly_idLoc_nameLayer_idSpatial_relationMsg1MTL1510 OVERLAPS, 1511 OVERLAPS, 1512 WITHINThanks

I have some features that contain an attribute with a GeoJSON string, I also have a Multipolygon in WKT passed as a global parameter to the workspace, what I have to do is to parse each geometry from the attributes (in geoJSON) merge them into a multipolygon and test if this intersects at least once the geoJSON mulitpolygon. At the moment I cannot parse the GEOJSON from the attributes, I tried to use geometryExtractor but the transformer instead of extracting the GEOJSON string extracts the geometry of the incoming feature (which is unrelated), i tried the feature reader but I get an error because the reader is looking fro a file path while I submit an attribute. I parsed the geoJSON with the validation online and it id fine. How can I accomplish this?

Hello ThereI am looking to get export all feature to the image but with the sat image background I used image fetcher transformer, the problem is I am getting only one feature on the image and the translation shows 5for the info I am using the Google Static image url

I'm receiving the following error using the salesforce connector. The connector returns 2000 features and then stops with this error. On another object, it returns 1,000 features then stops. My SOQL query runs fine in salesforce workbench. Any ideas? Python Exception <MissingSchema>: Invalid URL '/services/data/v43.0/query/01g6A00000RzDWPQA3-2000': No schema supplied. Perhaps you meant http:///services/data/v43.0/query/01g6A00000RzDWPQA3-2000?Traceback (most recent call last): File "plugins.py", line 441, in input File "salesforceConnector.py", line 259, in receive_feature File "salesforceConnector.py", line 151, in query File "salesforceConnector.py", line 133, in _get File "C:\\Program Files\\FME\\/python\\requests\\sessions.py", line 521, in get return self.request('GET', url, **kwargs) File "fmehttp.py", line 224, in request File "C:\\Program Files\\FME\\/python\\pypac\\api.py

I have line features from an Autocad DWG import that I would like to turn into polygons by adding some width to the line. The line may consist of one or more line segments. I'm thinking I could break the line into segments, create two copies of each segment, move the segments parallel to the original line in opposite directions and then create a hull around all the points. I'm not sure how to do this. Is there an easier way?

I need to output an SQL script created with SQL Creator in a custom text file. The file is essentially a csv file but with '|' as the seperator, the header row prefixed with a 'H|' the rows of data prefixed with 'B|' and a footer containing F|<file_id>|<datetime_stamp>|<number_of_rows> creating a csv file using '|' is easy enough but I haven't found a way to do the prefixes or footer. I was looking at using XML Templater but not sure if I'm barking up the wrong tree. Any guidance would be greatly appreciated.

We're trying to run a script in FME Server 2018 that replaces a geodatabase with a new dataset using arcpy. In a few months we'll be attempting to use FME's native geodatabase writer, but for now I need to troubleshoot why the following doesn't work:import fmeimport fmeobjectsimport arcpy# Main Functiondef delme(feature): # Variables table_2b_deld = feature.getAttribute('SOURCE_ETL_TABLE') sde_conn = FME_MacroValues['SDE_Connection'] full_del_str = sde_conn + '\\' + table_2b_deld + 'X' # print full_del_str # Process try: arcpy.Delete_management(full_del_str) feature.setAttribute('deletion_result','success') except Exception, e: logger = fmeobjects.FMELogFile() logger.logException(e,2) feature.setAttribute('deletion_result','failure') feature.setAttribute('deletion_result_detail',e) passAfter that script runs, we move data in Oracle from our staging schema into our production schema, then attempt a geodatabase registration script with a virtually identical syntax.If the geodataba

I looking to calculate the intersected area between polygonsI used the Areaonareaoverlay transformer but I am getting one of the feature removed and replaced by another one,

I am converting an excel spreadsheet to an esri geodatabase feature class of points. Working well so far, except for one field of elevation values. There was no standard of input and the values are varied. For example:75 feet75 ft.75 ft75f75 MSL25 m / 75 fIf it weren't for the last example, which occurs too often to waste time updating manually, I'd just use a string replacer to extract just the numbers, but in that last example, I'd end up with 2575 instead of just 75. I'm guess that first I need to remove everything before and including the '/', and then can use a stringreplacer with regular expression '[0-9]+' . Also, I've gotten another spreadsheet of data in which "##m" occurs. Those rows would need to be converted to feet. Hoping this is solvable with transformers, as the data is not to be edited.

I have a custom transformer that caches API call results to a PostgreSQL table. It tries a DatabaseJoiner on the key, and if it finds a matching record, it passes the joined feature directly to the main Output port. Otherwise, it calls the API, passes the result to a SQLExecutor to INSERT it for joining on same key value on subsequent features passed to the transformer.Unfortunately, the DatabaseJoiner is unable to find records stored by the SQLExecutor for subsequent features during the same workspace execution. I've tried explicit COMMITs (with appropriate delimiter declaration) in the SQLExecutor (it says no transaction is in progress) and a 5-second-per-feature Decelerator after the SQLExecutor in case there is some kind of race condition between FME Workbench and PostgreSQL. No luck. I still get duplicate key violations because the failure of the DatabaseJoiner causes the same key to be sent to the API and storage attempted again via the SQLExecutor. I've even tried

Good morning,I have a question about FMEI have many readers and writers that transform files into oracle tables, and he reads everyone and does commit only after all. I would like you to conduct a commit every transaction from reader to writer

Using 2018.0 I placed a logger in-line with a translation. Max messages to log is set to 999999, but it stops logging after 115 features.Why is that - and how do I get it to log all the translation info (looking for info on the 428'th item in this case)?

Hi,Just wondering if there is any way to link the components of a BIM (Revit) model to values so the component changes a color if its value is above a range (?)Any insight is more than welcome.Many thanks.

Is there a way in FME DataInspector to make 3D solids "partly" transparent, like area filling is now ?I have quite hard times to inspect the parts of a solid when I need to always rotate it so that the marked vertex/point is in foreground.It would help greatly if it would be possible to see through the surfaces. Michael

I'm trying to run a workbench on my MacOSx 10.13 using DateTimeNow function but I get this error :AttributeCreator: Failed to load timezone data. Please visit http://www.safe.com/supportAttributeCreator: Failed to evaluate expression '@DateTimeNow()'.  Result is set to null.It runs perfectly on Windows 7.Do you know what could cause that? I've check into my options and my time zone is defined.

i have a lidar data for which i have to create a lod2 city gml model . how can it be done?

i build a 3d buildings scene in sketchup, when i convert it to 3d tiles, i found there is only one feature in b3dm, i can't divide different buildings each other, can i split 3d entity in skp file ? or any good solution to solove it ?thanks!