FME Form

I am trying to write a bunch of shape files to a geopackage but am getting a strange error.  'OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "table_name" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL' There seems to be a problem when the writer constructs the primary keys for the database, but I have no idea how to address this. There is no id attribute in the source data, I actually tried adding one and the writer handled this by changing the name of the primary key to id_0. Still got the same error though. I am using fme_feature_type to set the table names and schemas.

Is there a similair function as DateTimeNow() which takes only the current date and not the time part? I know I can make use of Timestamper but I'm curious if there are other even more simple ways of naming by date in the writer using Date functions.

Has anyone got a method to rebuild a flattened json file using the dot notation? Essentially it would be the JSONAttributePacker but with a iterative approach?

I have upgrade from FME 2016 to FME 2021.2.When I am running the FME script, if I don't give source dataset in SCHEMA READER then I am facing "No Schema Dataset found" issue. But the same script runs fine on FME 2016. I think FME 2021.2 is not accepting empty string (i.e. no dataset) as input.Is there anything I can do to fix this issue ?

I get this error periodically when running a workbench copying from Oracle to SAP HANA. Only a handful of tables here and there, I've yet to establish a pattern. There are no issues with the permissions, and no queries left in the tables on the Oracle side, as far as I know.

I have many vue 3D model, how to convert them to fbx, so i can use it to many applications.

Hello,I have several website from which I need to read data, mostly stored in tables.For the public website, no issue as I am using I am trying to reader 'HTML Reader'.For the secured website, the sequence would need to navigate first to the login page, (https://members.embuild.be/fr/user/login)enter credentials, navigate to the secured page containing the desired table and read the html table.After reading several posts, my designed workflow would:HttpCaller URL: https://members.embuild.be/fr/user/login, method: POST with body 'Mulitpart / Form data' and the upload: Name - Type - Value = name - String Upload - my@email.com and Name - Type - Value = pass - String Upload - myPassword.HttpCaller (En Serie from the first one), URL:

Hello there I have a published workspace that generates WebSocket stream, and I need to consume the data into ArcGIS geo event using input (subscribe to an external web socket for JSON ) I cannot figure out the URL structure that should be used to expose the WebSocket stream to an external app.   This web socket configuration and this is the Geovevent configuration. Note: I need the correct URL to put in the (remote server websoket) filed

The Reading JSON tutorial demonstrates using Feature Reader to fetch and parse data from a bare url. However I need to fetch from a url that requires a token in the http header. I've used HTTPCaller transformer to do this successfully and I have json data in `_response_body`. However when I feed response body to FeatureReader it treats that as a *path* and not *content*. (It took me hours to figure out this what the error message meant). How do I read the `_response_body` from the http call as *content*? https://community.safe.com/s/article/json-reader-configuration

I have a shapefile with 1000 polygon data and shapefile includes 50000 unique lines. I want to connect both lines that are inside the polygon. I used the spacialfilter but it couldn't detect properly endpoint of the lines which are inside of the polygon

Having issues with info being extracted into the CLOSED 45 DAY attribute-that is created with the ATTRIBUTE CREATOR. Thanks for all recommendations.

To create a web service for CKAN connecting to the Open Canada server, I have tried various permutations around https://open.canada.ca/data/en but no luck. Thanks!

I need to create an RDF Turtle (ttl) file to CSV convertor for asset data structures. There seems no RDF reader in FME available. What would be the best approach to read RDF Turtle files into FME for further processing ?

I am updating an older FME script (2019) to 2022.1, and am getting an error when passing an empty value to the published File/URL parameter, even though it has not been checked as Required. The error message is: No CSV2 dataset name was specified (couldn't find a value for `R_2_DATASET' or `CSV2_DATASET'). This seems to be a new issue with 2022.1 version, as I am updating the script from 2019 version. Is there a way around it?

Hi there,I have a process in which separate gdb are written and indices are created on specific attributes. The next step of the process merges these separate gdb into one using dynamic writingWhat I want to know is do these settings (creating the indices) are carried over when writing dynamically and if not is it possible to index the specific attributes after the writing? (some python voodoo magic….) Thanks,Itay

I would like to implement a variable as a buffer. However, once I define the variable, it does not get updated.  For example: The variable has to act like a buffer.. At the moment, I have the variable implemented in the def but I think this is wrong.  def buffer(feature):   puffer = 'leer' for i in range(0,50):    if puffer == 'leer': feature.setAttribute('value', value2) puffer = 'value2' else: feature.setAttribute('value', value3) For this example, I get always the Result from feature.setAttribute('value', value2). I have also tried to create a class withdef __init__(self) and Input and close.But I don't get a Result.The result should be written in the attribute table of a shapefile Can anyone help me?

Hi everyone,I'm using FME Version 2022.2, build 22782. We try to use PythonCaller in a FME worklow, this PythonCaller need to use lib with Python 3.7 compatibility. We change the Python Compatibility in Navigator>Scripting>Python Compatiblity to Python 3.7+ and we change in Tools>FME Options>Translation>Python Interpreter>Preferred Python Interpreter to FME Python 3.7+ without success. Indeed in the Translation Log we always have this message : Python version 3.10 loaded successfully A workaround is to use the 3.7 dll of the Anaconda installation directly on machines running FME 2022.2. However, isn't there a way to force the use of the Python interpreter, for python 3.7? We try to force the Python interpreter by using the print() in Startup Python scripting (see https://commu

Hi,I have been investigating this for some time, but did not find any solution so far: In order to read sharepoint lists from a predefined sharepoint site, I used the web connection "Microsoft SharePoint Online (Template)". As testing / reauthentication was successful, I felt ready to read a list from this specific sharepoint page so I inserted its URL and indicated my web connection. However, when I click on "Lists" to retrieve the lists I created, I get an error message (see attached). The error in the log furthermore shows:"Failed to obtain any schemas from reader 'SHAREPOINT' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information" I am using FME 2020.2. Do you know what I am missing here?

Hi. I know it is a basic ask why FME Data Inspector is not opening. But, I have check for visual preview window, task manager for any FME Data Inspector open items, installed a fresh version of Desktop(2022.2.3) and also tried restating the machine. The last window displays 'initializing user interface', and nothing pops-up.Can someone suggest a quick solution to this?Thanks.

I'm an FME newbi. Feel like it's something very basic but couldn't come up with a solution on my own.What I want to achieve is to get 80% of the value from column B to column A, but some of the features have multiple values separated by a comma, soo they come out as NULL. I went through previously asked questions but couldn't find anything. Appreciate any help! 

I would like to extract 'Orientation' >>  Plz any idea what setting i use so that i could see those value in table in filter the data according.  

HelloI want to transform with fme a shape file containing the sewer pipes into a file that can be integrated into the EPA SWMM application with .inp format (text file). Do you know any fmv schematics? THANKS

I have a situation where .dgn linework is being drawn with a custom line style (a treeline). I need to test whether the arcs of the treeline intersect with building edge linework. But when I load the .dgn into FME, the custom linestyle is not represented. It is still present, and (with the correct seed file and rsc and other tricks) I can write it out, but I need to work with the custom parts within FME. Is there any way to do that? A similar option to expanding cells, but for lines? Or some other approach that would work?

I am trying to convert an IFC TO CESIUM TILES 3D with FME 2022. The projection EPSG:3857I tried an d follow the explation here:https://community.safe.com/s/question/0D54Q00009TdMzbSAF/cannot-convert-ifc-file-to-3d-tiles  But i got this has an error: The below feature caused the translation to be terminated GeometryPropertyExtractor_<Rejected> (TeeFactory): GeometryPropertyExtractor_<Rejected>: Termination Message: 'GeometryPropertyExtractor output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' I also tried to convert directly an i got this:CESIUM3DTILES writer: Unable to reproject the 'EPSG:3857&#39

In both 2022.2.5 and 2023.0.0, I am unable to read DWG files or DGN files. The translation log reads:DWGAutoCAD Reader: An error occurred for dataset 'xxx.dwg', in function AutoCAD2004Reader::open. Exception thrown: 'Extended error' (The file cannot be accessed by the system. SCENEOE_23.9fme_17.tx) Failed to obtain any schemas from reader 'ACAD' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information Translation FAILED.Error running translation.Workspace generation failed.  Parameter file was C:\Users\JSDBRO~1\AppData\Local\Temp\FME_1683040838597_37964.DGNFME API version of module 'acad/ACAD' matches current internal version (4.0 20220615)