Best Answers

Hi all,I have attributes streets for example below. I want to extract the attribute14 Le Thanh Nghi >> 1412B Gia Quat >> 12B3 Ngach 6 Ngo 12 >> 3Tran Hung Dao >> Null (Have not number) Could you tell me how to use regex function to make it?Thank you

I am trying to create a 2D oriented bounding box around the point cloud of a roof with a boundingboxreplacer and the appropriate option, but the result is the same as a standard 2D bounding box. I expect an rotated bounding box. What am I doing wrong?

Do I need to refresh the "Run Workspace" action in an Automation on FME Server when I make an expression change in an Attribute Manager in the workspace? I've published the updated workspace to FME Server already. Will the Automation run the newest version of the workspace? Or do I need to make it "see" the change somehow?

HiI want to know for all records with a certain project number whether certain other attributes are the same. For example, all the records with projectnumber A97652 must have the same startdate and owner, if ist not the same then i must change the one that's different. I think i need a transformer with a group by function. I have tried the matcher but it doesn't do exactly what i want. Does anyone know wich transformer i have to use? 

Hi, I'm trying to create a single xml template that can handle dynamic attribute names. The attribute name to be used is stored in another attribute. Please have a look at how i set up the xmltemplater to write the attributes names:ROOT:<root> <a>head</a> <feat>{fme:process-features("SUB")} </feat></root> SUB:<f> <{fme:get-attribute("attr")}>{fme:get-attribute("value")}</{fme:get-attribute("attr")}></f> Where 'attr' holds the attribute name and 'value' the value.  I get the following error:The following error occurred near line 2, column 6 of the query: invalid expression: syntax error, unexpected character "{"An error occurred while parsing the 'SUB' sub-templateSo clearly this is not the way to go. Is this possible in anyway or do I have to define specific SUBs (conditional) for every possible feature schema? Thanks! 

I'm using FME Server and Desktop version 2018.1.2, I have a webhook in Cityworks when a service request is closed it should trigger a FME server process where it generates a pdf report and emails it to the requesterI have a parent workspace that gets the JSON from FME Server topic message. The workspace checks if a file exists and then runs two workspaces based on yes-no tree. The child workspace reads the same JSON and uses a cityworks connector transformer to authenticate to cityworks api to get service request details. The child workspace runs as a stand-alone process and successfully authenticates to Cityworks to get a token. However when run as achild workspace fails with the following error CityworksConnector_HTTPCaller(HTTPFactory): HTTP/FTP transfer error: 'Couldn't connect to server'CityworksConnector_HTTPCaller(HTTPFactory): Please ensure that your network connection is properly set upCityworksConnector_HTTPCaller(HTTPFactory): No proxy settings have been entered. If you requ

Hi Community, I just wanted to know that for a pipe geometry co-ordianates...council ideally collect points for particular pipe as a polyline (meaning having more than two co-ordinates for a line).My Question is how to collect co-ordinates of starting and end point of a specific line out of given all co-ordinates defining a polyline?

Hello all, I have a table that I need to pad with missing ranges following a small, specific rule set. Lets say I have the following table (in the attached spreadsheet):I would like to result in this table, which has new rows inserted with start and end values whos ranges were not represented in the initial table. These new rows have been flagged as "free" (also in the attached spreadsheet):The knowns and the rules are as follows:The quantity of groups is not knownThe quantity of subgroups is known, in this case 1,2,3The allowed range is known for each subgroup, in this case 0-10, 10-20, 20-30As a rule, ranges should not cross subgroup boundaries (see row 9 in output table)All values from 0 to 30 should be represented in each group To simplify the example, the ranges overlap. The real data type has decimal precision, which would result in the following ranges:0 <= SUBGROUP1 < 1010 <= SUBGROUP2 <2020 <= SUBGROUP3 <=30 Thank you in advance for the help.

Hi friends, how to add the display of my data to the map (for example, the outline of houses or some zones) when activating the window for selecting an area to FME Server.

As output from a workbench I get a table with some rows of data. This data is send to me via the Emailer.  I created a server app with this workbench and now want to get the information, which is send by the Emailer, directly as result in the Server app as a table (see attached image). The content of this table depends on the value of a Published Parameter. I created an image which shows the idea I have in mind:Any ideas?

I've been given a CSV file that has a mixture of line ending types, some are LF and some are CR.  The first line is blank with a LF, followed by a header line with a CR then all the data records which are terminated with LF's. The CSV reader is thinking the terminator is LF so thinks the header line is both lines 2 and 3 which is messing it up. Other than reading the file in as a whole and changing the CR to LF, saving it and reading it in again does anyone know how to read this in?

I want to make an Automation where the flow goes first trough an workspace which reads data from an database. Depending on the feature type it then goes to different Automation Writers. Each of these ports are then connected to its own workspace so it can be run parallel. Eventually they merge back to another workspace which writes back the data to the database. The problem I have now is that thousands of features reach the Automation Writer thus kicking of the next workspace thousands of time. Obviously that is not what I want. What is best practice to collect and group these features and pass them on as one feature. I tried using the Aggregator Transformer and adding the parameters to a list, but it seems that it is not supported by GeoJSON. I use FME Server 2020.2

Followed the example provided by @jovitaatsafe​, and the workflow appears to be exactly what I need to do with my data, where I have a number of points in different areas, and want to aggregate by count into hexagons.  The hexagons are also showing up in the ocean near Africa, so I'm guessing this is a map projection issue? But not sure where to resolve it exactly.

I've been sent some data - a simplified example would be like the below with XY coordinate points each with an attribute to say whether that location was covered or not. I need to create lines from these points, but I only want lines from the points that are 'Yes' covered, and each section of consecutive points that are 'Yes' covered needs to be a different line. Logically if I could ask the questions... "Are you a 'Yes' point?" and "Is the point before/after you a 'No' point?" I could find the first and last points of each line but I don't know how to do this in FME.Does anyone have any solutions or pointers?Thanks

Hello everyone,I want to download files from USGS. In my workspace I have a Creator connected to HTTPCaller.My HTTPCaller looks like this: When I Run the workspace I get error 'Error running translation'.When I paste this URL to browser and click enter, after about two minutes file starts download but I can't use this URL in HTTPCaller.Any ideas ?CheersAnn 

Hello! I used this instruction to create a web connection to our ArcGIS Portal: https://community.safe.com/s/question/0D54Q000080hBUjSAM/how-to-create-an-fme-web-connection-for-esri-arcgis-portal-feature-service-oauth-20 There is no problem using the ArcGIS Portal reader for reading the branched enabled service. The problem is when I try to use the ArcGIS Portal writer to write to the same service. I get the following error: ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was 'none' and the message was: 'The operation is not supported by this implementation.'. Details: ''A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsArcGIS Portal Feature Service Writer: Reconciling Branch Version 'sde.DEFAULT' against 'sde.DEFAULT'ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server

I have developed a python script to walk though directories picking dwg files that fit the pattern I want. I would like to add the script to a user parameter and pass/link the parameter to a reader source. For testing purposes I started with a simple script to return a single dwg, linked it to the reader source, and it failed with error...'Update Reader Failed'. My simple Python User Parameter scrips is as follows:----file = r'C:\\data\\dwgfoldertest\\Test1.dwg'return file-----Any pointers would be appreciated. If I get the simple test working, I'll move onto the more complex Python oswalk script which will return a string of dwgs separated with commas, so if you have any tips on how FME will behave with that next step, that would be appreciated also. Thank you,Tyler FME(R) 2020.1.2.0 (20200902 - Build 20620 - WIN64)

I have 210 rasters, I am trying to create one mosaic for every 10 of them. The titles will be something like:raster_0_10raster_10_20raster_20_30I created a custom transformer to loop the rasters. There are two variable called "from" and "to". I increase them with 10 for the failed data. Whatever I do, either it keeps updating the first raster or it fails.I attached the workbench, unfourtunately I am not able to give a sample data but I provided the CSV file of the namings. Thanks,Caner 

I have countless roof surfaces as MultiPatches from which I would like to determine the highest point (x,y,z) using FME. I can determine the highest Z-value of a roof surface without any problems, but I always get only the Z-value and not the corresponding X and Y coordinates. One possibility would be to calculate a small elevation model for each roof and then use the X and Y coordinates from the cell with the highest Z value, but I would like to avoid this diversions if possible. Is there another more efficient way in FME to determine the highest point (X,Y,Z) of a multi-patch area?

I have multiple (210) jp2 files, FME reads them but the extents seems the same for all of them. Therefore they sit top of each other. If I check the raster files in ArcGIS Pro, they are next to each other and extents are different.The coordinate system is not in the list of FME. I created a custom one using the tool below.https://demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw? The coordinate system is ESRI:102717.https://epsg.io/102717 One warning that I am getting when I run the workbench is JPEG2000 reader: `<MYLOCALPATH>\\w_10890984_12_17100_4bd_2017.aux' exists but could not be opened. File contents may be invalid, or the file format may not be supported. 

HiWant to delete all rows from my SQL table. Created the following FeatureWriter to set to delete:However, ran it in my workbench and the database records are still not deleted. Anything that I did wrong? Thanks.

Hi there,I use FME Desktop to bulk-load to elasticsearch. I'm building a new application based on elasticsearch 7.1.1 but mapping types were removed ahead of this version;https://www.elastic.co/guide/en/elasticsearch/reference/current/removal-of-types.htmlAre there plans to update the reader/writer to be compatible with elasticsearch 7?Thanks,Campbell

Hi!Since few time I have an error at the begining of the translation.PDF Reader: Failed to open document "xxx\\*.pdf"because it does not exist or because the reader does not have permission to access the fileI replace the path by "xxx" for this post.The path is good and I have permission because when I choose just 1 file manually it works. The problem seems to come to the relative path with the " * ".I don't see that is the problem.Can you help me? Thanks!

We get the error "Can't connect to HTTPS URL because the SSL module is not available." when running a workspace on FME Server but the same workspace run from FME Desktop is okay. FME Desktop 2020.2.1.0 (20201130 - Build 20806 - WIN64)FME Server 2020.2 Build 20787 - win64 ```2021-1-26 19:19:35 | ArcGIS Feature Service Reader: Requesting metadata for Feature Service at 'http://mapservices.gov.yk.ca/arcgis/rest/services/GeoYukon/GY_Biophysical/MapServer'2021-1-26 19:19:48 | ArcGIS Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='mapservices.gov.yk.ca', port=443): Max retries exceeded with url: /arcgis/rest/services/GeoYukon/GY_Biophysical/MapServer?f=json (Caused by SSLError("Can't connect to HTTPS URL because the SSL module is not available."))' ```Digging around on Stack Overflow and similar s

I have simple workspace doing a point densification and generalization on polygons: I have three published parameters:the input (Shapefile), the output directory and the output name (Shapefile). I call it from a batch file (it is replacing another tool in a longer chain of commands) like this:fme workspace.fmw  --DestDataset_SHAPEFILE z:/ --ftp_feature_type_name_exp bThis works as intended, taking the default input (z:/a.shp) and writing to both directory and filename I define in the parameters (z:/b.shp)fme workspace.fmw  --SourceDataset_SHAPEFILE z:/b.shp --DestDataset_SHAPEFILE z:/ --ftp_feature_type_name_exp cUsing the --SourceDataset_SHAPEFILE parameter does not work. There is no error message, but it seems the workbench either does nothing or falls back to the default values for all parameters. How can I call a workspace with different input/output data, from console? These are purely geometric operations, so I don't think schema should be an issue (it is the same in these exampl