FME Form

Hi, I have a text string that looks something like this…LOT 4-6 DP 287 SEC 2-3 SO 345152 I have a regex “(LOT \d+[\s?&-]\d+ DP \d+ ){1,}”  that grabs the LOT 4-6 DP 287 from the text line.How can I split the 4-6 into separate attributes so I end up with Lot 4 DP 287 Lot 5 DP 287 Lot 6 DP 287I could do it with a testfilter but there are unknown combinations. 1-12, 60-62, 78-82 etcAny help is greatly appreciated.Regards, Paul

Hi,I am just wondering if you know the way to get the list of the layers that are chosen in particular Layer List widget in ArcGIS Web AppBuilder. I have used:ArcGISOnlineConnector to get into the web appandHTTPCaller with Request URL that have following structurehttps://YourPortalUrl/portal/sharing/rest/content/items/YourItemId/data?f=jsonUnfortunately t the only infrmation that I got in _response_body in relation to this widget is the label given for the widget in the app"id": "widgets_LayerList_Widget_20","index": 5,"label": "Layer List_2","name": "LayerList","uri": "widgets/LayerList/Widget","version": "2.21"  

Hey.I need to count the number of characters in all text fields of my dataset.Any simple way to do this to avoid using multiple StringLengthCalculator ?

Searched for possible solutions here, but nothing yet. Have : col0 col1 col2 col3 col4 Region A BU02851 BU02852 BU02853 BU02854 Region Value A 50 55 40 10 Region Value B 7 11 4 15 Region Value C 60 70 10 25  Need : Region A Region Value C       BU02851 60       BU02852 70       BU02853 10       BU02854 25        What steps do I need to take to get this done? Thanks in Advance ! 

Hey. Do you have any idea how to solve the sequential processing of input elements on HorizonAngleCalculator? If I have several elements on the input of the Horizontal Transformer, I need one element to be processed and then the next element to follow after that element is processed. After that, I would put a featureholder after the HorizontalAngleCalculator and it might work. I've tried testing the featureholder with counter and filtering features that have already been processed, but somehow I can't get it to work. Thank you very much

Hello,I have two questions about the HorizontalAngleCalculator transformer. 1) I simply need the AutoCAD Angle property of a line as shown below. Is HorizontalAngleCalculator the best transformer to use?  Or, better yet...is there a way to expose this property in the reader?2)  The install message for the HorizontalAngleCalculator says it’s not not created by Safe Software, but rather by “safe-lab” implying Safe Software Lab which is kind of confusing. Can someone clarify what this means and whether the transformer is trust worthy?Thank you,Tyler

Hello,I am trying to create a workflow in order to transform a dwg to a cityGML file and later to import it into a 3D citygml database.I have tried to find an example online doing something similar but I had no luck.I wanted to ask if something like this is possible with FME and if there is an available example to get a first impression of how to implement it.

Hi.I have a file of text strings that have multiple ‘parts’ that I have split into a _list. Example text string... LOT 9 DP 19723 LOT 12 DP 384274 LOT 8 DP 30287 LOT 9 DP 2402 PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSEDUsing string searcher, I have formed a list of the formatted string to push into the list using regex: (LOT \d+ DP \d+){1,}The result is a list containing the:appellation:LOT 9 DP 19723 LOT 12 DP 384274 LOT 8 DP 30287 LOT 9 DP 2402 PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSED matches: LOT 9 DP 19723  LOT 12 DP 384274  LOT 8 DP 30287  LOT 9 DP 2402  What I want to be able to do is remove the matched part from appellation on the way through leaving me with both the matches as individual features, and a subset of appellation with the matches removed. The resultant appellation in this example would be: PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSED I would be very grateful for any help with this.Regards, Paul 

I have an FME workspace that sends me an email during certain error conditions. This works great on my remote laptop, but fails on my onsite desktop machine. The FME workspace needs to be run nightly on my desktop machine. This means that I won’t get the email (and won’t be notified of the error conditions). On my desktop machine, I get this error message: ERROR_DURING_PROCESSING<class 'requests.exceptions.SSLError'>: HTTPSConnectionPool(host='graph.microsoft.com', port=443): Max retries exceeded with url: /v1.0/me/sendMail (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)'))) The only difference I can think of is that my laptop use a VPN connection and my desktop machine is on the company network. I contacted someone in our IT department and they want to know the name of the certificate which I don’t know.Does anyone have ideas on how to resolve this? Thanks, Chuck

Hi Community,I have a workspace with some python in to create a container within a blob storage account (something the blob storage connector was not able to do). The problem i’m having is that as soon as i use the blob storage connector in my workspace the package is installed in C:\Users\%username%\AppData\Roaming\Safe Software\FME. This then seems to force FME to use this directory in my python caller. The problem is i’m using newer python packages where BlockBlobService no longer exists and is replaced by BlobServiceClient so they stop working despite being installed as per the instructions for installing python libraries. Does anyone have any suggestions? 

Hi,I am trying to use the RasterObjectDetector for an object detection task using FME Form 2024, but translation fails and I get following error messages:-Library 'C:\Program Files\FME\plugins/opencv/rasterobjectdetectfactory.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this library.-Could not load module 'C:\Program Files\FME\plugins/opencv/rasterobjectdetectfactory.dll' : 'The specified module could not be found'-Module 'opencv/rasterobjectdetectfactory' is unavailable for use with this FME editionI downloaded OpenCV 3.4.9 and added the installation location to the system path, as specified in the documentation of the transformer, but it is still not working. Does anyone know how to solve this?Thanks!

I'm using the ESRIReprojector transformer. When converting between NAD83 and NAD27, I get one option for Geographic Transformer. In ArcGIS, I get several options for Geographic Transformer. Is there any way to get the same multiple options in FME without recreating them? Thanks.

Hi I have a very simple question but it seems i can’t do it . I just want to make a point from an excel list with x y coordinates, but not by writing it to a writer because I have to do a lot of other operations with it. I have already tried different things, I first used a coordinateSystemSetter and then a vertexCreator. But during further edits I always get rejected and my model crashes. It can't be that difficult :-)

WFS 2.0 services are available on the Geoportal Baden-Württemberg. It is not possible for me to view/download the contents of the objects (BP_Plan) with the WFS Reader using FME 2023.Does anyone have any idea what the problem might be?Example:https://geodienste.komm.one/ows/services/org.165.d5516855-2ef7-4512-92f7-68d208f6f722_wfs/org.165.15f5882e-891a-4ce4-b2fc-000a45978e11?SERVICE=WFS&Request=GetCapabilities

In my workbench I download ffs file from azure storage and assign the path in attribute _download_path then try to read the file from the same path using FFS reader but it’s not recognizing the path and in the error even showing wrong name like it’s replacing some characters like it’s considering the wrod gelöst as gelo?st. This word is in my filename.

Hi all, I am trying to convert a AGS File to a standard format to view such as Excel or Shape. I seen something like this online using leapfrog https://www.youtube.com/watch?v=OtyrYsx9teE but struggling to find a simple solution in doing this with FME. Any useful tips would be great.

Hi there,I am fairly new to FME. I have around 6000 dwg. files regarding the same industrial drawings and the data is roughly found in the same place in each file. I would like to know how i can extract the attributes that i need out of these files.I have started using a wildcard function to read multiple files. I know this question is fairly vague, still I was wondering if anyone has the time to help me with this, or knows any recomendations for explanation (youtube or similair examples/workspaces) Like I said, FME is still pretty new to me so any advice would help. Thank you

I am making a call to an API and getting a JSON in return. With the JSONFragmenter and it's flattening options, I can expose most of the attributes in the JSON into FME attributes, but I am getting stuck on a particular structure. Sometimes there's a little table within a single attribute in the JSON like so: "related_objects": [                    {                        "relation_name": "verbinding",                        "relation_id": 1,                        "objects": [                            "randomid1",                            "randomid2",                            "randomid3"                        ]                    }                ] This indicates objects that are related in a particular way to the object in my query. I would like to generate a list of all of the related objects (randomid1, randomid2 etc.). I want to use that  list in my FME flow. The number of related objects might be one, or a hundred, in this case it's three.How do I make FME turn that littl

Hi All,I have created a workflow that reads a few large GIS datasets in vector format across different areas. To avoid reading all the records in the dataset and reduce time I have used the FeatureReader transformer which is connected to the layers and an Area of Interest. The Spatial Filter option is ‘turned on’ as Boundary Boxes OGC-Intersect to read only those records within the Area of Interest. The problem is still takes ages to read,I have got a few FeatureReaders within the workflow and I was thinking to use only one FeatureReader (as all the data comes form the same GDB) to improve the performance, Any ideas to improve the performance of the workflow?

I have a SQLExecutor that inserts data child records for contract IDs. It does fine if it’s a one-to-one but if it’s one contract ID with many children, it only inserts one. Nowhere in my workbench does it group by the contract ID though. If there are 2 contracts and each has 2 children, there are 4 individual rows of data to insert. I managed to resolve the issue by adding a select statement after the insert to produce a result. I don’t understand why it’s behaving this way though. Note that I’m using a SQL Executor instead of a writer because of the need to set the audit user for each insert. Below is the sql statement I’m using. Why does the select statement at the end make it work?  FME_SQL_DELIMITER |EXEC sp_set_session_context 'AuditUser', 'SNOW Sync' |INSERT INTO CONTRACT_ASSOCIATE (CONTRACT_ASSOCIATE_ID, BA_ID, CONTRACT_ID, CONTRACT_ROLE_ID)SELECT @Value(CA_ID), '@Value(BA_ID)', @Value(CONTRACT_ID), @Value(CA_ROLE)WHERE NOT EXISTS (SELECT 1 FROM CONTRACT_ASSOCIATE WHERE CONTRAC

How to calculate the IRI between two points in FME if we know the distance and the slope?Thank you.

After upgrading to ArcGIS Pro 3.0.3 i get the above error when writing to an Esri Geodatabase (File Geodb). Does anyone know what the reason could be? I've also upgraded to FME 2022.2. Thanks in advance! 

In FME 2018, I want to use a custom python interpreter, and a specific python virtual environment (conda environments).How can I do this?

Hi!  I am trying to convert an excel spread sheet (no spatial data involved, just plain data) into a pdf file with pagination based on a field in the spread sheet. Can somebody help me through the steps of this conversion? I have seen posts about using table adder, text adder, pdf styler, pdf page formatter etc. but I am trying to understand the high-level steps to start developing this process.I was hoping SAFE would have some webinar or tutorial on simple excel to pdf conversion, all I can find is extracting data from pdf and converting to excel.Any help is much appreciated.Thank you,LSugumar.

Hi,if a similar issue has already appeared on the forum, please redirect me.I'm trying to generate an automatic report in HtmlReportGenerator. I mainly use CustomHTML to prepare the exact shape of the data table. When I manually create a table and fill it with values from the flow, I have no values in output (the table displays empty records). What am I doing wrong?for example:     <tr>         <td>1</td>         <td><a href="https://geoportal.gov.pl">INDICATIVE LRT/BRT VARIANTS (SR CPK, SFP MODEL)</td>         <td>DATE</td>         <td>@Value(INDICATIVE_VARIANTS)</td>         <td>@Value(INDICATIVE_VARIANTS2)</td>         <td>NON</td>     </tr>