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
andrew_patterso
Contributor
andrew_pattersoContributor
asked in General
Which version of ODBC Driver for SQL Server should FME2023.1 utilise?

I am in process of migrating FME to a new windows machine and to run in the latest version (FME 2023.1). I have found that the workbenches run faster in the version we have upgraded from (FME 2018.1) Checking the log files for some of the processes, the SQL creator processes take longer in FME2023.  FME 2023 takes 2:06 minutes to connect and run a query ODBC Driver 17 for SQL server installed on new machine Version 2017.1710.03.01 2023-07-27 12:10:05 Microsoft SQL Server Non-Spatial Reader: Trying to connect using Microsoft OLE DB Driver 19 for SQL Server... 2023-07-27 12:12:11| 105.0|103.3|INFORM|140521: Database read complete. Retrieved <default parameter> feature(s) FME2018 takes 38 seconds for the same query2023-07-28 02:17:26 |Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2012 Native Client... 2023-07-28 02:18:04| 40.7| 36.9|INFORM|Microsoft SQL Server Non-Spatial Reader: Database read complete. Retrieved 140521 feature(s) Note, I also tested th

6020
steveatsafe
Safer
jackyd
Supporter
jackydSupporter
asked in General
Connecting SDE with Windows Authentication

We are connecting to an SDE database via and SDE file in server, we would like to use Windows Authentication and the service account the server runs under. But when I load an SDE connection file with Windows Authentication selected it does not pick up the windows credtiasl of the service account. Error Message:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216118'. The error message from ArcObjects is: {Bad login user}Please ensure the connection parameters are correct (server=`egisdev-db.tnad.tasnetworks.com.au', instance=`sde:sqlserver:egisdev-db.tnad.tasnetworks.com.au', user=`', password=`***', database=`EGIS_UNMaster', version=`sde.DEFAULT') I have tried reading from the DB using a database connection set to Windows Authentication, but we need to to use SDE connection as these are esri geodatabases. Any thoughts?

2380
jackyd
Supporter
vlroyrenn
Enthusiast
vlroyrennEnthusiast
asked in General
Reading FME datetime attributes as a Python datetimes

One of the main pain points I've been having so far with using Python with FME is getting datetime attributes from features as datetimes in Python. FME datetimes normally have a sub-second precision of 7 digits, up to 9, but Python stops parsing after 6. "When used with the strptime() method, the %f directive accepts from one to six digits and zero pads on the right. %f is an extension to the set of format characters in the C standard (but implemented separately in datetime objects, and therefore always available)."        #        # Unzoned        #                a_timestamp = feature.getAttribute('a_timestamp')        print(repr(a_timestamp)) # '20230620161403.0020449'                # ValueError: unconverted data remains: 9        # (Python's strptime stops at 6 decimals)        # (This will randomly work once out of 10 because trailing zeroes are trimmed)        # datetime.strptime(a_timestamp, '%Y%m%d%H%M%S.%f')                # This shouldn't be that complicated!        # Also, 

3395
vlroyrenn
Enthusiast
qubbiewu
Contributor
qubbiewuContributor
asked in General
Add CityGML Attributes

Hello All, I'm working on a workbench to convert IFC to CityGML. Before writing out CityGML, I'm trying to add some CityGML attributes, e.g. class, function, usage, etc.. According the section "Setting CityGML attributes and properties in FME" from Writing CityGML from FME (safe.com), I used these two transfermors "AttributeCreator" and "GeometryPropertySetter" to add the attributes. However, the output CityGML cannot identify the attributes as the ones in CityGML schema. Foe example, I opened the CityGML with notepad, the attributes are look like this:Only "class" can be showed as "<bldg:class>", others are showed as "<gen:stringAttribute name="citygml_...">". What I want is this:May I know is this possible to do in FME Workbench? If so, how? Many thanks.PS. This is my version of FME Desktop. Regards,Qubbie

2440
qubbiewu
Contributor
D
douglasb
asked in General
Use NeighborFinder to find the Candidate that has an ID that is present in 2 possible columns in the Base dataset

I have two point datasets, GPoints (~100 points) and OPoints (~1000 points), and I want to find the nearest neighbor for each GPoints entry. However, the nearest neighbor from OPoints must have an ID that matches the values from 2 possible columns in GPoints. In this case the column names are id1 and id2. E.g.The first entry in GPoints has values of id1 = 9001 and id2 = 9005. Therefore the nearest neighbor from OPoints must have an id of 9001 or 9005 (whichever is closest to the entry in GPoints current being analyzed). In SQL this would be WHERE OPoints.id = GPoints.id1 OR OPoints.id = GPoints.id2.

80
D
J
jorgeherediasni
asked in General
Why are the log files just disappear when a workspace is being processed in the FME Server?

After it begins running, I have this message: Error: The log file for job ID "19099" does not exist.However, I can see it (only the job id and the workspace number) in the running jobs section.

1210
david_r
Celebrity
nicole.mcstay
Contributor
nicole.mcstayContributor
asked in General
Is there a way a writer can create a new file with a new name to reflect any updates instead of just overwriting the current one?

I have workspaces looking a data quality which are automated on fme server. I am looking to record the monthly number updates from the workspaces and was wondering is there a way a writer can create a new file with a new name (e.g jan 2023 or Feb 2023) instead of just overwriting the current one?

600
ctredinnick
Supporter
cfvonner
Supporter
cfvonnerSupporter
asked in General
Dasbhoard workspace JobHistoryStatisticsGathering.fmw Errors after upgrade to FME Server 2022.2.7

I recently upgraded from FME Server 2022.1.3 to 2022.2.7.  Since the upgrade, the JobHistoryStatisticsGathering.fmw workspace (which runs on a daily schedule as part of the built-in FME Server Dashboards) is failing.  The error message is:+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `JobHistoryReader_LoopHere'Attribute(32 bit integer)      : `Loop to JobHistoryReader_LoopHere1691186519 Input Splitter.BranchingFactory.Count' has value `1'Attribute(string: UTF-8)       : `_min_job_age' has value `20230803000000'Attribute(64 bit integer)      : `_offset' has value `0'Attribute(string: windows-1252): `fme_feature_type' has value `Creator'Attribute(string: windows-1252): `fme_geometry' has value `fme_undefined'Attribute(string: windows-1252): `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENullCoordinate Dimension: 2===========================================================================Loop to JobHistoryReader_LoopHer

620
virtualcitymatt
Celebrity
barrett_h
Contributor
barrett_hContributor
asked in General
Preserve attribute order from FeatureReader Generic port

Hi all, I'm wondering if it is possible to preserve the order of (unexposed) attributes when they come out of the Generic port of a FeatureReader. The attributes are coming out ordered alphabetically, I want them to remain in the order they appear in the schema. My process involves a dynamic FeatureReader to grab data records, a SchemaMapper to map (some) attributes to new names, a SchemaScanner to determine the new schema and a dynamic writer to write features out in the new schema. The problem I have is that the new schema is coming out with attributes in alphabetical order, rather than in the original order (with the old attributes mapped to their new names). Is it possible to preserve the attribute order from the Generic port of a FeatureReader? Thanks!

950
virtualcitymatt
Celebrity
A
alex_rump
asked in General
Problems reading an XML file in FME Workbench

I am right now struggling to understand this issue. I have read XML several time with FME several times and never encountered this problem. I have an XML file that just lists a couple of airports with some basic information. The xml file looks like this: I read it like this: But when I read it in, this is what I get out of it: What is going wrong here?

960
thijsknapen
Contributor
asmith
Contributor
asmithContributor
asked in General
ArcSDE Querier Deprecated - what to use in its place

Hi, we have several workbenches deployed to FME Server that use the ArcSDE Queirier, which is deprecated. It was reading data from an .sde and deleting the data based on a WHERE clause, and the translation was continued on the output ports of the transformer. What is a transformer that I can use in its place that meets the above requirements?

110
asmith
Contributor
datablue
Contributor
datablueContributor
asked in General
Version number in window title

I'm using FME Workbench 2022.2.24. In the window title and startup screen, it shows Workbench 2022.2, not the full version 2022.2.24. (I also have Workbench 2022.2 installed so this is confusing.) I would prefer seeing the full version number in both of these places. I haven't starting using FME Form 2023.x yet. Does anyone know if the behavior is the same?Should I post this as an Idea? It seems like a vey minor issue.

90
datablue
Contributor
garbadek
Contributor
garbadekContributor
asked in General
Set a single variable value and use it as input into a transformer

I have a database table that contains many attributes, one of which is controlled by a domain of acceptable values. I have a list containing a unique list of these valueI want to step through this list and each time through the loop select just the records from the table that would be selected if the unique value were inserted into in query:SELECT * FROM Table WHERE AttribInQuestion = WhateverColorFor instance, "Red" the first time through the loop would return:I've setup my Reader to read the SQL table I want to query, generated a List of my unique values, and created a TestFilter. The TestFilter works if I just type 'Red' into it, but I cannot figure out how to feed the filter a variable to save my life. I'm not asking about the looping (I've created a custom transformer for that), what I'm asking about is how to insert the 'Red' value into my filter using a variable? Thank you for any help you can provide. K

2680
garbadek
Contributor
J
jeaner
asked in General
Changedetector info

Can anyone suggest a really good changedetector tutorial or documentation? I'm having difficulties understanding the output where a change in attributes and/or geometry is found. I can't tell which attributes changed (before and after) and I'd like to see exactly where the geometry change is instead of only seeing which features have changed. Hope that makes sense. I'm still learning.

830
daveatsafe
Safer
thijsknapen
Contributor
thijsknapenContributor
asked in General
How to filter attribute on Bytes vs String Data type

Say I have the following data;for which I can see the following information in the Feature Information window;feature 1; text (bytes): 48656C6C6Ffeature 2; text (string: UTF-8): WorldIs there a way that I can filter the features on the basis of the indicated data type (i.e. 'bytes' vs 'string (UTF-8)'?

6610
thijsknapen
Contributor
F
fredaster
asked in General
Hi Superfluous decimals are added to certain numbers already containing decimals, but not on whole numbers. Sometimes the decimal already present is reduced. Can you help me so that I suggest a possible solution?

Examples:10 > 105.1 > 5.0999999046325610.1 > 10.10000038146972720.1 > 20.10000038146972717.6 > 17.60000038146972720.3 > 20.2999992370605478.4 > 8.3999996185302735.3 > 5.30000019073486207.97 > 207.97000122070312

72
geomancer
Evangelist
edward_skanska
Participant
edward_skanskaParticipant
asked in General
I am getting this error when trying to connect to sharepoint via a reader

Hi there I am trying to connect a reader to sharepoint to read some information in. When I press authenticate this is the error that I get. I was wondering if anyone knew how to fix this?  All the best-Ed

960
braggken
Supporter
nitinshahane
Contributor
nitinshahaneContributor
asked in General
Can one execute Data Reviewer Checks using FME Workbench?

Either directly or using Python?

510
virtualcitymatt
Celebrity
T
tbaving
asked in General
Undefined macro `UNIT' dereferenced in file

Hi guys, i'm having an issue when i run my workspacerunner. Undefined macro `UNIT' dereferenced in file `G:\\wb-xlate-1690810120428_4936' I't s workbench build in an older version (2021) of FME. And now i want to run it in 2022 FME version. But it keeps saying that error. I also tried to create an new workbench, with new readers.....but it won't work. What I am doing wrong? :(

3330
virtualcitymatt
Celebrity
dustin
Influencer
dustinInfluencer
asked in General
Dynamic listing of parameter names

One thing I prefer to do when building a new FME tool is to log the input parameters in a startup python script in order to facilitate debugging when things go wrong. A sample of the code I use is below.import fmeobjects fmeobjects.FMELogFile().logMessageString("Input parameter 1: ") + FME_MacroValues["parameter1"], fmeobjects.FME_INFORM)fmeobjects.FMELogFile().logMessageString("Input parameter 2: ") + FME_MacroValues["parameter2"], fmeobjects.FME_INFORM)This has worked great for a long time, however it's cumbersome because I need to manually enter the names of the parameters. I'm curious if there is a method for returning the names of parameters dynamically in the startup python script, and then loop through them to include in the log file. If this is possible, I could keep my startup script the same between all tools and simply copy it into new tools without having to modify. 

272
dustin
Influencer
R
rdoliya28
asked in General
How to get licence

How to get home licence in fme 2023 version

3670
saraatsafe
Safer
A
asadamjad
asked in General
Multi rows in One single row

i have multi rows coming from the source and I want all that rows in one single row and layout same as I mention below Data Source coming like thisI want Output like this in one single Row and the same layout

90
ebygomm
Influencer
dannymeus
Contributor
dannymeusContributor
asked in General
Advanced Feature Type Parameters of the wrtiter in FME server are different then the upladed workbench writer table genaral settings.

When viewing (in FME server) my workbench that I uploaded tot FME server I see different Advanced Feature Type Parameters settings then in my Workbench on FME desktop. In my workbench the settings of my writer are 'insert, drop and create' after I upload the same workbench to FME server the settings in server seems to be 'insert, create if needed'.Why is that? I do not expect the settings change while uploading tot FME server. If I run the workbench from server the outcome is that the writer used the 'Drop and Create' and not the 'create if neded'...this behavior is confusing settings in my Workbench on desktop: the settings in FME server of the same workbench after uploading to server:

150
E
L
leif
asked in General
DJI metadata from images

We have photos in jpg format that were taken with a DJI drone. Usually all EXIF data are easily accessible using the JPEG reader, but not the DJI custom metadata. We need to access the data that shows up when opening the image in a text editor: I tried reading the files with a text reader, but that gives several thousand lines of text and no way of seeing which line of text is connected to which image. This should be a common problem for everyone with a DJI drone? Any suggestions for now and maybe a DJI photo reader or DJI EXIF reader in the future?

4720
jovitaatsafe
Safer
aaronp_osni
Contributor
aaronp_osniContributor
asked in General
How to process feature types one at a time for LAS files stored in a zipped folder (that contains many many zips!!)

Hi folks, I have LAS files that are in zipped and stored in a folder. There are 16 LAS files to each zip. Furthermore there are about 100 zips in the folder I'm accessing the data from! The zip files are about 2.5GB on average and I would like to process each zip at a time (sheet1.zip, sheet2.zip etc). I'm adding height attribution to building polygons using a clipper which is a blocking transformer, then the point cloud statistics calculator. I can use the Directory reader to produce a list of zipped files and feed these into a Feature Reader, then use a clipper to clip the LAS data to the building polygons. However the clipper is a blocking transformer which will wait for the FeatureReader to finish. Ideally I want one building polygon dataset for each zip (sheet1.shp, sheet2.shp etc). I need to somehow loop back to the start of my workspace and start again with the next file on the list produced by the directory reader. Anyone have any ideas?

280
daveatsafe
Safer

Badge Winners

Show all badges

Community Stats

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