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
gio
Contributor
gioContributor
asked in General
Tester error after upgrade to latest

I upgraded a workspace in versionFME(R) 2019.2.1.0 (20191202 - Build 19813 - WIN64) Reason was to solve a sudden problem concerning fan out on a autocad writer.When scheduled and called trough a windows scheduled batch file it fails to complete the fan out. If i run it direct, the fan out works. So i decided to upgrade transformers,.   Now i get this error related tot the feature ordering across or over all ports. This error is given for all the testers in my workspace! Wh..wh..why? THis does not happen if i run the workspace directly (not trough a windows batfile) Here is the error:                 FME 2019.1.1.0 (20190801 - Build 19617 - WIN64)                    FME Desktop Oracle Edition (floating)                              Permanent License.                      Machine host name is: LDNPVWAPP074Operating System: Microsoft Windows Server 2012 R2 Server 4.0 64-bit (Build 9600)                Copyright (c) 1994 - 2019, Safe Software Inc.                              Safe Softwar

840
gio
Contributor
N
nroux
asked in General
Hi everybody, I'd like to manage FME scripts to GIT or GIT LAB whitout FME Server.

Hi everybody,I'd like to manage FME scripts to GIT or GIT LAB whitout FME Server.First question : is it possible ?Second question : what kind of way to try it ? Thanks for your response. Nicolas

280
david_r
Celebrity
A
ali.jo17
asked in General
Trouble adding Web Connection

I am trying to Read, and eventually Write, to an ArcGIS Portal hosted feature layer using ArcGIS Pro/Data Interoperability FME(R) 2020.0.1.0 (20200407 - Build 20218 - WIN64. I believe I was successful adding a new service using the ESRI ArcGIS Portal (Template) (see image 1). I tested, which connected to the Portal. When I try to add a Web Connection, I select the service I just created, Authenticate (successfully) (see image 2), but after that, I close the authenticate window and nothing is added to my available web connections, even after restarting FME (see image 3) I'm not sure if I missed a step, but I can't figure out what's going on/not working.

220
andreaatsafe
Safer
nic_ran
Contributor
nic_ranContributor
asked in General
Is it possible to set the NAD27 to NAD83 Datum at the workspace level?

This article:https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Configuring-Datum-Shifts.htmexplains various methods of configuring FME to work with USA and Canadian grid shift files. However, the company I'm working for routinely works with both USA and Canadian data, so it's not practical to set this value for all of FME. Rather than performing a manual CSMapReproject everywhere it's needed in the workspace, is it possible to define the grid shift file to be used just once for an entire workspace? It would be great if this was available as a setting under Workspace Parameters but there doesn't seem to be anything there....

140
nic_ran
Contributor
oliver.morris
Contributor
oliver.morrisContributor
asked in General
sql server jdbc timeout issues

Hi, I have a few sql executor transformers in a sequence. They are using sql server jdbc driver connections. When I run I get the following notices usually from either the second or the third executor in the chain. com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out. I have in the past got round this by putting in feature holders which seem to close the existing connection session but it doesnt appear to be working and is affecting workbenches in desktop and cloud. I dont get these issues with using the native sql client but because I need them to run in cloud they need to be on jdbc. Does anyone have any suggestions as to work arounds for this. thank you

2050
oliver.morris
Contributor
btl
Contributor
btlContributor
asked in General
Is this PythonCaller documentation incorrect?

I tried running the Class Interface example on this page:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/pythoncaller.htmBut the code as written, (after correcting the indentation) gives me the same area for each polygon.To get the expected result I have to remove the 3rd & 4th from last lines (and re-correct the indents) i.e.:import fmeobjects class FeatureProcessor(object):     def __init__(self):         self.featureList = []         self.totalArea = 0.0           def input(self,feature):         self.featureList.append(feature)         self.totalArea += feature.getGeometry().getArea()         feature.setAttribute("total_area", self.totalArea)         self.pyoutput(feature)Was this written for an earlier version of Python, or is it an error?  I'm not good enough at Python to know why the original script didn't work.

232
btl
Contributor
B
bi
asked in General
Update, delete and insert in single workspace

I'm trying to find an effective way toread in a feature classuse an area on area overlayer with another feature class to split some geometries and inherit attributesupdate the feature class that I read in in the first place with the updated geometries and attributesSo there are two datasets, blue and red. Blue is the data I want to read in, edit and then write out. Red is the data I am going to split it by.I somehow want to take the blue data and edit it and then write it back out to the same feature class. In the below, the green squares are not needed as there will be no change. The orange squares in the centre will stay identical except that one of their attributes will be updated to include the "BOX_ID" of the red box (in this case, the OBJECTID) with which they intersect. The yellow squares need to be split along the boundaries of the red box, with the portion that is "inside" the box inheriting the ID of the box and the portion that is outside the box just

1670
B
C
cbrown
asked in General
I have quite a complex workbench which I have been running successfully for a year or so which for some reason is suddenly failing. I get an 'Access is denied' error message. I have checked all path and filenames and have access to all. Anyone any i

350
C
LizAtSafe
Safer
LizAtSafeSafer
asked in General
What's Up Wednesday: FME News for the Week Ending 22-January-2021

Welcome to your weekly dose of FME news! FME UC Postponed to 2022For the safety of all our attendees as well as everyone involved, we have made the difficult decision to postpone the FME User Conference to 2022. Save the date for August 23-26, 2020. For more information on tickets or refunds, please see our FMEUC FAQ.  FME 2020.2.2 ReleasedDownload the latest version of FME 2020. Some improvements include:Upgraded CityJSON to 0.7Added Python support for ArcGIS Pro 2.7Shortened generated temp file paths Also, check out the 2021 beta with new features such as data streams and a published parameter manager.  Webinars and Training in German, Spanish, Norwegian, and FrenchThanks to our Partners, you can watch a webinar or attend a course in another language. Check out our webinars or training pages to see what is available.  Website ImprovementsOur digital marketing team is always working hard to improve our website to help you get the information you need. But we wanted to share a little a

120
danilo_fme
Evangelist
J
jaircasti
asked in General
Creating a 3D Line with slope

I need help trying to create 3D lines with slopes. I do have 2 points to create a line but 2 points have different elevation. the VertexCreator and LineBuilder use only one elevation to the whole line. Is it any way to create this line? Jairo Castillo

1050
J
J
joe101
asked in General
How to set up a config for readers and writers that refer to files in a folder.

I have several fmw files that read and/or write to a particular folder structure. But sometimes the location of the folder structure changes servers. So i'm wanting a way to set a root variable for readers/writers so i only have to update the one variable instead of updating all fmw readers/writers. --------------------UPDATE--------------------I need to add, my intention is to have one variable/setting/config that is globally available across all my workspaces. So changing one configuration would affect all workspaces.For example, in a shapefile writer, the dataset location is d:\\folder\\to\\file.shp, but I'd like to change the location to something like $(GlobalVar)\\folder\\to\\file.shp. Where GlobalVar is available across all workspaces.

790
caracadrian
Contributor
A
axelouar
asked in General
In an oracle database I would like to export to excel format a table with a particular filter. I would like to output only the rows containing the most recent date per section. How can I do this on FME?

Example of my database :   I am a beginner in FME, thanks for help !

131
david_r
Celebrity
A
aquamarine
asked in General
Delete Reader from canvas but keep in Navigator window

Hi, I have a generic reader in my workspace which allows me to read in all types of file formats. However, I believe that in order to set the parameters for the different types of file formats, I need to add to my workspace, a reader for the particular file format I want to set the parameters for. I have done this, but I want to now remove the reader from the canvas but keep it in the Navigator window. I managed to do this once awhile ago, but now I have no idea how I did this. Any ideas?

90
A
jamal
jamal
asked in General
FME 2020: The “GeometryFilter” tool fails to detect objects of “circle” type in AutoCAD,

FME 2020: The “GeometryFilter” tool fails to detect objects of “circle” type in AutoCAD, I couldn’t figure out how to filter objects of “circle” type in AutoCAD. The “GeometryFilter” tool fails to catch them. Then how to filter the CAD circles? The data is attached         

560
jamal
liboc
Contributor
libocContributor
asked in General
Hi, I am newish to FME professional and I am wondering if there is a way of extracting the filename of a hyperlink (in google sheets).

To put this into context I have a google sheet which has hyperlinks to photos. It shows the shared link but not the filename. I need to be able to extract the filename (and ideally the directory path from Google drive) so I can relink the photo to the new location. Hope this makes sense

50
liboc
Contributor
jamal
jamal
asked in General
FME 2020: Which tool can be performed to display where the lines overlaps (duplicates) are,

FME 2020: Which tool can be performed to display where the lines overlaps (duplicates) are, I couldn’t figure out Which tool can be performed to display where the lines overlaps (duplicates) are. For example, in the screenshot below, there are 4 lines and overlapped in the place marked in orange. How this overlap can be displayed? the data is attached  

70
jamal
jamal
jamal
asked in General
FME 2020: How to get lines extended to centers of circles?

FME 2020: How to get lines extended to centers of circles? In the screenshots below, this is how surveyors draw parcels. What I wanted here is to extend the lines that touch the circles to their centers so that all lines get connected at these centers How this might be performed in FME? Which tool can help on this?Sample data is attached   

140
jamal
inframan
Contributor
inframanContributor
asked in General
Exposing the X and Y Coordinates of a line

I have a shapefile, it is all lines with only two points in each line. Ultimately I'd like to expose the X and Y, start and end, of each line. CoordinateExtractor seems to be able to expose the X and Y of all the points but is there a way to filter that list, like Start X, Start Y; End X, End Y?

1780
inframan
Contributor
A
abbas_lokat
asked in General
How to find points that aren't in a polygon (but they match on an attribute)

I'm trying to create a validation routine that tells me what points are not in their expected polygon. I have two tables with an areaid common to both- one has point geometry (building b) and the other has polygons (area a). something along the lines of the following badly phrased pseudocode!select * from building where building point does not exist in area and a.areaid = b.areaidAll help appreciated! Thanks in advance

1350
redgeographics
Celebrity
parashari
parashari
asked in General
Chaining Logic to Select Same Group Roads And Upgrade

Hi Community, I have a road network where roads are defined in road classes (1-5). While comparing the road from two different geometries(local and client), I need to upgrade my road network on the basis of client's road class. In the image attached, the yellow lines are road class 4 and grey ones are road class 5. So, I need to upgrade road class 5 to class 4.In the image shared, the one selected road element (in cyan), needs to be upgraded from the top (hanging geometry) to till the yellow line in the down south, and rest all data remains same.In other situations, one side of the road can be a hanging geometry, so the road selection can be unidirectional to bidirectional. But, the upgradations has to be limited to only one road class update (4 to 3, 3 to 2 etc.,) This is because road class 1 (road of international importance) can directly only be connected to class 2(national/regional importance) and so on. So there has to be a chaining logic where I can select the road elements

70
M
colasamk
Contributor
colasamkContributor
asked in General
Is there a automated way to extract data from multiple Oracle tables (thousands) to CSV files?

Hello, I'm trying to extract data from Oracle database with several thousand tables to CSV files.Because of the number of tables, extracting each table to CSV file is not an option. Is there an automated way to read the list of tables from Oracle DB (non-spacial) and extract each table to CSV files? I haven't been able to find any articles or forum questions to do that. Any help will be appreciated. Thanks.

1220
M
N
nikkikaur
asked in General
Data doesn't align after export from SQL DB to File Geodatabase

Hello,I am extracting data from a sql DB and exporting as file geodatabase. But when I compare them in Arcmap the data is not aligned it is next to each other but not on top of each other why would that be? I have same projection on both the data sets. ThanksNikki

100
N
gcarmich
Participant
gcarmichParticipant
asked in General
Create a table with all possible pairings of numeric values from input table.

 I have a .csv table with 35 numeric values in increments of 5 (5, 10, 15,..). I need to create a table that list all possible unique pairings of these values in two columns ((5,5), (5,10), (5,15),...) . I've tried joiners, mergers, and combiners but can't get the output I need. Is there a transformer that would do this?

710
gcarmich
Participant
T
timheteren
asked in General
FME AGOL attachement to Emailer transformer

Hello, How can i get the attachment of a AGOL layer to the Emailer transformer? Keep getting errors...Please help :)

600
magnust66
inge
Contributor
ingeContributor
asked in General
What do you guys say when you're asked: "What is FME?"

I find it very difficult to explain in a few sentences. I never know how to comprehensibly explain what FME does/can do, without giving a 20 minute monologue on all the possibilities I can remember at that moment. So what do you say when someone asks you what FME is?

1740
drc43
Contributor

Badge Winners

  • English Speaker
    jamatsafehas earned the badge English Speaker
  • Student (Grey)
    hdnguyenhas earned the badge Student (Grey)
  • Teacher (Grey)
    hdnguyenhas earned the badge Teacher (Grey)
  • FME Certified Professional
    rune.van.sevrenhas earned the badge FME Certified Professional
  • English Speaker
    nasirhas earned the badge English Speaker
Show all badges

Community Stats

31,789
Posts
120,751
Replies
39,405
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.