Skip to main content
  • EN

General

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

  • 4,033 Posts
  • 13,782 Replies
4033 Posts
K
kseadawy
asked in General
ESRI Geodatabase (ArcSDE Geodb) The Product License has not been initialized.

I made SDE connection through Arc Catalog to connect to geodatabase and when I used the reader ESRi geodatabase (Arc SDE), I chosed the created connection file of SDE.When I tried to select the tables, I got the error as in the below image.My Arc desktop is initialzed and the license server running.I installed also oracle client to make the connection file because DB in Oracle.

1588
rudy_v
Contributor
4 years ago
reidm35
reidm35
asked in General
Grid Locations for start and end of line segments

Hi there,I'm trying to get grid locations from a polygon fgdb feature class attribute for the the start and end of a fgdb line feature class. The attribute I need to put into the line data is a GRID ID. I thought about using a spatial relator or a lineonareaoverlayer, but I cannot figure out how to use either transformer and how to transfer the attribute over. I'm especially having problems with exposing elements and dealing with list attributes. I can add photos or attach the workspace if needed

2314
reidm35
4 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Weekly Quiz: Round 4 Answers and Results

Hi FME'ers,Here are the answers and results to yesterday's quiz. I heard that it was quite a hard one this week. Not my intention, but it's good to have a tough one now and then! It would be boring if we all got 6/6 every time.Answers1) A new transformer coming out in FME2019.2 will be the...RasterSharpenerLineSegmenterPointCloudColorSetterMinecraftServerConnectorRangeExploderIt's the RasterSharpener. FME2019.2 will be coming out VERY soon (either today or tomorrow) and will include not just this transformer, but also a RasterSegmenter and RasterRegisterer. So if you are into raster data, 2019.2 is worth looking out for.I also have a post tomorrow about a new parameter in the Tester (and some other) transformers, so watch out for that.As for the others:LineSegmenter: I made that one up, so who knows what it is supposed to be or might do!PointCloudColorSetter: Another one I made up. There's already a PCColorScaler, which is pretty much what a ColorSetter would do any

974
D
4 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Monday Quiz: Round 4

Hi FME'ers,Here's the FME Monday Quiz for this week. It covers new transformers, schedules, Twitter accounts, and sports. Give it a try and see how you do.https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizRemember, I'm going to call a winner after this week, and start the league table afresh next week. So it's your chance to top the table when it really matters!Mark

2711
mark2atsafe
Safer
5 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in General
Question of the Week: DateTimes in File Names (01112019)

Hello FME'ers and Happy November!There's a saying that "things always come in threes" and here's proof. This Question of the Week is not so much one question, as three instances of the same requirement: to put a datetime in a file name.Question of the WeekQ) I have a workspace that downloads files, renames them and stores them in a ZIP file. Said ZIP should contain the current date in its filename. Can this be done somehow?Asked in various forms, here, here, and here!A) Basically the user wants to add the current datetime to an output filename. The obvious use is to stop multiple runs overwriting the same file. I like this question because there are multiple places where this might be done: on a writer, in a transformer, or as the name of a log file. Let's take the writer scenario first.Writer TimestampsTo get a timestamp I obviously need to use either the DateTimeStamper transformer or the DateTimeNow() function. However, if I enter that function directly int

3340
mark2atsafe
Safer
5 years ago
fme_can_do_it
Supporter
fme_can_do_itSupporter
asked in General
Distance calculation between points datasets

I have CSV that contains Lat/long. i need to convert this into points using spatial reference WGS 1984. then i have to compare this point data with my building point layer. i need to calculate distance between the points in CSV and the building layer. Building layer has already this CSV data but the locations in CSV has been changed. I need to find the distance in feet.

501
danilo_fme
Evangelist
5 years ago
S
sajidworksgis
asked in General
HI,i am new to FME,i am trying to prepare the model of conversion of the CAD files into the geodatabase.Is there anybody who can help me in this regard.Please contact at sajid.works.gis@gmail.com

Error came when i am using textpromp extractor(geometry error) of one feature. Because of this i cant be able to proceed further.

61
redgeographics
Celebrity
5 years ago
jhawks
Contributor
jhawksContributor
asked in General
Write data to a new column in an Enterprise Geodatabase in Oracle:

If I create a new column in a feature class and want to write data to it, is is "Insert and Create as Needed" in the General Table Operations?

52
itay
Contributor
5 years ago
M
msrnivasan
asked in General
Want to migrate FME v2015.1 workbench to FME v2019

Have few queries before migrating FME Desktop and Server version 2015.1 to 20191. Whether OS Windows 2012 R2 will support FME Desktop and Server 2019?2. Does FME workbench older version 2015.1 will work on version 2019?3. Is ESRI ArcSDE 10.1 (.sde) file will connect through Direct Connection on FME Version 2019?4. Is it possible to save or connect ESRI ArcGIS 10.1 FGDB file through FME version 2019?Thanks in advance.

53
mark2atsafe
Safer
5 years ago
jhawks
Contributor
jhawksContributor
asked in General
Unable to flush the cursor for the feature class because the spatial index is too small.

Unable to flush the cursor for the feature class 'M_SDAT' because the spatial index is too small. Increase the spatial index on 'M_SDAT' and retry I have an old complicated workbench. It translates all of the NOAA Electronic Navigational Charts S-57 .000 files into Oracle for internal users and external arcgis server rest services. It's been running every Saturday on a schedule for years. lately it's been throwing the above error. I'm able to get past it and run the translation by disable that particular feature class. But every week it's breaking on a different one, so I need to find a real answer. FME Server 2019.0.0.1 Build 19246 - win64Oracle 12.1.0.2

728
steveatsafe
Safer
5 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Weekly Quiz: Round 3 Answers and Results

Hi FME'ers,Here are the answers and results to yesterday's quiz:Answers1) How many engines are permitted on a professional (4 core) FME Cloud instance?14816UnlimitedIt's actually unlimited! You can run as many engines as you want, on any FME Cloud machine. Check out the pricing page if you don't believe me!Of course, as in Jurassic Park, don't get so preoccupied with whether or not you could run a million engines, that you don't stop to think if you should! The architecture of the machine effectively limits how many engines are viable. But it also depends on the size of the jobs and what they are doing. Smaller jobs would allow for more engines, as would jobs that use less CPU time (I'm thinking calls to a database or web service).2) Humourous titles are a great draw to presentations at the World Tour and User Conference. All of these films have been referenced in an FME presentation, but which one occurs the most?Confessions of (a Dangerous Mind) (1 present

70
mark2atsafe
Safer
5 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Weekly Quiz: Round 3

Hi FME'ers,Here's this week's quiz. As always, I'll be back online with the answers tomorrow, and a list of top scores, so I'll see you then.Quiz: https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizApologies for not having a Question-of-the-Week last week. I'd meant to do one, but was out of the office unexpectedly. Sorry. But I'm already working on it for this week!Good luck with the quiz and see you tomorrow...Mark

61
mark2atsafe
Safer
5 years ago
K
kfarasan
asked in General
Workbench 2015 will open on FME Desktop 2019 version

I want to open version 2015 FMW workbench file in 2019 version. Is backward compatibility will support?

71
david_r
Influencer
5 years ago
S
san
asked in General
GML conversion not working properly in FME desktop 2019.

I'm trying to convert a gml file to cesium 3d tiles.I got the output but unable to view the content in cesium.Its zooming to wrong place.I inspected the data in FME data inspector i'm able to view in 2d properly but unable to view in 3d, i'm able to see just lines.I have attached the screenshots and gml file.What wrong i'm doing.How to resolve this.

76
S
5 years ago
dataninja
dataninja
asked in General
How to use FME to find mean & standard deviation?

Alteryx has a tool called smart tile and I am having trouble replicating it in FME.https://help.alteryx.com/2018.2/Tile.htmCan anyone give me some advice on how to replicate the tool in FME?

495
dataninja
5 years ago
A
aandronov
asked in General
Adding an Attribute for a Range of Records

Hi,I want to create a new attribute value(CoolAttribute) for every record falling within Green to Red range. Green and Red appear consistently in the spreadsheet and Green is always followed by Red. Please refer to the screenshot below. I would appreciate your help.Cheers.

142
A
5 years ago
V
vipulpatel78
asked in General
How to get Most recent file from FTP server/directory

Hello Friends, I have a requirement to load most recent ( latest file) from FTP server into a table in Oracle DB.e.g. the file name will be something like this "inbound_fdw_dom_20191003014842" which is ( filename_yyyymmddhhmmss) . The file will be in .csv format.my issue is, what to do in FME to get latest file. Since I am learning and new to FME tool, could some one show me step by step information or picture will help me a lot. Sorry, I may be asking too much detail but I am learning so need help here. Thank you in advance for your help. Thank you,Vpat

701
virtualcitymatt
Evangelist
5 years ago
N
nursufij
asked in General
Error while validate wms in fme inspector

Hi, I am not very familiar with fme. I want to serve tiff image through WMS by using FME Server. But i get this error when I want to validate the output by using fme inspector. I'm using the fme server 2019.1 and tested the output by using fme inspector 2013. Can someone explain me why this error occurred and how to solve it? Here also I attached the fmw file that I used which been downloaded from this fme community and the error that I get. Thank you in advance 

43
itay
Contributor
5 years ago
R
razamirzza
asked in General
Hi all, I want to create a shorter name of an attribute values for example attribute values name is building but i want when i type it in arcgis as build it should reflect as building in suggestion name. Can anyone help me that how i can do that in F

How to make a shorter name of a full name in FME as when i type the short the full name will come under suggestion

62
bruceharold
Contributor
5 years ago
blackheart
blackheart
asked in General
Google Sheet Columns not reading in Reader

i'm getting probelm i google sheet .. everything is OKay but when i connect the sheet some columns are coming and some are not showing in transfrmr pleae anyone can help me out

191
virtualcitymatt
Evangelist
5 years ago
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

132
itay
Contributor
5 years ago
dataninja
dataninja
asked in General
How to generate straight center line for a polygon?

This is my input geometry This is my desired output: I want to generate the red line.CenterlineReplacer does not do a good job btw. 

2355
mark2atsafe
Safer
5 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Weekly Quiz: Round 2

Hi FME'ers,Here's this week's quiz. As before, I'll be back online with the answers tomorrow, and a list of top scores, so I'll see you then.Quiz: https://demos-safe-software.fmecloud.com/fmeserver/apps/FMEQuizIt is still a bit experimental (my use of Server apps) so do let me know if it doesn't work for some reason (I do see a bit of an encoding issue with one question, but it should be OK).CheersMark

146
srg
5 years ago
rakeshreddy0996
rakeshreddy0996
asked in General
error text(2147483647) While writing Lines data

GEOPACKAGE writer: Creating layer 'roadnetwork_full' with geometry type 'wkb_unknown'GEOPACKAGE writer: Wrong field type for idGEOPACKAGE writer: Unable to create attribute 'id' of type 'text(2147483647)' on feature type 'roadnetwork_full'GEOPACKAGE Writer: In Feature Type 'roadnetwork_full', 'fme_table_handling' has invalid value 'CREATE_IF_MISSING'. Possible values include: 'CREATE_IF_MISSING', 'DROP_CREATE', 'USE_EXISTING'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...GEOPACKAGE writer: Committing transaction of 535 features to feature types 'roadnetwork'...

282
oscarwillems
Contributor
5 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in General
Question of the Week: Coordinate System Accuracy (18102019)

Hello FME'ers, I wanted to introduce another new item here, the Question of the Week. We get asked a lot of questions at Safe - whether in the community or via support - and I wanted to highlight some of the most interesting ones.Question of the WeekThis question concerns coordinate systems and came to us via Live-Chat.  Q) When reprojecting, does FME have any 'tolerance' in regards to errors that may be introduced? How accurate will a reprojection be?  A) This is a great question because nearly all of us use coordinate systems, and yet reprojection can be a bit of a mystery that we're intimidated by. Let me try and simplify the process.  A reprojection in FME is carried out using one of two operations.  1) The first operation is a mathematically exact method. Typically these are reprojections within the same datum. The only "errors" in there will be due to rounding when using 64-bit math (I've mentioned that sort of computing precision issue before) but i

111
itay
Contributor
5 years ago

Badge winners

Show all badges
30,029
Posts
Terms & ConditionsCookie settings