Skip to main content
  • EN

Best Answers

10386 Posts
K
khk
asked in Data
copy external files based on result names

Hi, I want to copy files based on workspace result values. Example: a, b, c builders are applied for tenders of xyz road construction. All 3 companies tenders are integrated into one document and named as xyz road (its same as fme workspace result road names)so when fme workspace result record contains xyz road, then pickup "xyz road" excel/pdf tender files and copy them into a specified folder path (or create new folder and copy files). Any guidance on how to check the result road names with external files present in a directory (Lookup tables?)? is it possible in an easy way to automate it ? How can i compare result and copy respective files into a specified folder. Any guidance is helpful.Thanks,khk

226
K
mark2atsafe
Safer
mark2atsafeSafer
asked in Transformers
DateFormatter vs TimeStamper

I just noticed that the TimeStamper uses the format:  ^Y, ^M, ^D  ...whereas the DateFormatter uses:  %Y, %M, %D  Has anyone else noticed? Does it bother you? Do you think they should be the same prefix (probably %)?

1110
takashi
Celebrity
J
jtalero71
asked in Data
Synchronizing GIS and CAD (DGN) with FME -- can it be done?

I am a newcomer to using FME products. I have been reading several documents relating to my question. However, I would like to have an answer directly from your staff.We are a two shop software (Bentley Product) MS – used by our designer. GIS – used as an asset management tool.At this time we are also maintaining our assets data in MS as well as in GIS. The purpose for this practice is that our designers are able to consume the historical data while designing a project from our MS asset registry data repository. This process is becoming a lot more Painstaking an enormous amount of work for our MS and GIS staff as well as major duplication of effort. My goal is to be able to maintain one assets data repository (GIS) and have our designer consume this data in the MS environment thru a conversation/extract tool from GIS to DGN. At the same time, thru transformation, be able to maintain and display the feature Standard developed by our designing staff with the collaboration of Bentl

92
C
N
nicole
asked in Transformers
Test whether a line is contained in an existing dataset of lines

I have following Problem:I have a dataset of different lines and I create a new line with the "Creator". Now I want to test wether the crated line allready exists in my dataset. If the line doesn't allready exists, I want to edit the existing data and the new line separatly. I tried to use the "Matcher". But if the new line does not already exist, it can no longer be separated from the existing data because there is only one common output for 'NotMatched'.I hope somebody can help me.

92
N
R
rhalko
asked in Authoring
How do I setup MSSQL_ADO reader? It is not in my gallery.

I am just trying to read from an MS SQL Server non-spatial database, but the reader is not available in my list. I am fairly new to FME and cannot find the reader described in the documentation as "MSSQL_ADO". I have "MSSQL" but it doesn't allow me to enter parameters. What am I missing?

293
ravenkopelman
Safer
G
garnet
asked in Authoring
What is a controller in therms of workbench? Is that only a term?

HiI am new to FME. Coming from ESRI background and FME terminology is new to me.I have 30 or so workbenches - some of them are called something_controller and other of them are called something_runer They see to be just regular WBs - doing some stuff to data. I don't see any relationship between a controller WB and a runner WB, e.g. controller calling the runner in any way. Being new I am not sure if this is at all possible.So do the naming suggest any relationship between WBs or this is just a term in the naming?Thanks

75
davideagle
Contributor
michaels
Contributor
michaelsContributor
asked in Authoring
Startup Python script: How can I create an empty file?

Hihow can I create an empty txt-file with the python startup script?That file has to be into the same directory, where the data in the workflow will writen to. So I will need the "DestDataset_SHAPE" as the directory and "LTYP.mif" as the filename.Thanks very much for your support.

464
david_r
Celebrity
redgeographics
Celebrity
redgeographicsCelebrity
asked in Authoring
Go from "local" named connections to shared named connections

I have a couple of named connections set up in FME Workbench and they're currently stored in the default location (wherever that may be). How would I go about migrating those to a shared set of named connections on a network drive?At first I was able to right-click on a named connection, choose export, save it as a .xml file, then specify a named connection file in the Default Paths tool (which creates an empty one) and import the .xml file there, but after a restart of FME Workbench that right-click option has disappeared. Happens on both FME 2015.1.2 and 2016.

92
redgeographics
Celebrity
J
jphillip
asked in Data
Shape (latitude and longitude) identification

Converting a shape file to a MySql table and all is working with the extraction of each attributes except i can not identify the latitude and longitude values that represent the point geometry. Can any one help me with how I identify and split out the coordinates in a shape file. thanks

121
takashi
Celebrity
T
t1
asked in Transformers
Filter out features when an attribute appears in another table

I have a table called "alternate street names" that contains values such as: NORTH, NORTH MILL, NORTH, DRIVE, MILL, MILL DRIVE, DRIVE. (These are the permutations of 'NORTH MILL DRIVE'.)I also have a table of "exclusions", such as: AVENUE, STREET, DRIVE, NORTH.The objective is to only write the rows from "alternate street names" where the alternate name is not in "exclusions". Also note that the "exclusions" must be read at run time.I did a lot of searching and trying different transformers, but could not get anything to work. This seems like a very simple task and I'm just overlooking something.

3364
T
arnold_bijlsma
Enthusiast
arnold_bijlsmaEnthusiast
asked in Architecture
Upgrade to 2016 - bug in user parameters?

I upgraded from v2015 to v2016 today, and I have noticed that a user parameter that is derived from another user parameter is not upgraded properly.In the attached Workspace, I am creating a SiteName parameter based on the input filename. And I also create a SiteNameGDB parameter for the output filename, based on the SiteName parameter. Unfortunately, when opening this workspace - which worked fine in v2015.0 - in v2016, it has replaced the expression $(SiteNameGDB) with the literal string "__SiteNameGDB_"Is this a bug?

106
arnold_bijlsma
Enthusiast
G
guy
asked in Authoring
Error : FACTORY_NAME

The clause 'FACTORY_NAME AttributeCreator ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV' within 'FACTORY_DEF * AttrSetFactory FACTORY_NAME AttributeCreator ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV INPUT FEATURE_TYPE StringConcatenator_2_OUTPUT ATTR Nom_dossier Pentes_des_pistes OUTPUT OUTPUT FEATURE_TYPE AttributeCreator_OUTPUT' is incorrect.  It must look like: FACTORY_NAME <name>  This error just appeared. It's the first time I see this and I don't understand it at all.  It appeared with a script I've been using for a long time without any problems ; until now.  Please can someone tell me what this is about, it's urgent ! Thanks

844
erik_jan
Contributor
pushpa
Contributor
pushpaContributor
asked in Authoring
Strings with numbers

I have a Shapefile with 9000 records and one of the attribute columns contain strings (numbers and letters). Column width is set to 4 characters I need to find all records with last character is a "letter" and delete that letter.ie: ST4WS4WAbove records I would like to delete "W" from the recordsCould someone help me to do this using FME?thanks

895
davideagle
Contributor
ddecoene
Contributor
ddecoeneContributor
asked in Authoring
workspacerunner - how to 'catch' all items created

Hi all,I ran into the following problem:i have a workbench which has a workspacerunner, which calls several child workspaces. Each childWS will created a file: <xxx(number).dwg> . The duration for each childWS is different (some take seconds, some 15min). Behind the workspacerunner there is a featureholder followed by a custom transformer which is the combination of a decelerator (timing every 30sec) and a FileExistancechecker in a loop. In the end all dwg's are grabbed and thrown into one big file.My issue now is that i would like to speed things up. Now i have about 70 child WS so right now i'm waiting about 35min for all things to go through the decelerator. (i wish to increase the amount of child WS, setting the timing to a value less then 30sec is not good because <xxxF(number).dwg> are then missed to be thrown into the big file in the end.Setting the workspacerunner to wait for job to complete makes me miss the multicore speed. Setting the value to 'no&#39

4712
ddecoene
Contributor
K
khalid_omer
asked in Transformers
Spatial filter performance

Dear All ,   We face a performance issue in spatial filter when both candiate and filter having more than 150K , as shown below , it is taken more than 2 days and still running . below is part to the log files  2015-06-16 11:11:48|168167.0|  7.0|INFORM|SpatialFilter_13(SpatialFilterFactory): Processed 'Candidate' 118233 / 150608 2015-06-16 11:11:56|168174.1|  7.2|INFORM|SpatialFilter_13(SpatialFilterFactory): Processed 'Candidate' 118236 / 150608 2015-06-16 11:12:01|168179.0|  4.9|INFORM|SpatialFilter_13(SpatialFilterFactory): Processed 'Candidate' 118242 / 150608 2015-06-16 11:12:06|168183.9|  4.9|INFORM|SpatialFilter_13(SpatialFilterFactory): Processed 'Candidate' 118243 / 150608 2015-06-16 11:12:11|168188.2|  4.3|INFORM|SpatialFilter_13(SpatialFilterFactory): Processed 'Candidate' 118255 / 150608

536
A
R
rob_f
asked in Transformers
raster - outofmemory exception

Hi,I get an OutOfMemory exception with raster transformer.Input file is just 300MG TIFF (uncompressed). Transformer is ReframeReprojector (coordinate system transformation). In TaskManager I can observe that FME gobbles up memory quickly and runs out of memory after less than a minute. What can I do? (I'm not overly familiar with FME).W2008R2, 6GB, FME 2014 SP4, W64Thank you, Rob

83
R
krist
Contributor
kristContributor
asked in Transformers
Why does the Clipper transformer default to creating aggregates?

I am curious why FME's clipper transformer creates aggregates by default. I would think that the this parameter should be set by default to "No". Many data formats can handle aggregates but there are many situations that this will cause major issues. My habit it to change this parameter each and every time I add a clipper. And newer users of FME may not know about this clipper parameter or know what it does.

255
gio
Contributor
P
philip_nelson
asked in Transformers
Can you provide a 64 bit version of the GridInQuest transformer?

Can you provide a 64 bit version of the GridInQuest transformer which I use all the time but have to use the 32 bit version. I know this depends on GridInQuest providing the dll but it is vital for me. The only option for me is to install 32 bit and 64 bit and use the 32 bit for any transformations using GridInQuest

92
davideagle
Contributor
dfresh
dfresh
asked in General
Converting FME 2014 SP1 workbenches to 2016?

I have about 15 FME 2014 scripts, that I want to convert to 2016, obviously this is a huge jump, any obvious examples for making this update much easier?thanks,

31
erik_jan
Contributor
B
breton01
asked in Transformers
How to Detect a Schema difference (Dataset1 has X attributes, Dataset2 has X+or-n attributes)

Very much a newbie. I'm somewhere around week two of actually touching FME. Have Searched the Transformers and Knowledge base and found close but not quite workflows.Two Datasets. One published, one to be published (updated). Need to compare the two. If # of attributes changed(addcol/deletecol) between the two, stop on error. Not caring so much about # of Records, data gets edited so those can change, care about attribute additions/deletions. This is step0.1 of a potentially complex data validation process that will likely take quite some time to develop the full flow. But need to start from somewhere.Tester - pass = Both files have identical # attributes, and attribute type.tester - FAIL = Different # of attributes, AND/OR attribute type difference existence of fail halts process with error - "Illegal Schema Change". Thought this would be a easy fast one to come up with....not so.Thanks so much in advance, I'm going to keep trying different things, If I find

1031
erik_jan
Contributor
M
miladahmad
asked in Transformers
How can I copy vertices at lines intersections (not segmented lines)

Hi all,I have a file with polylines which intersect but not segmented at the intersection and I’d like to find the vertices coordinates or have a points file from this vertices.. Any idea?Thanks

277
M
danilo_fme
Evangelist
danilo_fmeEvangelist
asked in Transformers
Create a heatmap in FME using Python

Hello all users,I saw at Internet a library in Python that create a heatmap http://jjguy.com/heatmap/.In my opinion doenst have a problem to import this module into FME. Somebody works in FME to create heatmap using the transformer PythonCreator?Thanks in Advance,

552
danilo_fme
Evangelist
E
ericarmitage
asked in Authoring
String Value to integer in Python

Hi. I have a table with an attribute with string values such as "39.1234". I'm trying to extract the integer of this to a new attribute using Python. So something like this import fme import fmeobjects def processFeature2(feature):  vStartMiles = feature.getAttribute('Start_Mileage')  vStartMiles2 = int(vStartMiles)  feature.setAttribute("Start_Miles", vStartMiles2) However, this code gives the following error and i've tried various other options without success. Any ideas how to to extract the integer from a string with Python? Thanks

665
J
A
Anonymous
asked in General
Add Transformers to Toolbar

FME used to have the ability for the user to add transformers to the toolbar. I found this quite useful because I can just click on the icon for AttributeCreator and not have to type it. Is this functionality in 2016? I don't see it.Thanks

72
fmelizard
Safer
L
longhornfan
asked in Automation
Notifications on FME Server

I was just curious if anyone might be able to shed some light on an issue that has now popped up after switching everything to smtp.(company name).com yesterday under Manage --> Notifications --> Subscriptions.We get daily updates from jobs that run overnight, and we were still getting them from smtp.(company name).local. But since changing all of the values yesterday to smtp.(company name).com, we got no messages or updates from FME Server last night. Can anyone shed light on why this might be happening? Can you look at the attachment containing the before and the after settings (SMTP Server is all that was changed) and let me know if we need to change anything else about them to allow the messages from FME Server to come through? Thanks in advance for any help you can provide.Tony

123
L

Badge Winners

Show all badges

Community Stats

31,802
Posts
120,809
Replies
39,420
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.