Best Answers

Hi,I would like to populate the "public.pdl_steg" table in PostgreSQL/PostGis with features from a "pdls" shapefile layer. public.pdl_steg includes triggers in some fields.The id_pdls field is of the serial type.The code_pdls field is unique.   The triggers work well in PostGis et QGIS. Shapefile “pdls” table:However, after several attempts, I was unable to add the features from the "pdls" layer to "public.pdl_steg". The execution does not emit any errors and nothing happens.Any help is welcome.

hello ,i would like to save geometric data into excel file then I read the excel file in arcmap ,It shows me the attribute tables and location of lines .How to achieve it ?fme 2021thanks in advance 

Hi,I am trying to use FME 2023 version to convert OBJ into Cesium 3DTiles.While the conversion is successful, I notice that it causes our application to becomes sluggish, and it also consumes alot more resources. The application I am using is Luciad (https://dev.luciad.com/) and the software vendor has given the following feedback after investigating the Cesium 3D Tiles data:1. The number of .b3dm tiles generated are too few, resulting in each .b3dm being to "heavy" for loading & rendering.2. No sufficient number of "level of details" To demostrate that, I created a small sample and uploaded to https://drive.google.com/file/d/1FYMHx977zB_NAJa74nqMfmLvlMqWKPog/view?usp=sharing.1. Large .b3dm files    a. The .obj that I convert to Cesium 3D Tiles has 330K triangles.    b. Only 2 .b3dm files were created. But it should have at least 33 .b3dm files (330K/10000) since I am using 10000 for Maximum Number of Triangle Faces Per Tile (see 3dtiles_setting.png)    c. It seems like the FME 3DT

Hello, I am trying to create a workbench that will read in all our add/delete tables from our SDE, do a count on the running total of records for each, and export a spreadsheet with the table name, and the counts in each,I’m using a SQL Creator and my SQL statement is something like SELECT COUNT(*) FROM <tablename>,and right now that's not returning me any value even though it was successful? Also, how would I go about coding out to add the next table in?would it be:SELECT COUNT(*) FROM <tablename>unionSELECT COUNT(*) FROM <tablename2>unionand so forth?also for background:We use Microsoft SQL Studio, and I chose the connection as a spatial server.Thanks for any help!

Hello, the problem is the following. I have a duplicateFilter attached to 2 different featuresTypes, which have an attribute in common. I would like, however, that when there are duplicates, the features of a certain type remain in the unique port. In other words: when there are duplicates, I always want the pair of the copy that goes to unique to be of a certain feature type, always the same, and to be able to control it. Any ideas? Thanks, Pol

I need some help with this problem below. As seen below the lines have diffrent attribute ID’s 1,2 and 3. The lines 1 and 3 are moving correctely as a offet 10 meter from their first location, as seen in the picture to the left. But line number 2 are not moving as an offset, as it is an exit ramp with different attributes than line 1 and 3. I want line number 2 to move with line 1 and 3, so they are connected in the same way as the right picture, meaning same direction and shape. I already have a dataset as the right version and my first thought is to create a point layer with start- and endpoints of each line and make them always connected as line 1 and 3 are moving. How should I solve this problem as easy as possible. I have a large roadmap of these lines and problems, so this is just an example.  

I created a few polygons  with topologybuilder and now i need to explode them in order to test some line on line with another feature.ive tried chopper which works greate except the fact that converts the arc in polygons to line and ruins everything. so how do i split these close polygons back to lines and arcs?ivre tried GeometryPartExtractor to filder out arc but the results are arcs and rest of the polygon insted of being a polyline without that part it convert it in cloed polygon 

I received a service bus connection string in the following format:Endpoint=sb://sb-sb-s-sbb-mastersupa.servicebus.windows.net/;SharedAccessKeyName=Andblablablab;SharedAccessKey=blablablablablablalbablablablabla+blablabla=;EntityPath=moreblablablablablatestBut it gives me an error in FME 2019,2020,2021Is says: Error: claim is empty or token is invalid.Should I enter the string in another format? Also: In 2022 and 2023 I get an error: No module named ‘uamqp’. Looks like this module is not available in this Python library set?

Hello,I want to generate an incrementation from the max value of a column in order to not have duplicate values. The _max value column is not recovered in the counter for the 50 duplicate features :  Any idea ? Thank you 

Attached are simple FME-Workspaces from version 2017 and FME-Form with GeometryPropertySetters and Aggregators and the xml outputs. The 2 workspaces are exactly the same.FME 2017 writes the aixm Marking Element Geometry as expected, but FME-Form does not - the MarkingElement Geometry Feature is missing (Workaround is to use XML-Templater).Any idea, is this a bug?

Hi, I have a text string that looks something like this…LOT 4-6 DP 287 SEC 2-3 SO 345152 I have a regex “(LOT \d+[\s?&-]\d+ DP \d+ ){1,}”  that grabs the LOT 4-6 DP 287 from the text line.How can I split the 4-6 into separate attributes so I end up with Lot 4 DP 287 Lot 5 DP 287 Lot 6 DP 287I could do it with a testfilter but there are unknown combinations. 1-12, 60-62, 78-82 etcAny help is greatly appreciated.Regards, Paul

Searched for possible solutions here, but nothing yet. Have : col0 col1 col2 col3 col4 Region A BU02851 BU02852 BU02853 BU02854 Region Value A 50 55 40 10 Region Value B 7 11 4 15 Region Value C 60 70 10 25  Need : Region A Region Value C       BU02851 60       BU02852 70       BU02853 10       BU02854 25        What steps do I need to take to get this done? Thanks in Advance ! 

Hey. Do you have any idea how to solve the sequential processing of input elements on HorizonAngleCalculator? If I have several elements on the input of the Horizontal Transformer, I need one element to be processed and then the next element to follow after that element is processed. After that, I would put a featureholder after the HorizontalAngleCalculator and it might work. I've tried testing the featureholder with counter and filtering features that have already been processed, but somehow I can't get it to work. Thank you very much

Hi Could anyone help please? I have created two connections to Microsoft SharePoint, one for SharePoingOnlineConnector and one for SharePoint List Reader/Writer in FME Form.When i use either after uploading to FME Flow i get this error from Flow when running a published Flow App but it seems to work when running directly from the Flow UI SharepointOnlineConnector: Connection 'xx SharePoint Files' does not exist. Check connection parameter and connection definitions in FME options and try again I have gone into the group settings and granted full control to every user group that can use the Flow App, we are using AD authentication and that appears to be working fine. If anyone can assist i would be very grateful Thanks Adrian

Hi.I have a file of text strings that have multiple ‘parts’ that I have split into a _list. Example text string... LOT 9 DP 19723 LOT 12 DP 384274 LOT 8 DP 30287 LOT 9 DP 2402 PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSEDUsing string searcher, I have formed a list of the formatted string to push into the list using regex: (LOT \d+ DP \d+){1,}The result is a list containing the:appellation:LOT 9 DP 19723 LOT 12 DP 384274 LOT 8 DP 30287 LOT 9 DP 2402 PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSED matches: LOT 9 DP 19723  LOT 12 DP 384274  LOT 8 DP 30287  LOT 9 DP 2402  What I want to be able to do is remove the matched part from appellation on the way through leaving me with both the matches as individual features, and a subset of appellation with the matches removed. The resultant appellation in this example would be: PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSED I would be very grateful for any help with this.Regards, Paul 

I have an FME workspace that sends me an email during certain error conditions. This works great on my remote laptop, but fails on my onsite desktop machine. The FME workspace needs to be run nightly on my desktop machine. This means that I won’t get the email (and won’t be notified of the error conditions). On my desktop machine, I get this error message: ERROR_DURING_PROCESSING<class 'requests.exceptions.SSLError'>: HTTPSConnectionPool(host='graph.microsoft.com', port=443): Max retries exceeded with url: /v1.0/me/sendMail (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)'))) The only difference I can think of is that my laptop use a VPN connection and my desktop machine is on the company network. I contacted someone in our IT department and they want to know the name of the certificate which I don’t know.Does anyone have ideas on how to resolve this? Thanks, Chuck

Hi Community,I have a workspace with some python in to create a container within a blob storage account (something the blob storage connector was not able to do). The problem i’m having is that as soon as i use the blob storage connector in my workspace the package is installed in C:\Users\%username%\AppData\Roaming\Safe Software\FME. This then seems to force FME to use this directory in my python caller. The problem is i’m using newer python packages where BlockBlobService no longer exists and is replaced by BlobServiceClient so they stop working despite being installed as per the instructions for installing python libraries. Does anyone have any suggestions? 

I am having trouble setting up an FME Flow Workspace App. We have setup our environment to have many users added to the “fmeguest” group and have them pretty much exclusively use Flow by accessing Workspace Apps. For a while now we have been using the “Requires Authentication” option on our flow apps with “fmeguest” as an Allowed User. However this appears to now not be working. Any time we add any additional allowed user (above the author of the app) and hit ok to host the app, those users are dropped. When we return to the edit screen only the app creator has access again. This means no additional users can gain access to the flow apps, which very much defeats the purpose of them.  Just wondering if anyone else has encountered this problem, might be a tricky one for people to replicate to help.  We are on FME Flow 2023.1.1.1 Any Ideas are welcome, fire them through and we will give them a go 😊  

Hi I have a very simple question but it seems i can’t do it . I just want to make a point from an excel list with x y coordinates, but not by writing it to a writer because I have to do a lot of other operations with it. I have already tried different things, I first used a coordinateSystemSetter and then a vertexCreator. But during further edits I always get rejected and my model crashes. It can't be that difficult :-)

WFS 2.0 services are available on the Geoportal Baden-Württemberg. It is not possible for me to view/download the contents of the objects (BP_Plan) with the WFS Reader using FME 2023.Does anyone have any idea what the problem might be?Example:https://geodienste.komm.one/ows/services/org.165.d5516855-2ef7-4512-92f7-68d208f6f722_wfs/org.165.15f5882e-891a-4ce4-b2fc-000a45978e11?SERVICE=WFS&Request=GetCapabilities

I am making a call to an API and getting a JSON in return. With the JSONFragmenter and it's flattening options, I can expose most of the attributes in the JSON into FME attributes, but I am getting stuck on a particular structure. Sometimes there's a little table within a single attribute in the JSON like so: "related_objects": [                    {                        "relation_name": "verbinding",                        "relation_id": 1,                        "objects": [                            "randomid1",                            "randomid2",                            "randomid3"                        ]                    }                ] This indicates objects that are related in a particular way to the object in my query. I would like to generate a list of all of the related objects (randomid1, randomid2 etc.). I want to use that  list in my FME flow. The number of related objects might be one, or a hundred, in this case it's three.How do I make FME turn that littl

Hi All,I have created a workflow that reads a few large GIS datasets in vector format across different areas. To avoid reading all the records in the dataset and reduce time I have used the FeatureReader transformer which is connected to the layers and an Area of Interest. The Spatial Filter option is ‘turned on’ as Boundary Boxes OGC-Intersect to read only those records within the Area of Interest. The problem is still takes ages to read,I have got a few FeatureReaders within the workflow and I was thinking to use only one FeatureReader (as all the data comes form the same GDB) to improve the performance, Any ideas to improve the performance of the workflow?

Our FME Server was patched and rebooted, which left it in a bad state. The automations and schedules kept triggering jobs but no jobs were running. It wasn’t noticed over the weekend and we now have over 160,000 queued jobs and I can’t get the FME server to respond (it hangs at the login screen, API calls just hang). I’ve restarted services, the machine etc etc. I think the issue is the fmejobrestore starts restoring all these jobs to the queue when I restart the fme server services. I’d like to cancel all the queued jobs in the back end database. Can I remove the records from the fme_jobs table? Will this cause any issues? Thank you!Kathy

Good evening at everyone.I have a shapefile of buildings in the reference system Gauss Boaga Italy Monte Mario 1 (EPSG:3003) [1]If I reproject these data in ETRS89 UTM 32N (EPSG:25832) using the proj4 library (with QGIS or PostGIS) and I obtain a very valid result [2], which overlaps with the orthophotos in coming from the WMS. [3]I tried to configure a custom SRID [4] by entering the 7 reprojection parameters used by the proj4 library contained in QGIS or PostGIS [5]I tried to reproject with FME using my custom srid, but the result is very different [6]. Is something wrong with the custom configuration [4] or fme  transformer [7]?Thank you!In the zipfile: [1] original.shp[2] reprojected_with_qgis.shp[4] MyCoordSysDefs.fme[6] reprojected_with_fme.shpother references:[3] http://pubblicazioni.provincia.fi.it/geoserver/wms?request=GetCapabilitieslayer=orto2016[5]"+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +u

Is it somehow possible to receive a connection from another party using OAuth2?Do I need to add a specific user to the user list? Do I need to create an application?Could it be done using a webhook or an automation? Or should i build a webhook or automation and use that as a trigger to connect to another location using OAuth2? The other party does not want to send data to my FME Server without using OAuth as a security measure.