FME Form

HiI tried to join two linear datatset using this approachI created (snipper) center point from one lines dataset and then I used the spatial relator to join the info to the 2 lines dataset but due to the mismatch of the coordsys of two datasets(I suppose) the center point doesn't touch the line (see picture)I suppose that this is related to the tolerance during reprojection do you have same experience ? thx PS I solved creating a buffer for the center points Francesco

Hi!I have a work process that writes into googlesheete, I get quite a few errors:Python Exception <ApiError>: API Error 400 INVALID_ARGUMENT: 'This action would increase the number of cells in the workbook above the limit of 10000000 cells.'I saw what was being done here:https://community.safe.com/s/article/Known-Issue-Cell-limit-error-when-writing-to-Google-SheetsWhat can solve my problem is the ability to delete the sheet by fme..Is there such a possibility?

is it home use license and 30 days trial are different ?

To populate in an automated way the json templater what I would to do is to add the string stored in 2 attributes that I created in the table of my source.The first one is to create the list of attribute name and the second one to run the command in Json templater to add the value of the same attributes present in the source. ( see picture)something like:{   "id":fme:get-attribute("id"),   "@ns:com:here:customer:$(CustomerName)": {                    "objectidOriginal": fme:get-attribute("objectidOriginal"),                   "toaddr_l": fme:get-attribute("toaddr_l"),                   "toaddr_r": fme:get-attribute("toaddr_r"),                   ..............................                   ..............................                   ..............................                   "filegdb_type": fme:get-attribute("filegdb_type")} I created this ROOT:{   "id"

Hi, after following the OpenAI GPT-3 webinar I would like to ask if is it possible to create a process to detetc/extract the traffic sign from images using OpenAI GPT-3 in FME thx Francesco

I force the autocad_text_size = @Evaluate(@Value(autocad_text_size) / 100), autocad_box_height = @Evaluate(@Value(autocad_box_height, and autocad_box_width = @Evaluate(@Value(autocad_box_width) / 100). When viewing the Attribute Creator transformer value they look correct but when I open AutoCAD DWG file the text is still at the original height.I try using TextAdder and DWG styler but nothing seem to work. Can someone show me what I am doing incorrectly in my workspace?  

Hello,I have seen this post concerning the customization of the FME Server Web Interface:https://knowledge.safe.com/content/idea/42274/customize-the-fme-server-web-user-interface.htmlIn 2018.1: is there a workaround for changing the color of the "FME Server menu"? Can we modify a css file? Or ??Thank you

Hi All,I'm trying to create and write dynamic attribute name with the joined workspace. In a FFS file, I have C-SEGMT entities. I would like to count how any entities I have until the current year (e.g. 2023) but also for the two previous years (e.g. 2022 and 2021) and put the result in a dynamic attribute name (for my example, three attributes named "NumEntities__2023", "NumEntities__2022" and "NumEntities__2021" I can create them, as you can see it in my Workbench and the screen capture, but I don't know how to write them in my Writer. It's OK for a FFS Writer, but if I want to write in a GEOJson file or other formats, it fails. I could name them directly "NumEntities__2023", "NumEntities__2022", "NumEntities__2021" ; or I could expose them with AttributeExposer : I can see their name if I have enabled feature caching. But my goal is, if I run the workbench next year, the attributes will be automatically renamed

I need to read multiple geodatabases from url, where some geodatabases are at the root folder, and some in subfolders.I tried to follow the article here, but already the initial schema reader fails. I set the source to https://arealdata-api.miljoeportal.dk/download/**/*.gdb. The error message I get is: Unable to connect to the File Geodatabase at 'HTTPS:\\arealdata-api.miljoeportal.dk\\download\\**'. Make sure the correct filename was specified, and that the Geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-1'. The error message from ArcObjects is: {} 

From a program called topocad I receive building models drawn from drone point cloud. In order to build more complicated parts of the building, they are generated using extrude-> intersect. This creates geometry problems when imported into sketchup with tiny segments, duplicate overlapping points and as result, polygons, or missing polygons. I have tried to snap and repair using areagapoverlaycleaner, 3d snapper, geometry validator with no luck. I'm missing something in the process of data cleaning in fme so I ask for some tips. #1 gml->gml routine . #2 double lines created that snap to vertices .001 mm apart. #3 how it looks when imported

Hi All I have a URL in the format http://blah.com/images/{index] where the maximum index value will be the total number of records minus 1. So for three images the indexes would be 0, 1, 2 What is the best way to take the attribute imagecount and loop to the URL for the correct number of times starting at zero??? Just getting a bit confused now....Regards 

Hi all.When running a FeatureReader normally, it outputs the schema feature for a given dataset before all features. This enables writing to a dynamic writer.However, when attaching the dynamic writer to a previously run (and cached) FeatureReader, and then asking for playback, it seems that the schema features are apparently _NOT_ played back before the corresponding features from the same transformer, crashing the writer.Is it true, is this really WAD ?It kinda ruins the idea of incrementally building and debugging a workspace.Cheers.

I installed FME Server 2022.2.2 on Windows Server using Express. I told setup to use the wrong* password for Postgres `fmeserver` database user. How do I change the password after the fact, without going through the whole install process again? I know the password is stored in fmeDatabaseConfig.txt in the FME Server installation directory and how to encrypt the password. But that's how to change what FME passes to the db, not what is stored in the db. I need to change both. There is more than one Postgres service and database on this server. * wrong means "differs from our internal standards and documentation".

Hi,Is there any way to read an image from a excel sheet or expose the hidden attribute/row that contains it?Thanks

Hi I'm currently trying to combine 2 datasets based on a shared set value where table 1 attribute 1 ex. = 500, and table 2 Attribute1 also = 500, and there would be duplicate 500 values in both datasets so to do an effective Join I'm attempting to also join on *closest mileage value, the mileage is not exactly the same between the two tables so it would need to be within rage or closet to sort of function where first the join would be attribute 1 being the same between both tables and then joining table 2 to table 1 where the mileage from table 2 is cloest to table 1 mileage.

I use FME for updating several things in AutoCAD drawings (dwg) and writing out to new drawings using acad reader and writer. At present, when the new drawing is completed, the autocad_entity_handle is different on each object in the new drawing.  Is there any way to preserve the original autocad_entity_handle from the original drawing in the new drawing?Thanks!

Hello all, I am trying to write some data to my SDE geodatabase(file), and I tried two transformers to achieve my goals: Feature writerI got an error: invalid cursor state from the database. When I filtered one row and run the writer, the data were successfully injected, but some of the injected data are different from the intended data. For example, a foreign key needs to be injected as 5 but it's injected as null or 2 in a different row. Please see the setting below. Python CallerI used Geometry extractor to write the shape attribute, Shape@XY with the value (longitude, latitude), and then used arpy.cursor.insurtRow to insert the data under the input function using feature.getAttribute method. I got an error: the INSERT statement conflicted with the FOREIGN KEY constraint.  Thank you,Tae

Using the AttributeConcatinator transformer, how do I represent a blank space in the Separator String: data entry?

We need this to be able to post the attribute to an API which requires one of the other File Structure types than the default

I run this command from the command line: C:\\Progra~1\\FME\\fme.exe C:\\BIDW_Prod\\FMETemplates\\FINANCE_finance_EDW_CALL.fmw and get this error: Feature specification `NO_LOGGING' in mapping file row `FACTORY_DEF * TeeFactory FACTORY_NAME SQLCreator_<Rejected> INPUT FEATURE_TYPE SQLCreator_<REJECTED> NO_LOGGING OUTPUT FAILED FEATURE_TYPE * @Abort(ENCODED,SQLCreator<space>output<space>a<space><lt>Rejected<gt><space>feature.<space><space>To<space>continue<space>translation<space>when<space>features<space>are<space>rejected<comma><space>change<space><apos>Workspace<space>Parameters<apos><space><gt><space>Translation<space><gt><space><apos>Rejected<space>Feature<space>Handling<apos><space>to<space><apos>Continue<space>Translation<apos>)' is not valid -- it has a

I have a stream of features containing polygons and multipolygons.I would like to identify only the polygons and promote them to multipolygons (containing one polygon). I tried GeometryAggregator but it is converting multipolygons into geometryCollection(multipolygon) which I don't want.Must be something simple that I just can't see. Any help appreciated.Simon

Hi, I made a workspace to create INSPIRE datasets. When checking whether the created INSPIRE GML is valid, I wanted to add an XML Schema Validation step into the process. When doing so however, I noticed that in FME's XMLValidator I get two Validation Errors;no declaration found for element 'so:soilProfileObservation'element 'so:soilProfileObservation' is not allowed for content model '(metaDataProperty*,description?,descriptionReference?,identifier?,name*,boundedBy?,location?,inspireId?,localIdentifier?,WRBSoilName,otherSoilName*,validFrom,validTo?,beginLifespanVersion,endLifespanVersion?,isDescribedBy+,location)' See also below screenshot;If I however validate the GML using either (the XMLTools plugin) of Notepad++, or INSPIRE's validator, the GML does validate.  Does anyone know what causes these validation errors of FME's XMLValidator? If I check the second (unique) error that, i.e. that the element soilProfileObservation is not allowed in the c

Hello, I have a digital model in ifc format that I want to convert to CityGML format in FME and then integrate it into a Postgis database. I want the model to keep its characteristics at the end of the process.

Its possible to write the TAGs but in MicroStation the tags do not work.I use FME 2016Thx for help.

Customer has a working migration chain on FME 2021.2.5 and we would like to upgrade to 2022.2. At first, I started extracting data using FeatureReader from our source (Oracle Spatial), but I have strange warning message in the log and not all data all extracted from the source.  Warning message in the log relates to entries in ALL_SDO_GEOM_METADATA which are all set correctly – I would mention once more that data reading from Oracle using same workbench in 2021.2.5. is working. Here is the warning message: Execution of statement `SELECT table_name, column_name, (SELECT COUNT(*) from TABLE(META.diminfo)) dcount, SRID FROM ALL_SDO_GEOM_METADATA META WHERE ALL_SDO_GEOM_METADATA.owner = '<SOURCE_SCHEMA>''did not succeed; error was `ORA-00904: "ALL_SDO_GEOM_METADATA"."<OWNER>": invalid identifier'. (serverType=`ORACLE8i', serverName=`SERVER_NAME', userName=`<FME_READER>', password=`***', dbname=`') If I try to execute