Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
cnieman
Contributor
cniemanContributor
asked in General
How to read all shapefiles in a ZIP file regardless of how deep the directory structure

I would like to POST a zip file to a workspace in FME Server and read the shapefiles from it. The problem is that the shapefiles could be multiple directories deep. In workbench, I can use [**\\*.shp] as indicated here, but this is not retained on the FeatureReader dataset path when the zipfile is posted to the data streaming service in FME Server. Is there a way to achieve this?

1670
cnieman
Contributor
shomber2
Contributor
shomber2Contributor
asked in General
How to change file name of downloaded file.

I am currently working on a workflow that downloads a file from ArcGIS Online and I am then uploading the attachment to Cityworks via the API. The file is downloaded with a general name and I'd like to change the name of the file before passing to the API. I have done some digging on this forum and I am not seeing a way to dynamically change the file name based on other attributes in the middle of a workflow. Would I have to build a custom transformer to do this? Any ideas or examples appreciated, thanks!

1690
shomber2
Contributor
M
mikebilsland
asked in Transformers
Hi, I have a DFX file and would like to convert to an OBJ file, however it does not convert cleanly. Has anyone come across this and converted correctly. Many thanks

Hi, I have a DFX file and would like to convert to an OBJ file, however it does not convert cleanly. Has anyone come across this and converted correctly. Many thanks

80
natalieatsafe
Safer
J
jaimemayordomo
asked in Integration
Using HTTP caller, how can I automatically fill-in the upload body? I am able to post the any test I paste in the upload body field, but I would like to fill in automatically the text of the upload body, with the output of an attribute manager.

Using HTTP caller, how can I automatically fill-in the upload body? I am able to post the any test I paste in the upload body field, but I would like to fill in automatically the text of the upload body, with the output of an attribute manager.

300
J
fmejamesl
Contributor
fmejameslContributor
asked in Transformers
Is there a better way to do basic math? I'm trying to parse file names from an SFTP call.

I'm parsing data from an SFTP call to get the file name. I'm returning _list values that have all the FTP properties of each file. I use an AttributeCreator get the length of this string as an attribute (ListStringLength=69) --- @StringLength(@Value(_list))-rwxrwxrwx  1 user   278361 date 00137 0001539147T ABCDEFG1234567.jpg I'm also using the AttributeCreator to get the starting position of the file name based on the prefix as another attribute (StartingPosition=33) --- @FindString(@Value(_list),"00137 0001539147T")278361 Mar 21 09:49 00137 0001539147T ABCDEFG1234567.jpg From here, I tried to simply subtract. But that didn't work.@Value(ListStringLength)-@Value(StartingPosition) = a string value 69-33 So then I added an SQLExecuter and did the math in SQL and output the FileNameLength.select @Value(ListStringLength)-@Value(StartingPosition) as FileNameLength From here, I added an AttributeCreator to get the FileName. @Substring(@Value(_list),@Value(StartingPo

103
geomancer
Evangelist
hwilson
Contributor
hwilsonContributor
asked in General
Run multiple testers and update a field

Hello, I have a dataset in excel that I would like to simplify the data into a newly created status field. For example all records that are 1000 will be status A, all records that are 2000 will be status B, all records that are 3000 will be status C. I will then import the data into GIS to symbolize based on status. I am creating testers for each status type and then joining it all back together. I was wondering if there was a single transformer that I could put in all my criteria and have the status field updated. I think this should be fairly simple but not finding the right transformer. Thank you

110
hwilson
Contributor
K
kris_ab
asked in Transformers
Hi I have the intersection points in point feature. I want to have attribute field as the street address as 2 St/3 Ave. The street network has line features. is it possible to get this happened to point feature at intersection? thanks in advance.

Hi I have the intersection points in point feature. I want to have attribute field as the street address as 2 St/3 Ave. The street network has line features. is it possible to get this happened to point feature at intersection? thanks in advance.

60
K
J
jeaner
asked in General
Find non UID and nulls, calculate based on last highest UID in data and write to existing gdb.

I've looked all afternoon for the answer to this probably simple task. I am working with a feature class in a gdb. The feature class has a unique_id field that may may be populated with duplicate numbers or be null. I need to find all the dup ids or nulls, calculate them incrementally based on the last highest unique id while leaving the other records alone. I was able to put something together that seems to work when if I set the writer to overwrite existing gdb. Is there a way to do all of this and just update the existing gdb? I don't want to loose the other feature classes and tables in the gdb. I'm pretty new to FME!

40
J
wrijs
Contributor
wrijsContributor
asked in General
changes made to dgn file is not noticed by reader when running the workspace

I have a workspace which takes a dgn file(A) and matches it to another dgn file (B). dgn file (A) contains little changes everythime I have to run the workspace. These changes need to be braught to the second dgn file (B), and this workspace automatically (often succesfully) does that.  However, if I have run this workspace once, and then changed something to the first dgn (A), the reader will not automatically load the new data in dgn file (A).  I dont know how to fix this, obviously I dont want to delete the reader and put a new one back everytime a small change is made.  Is there anyway to make the reader completely reload the data everytime I run the workspace?

80
hkingsbury
Celebrity
F
fmesafejde
asked in General
Python Exception

We used to have the following 'Emailer' Transformer in our FME Desktop /Server 2021.2.2 and it worked fine: However after upgraded to 2022.2.3, we experienced the following Python Exception error for Emailer:Any idea how to fix that? Thanks.

540
F
reservoirdog
Supporter
reservoirdogSupporter
asked in Transformers
How to read Esri FileGDB without Feature Class "names" / schema-prefix

I have several Feature Classes in a FileGDB and would like to convert these into a Geopackage. Therefore I would like to remove/not read the different schema-names / Schema-prefixes.A Feature Class "WAS_LABEL/WAST_TEXT" would be read as "WAST_TEXT" without the schema-name/prefix.Is there an easy way to achieve that? The FeautureClass-Names in the geopackage need to be "flat" without schemanames...

63
M
A
add2116
asked in Transformers
Hello everyone, I am working on spatial data. The graph shows multiple lines outside the desired area. I used generalizer but did not work. I discovered that spike removal works perfectly, but numerous remnants are left. How should I remove it?

Here is an example: I want to remove the small dots inside that circle. Thank you.

60
M
pauldeq
Contributor
pauldeqContributor
asked in Transformers
SQL Creator is not Exposing the attributes when I click on "Populate from SQL Query..."

I am doing a simple SQL query that I created MS Sql Server. I pasted it into the SQL Creator and ran it, and it was successful. I then go to expose the attributes by populating them from the SQL Query, and nothing shows up. Below is my query. Can someone please tell me how to fix this. I have tried using the Delimiter statement at the top, but that doesn't work either. Here is the query: With AcscerRecdQry as (Select lpm.permit_no as PermitNumber, lpm.permit_id as PermitID, lpm.version as PermitVersion, gc.code_desc as PermitStatus, soclpm.soc_id as ScheduleID, soclpm.schedule_name as ScheduleName, (soclpm.ACSCERYearDue - 1) as ACSCERRptPeriod, soclpm.ACSCERYearDue, Case When (IsNull(soclpm.received_dttm,'') = '') Then 'No' Else 'Yes' End as ACSCERRecd, 'Permit Schedule Does Not Exist' as QA_Issue From nms.dbo.latest_permit_master lpm Left Outer Join (Select Distinct slpm.permit_

2200
kailinatsafe
Safer
mkastelijns
Contributor
mkastelijnsContributor
asked in General
We decided to install a newer version of Apache tomcat, because of issues with the current tomcat. We would like to know if one can safely use Tomcat version 9.0.68 with FME server 2021.1.

At our organization we have an extensive FME server installation with a lot of machines for the engines and cores. We have Apache tomcat 9.0.50 installed, but have a lot of issues with this version of tomcat in combination with fme server 2021.1. Our decision was to install a newer version, 9.0.68., recommended for fme server 2022.2. We succeeded to upgrade tomcat without deinstalling FME server. However we are interested if we can expect issues.with this version in the future. If you need more information please let me know.

1850
merlinegeorge
Safer
T
tammydovey
asked in General
Spatial Join: one to one

Hi,there are lots of qstns about one to many joins.I want to understand what transformer to use to achieve a one to one spatial join based on geometry? I have a line in GIS that I want to analyse to see if there a geometry join to a line in CAD. This works fine with the SpatialFilter if there is only one line. however when GIS and CAD has two lines in close proximity the SpatialFilter is creating a many to one join by joining the Two GIS lines to the same CAD line. How do I create the one to one join please? thanks in advance

590
M
riad.hamoudi
Contributor
riad.hamoudiContributor
asked in General
Merge more than 20 personnel geodatabases into a single one

I am currently working on a project where I need to combine more than 20 personnel geodatabases  into a single one. The geodatabases have the same table field structure and also have attachments and relationships classes. I am using FME to perform this operation.I have  difficulty in achieving this effectively. I have tried using the "Feautre Merge” and tool in FME, but it seems that this tool does not take attachments into account. Therefore, I am looking for an alternative solution to combine these geodatabases while retaining attachments.I am sure that there must be a solution to this, and I would like to know if anyone could help me find a suitable solution. If anyone has worked on a similar project or has in-depth knowledge of FME, I would be delighted to hear your advice and suggestions.  

800
M
J
jw4554
asked in Data
Can FME write arrays to a new PostGIS table?

Hello, I have a table which needs to be written to PostGIS. One of my dataset columns contains a list of buffer distances for example 300, 200, 100m. It would be ideal to write this as an array to PostGIS for example {300, 200, 100}.  If the table already exists with an array column in PostGIS, FME will update the array correctly. If the table doesn't exist I can't see how to set the column type as an array in FME. Is it possible? Thanks :)

1458
M
E
ewa
asked in General
Hi All, I would like to clip a line with another line. I need to clip my lines in the part overlapping another line and export it to a separate layer.

I need to clip the road with a bridge, and in the section of the road, where the road overlaps the bridge, change its attributes. Thanks in advance for your response

380
M
M
mahmood631
asked in General
Reading CSV file via directory path and FeatureReader - Get Duplicate records.

Hello everyone,  I used "featureReader" to read all CSV files from a specific directory via DirectoryPath and it works fine with me but I am surprised a little bit why I got duplicate data.  For example, if I have 3 files, it counts the read 9. What is the best way to ready all CSV files fast and quickly?  Do you advise to enable the cache files?  

1740
sigbono
Contributor
joy
Enthusiast
joyEnthusiast
asked in Transformers
Why are block unrotated when converted from dgn (Microstation) to dwg (Autocad)?

Hello everyone,I am trying to convert dgn (Microstation) to dwg (Autocad), but for some reason the blocks are in my dwg unrotated. In Microstation those are called cells. Does anyone know how I can get the cells rotated in the dwg file? The igds_rotation attribute does show the rotation values in case of Microstation (see below for some example values)and I read somewhere online that the attribute name that holds the rotation value in case of autocad was 50. I could be wrong though. In the output (dwg) the cells are unrotated. It might thus be due to the fact that I stored the rotation value for autocad under the wrong name. 

530
joy
Enthusiast
M
mlindsvo
asked in Data
Uploading to Azure storage under a new filename

I'm looking for a way to upload to an azure file storage with a new filename. I eventually want to expose an FME server app that will allow the user to upload any raster file, and then will upload that file to the Azure Storage and call a few REST APIs afterwards. I have a basic workbench working on my machine that can implement the workflow.  The issue is, we can't have any spaces or periods in the filenames in the Azure storage, but I want to allow the user to upload rasters without changing the name. I have not found a way to be able to rename the file before or during the upload. I have experimented with using a Feature writer transformer with the File Copy writer to create a temporary file then using the temp file path in the Azure File Storage Connector but I'm struggling to even rename copies there. I realize I could probably do hacky stuff like use a systemcaller to rename the file, but if I need to do that I'm not sure what the advantage of using FME is, since

530
M
crstnaiw
Contributor
crstnaiwContributor
asked in Integration
Can FME connect to Salesforce Platform Events?

In Salesforce, they have a feature called "Platform Events" where the fields are defined in Salesforce. Does FME have an existing connector or an app for this and can FME also publish changes to the "Platform Events"?Thank you

540
crstnaiw
Contributor
limo
Supporter
limoSupporter
asked in Transformers
How to drap 3D Cubes on a surface(tin)

Hi , we wanna create 3D extruded Polygons based on 2D polygons.As Input we have geojson with geometry type multipolygon. With the Surface Draper we can drap 2D Polygons on the Surface. So for all vertices I get a z-value. This is actually working. Then we extrude these 3D polygons with the Extruder! But I get a strange result in the inspector: For us it is important that we have a GeoJSON with extruded 3D Shapes which fit our tin! This is right now not the case our polygons are extruded with same height but they have differences in height to each other.  Is it possible to do this like this way:Or do I have to change the geometry type inside the format? Hope someone can help me? Thanks in advance! 

510
limo
Supporter
gis.analyst
Contributor
gis.analystContributor
asked in Transformers
Hi I want to reproject some dwg files from CSRS.UTM-17 to CSRS.MTM-10. However, when I use this projection the results are not correct. Could you please help me? attached are sample files and settings

I used several models. once without transformers and once with EsriReprojector, reprojector, and ...In all cases, the results are not in correct projection.even I force to create prj file and it has the correct projection but output dwg has UTM projection with wrong coordinates

950
gis.analyst
Contributor
A
alfred
asked in Transformers
rotate a Autocad block so that the attributes rotate about the insertion point of the block

HelloI have a DWG with blocks, when i use autocad_rotation the attributes are NOT rotated.Is it possible to roate also the attributes?Have a good day. 

1540
joy
Enthusiast

Badge Winners

  • Welcome Back
    dwade10has earned the badge Welcome Back
  • Integrate Data with the FME Platform Training
    johnrochehas earned the badge Integrate Data with the FME Platform Training
  • Student (Grey)
    westerbrinkhas earned the badge Student (Grey)
  • Teacher (Grey)
    westerbrinkhas earned the badge Teacher (Grey)
  • Student (Grey)
    artec186has earned the badge Student (Grey)
Show all badges

Community Stats

31,798
Posts
120,791
Replies
39,416
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.