FME Form

As you see, value is null so it gets ORA-01449(null).So, How can I setting value collumn ?

When reading in a zip file with three text files, it results in garbled data. Any ways to fix this?

I am trying to connect to sde database in FME. I am using ArcSDE geodb reader. I am getting this error. I am using an ESRI edition Fixed license.

I have been trying to figure this out for a while now and can't get it to work. I want to be able to launch a workspace runner from a python script as detailed here:https://community.safe.com/s/article/run-an-fme-workspace-from-python-using-fmeworkspac I append the path to "fmeobjects" as it mentions, which in my case looks like this:"sys.path.append(r"C:\\Program Files\\ArcGIS\\Data Interoperability for ArcGIS Pro\\fmeobjects\\python37") ".But when I try to "import fmeobjects" I get the following error:"ImportError: DLL load failed: The specified module could not be found." I assume the path is setup correctly otherwise when mistyping the module name it gives a different message "ModuleNotFoundError: No module named 'fmeobject'". Any ideas what might be going wrong? I have tried running a program called "Dependency Walker" to see the other dependent ".DLL" files "fmeobjects.pyd" requi

Hello, happy new year！ I meet an issue with the AnchoredSnapper converter. I use the AnchoredSnapper and SpatialFilter converters can't correctly filter the containment relationship between the two cad layer faces. Can anyone help, thanks  I uploaded my CAD data, JMD and JZD layer, I want to get JZD contain layer of JMD

Hi, I am looking at snipping the Midpoint of a line with 2 vertices (index 0, index 1). Tried several ways but can't seem to get it right. My snipper creates the point at vertex index 1. Is there a way I can implement this? Thank you.

This is the error message:The database generated an error while attempting to convert the string `0.8' to an OCINumber, so alternative number parsing was performed. (serverType=`ORACLE8I', serverName=`****', userName=`*******', password=`***', dbname=`') It doesn't matterhow you cast the number in the sql query.

Hi :-)I have an issue with FME Desktop 2020:Whenever I open a workspace which includes an InlineQuerier (to be precise: with a filled SQL-query at the output-port), I get the error "File C:\\Program Files\\FME_2020\\metafile\\SQLITE.fmf could not be opened" inside the Translation Log.When I open the same workspaces with FME Desktop 2019, this error does not appear. Further system-infos:I have installed FME Desktop 2020 (path as mentioned above) alongside with FME Desktop 2019 (default-path).FME Desktop 2020 Version: 2020.1.2.0 Build 20620 WIN64FME Desktop 2019 Version: 2019.1.3.0 Build 19642 WIN64Thanks in advance and best greetings :-)Florian

I have implemented a Python script to interface with Speckle to access the server, retrieve data streams and ultimately retrieve the JSON geometry object for parsing in FME. This runs and retrieves data in my base Python install, the FME REPL command-line Python build but will not get over the first hurdle of interfacing with the Speckle Server. Are there transport restrictions to python code? I can't find documentation around this. Before I try writing a bunch of scaffolding code just to trace back the problem it seems best to see if there is a fundamental restriction I won't overcome. Some suggestion on the Speckle forum is that it may be related to SSL certificates...?

I just want the resulting dwg to have the exact same layer colors and linetypes as the source.Anyone succeeded in doing so?

 FME 2020: How to get all the layers automatically selected when the dwg file is selected as a source file in the reader? I found out that each time a dwg file is selected (as per the screenshot below), the “select all” option is not checked by default.  How this option can automatically be checked as any dwg is selected as a source?                   

add variable in json reader from user parameter like this;

Hi;I get ifc output from SketchUp. Although the materials look normal, they are not displayed properly when I read them with Fme.  SketchUp   FME  How can i solve this problem.thanks 

Hello FME users. I can't solve the problem of passing all the points along the shortest path. I can't make a cycle with sorting. Please help me.

I would like to use FME as a 3d model converter/processor. We know that the 3D Clipper of FME is not being supported yet and I would like to split the osgb model with z values using https://www.openscenegraph.com/ such as using this example code https://github.com/openscenegraph/OpenSceneGraph/blob/master/examples/osgclip/osgclip.cpp#L109 . However, I find that the osgt file cannot be recognized by FME and the following error messages are shown: OSG Reader: Ignoring unsupported nodeOSG Reader: Ignoring unsupported geometry - only surfaces are supported How I can generate a cropped 3d model that can be opened by FME? Any suggestions are welcome! Thank you.

Created a user to use with FME desktop for our local ArcGIS Enterprise Portal. When connecting in FME Desktop using the ArcGIS Portal Feature Service Reader it gives an error saying bad password. Figured out that the generated password for this user must have had some characters that were not supported in FME. What Characters are not supported for passwords in this reader?

I am noticing that the number of features and feature types between the Merged Feature and Individual Feature mode are quite different. My expectation was that when you select "Read All Elements", it would...read all elements, regardless if merged or individual. I compared two different files and both had more features and feature types in Merged mode. I am not specifying a view and reading geometry as non-spatial. One had 5 more FeatureTypes, the other had 13 more! Why?  Thanks,@larue​    

Is it possible to add a "$filter" parameter to an OData reader in FME 2021.2 ?  

for an example:why is the result not is 1 but 4

coordinates of given type extract coordinates and type

hello there we need to aggregate all features into one, we are unable to write it to PostGIS or shapefile, by checking the geometry we find type collection how could we solve this and write the output, all features are line features Thanks 

I have a column in a table with names and I want to find the ones with alphanumeric string and replace it with a null value. Apparently this is erroneous data in the table.  Sample Data in the column NAME:GREEN-BROWN TREES --> Leave as isFORT/STRONG -> Leave as isPEACE RIVER --> Leave as is3T7H8HF54FD --> This is the data I want to find and replace with Null Greatly appreciated. Thank you.  

When running "my" workspace I get an error at the end of the translation, after writing the output, with the message: "Error running translation." No further errors are given. The tail of the output:==============================================================================Total Features Written                                                      32=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Translation was SUCCESSFUL with 773 warning(s) (32 feature(s) output)FME Session Duration: 1 minute 10.3 seconds. (CPU: 40.2s user, 6.5s system)END - ProcessID: 1680, peak process memory usage: 320516 kB, current process memory usage: 172000 kBError running translation. The workspace converts a DWG to GML. It uses an Excel sheet for some mapping rules/lookup tables. Other DWGs do not have this problem, only two DWGs cause this. The DWGs are not corrupt, at least AutoCAD complain that these DWGs should be recovered. Furthermore, the `AUDIT` command in AutoCAD do

I know this can be done, but can not find the right way:How can I add the current Date and Time in the name of the Log file?Preferred format is: YYYYMMDDH24MIAny help is appreciated.

Hey,Since a day or two I can no longer read my data. I always get the same error, even when I try it in another workspace. Does anyone know what it could be?I use FME 2021.0 and i'm trying to read a postgis table. ThxNathalie