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
lambertus
Enthusiast
lambertusEnthusiast
asked in General
Group Based - Select maximum value attribute and keep those records

Dear community,I have a table with two records for which I want to get only the record where _min in row 2 is less compared to _min in row 1 (or using _max). Hence, for the table below I want to get the second row and all attributes from that row. Any ideas? 

4850
lambertus
Enthusiast
aguan
Contributor
aguanContributor
asked in General
Is it possible to use pre-write SQL to delete features in a file geodatabase feature class?

I see the file geodatabase writer has pre and post writer SQL options. So I assume I can do some deletion before inserting. Can I do "delete from table where attribute = 'attributeValue'"? Not sure what the syntax should be. 

510
aguan
Contributor
B
brian.telintelo
asked in General
I have a writter that is an IMDF type. However, all of the writer properties are disabled and I can't modify and edit them. I should be able to add elements to the "properties" block of geojson.

I have a writter that is an IMDF type. However, all of the writer properties are disabled and I can't modify and edit them. I should be able to add elements to the "properties" block of geojson.

40
B
B
bgfield
asked in General
Using SchemaSetter assembles attribute in apparent random order - how do I get them in their original order?

I'm setting up a workbench that runs a SQL query on an Oracle db (using SQL Executor) and converts it into an ESRI Shapefile. The workbench is dynamic; we have about 200 pre-defined SQL queries stored in a config file that is retrieved at runtime based on user input and stored in a parameter. I've got everything in the workbench set up and working fine; a user can pick which query they want to use, the SQL Executor will execute the appropriate query, Schema Setter will build a list of attributes based on the SQL Executor, and they will be written to the Shapefile. The problem is the order in which the attributes appear seems to be completely random. If my SQL query is "select a, b, c, d, e, f ... from table" my resulting shapefile will show the attributes in something like e, d, f, a, c, b as opposed to the order in which they were queried. The order is the same each time so I guess it's not TOTALLY random, but I have no idea how it's getting the order it'

530
hkingsbury
Celebrity
R
richard_che
asked in General
How to extend segments to cover gaps in road?

I'm currently working with a dataset that contains about ~1000 segments with multiple roads, each roadname contains multiple segments which are usually not connected and there is no field value that has any sort assigned to these segments. I would like to connect the "current" segment to the next segment if the roadname matches. My original thought process on how to go about this wascreate a line buffer where the endcap is square and only have the end cap extend out or "buffered" and have the width of the segment buffer size remain the same as the original line or ~1m buffer, however after looking into this I dont believe its possible to set different values for the buffer width and endcap.I would have used spatial filter and group by road namethen I would have used vertex creator to get the end gps of the "current" segment to be the start for the next segment for those flagged from the spatial filter. Here is an example of the network I'm only try

340
R
LizAtSafe
Safer
LizAtSafeSafer
asked in General
What's Up Wednesday: FME News for the Week Ending 18-December-2020

Welcome to the final What’s Up Wednesday of 2020. We’re going to pause for the holiday season, but we’ll be back with all the new and exciting FME updates on January 6th, 2021.  Twelve Days of FME 202We’re already on the 7th challenge! Have you been keeping up? I’ve been enjoying watching all the submissions come in for the art and meme challenges, great work everyone!  Do you have no idea what I am talking about? Now until January 8th, we are having an FME contest that gives you twelve chances to win a prize! Throughout the month of December, various challenges and puzzles of varying difficulty will be released to the community. Complete the challenge or puzzle within the limited time frame to be entered to win. See the Contest Terms and Conditions for the full schedule or the launch page for links to all the challenges.  FME TrainingIf you are reading this shortly after I posted it, you can still sign up for the City Works and FME training course; it starts today at 9am PST.  FME 202

80
LizAtSafe
Safer
alc33
Contributor
alc33Contributor
asked in General
encoding and language driver ID

Hi! I'm trying to define the encoding for my shp but directly on the dbf and not on the cpg. I choose UTF-8 on the parameters and I always have a .cpg file. I looked on the shp writer help and I saw this sentence :"The output Shapefile .dbf will contain the language driver ID for the selected or detected encoding, if no language driver ID is available for the encoding, a .cpg file may be generated instead." I don't understand what is a "language driver ID ". Can you explain ? Thanks!

1020
alc33
Contributor
A
aquamarine
asked in General
Feature count has disappeared (FME 2020.1)

Hi,I have been using FME 2020.1 for about 6 months now and suddenly today the Feature Count numbers disappeared while running a workbench (and after the workbench finished running). The Feature Counts appear if I run the workbench in Feature Cache mode, but not in normal mode. I'm not sure if I unknowingly changed a setting but I didn't think I did. I am using version FME(R) 2020.1.1.1 (20200817 - Build 20614 - WIN64).Has anyone else encountered this problem?

690
hkingsbury
Celebrity
K
krishnaluvsu
asked in General
Update features of ArcSDE (staging) to ArcSDE (Production)

I want to copy all the feature classes (with attachments), tables to be copied from one ArcSDE to another ArcSDE.  I have added writer and in writer parameters, I have tired Feature Operation as Insert, Update, etc... Instead of updating the Feature Class, the data is getting appended to the Feature Class... Any Help on this? Thanks,Krish  

40
K
D
dmatranga
asked in General
Rotate polygon by compass bearing angle

Using a set of input points (GPS data), I buffered each point by 1 meter to create square areas (polygons).  Now, I would like to rotate each square (polygon) by the bearing angle collected from the GPS data. Anyone know how to do this? I tried the Rotator, but after inspecting the output, this doesn't seem to work. Note: The bearing is an angle measured from North (where Due North is 0º), so Due East would be 90º.

1890
jdh
Contributor
bubblebeb
Contributor
bubblebebContributor
asked in General
How to use LIKE query in FeatureReader on a PostGIS database.

I am wanting to search a PostGIS database using a Contains or Like query to search strings for a partial match. My last attempt is proprietor_1 LIKE '@Value(Name)' I also tried CONTAINS(proprietor_1, '@Value(Name)') proprietor_1 is in my PostGISName is in my routine Any assistance with queries would be great.

1672
caracadrian
Contributor
A
aneta
asked in General
Support for the Kronstadt vertical system

I have an IFC file that doesn't have an assigned horizontal and vertical coordinate system. I know that the coordinates are in EPSG: 2177 and Kronstadt (PL-KRON86-NH), but in milimeters. I created my own .prj files :.prj for EPSG : 2177 in millimeters.prj for EPSG : 2177 in meters (WKID: 2177).prj for Kronstadt in milimeters.prj for Kronstadt in meters ( WKID: 5705)I tried using Esri Reprojector but I couldn't set vertical system. I also tried using CSMapReprojector but I couldn't see. Does Kronstadt is supported by FME? Regards,Aneta

190
A
D
dj_huisman
asked in General
Write data second time or append to ARCGISPORTALFEATURES doesn't work

Writing data first time works well. If needed a new object is created in ArcGIS portal. But when try to insert the data (with or without a truncate) the next error i get. Can't find a similar problem on community.safe.com. ArcGIS Portal Feature Service Writer: Writing features for layer/table 'DRD_O_SensordataWielwijk_FME3', with 91 inserts, 0 updates, and 0 deletesPython Exception <Exception>: Second parameter to FMEException() must be a list of strings.A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsTranslation FAILED with 2 error(s) and 0 warning(s) (91 feature(s) output)

140
rahulsharma
Safer
pmcpherson
Contributor
pmcphersonContributor
asked in General
Reading CSV tables with changing attributes

I've read a number of articles here regarding "dynamic schemas", but it appears I'm missing something fundamental, and so I will try asking my question a different way. I want to create a workflow that will read a CSV file that will change from time to time, either in the number and names of its columns, or in the number of rows that exist. The workflow will then "enrich" the data found in the source table by querying an API using the value of one of the source columns (which will not vary in name), and finally the workflow will write a CSV with the original columns AND the "enrichment" columns. My problem is not with the API calls or the "enrichment" process, but rather that I can't seem to figure out how to set up the workflow so that the correct columns are read and interpreted unless I manually press the "parameters" button in the FeatureReader transformer. (I'm using the FeatureReader and FeatureWriter transformers

1750
david_r
Celebrity
G
garydlester
asked in General
Why does FME Server fail to read sde tables when FME Desktop can read those tables?

I have a workspace that I am running locally on my computer. This workspace is connected to an sde database on Amazon EC2 instance. This workpace is very simple translation just a reader and a writer, the purpose of the workspace is to completely delete all features from the sde database. However when I publish this workspace to FME Server the translations fail due to this error. 2020-10-18 05:39:39 | An error occurred while attempting to open the table,[...]. The error number from ArcObjects is: '-2147216057'. The error message from ArcObjects is: {Invalid parameter value passed to function}2020-10-18 05:39:39 | It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FME Has anyone had an error like this before? I just don't know why desktop workspace works fine but once it is published to FME Server the workspace no longer functions,

1407
G
blackheart
blackheart
asked in General
User and Password for Server

I just install the Server and its asking user name and password please any one can tell me how can i get userna me and password ?

40
david_r
Celebrity
mario_bla
Participant
mario_blaParticipant
asked in General
How to detect overlapping polygons?

Hello,this was supposed to be an easy one, but I can't figure out how to detect overlapping polygons. Why is there no "Requestor Overlaps Supplier" in SpatialRelator according to this spatial predicates. How am I suppose to detect overlaps? 

2600
mario_bla
Participant
sar_copp
Contributor
sar_coppContributor
asked in General
Best method to join 10+ tables together based on a shared column?

Hi, I have an address_point base table that I would like to join with 10+ other tables. They all have a shared column called UPRN.Is there a better way than stringing together a series of 10+ FeatureJoiners?

1760
M
nielsgerrits
VIP
nielsgerrits
asked in General
Convert string with binary value to a IEEE754 Float.

I try to convert the binary value01000000 10001010 10111011 10001100to the value 4.33.Also see the example:Reproducable on this site:http://binaryconvert.com/result_float.html?hexadecimal=408ABB8CIs this doable in FME? And how?Thanks!

3427
david_r
Celebrity
warrendev
Enthusiast
warrendevEnthusiast
asked in General
HTTPCaller Timing Out

I am making a call to a SOAP web service to retrieve a token and FME Desktop will timeout, but I am able to successfully retrieve the token in Postman and in Python using the requests module. Any idea as to what would be causing the issue?2020.2.0.0 (20201027 - Build 20787 - WIN64) FME Error: HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'Timeout was reached'HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set upHTTPCaller (HTTPFactory): No proxy settings have been entered.  If you require a proxy to access external URLs, please ensure the appropriate information has been enteredHere is the code in python that runs successfully:import requestsurl="https://ext.youraspire.com/AIS/WorkTickets.svc" headers = {'content-type': 'text/xml;charset=UTF-8', 'SOAPAction': 'http://ext.youraspire.com/AIS/WorkTickets/GetToken', 'Host': 'ext.youraspire.com', 'Content-Length': '404'}body = """    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/en

2990
nielsgerrits
VIP
clowncutie
Contributor
clowncutieContributor
asked in General
Add watermark to PDF

Hi, I made a super simple 3 pages "Lorem ipsum" file with docx and saved as pdf, I'm new to PDF in FME and wanted to test just to add a simple rotated text using point creator, text adder, pdf formatter, but how about the next step?? How do I write the result to a pdf? Tried connecting my reader and my created text to a new pdf but the content is white except for my creted text, but I want to keep the existing text and just add for example a transparent text and an image, but its it more complicated than I thought. Do I need spatial reader or non spatial? Im only interested in adding extra stuff to every page to an existing pdf with the PDFStyler, then writing it as an addition to an existing PDF. Most happy answer would be a template workspace with:-PDF READER-PDF WRITER-PDFStyler that you can connect to the writer or multiple even to add to existing pdf (since I could not even make a simple read write pdf copy in FME)   pdf:text: (no idea where the yellow stuff is or ca

550
debbiatsafe
Safer
M
morijlumos
asked in General
CSV with Geometry from Oracle to Geodatabase.

I have a CSV export from ORACLE with geometry in a format like POINT (-81.00893 33.9717480555556), POLYGON ((-84.1769359565167 34.0427328929524, -84.1767072908479 34.0427328929618, -84.1767072908479 34.0430401524308, -84.1769359565167 34.0430401524308) etc. I cannot figure out how to extract the geometry and create layers in a geodatabase. I tried a few ideas with GeometryExtractor, GeometryReplacer, etc but I haven't had any luck. I attached the CSV for reference.

300
M
J
jimq66
asked in General
How can I get a count of points that are on a line?

I have GIS point features that are on or along GIS line features. I need to get a count of how many point features are on any given line feature and attach that count as an attribute to the line. I also have separate inspection data as an access database that captures the equivalent of the point feature as a code. I need to get a count of the point codes associated with the given inspection to compare to the count of the GIS points and in turn determine if the inspection data needs to be reviewed.

1190
david_r
Celebrity
T
trialing
asked in General
How to optimise PostGIS DB Reader performance, currently I run out of memory.

Another learning FME question: I have a postGIS table with 1.6million records. I have 264 features from a lot of post process from another dataset. Each 264 features have been split to 4 extent coordinates. I need to understand the nearest neighbouring shape from the 1.6 million record PostGIS database (single table) for each 4 coordinates.  This means that FME Desktop attempts to cache the 1.6 million PostGIS records so it can then complete the nearest neighbour checks. I get 25% of the way through before I run out of memory and to be perfectly honest, I am slightly impressed my dinky laptop got this far. How would I go about changing this flow to increase performance?  Many thanks 

80
T
M
manumanul
asked in General
Aggregate table: Only keeping maximum values

I have a point feature containing different entries per point (multiple measurements on different heights), and i want to aggregate my attribute table in a way that only one entry per X,Y-point exist. The final entry should thereby only contain the maximum values of all measurements per points. I tried using the Aggregator tool, however, I was unable to keep the maximum values, since the only implemented functions seem to be average and sum. I think of using my own python script withih a PythonCaller, but it did not work either (I know it must work , but I am pretty new to both FME and Python and just did not succeed). Any help much appreciated!

1877
ebygomm
Influencer

Badge Winners

  • 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
  • Conversationalist
    aidsterhas earned the badge Conversationalist
Show all badges

Community Stats

31,790
Posts
120,750
Replies
39,403
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.