Best Answers

Hi there,I'm copying a table to other table in different oracle database. When the copy finishes, I need update a state field in source table (reader). How a reader could be transformed to a writer?

Hello.Currently I'm using the FeatureWriter to update my file geodatabase. It's running at a rate of 18 features per minute, and is comparing 13,998 features against 1.2 million in the dataset being updated. I'm running a test of this process on a group of features which is a good representation of what a typical update will be in terms of feature quantity. Is there any way to speed this up?Thanks.

Hi all,Today I stumbled upon an issue with the ChartGenerator. I'm using it to create histograms of data from 17 data sets. I'm using a workspace runner to batch process and create the histograms with the ChartGenerator transformer, but writing the output to file using fme_basename is not possible. Can anyone guide me to a solution where the 17 generated histograms are written to unique png-files? 

I'm trying to write a custom transformer with a python script that looks at the Public Parameter.There is a lot of trial and error going on but I think I'm doing it as it should now. This helped me getting started:https://knowledge.safe.com/questions/44873/getting-published-parameters-from-within-a-python.html The transformer works if the Public Parameter is set to a fixed value or if it is set to a feature attribute value. But when there are two instances of the Custom Transformer it looks at whatever starts first. So the second transformer uses the fixed value of the first transformer. custom_transformer_name = 'MultiInstanceBug'parameter_name = 'codeLength'instance_name = FME_MacroValues[custom_transformer_name + '_WORKSPACE_NAME']mv_codeLength = FME_MacroValues[instance_name + '_' + parameter_name]if mv_codeLength[0:6] == '@Value':  codeLength = int(feature.performFunction(mv_codeLength))elif mv_codeLength[0:6] == '@Evalu':  codeLength = int(feature.performFunction(mv_codeLength))e

I have Feature layer which is made with FME at AGOL. Now I would like to update that layer, but translation fails every time. I am using Esri ArcGIS Online (AGOL) Feature Service writer and Format Parameters are Writer Mode = INSERT, Truncate Layer First = YES and Rollback On Failure = YES. I think that it should work with those parameters. If I delete layer from AGOL, then it works fine, but if I don't delete layer, then translation fails. I would not like to delete layer manually. How to update AGOL Feature layer with FME?

I have a esri geodatabase that I'm trying to translate to a "Mapinfo" table. It is successful if I limit the max features to a million records, but the geodatabase is 2 million records and I keep getting the following error (see image). I'm running FME on a Windows Server 2008 machine. It has 2 XEON (E5-2670 v2) processors and has 10GB of RAM installed.I've set the temp folders to the Secondary "D" drive. Not sure why this is happening, as this wasn't an issue when I was running FME 2013. Since upgrading to FME 2018 this has become an issue.  

I'm trying to figure out how to use the directory watch on various user folders. The idea is when they update datasets it kicks off a job updating automatically.

I'm currently watching Folder1 and processing the data that is put there in dated folders.Folder1201811102018111120181112etcEach dated folder contains 3 subfolders (A,B,C) each containing a lot of shapefiles. The current system works fine as all the data is written at the time the dated folder is created. However this is soon to change and A, B and C could be written separately. I only want to process the data when A, B and C are all present.I've tried editing the Publication to include subdirectories but this notifies on every shapefile, I've also tried just using Modify instead of Create but Modify doesn't seem to work on Folders, only files.The only workaround I can think of is to have all the contents of A, B and C zipped before hand and thus limiting the number of notifications. But this isn't very elegant. Am I missing something?Many thanks!

Hi,I´m trying to create an XML-file from an excel sheet.I have an xsd-file to create my header information in the ROOT-Template and it contains a number of prefix (namespace) definitions (not sure about the correct names here). When running the workspace it works fine using prefixes in the ROOT Template part but when using the same prefixes in the SUB template I get an error telling me it is not defined. Can I make the SUB Template recognize the definitions in the ROOT Template or can I somehow define them in the SUB Template but not writing it out in the _result attribute in the sub-part of the xml-file?

Hello,I have 2 Shape files, one point, other line. I need to determine on which side of the line point feature is located. I need to take only points that are within 5m of line. For every point I need to add new attribute that will allow me later to separate right and left.Orientation of the line is determined by start and end point of the line.This is way out of my league so I need Your help.

I am looking to do an initial extract of a utility customer's Intergraph data to Smallworld using FME workbench. Is there a way to do an incremental extract on a nightly basis, without completely reloading the entire database?In other words, is there a way to identify daily changes in Intergraph data (ie time stamp, versions, etc) ?@MarkAtSafe

Hi all, I hava a question about FME Cloud Server.Could I FME Cloud Server trigger on demand? It's meaning when I use I will run it and finish will be turn offThank you

I have a set of points and lines that I need to collectively scale down using the Scaler. I am combining all features using the Aggregator, scaling down, and then Deaggregating. The features are retaining the original attributes, but all features are getting the attribute values from just one of the features. I am needing the features to retain their original attribute values after the Deaggregator.

I have to write some data to a XML-File, that's afterwards transformed to a HTML-Page using xsl.  One attribute in my data is an image, that's encoded in base64. In xsl it gets decoded and displayed in HTML as png.  This works fine, but now I want to make sure, that this image is of the correct size (height/width). Is there way, I can do this with FME?Thanks, Vera

Hi all. Is it possible, like in traditional programming, to create functions or subroutines in FME, when you have a piece of common FME coding you want to reuse and execute several times from a workbench or from different workbenches i.e logging of certain events or error situations. If so, please let me know, how to do it.

This morning I worked with FME Desktop V2017.1.0.0 (b 17539). Suddenly I get a message: Creating reader for format: Oracle Non-SpatialFile D:\\apps\\FME\\metafile\\.fmf could not be openedI read in the known issues We've fixed this issue for FME 2018.1. This issue was a problem with showing Oracle table list in the DatabaseJoiner.Ik have the same message with SQLCREATOR.- wich metafile FME tries to open? Can we replace this missing file?- Is this the same error in DB Joiner as I also have in the sqlcreator?- is there a workaround available (I have tried to create an new DB joiner and even copied the whole WS to a new WS and replaced all DBjoiners but that does not work).(- install fme 2018 will happen in a month or 2, but I can not wait so long or I have to escalate this issue to our manager with priority.)thank you for your reply

I am trying to convert a three character month to a two digit month (e.g. - Mar to 03) using FME 2016.1 (build 16492). Should be easy enough using the DateFormatter but the converted value returned is always 01. I think my parameters are set up correctly. Screenshot attached. Any ideas?Thanks,Aaron

I try download file in resources path using rest api, using get method:http://myhost/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/geodados/Bairro_Popular.zip?fmetoken=2c537eb21c3ff7b5e0d64be0d6a02b10f149a5b5 but my response is:"message":"null for uri: http://myhost/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/geodados/Bairro_Popular.zip?fmetoken=2c537eb21c3ff7b5e0d64be0d6a02b10f149a5b5"}My file is in Resources > Data > geodados > Bairro_Popular.zipMy user has permissions. Does anyone know the reason for the error?

Hi, I have a table containing Id's and url's referring to online pdf's. For each record in the table I want to search a specific string in the associated pdf. If the string has a match in the pdf, I want to retrieve the Id from the record containing the url to the pdf. I tried using feature reader en pdf reader but didn't get far. So any help would be welcome.Idris 

Hello therewe have exported a GDB to XML and we want to extract the dataset name the filed type, domain name, and in another table the domain name and domain value, this information will be used for mapping purpose    

Hi, I try to open an XML file downloaded with the SentinelDownloader but I get this error:  Loaded module 'SENTINEL2' from file 'C:\\Program Files\\FME\\plugins/gdal/GDAL.dll'FME API version of module 'SENTINEL2' matches current internal version (3.8 20180604)SENTINEL2 reader: Opening dataset 'C:/4-Igual que 3 pero bajando ALL/all/S2A_MSIL2A_20181103T111221_N0209_R137_T30TVK_20181103T122857.SAFE/MTD_MSIL2A.xml'SENTINEL2 reader: Cannot find =Level-2A_User_Product.General_Info.L2A_Product_InfoSENTINEL2 reader: Failed to open the dataset 'C:/4-Igual que 3 pero bajando ALL/all/S2A_MSIL2A_20181103T111221_N0209_R137_T30TVK_20181103T122857.SAFE/MTD_MSIL2A.xml'. Please ensure source data is valid and correct reader is selectedA fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'SENTINEL2' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, depend

Hi all,I am trying to create a workspace to automatically review other workspaces to ensure they meet our development standards and guidelines. One of these standards is that all connections used should be in the master connections file we all share. Which reader do I use to read the fme_connections.data file and get a list of the connection names? A standard text reader returns a load of #$@#@!# so I assume it's encrypted somehow?Thanks in advanceJames

Hello there!Into FME Server 2017.1 I have some process failing for some reasons and I get the error into the log.But when I look at the process status, it's Completed. Then, I don't get any notfications alerting me about this.Shouldn't I receive a Failure message instead?i could put an Emailer into my workbench, yeah, I know, but I would prefer the FME Server notification.Into FME Desktop I get the Failure message though.2019-01-03 17:03:36| 203.7| Â 0.0|ERROR |A fatal error has occurred. Check the logfile above for detailsthanks

I'm hoping to use the Emailer transformer with FME Desktop to send an email with attachments using Microsoft Exchange via Outlook Web Access. Should this be possible using this transformer? Or maybe using some other method?

Hello, I am new in FME.I need to create a KML that contains a set of placemarks with every jpg geotagged photo.INPUT: Set of jpg geotaggedOUPUT: KML with photo icons that I clic and show me the photo in a window. Thanks for your answers.