Skip to main content
  • EN

General

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

  • 4,039 Posts
  • 13,878 Replies
4039 Posts
gisbradokla
Enthusiast
gisbradoklaEnthusiast
asked in General
DatabaseUpdater match column

I have always tried to use the databaseupdater but have always had issues with it.Why if i have a unique column with GFID values and i want to match that it gives the error.Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.COGO_23' to the database. Provider error `(-2147217900) The data types text and text are incompatible in the equal to operator.'. SQL Command `UPDATE [dbo].[COGO_23] SET [GFID]=?, BLAHBLAHBLAHWHERE [GFID]=?'this is a flat mssql table with no geometry. 

1034
gisbradokla
Enthusiast
W
wjloy
asked in General
Does the new version of Form support ESRI's new Date (only) or Time (only) formats?

Curious if the new version of Form, 2023.2.1.0 will support ESRI's new Date (only) or Time (only) formats? They are not appearing for me when connecting AGOL, but they appear when I connect to a FILEGEODATABASE.

1158
AliAtSafe
Safer
philippeb
Enthusiast
philippebEnthusiast
asked in General
HTTPCaller - extend Multipart Upload window

Hey FME Lizard!In the HTTPCaller the Multipart Upload window is only showing two rows. Would be great to see more lines!So difficult to see the line I want when I have twenty. I have to click the narrows too many times...Thanks :)

374
philippeb
Enthusiast
gogopotter90
Contributor
gogopotter90Contributor
asked in General
PDF Page Formatter. How to avoid Manual X/Y Adjustments in PDF page formatter

Hello ,Is it possible to control the position of Upper left x and Upper left  y in a PDF formatter by setting their values in an attribute beforehand, so that the PDF formatter reads and uses them directly?I don’t want to keep adjusting the x and y positions directly inside the PDF page formatter every time I find that the output is not properly aligned. Do you have any tricks or suggestions to help me arrange my PDF layout more quickly?It takes a long time to design the PDF layout . Thanks in advance .

421
AliAtSafe
Safer
D
david_gis
asked in General
How to solve <No SNOWFLAKE_NONSPATIAL dataset name was specified>?

If we run SQLExecutor in FME workspaces in FME server 2022.2.2, then we can't connect to the Snowflake datasource. We have this problem in multiple workspaces that run on FME server and for multiple Snowflake databases/schemas. It raises this error:2023-6-29 15:14:13 | Performing query against SNOWFLAKE_NONSPATIAL dataset `snowflake_datalake_acc'2023-6-29 15:14:13 | No SNOWFLAKE_NONSPATIAL dataset name was specified (couldn't find a value for `R_1_DATASET' or `SNOWFLAKE_NONSPATIAL_DATASET')It has strange behaviour. When we load the same workspace, same input database/schema/role, same output database/schema/role, and different data table it can connect for some data tables, but it does not connect for other data tables. Is there a way to solve this? We got this problem when we switched to a new role in FME server for authorization to databases/schemas/tables in Snowflake. We already checked the database connection configuration in FME server multiple times and it is correct since it wo

1225
steveatsafe
Safer
gis.analyst
Contributor
gis.analystContributor
asked in General
Connecting ProjectWise to FME

I am going to read Data from ProjectWise. FME could read Folder trees (as attached picture) but accessing to folders is not possible. (my user name and passsword are correct)(Also I have the Bentley CONNECTION Client installed and logged in.)The IT guys said that they useAPI version 2.8.Is there any solution to solve this issue?Thanks in advanced  

2075
filipovitz
Contributor
mariuszwojcikgb
Contributor
mariuszwojcikgbContributor
asked in General
Please disable auto attaching transformers to links while moving a group of transformers or entire bookmark

Auto attaching transformer to a link is a great feature. But while moving multiple transformers some of them they attach to links without such intension. If not noticed it create a lot of problems.

342
JennaKAtSafe
Safer
lifalin2016
Contributor
lifalin2016Contributor
asked in General
Curious incident using SQL Server - huge log file as a result

Hi.I just had a job on our FME server 2022.2.2 go haywire.When reading from one or more database tables, it suddenly spews out a _lot_ of error messages, repeating the same two lines from line 319 to line 865997 (on page 1734):Microsoft SQL Server Spatial Reader: An internal error has occurred. Please visit http://www.safe.com/supportMicrosoft SQL Server Spatial Reader: Failed to parse datetime, attribute set as nullWhat gives ? Should I be concerned ?I've occasionally encountered huge log files before, but haven't had any idea why. Next time I'll see if it's the same issue.The job took several minutes (as opposed to normally a handful of seconds) to finish, which is not good.Cheers.

10325
nordpil
Supporter
bwn
Evangelist
bwnEvangelist
asked in General
How to run 2 x WorkspaceRunners simultaneously with "Wait for Job to Complete" = Yes

I'm struggling to figure out a way for an initiating Feature to trigger 2 separate WorkspaceRunners simultaneously. In this case, Workspace 1 and Workspace 2 are completely independent of each other, and it doesn't matter to them if the other Workspace Fails or Succeeds. However, Workspace 3 DOES need to conditionally only run if Workspace 1 and Workspace 2 both succeed, and Workspace 1 and 2 must only report "Success" if they run with no errors. I hopefully set it up this way below only half expecting success, although it ended up that this still only ran the WorkspaceRunners in Sequence and didn't work, since WorkspaceRunner #2 waited until WorkspaceRunner #1 completed before pulling in the Initiator Feature. Note: Workspace 1 and 2 are completely different FMWs and completely different Parameter lists. 

1317
sandrawang
Participant
takashi
Influencer
takashi
asked in General
How can I prevent adding excess decimal places in the formatted JSON document?

Hello,In some cases, JSONFormatter writes a decimal point number with the full precision of floating point numbers.Example:Source{ "number" : 1.954, "string" : "1.954" }Formatted by JSONFormetter (FME 2021.2.2){  "number" : 1.9540000000000002,  "string" : "1.954"} I think this document is desired in many cases.{  "number" : 1.954,  "string" : "1.954"} Is there any way to prevent adding the excess decimal places?

3645
itay
Supporter
benji
Contributor
benjiContributor
asked in General
Geometry validator: 1 input but multiple outputs... why?

Can anyone please explain why with only 1 feature being read, more than 1 can fail? Any help would be highly appreciated!Many thanks!!

264
laddysmurf19
Contributor
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Weekly Quiz: Round 2 Answers and Results

Hi FME'ers,Here are the answers and results to yesterday's quiz:Answers1) Which of these transformers has a Stiffness parameter?DisplacerHullAccumulatorSpikeRemoverRubberSheeterEggBeaterThe answer is the Displacer transformer. This transformer is useful for moving features apart that are too close to each other (usually for cartographic purposes). The stiffness parameter controls how much a feature can be deformed in moving it.  Give yourself 3 imaginary bonus points (ibp) if you knew the answer already, 2 ibp if you figured it out from what the transformers do, and 1 ibp if you typed stiffness into Quick Add and pressed tab (great tactic).You get no ibp if you went through each transformer to check!2) The FME Mobile App that connects to FME Server is called...FME Server ExpressFME Data ExpressFME Mobile ExpressFME Workbench ExpressFME Vande Bharat ExpressIt's the FME Data Express. It's intended to allow mobile access to Server, with some data collection capabilities to

393
danilo_fme
Evangelist
matthieuv
Contributor
matthieuvContributor
asked in General
Table Qualifier for FeatureReader

The FeatureWriter has an option to set the Table Qualifier. This makes it possible to use one writer for multiple database schemas.Unfortunately the FeatureReader is missing something similar which leeds to a lot of spaghetti. It would be a nice improvement if you can set in the FeatureReader the Table Qualifier (based on an attribute value). 

453
nielsgerrits
VIP
F
felixderglueckl
asked in General
Meaningless error (Error running translation)

Hello together, I'm a bit confused. I have a workbench where I merge attributes from 3 data sources. The result should being saved in an FFS file. But the workbench throws an error at the end which is completely meaningless to me. This is the end of the log file:Translation was SUCCESSFUL with 25 warning(s) (919246 feature(s) output)FME Session Duration: 35 minutes 27.1 seconds. (CPU: 1867.5s user, 275.9s system)END - ProcessID: 25060, peak process memory usage: 17993084 kB, current process memory usage: 307928 kBTranslation was SUCCESSFULError running translation.On the one way the translation seems to be successful, in the other way there is an error running the translation. One strange thing is that there are two instead one FFS file being created by the writer of the workbench: Output.ffs (with 39 FTS files) and Output_1.ffs (with 9 FTS files), although I defined just the Output.ffs in the writer. In spite of the error I tried to load the Output.ffs into the Data Inspector. I also 

173614
crystalatsafe
Safer
mortonprice87
mortonprice87
asked in General
Error when publishing with uploads to FME server

When publishing any workspace to FME server, with files that need to be uploaded, i get the following error. Publish failed - FME Server encountered an error and reported the following message.The resource name must not contain any of the following characters: \\ / : * ? " < > | & = ' + % # non have my files have these characters Its happening with any new workbence, and it doesn't seem to matter what the reader is. even simple workbence, with a reader straight to a writer fails to upload.  Wondered if anybody has encountered this.Using FME Server/desktop 2020.2

1964
mattmatsafe
Safer
C
chris28
asked in General
Coordinate system extractor

I have a shapefile with a coordinate system defined which I'm using to test my workspace. I'm using the coordinate system extractor to check if there is a coordinate system. The _coordsys attribute comes up empty. But the shapefile does have a coordinate system. Why might this be happening?

384
minmax136
Participant
F
frankcremer
asked in General
How to solve intermittent runtime errors with FeatureWriter to Snowflake?

For my client we run a lot of translations on their FME server that write to Snowflake. For like 99% of the time that runs without any failures. However, occasionally we are getting the following run time error: "COM.safe.fme.jdbc.TranslationFailureException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: {0}." Unfortunately this is a rather non-descript error (I wonder what {0} is). Also this error only occurred after our upgrade from FME Server 2020 to 2022.2. Rerunning the exact same translation the next day so far did not result into this error. So, does anyone have an idea how to prevent this from happening? Frank

868
steveatsafe
Safer
dudo01
Contributor
dudo01Contributor
asked in General
Open Text Editor or Open Arithmetic Editor => Open Editor

Is it possible to create a unified editor for both text and arithmetic?It would simplify the process of assigning variables to text rules or mathematical calculations, visible in a function dropdown box.For example: A rule definition can begin with a codeword, like Calc(....), to be processed as arithmetic or recognized by AI?

132
dudo01
Contributor
benvk
Contributor
benvkContributor
asked in General
FME Server unable to find ESRI License

Hi All,  50 2022-2-2 18:19:13 | The Esri Product license used by this machine does not include licenses for the 'Advanced' licensing level51 2022-2-2 18:19:13 | Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details52 2022-2-2 18:19:13 | A fatal error has occurred. Check the logfile above for details We have FME Server 2021.2.2 running with ArcGIS Pro. We have logged into Pro with a ESRI named user 'gisadmin_acc', this has an advance level license assigned to it. Pro opens and runs fine on the server machine.  We installed FME Server using an admin account called sa-pandora-fmeWe also installed ArcGIS Pro with this same sa-pandora-fme account. The instructions we have been following are here - https://community.safe.com/s/article/Using-ArcGIS-Pro-with-FM

71119
wccbrown9a
Contributor
omerseyfettin
Contributor
omerseyfettinContributor
asked in General
Could Database Updater upgrade to can more than one table update ?

HiIn FME 2025.1, can multiple feature classes containing the same fields and needing to be updated with the same data be developed to use a single DatabaseUpdater converter?For example;A function can be added that allows feature classes or tables to be selected in the parameters, as in the reader. The additions can be seen as a list above the Match On list.

40
omerseyfettin
Contributor
C
claragmercadal
asked in General
Euclidean distance

Hi, I would like to know if there is any processing in FME as "Euclidean Distance" tool in ArcGIS. Thank you. Clara.

765
sandervanegmond
Contributor
O
oskarwallin90
asked in General
TIN surfaces and Normals

Hello!  I am currently Generating TIN surfaces from a pointcloud and exporting as a FBX.  I am having some issues with bad looking edges, aswell as vertexnormals looking like split normals everywhere (hard edges, see image below)As you can see from the images here, the triangulation is very rough. is there anyway to average those normals to get a more smooth experience? Think smoothing groups, from 3D studio max or something similar. i dont want to actually change the geometry, just the visuals. This was generated from a 4x4km pointcloud with a TIN generator surface tolerance at 0.5 (just to speed up the process).   Best Regards. Oskar Wallin

1124
charry
Supporter
martin_fme_user
Contributor
martin_fme_userContributor
asked in General
Where's the Wall of Fame?

Hi all, Last year, I received my FME Certified Professional certificate.An achievement that I am proud of. I want to check if I am still the only FME Certified Professional at my place of work. The problem is: I can't find the Wall of Fame any more since the Safe Software rebranding. Does anyone know if the Wall of Fame still exists? Regards, Martin

7676
gistech_
Contributor
totobobiasos
totobobiasos
asked in General
sharepoint list writer

I'm having trouble writing sharepoint users to a sharepoint list. It does not seem to matter how I'm formatting the user string attribute - it just wont accept it. The writer is configured as uploaded workspace. The sharepoint list adds a new, empty row.   HOW do I configure the writer, and what is supposed to be the correct attribute value? To my understanding, the attribute value is to be formatted asi:0#.f|membership|name.name@domain.se

604
crystalatsafe
Safer
B
basantlalnit
asked in General
Where to get Draco compression plugin in FME Desktop?

As per ChatGPT, FME supports Draco compression and FME has a plugin 'Draco 3D Mesh Encoder/Decoder' in tools->plugins & transformers->dialogbox-> choose download tab->scroll down and will get the plugin. But even I am not able to see the option plugins & transformers in tools.So can anyone make me clear where to find it in FME Desktop, I am using latest version of FME. ThanksBasant Lal

665
virtualcitymatt
Celebrity

Badge Winners

  • Student (Bronze)
    geo-xhas earned the badge Student (Bronze)
  • Student (Grey)
    geo-xhas earned the badge Student (Grey)
  • Teacher (Bronze)
    geo-xhas earned the badge Teacher (Bronze)
  • Teacher (Grey)
    geo-xhas earned the badge Teacher (Grey)
  • Student (Grey)
    akeerihas earned the badge Student (Grey)
Show all badges

Community Stats

31,195
Posts
118,249
Replies
38,801
Members

Latest FME

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.