Best Answers

 Good Evening, there is an issue I cant solve by myself, maybe someone can help me. I have a dataset of features ,which i want to analyse and one rule is, they need have 3D coordinates and cant be 2D if they dont they should be filtered out. How can I approach this? THX to all.  

Hi,I have a problem with adding a reader for a geopackage that contains a TIN. Adding the reader fails with the message: "No geometry mapping entry found for 'wkb_point' in metafile 'C:\\Program Files\\FME\\2020.1.0.1\\metafile\\OGCGEOPACKAGE.fmf'" Data is somewhat strange, since the layer identifiers are long (way over 30 positions) and contain spaces and minus signs. In QGIS, the data is displayed correctly though... Any idea what might be causing this error? The data is proprietary, so I can not share. I'm using FME 2020.1.0.1.

Hello, I'm trying to extract data from Oracle database with several thousand tables to CSV files.Because of the number of tables, extracting each table to CSV file is not an option. Is there an automated way to read the list of tables from Oracle DB (non-spacial) and extract each table to CSV files? I haven't been able to find any articles or forum questions to do that. Any help will be appreciated. Thanks.

I have built an app with a geometry published parameter as input for the user. In my workspace I have the 'Optional' box unchecked, meaning it is a mandatory (not optional) parameter. However, when it is left blank and the app is submitted, I don't get a prompt telling me that it is needed. The job is submitted to server but fails right away, because it doesn't have a location. Other mandatory published parameters give a prompt to the user if they are left blank when the user tries to submit them. Is this a bug that the job is allowed to be submitted when a mandatory geometry parameter is left blank?

Hello, We are running FME Server 2020.1.0.1 and are trying to connect it to our AD to allow users to login and run automations. We keep getting the below error and we are not sure what to try next.Unable to establish connection to directory server (91)Port: 636Connection Type: SSLAuthentication Type: Basic

Hello, the objective of the workbench is to cut objects in order of priority according to the values of the attributes. The priority has to be fixed automatically.I first generate a table that looks like this:The objective is to autmacitally generate the order of clipping in a table : I don't know how to solve this problem, can anybody help me?Thank youRonan

Hi,Can anyone please help me on how to normalize a set of greyscale images using FME ? (Transforming the scale range of radiometric values to the [0,1] interval) thank you very much

Is there a easy way to do that in FME?Thats how i did it:now i wonder if there is a easier solution.

Is it possible to retrieve the advanced information from Automations (like 'Queued Job Expiry Time' and 'Running Job Expiry Time') from the FME Server API?I would like to automatically check if these options are used for all my automations.

I have an attribute in a .gdb containing dates in the format (yyyy) in a geodatabase in short integer which I need to change to an actual date attribute in the format (dd-mm-yyyy) with the date being january 1st for all. Is this possible? /Rasmus

I have a survey123 application. i am trying to connect the feature class connected with this application in ArcGIS Online to my local database. For this i am using FME Workbench. I have previously conencted Arcgis online feature class using fme desktop and it worked fine. This time however i am getting the following error. ArcGIS Online Feature Service Reader: Could not find a Feature Service item matching the Feature Service directive I am using FME 2020.1When i added the AGOL reader and chose this feature class i am getting column names in reader which means it is able to connect to feature class, when i press the see source data on reader I can see the data as well. It gives me error when i run the FME even if i don't have any transformer and just inspector.

Is there a way to enable feature caching between sessions, so that the workspace doesn't need to be re-run after closing Workbench? Thank you.TylerFME Workbench 2020.2.1.0 Win64

I'm working on updating an (old) workflow that was made with at least version 2018 (but could be earlier) to 2020.1.2.1 (20200909 - Build 20624 - WIN64) . Both in FME 2018.1 and 2020.1 this flow and its Custom Transformer work like a charm. When upgrading a ListConcatenator in one of the transformers from version 2 to version 3 it stops working. I also checked in 2018 and it had the same problem so it is not just my 2020 installation. I'm getting the following error:2021-01-08 13:10:44|   0.6|  0.0|ERROR |@Tcl2 -- failed to evaluate expression `set Titelblok_koppelen_validatieRegels_en_TagValidatie._ListConcatenator__separator [FME_DecodeText {<comma>}]; regsub -all "{}" [FME_DecodeText {_list<opencurly><closecurly>._listTags<opencurly><closecurly>}] [FME_DecodeText {<opencurly><backslash>d+<closecurly>}] Titelblok_koppelen_validatieRegels_en_TagValidatie._ListConcatenator__listPattern; set Titelblok_koppelen_validatieRegels_en_TagValidat

I'm attempting to confirm that a set of GeoJSON area features are geometrically identical to a Shapefile produced from the same source. Of the 19k features, less than 400 come out as Unchanged, with the rest going to Inserted AND Deleted. I've set match Geometry to 2D and turned ON Lenient Geometry Matching. When I write the same GeoJSON out to Shapefile, the resulting Shapefile gets all of its features routed to Unchanged under the same settings.  Any ideas as to why I'm seeing this behavior?

Hi guys i found alot of question about CSS selectorbut no answer to my case so I tried to post my question How can select the blue info  <span>ISTITUZIONE TEMPORANEA DEL DIVIETO DI SOSTA PERMANENTE CON RIMOZIONE COATTA DEI VEICOLI IN UN TRATTO DI VIA DONATO BRAMANTE.</span> which CSS I have to use ? Sorry I'm new but the help need more more more examples from my point of view thx for support Francesco 

I have set up static IP adress for the cloud instance as I assume this is necessary?

Hey, How do you split two differents feature type, like point and polygone, that went into a Tester together, back to being independant again. Thanks, Ian 

Hi guys, I'm looking for a way to adjust vertex order in triangles. First point should be the one with smallest angle between two edges. Remaining vertixes are to be oriented counter clockwise. Is there a build in transformer that offers such functionality or does anyone have a ready to use solution/idea? Thanks in advance!

Hi, I have a set of polygons (representing the street blocks) from which I was able to create centroids. I would like to create a grid from those points, meaning that points would represent grid intersections. Have already tried with triangulation but had no success.If it is helpful I can try and upload a sample. I would really appreciate any suggestion. Thank you.  Edit:I believe I need to explain a bit more. In the current approach I am creating a "grid" based on the street centerlines and merge them with Neighbourhood Aggregator to 800x800m cells. The problem is that at the end grid borders are always on the centerlines (one side of the street is in one cell, where the other side of the street is in neighbouring cell). I would like to now try a different approach, where the grid borders would connect centroids of those blocks, this for example would be the output (red lines). Ideally, they would have a more rectangular shape, but not exclusively, it could also contain squa

I'm struggling with the PythonCaller Transfromer regarding multiprocessing. The script below is a simple example to illustrate my problem. How can I get it running as a PythonCaller script? Currently the translation log says:File -c could not be openedProgram TerminatingTranslation FAILED.Error running translation.Translation Abortedimport multiprocessingimport randomimport time def worker(t, i, return_dict):    print("Sleep {} seconds".format(t))    return_dict[i] = t    time.sleep(t) def multiprocessing_test(n):    print("in multiprocessing_test")    manager = multiprocessing.Manager()    return_dict = manager.dict()    jobs = []    for i in range(n):        p = multiprocessing.Process(target = worker, args=(random.randint(3,6), i, return_dict,))        jobs.append(p)        p.start()    for p in jobs:        p.join()    print(str(return_dict)) if __name__ == "__main__":    def processFeature(feature=None):        print("in processFeature")        multiprocessing_test(10)     #proces

I'm trying to extract all of the data from a table that lives on a webpage along with the hyperlinks that are embedded inside of one of the columns. The HTML table reader is only able to return the data that is displayed on the webpage, not the hyperlinks that are present. On the flip side, I can only get the HTMLExtractor transformer to collect the first record in the table. Attached is my workbench... what can I do to collect all of the records in the table?

The error is 'Unauthorized request by user due to lack of proper permissions'All other API-request seems to work fine. I checked all the permissions, and i have all permissions.  Anyone an idea why this is not working.  Screenshot Using FME Server build 20787)  

Hi everyone, I'm running FME Server 2020.2.1 Build 20806 on a Linux Debian 10.6 host. I need to run a workspace that writes to a sqlite database previously uploaded in the shared resource data directory, but the workspace fails complaining it can't write to a read-only database. I discovered that when I upload a file in the shared resource data directory through the Web User Interface, the owner user:group of the file is root:root and not fmeserver:fmeserver as expected. After changing the ownership of the file (the sqlite database in this case) to fmeserver:fmeserver using the shell of the operating system, the workspace runs fine. This is obviously a workaround which is not suitable for a production environment with several users. Can anyone help me solving this issue? Thanks!

Hello & Happy New Year Whilst testing this transformer I realised that if I set it to:Download "As File"Download To Folder "Intentionally set to wrong location"  Then the invalid setting is not rejected nor the cog changing its colour to red.Is this by design? If I, of course, amend the ObjectID then the feature will be rejected.I also set the target folder (wrong location) as an attribute and same result ThanksSameer

Hi all,There is a issue connecting to Postgresql 12.Error executing SQL command ('SELECT c.relhasoids AS oids FROM pg_class c INNER JOIN pg_namespace n ON n.oid = c.relnamespace WHERE ...... 'ERROR:  column c.relhasoids does not existAccording to PostgreSQL 12 documentation, the "relhasoids" column has been removed from release 12.The error appears on both readers(PostgreSQL\PostGIS) and on different versions of FME Desktop: 18.1; 19.1; 20_beta.At the same time, the SQLCreator transformer reads the database without any problems.Has anyone else tested how FME works with new PostgreSQL 12?