FME Form

Trying to convert data to XLS where each layer is a separate sheet. I was able to do this in FME desktop but unable as FME Form. Is there something special I need to do with FME Form?

I am importing a project into FME Form that contains two automations, associated workspaces, and the repository for the workspaces. The repository for the workspaces already exists in the FME Form environment I'm importing into and it has other unrelated workspaces in it. The Preview Import page states that I will overwrite the exisiting repository during import. What, exactly, does "overwrite" mean? I only want to add the two new workspaces to the existing repository. Is that what happens? Or does the import process completely replace the repository, wiping out any existing workspaces and keeping just the two new ones? Something else? I'm trying to figure out if I should include the repository during import or not. I can't find any documentation that provides an answer. If anyone has one or can point me in the right direction I would greatly appreciate it!

Hi All, I have put a workbench together to populate some GIS metadata but I need to have the <CreateTime> automatically populate every time I run the workbench, below an example of the XMLTemplater transformer settings:Currently the time if fixed as 00:00:000, How can I set it as variable parameter ? I have tried the ROOT Template Functions but didn't work. Any advise more than welcome :)Thanks 

Hi, I would like to read all the layers published to Esri Portal/Enterprise that are shared with particular group. I use Esri ArcGIS Portal Feature ServiceIn the Parameters I would like to change the Feature Service so instead of reading one layer will read all layers from that group; A9 WTC in this case

My configuration in the JSONTemplater looks like this:  {  "type": "Feature",  "geometry": {    "type": "Point",    "coordinates": [      fme:get-attribute("X"),      fme:get-attribute("Y")    ]  },  "properties": {  "33064" : fme:get-attribute("33064"),  "33085" : fme:get-attribute("33085"),  "33103" : fme:get-attribute("33103")  }} As result I get: { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ 7.61438690276304, 47.5603635244644 ] }, "properties" : { "33064" : "", "33085" : 94328460, "33103" : "2. von B Spezmast Nr.55" } } The numb

Hi;I created a very simplified version of my custom transformer.All it does is find the center point and define the layer name for the future dwg writer.Attached is a custom transformer and workbench example, where dwg writer creates a dwg file with point in the default layer that come from custom transformer.When I use the transformer in "linked" mode and start the entire workbench, I get an error.When I use it in "linked" mode but with the use of feature caching to the transformer, and then I only start the dwg writer with "run to this", then it's ok.When I use the transformer in "embedded" mode, everything works fine.The difference in the translation log is in line:"Using MultiWriter with keyword `PRIMARY_DEST' to output data (ID_ATTRIBUTE is `multi_writer_id')"in embedded mode and"Using MultiWriter with keyword `REDIRECTED_DEST' to output d

I have created a workspace which takes multiple zipfiles as a user parameter and reads them with a FeatureReader containing an Directory and File Pathnames Format. If I run this workspace in FME Desktop 2021.2 it works fine.My next step is publishing it to FME Server 2021.2 and starting it there.I add the same files to the user parameter and request the workspace to run.It starts like it should and gets the filenames as parameters but then it gets weird. FME Server seems not able to process the parameter it created itself.On the FeatureReader it gives an error which tells me the FeatureReader (QueryFactory): The clause '@EvaluateExpression(... is in correct.I asked several colleagues and searched the internet on this specific error but  I can't find anything that looks like this. So did anyone ever run into this error and does one know how to fix it? The complete error (without the file paths which are formatted like "D:

I have changed the project file extension to .zip and extracted the XML documents, but getting nowhere with Esri ArcGIS Layer Reader (safe.com) Have also tried pointing a regular xml reader at them. Any ideas?

Hello,Can I use the same FeatureWriter transformer to write lines and polygons into the same GDB? I know how to do it in a normal writer but can't get it to work with the FeatureWriter. Below an example of the workbench which filter the geometry by areas and lines and then go into two different ports in the transformer Below an example of the FeatureWriter settings where I have included two feature types (polygon and lines)  Do I need to set a Dynamic Schema Definition? I have tried that option with 'Schema From Schema Feature' option but failed, Any idea more than welcome, thanks! :)

Hello,I have a (tough) nut to crack.A TestFilter of a job, run by a WorkspaceRunner, receives data but does not copy them into his output.TestFilter_12_INPUT (TeeFactory): Cloned 2589 input feature(s) into 2589 output feature(s)TestFilter_12 (TestFactory): Tested 2589 input feature(s) -- 51 feature(s) passed and 2538 feature(s) failedTestFilter_12 LR valid Transformer Output Nuker (TeeFactory): Cloned 45 input feature(s) into 0 output feature(s)TestFilter_12 BT valid Transformer Output Nuker (TeeFactory): Cloned 6 input feature(s) into 0 output feature(s) The very same job, when run manually it gives this information : TestFilter_12 (TestFactory): Tested 2589 input feature(s) -- 51 feature(s) passed. I don't understand why the behavior changes according to the way of launching it. Someone has an idea ?  

Hi there, if I have a dynamic filename within a csv or feature writer, e.g. "@Value(LINK_DIRECTION)_@Value(SIMULATION)_@Value(TECHNOLOGY)_@Value(BAND)_@Value(CARRIER)_@Value(TYPE)_@Value(SERVER)-importfile" it takes about 25 seconds to write one million files. If I write simply to test.csv, it takes about 2 seconds.Both variants writes only one file. I tried also to group by within the featurewriter with option "Complete Groups when Group Changes". All records are within the same group.User Attribute Definition is in all cases set to "Automatic".What did I wrong? What's the best way to just write into a csv file, with various attributes in the filename?Thank you for any help!I'm using FME 2022.2

Or is there a certain way the csv needs to be structured in order to take on a new schema? Thank for your time.

Hello everyone! I have dataset with two entities - points with Z coordinates and quite complex multilines. Is there any way how to gain Z values from points to vertices of line? Points have the same XY as vertices of line. Sample below:I have tried the way with SurfaceDraper or with Chopper and PointOnPointOverlayer, but results were not as I expected. Thank You so much!Lubo

I using geometry validator to rectify the geometry errors . Input of the geometry validator is polygon data from PostGIS database and repaired geometry need to update in same table. While executing the FME it shows "Geometry type (Polygon) does not match column type (MultiPolygon)" . Please advise to clear this error.

If you execute the attached workspace... You get fme_text features with empty fme_text_string (but TextString has a value). Any suggestions? 

Hello. Could someone advise? I have an airport runway and for each runway I have a runway threshold coordinate - start and end. I also know the length and width of the runway between these runway thresholds. I would need to graphically create a polygon that will create the correct visualization for me based on these input attributes. The output format will be a shapefile. The dates of each runway are several times, because depending on the direction from which I land, I have the name of the runway. In reality, it is 2 points of each runway (start and end) and their one length and width. Thank you very much 

The goal is to make the shortest paths for the first salesman for first day of work, then the second salesman for the first day of work, then the third salesman for the first day of work, then move to the second day, and repeat.  Days = User Parameter on # of days to iterateSum_Total_Time= the work + travel time for the combine paths for that salesman for that day.Each salesman can work a maximum of 3 hours per day (total_time).I have calculated the work, travel, and combined time per path per salesman. Set Work_Date = todaySet total_time = 0Set Sum_Total_Time = 0Set day = 0If Day =< Days Then     For Salesman in Salesmen:     Set WorkDate = WorkDate + Day         If Sum_Total_Time =< 3               From_Node = Salesman_Location               TestFilter = Days_Since_Visited > = Target_Days_Since_Visited               Spatia

I need an FME .fmw file that will convert an Esri point shapefile into an AutoCAD DXF files that will take the 'POINT_ID' attribute value from the shapefile and place it as a text entity to the upper right of the converted DXF point

I need to make an inventory of the GIS data my organization has. As a first step, I need to make a list of the names of the Feature Classes in each of our File Geodatabases.  Is there a way to extract a list of the Feature Class names (not the attributes or schema) from a File Geodatabase(s) to Excel using FME?  I know how to do this in python in ArcGIS Pro, but given I am relatively new to FME, I thought I would try it in FME.

Hello , i would like to remove the arrow symbol from the lines how could I test in data which lines has arrow then remove it .as info :arrow symbol and line connects to has the same id FME 2021 

I have a file of polygons and need to generate a list of which are adjacent to each other. I tried the spatialrelator tool and selected the 'touch' parameter but that didn't work for me. I then read a few posts on this forum and decided to buffer those polygons (only 10 ft) and then run the AreaOnAreaOverlayer to generate a list of overlapping polygons. I selected the Merge Attributes option and the UID column within the transformer so that the output included the UID of the main polygon and the UID of each polygon that is adjacent/overlaps that polygon.  The tool works with one exception: the formatting of the merged UID column. It keeps adding brackets { } in the column name. I can't find a way to remove those from the default name value within the transformer itself. I can change the column name in my output file to remove them, but then the transformer will not allow me to manually connect the transformer column to the new name column in my output f

Hi, I have 2 sets of data one line and one point set. I have snapped the point set to my lines and aggregated them by their highway name. I need to remove the first and last point that falls on each highway. Unfortunately, this is where I come up short on ideas. I have tried using a Neighbor finder and snapping the last points to their closest neighbor, but as my road data overlaps, this causes an issue of points snapping to points on other roads.   Any recommendations would be appreciated.

I have two FME Flow servers and I'd like to be able to change this color to easily be able to tell them apart when I have multiple tabs open.

i need to extract the Geometry traits that are in the picture. any clue how?

Are there any specific coordinate strings or bounding boxes to be created for the ImageFetcher to understand where to fetch from a URL? I.e. I tried to fetch from a XYZ tile server and it works flawless in QGIS. The same URL doesn't work with the ImageFetcher for some reason.