Skip to main content
  • EN

General

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

  • 4,042 Posts
  • 13,932 Replies
4042 Posts
john_gis4
Contributor
john_gis4Contributor
asked in General
Turning off logging of SQL Statements in FME Desktop

I'm using FME Desktop 2020 and have a workbench with several SQLExecutor transformers. These are performing 1000s of SQL queries against a PostGIS database and working fine. The only issue I have is that every SQL statement is being logged in the FME log, which is creating a bloated log file (100s of MBs in size).  I don't need to see the individual SQL statements in the FME log, but these are coming through as INFO level messages (I would actually class this type of logging as DEBUG not INFO level log messages - but that's another story). I know there are options to turn off INFO messages, but other INFO messages may be useful. So is there a way to turn off logging of SQL statements only? I would have thought this could be a global logging option or an option on the SQLExecutor (and SQLCreator) if this option doesn't exist already somewhere.  Any thoughts appreciated. John

1240
john_gis4
Contributor
gisgeek
Contributor
gisgeekContributor
asked in General
Hi there I am trying to use SQL Executor but getting an error

This is the statement I am using in SQL Executor. It runs fine in SQL Server Management studio.  update a set ParcelID = NewParcelID, KOAUnitID from  (select a.ParcelID,b.ParcelID NewParcelID,a.KOA_UNIT_ID KOAUnitID from   [GISStaging].[dbo].[KAINGAORALETTABLEUNITSTAGINGNZTM] a left join  GISPublish.dbo.Parcel b on a.shape.STIntersects(b.shape) = 1) a  and this is the error message:Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `update a set ParcelID = NewParcelID, KOAUnitID from (select a.ParcelID,b.ParcelID NewParcelID,a.KOA_UNIT_ID KOAUnitID from [GISStaging].[dbo].[KAINGAORALETTABLEUNITSTAGINGNZTM] a left join GISPublish.dbo.Parcel b on a.shape.STIntersects(b.shape) = 1) a'. Provider error `(-2147217900) Incorrect syntax near the keyword 'from'.'A fatal error has occurred. Check the logfile above for details

1773
bwn
Evangelist
dor1411993
Contributor
dor1411993Contributor
asked in General
Hey! I would be very happy for your help: I am analyzing a network of large municipal drainage system, I want to check the correctness of the data of the lines and drainage manholes.

Our situation is as follows:We have a network that we have built with the help of several sources of information, and we want to verify their correctness, prior to the publication of the information.One of the tests we did, and have already fixed the problems, is a check of the flow directions. Each line exits an manhole, and exits to the next manhole, where vertex 0 is the beginning of a line, and vertex 1 is the end of a line. (You can see in the picture with the arrows, which symbolize Vertex 1)I did this test with the help of "VertexExtractor" , and it was pretty successful.Here I need their help:The relevant data for the lines are: "StartHeight" - the height which the line begins- the height of the exit from the manhole, and the invert which it is exit from the manhole."EndHeight" - the invert which it entered the manhole.The relevant data for the manholes is "IL out"= invert level out.Because the drain flows in gravity, the "StartHei

140
bwn
Evangelist
connecter
Contributor
connecterContributor
asked in General
Shape export problem

Hi,I export a shapefile from FME. The shapefile contains lines and some entries without lines. After that I open it in QGIS. The shapefile looks good, but then I try to edit some specific lines I get an error: CRITICAL   Layer Info : OGR[3] Fehler 1: REPACK of layer 'Info' failed. I try to find a solution for the problem and find a workaround:Export the same shapefile again in QGIS to shpAll data inside are the same, only when I try to open it, the header is differentQGIS writes "ƒpè": FME writes ƒè: When I copy the three characters from QGIS manuell it works! Why? What do these characters mean? What can I do to get the same output like QGIS? Sry I can´t share the workflow and the data-> workstuff. Thanks for your help. 😃

930
connecter
Contributor
R
rajeshkolhe
asked in General
1. Do FME 2020.1.1.1 support writing 0:n relationship in Smallworld 5? 2. Do FME 2020.1.1.1 support writing Smallworld 5 internal tables?

Products - FME 2020.1.1.1  & Smallworld 5.2.4Relationship 1:nWe are able to load the data in Smallworld parent and child objects and maintain the relationship (1:n) using FME. Relationship 0:nFor 0:n relationship we are able to load the data in Smallworld parent and child ( except Relationshipattribute) objectsThe intermediate internal relationship table between the parent and child is not accessible in FME Smallworld 5 Writer to update the 0:n relationship.1. Can you guide in identifying what could be wrong?2. Do FME 2020.1.1.1 support writing 0:n relationship in Smallworld 5?3. Do FME 2020.1.1.1 support writing Smallworld 5 internal tables?

100
R
T
theodore
asked in General
Is there an alternative to the Curvefitter, to make a line of segments smoother, BUT with every initial point contained in it.

Hello,I have a large set of points, that I need to connect. With a LineBuilder and a Chopper, I can obtain each segment, but the angles are sometimes a bit harsh.And so I would like to soften them, creating a curve instead of a set of lines. But I want the curve to go trough ALL the points of the input. Therefore I can not use a Bezier curve.Any idea on how is it possible ?Thanks  The first pic is how I would like it, and the second is what I do not want, a Takashi solution for a similar problem, but that does not work here. 

390
J
gisbradokla
Enthusiast
gisbradoklaEnthusiast
asked in General
AutoCAD text rendering

when i bring an autocad drawing into any fme wb it shows the text as a different size than what is in the drawing. If i use esri to display the drawing it shows exactly what is in the drawing. Why can't this be done in fme?another feature i would like is to be able to turn the autocad text into linework (with the string as an attribute). I have accomplished this in some software before (can't really remember which software). The first part of the request would be to quickly read a file make a change and write the file back out with only a small change. (virtually impossible to do with fme currently). The second part of the request would be to in effect use the drawing in fme to write out to many other software with the graphics of the drawing preserved.

1290
deanhowell
Influencer
B
bastien13001
asked in General
How to create empty shape using an attribute as name

Hello there,I need to create empty shape files, using an attribute as directories and files names.For now I always have an object( with "NULL" attributes values) in each tables.Any one have a solution ?

100
B
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in General
Identify overlapped polygons

Hi all,  I have multiple dwg files. I created concave with help of HullAccumulator and I would like to identify which concave hull intersects which concave hull. It is possible that one concave hull intersects more than one. For example if polygon 1 overlaps with Polygon 2 and Polygon 2, I would like to add this in the attribute of Polygon 1.  I am trying to combination AttributeCreator & Intersector and Tester but I could not get expected results until now.  Thanks in advance.

360
jdh
Contributor
damian6105
Participant
damian6105Participant
asked in General
Dynamic schema definition output issues.

Hi I'm trying to export all of my feature datasets in my ArcGIS Online account to independent shapefiles. I'm using the 'Dynamic Schema Definition' option in my Writer to output a separate shapefile for each of my feature datasets. In my ArcGISOnlineConnector transformer under 'User Content Folder', if I select my root folder, I get shapefile outputs with names that match my feature datasets, but they are all just empty shells, no attributes or geometry. However, in my ArcGISOnlineConnector transformer, if a specify a specific subfolder from my ArcGIS Online account for 'User Content Folder', then the shapefile outputs are all good, with correct attributes and geometry. But obviously I only get outputs from that one sub-folder. I need shapefile outputs from all subfolders. Can anyone point out what I'm doing wrong please? FME file attached. Cheers, Damian

140
rahulsharma
Safer
R
richard_che
asked in General
How to split a shapefile based on attribute value?

Essentially I'm looking for a group by function where I can group my data based on a shared value and then export these subsets into seperate shapefiles where each subset shapefile shares the same attribute value. For example my shapefile has field that has either a value of 1,2,3,4 I'd like to create 4 shapefiles from the main shapefile where 1 shapefile has the value of 1, the other has the value of 2, etc..

3360
J
A
abdou
asked in General
FME Data Inspector 2019 crashes when any file is loaded

Hi guys.Everything was working great with the 2018. But since I moved to the 2019, no matter what type of file I bring in the Data Inspector, it just crashes after trying to load it. The Workbench works fine though.I tried all the builds (of the 2019) that have been released so far, no success. I tried to re-install, uninstall, still nothing. But as soon as I get back to the 2018, Data Inspector works again.The problem is that I need the 2019 for latest import and visualization of IndoorGML. I suspect the bug is related to Qt5 because when I try to debug the application with mvsc2017 I have the following exception thrown:Unhandled exception at 0x00007FFE39931BFC (Qt5Gui_fme.dll) in fmedatainspector.exe: 0xC00000FD: Stack overflow (parameters: 0x0000000000000001, 0x000000CEEFE03F18).I did not update anything related to Qt5 lately. Anyone has an idea?Thanks in advance.

5912
mlufkin
Contributor
gisbradokla
Enthusiast
gisbradoklaEnthusiast
asked in General
invalid geometry type

I am getting a rejection of one line in my wb that seems to be valid.as per safe documentation i have place a geometry validator and geometrycoercer into the workflow. yet it is still rejectedWhy would this be getting rejected for invalid geometry type?with these parameters on the validator.Feature Type MValue_OUTPUTCoordinate System NM83-EFDimension 3DNumber of Vertices 2Min Extents 7764.78954863, 4086.494, 3384.991Max Extents 7764.868, 4086.956395047, 3385.0004943987096Attributes (61)  _elevation 3384.991  Alignment_Sheet_Status COMPLETE  autocad_color 12  autocad_entity autocad_line  autocad_entity_visibility visible  autocad_layer_desc  autocad_layer_frozen no  autocad_layer_hidden no  autocad_layer_locked no  autocad_layer_on yes  autocad_layer_plottable yes  autocad_linetype ByLayer  autocad_linetype_scale 1  autocad_lineweight -1  autocad_original_color ByLayer  autocad_original_entity_type autocad_3dPolyline  autocad_resolved_linetype CONTINUOUS  autocad_source_filename S:\\SUR

10300
ebygomm
Influencer
rva1
Contributor
rva1Contributor
asked in General
I'm looking for a way to populate a list based on current list value without exploding it.

Hi ! I hope someone can help. I'm trying to create more attributes within existing list without exploding and rebuilding it. Like this: _list{0}.aaa : A_123_list{1}.aaa : A_234_list{2}.aaa : B_245 to _list{0}.aaa : A_list{0}.bbb :123_list{1}.aaa : A_list{1}.bbb: 234_list{2}.aaa : B_list{2}.bbb: 245 Is there a way? I'm specially looking for help on the list creating part. I can manage renaming the list values;) I was looking for a way to first do this:_list{0}.aaa : A_123_list{0}.bbb : A_123 and than do this:_list{0}.aaa : A_list{0}.bbb : 123 cheers,ronald 

80
rva1
Contributor
V
vinnyboy
asked in General
Compare two strings and output the matching parts and count of parts that matched.

Trying to compare two columns that have strings concatenated by ' | ' and look like this: COL Aabc | def | ghi COL Babc | xyz Desired result:COL C that contains the matching part of both strings. In this case result should be: abc COL D containing the count of matched parts of the string. In this case, result should be: 1 Would appreciate your response. 

2950
virtualcitymatt
Celebrity
david.benoit
david.benoit
asked in General
SharePoint Reader Issue- How to resolve a 401 error at Runtime for NTLM authentication.

I used NTLM authentication in FME Desktop back in 2018/2019 with no problem. Now with FME 2020, it no longer works.  I am able to set up the reader fine: and select my List(s) with no authorization issues: However, at run time, or when trying to inspect the data, it fails!  Microsoft SharePoint List Reader: Client-side error: '404 Client Error: Not Found for url: https://ecollab.ncr.int.ec.gc.ca/theme/OPG-1A1-1A2/priv/SAR_Recovery/_api/web/Lists(guid'2b88722b-bee9-40ff-8520-2321259e8a20')/Items?%24select=Title%2CChild%2CParent_x0020_not_x0020_to_x0020_%2CParent_x0020_COSEWIC_x0020_ID%2CParent_x0020_2_x0020_COSEWIC_x00%2CChild_x0020_1_x0020_COSEWIC_x002%2CChild_x0020_2_x0020_COSEWIC........................' returned from SharePoint. Error message was: '' A fatal error has occurred. Check the logfile above for detailsFailed to specify the feature index as constraints on the reader. As mentioned, I am using the very latest version of FME (just upgraded to try an fi

2200
david.benoit
N
nguyenduyliem
asked in General
Convert a dgn file into shapefile while still keeping the Fill values of objects

Dear All, I have a dgn file (version 7).I want to convert a dgn file into shapefile while still keeping the Fill values of the objects. How can I do that by using FME Desktop?I have tried using Feature to Feature in ArcGIS but all the values of Fill are -1.Thank you very much!Yours sincerely,ND Liem

530
N
LizAtSafe
Safer
LizAtSafeSafer
asked in General
What's Up Wednesday: FME News for the Week Ending 16-October-2020

Keep up-to-date with this week’s installment of What’s Up Wednesday. Gartner Peer Review SurveyIf you haven’t already done so, there is still time to earn that shiny exclusive badge on the community for filling out the Gartner Peer Review Survey. Get started by visiting http://fme.ly/CommunityInsights and entering your community username.  WebinarsIf you missed it, you can watch the Ask Me Anything FME Server Edition webinar. Thank you to everyone who submitted questions, this webinar was a huge success and we are planning on doing more like this in the future.  We also have lots of upcoming webinars hosted by Safe, such as integrating with ArcGIS Online, working with BIM, and merging data.  We also list webinars offered by our Partners on our website. There are a few upcoming to check out like transforming ‘almost’ anything, automating ‘almost’ anything, automating your remote office, and an introduction to FME presented in Dutch.  FME TrainingNext week we are offering two free live o

60
LizAtSafe
Safer
P
pieterlootens
asked in General
Counter - restart on attribute change

Hi all, I would like to know if it is possible to restart a counter when an attribute in a set of features changes. I've only succeeded in sorter the entire feature set from 1 -> x. thxPieter

1160
P
bjudes
Enthusiast
bjudesEnthusiast
asked in General
When dissolver a feature into its neighbour, I want the neighbour's attribution to win every time?

Hi, I have a dataset with a class called drains, I no longer want drains to appear in the dataset and would like to merge/dissolve these on their nearest neighbour. When I do this at the moment, many dissolve and the neighbours attributions wins out, but in some cases (it appears to be when the drain is the bigger feature) the drains attribution remains. Is it possible to dissolve all drains into their neighbour and always have the neighbours attribution remaining?Thanks for any help. B

80
bjudes
Enthusiast
J
javsal
asked in General
looping or controlling workspace flow

Given a workspace that uses FeatureReader, with a Geodatabase feature class as the "initiator", does anyone have a suggestion for how to process one Geodatabase feature (from the initiator) at a time? I have a large geographic area currently as the initiator and the model goes on to process millions and millions of features from dozens of feature classes (via FeatureReader), and is a slug! I am hoping that by clipping the data that represents my initiator in the above description, and finding a way to make workbench process only one feature at a time from a single geodatabase feature class, it can process the data in more timely manner. I have looked in to Workspace Runner but I can find any material on how to use it to process features from within the same feature class.  Thank you

180
bwn
Evangelist
D
david.bondy
asked in General
How do you prevent a model from writing records when there are errors or warning present in the log?

I would like to prevent the writers from executing when there are any errors or warnings present when a model runs. Is there a way to accomplish that?

1160
M
armando_amador
Contributor
armando_amadorContributor
asked in General
Pagination Size in the Attribute Exposer.

I would like to increase the amount of elements size from an Attribute Exposer.How can set this to receive the total data ? 

100
danilo_fme
Evangelist
J
johntannew2018
asked in General
Convert DTED to MBTiles Possible?

I like to use FME Desktop to convert multiple DTED Files into one single MBTile file. Does anyone has a simple example on how to go about it?

560
jdh
Contributor
LizAtSafe
Safer
LizAtSafeSafer
asked in General
What's Up Wednesday: FME News for the Week Ending 9-October-2020

Welcome to another crisp autumn What’s Up Wednesday, most of the leaves have fallen where I’m writing this from and the rains have set in. What better time to grab a hot beverage and sit down to catch up on the latest FME news.  2020.1.3 (b20632) ReleasedIf you are interested in our new trial process, this build has some updates for that. As always, you can download the latest release or try out a beta on our website. FME World Tour on DemandIt’s been almost six months since we transitioned our FME World Tour from a roadshow to a new virtual experience. Did you know we recorded the event thing so you can watch it on demand whenever!  Now is also a great time to start thinking about your FME World Tour presentations for 2021.  DataEng UncomplicatedDataEng Uncomplicated is an awesome FME customer YouTube channel that produces high-quality walkthrough videos covering some of the more complicated FME tasks. If you’re looking to change the temp directory, perform basic web scraping, learn h

60
danilo_fme
Evangelist

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,396
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.