General

I have the following string: mapMarkers.push(bap(map,'','marker.php/oaaa/BusShelter:BusShelter:BusShelter/EB:WB:EB/1/null/null/39.69643098429845/-104.88185718655586/null','','interactive_view:f=D0007.1.1.1|f=D0007.1.2.1|f=D0007.1.3.1',1, null, null, 1, null, null, ["BusShelter"], true)); I'd like to extract the lat/long values as well as any values following f= So for the example above, I should get the following attributes: Lat=39.69643098429845Long = -104.88185718655586ID1 = D0007.1.1.1ID2 = D0007.1.2.1ID3 = D0007.1.3.1 Do I use a stringsearcher with a regex? If so, how?

Is there a reason why I can not setup a fme workspace on FME Server that accepts POST requests? It would be much cleaner to accept data in a post request. This would also allow for accepting image and other large binary data to go in to my workflow.

Hi, I am using a PythonCaller to create an XML string. When I send this string through an XMLTemplater, all "<>" brackets are converted to "<" and ">" (html encodings). Adding a StringReplacer/StringPairReplacer to replace all brackets works fine but can take some time for larger content . Is there a way to prevent the XMLTemplater from converting brackets to encoded brackets? becomes:

I'm trying to create a relationship (1: n) between a shapefile and four tables and publish it in an FGDB. I created two columns with AttributeCreator (goedb_feature_has_relationships) and (geodb_oid). As a writer, I have four options (see the following figure). I selected (Esri Geodatabase (File Geodb)).I noticed that format attributes from my writer doesn't contain (goedb_feature_has_relationships) and (geodb_oid). It is the same with other writers. Because of this, no relationship is created in the end. every excel file has a relationship (1:n) with my shapefile. I would be grateful if you could tell me why the problem is. Many Thanks. 

Error message when converting four shapefiles into one FGDB. Error consists of:An error occurred while attempting to create the feature class 'SB_Aussenkasten'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create double column table.}I would be thankful. if someone could tell me what the problem is. Thanks very much.  

Hello FME community, I have an excel file with the following columns (please see Photo) and would like to convert it to line (FeatureClass).I would be grateful if you could give me a hint.

Whenever I run the workspaces, it ends up with "Error running translation" at the first process of the translation. This occurs in all workspace files including official training files or most simple translation such as xls to csv.My work environment is MacOS Monterey (MacBook Pro 14 inch M1 Pro). And there are no problems if I run the same translation on Windows PC.

Hi, I have bottom hole well locations in the attributes of surface hole well locations shapefile. I need to read those coordinates and generate a new shapefile in FME

I have two variables within a script tag in the head of an html document.What's the best way to extract those two variables?Both variables are json data.  In the end I want the geojsondata and I want to add the metadata to the geojson data. I can extract the strings for the variables using regex, but is there something better to read javascript? 

Hello! I am using FME Desktop 2021 and I have constructed a workbench that reads a CSV file with one column field. Each CSV row is a text string, which represents an XML document. It is used as an FME attribute inside a SOAP request template (XML template) to download and parse an XML document. However, the XML document could be referencing other XML documents via their respective text strings. If I extract these strings from the XML response, is it possible to feed them back as an input for my workbench and download them before moving on to the next CSV record? Apologies if the question sounds unclear, I can provide more info if needed. Any suggestion would be highly appreciated.

Hello,  FME Desktop 2019.2.3.3 Build 19825 Win64 I'm getting a few issues when using the Directory and File Pathways reader to get the subfolds in a directory.  I have a Published Parameter that is set up for File_Path input. If I put a path with a space in the name I'm able to see all subfolders when running in FME Desktop, but once I write to csv the file paths are truncated to only show the path up to the first space. Example:  In FME Desktop I see this: \\\\unc_path\\a\\b\\a b c Here's what the csv output looks like: \\\\unc_path\\a\\b\\a  That led me to try and add double quotes "" "" around the path in the Published Parameter which then gets to my second issue that it then adds commas "," into the path where the spaces are.   We'd like this workbench to be dynamic and allow any file path whether there's a space or not. Is there a solution that doesn't require my end users to change the file path to forward slashes, double quot

I received a sample data file from a client who wanted me to convert all their files from CGI's OMS .gis extension or called the M3i format, data is for Electric utility. Though you can open the file in Notepad++, I tried to read it as well using Json Reader to be able to extract the attributes and geometry, but it seems it's hard to interpret the data structure from inside, to be able to parse it.. I also found this Safe webinar slides (here) talking about this format, and it looks like t's supported FME format thoughhere's a snippet of how this file looks like:GIS M3I standard data, version 1621295625593D702{GEOMETRY{SYMBOL{default;361368.971591387;194906.787360248;1;178621295625593D702{CONNECTIVITY{NODE{621295625593D702C1;621295625593D702C2621295625593D702{ATTRIBUTE{EQUIP_TYPE{ELBOW621295625593D702{ATTRIBUTE{STATUS{C621295625593D702{ATTRIBUTE{PHASE{B621295625593D702{ATTRIBUTE{ON_MAIN_LINE{T621295625593D702{ATTRIBUTE{DISPLAY_TEXT{\z3025J to 2433JB621295625593D702{ATTRIBUTE{TOOL_TIP{3

hi，everyone,Thanks for browsing my question。I want add below map frame for my polygon,red is my polygon。how I cad export result to cad​.​

We all want better performance from our workspaces and often that comes down to our design. Sometimes very subtle design changes can produce a big performance difference and this is one example of that. Workspace ComparisonHere is a workspace that renames incoming attributes with the AttributeManager:  That workspace takes 1.1 seconds to run. Here's another workspace that produces exactly the same output: Instead of using the AttributeManager to rename the attributes, they are renamed on the writer schema and a value assigned to it. That workspace takes 5.5 seconds to run! ExplanationSo the second workspace is five times (is that 500%?) slower. Unsurprisingly the time lost in the second workspace is caused by the writer: Fast Workspace2022-01-06 13:17:22|   0.8|  0.1|INFORM|Creating writer for format: CSV (Comma Separated Value)2022-01-06 13:17:22|   0.8|  0.0|INFORM|CSV writer: Writing 100000 feature(s) to file 'CSV.csv'2022-01-06 13:17:23|   1.0|  0.0|INFORM|CSV writer: Writing 58691

the AreaOnAreaOverlayer efficiency is very slow compared with arcgis,is there any other replace?

So I was given a workbench that was quite extensive and it has a lot of junctions. These junctions were only added so that annotations could be placed on a specific location for readability. This doesn't sit well with me because feature caching is on and the workbench is prone to memory issues already. Also, I don't like the cluttering. But it makes sense to get the annotations where you want. However, after reading several posts it is still not clear to me whether junctions add to the cache or not. Can somebody tell me whether they do add to the cache or not?

 I have the following installed:ArcPro 2.7.4ArcGISDesktop 10.8.1Background Geoprocessing 10.8.1FME 2021.2.1.0 (20211203 - Build 21797 - WIN64) I also have a workbench that used to work. It simply took a couple of old-school Esri SDE features plus two new-school features that have attribute rules applied on them, and therefore need ArcPro Translation turned on, which it is, and exported them to a file geodatabase. What used to work now gives me the dreaded "Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise" error. What else do I need to look for?http://fme.ly/qua

Dear Community, I have the following issue: My ultimate goal is to build a CityGML file from roof polygons. To build the buildings and separate the walls and stuff is fine. But the buildings are commonly have structures (as I call roof on roof structure) above the roof. I'm able to project the roof - and roof on roof's roof - to the ground, but then I receive this: What I would like to achive is kind of this:This seems kind of hard to me. I read over the whole forum, but no sign to be able to cut the roof on roof's wall with the angled roof plane. Also extrude would not fit, because this will require a single height, and in this case, the height is changing along the intersection line. The geometry type is MultiSurface. How can I effectively generate this roof on roof structure's wall segments without pushing the wall until the ground level? If no clear answer for how to generate properly, how can I cut the excess parts?If no way to clip, I'm open for further ideas,

I'm having a hard time monitoring our production fme server due to the high number of jobs it runs. Typically it runs 3000+ jobs each day.We have a system of workspaces, that automatically monitors and processes relevant requests from a national database for multiple customers. The processes run every 5 minutes half of every business day, which produces most of the mentioned number of jobs.The jobs that process the requests are identical, and a string of modular jobs are launched for each request. This makes it difficult to monitor the progress of each request just by using the built-in web interface.Are there any smarter ways to utilize the standard interface for monitoring, or must I create my own procedures, and my own logging (to a db) ?Cheers.Still using 2020.2.5

Hello everyone, I am trying to tile a Point Cloud in FME. I have a Point Cloud in the .xyz format and i would like to tile them to the Cesium 3D-Tiles format. Unfortunetly it looks like on the foto.I` am just using the Reader for the xyz file and the writer for the 3D-Tiles output. Is there anything i am doint wrong and if yes (what i think) how can i solve the problem? Thank you for all answers.

Happy New Year FMEers!Here's the first What's Up Wednesday post of 2022. What's Up Wednesday LinkedIn NewsletterIf you prefer to get your FME news on LinkedIn, What's Up Wednesday is now a regular newsletter that you can sign up to and receive notifications about. I'll still post here of course, but maybe LinkedIn is more convenient for you? FME2022 PerformanceFME2022 is still in development but should be released sometime in March, if I have my info correct. But founder Dale Lutz gave us a sneak peek at what we might expect in terms of performance. For a spatial overlay, Dale found a 10-20% performance improvement. This sort of number is a good indication, but not the whole picture. I know of other tests that have much higher improvements. It all depends on what functionality you're using.  Regardless, this graph is what I found most interesting:  All of Dale's tests were done on a Mac and this graph shows how Intel-compiled FME worked on the new ARM M1 chi

Hello wise people. I am trying to clip (extract by mask) a big LAS file to multiple shapefiles (2 for now but they will eventually be 14). The workflow is like this: LAS reader, Clipper, Feature writer. When I choose "OUTSIDE" to the writer it clips properly but with INSIDE (which is the one I need) it doesn't clip properly to the shape of the polygon (shapefile). What gives? Thanks so much.

I am running a verification process and there can be one or more validation errors to my data for each feature. I would like to define my own error messages and push them to a list so i later easily can combine an error report.To solve it I am thinking of using lists. But i cannot figure out how to create an empty list instead of an attribute.  I am thinking to have a list looking somthing like this: errors{0}.height: "Negative values are not allowed"errors{1}.height: "Value must not be empty"errors{0}.quality: "Quality code invalid"errors{1}.quality: "Quality code must not be empty"errors{0}.bbox: "Feature is out of bounds, check coordinate system" I hope you get the idea.Later i want to use the list to report all the errors each feature might have. But how can i define an empty list so that i can later populate it with values as the feature go through a step of testst? Can I use Feature manager to make my test and add the validation r

In attached workspace I get unexpected DuplicateFilter behavior, The Inspector result is, Since the two features have the same value for the nombre_cientifico attribute, I am confused with the unique port output. Any suggestion? 

I am trying to connect to sde database in FME. I am using ArcSDE geodb reader. I am getting this error. I am using an ESRI edition Fixed license.