Best Answers

Hi,I'm trying to make a script that will replace/erase some of words from table of strings.I want to create list of key words in a Published Parameter (multiple choice) that will be piked by user. When I pick one KeyWord script works fine but with more doesn't work at all. How can I make it to loop through all picked words?str1 is with Published Parameter andstr2 is with list of words, but there should be more of them so it will look horrible ;)EDIT: words are single. Additional problem I have now is how to make them be whole words only eg. Landhotel shouldn't be erased HOTEL, only Land Hotel -> Land.And additional question is there a way to replace RegEx matching with sth shorter? I'm new in scripting so my code is vary basic :)I have such a script in PythonCaller:import fmeimport fmeobjectsimport redef KeyWord_replacer (feature):    str1 = feature.getAttribute('Name')    str2 = feature.getAttribute('Name2')    keyW = FME_MacroValues['KEY_WORDS']    str1 = str1.lower()    str2 = st

Hi,I am having an issue converting data from an ESRI SDE connection to KML file in FME due to 1.3m shift from the same conversion in ArcMap.My SDE data is NAD 83, UTM Zone 10N (WKID: 26910). I have no issues connecting to the SDE, I get the same 1.3m shift using a Writer or a FeatureWriter. I do get a warning of:NOT changing coordinate system of reader identified by keyword `GEODATABASE_SDE_1' from `EPSG:26910' to `_UTM83-10_0' -- mapping file setting of `EPSG:26910' overrides coordinate system `_UTM83-10_0' read from fileIf I put the SDE coordinate system of "UTM83-10", I still get the same error. Once exported, regardless of which coordinate system i use, the 1.3m shift is still present in the kml. I have exported from the SDE into both a file geodatabase and shapefiles and repeated the same process and I get the same results. If I re-import the KML into FME to a shapefile and compare to the original in ArcMap, there is no shift. If I import the same kml

Hi,I have an workbench where I used a fanout in a geojson writer. The geojson writer has 23 features and each feature is fanout based on the fme_feature_type where my Fanout Expression is "@Value(fme_feature_type)". The result is great, it created the files I need in geojson format in the folder specified in the "Destination" property of the writer. But each fanout dataset is named with the feature name. So if my fme_feature_type name is gis.auto_recloser, the fanout file is named gis.auto_recloser. But I would like it to be named auto_recloser_delete.geojson instead. Is there a way to customize the fanout dataset file name?

Hi,Previously when passing attributes names 'today', '1 week ago' etc ot the dateformatter it could work out the date. This is now failing.Have I missed something?Thanks

See FME 2018 New features, I can't find the 11th feature in my current FME 2018.0.1.0. Did the official version cancel this feature or did I not find it?

I am looking to write to a postgres hstore column and seeing if their is a way to use a postgres writer with its 1000 transactions at a time to write to postgres table with a hstore column over using a 1 at a time sql-executor? I have 5 attributes to go into the hstore.

I am quite new to FME, so sorry for my lack of knowledge. I've created a very basic workspace to combine three LAS point clouds, reproject them from State Plane Alaska Zone 4 Feet to UTM84-6N. The combination and reprojection work and create a file, but the new LAS file is now georeferenced about 300 kms east of where it should be. I've done a similar transformation in LASTools successfully. Any ideas?

Hello,I have a workbench with an optional DATE-parameter. When I use a tester to handle that empty date, I get different 'outcomes' when running from within FME Workbench compared to running it from FME Server. FME Server says an empty date parameter 'HAS A VALUE', but directly in Workbench an empty date parameter is an 'EMPTY STRING'. I use the exact same versions for Server and Desktop (version 2018 build 18301 Win64).Is this a bug? How can I properly handle empty dates passed via parameters?Regards,Frank van Doorne

I am am trying to convert a IFC-file into a CityGML-file. For inspiration I am relying heavily on the intermediate guide for BIM to gis. Now when I am trying to convert the IFCDoors entities into CityGML doors i get the following error:Type of writer to use was not specified (WRITER_TYPE was not found)I have to the best of my knowledge not changed the writer in any way except for the output-file path and the projection system. Every other geometry I am using seems to konvert nicely.So my questions are as follow:What does the error mean?How can I solve it?Thanks in advance :D

Hi,   When running a workspace on Cloud I get the following error "BADNEWS: File /opt/fme-engine-2018/metafile/autocadCorrTemplate.fmi could not be opened (foundation/framework/engine/tabrdr_classic.cpp:2756 - open) - (foundation/framework/engine/tabrdr_classic.cpp:1460 - getRow)"  The same workspace works fine in Workbench and even worked on Cloud in an earlier iteration. I have recently updated the workspace and it does contain a DWG reader but I have made no changes to that part of the workflow.  

Hi, I'm trying to split some text, based on the value auf another attribute. Unfortunately the AttributeSplitter transformer doesn't accept attribute values comming from inside the workspace, only pubulished parameters as the delimeter. Is there a way to set up individual delimeters for every feature and carry out the splitting upon them?One Example:Text_line_data: 2018-06-11 08:39:23| 486.7| 0.0|STATS |62b88ad3-1c54-43b2-b010-479f2141a98a Here comes the text string im interested in. The string wil vary in length for every featureDesired delimiter: 62b88ad3-1c54-43b2-b010-479f2141a98a I',m looking for the string that succeeds 62b88ad3-1c54-43b2-b010-479f2141a98aThanks for your support!

Like Projection Standard parallel (s)Longitude of originUnit False easting \\ northing

Hello.I am needing to lookup attribute values from my source table and lookup the attribute name and value in an excel file to return a the new mapped value. If the source attribute name and value matches the lookup list, return the new value.I have tried different combinations of mergers, exploders, joiners. Its a massive dataset with dozens of attributes to lookup per record. Any guidance would be appreciated. The challenge mostly that source attributes to align are values in the lookupFor example:Source Data ExampleSTATUSMANUFACTURERMATERIALCREATEDBY0ABC_COJohn0ZYX_INC1John0ZYX_INCJohnLookup XLS IDDOMAIN1ORIGVALUENEWVALUE1MANUFACTURERABC_COABCCO2MANUFACTURERZYX_INCXYZINC3MATERIAL UNKNOWN4MATERIAL1PLASTIC5STATUS0ACTIVEDesired Target STATUSMANUFACTURERMATERIALCREATEDBYACTIVEABCCOUNKNOWNJohnACTIVEZYXINCPLASTICJohnACTIVEZYXINCUNKNOWNJohn 

Hi! I have a problem! I need to export dbf file (FoxPro) to CSV. FME to read dbf file had changed fields with memo type - automatically to add numbers before text. I can’t remover numbers, because some text start by numbers. Please give me advice to solve this problem.

Hello, I have a 2D City Map .*dxf file. I draped my city map on digital terrain model to obtain a 3D city map. It works fine but when I try to use .*dxf/.*dwg writer, ? see this problem. "AutoCAD Writer: Encountered a feature with inconsistent Z values, and type 'autocad_lwpolyline'. For this type, only geometry with constant Z values, or 2D geometry are supported. Dropping Z values"In my output, the geometry which consist of 'autocad_lwpolyline' does not have Z values. Is there any way to solve this problem?

Hi,Any idea how to convert Collada / 3ds single sided faces to double-sided faces?Thanks,Y.

Hi,I am writing out to a json writer and intend to stream this json using fme cloud.The output looks like [ { "STAGING_ID" : "9515", "USER_API" : "A2C3601C-40E9-48DC-A0C0-5D4DB0867A2E", "REQUEST_GUID" : "80318a93-f513-4e63-8c08-9e07250af0e2", "ID" : "120654", "UNIQUE_LOCATION_ID" : "5819", "UNIQUE_SAMPLE_ID" : "576683", "ROW_CREATED_DATE" : "18/05/2010", "LAST_EDITED_DATE" : "18/08/2017",etcIdeally I would like to add a few lines before the records return e.g.[    "status":"ok",     "body" :  { "STAGING_ID" : "9515", "USER_API" : "A2C3601C-40E9-48DC-A0C0-5D4DB0867A2E", "REQUEST_GUID" : "80318a93-f513-4e63-8c08-9e07250af0e2", "ID" : "120654", "UNIQUE_LOCATION_ID" : "5819", "UNIQUE_SAMPLE_ID" : "576683", "ROW_CREATED_DATE" : "18/05/2010", "LAST_EDITED_DATE" : "18/08/2017",Could anyone suggest how this can be achieved. I really don't want to manually template the output from the rows because they are dynamic and remove any null values.Many Thanks,Oliver

Previously we had no issue publishing to FME Server (2016 and earlier) with connections set to access web services on our ArcGIS Online for Organizations account. Now we can't seem to get our "one" ArcGIS Online job to work on FME Server 2017. When it asks us to authorize the connection after upload (Which works just fine on Desktop we simply get an error telling us "Invalid client_id Error:400"Has anyone else encountered this issue yet? Do you know what the solution to it is?I'm attaching a copy of the error message and what bothers us is it shows the generic https://www.arcgis.com URL and not our organizational account.

I would like to run a simple command-line command in FME and output the text to an excel table.I want to runtaslklist /s SERVERNAME /fi "ArcSOC*" > c:tasklist.txt ...and then send the results into other transformers.How would I do this?

Hello, im searching for the possibility of running multiple workspaces at the same time (not queued jobs) making use of the python fme objects fmeobjects.FMEWorkspaceRunner() . I was kind of hoping that i could pass a list of dictionarys as 'parameters' argument to runWithParameters(workspace, parameters) ... I was expecting the same behaviour as seen in workbench transformer WorkSpaceRunner, where you can set wait for job to complete = No and the amount of jobs to run (max 7, i suppose) run in parallel. Im i missing something wiht this object, or im really suppose to implement some python multiprocessing technic to acomplished the parallelism needed ? What your thoughts are ?Regards,Jorge

With the ArcGIS Online reader I can get the layer name from fme_feature_type but is there any way to get the name of the feature service that contains that layer?

I am using FME 2018.0. The problem is that my FeatureWriter outputs some weird geometry. The first picture is my input geometry. The inspect result is generated right before entering FeatureWriter.Then, I created a FeatureReader connecting to the geodatabase created above and inspected following geometry.I looked into the two geometries. They have the same amount of vertex. What could cause this problem?Update 1. I change the output format to shapefile and it works with either arc geometry type or polyline. The latter one is what I use for geodatabase output. Hope it helps. Update 2. A simplified worksapce and relative data is attached.

The documentation for the PythonCaller points to this page to describe how to install python packages for FME: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Installing-Python-Packages.htmAt the bottom the target directory is listed as C:\Users\<user>\Documents\FME\Plugins\PythonBut, in that directory are several subdirs: python27, python 34, python35. Do I install instead to a version-dependent subdir?i.e.:python -m pip install <mymodule> --target C:\Users\<user>\Documents\FME\Plugins\Python\python36

Hi,I have setup a really nice example of the data delivery on FME server using this example code - https://knowledge.safe.com/articles/1117/data-distribution-with-web-maps.html. Ihave also made the guest account token the init for the FME javascript.I have setup a simple form to authenticate in the example the user using the token service however struggling to replace the init token with the users token when the FMEServer.runDataDownload method runs.Any attempt to overwrite the variable token resorts to running the job under the guest account.Any suggestions?Thanks

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.