- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Best Answers

9941 Posts

Recently active

Most views Most replies

ascollins

asked in Authoring

remove attributes on read

On the FME roadshow someone mentioned there was a way to remove attributes on the reader to improve performance. Unchecking attributes on the feature reader properties User Attributes just seems to hide them but reads these attributes anyway - eg. hidden attributes still appear in Data Inspector. See attached.

4013

7 years ago

mchauvet

asked in Architecture

FME Server 2017: two engines (32 and 64 bit)

I have a FME Server 2017.0 - Build 17259 - win64 and I was wondering if it's possible to have a 32 bit engine (2016 v1.2.1: we need it because the APIC plugin is not working with 2017 version) working together with a 64 bit engine (installer with the server). If it's possible, how can we manage to license all that?Thanks for your help!

7 years ago

danilo_fmeEvangelist

asked in Data

Migration Oracle to SQL Server

Hello,I would like to do a migration between Reader ( Oracle - No Spatial ) to Writer ( SQL Server ).The question is: Its possible to migrate all from Oracle ( primary keys, foreign keys, indexes , views ) to SQL Server? Thanks,Danilo

1110

7 years ago

asked in Transformers

Conversion of DMS to Decimal degree

I am looking on how to convert DMS attached to this question to something like 11.00999945. Any help will be appreciated.Thanks

3472

7 years ago

fmelizardContributor

asked in Authoring

How to formulate the names of existing attributes using values from another attribute?

In this scenario, the source data has some attributes with names following a common pattern. e.g. test (a), test (b), test (c), etc. We want to use all of these attributes on the left side of some test clause (in TestFilter). Instead of manually selecting every attribute, is it possible to use a formula to represent test (a), test (b), test (c)? We do have an attribute "name", whose values are a, b, c, etc. Also, the right side of the test clause can be set with the same expression, for all of these attributes. Any suggestions would be much appreciated!

7 years ago

rclarkenzContributor

asked in Transformers

Validate Date field

I have a date field in my excel document which I am reading into FME that contains a mixture of dd/mm/yyyy and dd/mm/yy. Unfortunately, some of the fields just have the year, e.g. 1951. with no date or month.What I'm trying to figure out is how to find just those features that have a year in the date field and then return only those to the inspector.I looked at AttributeValidator but I see it does not have Date as a Rule configuration under Type.

2015

7 years ago

1011analyst

asked in Transformers

Obtaining all attributes with "null" and "0" values from shapefile?

Hey guys, I am trying to build a model which will give me the "null" and "0" count for a number of attributes from my shp. I have built a model using the attribute validator with the Validation Rule "Not Null" to obtain all Null values coming out from the failed output into a statistics calculator transformer where I have "_count" for Total Count Attribute: under Calculate Attributes. To obtain the "0" values for my other attributes I input my attributes in Attribute Validator and used the validation rule "Contains Regex" with the [0] rule configuration. However this is not the correct was a it will also include subsequent zeros e.g.. "10, 100, 1000 etc." My questions are; is the above method the correct and most effective way to obtain Null values and how can I use the regex function in the Attribute Validator or any other transformer to obtain "0" values?Thanks in advance:)!

163

7 years ago

ujjwalpakhare

asked in Transformers

I would like only to find sliver and overlap polygons. Please anyone help me.

352

7 years ago

sussexpeteContributor

asked in Authoring

How to get the Current Working Folder

Hi.I want to include the name of the "current working folder" (e.g. H:\\00-Data\\FME\\PlanningSitesForGIS) in the body of an emailer so that the recipient can see where a workspace has been run from.I am using the FME_MF_DIR parameter to do this but as it is listed separately from "current working folder" in the log, wonder if this is correct?I would also like to know if the parameters FME_MF_NAME and WORKSPACE_NAME are one and the same?Many thanks for any help

1582

7 years ago

rclarkenzContributor

asked in Transformers

Tester failed, Inspector shows different attribute values

I'm a little confused and hope someone can help me understand why the Feature Information window in the FME Data Inspector shows a value in an attribute, yet the same feature attribute in the Table View shows as <missing>I noticed this because I have a tester that is comparing the nominal focal length fields (one is from a spreadsheet the other is from the database), and this feature is failing at the tester. I knew it had a value in the spreadsheet and database so I used the Inspector to check it.I was stumped because in the Feature Info window, 'NOMINAL FOCAL LENGTH' and 'nominal_focal_length' show the same value, so the Tester should have passed the feature. I then checked the Table View and it shows that 'NOMINAL FOCAL LENGTH' attribute has '<missing>', which must be why my tester is failing this feature.So I'm a tad stumped.

Reader: how to determine if an attribute is exposed or not?

Hi all,the following use case - please see the screen-shot: Is there any way from code side (C++ custom plugin) to determine that "CUSTOM1" shall be exposed (checked by user) but "CUSTOM2" shall NOT (unchecked by user).In the mapping file, DEF line I still see "CUSTOM2" is present.But from another site if I open saved .fmw file - FME WB knows which attributes are unchecked/checked.So FME WB is aware of that - any way to make my custom plugin (Reader) to be aware as well?Thanks!

7 years ago

ngstokeContributor

asked in Transformers

Find the next closest date between 2 attributes

I have a list of attributes that have starting and completion dates listed for different teams. After sorting the starting date column I'm trying to use the first attributes completion date to find the next attribute in the list that has the next closest starting date, then calculate the difference in days. Below is a sample of my dataset. So far I've been unable to find a way to automate this process in my workflow. Any suggestions are much appreciated.

6210

7 years ago

geospatiallover

asked in Transformers

Remove multiple underscores that separates words

I'd like my regex to replace the middle underscores with a space. I cannot seem to escape the underscore character to use with curly brackets for repetitions.I have strings with multiple underscores and spaces as word separators. I'd like my result to look like below: word1_worda wordb wordc wordd_word3Sample strings look like: sample1: Autobooster 1_Autobooster Unit_Unit_Autobooster Unit sample2:Anchor_FIELD_VERIFIED_DATE_NonDisplay With my format these samples should result to: sample1: Autobooster 1_Autobooster Unit Unit_Autobooster Unit sample2:Anchor_FIELD VERIFIED DATE_NonDisplay I used Lookahead and lookbehind and what I'm getting is the middle string with the underscores between word 1 and word 2 and word 2 and word 3 before and after the result. Regex below\\w(?<=_).*_?\\w(?<=_)Test string looks like belowIf I were to finish my translation I have to use StringReplacer, StringConcatenator, and then merge them back again.

File Copy Writer Error attempting to copy from when writing to Biztalk monitored fileshare

Hi, I havethis error using FME FileCopyWriter (runs on FME Server) to copy files processedby FME to a fileshare that is monitored by Biztalk. Biztalk is taking care oftransferring files to a different (and isolated) location. We are currently testing a set of about 100 files(140Mb, mostly shapefile, jpg and wld), the final set would take about 4500files and 40Gb.I use aworkspace that reads from Excel a list of source and target locations, and a FeatureReader(PATH Reader) to read all files at the source location. Finally a File CopyWriter to write each file to the Biztalk target location.Sourcefiles are ready and static, no read/write actions on them. When running theworkspace with Biztalk services turned off things are all running fine.However, when Biztalk services are running, the process crashes with thefollowing error: 2017-08-08 09:33:07| 0.5| 0.0|INFORM|File Copy Writer: Copying file '2016_01w_O10_1_2.jpg'2017-08-08 09:33:07| 0.5| 0.0|ERROR |File Copy Writer: Error attemptin

fmelizardContributor

I care about memory. What do these FME log file messages mean? FME Configuration: Process limits are 32.00 GB of physical memory and 128.00 TB of address space FME Configuration: Start freeing memory when process usage exceeds 96.00 GB of memory or 128.00 TB of address space FME Configuration: Stop freeing memory when process usage is below 72.00 GB of memory and 96.00 TB of address space I like to tell my processes what to do. How can I control the memory FME uses?

222

7 years ago

pinkopoContributor

asked in Data

Create new file geodatabase on writer

Hi guys,I am trying to automate a process which requires to write into a new file-geodatabase everytime i run. is there a way that FME can create a new file geodatabase for my feature classes in a same workbench?Thanks!

Change the width or appearence of lines in the Inspector

Dear FME community,is there a way to change the line width in the Inspector? I assume that there isn't currently such function, because it was suggested here as well:https://knowledge.safe.com/content/idea/28191/inspector-transformer-parameters-for-line-width-an.htmlHowever, perhaps somebody has an idea how to "style" the lines in the workbench, so that they are displayed differently in the inspector. I want to change for example the line width and the appearence, e.g. to have continious or dotted lines. There is for example the MapInfoStyler which we use for MapInfo data sets, but the style is only displayed in MapInfo itself, not in the FME Inspector. Our purpose is the distinguish the original lines of the former dataset and the transformed lines, which are displayed on top of each other in the Inspector. The only way I know is to buffer them, to make the one data set wider, but then they are no longer lines which is not suitable for us.Perhaps somebody has an idea of

1344

7 years ago

mygisContributor

asked in Data

FME Cloud - Running Scheduled Job during an FME Cloud Running Scheduled Instance

Hello,I am curious to know if the Scheduled Instance on FME Cloud would terminate a non completed job in FME Server.In this theoretical scenario I would schedule the FME Cloud Instance to be activated let's say at 10 a.m every day and that the FME Server Job would run at 10:15 every day. Under normal circumstances it would take 30 minutes to run the job and my FME Cloud Instance will be deactivated at 11 a.m . But what would happen if the FME Server Scheduled Job one day takes 1h 30 m to run, would FME Cloud Scheduled Instance wait for the job to complete? Thank you.Lyes

annette2Contributor

Hi,I have received a text file to convert to polygons with donuts but I am unfamiliar with the format. Does anyone have any experience with a file with the following header:Version 780 Charset "WindowsLatin1" Delimiter "," CoordSys Earth Projection 20, 109, "m", 5.387638889, 52.156160556, 0.9999079, 155000, 463000 Bounds (13558, 306866) (278118, 619026) Columns 1 RxLev Char(9) Data Region 789 36733 278118 583666 278038 583666 278038 583746 278038 583825.9999 278038 583906 277958.0001 583906 277958.0001 583986 277878 583986 277798 583986 277718 583986 277638.0001 583986 277558 583986 277478 583986 277478 583906 277398 583906 277398 583986 277318.0001 583986 277238 583986 277158 583986 277158 584065.9999 277078 584065.9999The end of the file has the following information: 7 16518.0001 365666 16438 365666 16438 365585.9999 16438 365506 16518.0001 365506 16518.0001 365585.9999 16518.0001 365666 5 199958 461506 199878 461506 199878 461425.9999 19995

134

7 years ago

howard_l

asked in Transformers

Expression Evaluator - RegEx Feature Function Syntax

I'm trying to use the FindRegEx Feature Function within the Expression Evaluator Transformer.Does anybody know the correct syntax to use ?Documentation on this seemed a little thin on the ground / no specific examples...........................I'm trying to do a search in the field: [Category]using the RegEx expression: 0[0-1][0-9]I tried the following - but no luck:@FindRegEx (@Value (Category), 0[0-1][0-9])............................Any ideas - most welcome.............................RegardsHoward L'

3213

7 years ago

asked in Transformers

Code Repository For Managing Scripts Across Servers

In a situation where multiple FME servers are spun up and run standardized workbenches, what's the recommendation for managing helper scripts? We have a set of Python scripts that aid the startup/shutdown of these workbenches. But having multiple servers, it is difficult to ensure the versions of these scripts are the same across the board. Anyone have any recommendations for a code repository? We do have a subscription to Visual Studio Team Service. If anyone has used VSTS with FME server, I am interested to hear about your experenice in that as well.

155

7 years ago

fmelizardContributor

asked in Transformers

How can I move a solution from my development environment to the test environment and ultimately production?

We are risk averse here at Lizard Inc. and we utilize a a three stage dev/test/prod environment to ensure that no bad code or configurations get into our production system. Production must work!!How can we move a working solution from an FME Server development installation to a testing/staging installation and ultimately to our production install?

How to insert image into excel files by FME2014?

asked in Transformers

Using IN command in InlineQuerier

I have two datasets that I am currently working on:1) DBF12) DBF2I need to lookup for Description (in DBF1) in DB2 within the columns I1 to I8 and >> to return the corresponding DMA to Inflow field if a match is found OR>> to display a space if no match foundThe result would look as follows:Currently, I am using the InlineQuerier with IN statement, but it truncates the result when there is no match. The NOT IN command displayed irrelevant results as well.Please suggest a solution which may be SQL or Non SQL based.

7 years ago

fmelizardContributor

asked in Transformers

How do I compare tables with mismatching schemas when using the UpdateDetector?

I have two datasets to compare: an original table and a revised table. I want to pass them through the UpdateDetector to track Updates, Inserts, and Deletes. The two tables are linked by a shared primary key attribute, and I want to track changes that may exist in another attribute; however, the original table has an extra attribute, ExtraID, which does not exist in the revised table. For features that exit the Updated port, this ExtraID loses its value. How do I retain the values in ExtraID and prevent them from exiting the UpdateDetector as NULL?

7 years ago

Page 312 / 398

Badge winners

lukasbutzmannhas earned the badge Welcome Back
lukasbutzmannhas earned the badge FME Form Advanced Training
cliffordgraves1has earned the badge Webinar Watcher (Grey)
cliffordgraves1has earned the badge Welcome Back
farah.dahmanehas earned the badge French Speaker

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.