Skip to main content
  • EN

Best Answers

10390 Posts
B
bakkermans
asked in Authoring
Slow FME using temporary fixed license instead of floating license

Since I am at a customer, not being able to connect the our license server via vpn, I installed a temporary fixed license. This is installed without issues using the license manager, however, my FME slows down terribly! And with that I mean everything: opening FME Desktop, opening FME Inspector, loading data, running a model, ... I am really not able to work like this. Anyone an idea what is going on here?

1096
andrewmurphy
Contributor
miquelrs
Contributor
miquelrsContributor
asked in Data
CSV Writer writing null values for UPRN's > 99.999.999

Have FME Desktop 2020. It turns out that writing UPRN's into a CSV doesn't work for values above 99.999.999. Have tried all data types in the writer (real64 is the one that FME sets automatically, but have tried String, int64, etc..). Nothing works.Can somebody help me please?  First capture is the output before writing csv (upper workflow):  Second capture is the output after reading the CSV (lower workflow). Notice that there are 14400 records with null UPRN. 

1911
miquelrs
Contributor
oscard
Influencer
oscardInfluencer
asked in Transformers
FME crashes with JSONTemplater

Good morning. I've been facing all morning a FME crash that I do not understand. So far I have tested my workspace with two version: FME 2018.1 and FME 2020.0 both 32-bits. The process fails with both of them.My source data is a Personal Database (MDB) without spatial information. In one table I have data about "group layers" and in other about "layers".A group can contain layers and other groups. I must build a JSON with that info.To build the JSON with the groups, I have used the following JSONTempalter: ROOT contains:{    "version": "1",    "tipo": "3",    "servicios" : [            fme:process-features("GRUPO")        ]   }GRUPO contains:{    "Nombre_ES": fme:get-attribute("NOMBRE_ES"),    "Nombre_EN": fme:get-attribute("NOMBRE_EN"),    "grupos" : [        fme:process-features("SUBGRUPO", "PARENTID", fme:get-attribute("ID"))    ]}And SUBGRUPO contains:{    "Nombre_ES": fme:get-attribute("NOMBRE_ES"),    "Nombre_EN": fme:get-attribute("NOMBRE_EN"),    "grupos" : [        fme:process

184
oscard
Influencer
A
akozielec
asked in Transformers
Is there a way to Sort by Field A but only if the first row in Field B is missing?

I have a sorter, but I do not want it to sort if the first row in Field B has a value. I am guessing this will need a combination of transformers.

154
A
A
adklys
asked in Data
Machine learning/computer vision - XML (knowledge) generation problem

Hi FME folks,My first post so go easy on me please :)We use FME at work for various geo-spatial projects and I've been asked to look into it's C.Vision capabilities. Previously I had a crack at anaconda and some GPU accelerated approaches but the amount of back-end stuff necessary to get started go a little too involved.I've gone through your video tute @dmitribagh as well as all the workspaces provided and with some solid hrs. of practice I managed to get all of them working. I am somewhat of an an FME newb with less then 50hrs. of usage at a rough guess.I'm trying to build a model for recognizing houses (roofs) in aerial photography. I've managed to create auto annotations using some footprint data which we have.Idea being that I need a "clean" image of a single house rather than a house surrounded by other houses, and annotations being rectangles sort of forces you to improvise. I have a bunch of negatives of empty lots which I manually created ... ...

123
A
H
hanj
asked in Transformers
Errors when running FME Desktop workspace in scheduled task - MS SQL connection related

Hi,I have created a FME Desktop workspace that imports data into the MS SQL database which runs successfully as a scheduled task if I am logged in the server. But it fails when I'm off the server and gives me this kind of error message. (I got a blank SQL provider error)2020-05-07 22:00:21|  11.5|  0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using SQL Server 2012 Native Client...2020-05-07 22:00:22|  12.3|  0.8|ERROR |Microsoft SQL Server Non-Spatial Writer: Failed to connect using SQL Server 2012 Native Client. Provider error ''. Connection string 'Provider=SQLNCLI11;Data Source=;Initial Catalog=cadasdb_equalizer;User ID=;Password=********'2020-05-07 22:00:22|  12.3|  0.0|ERROR |Microsoft SQL Server Non-Spatial Writer: A suitable Microsoft SQL Server Native Client is not found. Install Microsoft SQL Server 2012 Native Client from http://www.microsoft.com/en-ca/download/details.aspx?id=29065 . Please expand 'Install Instructions' and download 'sqlncli.msi'2020

469
H
G
goskoog
asked in Authoring
Python Caller For Loop Indexing to Compare Two Feature Rows (or other method)

This is the final step to some complicated data sorting - so as an example lets say I have the following data: indexequipmentNamesequenceequipCount1a102b103c204b215c316d307d418b429b5310e5011b6412e6113b7514f70 The goal is to get data ordered like this: abbccdd... etc. This works by sorting the sequence column ascending and the equipCount column (unique counter of equipment name) descending. The problem is that if there is a sequence pair that does not contain a zero (both pieces of equipment have appeared before) then its no longer beneficial to sort equipCount descending, instead it needs to be sorted ascending(see index 7 and 8 sequence pair 4, they should not reverse order 2 to 1; and index 11 and 12 sequence pair 6, they should reverse order to be 1 to 4). Again this is all to get the final order to be abbccddbbeebbf. My solution to this was to check if each equipCount value in a sequence pair was not zero, and then to make even numbers = 0, because an even unique count means it is

697
debbiatsafe
Safer
dms2
Contributor
dms2Contributor
asked in Authoring
FME Workbench 2020 throws error on exit

I installed FME 2020.0.2 (build 20232 -win64) on a Windows Server 2012 R2 Standard 64-bit (6.3, Build 9600) machine.It works fine but throws an error message on exit and I'm concerned it may hide some important unwanted functioning I haven't found out so far. Before installing FME Desktop on our production server we want to make sure everything works as expected, so I can't overlook this apparently minor thing. Any idea of what is it about?A repair install did not solve the problem. See error details below: Application Name: fmeworkbench.exe Application Version: 2020.7.39.20232 Application Timestamp: 5eab95e4 Fault Module Name: Qt5Core_fme.dll Fault Module Version: 5.12.3.0 Fault Module Timestamp: 5cffcf60 Exception Offset: 0000000000028658 Exception Code: c0000409 Exception Data:

1051
erik_jan
Contributor
F
fk9200815
asked in Data
Why my FME 2020 Doesnot Read IFCSpaces? When reading IFC Step Xml file with Read Ifcspace geometries' to Yes, but still not present in select feature Type. i tried on different IFC Files from Revit in FME 2020.

Why my FME 2020 Doesnot Read IFCSpaces? When reading IFC Step Xml file with Read Ifcspace geometries' to Yes, but still not present in select feature Type. i tried on different IFC Files from Revit in FME 2020.

192
F
aron
Supporter
aronSupporter
asked in Authoring
Write files from attributes - Fanout does not do the trick

I have a dataset where want to write separate files based on multiple attributes. From the example below I would like to write a file with all the Jones, another with all the Smith, a third with all the Farmer and a fourth with any Kim. Fanout does not handle multiple attributes and in this case the StringConcatenator trick wont help, since most of the rows would be contributing to separate files. Any ideas on how I can achieve this? A B C D Jones  Farmer Kim Jones Smith   Jones Smith Farmer  

115
aron
Supporter
koenvdw
Contributor
koenvdwContributor
asked in Transformers
test tiff files on filesize

Hi I cant seem to find a way to test files on filesize. It's not a format attribute or something you can import with the files... You can do it with python probably, but I'm not a programmer. (I tried and failed :) ) All I want is: TESTERfilesize > 1 183 000 bytes    

2336
koenvdw
Contributor
jstanger
jstanger
asked in Data
Force Generic reader to choose MITAB over MAPINFO

When using a Generic Reader with Guess format from extension, I know it is possible to create a "dummy" resource in the workbench to pass configuration parameters, but how do you set the preferred order of readers that is applied? Say for argument's sake I need to read TAB files using MITAB (not MAPINFO) or SHP files using SHAPEFILE (not ESRISHAPE). I'm not making a judgement on which reader is preferred, rather if you are required to use one that isn't the default, how do you do that?

99
jstanger
bernarddinon
bernarddinon
asked in Transformers
How can i fix the precision of 3 with StringFotmatter for all the values (.3f) ?

Hello,  In my workspace, I use LenghtCalculator to have the "Distance" from line. I'd like to have three Numbers after .  I use Stringformatter on this attribute with Format String .3f but all value not have this setting.  Someone can help me to fix this?  I have also tried Attribute Manager with Math Opérator "ROund (Distance, 3). It's the same things.  Best Regards  

29017
bernarddinon
D
danielhamngren
asked in Authoring
What published parameters are supported in FME Data Experss App?

Hi,I've been looking for some documentation on FME Data Express with no luck. Specifically I'm looking for what published parameters are supported by Data Express.Some of my published parameters in a workspace has the label [unsupported] added to them when I open the workspace in Data Express.It would be great help to know which types of published parameters are supported.

102
D
david_r
Celebrity
david_r
asked in Transformers
Possible bug with DateTimeConverter rejected output

Hi, can someone please take a look at the behavior of the <Rejected> port of the DateTimeConverter and check if it's as expected:https://knowledge.safe.com/questions/113416/different-date-formats-in-the-same-date-column.htmlThe behavior is described in my answer and the comments below it.Possibly the same issue: https://knowledge.safe.com/questions/91296/datetimeconverter-rejected-port-null.html 

623
mark2atsafe
Safer
max_d
max_d
asked in Authoring
How do I create unique ID by groups?

Hello,I want to create a unique numeric ID in a new attribute field from a two-letters string attribute, this way:feature - IDAA - 1AB - 2AC - 3BA - 1BB - 2CA - 1CB - 2 CC - 3 CD - 4etc... I guess I need to count how many times a letter is listed and then create IDS for every count and repeat but I don't know how to do this. Many thanks, Max

1215
max_d
J
jlbaker2779
asked in Transformers
VariableSetter and VariableRetriever bug? - FME 2020.1.0.0 Build 20510

When using a SQLCreator or Creator, I can't get the VariableRetriever to attach attributes to the created data. It works correctly with any other data but not the creator(s). Can anyone else replicate this behavior? FME 2020.1.0.0 (20200305 - Build 20510 - WIN64)  Works correctly with a shapefile input _value is left null for the creator and SQLCreator records

212
J
nag
Contributor
nagContributor
asked in Data
What is the change in api token id generation in FME Server 2019 vs 2015

Hello Team,We were using a .Net code to generation API token to access FMEServer in 2015 version, Which was working fine.Recently we upgraded to FME Server 2019 tried accessing FME server with same source code which was using in FME Server 2015, was throwing an error as "No token was found for user id XXXXX". Could somebody help me to resolve the issue. Also let us know what is the change in token id generation using FME Server 2019? Does we need to update our source code to generate Token with 2019 version? Thanks in Advance!!!

246
nag
Contributor
pratap
Contributor
pratapContributor
asked in Transformers
Count of Attributes with irrespective of schema

Hi Guys,Can any one guide me on how to perform "INPUT" I have to as "OUTPUT" I require...Input will be GDB object class tableOutput will be excel spreadsheet.Schema of the table will be dynamic as I will use different tables. I have provided spreadsheet as an example to understand better...Thank you

253
bwn
Evangelist
A
andreasb
asked in Transformers
3D solid Clipper boundries leaving a thiny edge

Hello, Currently I'm trying to get a 3d model out of a 2d drawing. Now when extruding different areas and clipping those with each other to get the right solids i encounter a problem. When the boundaries of the different polygons are overlapping (for example: walls and rooms) I encounter the problem that FME sees a very tiny difference between them which leaves me with this very small boundaries where the overlapping lines are.Is there a way of solving this problem? I have messed around with the clipper parameters but for now I didn't manage to get any success. I also thought about buffering the certain areas by a very small amount to just get over the edge but I don't really like that solution; as this makes the model inaccurate. Also I guess this has to do with the floating point problem? When extruding i don't get the exact length but something that differs 0.00000001.Do i have to use the topologybuilder in this case? If yes where do I put it in? I'm still search

182
A
L
lidiad
asked in Data
Installing ArcGIS Pro on FME Server - FME Server Web Interface is down! SOS!

We have FME Server 2019. I want to run some python that uses arpcy from ArcGIS Pro.ArcGIS Pro installation requires Microsoft dot net 4.8. I have installed it and restarted the server machine.Now our FME Server web interface did not come back up. FME server seems to be running. But we can't access the web interface. 1. How do I fix the web interface for FME Server? Is it dot net that causes the problem?2. Has anyone successfully used arcpy from ArcGIS Pro on FME Server?

91
gazza
Contributor
alexlynch3450
Contributor
alexlynch3450Contributor
asked in Transformers
How does the AttributeValidator transformer process unique feature? Specifically, cloned attribute values.

Is there a way to reject or fail all features containing same value? Right now I would ideally like a way to route all features containing same value to failed port. Currently, for example, if I clone 1 record 3-time, two features fail and one feature pass. How do I route all features that have non-unique values to failed port?

85
alexlynch3450
Contributor
davideagle
Contributor
davideagleContributor
asked in Data
Create Hyperlinks in Excel?

Does anyone have any bright ideas. We're trying to write hyperlinks into an Excel worksheet but failing to do so. The old Excel ADO writer doesn't support this (http://fmepedia.safe.com/articles/FAQ/Reading-hyperlinks-from-an-Excel-spreadsheet) but I thought the new one might with perhaps some of the format codes that are now supported in the new writer (http://office.microsoft.com/en-ca/help/number-date-and-time-format-codes-HP005207595.aspx) but it appears not.  If you try to be clever and write a concatenated formula string into Excel with either writer like this:  =HYPERLINK("http://www.1spatial.com/fme","http://www.1spatial.com/fme")  ...FME just writes it explicitly as above... we've even tried adding a return line in the concatenator to no avail. Ironically if you open the results of this and click into the cell and hit return it enables the hyperlink, so it's not a formatting issue either.  So, I guess my plea is, has anyone done this or does

85316
ponceta
Contributor
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
My FME Workbench crashes when adding certain transformers

Hi.I originally had some issues with 2019.0 om my home pc with a home license. It crashed every time I added a Tester or a TestFilter transformer: https://knowledge.safe.com/questions/90340/fme-20190-problems.html These problems were solved in later builds, and neither 2019.2 nor 2020.0 crashes like this anymore. However, I just accidently ran into other similar problems with both 2019.2 and 2020.0 (and even 2018.1) on the same pc.Now it's the transformers AttributeFilter and AttributeValueMapper that makes FME crash immidiatedly.And I noticed that the Sorter transformer doesn't provide any attributes for the sort value either.Luckily both versions work on my office pc, but I would very much also like FME to work properly at home. Are there any information I can provide that'll help find the source of my problems ?I did check the "Improve FME by reporting ...", but I suspect it doesn't work when FME crashes.The pc in question is Windows 10 Pro version 1903 bui

887
lifalin2016
Supporter
vki
Contributor
vkiContributor
asked in Authoring
setting a parameter depending on the environment

I want to set the value of an attribute, depending on the environment, where my workbench is running (desktop, server dev, server prd),. I could do this with an parameterFetcher and get e.g. FME_SERVER_HOST. But I don't want to do this for each feature, but just once at the beginning.What's the best way to do this?I tried it with a scripted parameter, but I get an error, for FME_SERVER_HOST is not know when I run the workbench on desktop.Then I tried it with a startup-script. Here I don't get an error, but how can I set a parameter here, that I can use in the workbench?Thanks, Vera  

335
vki
Contributor

Badge Winners

Show all badges

Community Stats

31,821
Posts
120,868
Replies
39,457
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.