- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27719 Posts

asked in Transformers

How do I use Arithmetic editor in AttributeManager to change a field that has '$1,300,000' to be an integer '1300000'

I have tried all the ways I could think of to do this but cannot find anything on how to change a text field to an integer field like in ArcGIS Pro. Please help! This is what I have tried: @int(USER_Price)@int(@replace(@replace(USER_Price, "$", ""), ",", "")) I have also tried @Trim which produced a 3 digit result.

473

1 year ago

petrb

asked in Transformers

changing MDB content in FME Cloud

Hello.i have simple workflow to update Access MDB content.it starts with SQL creator to define the queries and end up with SQL Executor to write down all the attribute manipulations and the end.Works fine in workbench as it updates existing MDB file and therefore there is no Writer placed at the end. Im seeking an advice how to update this to be able to publish it to FME cloud so the Cloud returns the updated MDB file.as this MDB file is uploaded at the beginning, it still exists and being updated somewhere in the temp folder of the FME Cloud so it should be easy just to request it with some transformer at the end and provide it as a result. can you advice me what transformer can do it for me?

210

1 year ago

kpyke5Contributor

asked in General

When trying to run a workspace I get an error saying "Undefined macro 'OUTFIELDS' dereferenced in file 'a file that doesn't exist'

I created a workbench in an earlier version of FME workbench and then when I updated it to 2022.1 it eventually stopped working referencing an undefined macro 'OUTFIELDS' to a file that doesn't exist when the translation fails. I tried copy and pasting the workbench into a new workbench but that didn't work. I tried updating to 2022.2 but that also didn't work. I'm hoping someone here has had a similar issue and knows how to fix it. I am trying to avoid recreating the workbench from scratch because it is rather large

660

1 year ago

rivam

asked in Transformers

FME Writer not exporting all results after GeometryValidator

I am trying to simply export results with a Writer into a .shp. If I do not use a GeometryValidator most of the features are present in the final attribute table, but not shown in a ArcGIS map. If I use the GeometryValidator and then use both the good and the repaired features as inputs for the Writer, some results are missing from the final attribute table, but all the result in said table are also displayed in an ArcGIS map. The log gives following warning "Dropping heterogeneous aggregate feature for the SHAPEFILE Writer, due to feature type allowed geometries restriction". How do I solve this? Thank you!

830

1 year ago

reschContributor

asked in General

How can i read features with a shared UNC-Path and the Directory and File Pathnames Reader?

Hello everybody, we have a problem with the Directory and File Pathnames Reader.There is an UNC-path: \\\\[server]\\X$\\[directory]\\[directory]\\[directory]. The user has access to the (last) directory and also rights to write. This has been checked. If we use this UNC-path with the Directory and File Pathnames Reader zero features will be read. There is no error, just zero features.It works (with same settings except the path) when the path/directory is connected as network drive. But this is undesired. Has anybody an idea how this with the blank UNC-path works? We are using the FME Desktop (and FME Server) version 2020.2.0.0 Thank you very much in advance! EDIT:it works with a blank path filter and when subfolders are excluded:But we also need the informations which are in subfolders.When it's set to "yes" we run in the same problem (as described above) again. Is it possible that FME needs here special or deeper permissions for the folders/folder-hierarchy? Still tha

430

1 year ago

connecter

asked in Transformers

Use template sheet and don't overwrite existing file

Hello,in the past it was possible to set the options to no and still choose a template. Is there a workaround here? Why is that no longer possible? I would like to use a template and every time the workflow writes that this is done to the same file and not all spreadsheets are removed.

2060

1 year ago

fmesafe.podporaContributor

posted in General

original

Can I have one more question? Is there a transformer within FME that could format CSV into plain text with formatting, see the attachment? Thank you very much

1 year ago

canerakin111Participant

asked in General

Experience processing with NexRAD data?

Does anyone have experience reading NEXRAD Level 3 data? They are compressed two times (.tar.gc) and there is no file extension when it is extracted.

Zoom to selected features - bug?

Hi,after some time in a workflow I often get a problem that the "zoom to selected features" is greyed out. Also the highlighting of the feature is not displayed any more. I try all, but only closing the program helps. Have anyone the same problem? The separat Data Inspector program don't have the problem. I have the newest Version of FME 2021.1, old version have also the same problem.

FME_LOGGEDIN_USER parameter Capture

Hi We are currently on FME Server 2021.2.2. There's a need to capture the login user ID for a server app and then insert into our database for logging purpose:Believe that's the FME_LOGGEDIN_USER parameter. Please advise whether it is possible to do so. Thanks.

150

1 year ago

koenterralyticsContributor

asked in General

FME Emailer is not working on Linux

I've got FME Desktop running under Linux. This works fine (after quite some steps), but now the Emailer does not work. It used to work with FME 2021 (on same Linux machine). But it does not work with FME 2022 anymore. The Emailer v 3.3.3 package is correctly installed, since it is listed in the package list using the command sudo /opt/fme-desktop-2022/fme PACKAGE LIST.When running the workspace it mentions:2023-01-24 14:10:27| 0.5| 0.3|ERROR |Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'2023-01-24 14:10:27| 0.5| 0.0|FATAL |PythonFactory failed to load python symbol `fmepy_emailer.Emailer'2023-01-24 14:10:27| 0.5| 0.0|FATAL |Factory proxy not initialized2023-01-24 14:10:27| 0.5| 0.0|FATAL |Emailer_transip_CALLER (PythonFactory): PythonFactory failed to process featureAny idea why this is happening? I tried to uninstall and reinstall the package, but without result.

using scripted prarameter to return windows directory path

Hi,I have a workspace that needs to read data from a variable folder and write to that same folder. However the exact folder name is not given but rather depends on two parameters (BEKnr and Model) that are entered at the start of runing the workspace but also includes a part that is not exactly known and can vary (versionnumber, v*).To read the data I can easily use * for this variable but for the writer this is not working. For instance: I need data to be read from tis folder; G:\\Team_Hydrologie\\FEWS\\ATTRIBUTENTABEL\\11_Maas\\Dommel\\v2_FEWS. Using an attribute creator and feature reader referring to the location as: $(FME_MF_DIR)\\$(BEKnr)\\$(Model)\\v*_FEWS I get the reader to work.But to write to this same folder the use of the * doesn't work. (To be clear, there will always only be one folder that fits the criteria above, only one folder will have the _FEWS suffix. )How can I do this? Without the user having to indicate the exact folder I was thinking of using a scripted p

1 year ago

carlmContributor

asked in General

What are the limits of FME 2022 Comparison

I was wondering what are the limit of the 'Compare and merge' feature included in FME 2022. I have a request to note all the changes made in the workspace and I want to find a way to list those changes. The problem is that I get an error: Unable to compare workspaces. (I have 800 transformer in it with multiple Custom Transformers). I know this is a bit unrealistic...Thank you

SQL Server with SDE 11.0

After upgrading our SDE on SQL Server to SDE 11.0 using ArcGIS Pro 3.0.3. FME workbench is not able to read feature types correctly from the database. When importing a feature type using a reader, FME cannot read any fields. Same thing is happening when using FeatureReader. Has this been tested that FME 2022 works with SDE 11.0?

290

1 year ago

aleksandar

asked in Transformers

IDENTITY_INSERT for several tables

Hi guys, I tried using IDENTITY_INSERT on several tables of single SQL Server Non-Spatial writer. There is a error I'm getting that says I cann't do that. I now for the rule that SET IDENTITY INSERT can only be used on a single table per connectio, but I wonder if there is some way to make my 4 tables use this feature with a single writer? These tables aren't beeing populated at same time, so can I do something with SQLExecutor for example or no?

Inserting data into spatialite table does not create geometry / fill geometry column (FME 2022)

Hello. I am in need of dynamically moving data from one spatialite database to another.Both of these databases (.gigdb files) in this case use same schema. However in the example files I have attached one file (DTMK-2022_07_1.gigdb) has one more feature in feature type (table) a0100000321 than the other file. I would like to copy this extra feature to the second file, same table name. I have encountered several problems.Our company uses FME 2021.1.2 -> there the now obsolete spatialite writer does not allow me to create uppercase / camelcase attribute names, so even when manually creating attributes in the writer, it does not allow me to and then I lose them in the translation. Dynamic writing also converts them to lowercase and I get plenty of error messages saying that my schema does not match.Now my second problem: I am trying FME 2022, just released. When trying the new Spatialite writer, now I get correct attribute names, so that appears to be fixed, however I cannot figure out

910

1 year ago

lazarlubomirContributor

asked in General

How to clip 3D solid?

Hi everyone,please, do you have any idea how to clip elements from solid with no volume?For example feature like in attachment?Thanks a lot!Lubo

630

1 year ago

jbeaudoin

asked in Transformers

Is FME working on a way for the Data Inspector to view a Hyper File and/or Reader for it?

I found that after using the Hyper File Writer, that I had no way to open the file and view it in FME, and could only use Tableau to open the file to see the data there. I could not find a Reader for Hyper Files as well.

I was trying to convert geoJSON data for one floor to IMDF. I saw a video regarding the conversion of YVR airport and was wondering is there was a template or existing workflow available that I could refer to to work on the same. Any help is apprecia

290

1 year ago

wisegisContributor

asked in General

Getting R to play nice with FME Server.

I got a good one! I am working with the RCaller transformer and doing some good things on the workbench side. I decided to automate a process for non-R programmers to create ggplots of their sensor data. This process worked great on the ol' laptop, so I migrated to my FME Server. I have worked through the version of R (downgrade) to 4.1.3 per FME documentation. I had to change the default path of the libraries as well to make everything play nice. I have run this file on the SAME server as the FME Server install and it runs without error in workbench on that box. When I run the same file in server I am getting this message: 2023-1-19 14:40:45 | RCaller_2 (InlineQueryFactory): Encountered an error when starting R interpreter. Check that R is installed and that the R interpreter path is set in Workbench's "Translation" settings ( http://fme.ly/rcaller ). Message was: Process failed to start: The system cannot find the file specified.It is at least consistent. I&#39

When using the AzureFileStorageConnector with Authentication - Credential Source: Anonymous what does one set for the Embedded Credentials - Account Name?

If the Authentication - Credential Source: Anonymous why even require the additional Embedded Credentials - Account Name?

1 year ago

gisbradoklaEnthusiast

asked in Transformers

adding new values to a choice user parameter.

I am using user parameters to direct the input and output of a workspace app.the user parameter is a choice configuration with allow choice edit enabled. This does allow the user to type or paste the value required in. I have the allow edit enabled to the parameter.It would be nice though if the checkbox allowed actually ADD(appending) the new value to the parameter list and not just to run the workspace with the new value and then lose it. (edit: I am not sure why but previously the app would not allow me to change or edit the value but now i am able to do that so i assume that was user error)

2410

1 year ago

gcarmichParticipant

asked in Transformers

Categorizing data based on external table with unique lookup min/max values

I have two tables. One with input data the other with unique high/low lookup ranges to categorize the input data. The lookup ranges and input data are numeric values. How can I append the associated data in the lookup ranges table to the input data based on where it falls between the min/max values? I considered AttributeRangeMapper but that will not allow comparison between two tables. Thank you, Gil

1 year ago

sharminn

asked in Transformers

Using JSONTemplater for the first time and i keep getting an error message saying ':Downtown" : pair with the same name already exists in object', and not sure how to solve this.

600

1 year ago

checcosisaniContributor

asked in General

Spatial relator issue line vs points

HiI tried to join two linear datatset using this approachI created (snipper) center point from one lines dataset and then I used the spatial relator to join the info to the 2 lines dataset but due to the mismatch of the coordsys of two datasets(I suppose) the center point doesn't touch the line (see picture)I suppose that this is related to the tolerance during reprojection do you have same experience ? thx PS I solved creating a buffer for the center points Francesco

150

1 year ago

1
...
189
190
191
192
193
194
195
...
1109

Page 192 / 1109

Badge winners

magda_czhas earned the badge Student (Grey)
magda_czhas earned the badge Teacher (Grey)
magda_czhas earned the badge Welcome Back
formflowinghas earned the badge Welcome Back
shweta13has earned the badge Integrate Data with the FME Platform Training

Show all badges

30,461: 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.