FME Form

Recently I tried to write a few million non-spatial features to a Hyper writer. At some point (around 11.000 features) in committing the features to the file (create if needed on a new non-existent file) it errors. With the debugging option in the log I was able to figure out that a 'COPY-IN' statement is executed I think.When I look at the documentation https://tableau.github.io/hyper-db/docs/sql/command/ no such statement is supported. Am I correct here?  Features per transaction is set at 1000. Bulk insert: Yes. Changing these makes no difference.  When limiting the features that pass to the writer it will write the file correctly. Like say about 50.000 no problem.

I encountered something a bit weird. In a bit larger workspace I wanted to apply parallel processing for part of the workspace, so I embedded that part of the workspace (which already contained some custom transformers) in a new custom transformer. Then however I obtained some issues with the parameters, it seemed that they were not passed on correctly. Attached is a workspace where I replicated the issue. It's just a dummy workspace that connects to an Oracle DB, and (aims to) return the static result; 'Greeting' = 'Hello'. Main;CT_0;CT_1;If I run the workspace with a d

Hello, I am using the sqlexecutor and I am populating the attributes to expose from sql query. It correctly displays them but there is a (ok) button missing to add them successfully. When I close the window (x), they won't be added.

Hey FME Users, There is a lot of information in and around OSM on the forum, but can we add OSM as the background map in Data Inspector?

Hello , How to solve self intersection ( p-case ) ?i would like identify which lines has p-Case and solve this problem ?as example I have a line with specific id starts at point and closed back at the same point .Will be possible to let the line to cross this point and no intersection at start point ,if it is possible .Thanks in advance .FME 2021

I have been tasked to set up an automation that will FTP a file from a State-supported site to our network.I have been advised to use the FTPCaller transformation to achieve this. I have the specifics to the State-supported site and, using WINSCP, can manually download the file. In order to do this, In WinSCP, I supply the host name, the port, and a username supplied by the State. Additionally, I have to click on the Advanced button, then under SSH click on the Authentication text, click on the ellipsis (...) under Private Key File I enter the name of a Putty file (that was given to me by the FME Administrator) The file is sent by FTP using this manual method. At this point I am trying to automate the process so that the FME, using FTPCaller as advised, will achieve the same transfer. However, I am not clear how-to setup the FTPCaller to incorporate all of the parameters (host name, port, username, Putty file) that I have been given for the manu

I have a workspace app that accepts a kmz dropped on it. The result is a postgres/postgis spatial overlay with the kmz. When there is no resulting feature I need to send a message to the app instead of the resulting data. I have added NoFeature testers into my workspace to capture any streams that do not have output. Just not sure how to generate a report and get that to the app when the workspace completes. I am thinking now it would be nice to have a count from each of the input data streams whether there is a spatial relate or not.Thanks for any direction.

I have a file geodatabase where backups are stored with a date in the name that gives the backupdate, BU_20230724, BU_20230731 etc. How can I select that only the latest will be read for further analysis? Normally, a feature class is selected under Constraints > Tables and you can select the one you need but, the latest Backup will not stay the same during the year. In a automated proces I would like to select the one with the latest date without changing it manually.

Greetings,I used FeatureJoiner to merge a Spatial and non-spatial records using a common value (grid_id).  I use a Tester to select a scenario ie date is 2000, 2030, 2040, etc.I then use a StringConcaternator to add a value to a cell (overwrite cell value), the cell for 2000 will be 0 -5. I also have a Tester for 2030 (2C), 2030 (4C), 2040 (2C), 2040 (4C), etc. The records in the FeatureHolder, should all be written to a single row.Instead I have a row per date/scenario?? For 2000 I have the following data. The output is written over n rows, not a single row??

HI. Do I still have to manually input using the AttributeExposer transformer, like the answer to the question below? https://community.safe.com/s/question/0D54Q000080hcshSAA/problem-ifc-reading-user-attributes What should I do when a user-defined property exists for each IFC file in the way that the fmw file runs FME Application in the shell and operates? please answer about my question. Regards,Bongsup Kim​

Hello all, I have a point feature shape file and road center line. I need to create the orientation of those point feature w:r:t the road center line .

Hello. I´m Topo79.I'm trying to export through pdf_rasterized_pages to an GeoTiff in its real coordinates but it's imposible. I've transformed a gdb into Adobe Illustrator, ffs and GeoPDF at once, but from GeoPDF to georreferenced GeoTiff it isn't posible.Thanks a lot ;)

Hi, I am trying to get CAD data into Smallworld GIS. I did get one dataset in, one layer from the Cad drawing into Smallworld. I tried it with another layer from CAD file and I got the message "insert operation failed" which resulted no data being inserted into Smallworld GIS. I am able to see all data in Universal Viewer so I am thinking that there must be something wrong with the writer. Is there anyone that can help me with this problem? Thank you gamze

Has anyone ever used the Wrike API in FME? I'm reading the docs and trying to figure it out but could use some help on how to get a token and then query data within tasks: OAuth 2.0 Authorization | Develop your own integration on the Wrike API

I've built an AutoCAD based automation in FME Form and use blocks with text for some of the output features. The text aligns how it was designed in the block in the FME Form output.   However, when running in FME Flow the text shifts. If I move the block slightly or edit the text in AutoCAD then it snaps back to the correctly designed position.I'm using the same template dwg in FME Form and FME Flow. 

Hello,I have a main table called "Documents". I need to create a table called "List" based on data from the "Documents" table. Within the "Documents" table, I have a column called "ElaborationType," and within it, the number 1 represents the main document. Numbers 6, 14, 33 represent documents related to the main document, i.e., they are lists. My goal is to generate results in the "List" table where the "RecordID" in that row matches the "ElaborationType" equal to 1, but it also repeats or duplicates that number based on the numbers 6, 14, 33.(EXAMPLE: 2302(6), 2304(MAIN DOCUMENT NUMBER 1), 3177(14) belong to the same group because they are in the same cadastral municipality KO_ID).Within the "List" table, I need to have 2304, 2304 because they are lists for the main document 2304, and they must have their corresponding year from the "FromYear" attribute.I

Hello,I am currently working with FME Desktop 2022 and I have encountered an issue while trying to generate sequential numbers in a column based on attribute values. I have two tables, "Dokumenti" and "KatOperat," and I need to create a connected table called "ListKatPlana." In the "ListKatPlana" table, I have two columns: "ID_KatOperat", "ID_List" and "creationDate".The challenge I'm facing is generating the values for the "ID_List" column based on the "Koliko" attribute in the "Dokumenti" table. The "Koliko" attribute represents the number of records that should be associated with each "ID_KatOperat." For example, if I have an "ID_KatOperat" of 2304 and the "Koliko" attribute is 9, I need to generate numbers from 1 to 9 in the "ID_List" column for that specific "ID_KatOperat."I have tried using an a

I am receiving a JSON file that's around 85 MB. The file contains a large around of elements in a single nesting. I want to extract a given value by looking at the neighbor key.  In the example below it could be that I want to extract the value "2.000" from the section where "field" has the value "Frontside heights interval".         "field" : "Frontside heights interval",         "value" : "2.000",Can this be done using the built in JSON transformers?{   "stackId" : "d9a5ba5e2a00407ca52b68f902e43393",   "departmentId" : "5f4adeebe93b46368e6451f8b43ba914",   "registrationPosition" : null,   "measurementPosition" : {      "longitude" : 9.6567316353411,      "latitude" : 56.30290238191994,      "height" : 29.993129805661738,      "accuracy" : 6.213567568298807   },   "stackNumber" : 0,   "polterId" : null,   "registrator" : null,   "surveyor"

Hi, I have features about vegetation observations with many attributes like Date, ObservationId, Latitude, Longitude, IdTaxon and IdTaxCompl.I did the following workflow obtaining successful results: 1) buffer features to a specific distance; 2) Dissolve buffered features grouped by IdTaxon (obtaining what I call "stations"); 3) Renamed IdTaxon to sIdTaxon on the Dissolver resultant table; 4) Add a UniqueID for each station; 5) using a combination of PointOnAreaOverlayer, ListExploder and TestFilter I manage to join the corresponding StationId to the original observations table. To do this I set up PointOnAreadOverlayer to produce a list On Output 'Point' with the selected attributes "_ulid" and "sIdTaxon". I need the exploded list because observations of one species may also intersect stations from other species (so my TestFilter select the overlayed data using the condition "IdTaxon like sIdTaxon".My problem is that alt

Hello , i have 2 dataset with different geometry points has the same id (points id at dataset 1 is the same points id at dataset 2 (same color as picture) but each point has different geometry and lines also has different geometry. probably , there are few points Id at the middle of network at dataset 1 are not the same point Id at dataset 2 . Lines in each dataset has different id , but they connect with same id point in different dataset but with different geometry .i would like to compare between two dataset and find which line id from dataset 1 equal line id from dataset 2 .my target to get specific attribute from lines at dataset 1 to provide for each lines equally at dataset 2 . FME 2021

This is the URL i'm trying to access. https://qpublic.schneidercorp.com/Application.aspx?AppID=1048&PageTypeID=4&KeyValue=450070160000It's a public link. If I try to access it via the HTTPCaller, it throws a 403 error. Why would accessing the link via HTTPCaller throws an error? Thanks

Is it possible to establish a connection to the Government of Canada's open data portal. From there I would like to be able to pull certain layers of interest and then transform them to output products I can share to staff/public.

https://engage.safe.com/support/downloads/fme/2023/win64/fme-form-2023.0.2.1-b23339-win-x64.exe

Hello, I have a client who just installed the latest version of FME Form 2023.0.2.1 Build 23339 WIN 64 and when he runs a workspace, nothing shows up AT ALL in the translation log window. It remains completely blank. We tried using the Log File in the logging section of the Workspace Parameters and when we open this file in a text editor, it is not empty and shows the translation log as expected. I am starting to think it might be just a weird visual bug with FME Form 2023.0.2.1. Did anyone else experienced this bug in the past with 2023.x or any other version of FME Form? I added pictures to show what I mean by a "blank" translation log window and also my client's log settings and log file. Thank you.  

Hello , i would like to understand in detail more about anchored snapper segment type .what is difference in segment type instead of others ? my case : I have end points but there are a little bit far away from lines and they should intersect with lines .when i use vertex point type ,with specific distance (0.2) nothing happened but when I use segment type with same distance (0.2)I found the lines changed the position and the points to let the point intersected with lines .i am only afraid if using segment type ,May be let some lines intersect with wrong nodes.what is the best method to Snap some end points to vertex of lines without problems ?i have used points as anchors and lines as candidates (Anchored snapper transformer )2.will be possible to let end point intersect with vertex of lines with out changing the position of lines ? Bcs segment types cause changing of position of lines i am thinkin