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
rudy_v
Contributor
rudy_vContributor
asked in General
Microsoft System CLR for SQL Server 2012

Why is Microsoft System CLR for SQL Server 2012, still a requirement for FME to work with SQL Serve Spatial - We are on SQL Server 2019, and we have CLR 2019 and 2017 installed. Surely it should use the CLR that is installed. Without 2012 CLR installed - FME does not work. 

370
hkingsbury
Celebrity
philippeb
Enthusiast
philippebEnthusiast
asked in General
Generate Hexagonal Grid

Hi !Any idea how to create a 2D grid with hexagons instead of squares?I would like to reproduce this tool : https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/generatetesellation.htmI tried HexBinner transformer but it works with points. So when I try with a grid of points I created, there is some holes in my grid, as you can see... Thank you !

6700
caracadrian
Contributor
alc33
Contributor
alc33Contributor
asked in General
Hi ! I have a workspace with the version 2018. I would like to launch with workspacerunner with an other workspace with the version 2022. That doesn't works but maybe there is a way to make it works. Do you have an idea? Thanks !

Hi ! I have a workspace with the version 2018. I would like to launch with workspacerunner with an other workspace with the version 2022. That doesn't works but maybe there is a way to make it works. Do you have an idea? Thanks !

40
dustin
Influencer
benadei
Contributor
benadeiContributor
asked in General
I keep getting a type error in my Python caller

I keep getting an error in my Python caller transformer trying to convert dates in the format '%Y%m%d' to Python 'datetime.datetime' format. The transformer works for the first 236 features and generates the following error:Python Exception <TypeError>: strptime() argument 1 must be str, not NoneTraceback (most recent call last): File "<string>", line 38, in inputTypeError: strptime() argument 1 must be str, not NoneError encountered while calling method `input'I have examined the input data and nothing seems out of place or wrong with the data. I am not sure what's causing this.

4100
daveatsafe
Safer
so_much_more
Supporter
so_much_moreSupporter
asked in General
FeatureWriter have encoding issues, PostGIS writes does not

I am migrating data and are using a dynamic workflow. When I am using the PostGIS writer it run smoothly. But since i need post processing after writing to DB I sat up the FeatureWriter identical to the PG one. But the writer fail du some encoding issues on attributes with Nordic characters in their nameFeatureWriter (WriterFactory): POSTGIS writer: Internal Error: Failed to copy attribute 'FØRSTEDATAFANGSTDATO' to 'fã˜rstedatafangstdato'I cant see this being about case sensitivity since there is no issues using the regular postgis writer.Any ideas how this can be solved? Looks like a bug to me? 

160
saraatsafe
Safer
Z
zacharyp
asked in General
SAML Method of Authentication has gone from the SharePoint List Reader/Writer, in newer version of FME Desktop.

In FME Desktop 2019.2 b19825, the Microsoft SharePoint List Reader/Writer offers SAML as an authentication method for reading from our corporate SharePoint sites.   This method is now absent in 2021.2 b21784 and none of the other authentication methods seem to be working for me. Why was this option removed and is there a workaround to getting FME Desktop to connect to SharePoint sites using normal SPOL credentials.  

800
natalieatsafe
Safer
barrett_h
Contributor
barrett_hContributor
asked in General
Points created from NeighborFinder are not recognised as overlapping in the PointOnAreaOverlayer

Hi all, I have a very simple requirement, find the closest location on a polygon to some points then move the points to that location, this has been achieved using the NeighborFinder and VertexCreator transformers. Further on in the workspace I need to use a PointOnAreaOverlayer to transfer the polygon attributes to the point layer (I realise that this can be done in the NeighborFinder step but for the sake of this post, lets assume this is not possible). The issue I am coming up against is that even though the new location of the point is determined by the NeighborFinder, in some cases the point and area are not considered to be overlapping by the PointOnAreaOverlayer. This is my very simple demonstration workspace:The initial features do not overlap:Once run through the workspace they appear to overlap:However, according to the PointOnAreaOverlayer, one of the points does not overlap:The point that does not overlap (according to the PointOnAreaOverlayer) is the southern most point (

430
barrett_h
Contributor
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in General
FME/Arcmap licensing error

Hi,When I try to run a workspace on the FME server, I receive this error. On my machine, I have ArcMap and Pro installed with 64-bit background geoprocessing. I am also reading data from File Geodb using the Esri Geodatabase (File Geodb) readerArcGIS Enterprise 10.9.1 has been upgraded to ArcGIS Enterprise 11.0, and I am running FME Desktop 2022.0.1.0 and FME Server 2022.0.0.2. It is unclear why I am getting this error. Is it because we have upgraded ArcGIS Enterprise and are using FME Desktop 2022.0.1.0?  Thank you,

280
bill3648
Contributor
J
james007
asked in General
I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks

I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks

40
geomancer
Evangelist
jkr_wrk
Influencer
jkr_wrk
asked in General
XMLXQueryExtractor extract Attribute

I have the following XML:<?xml version="1.0" encoding="UTF-8"?><MyProblem> <Maat Name="MyName1" Description="LetsDoIt"> <Status_Maat Value="Open"/> </Maat> <Maat Name="MyName2"> <Status_Maat Value="Open"/> </Maat> <Procon Description="FinalCheck"/> <Precon Description="StopAndCheck"/> <Maat Name="MyName3" Description="LetsDoNothing"> <Status_Maat Value="Open"/> </Maat></MyProblem>I can extract the Maat with XMLXQueryExtrator by the following expression:/MyProblem/Maat Notepad++ XMLTools says the path to the Description is /MyProblem/Maat/@Description but this gives an error. And no results. What am I doing wrong?

392
jkr_wrk
Influencer
farfar
Contributor
farfarContributor
asked in General
How to read/write ODS files? Thanks

How to read/write ODS files? Thanks

1540
A
A
asadamjad
asked in General
JSon file

I'm having a bit of trouble understanding how to extract data from this JSON file my client sent me. It came from Insomnia and I'd be really grateful if anyone could lend me a hand with this.

250
virtualcitymatt
Celebrity
scootercat_nl
Contributor
scootercat_nlContributor
asked in General
No result from Testfilter means no process going through?

i use transformer Testfilter to filter type of mutation. Ultimately, I want to know how many mutations there are per type. For that I use StatisticsCalculator.This works fine, except when no value comes from TestFilter. How do I get the process to continue and StatisticsCalculator returns a value of 0?

260
tomfriedl
Contributor
hoskinmi
Contributor
hoskinmiContributor
asked in General
How can I buffer outside a polygon only?

I have have a set of polygons (actually they are buffers of a point) and I want to buffer these again to leave a ring - just keeping the buffer outside the original polygon. I can do this easily in arc/arcpy by using the buffer type "OUTSIDE_ONLY". How can I get the same effect using FME? I have created the buffers but when I use the clipper to clip one out of the other it clips all the overlapping buffers (which is what I expected) but I can't seem to figure out how to get the result I would like. I feel like I need to split each of the the buffer datasets so that it does the clip on each pair of polygons separately but - I'm new-ish to FME so.... Can't seem to find anything to help online either. This is what I have - the attribute managers are just to fill in an attribute so I can put the two buffers back together in one layer and be able to identify which polygon is which type.This is what I would like to end up with:Not this:

2350
hoskinmi
Contributor
bozboswell
Contributor
bozboswellContributor
asked in General
Summarize events from Google Calendar - combine data that is split across multiple lines into 1 line

I am trying to summarize Google Calendar events from the text output of Google Calendar. The export breaks the Description attribute across multiple lines (kinda like a permanent word wrap). Do you know of any way to walk through a text file and put relevant text back together (anti-word wrap)? I realize there is a Google Calendar reader but we are having some issues with connecting using 2FA. I was hoping the text output would allow me to get around fighting with the Google connection. For example, I want to eventually get the DESCRIPTION into 1 line: DESCRIPTION:Training Document Rollout\\n\\n-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-\\nJoin with Google Meet: https://meet.google.com/we-m2dbz-xvc\\nOr dial: (US) +1 443-23471-4874 PIN:8were6975#\\nMore phone numbers: https://tel.meet/wje-mebz-xvc?pin=2freaag3037362148&hs=7\\n\\nLearn more about Meet at: https://support.google.com/a/users/answer/912345620\\n\\nPlease do not edit this sect

181
david_r
Celebrity
checcosisani
Contributor
checcosisaniContributor
asked in General
How to read json

HiI need to extract from json the info reated to each run  "Name": "Run 1","Start Time UTC": "","Stop Time UTC": "","Duration (hh:mm:ss)": "",  I tried to use the json transformer but no success thx for help Francesco

20
redgeographics
Celebrity
fmejamesl
Contributor
fmejameslContributor
asked in General
Attribute getting set to null

I have a custom transformer. One of the incoming attribute values contains a comma separated list of strings. As soon as the record passes through any subsequent transformer, the value is set to null. Here is the incoming data with WOTEMPALTEIDs as the value that's getting dropped.After passing through any transformer (AttributeManager in this example), WOTEMPLATEIDs values are dropped to null. The other values are unchanged.Thanks 

740
fmejamesl
Contributor
malikusama95
malikusama95
asked in General
i want to create excel is group by complexFolder name same (complex Folder) value have each excel

i want to create excel is group by complexFolder name same (complex Folder) value have each excel

30
malikusama95
mhprawiro
Contributor
mhprawiroContributor
asked in General
Google BigQuery Authentication Return 401 disable client

Hi, It's been a while that I couldn't Add Web Connection for using GoogleBigQueryConnector. Previously it's working well, but after re-install my FME desktop, it's always return Error 401: disabled_client when I try to add web connection using my google account.Error 401: disabled_client Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In. Request DetailsThe content in this section has been provided by the app developer. This content has not been reviewed or verified by Google.Could some one help me what's wrong here? 

2760
crstnaiw
Contributor
jasonc
Contributor
jasoncContributor
asked in General
How to dissolve polygons based on an attribute where a dissolved record will include non touching polygons with the same attribute? Using Multi Polygon geometry

How to dissolve polygons based on an attribute where a dissolved record will include non touching polygons with the same attribute? Using Multi Polygon geometry

1640
jasonc
Contributor
jonvelco
Contributor
jonvelcoContributor
asked in General
FME Server can't open Oracle client libraries but Desktop can

On the FME Server VM I have setup, the 64 bit Oracle Instant Client isn't being recognized by FME Server. I have the PATH environmental variable set to the folder. I also installed Desktop on the same VM and it has no problem connecting to Oracle databases.  What else can I try? This is the error I get when running the workbench in Server:Oracle client libraries (e.g. oci.dll) could not be loaded. Ensure that the 64-bit client is installed and properly configured, and the PATH environment variable includes the file path to your Oracle client. Refer to https://community.safe.com/s/article/how-to-setup-an-oracle-instant-client-for-use-with for more informationThe Oracle Instant Client setup is the "Basic Package" Version 21.9.0.0.0 FME Server2022.2.4 Build 22792 - win64 FME Desktop2022.2.4.0 (20230303 - Build 22792 - WIN64)Database Edition

1970
jonvelco
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in General
How to Write features in a specific order / Hierarchy?

Hi Community, I'm working on a workflow that needs to write a final Feature class based on a particular hierarchy. The workflow includes a few 'AreaOnAreaOverlayer' steps + ListConcatenator to indicate which parcel overlaps which, below a screenshot with the desired hierarchy:1 - Most important parcels A2- Middle important parcels B3- Less important parcels C  I can't run dissolve + clip as need to keep the overlapping information to be 'listconcatenated' so decided to use a Sorter (alphabetical order) to obtain the desired order but isn't working 😞 as there's areas where the parcels C are on top of the parcels B. Below an example where the overlap in the middle between 2 parcels (B + C) should be assigned to B but for some reason is CThere must be a way to tell FME please write parcel A on top of parcels B and then parcels B on top of parcels C and parcels A on top parcels C. A>B>C Thanks a lot in advanced 🙂

2760
redgeographics
Celebrity
femo
Contributor
femoContributor
asked in General
Hi, i want to read a compressed file within a python caller. It works fine, as long as i reference to a *.gz file located in the file system of my pc.

 However, I would like to directly read the same file from a URL.Therefore, i have changed the published parameter accordingly (see screenshot attached). The following error messages is produced:Emptying factory pipelinehttps://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gzPython Exception <FileNotFoundError>: [Errno 2] No such file or directory: 'https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gz'Traceback (most recent call last): File "<string>", line 24, in input File "gzip.py", line 58, in open File "gzip.py", line 174, in __init__FileNotFoundError: [Errno 2] No such file or directory: 'https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gz'Error encountered while calling method `input'PythonCaller_3 (PythonFactory): PythonFactory failed to process featureAn error has occurred. Check the

210
femo
Contributor
james_c_452
Enthusiast
james_c_452Enthusiast
asked in General
Shapefile generated in FME doesn't work in lastools

Hi,Does anyone know why a shapefile generated in FME would not work in lastools? I am using lastools to clip a point cloud using a buffer from FME but it can't read the shapefile. I don't know why it is invalid, only that my command line has the following errorAny help would be appreciatedThanks

90
james_c_452
Enthusiast
galigis
Enthusiast
galigisEnthusiast
asked in General
PointOnAreaOverlayer Help - One Point shared between two polygons

Hi Community, Classic issue with the PointOnAreaOverlaye where I have got one location where the same centroid is shared between two parcels and want to bring the information from point to area. Attached two screenshots that explain the situation. In theory...by creating a list and exploding should work but doesn't give me what I want as the output contains 2 parcels overlaps where there're two points Example 1) I need to bring the assign the point info to each of the parcels. As you can notice the point on the left is shared between two parcels.Example 2) Also, I need to bring the assign the point info to each of the parcels. As you can notice the point on the right is shared between two parcels.I have tried to 'Generate List on output Area' and then explode but the 'element_index' and '_overlap' are different so can't use a tester to filter the list.I have also tried NeighborFinder to filter only those centroids at the middle of the parcel . Thanks

390
galigis
Enthusiast

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.