FME Form

Hi, I'm inefficient with CSS selector statements - having no HTML authoring background. I want the CSV download links at this site and only the csv download links:https://data.sandiego.gov/datasets/parking-citations/I can get all 'a' tags and the href references no problem but have to test the result ends with '.csv'. Can anyone give me the right selector syntax for the element I'm after? Thanks all.

Hello,​So I have a data, which is called "Amendment Date". The format is as followDD/MM/YYYY HH:MM:SS. ​I would like to make a checker to check if the input data are correct. I tried the attached steps and it seem ONLY works on correct order. If the data is wrong, it said ERRORS and cannot run the transformer. Would someone please guide me how to do valid the format. Thank you.

I have a .dgn that has a lot of 'blocks' that are made up by Smart Solids (they consist of only fme_lines as far as FME Desktop sees it) and they show up like thisOf all the other parts (Free Forms which are fme_areas) Im building with MeshBuilder and they show up just fine, but these parts are missing. I managed to separate these parts from the working ones because clearly I have to deal with these differently but I dont know how. SurfaceBuilder/SolidBuilder seems to just reject everything, only AreaBuilder (which if Im correct is not for 3D stuff?) outputs something but it is far from what I want, for example:For this input

How do I convert a date such as 12/31/1979 to Julian date in FME?

My reader contains two features: 1 line, 1 point.My output writer is set as Generic and with User Parameters to choose the output options. But the attributes/fields I pick are captured only in SHP/FGDB/KML but not Autocad Map 3D Object Data. Any clue how I can include the attributes I want in the autocad output?

Hi folks, For some unresolved reason, our ArcGIS Server 10.7.1 crashes intermittently. Like randomly after a week or a few weeks or month or two, it just crashes. When I check the Server logs for what appears around the crash timestamp, there are a number of SEVERE errors that follow the pattern of "Error performing query operation Wait time of the request to the service <SERVICE> has expired." It's a specific set of services, enterprise feature classes as their source, usually the same culprits appear in these error messages so I thought it might be associated with some web apps that may be experiencing strangely heavy use at sometimes outside of main business hours. I've already had Esri Tech Support investigate this but they couldn't figure out what's causing the issue either. But I recently changed the source of one of these services to point to a shapefile instead. At the next Server crash, this layer did not have its

I'm working with a client who has all their infrastructure based on IBM Cloud and they are looking at reading and writing files from IBM's version of S3. The docs say that they basically use a complete clone of S3 implementation (actually a copy of the boto3 library for access) so I'm wondering if FME has an OTB way to work with these kinds of buckets? Relevant docs here: https://cloud.ibm.com/docs/cloud-object-storage?topic=cloud-object-storage-getting-started-cloud-object-storage I've given it a shot trying the S3Connector but even when providing an alternate endpoint it still seems to fail to connect. I'm not sure if it's the way the transformer is implemented or if it is something I'm doing.

Hi,I have problem creating an excelfile in a script that I published in FME server. I get an outputfile with type "file" and not ".xlsx". I can use the file to drag and drop it to an empty excel sheet. However what I really want to do is to create an excelfile. I am using a published parameter in my writer that looks like this . Also please check my parameters for the excelwriter.Am i missing something important? The version on FME desktop: 2020.1.3.0The version on FME server: 2020.2.3

Hi All,I am working a project ,where client asked us to add suffix to a attribute value .This attribute value is not a Unique , in order to make it unique we have ad suffix values as shown below image , requesting you all to provide a solution ? to reach this requirement! (the suffix number should be 4 numbers)Thanks in advance.

291 / 5000  ÜbersetzungsergebnisseI'm looking for a transformer with which I can create a buffer around a line. This buffer should have a defined width. The line has z-coordinates.At the end I would like to continue using the buffer polygon that was created and the polygon should receive the z-coordinates of the line.  

I am currently using a ChangeDetector to determine which fields have been updated in two different databases. The change detector works as intended and creates a list of different fields have that have been updated. The problem I have is that all the updates need to be written to a database on a one-by-one basis and currently I cannot find a way of sorting the updates by the specific field that has been updated. The updated list created by the ChangeDetector has specific attributes called "attributeName" and "revisedValue". I want to use those two attributes to create a new single attribute which is named after "attributeName" and has the value from "revisedValue" that indicates to my database which field need to be updated and the value that has changed.

Hey community! how can I convert a point cloud in this sense? When I put my obj in Unity I have this problem....

Hi, the API comes back with the number of totalPages (say 10 pages), how can I loop the API call through all these pages (1,2,3...10) to get all data? Is there a tutorial I can refer? thanks, Song

Is it possible to transform .gdb files into .ifc files. If yes, what transformers do you use? Sincerely Thomas

I've got a 3D DGN of a bridge out of Bently. I'm following the instructions in the Creating FMEAR Datasets from 2D Cad models article. Since it's already a 3d model, I'm assuming that I dont need the extruder or offsetter. So it should just show up if I convert it, right? I do get a layer list and scale information in the app, but the surface dots disappear once it loads, and nothing else shows up.

This is an error I get when I try to refresh an existing layer in a feature service on ArcGIS Online. ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'Environmental_Inspections'. The error code from the server was '1000' and the message was: 'String or binary data would be truncated.The statement has been terminated.'Has anyone else run into this?

The work flow of this process is that there is an excel spreadsheet from another department that is updated with one new record everyday. This excel document is the source for another spreadsheet that we use in our department where there are formulas that update columns. What we are noticing is that when the workbench is run the next day it will not pull the new record automatically. If I open this excel spreadsheet and save it manually then the FME excel reader will pull the new record. What can I do to get the FME workbench to pull the new record?  Thank you, Laura

Hi, We have a very basic workflow where a user enters a value into a parameter, and we write that value to a CSV which is stored on a network share drive. We have an external facing website that we would like to have access to this CSV so that it can publish the latest value found in this CSV.  I am not a web developer, I am a GIS Guy, so I am a little out of my depth. Is there some way I can save this CSV on the FME server so that it is available via the Website to read?  I am unsure if that is the best way to explain it, sorry for the n00b terminology.

Whenever running a workspace the log start with pointing out how to run the workspace at the command-line. No doubt it works when I open the command-line and run the workspace.My issue though is that I have a little ui in C# where I do not call cmd.exe, but go with Process.Start() and start directly fme.exe.My approach works as well, however, it takes 4 minutes to run the workspace in cmd.exe and 30 minutes when calling directly fme.exe. Is there an explanation why it takes so much more time when calling fme.exe instead running it through cmd.exe?

So the problem is that I have a hard time to refresh my updated data. The 1st time I run the data is fine. When I tried to edit the source data and click "RUN" again, the data doesn't update the data. However, if I click view source data, it is the updated one. I tried "Reader => update feature types" and it doesn't work as well. I have to close the program and reopen the fmw file in order to get the newest version of data.  Is there any way that I can update the data inside the FME environment? Thank you very much. Zach

I have data for various sites and some sites have been digitised more than once and have overlapping polygons. However, these are not virtually identical polygons. They only partially overlap. I want to find the sites that have overlapping polygons. I tried using SpatialRelator with "Intersect", using the same data as both Requestor and Supplier but it picked up instances where one polygon was actually adjacent to another but probably just overlaps a tiny bit. This resulted in 3700 out of 3900 having more than 1 related candidate which doesn't really shortcut the process. "Contains" wouldn't work because not all overlapping polygons are completely contained.

Hello Sir/ Madam,​I am trying to check if the input "units" and within " floors". ​There are two floors and many units, which they both have "base level" attribute.​The following are what I would like to find out separately.​1) units that are completely outside of each floors2) units that touch the floor boundary yet part of the portion is outside the floors I am not sure how to do ​let FME know how to process each baselevel ( 4.53 and 10.3) in this case one by one. The attached documents are in shapefile. I also attached my fmw in here.​Could someone please tell me what I did wrong? Thank you in advance. 🙂 Zach

I have 1 table that has one column called mbipk with a number value and then another column called sales with a number in it. I want to run it against 16 other tables which also have that same mbipk column, I want it to match only the mbripk number and if that matches then I want it to inject a new column called sales_2 and put the sales number from the 1st table into sales_2 into table 2. Is this possible?

I had an issue with a workspace with a disabled junction. I then discovered that disabled junctions won't get grouped in the navigator as disabled transformers and disabled connections do. Is this on purpose or is this something that can be improved? I expected them in the "Disabled Transformers" group. The workaround is to search for "junction" in the workspace search, this will display all junctions and mark the disabled junctions grey. Tested in 2021.1.1.0 (20210730 - Build 21619 - WIN64)

Hi,I created an FME workbench which contains python script at FME shutdown. This python script uses Arcpy library to make database connection. The workbench execute successfully and insert the data in database when executed manually. However, the script fails when we publish the FME workbench in FME server. It shows transaction is successful with message as 'FAILURE'. The FME job fails to insert data in database. Please advice.