FME Form

Hi,I was trying to use below python code in FME. But it is throwing an error i.e. '<TypeError>: bufsize must be an integer'. Can anyone help me on this to get it resolved? I will provide the complete script on request if required.Thanks in advance#Code used in python callerarg1 = ['pg_dump', '-t', 'schema1_table1', 'server1_conn','|','psql', 'local_conn']proc = subprocess.Popen(arg1,cwd=directory, shell=True,stdin=PIPE) #where #server1_conn = "host=<server_host> port=<server_port> dbname=<server_db> user=<server_user> password=<server_pwd>"#directory = C:\Program Files\PostgreSQL\14\bin 

I want to use the PythonCaller to read a value from the header of an ECW file. The value I am looking for is four characters long, starting at the position of 37. I want to then print the value. This is the code I have so far; import fme import fmeobjects # Template Function interface: # When using this function, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter def processFeature(feature):  pass   # Template Class Interface: # When using this class, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter class FeatureProcessor(object):  def __init__(self):   pass  def input(self,feature):   print ('start')   n = feature.getAttribute('fme_dataset')   print (n)   f = open(n,'rb')   f.seek(37,0)   print(f.read(4))   f.close()   self.pyoutput(feature)   print ('finish')  def close(self):   pass   But it does not return the value

Currently imported a 'subledger' text string via Attribute Manager. Need to have leading zeros added to the left so it is always 8 characters. For example, '1046' should be '00001046'. Please advise which Transformer should I use. Also another 'subledger type' text sting is dependent on the above 'subledger' field. If no subledger, it shows blank. If something in the subledger, then 'W' should show under 'subledger type'. Please advise how to achieve. Thanks.

I am reading non pyramid tiff files in CRS EPSG:3844 and I am trying to write to Geopackage Tiles with pyramids using Incoming Feature Tiling Scheme to keep the original CRS.Using RasterPyramider the output is one raster for each pyramid level, that translates to many tables in Geopackage Tiles and it defeats the purpose.How should I aggregate/combine the level rasters to write a consistent GPKG file (directly)?

I am constructing a workspace that builds a file geodatabase from a schema specified in Excel. Each worksheet row defines an attribute and its feature class and feature dataset hierarchy (and domain, if any, but that will be for another day). The schema has feature classes mostly nested in feature datasets but some are root level. For testing, I have extracted a small sample of the schema, representing thirteen combinations of feature dataset and feature class with one feature class at root level. Now, after Excel file reading and subsequent processing, near the end of the workflow the attribute records go through an Aggregator transformer, which creates the attribute{} list attribute. The result is thirteen schema features. Schema features exiting from the Aggregator have no geometry, of course, and consequently have fme_type=fme_no_geom and fme_geometry=fme_undefined. I created and set the following attributes on each schema feature to hold the values that I want to specify as

Attached workspace created using workflow option "Single Merged Feature Type" for Personal Geodb Reader.  Steps to experience the issue.Execute the enclosed workspace in FME Desktop 2022.1View the cached features of reader (Click on the tiny magnifier icon on the reader)Even though FEATURE_TYPES published parameter was set to Highways, data attributes of Highways feature class were not shown in the table under Visual Preview panel.You may check the issue by passing a different Personal Geodb and Feature type(s)

How would I build a workspace with an ECW Writer transformer, followed by a Python script that modifies the ECW image file after it has been written?

How to rectify this error?

I have thousands of data, and each datapoint has six attributes, which I want to store in one list per data point. Which transformer could be used for this?

Hi, I need to work with a file that uses EPSG:5682 as CRS but unfortunately it's not available in the CS Gallery. I tried to add it as a custom CS, as described in the online documentation but it's still not showing up. This was my workflow:I went to the online tool and pasted the ESRI WKT for EPSG 5682I entered the missing parameters (that weren't already populated from the WKT)I unzipped the files provided by the tool and copied them to ..username\\Documents\\FME (see attachment)After restarting FME, the custom CS is still not available in the gallery. Did I miss something? Thank you for your help!

Hi, We are creating an integration between Smallworld and FME Server. The Smallworld tool will call an FME workspace on our FME Server. The FME Server is hosted internally only and we are using built in authentication.  There is an option in FME Server to create a short lived session token via the api. I've set up a user that only has access to this repository that can be used to generate the token.  There is a second option in the Administrator interface to generate a fixed api token. When is this used? Is it more or less secure? The Smallworld developer notes that if you are using a user name and password to generate the short lived token then the risk is similar:'It seems to me that the API token with restrictions is more secure than username/password. Such a token is long and not recommended. It can be extracted from the Smallworld session and this applies for username/password.' For integration with Portal for ArcGIS we use the short lived token generated by a built in

Example: We have a layer with employees. Each employee has their own unique polygon. We can easily go in and create unique symbology for each person. We can use hashing and colors to allow overlaps.  The issue is finding a way that every time someone new is entered in the employee database, they get symbology automatically setup.  In other words, does anyone know if FME can create a new layer file, symbolized with rules, that accounts for new rows/values. We were hoping to find something in ESRI solutions but haven't so far. So now wondering if FME can just automatically recreate the base layers files that the map service would ultimately consume.  Thanks

I want to change the text alignment of the texts in a dgn with an attribute manager before further editing. Does anyone know the attribute that is responsible for this? Thanks.

I am downloading data through an API from OS open source. The connection is set up correctly and the data is downloading when ran but it downloads several versions of the data in several formats such as SHP file, GML and Geotiff. For my project im working on I only need the shapefiles but I cannot figure out what tool to use to filter the rest of the unwanted data types out correctly. Or maybe its not a tool and its done in the JSONfeature parametres?I have attatched some photos below so I hope it helps clear up any questions.

The above image should explain the issue.  I have tried AreaGapAndOverlapCleaner which fills the donut and dissolves with 1 of the polygons (I have chosen the polygon with the longest boundary at present), which results in below. This is ok but ideally I want the donut evenly split across both polygons. Is this possible? Can anyone recommend a transformer or number of them to get my required output?

I'm doing a basic transfer of Geomedia Text Features from one table to another. In the past I've always done this by exposing the oracle_element{} attribute and exploding the list. This is always worked fine but I'm running into problems with certain features that don't contain the oracle_element{} attribute. An example of what I'm talking about:create table source (id int, geometry mdsys.sdo_geometry);create table destination (id int, geometry mdsys.sdo_geometry);insert into mdsys.user_sdo_geom_metadatavalues(    'SOURCE',    'GEOMETRY',    mdsys.sdo_dim_array(        mdsys.sdo_dim_element('X', 610000, 660000, 0.0005),        mdsys.sdo_dim_element('Y', 5500000, 5550000, 0.0005)    ),    82232);insert into mdsys.user_sdo_geom_metadatavalues(    'DESTINATION',    'GEOMETRY',    mdsys.sdo_dim_array(        mdsys.sdo_dim_element('X', 610000, 660000, 0.0005),        mdsys.sdo_dim_element('Y', 5500000, 5550000, 0.0005)    ),    82232);-- row that translates correctly, sdo_gtype = 2001insert

Hi, I've a bunch of features relative to adresses and associated inhabitants.I've already grouped the features by similar street names and numbers wich results in the "match_id" column.What I need now is to sum each four "total..." column's value (separately) by using the "match_id" as grouping value.The goal is to get the number of peoples, etc ..., living at one adress.I've tried several transformers after the AttibuteManager but none return the attented values. Thanks for your help

Please can someone tell me how to write a WHERE clause in the feature reader that excludes records that do not contain a value.I have thousands of records and some of them have a Global ID - I want to keep these records.I also have records that contain NULL or no value - I want to exclude these values.I can perform this function in a Tester, but a colleague informed me having this clause built in to the feature reader instead will be much quicker. Perhaps someone can confirm this.Thanks, Frank

Is there a way to extract only the non-empty fields of an oracle table?Let's say I have a table like this one,    col_a    col_b    col_c    col_d   col_e    NULL     NULL     NULL     NULL    5    NULL     NULL     NULL     8       6    0        NULL     NULL     NULL    3    NULL     NULL     NULL     0       1and the subtable that I would like to extract should be    col_a    col_d   col_e    NULL     NULL    5    NULL     8       6    0        NULL    3    NULL     0       1Thanks

Hi Everyone, My Question:I am trying to read the Pset of an ifc dynamically. I have looked at a few sources in the forum but have not been able to manage. I would love some help on this topic. I have read a few articles on Dynamic Schemas and Updating Ifcs etc:https://knowledge.safe.com/articles/594/updating-ifc-example.html https://knowledge.safe.com/articles/1136/schemamapper-transformer-tutorial.html https://knowledge.safe.com/questions/32777/how-to-expose-all-attributes-in-generic-way-any-ma.html  My aim is to expose part of a custom ifcpropertyset that are created by an external user. I will know the naming convention, but I want to be able to use Regex or some sort of fuzzy match to catch the Pset incase there has been a mistake in the creation of these Propertysets.  For example if the Custom Pset is called "Pset_Project", I would like to expose it and all its Traits.But I want to make sure that if someone writes "Pset_prject" or "Pset_project1", th

Hi everyone, I need to retexture a citygml file using one (mosaic)image file. But I am facing an issue in the last steps using the Appearance Setter. I started with the WallSurfaces and managed to calculate the (row,column) coordinates of each wall-vertex on the new single image (derived from the previous textured model that used multiple images for one building in the appearance folder). The position of a (sample) wall3D projected on the mosaic-image looks correct, attached a screenshot from QGIS. I rescaled the row column coordinates to a 0,1 scale, with (0,0) representing the lower left corner of the image, and stored them as list-attributes for each wallsurface. I used these lists to set the u,v texture coordinates with the measuresetter transformer as explained in this useful post on texturing citygml :https://community.safe.com/s/question/0D54Q000080heXzSAI/3dcitydb-texture-coordinates Afterwards I used the appearance setter, connecting the imagemosaic to the appearance input, th

Hello I want to automatically add a tree to a class I want in classified point cloud data, how can I do that? Can you write me the order of the FME conversions, thank you very much in advance for your valuable information.

Environment - Ubuntu 16.04 LTS Docker Host, running FME Server 2018.1.1-20190122 images I am receiving an error - There was an error submitting the job - when trying to run a workspace within FME Sever. Digging through the FME Server logs I find the following error within the Resources > Logs > tomcat > fmeserverweb > localhost current log.07-Mar-2019 09:05:10.300 SEVERE [http-nio-8080-exec-1] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [JobRunnerForm] in context with path [/fmeserver] threw exception java.net.ConnectException: Connection refused (Connection refused)    at java.net.PlainSocketImpl.socketConnect(Native Method)    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:3

Hi,I have a MicroStation file (v8) with a table in it that I need to extract to csv. Can someone please advise? I am using FME2020.1 and I have attached the dgn.Many thanks,Chris