Authoring

HiI have a workbench that goes like this :Using FME Desktop 2014 (build 14339)I'm using a FeatureReader to extract data (from SDE).I'm using a FeatureReader to extract SCHEMA (attribute name and type) from the data extracted from SDE).The schema is extracted because I need to change an attribute type before writing it to MapInfo (an SDE date attribute is formatted as fme_datetime and for MapInfo I need it to be fme_date).I'm using python to change this and it works perfect.Then I merge the extracted schema to every feature with the FeatureMerger and then output the data in Mapinfo.The real problem is that I now need to change an SDE float attribut to a mapinfo decimal type (fme_decimal(10,5)).FROM SDE : fme_data_type = fme_real64 and native_data_type = doubleTO MAPINFO : the type is FLOATI try to change the fme_data_type and native_data_type to double (fme_decimal(10,5)).In the workbench it's ok, but the mapinfo output is still FLOAT.Any Idea?Thanks!Francis

I am running a workbench to validate overlapping polygons My table structure is versioned spatial tables I have ran the validation workbench against one version, using a published parameter setting the override version. This has been successful for a single version. I want to automate validating a large number of table versions. I have attempted to use the workspace runner to achieve this. In order to change the override version. With the idea that this will run for each table version. I have a tried using a CSV list of the versions and I have tried reading directly from the Oracle version table list. I have been unable to produce an output with test cases, these test cases produce an output when run against an individual version.I think the workspace runner is failing to change the override version published parameter instead running against the SDE.default version for the same amount of versions within the CSV list.I would be greatful for any help or advice, at a bit of

HiI am using FME to transfer data from Oracle to PostGISFor a couple of my tables I don't want to include some fields, however some of the fields to be removed have the same name as fields on other feature types that I want to keep.Can I specify which table to remove the attribute from in the dynamic writer properties?Thanks

In the 'Using Python with FME Server' doc, step 2 asks to run the command python get-pip.py however, the server we are configuring is offline so we get an error 'Failed to establish a new connection'. What are the steps to get get-pip installed?

Hi! I am using a writer to write to a non-version ESRI SDE feature class. For now I pass some parameter to the "Truncate Table" of the writer. When the parameter is "Yes", the writer deletes everything in the feature class before writing new records, as expected.When I tried a situation that the parameter is "Yes" but there is no feature to be written, the feature class is not going to be truncated. This is the behavior I want. However, I couldn't find any documentation about this scenario.Is there any documentation I can use to verify my implementation is ok? I am trying to avoid using undocumented feature as much as possible.Thank you!

Could you please take a look at this:https://knowledge.safe.com/questions/54930/statisticscalculator-bug.htmlMy first reaction is that it's indeed a bug.

user selects one feature class (published parameter) and fme writes to one to six formats(like csv, shape, dgn, acad, xls,mapinfo etc...)in the fmw i am asking formats to write via published parameteroutput_format =dwg,shape, xls  like(comma separated)then i used python prg  to split these values create new attribute for each format(yes)import fmeimport fmeobjectsimport mathdef frq(feature):    my_list = feature.getAttribute('_list{}')    ESRISHAPE=''    XLSXW=''    CSV=''    AUTOCAD_OD=''    AUTOCAD_DWF=''    FILEGDB=''    for item in my_list:        if item=="ESRISHAPE":            ESRISHAPE="YES"        if item=="FILEGDB":            FILEGDB="YES"        if item=="XLSXW":            XLSXW="YES"        if item=="CSV":            CSV="YES"        if item=="AUTOCAD_OD":            AUTOCAD_OD="YES"        if item=="DWF":            AUTOCAD_DWF="YES"    feature.setAttribute("ESRISHAPE", ESRISHAPE)    feature.setAttribute("XLSXW", XLSXW)    feature.setAttribute("CSV", CSV)    feature.setA

I am trying to create a single ini file from multiple database tables. Each table has two columns LCODE,LVALUE.Each table name should become the section heading and the items below them should contain the rows in the format LCODE=LVALUEThere should be a single empty line between the last row of a section and the next section headingThe ini file would look like this:[ARTWORK_MATERIAL] STEEL=PLAIN STEEL ALUMINIUM=UNPAINTED ALUMINIM[ARTWORK_TYPE] SCULPTURE=The artwork is a sculpture MOSAIC=The artwork is a mosaicand so on.Any help would be fantastic.CheersPaul

I am looking for a way to add the previous months name to the filename of an output Excel e.g. Filename_August.xlsx.I have been trying to do this with Python (I am a Python beginner) as a Private Parameter using the following:from datetime import date, timedeltafirst_day_of_this_month = date.today().replace(day=1) last_day_prev_month = first_day_of_this_month –timedelta(days=1) prev_month_name = last_day_prev_month.strftime(“%B”) print prev_month_nameThis works in python but it fails in FME.Any ideas?

Windows 7 / FME Desktop 2017.1.0.0 build 17539FeatureReader with PostGIS. In the FeatureReader, in the (PostGIS) Parameters, in Schemas for Table Listing, the schema "data" is saved as my default. Works like a dream.Every now and then I need to edit a workbench with another schema already configured. Now it comes: when I open the FeatureReader to edit the Feature Types to Read, I get Failed to retrieve feature types. I believe my default PostGIS schema setting is overriding the original configured schema.I wonder if this is how it should work.

I'm a very new to FME. I'm trying to transform a geodatabase file with several items to a dwg file using the Clipper and shape file boundary. The clipping appears to be working correctly. However, each layer within the new dwg file has a copy of every object. Each layer has the same properties like color, linetype, etc.

I was recently putting together an example of calling a third party application and wrapping it up in a custom transformer and I thought I'd share a (fun) variation I came up with to demonstrate a point.Filtering the posts on the Knowledge Center is now a little more functional than it used to be and a few of you will have noticed that the filter options build the URL to a standard format, so of course you can get FME to do that for you too. Quite a few websites use this approach and communicating with APIs is quite similar, so FME lends itself to the task very well.Given that I'm feeling pretty hard-done-by, that I did post a question on TLAPD (Talk Like a Pirate Day for those land-lubbers out there) and yet I still wasn't granted a "special" Pirate Chief badge. I thought I'd create a small BadgeChecker transformer that incorporates:- Custom Transformer technology - Embedded, though it could be exported and shared. - Attribute hierarchy in the AttributeManag

I have a table information and that needs to be transpose like shown below screen shot.Parcel number is more then 1000 and each parcel bldg type up 30 plus types.Please can advise to achieve this task.Thanks in advanceVenu

In FME Server 2017 you can route a job to a specified engine by specifying the tag for that engine in the Job Routing Tag box in the Advanced panel of the Run Workspace dialog. However, I am calling the workspace from a workspace runner using the FMEServerJobSubmitter tool. There is no facility in the workspace runner to enter the job routing tag. Also, when I publish the workspace runner to FME Server, there is no place to put in the job routing tag. I tried setting the FME_SERVER_REQUEST_PARAMETERS parameter to "tm_tag=my_engine_tag1" but it still failed when I ran the workspace runner because the workspace did not route to that engine. Is there a way to set the job routing tag either when you publish the workspace to FME Server or when you call the workspace from the FMEServerJobSubmitter?

So the scenario is: I have an SDE featureclass with attributes A,B,C. User has shapefile with attributes A,bob,C,D. I want to create a workspace to be run on FME server that will allow the user to map one, many, or none of the fields. I'm not sure how to go about this. I also want to map the matched ones so the users will only have to match the remaining, but still give them the option to change the mapped one if they so choose. Thanks.

I have noticed that when an error is present i attribute removers the mapping to the writer is not correct.I am using ESRI interoperability's FME engine and have had very bad experience.On esri version 10.2 the error is visible in the mapping - the "lines" will be moved around, On ESRI veriosn 10.3 its ´really bad, because the lines are correct but data is put into wrong Places.Is this a know error ?

Hi,I have a situation where I have two file geodatabases. They contain subsets of data from the same spatial areas and have a structured coding (see example image below).As the layers can be large I wan't to process them in a workbench one pair at a time. But there are many pairs, so I would want to batch this. I know of a method to do this using PATH reader and WorkspaceRunner, when the inputs are Shape files. But with the PATH reader you can't map in to FileGDB layers. I do not want to convert to Shape, as I would loose the complex attribute names.Any suggestions how I could send each pair at a time to a WorkspaceRunner in batch? Attached is the logic how it would work with Shape-files.Thanks for any ideas!

Example: MagikSF> vl.collections[:l!foreign_facility].at(45281100).lg_scale_annos $ a sw:db_set MagikSF> print(!) $ db_set: l!for_facility_lg_scale_anno226:(gis_id(1160218,959604322,45281108)) l!for_facility_lg_scale_anno226:(gis_id(1160218,959604322,45281110)) MagikSF> foreign_facility is joined with other large scale anno collection and in smallworld it is returning as ds_set. while exporting that, it is going as char and taking "db_set" as value in text format which is not correct .how to export this particular field.

Hi,Is it possible to set the attributes in the Feature information window so that the colors in the color will be displayed in the same color as igds_color without using the workbench? (Fme Viewer set fme_color like igds_color when input dataset) Is it possible to make a filter on attributes in the Feature information window so that we see only certain attributes in feature information windows?

Hello,I have a set of node data. Some of those nodes will have an empty attribute. I am trying to populate them (call it "config") based on previous or next feature. The condition is should be somewhere along these lines: If Feature[-1] exists AND Feature [+1] does not exist, then Config = feature[-1].ConfigAdversely, Feature[-1] does not exist AND Feature [+1] exists, then Config = feature[+1].ConfigIf both exists, then Config = feature[-1].Config. I am trying to write out the conditional statement and have adjacent feature checked. The conditions only allow for checking if an attribute is null, missing or has an empty string. I don't seem to have any option for the existence of a Feature itself. Any one have any idea how I can go about that? Thanks!

Hi, I have geometry in one Oracle table and attribute information in another which I am merging using feature merger. This works fine, the problem I then have is that I need to write to shapefile and it truncates fields to 254. In one particular field there are 100+ attributes that are over 2000 characters in length. I know I can use substring extractor to extract various lengths but does anyone know how I could ‘automatically’ create x number of attributes (each less than 254 characters) so that I would have 10 attributes of 254 length etc. that would make up 2,540 characters? Thanks

What method do use to parse the Filename (multiple) parameter in python?  I currently use source = FME_MacroValues['Param1']if source.startswith('"'): from shlex import split fileList = split(source[1:-1])else: fileList=[source]  but it feels clunky.  The assumption is that if it's a single file, it is not wrapped in quotes, but if it's multiple files it is: ""file1" "file2" "file3""

Hi,When I use FeatureReader and read the data, I'm receiving features with attribute names ending with (encoded: utf-16) and (32 bit integer). When I use the normal reader, I'm receiving the attributes as-iseg: id (32 bit integer) and ATTR1 (encoded: utf-16)Could any one tell me how to get the attributes as-is because I have to use the same attributes in featurewriter and write the data with Automatic attribute definition There are 1295 feature classes which is not possible to define the attributes for each feature type...Pratap

When I installed FME I think I checked Yes, when asked if I want to report usage statistics Anonymously to Safe Software. But I don't want to report this anymore. How can I turn it off?

I have a vector dataset containing buildings and a raster dataset containing elevation data.I am looking for a way to find the mean and maximum value of the roof of each building.So far I have converted the raster dataset to points, extracted the raster value to an attribute and clipped it with the building polygons. The StatisticsCalculator can help me finding the mean and max value in each building, but before doing that, I would like to remove the outliers.So the question is: how can I remove the top and bottom 5% of the values in a list?