A space to discuss FME Form
Recently active
In SharePoint you have the ability to add file attachments to records in a List object, can FME access these at all? I've tried the FME List Reader, which just gives a Yes/No field on if an attachment is present, and the SharePointOnlineConnector, but I can't seem to get it to view List objects at all.
Thus, the work of each work area is reported dynamically with each work time. For example, work was done on the plots layer on 1000 plots, 800 were updated and 200 were deleted in Excel form.
The data I am working is real time vehicle AVL GPS data that is dumped into a Feature Class using ArcGIS GeoEvent Server. The Point Feature Class has 104 records. My objective is to have my workspace act as a "listener" and send me an email every day M-F @ 10a letting me know that GeoEvent Server is reading these records. Of the 104 records (more records are added each month, so 104 is not static), there are 17 that are not the current date so they are routed to Failed in the Tester. There will always be records in this data that are not the current date. My question relates to the Tester, the way I have my workspace set up now, is if there are no records in Passed and all 104 records are routed to Failed, I will not get an email. Is there another transformer that needs to be added or maybe a parameter change in one of the existing transformers in my workspace? I want to also get an email if no records are routed to Passed, is this possible?
We used an XMLTemplater (2022.2) to generate an xml message using Excel file input with some optional columns.The XML template contains some if structures like this : { if (fme:has-attribute("STATUS")) then <Info> <keyName>STATUS</keyName> <value>{fme:get-attribute("STATUS")}</value> </Info> else() }The output xml is correct, but contains empty lines for every missing column, which we want to avoid.Leaving out the else() clause is not allowed as it results in a parsing error.How can we avoid those empty lines in the output xml ?
Is there a way to remove an existing Workspace Parameter from the FME Server Job Submitter?
This is the original uniquevalue Data with the number of existing features. 1140 Metadata.Worksets203 Metadata.ViewInformation182 Metadata.FamilyInformation105 Metadata.MaterialInformation20 Electrical.CableTrays16 Electrical.CableTrayFittings8 Metadata.PhaseFilters7 Metadata.LevelInformation6 Metadata.StyleInformation5 Metadata.LinkInformation4 Metadata.PhaseGraphicOverrides2 Metadata.ProjectPhases2 SitePoints1 Architectural.Railings1 Metadata.FileInformation in Tester transformer I used (Architectural.Railings / Electrical.CableTrayFittings / Electrical.CableTrays) The Original coordiante system was : XY-MMI used CoordinateSystemSetter and set CRSM.MTM-10 and then chang it to EPSG:3857For the writer I used I3S with i3s_3d_object Geometry
It looks like it displays the correct value but for some reason when you click on it or look in the "Feature Information" it looks like it's the truncated version of my string. When I try to preform other operations it'll use that truncated version too which sucks.
Hello FME Experts! I have been struggling with this for several weeks and I'm hoping someone may have some insight. I have a set of data that contains buildings that were manually digitized from roofline data. From this set, I have scaled the polgyons based on the type of roofline (scaling factors predetermined). This resulted in some properties with multiple roofline types to separate from each other. Think of a home with some steep and less steep rooflines - the scaling was done on each polygon. In addition, I used @Takashi Iijima 's workbench and modified it slightly to right angle polygons where possible. Now, I have an issue because I have polygons that should be adjacent (have shared boundaries) but because of the scaling, they are no longer attached (and because these were manually digitized, there were previous gaps in the data). I would like to physically MOVE the polygons to allow them to have a shared boundary without changing the shape (much). I tried using a c
Hi, I have compress a text with AttributeCompressor and stored it in an XML file. The text should be a password, so I don't want to store it as plain text. Then, I read the XML file and try to decompress the password with AttrributeDecompressor. But I only get this:2023-12-15 14:31:40| 0.6| 0.0|ERROR |@CompressAttributes: The 'Compressed-table.Compressed.password' attribute could not be decompressedBy the moment, I'm only compressing, not enconding. But I cannot make it work.I'm using FME Desktop 2022. I'm attaching both workbenches, (compress and decompress), the xml written by the first and readed by the second, and the logs of my execution.Thank you for your help.Best regards.
Hi, I have a polygon feature class, and want to process each polygon one by one, sending it to a fme flow job submitter. I tried writing out each polygon as a shape, and process then as a path file *.shp, but there must be a better way. Rudy
buffer transformer
Hi all, I need to extract the Hex Code Point of multiple letters using TextEncoder.However, the transformer fails to encode Roman numbers and some special characters. You can see in the below screenshot that it successfully encodes Bengali letters and some special characters, but not the others. Anyone has an idea how to solve it or any workarounds? Thanks!
I'm trying to write ~20m records to a Geopackage format file. If I remove all but a unique identifier column the output is created and FME runs correctly. If I try adding the original columns the process fails with the following errors. What can I do to fix this? 2024-01-04 10:57:31| 1.8| 0.0|ERROR |OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "Table1" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geom" POLYGON, "Toid" TEXT(20), "Version" MEDIUMINT, "VerDate" DATETIME, "FeatCode" MEDIUMINT, "Theme" TEXT(80), "CalcArea" REAL, "Change" TEXT(80), "DescGroup" TEXT(150), "DescTerm" TEXT(150), "Make" TEXT(20), "PhysLevel" MEDIUMINT, "PhysPres" TEXT(20), "Broken" SMALLINT, "LoadDate" DATETIME, "OBJECTID" MEDIUMINT, "OSMMSTYLE_NAME" TEXT(70), "Style_Code" SMALLINT, "SHAPE_Length
Hi guys,im using a csv file (with sde feature class names and etc.) as initiator to read various feature classes from a Esri sde database.however i also need to setup a spatial filter on this feature reader to limit the number of record being read. is there a way I can get this setup? I tried add another initiator into same feature reader transformer but seems this is not working.. Thanks guys!
I am trying to generate a point coordinate at the midpoint of Arcs. These Arcs have a very large radius and a tiny sweep, so they look like lines, but they are parts of a larger Arc. Whether I try the arc.GetMidPoint() method, or use Intersector with a crossing line, the point is always off. When I run the features through the SpatialRelator, it returns 0 _related_suppliers. It looks fine at first glance, but zooming in reveals that the intersection point really is NOT intersecting. My hunch is that this is due to the Point being calculated as a float. When using the Intersector or PointOnLineOverlayer, it actually changes the shape of the Arc! Here are some pics to illustrate:Midpoint of Arc at a distance Intersection point at a distance."Intersected" Point from Intersector lines (purple), with actual Arc (grey) close up. It intersects with the Intersector-created Arc, but not with the input Arc:Here is what I am running the features through to verify. Note: If I
I have a linear network that I have processed with the TopologyBuilder. I have a second linear network that I defines the from-to lines for the ShortestPathFinder. My concern is that the polylines in the two linear networks are segmented differently, for example, the Topology Edges are segmented at intersections and the From-To lines are segmented at mile markers. Is it necessary that the segmentation of the two networks aligns or just that the From-To vertices correspond to points on the Topology_Edges?
Hi, I have Civil 3D AutoCAD model with XRef attached. I cannot find the way to read the XRef layes as autocad_entity=autocad_xref. The only place that tells me that is an xfer is stored in the autcad_layer as apart from the layer name has the name of other model. What am I doing wrong?
Hello All, Currently I'm converting CityGML 2.0 from IFC4. The IFC file is a building model. So normally the exported CityGML feature types should be under Building module, which are named with "bldg" as the namespace prefix, e.g. bldg:Building, bldg:BuildingInstallation, bldg:WallSurface, etc. However, I found some feature types of the exported CityGML were assigned to Bridge module. Although I can turn on "Add XML Namespace Prefix to Feature Types" (found in the parameters of CityGML Writer), and make the feature types "brid:Door"/"brid:Window" to "bldg:Door"/"bldg:Window". I'm just wondering why the feature types "Door" and "Window" will be assigned to Bridge module by default. Or is there any mechanism to decide which module will be assigned to? Thanks in advance.Regards,Qubbie
Hi all,Please help! From January to April 2023 I worked through most of the FME Desktop/Form Advanced and Server/Flow advanced course. Now, December 2023, it seems my account and the progress is lost. All the badges I gained etc. In addition, some of the trailmixes I followed seem to not exist anymore. Anyone had a similar experience? Or know how this could be solved. Kind regards,Peter Goedbloed
Is there any easy way to add a date stamp to output file names when using the FeatureWriter? I am outputting Excel files that have multiple tabs with multiple separate inputs, from multiple data sources. The only way I could figure out how to do this without the FeatureWriter splitting up the different feature types into separate files is to add the DateTimeStamper to each data source, make sure it is kept all through the Workspace, and then take off the _timestamp attribute from each Feature Type in the Attribute list on the FeatureWriter. What a pain! Surely there is a better way? I tried to create a User Parameter, but it did not work. Any hints on this? Thanks, -L
Hi, I will create a military grid (10m precision) for an area. I have seen that there are some transformers in fme. I think the "MGRSGRIDGenerator" Trasformer is what I need. As input any 2d polygon feature is allowed. I runs successfully but does not generate any output! Does anyone have experience with this trasformer?
Hi!I am trying to get data (exchange rates) via a Rest API. I am a very beginner in using Rest API:s.By now, I start with a creator and connect than the HTTP Caller. However, I have difficulties to set up the HTTP Caller and get a connection.I use the following url: https://api.riksbank.se/swea/v1/Observations/SEKEURPMI/2022-01-01/2022-12-31 HTTP/1.1 The API needs a so called Ocp-Apim-Subscription-Key. It contains of 32 numbers and letters.I guess this should be defined in the header, but how would I do this in FME? There is no such parameter available, is it?To access the API portal username and password are required. Do I have to use this username and password in the "Use Authentication" section or does it refere to the username and password of the API itself? Thank you so much in advance.
Hello! I am having trouble getting the ProjectWiseWGSConnector working on FME Form 2023.0.2. I have a dedicated service account (SVC) account that can access two projects using ProjectWise Explorer. I am connecting with a username and password, not with Bentley IMS. When I use the same login and password in FME Form, I cannot access those projects. FME lists a series of folders that I have not seen before. I have attached a screen grab of the list of folders, ProjectWise API version, and ProjectWise connection configuration.
When I try to import Revit file to File geodatabase i face with the following error. An error occurred while attempting to create the feature class 'Structural_StructuralFraming'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column. [Structural_StructuralFraming]} my version of FME is 2023.1I did previously import Revit files in geodatabase without any error in previous version of FME.
I have a shape file containing for each 100m a line segment representing a 100m segment of a railway line. I would like to create for each line segment a buffer polygon that has no overlap with neighbouring buffers in railway lines to corner. Creating an indivdual buffer for each 100m line segment results into the following buffers:As you can see the buffers are having gaps wen the line is cornering. In order to avoid the gaps I created a single line using the LineCombiner and then using the Bufferer to create a single polygon. Next step would be to 'cut' this single polygon into polygons with a length equal to the original 100m line segment. Following the result of the LineCombiner and the Bufferer:Does anybody have an idea on how to cut this long polygon into 100m polygons?