FME Form

Hi,I'am trying to read a schema from an Oracle table through the FeatureReader. This works well for lets say TEMP.TABLE when the connection user is a different name than TEMP. When I connect using a user TEMP I don't get a schema. But after removing TEMP. the FeatureReader returns a schema. This if no problem when I know in advance which user is connecting, but in my case it's all dynamic. We use connection names and the user behind this connection can be the same as where the tables are stored.Is this a bug? Or does anyone have a solution? Thank you,Arno

When writing strings to a SQL-Server database, leading blanks are removed. Is there a way to change this behaviour?

Forgive me for what is likely a very simple answer to this question, but I'm still rather new to FME. I'm wanting to use a defined User Parameter (Type - Text) which will then inform my AttributeFilter transformer (where the user parameter directly corresponds to a specific field of the dataset being read by the AttributeFilter transformer). However, when I set the transformer parameters as per the screenshot below, I don't then get the expected output, i.e. the dataset filtered for that specific value. Is there something I'm missing? Thankyou for taking the time to read this post. 

Does anyone know how to obtain the “2.7 or 3.4+” python compatibility - dll file for transformers to function? After upgrading from 2021 to 2022.1 the Python 2.7 compatibility has been lost. Thank you.

Hi My code is working fine with FME Desktop 2014 but having error while compiling it with FME Desktop 2020 with below error error C2259: 'CtFunction': cannot instantiate abstract class as the IFMEFunction::execute is deprecated and need to upgrade it.

Hi everyone, I am trying to get the value of the first table (that only has one row with info about xmin, xmax, ymin etc.) into the 2nd table. The second table has more rows and my wish is to have all the rows in table to get the same value for e.g. xmin from the first table. However in the 2nd table only the first row gets the value of the first table, while I want to have all the rows the same value for that column. Does anyone how that might be achieved? In case my question is not clear, just let me know.

I am attempting to pull in some USGS groundwater data from a large number of sites over a number of years. The USGS has a website that can publish a JSON service that I am attempting to consume in FME Workbench.  Here is a LINK to the website. Every time I attempt to grab one site or 100 it fails in workbench using the JSON reader. The error is consistent at least. The feature reader in the log just says that the file doesn't exist. I'm not sure what I am doing wrong on the setup to bomb that quick in the process. Any guidance or info would be greatly appreciated.

I have to manually define VARCHAR(n) instead of TEXT <null> in the writer. This is very frustrating as I have hundreds of tables already defined. Using a reader resource ignores the DDL stored in the table. So is there a workaround? Here is and example DDL from the source SQLITE table:CREATE TABLE "System_Code" (   "OID" INTEGER NOT NULL,    scg_code VARCHAR(4),    code VARCHAR(4),    desc_ VARCHAR(2048),    status VARCHAR(4),    date_value VARCHAR(25),    char_value VARCHAR(2048),    num_value FLOAT,    start_date VARCHAR(25),    end_date VARCHAR(25),    et_created VARCHAR(25),    et_edited VARCHAR(25),    PRIMARY KEY ("OID")Which ends up half complete:

Hi! I am trying to read into FME a series of images (jpeg/tif/png) and then match them to a different datasource and rename them using pieces of information from both sources. All works well. But. I have some files which contain special/accented characters which aren't being read in. For example the filename below  Anadolu Koyu PLAN_IZMIT KÖRFEZI TO ISTANBUL.jpg throws an error 'Anadolu Koyu PLAN_IZMIT KÖRFEZI TO ISTANBUL.jpg' cannot be located. Please ensure the file exists and is accessible' The common denominator in all of the errors is the special/accented characters. My question is whether I am missing something and I can get FME to read the filenames and bring them into the workspace, or whether I need to handle these (hundreds of) files manually? All helps much appreciated!

I have a large set of raster images (they are aerial imagery) and they were taken under various different light conditions. I would like to use histogram equalisation to correct for this. Does anyone know if this is possible in FME please?

Hi,I am translating a DGN file to File GDB using dynamic schema.In DGN reader, i can see so many extra attributes like attribute.color, attribute.length etc. I want to ignore those attributes in file GDB writer.I am using attribute keeper but it is not working in case of Dynamic Schema, Please guide.Thanks in advance.

Hi, One of our team members left the team but has still FME Desktop on his machine + the connection to the license server. How can I revoke his rights in order to use one license of our floating license server? Thanks!

I am converting a dgn file with lightweight polylines to an autocad file. The input dgn file has a size of 70 MB and when I am converting to a dwg the size becomes roughly 97 MB. The dng consists thus of lightweight polylines and during conversion to autocad there is automatically a z component in the autocad file. Based on the following page FME Creates Large AutoCAD DXF Files (safe.com) I included an autocad_original_entity_type attribute in the attributemanager with the following value autocad_lwpolyline . The size becomes then 95 MB. I would like to make the dwg much smaller, how can I make the file much smaller than 95 mb by changing somethign in the autocad writer or doing some kind of transformation.

I'm attempting to run a workspace on FME server that writes a gdb which uses an xml template file. If i upload the workspace and choose upload files, this works fine. If I try and use a parameter to set the location of the xml file and upload the file to the appropriate resource folder the process fails with an errorThe error message from ArcObjects is: {unable to open primary document entityI know the file is in the correct location as a file not found error is generated if the file isn't there. Any ideas?

Hello FME Community I'm getting following error when trying to read events from Azure EventHubs using AzureEventHubsConnector: Python Exception <TypeError>: Message data is not compatible with string type: 'generator' object has no attribute 'decode'All parameters were set correctly and events are actually passing through other clients.   Thank you in advance! 

Log details :  FME Configuration: Using connection values from 'J10_170' for R_3Creating reader for format: PostgreSQLTrying to find a DYNAMIC plugin for reader named `POSTGRES'FME API version of module 'POSTGRES' matches current internal version (3.8 20180604)FME Configuration: Using connection values from 'J10_170' for R_3Creating reader for format: PostgreSQLTrying to find a DYNAMIC plugin for reader named `POSTGRES'FME API version of module 'POSTGRES' matches current internal version (3.8 20180604)Opening POSTGRES reader for dataset 'postgres'PostGIS client encoding: 'UTF8'PostgreSQL 9.5.25 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bitSuccessfully closed POSTGRES database readerSuccessfully closed POSTGRES database readerMerged 0 schema features read from 1 datasets into 0 resulting feature typesUniversalReader -- readSchema resulted in 0 schema features being returnedReader Parameter(

The workbench is checking where lines, points and polygons intersect with 2 other datasets (one a polygon dataset, the other a line). The workbench worked when initially built but after saving and coming back it no longer runs with the following message being displayed.  Starting translation...Too many recursive macro substitutions -- line currently is: `OS_MASTERMAP_WATER_NETWORK_GML_2_DATASET "$(SourceDataset_OS_MASTERMAP_WATER_NETWORK_GML_2)"'Program TerminatingTranslation FAILED. I've attached an image of what the workbench is looking to do. Inputs are mid/mif and gz. Outputs are xls and geodatabase. Any idea why this might be happening and how to fix would be greatly appreciated.

I have a polygon and two lines inside.The Lines z is true elevation and lines snapped to area in 2d.I want it to generate points at intersection points and snap 3d to lines like in the figure.The sample data (dgn) is attached.    

I have a linear feature and need to create another linear feature perpendicular to the original feature and at a given distance along the original feature from the beginning point.  Any help as to how to accomplish this would be much appreciated.

I'd like to have the value of an attribute as a user parameter.I need to make sure tables I work with comply with a schema. The schema field names are in a CSV, imported without column headers. I aggregate the attribute which leaves me with this output:Is it possible to get the string in col0, row 1, as the default value in a user parameter to ensure my output table conforms to the schema? Thanks!

Hi I am trying to set up the trainingdatabase and are using the correct credentials that is specified in course. host: postgis.train.safe.com, port 5432, DB fmedata User fmedata PW fmedata. When test i got no answer from server. Tested in cmd and it seems to be down?..

I have a dgn file that consist of many models ( it corresponds to a building and every floor has its own model) and I would like to import the models as seperate features in FME if that would be possible. When I try to import individual feature types in the dgn reader, instead of the models I get all the level names instead that are present in the models. So the feature types do not correspond to the model names, but to the level names. So for example I would like to get a seperate feature type of a model for floor 1 and of a model for floor 2. Does anyone know how that might be achieved in FMe desktop?  

After .obj files had converted to cesium 3d tiles, buildings created transparently. When I looked behind building, I saw another building. I dont want it. I want that these buildings are opaque. Is there any way for this?Thanks!

How to compare two database schema (File GDB & SDE) including subtype & domains values.

I have an existing workspace that writes files using a fanout by a selected attribute. The workspace has been promoted to FME Server and runs on a monthly schedule. I noticed recently that the resulting number of output files was incorrect and after some troubleshooting I realized that the workspace will not work as expected unless the features are sorted by the attribute prior to being sent to the FeatureWriter with the dataset fanout by attribute. Should it be necessary to sort first? Is this something new?