- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27723 Posts

benvkContributor

How to ensure parameter input is valid mobile number?

Hi, I have a parameter in my workbench that I want to lock down to expect a 10 digit phone number. Here in Australia they all start with 04, so I am hoping to make my parameter restricted to between 0400000000 and 0499999999. It doesn't work if I use integer, because it drops the leading zero. Does anyone have any tips on how I can achieve this? Ultimately this will be published to server and be a web form input field. I am hoping the user cannot press submit until the mobile number is in the range I mention above. Cheers

1430

2 years ago

jrlalessiContributor

asked in Transformers

Do I need a writer to commit changes in an existing table column?

I am reading in an ESRI File GDB, and using several attribute transformers to populate existing fields. Everything is working the way that I want it to (looking at the inspector), however the changes are not being committed to the tables when the translation completes. Do I need to have a writer in place to commit the attribute changes to the table? Is there something else that I need to add to tell the process it is complete, and the changes can be committed? I am not looking to create any outputs just update the attributes that I have targeted.

600

2 years ago

townestContributor

asked in General

UPSERT to file geodatabase gdb

I see this new UPSERT functionality...Where can I find help docs for upserting to file geodatabase gdb? Thank you, TylerSAFE FME 2022.1

6270

2 years ago

4dlink

asked in Transformers

Hi. I would like to create a workspace that can convert various points shape file into kml/kmz.

I could make a simple workspace that can convert from shape file to kml, but it is only allow to covert one specific shape file, due to the Name/attribute value differences for each shape files. Therefore, I would like to make a workspace to available to convert various shape file having different Name/attrbute value that can automatically read/extract each file attribute values, beyonds files and allows to select to show in output Kml file. i.e.) set varrious attirbute value available in Kml property setter. I'm very beginner, so my question is bit silly, but if you have some suggestions, idea, method, that would be really helpful. Thank you for your reading.

Compare two columns from excel files.

Hello.I have two excel files (1) and (2) that contain a column of addresses.The "House number" column in the excel file (1) and the "Houseno" column in the excel file (2)How could I compare the two columns and notice the similarities and differences.Thank you very much!

Translation successful, but process keeps running

HiSituationWe have a quite simple FME Workbench, loading CSV data from an URL, and writing it's data to a MSSQL database. The workbench works fine, writes all data and terminates with "Translation was successful". ProblemSometimes (actually mostly) the workbench doesn't stop right after it logs "Translation was successful", as it's supposed to do. Everything's done, all records have been inserted, but the workbench keeps running. Sometimes it takes 5min or 10min, sometimes it takes days until the workbench stops.The screenshot shows the situation. In this case it was a time lag of 5 min. FactsFME 2018.1MSSQL 2016; it's on the same machineWith PostgreSQL or Oracle we never experienced the same issue Any ideas or hints?Regards, Tobias

850

2 years ago

jonathanklarup

asked in Transformers

Create 3d donut polygon with an incline of 1.2 percent from center to edge?

I'm trying to Create 3d polygon with a center polygon and a buffer around it, I need to have an incline of 1.2 percent from the center polygon towards the edge of the "buffer". Hope someone can help, and thanks in advance. I've come this far, but I'm missing something:

2 years ago

lukas108Contributor

asked in Transformers

Is it possible to create straight labels along curved lines with MapTextLabeller

Hello. Is it possible to create straight labels along curved lines with MapTextLabeller? Usually this transformer creates curved labels spread out to every single letter that I do not want. Lukas

Hi, I am using a fmeserver engine image as a base image and trying to build a docker image with some more additional installations like azure file storage, oracle client etc. While I am trying to build the image, I am getting the following error.

This is the error I am getting when I trying to upgrade the pip --version in the base image and build a new fmeserverengine image:Step 2/45 : RUN python3 -m pip install --upgrade pip ---> Running in 95e4bf57b3f0Fatal Python error: Py_Initialize: Unable to get the locale encodingModuleNotFoundError: No module named 'encodings'Current thread 0x00007f43b515f740 (most recent call first):Aborted (core dumped)Fatal Python error: Py_Initialize: Unable to get the locale encodingModuleNotFoundError: No module named 'encodings'Current thread 0x00007f43b515f740 (most recent call first):Aborted (core dumped)Service 'fmeserverengine' failed to build: The command '/bin/sh -c python3 -m pip install --upgrade pip' returned a non-zero code: 134 The base image which I took it from :/quay.io/repository/safesoftware/fmeserver-engine:20632

I need to run approx 10K zipped LAS ASPRS files and generate an xyz file with 5 m grid using ground values. Looking for a workflow to do this.

2 years ago

arsouzaesilvaParticipant

asked in General

Extract NDVI value from raster

Hi, After using the NDVI calculator I would like to get the image indices that vary between -1 and 1. How can I do this in FME? Thank´s

130

2 years ago

spidermanContributor

asked in General

How to convert lines to points

Hallo , i have lines data and I have only start point and end point of line .but I would like to get all geometry of points from start till end point.,so I have used chopper to convert lines to points but my problem .I am not sure ,how could i add all geometry of points from start till end point in new attribute for the same id of line .FME 2021Thanks for help .

10570

2 years ago

nicholasContributor

asked in Transformers

How to read a JSON file from waze

I have a JSON file from waze that I am trying to read.I am using the JSON (JavaScript Object Notation) reader.There are three schema; alerts, irregularities and jamsI can read alerts okay with this queryjson["alerts"][*]Flatten Nested JSON values into Attributes = YesRead Entire Feature as JSON Fragment = Nowhich reads 433 alerts, each with a location.x and location.y which allows me to built a point object (Vertex) for each feature.But I am struggling with the irregularities and jams.The irregularities have a line object which obviously does not convert into two neat columns.How do I read the line object?I have attached the json file here

gisgeekContributor

Hi I am trying to connect to a public S3 bucket and have tried multiple times to connect and download files in the bucket. I just keep getting an error message. I'm probably entering something wrong but I've tried multiple different things and no luck so hoping for some guidance here. S3Connector: There was an error connecting to Amazon S3: 'Parameter validation failed:Invalid bucket name "shaking-layers/": Bucket name must match the regex "^[a-zA-Z0-9.\\-_]{1,255}$" or be an ARN matching the regex "^arn:(aws).*:s3:[a-z\\-0-9]+:[0-9]{12}:accesspoint[/:][a-zA-Z0-9\\-]{1,63}$|^arn:(aws).*:s3-outpo...'. Confirm that your credentials and region settings are correct. Some regions are not publicly available - contact AWS for more information. I have attached a screenshot of what I am entering in the S3 Connector.

1540

2 years ago

spidermanContributor

asked in Transformers

Problem to extract coordinate of start and end point of line

I have lines , I have used coordinator extractor with index 0 , coordinate extractor with index 1 so I got start point and end point for each line .but I have still few lines ,although I see them in inspector as lines but the coordinates that I extracted for each line of them by coordinate extractor transformer ,has same coordinate for start and the same coordinate for end of line as attributes what is the reason of that ?how could I get coordinate of start Point and end point for theses few lines but it should has different geometry in start rather than end FME 2021Thanks for help

1380

2 years ago

dallas2011Contributor

asked in Transformers

Add a new column which include the previous column data type(string, data ect)

Hi, I have a question, I would like to ask if it is possible to insert a column that contains the character encoding of the previous column.Do you think it is possible to do this?

2 years ago

sondregrimsrud

asked in Integration

Issues with AutodeskBIM360DocsConnector and files larger than 500 MB

Hi, I've automated daily uploads of certain files to the Autodesks BIM360 platform - through the use of AutodeskBIM360DocsConnector. Everything went fine the first 6 months, but as the files grew larger in size I've had issues with files bordering 500+ MB. Around 500-600 MB FME starts delivering an UPLOAD_ERROR. Is this a known issue, and does anyone have any insight regarding potential solutions or work-arounds? Attribute(string: UTF-8): `fme_rejection_code' has value `UPLOAD_ERROR'Attribute(string: UTF-8): `fme_rejection_message' has value `'

2 years ago

kumarkannan1980

asked in General

Year wise topology on the parcel data

Hi, I have a parcel data with various years in the postgis database and I need to executed topology year wise to find out the topology errors across the years. I have query to filter out the data in year wise and the query is (column1 < Year and column2 >= Year). My first question is how to retrieve the various years in DB for that particular area and my second question is how to pass the years to fetch the data pertain to that particular year and pass it on to the dissolver transformer, kindly let me know.

2 years ago

nibon

asked in General

Create all lines between points A and points B if the distance between them is < 500 meter.

I have two sets of points, A and B. I would like to create lines between them, only if the distance of this line is < 500 meter. Currently I achieve this using a 1-on-1 join in the FeatureMerger. For each point in A there is a list element with the coordinates stored for point B. So if I have 300 points of A and 200 of B, I would have a list with 300 features, with each feature having 200 elements. I then explode the list, and then for each point of B, create the feature, and then check if the distance is <500 meter. This is unfortunately very bad performance-wise, since there are a lot of unneeded connections (> 500m) being made. When running the workspace with big sets of points in A and B this can really effect efficiency. Is there a way in which I can check the distance between two points before I create the feature?

260

2 years ago

smfks911

asked in Transformers

How to add an attribute in files exposed by File and Path directory transformer?

Dear Altruist, I have a consistent series of excel files but saved under different folder in respect to model_run no. Now I would like to add a column in each of the excel files as per the folder name that file is situated in. I have used 'Directory and File Path' transformer to expose all those excel file and used stringsearcher to create a column that extracted the folder name from the path. Can anyone please tell me how can I add the folder name as an attribute to the individual excel file?regards/

720

2 years ago

joe.fmeContributor

asked in Data

Connection to Sharepoint List Reader and URL formatting

Hi all, I've been tasked with trying to connect to a Sharepoint list and have the appropriate security (read-only) applied to the sites and file/lists. When I try to read in the Sharepoint URL with FME, I am presented with errors, be it for Web Auth, Basic, NTLM or Kerberos. I've attached screenshots of the errors. Any help is appreciated. I do also have another URL which is formatted as "https://<site>.sharepoint.com/sites/<subsite>/_api/web/lists" which I have tried as well, but to no avail

200

2 years ago

zacharylee1204

asked in Transformers

Matching two tables and output result

Dear Sir / Madam, Actually I am trying to match two excel table values (attributes name from two different samples). In the excel, I have one matching table and two models attributes in two tab sheet. I would like to compare the value with Model 1 and Model 2 based on the matching table. For example, apple matching apple. However, some of the naming are not exactly matched with wording and are slightly different, such as Pineapple in sample 1 is equal to USA_Pineapple in sample 2. Is it possible to do that? Also, if possible, could it be not case sensitive? Then, I would like to perform a value check on two samples based on the matching table I provided. The result that I want to get is on the "Output Sample" tab in orange colour. I have attached my sample data here. I hope you understand what I said and I hope it is possible to do that. Thank you all and have a good day!

2570

2 years ago

james_c_452Supporter

asked in General

Wrong FME version opens when running FME from command line

Hi, I'm trying to run an FME process from the command line like I have many times before (fme example.fmw) However, it is opening the wrong version for the workspace. The workspace is in 2022 but the command line is opening 2018 (which is also installed on my computer). Is there a flag or something I could add to my code to ensure it opens 2022? My workspace has newer transformers than 2018 so it crashes everytime I open it I have tried adding it to the system path variable, but this doesn't do anything, unless I'm doing it wrong Thanks

380

2 years ago

arjanboogaart

asked in Transformers

Uploading files using python via data upload service

I want to upload some files for a specific workbench using HTTP.I'm using Python for this with requests library, but I'm having difficulty getting it to work.My python code is as follows: with open(file_path, 'rb') as file: url = f"{fme_url}/fmedataupload/{script_location}" data = { 'custom_file': { 'value': file.read(), 'options': { 'contentType': 'application/octet-stream', 'filename': file_name, } }, 'opt_namespace': directory, 'opt_fullpath': True } token = get_token() headers = { 'content-type': 'application/x-www-form-urlencoded', 'Authorization': f"fmetoken token={token}", } return requests.post(url, data=data, headers=headers, json=True)I do get a 200 OK response, so authorization is fine, but the file isn't uploaded.It even creates a directory at the right spot.The response is as

2080

2 years ago

mariakaContributor

asked in Transformers

RasterCellValueCalculator with overlapping images

Hey there,I'm struggling with the RasterCellValueCalculator. As I have raster files which are not congruent to each other and not of the same resolution (but overlapping), the transformer doesn't calculate properly. It's just a simple substraction.I already tried to bring the rasters to the same resolution.Can anybody help?I added a sample workspace. Cheers,Maria

2 years ago

1
...
206
207
208
209
210
211
212
...
1109

Page 209 / 1109

Badge winners

graceembree01has earned the badge Welcome Back
hrgisolutionshas earned the badge Welcome Back
matt.albrittonhas earned the badge Student (Grey)
gisbradoklahas earned the badge English Speaker
dylanroesthas earned the badge Dutch Speaker

Show all badges

30,469: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.