• EN

General

A read-only category for lost FME Form topics. We hope to move them shortly.

  • 4,033 Posts
  • 13,711 Replies

4033 Posts

geographygeek
Contributor
geographygeekContributor
asked in General

Move polygons to become adjacent without changing shape

Hello FME Experts! I have been struggling with this for several weeks and I'm hoping someone may have some insight.  I have a set of data that contains buildings that were manually digitized from roofline data. From this set, I have scaled the polgyons based on the type of roofline (scaling factors predetermined). This resulted in some properties with multiple roofline types to separate from each other. Think of a home with some steep and less steep rooflines - the scaling was done on each polygon. In addition, I used @Takashi Iijima​ 's workbench and modified it slightly to right angle polygons where possible.  Now, I have an issue because I have polygons that should be adjacent (have shared boundaries) but because of the scaling, they are no longer attached (and because these were manually digitized, there were previous gaps in the data).  I would like to physically MOVE the polygons to allow them to have a shared boundary without changing the shape (much).  I tried using a c

2
geographygeek
Contributor
4 months ago
R
rscsevilla
asked in General

Error at AttributeDecompressor

Hi, I have compress a text with AttributeCompressor and stored it in an XML file. The text should be a password, so I don't want to store it as plain text. Then, I read the XML file and try to decompress the password with AttrributeDecompressor. But I only get this:2023-12-15 14:31:40|   0.6|  0.0|ERROR |@CompressAttributes: The 'Compressed-table.Compressed.password' attribute could not be decompressedBy the moment, I'm only compressing, not enconding. But I cannot make it work.I'm using FME Desktop 2022. I'm attaching both workbenches, (compress and decompress), the xml written by the first and readed by the second, and the logs of my execution.Thank you for your help.Best regards.

3
R
4 months ago
S
sanghostevielee
asked in General

TextEncoder failing to encode Roman numbers and special characters

Hi all, I need to extract the Hex Code Point of multiple letters using TextEncoder.However, the transformer fails to encode Roman numbers and some special characters. You can see in the below screenshot that it successfully encodes Bengali letters and some special characters, but not the others. Anyone has an idea how to solve it or any workarounds? Thanks! 

1
david_r
Influencer
4 months ago
R
rob_nason
asked in General

OGCGEOPACKAGE writer: Unable to write feature, aborting write process

I'm trying to write ~20m records to a Geopackage format file. If I remove all but a unique identifier column the output is created and FME runs correctly. If I try adding the original columns the process fails with the following errors. What can I do to fix this? 2024-01-04 10:57:31|  1.8| 0.0|ERROR |OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "Table1" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geom" POLYGON, "Toid" TEXT(20), "Version" MEDIUMINT, "VerDate" DATETIME, "FeatCode" MEDIUMINT, "Theme" TEXT(80), "CalcArea" REAL, "Change" TEXT(80), "DescGroup" TEXT(150), "DescTerm" TEXT(150), "Make" TEXT(20), "PhysLevel" MEDIUMINT, "PhysPres" TEXT(20), "Broken" SMALLINT, "LoadDate" DATETIME, "OBJECTID" MEDIUMINT, "OSMMSTYLE_NAME" TEXT(70), "Style_Code" SMALLINT, "SHAPE_Length

1
pimc
Contributor
4 months ago
gvatin06
Contributor
gvatin06Contributor
asked in General

Silen install FME Form 2023.2

I followed the procedure for silent installation of FME Form 2023.2, but without succcess. Here is the command I write in the console, with Admin rights :fme-form-2023.2-b23764-win-x64.exe -d"C:\\FME\\installer" -s -sp"/qn /norestart" The fme-form Logfile which is created notes a successful installation in the end:Product: FME Form 2023.2 (Build 23764 - win64) -- Installation completed successfully. However, I cannot find the software installed... No shortcut and no program in the default C:\\Programs\\FME.Could you explain why the installation is not finished?

1
DanAtSafe
Safer
4 months ago
larue
Contributor
larueContributor
asked in General

Lack of precision with Arc Intersection Points: They Do Not Actually Intersect

I am trying to generate a point coordinate at the midpoint of Arcs. These Arcs have a very large radius and a tiny sweep, so they look like lines, but they are parts of a larger Arc. Whether I try the arc.GetMidPoint() method, or use Intersector with a crossing line, the point is always off. When I run the features through the SpatialRelator, it returns 0 _related_suppliers. It looks fine at first glance, but zooming in reveals that the intersection point really is NOT intersecting. My hunch is that this is due to the Point being calculated as a float. When using the Intersector or PointOnLineOverlayer, it actually changes the shape of the Arc! Here are some pics to illustrate:Midpoint of Arc at a distance Intersection point at a distance."Intersected" Point from Intersector lines (purple), with actual Arc (grey) close up. It intersects with the Intersector-created Arc, but not with the input Arc:Here is what I am running the features through to verify. Note: If I

9
larue
Contributor
4 months ago
marta.podsiad
Contributor
marta.podsiadContributor
asked in General

AutCAD - Xref issue

Hi, I have Civil 3D AutoCAD model with XRef attached. I cannot find the way to read the XRef layes as autocad_entity=autocad_xref. The only place that tells me that is an xfer is stored in the autcad_layer as apart from the layer name has the name of other model. What am I doing wrong?

1
jovitaatsafe
Safer
4 months ago
P
petergoedbloed
asked in General

Trailhead account seems to be reset.

Hi all,Please help!  From January to April 2023 I worked through most of the FME Desktop/Form Advanced and Server/Flow advanced course. Now, December 2023, it seems my account and the progress is lost. All the badges I gained etc. In addition, some of the trailmixes I followed seem to not exist anymore. Anyone had a similar experience? Or know how this could be solved. Kind regards,Peter Goedbloed

1
milo89
Enthusiast
4 months ago
larue
Contributor
larueContributor
asked in General

Using DateTimeStamper with FeatureWriter

Is there any easy way to add a date stamp to output file names when using the FeatureWriter? I am outputting Excel files that have multiple tabs with multiple separate inputs, from multiple data sources. The only way I could figure out how to do this without the FeatureWriter splitting up the different feature types into separate files is to add the DateTimeStamper to each data source, make sure it is kept all through the Workspace, and then take off the _timestamp attribute from each Feature Type in the Attribute list on the FeatureWriter. What a pain! Surely there is a better way? I tried to create a User Parameter, but it did not work. Any hints on this?  Thanks, -L

4
nielsgerrits
Celebrity
4 months ago
I
ingridantonsen
asked in General

Set up the HTTP Caller to extract data from rest API

Hi!I am trying to get data (exchange rates) via a Rest API. I am a very beginner in using Rest API:s.By now, I start with a creator and connect than the HTTP Caller. However, I have difficulties to set up the HTTP Caller and get a connection.I use the following url: https://api.riksbank.se/swea/v1/Observations/SEKEURPMI/2022-01-01/2022-12-31 HTTP/1.1 The API needs a so called Ocp-Apim-Subscription-Key. It contains of 32 numbers and letters.I guess this should be defined in the header, but how would I do this in FME? There is no such parameter available, is it?To access the API portal username and password are required. Do I have to use this username and password in the "Use Authentication" section or does it refere to the username and password of the API itself? Thank you so much in advance.  

2
I
4 months ago
R
rajubhi
asked in General

Trouble using ProjectWiseWGSConnector in FME Form 2023

Hello! I am having trouble getting the ProjectWiseWGSConnector working on FME Form 2023.0.2. I have a dedicated service account (SVC) account that can access two projects using ProjectWise Explorer. I am connecting with a username and password, not with Bentley IMS. When I use the same login and password in FME Form, I cannot access those projects. FME lists a series of folders that I have not seen before. I have attached a screen grab of the list of folders, ProjectWise API version, and ProjectWise connection configuration.

1
R
4 months ago
gis.analyst
Contributor
gis.analystContributor
asked in General

Importing Revit files to Geodatabase

When I try to import Revit file to File geodatabase i face with the following error. An error occurred while attempting to create the feature class 'Structural_StructuralFraming'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column. [Structural_StructuralFraming]} my version of FME is 2023.1I did previously import Revit files in geodatabase without any error in previous version of FME.

2
V
4 months ago
K
kanthsri74
asked in General

FMELine.appendLine in PythonCaller

When I was trying to add the line to the existing line using PythonCaller FMELine.appendLine(feature.getGeometry) then it is closing the paths as polygon. Basically it is adding an extra segment and closing the path.In the below image selected line, there is a straight line created when I use the above function.  What's this worst calculation? Who is the coder for this?  

1
takashi
Contributor
4 months ago
boomer87
Contributor
boomer87Contributor
asked in General

Order of triggering FME events

Hi there!I have several different FME scripts I have developed to translate layers in a source DWG to feature class in a FGDB.I need the ordering to fire as the below in the bookmarks, with one line creating a merged shp, then the other line taking that merged shp and importing it into a FGDB. Is there a way to set the order of lines or bookmarks to fire before the other?  Thank you!

3
boomer87
Contributor
4 months ago
garbadek
Contributor
garbadekContributor
asked in General

Using a User Parameter in Esri Geodatabase (SDE) Writer Where Clause causing missing quote error

I have what I hope is a simple question. I'm using a Where clause in my Esri Geodatabase (SDE) Writer. One of the criteria I'm using in my Where clause is that a jurisdiction matches a value being passed in using a User Parameter. This value "jurisdiction" parameter has a comma in it (which I think is the problem). When I manually type the Where Clause in as Jurisdiction = 'SomeName County,St' it works no problem. When I pass the parameter (I.E. "Jurisdiction = '$(parJurisdiction)') with parJurisdiction set to the exact same value I get:  "Unclosed quotation mark after the character string 'SomeName County))' Any suggestions as to how to solve this problem would be appreciated.  Thank you.K

2
garbadek
Contributor
4 months ago
mspencer
Contributor
mspencerContributor
asked in General

How do I set a range of values to NoData using RasterBandNodataSetter.

I have a raster and want to set values which are < 5 to NoData and also values which are equal to 255. I have tried setting values of 255 to NoData using the RasterBandNodataSetter, but in the output raster all three bands still have values of 255. I've attached the workspace. Ideally I'd like to set these values all at once but I'm just trying to get one value set correctly first. Thanks

1
kailinatsafe
Safer
4 months ago
totree30
Contributor
totree30Contributor
asked in General

Footprint and DEM to 3D buildings

Hello!I have shp footprint of buildings and DEM information with TIFF format. I would like to extract Band0 value as a height information, and then apply it into footprint, so then I can create a 3D buildings. Could you tell me the flow that I have to use? maybe I also have to change the coordinate system right

5
totree30
Contributor
4 months ago
M
missewuodiane
asked in General

How to perform cascading deletion in the database and avoid database disconnection issue?

I am trying to perform cascading deletion in the database but because the records are many and the deletion is happening in many tables, this takes a long and the database gets disconnected after a while. How to solve this?

1
ctredinnick
Contributor
5 months ago
F
fmesvn
asked in General

FME Flow can't send email through emailer

FME Flow does not send emails through emailer-transformer in the workspace. It works on mine production-server, but not in system test. I get error message Emailer: <class 'locale.Error'>: unsupported locale setting. The difference is between TEST and PROD: TEST: Process Encoding : UTF-8PROD: Process Encoding: windows-1252 I have tried deleting safe.emailer, under recources and plugins. Deleted the Build-folder. Tried different Python interpreter. But still no response. Is it Python installed on server that is causing trouble? Are there settings I can make either in the Flow GUI or on the server?  Emailer running from desktop works.

1
merlinegeorge
Safer
5 months ago
mattwilkie
Contributor
mattwilkieContributor
asked in General

Native spatial DB vs Esri enterprise GDB?

Since FME lives (thrives!) in the lands-between-realms I'm thinking this is the best place to ask this question and hook knowledgeable reponses. There are more eyeballs in the Esri and Stack Exchange community forums but they're less likely to have the broad horizon to horizon perspective combined with life in the tunnels found here. What are the trade-offs to consider when deciding between native DB spatial type or Esri Enterprise Geodatabase (or both)? Where 'native' means PostGIS for Postgres, SQL Server Spatial, OGC in Mysql, etc., etc. Assume equal proficiency of staff and resources is or will be made available. Licensing et al is consequential but not determining. Content is a mix of spatial and non-spatial. It's hard to say which is more. By volume in terms of storage it's spatial - a lot of wildlife telemetry, survey and observational data. However by number of tables the non-spatial will probably outnumber spatial in the long run. That said everything i

2
mattwilkie
Contributor
5 months ago
totree30
Contributor
totree30Contributor
asked in General

I cannot see 3d multipatch data in Graphics

Hello!I have Esri 3d Mulitpatch data as a shapefile, and I tried to see the 3d data on Graphics, but I can see nothing. Also I tried to extrude 3d objects from 2d multipatch, and I insert correct height value, but nothing has changed. Could you tell me how can I solve this issue? I tried to change the coordinate system and I've done several times, but only coordinate system is changed and still cannot see the 3d.

2
totree30
Contributor
5 months ago
garbadek
Contributor
garbadekContributor
asked in General

Formatting Date in FeatureWriter Query

I have a SQL Server table that holds log information. It contains a date field. If I query it in SQL no problem I get: In FME I have a FeatureWriter. I have it set to Update and Use Existing and I've chosen Where Clause as my row selection method. I thought it would be easy to select all rows having todays date, but I'm 3 hours in and having zero luck. I've tried all sorts of iterations like these and many, many more and every time I get "date is incompatible with some data type" or it finishes successfully and I get zero matches. Any suggestion would we GREATLY appreciated. Kim

1
garbadek
Contributor
5 months ago
benvk
Contributor
benvkContributor
asked in General

File Paths Inconsistent, bug, or user error?

Hi,  I have a user parameter where we are entering raw text in the format of:\\gis\scripts\FME_Projects\Production\Staging Folder\bulk_geopackage.gpkg  The first time this parameter is used is in a featurewriter transformer:Then when I look at the path it is passing through the output, you will notice one of the slashes has been reversed...Any thoughts as to why this is happening at this point?

4
benvk
Contributor
5 months ago
U
ukrsolid
asked in General

Read Microsoft Planner with FME

Wonder if there is a way to read  Microsoft Planner (Microsoft Task) with FME ? Yarko

3
P
5 months ago
myadegaryiutac
Contributor
myadegaryiutacContributor
asked in General

I am new in FME and I have a project to convert 3D models in .rvt format to be poblished in scene 3D views in ArcGIS enterprise. I was trying to find articles or similar projects that was done before but I couldn't. Can someone help me please tnx

I am new in FME and I have a project to convert 3D models in .rvt format to be poblished in scene 3D views in ArcGIS enterprise. I was trying to find articles or similar projects that was done before but I couldn't. Can someone help me please tnx!

2
gis.analyst
Contributor
5 months ago

Badge winners

  • Student (Grey)
    creinierhas earned the badge Student (Grey)
  • Teacher (Bronze)
    creinierhas earned the badge Teacher (Bronze)
  • Teacher (Grey)
    creinierhas earned the badge Teacher (Grey)
  • Student (Grey)
    rzickuhrhas earned the badge Student (Grey)
  • Teacher (Grey)
    jiaxinhas earned the badge Teacher (Grey)
Show all badges
28,884
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.