Authoring

I am using the FME Httpcaller to get data from an API. There is an issue with the API and some of the calls are rejected with a 404 Not Found Error. I am using the Error logging option in the FME translation but i wish to exclude this particular error. Is there any way to exclude certain errors from being logged in the Error log in FME?

Hi,For each feature in my dataset, I have two lists: one containing labels and one containing values.label{0}: IDlabel{1}: Namelabel{2}: Typelabel{3}: Countryval{0}: 1val{1}: Groningenval{2}: Placeval{3}: The NetherlandsThere may be more or less items in both lists. The contents of `label` may be completely different. But `label` and `val` always have an equal number of items.How can I dynamically create attributes from these lists, with the contents of `label` as attribute names and `val` as attribute values? 

It's slower on the machine that is supposed to be faster!

Hello,FME 2017.1.1.1 build 17652, 2017.1.2 beta build 17717, 2018.0 beta build 18208The scenario is:The source dataset contains multiple feature types. e.g. "A", "B", and "C".Read every feature from the source dataset and simply write them into Shapefile files for each feature type separately, with the same schema as corresponding source feature type.Here, the destination dataset (folder) names should be the same names as the source feature types. i.e. "A", "B", and "C".And all the destination files (feature types) should have an identical name. e.g. "output.shp"In fact, the names and schema of source feature types are unknown when creating the workspace, so you want to configure Dynamic Schema and Dataset Fanout.It's easy to realize this using FeatureReader + regular Shapefile writer with Dynamic Schema setting and Dataset Fanout configuration.

Dear All,I have three workbenches,First one is for taking backup data and Second one is to check the value of one field with two cases and published in FME server.Third workbench is for to run above workbenches in sequences using FMEServerJobSubmitter transformer.My query is second workbench Status attribute value need to bring into Third Workbench when second workbench failed through FMEServerJobSubmitter Failed port.Please advice to achieve this task.Second workbenchThird WorkbenchThanks in advanceVenu

Hi all,Firstly I found this post: https://knowledge.safe.com/questions/5094/create-column-names-from-column-values.htmlBut it hasn't answered my question fully.I have multiple shapefiles containing points. Each point has a VALUE field and a unique ID field which is the same across all the shapefiles. The end goal is to create a spreadsheet with the unique ID field and a field name containing the date of each shapefile populated with the VALUE field. The name of the shapefile contains the date so I am using substring extractors and a concatenator to build the date.I followed the guidance in the previous question and am using an attribute creator to create the date field and populating it in the same stepAnd an attr

Hi all,I try to access the GDAL library via python to use a format (namely esri personal geodatabase) which my FME installation / licencing doesn't support. GDAL 2.4.0 and Python for GDAL are installed (everything under 32bit as my Microsoft Access driver is a 32bit installation, according to the manual https://sandbox.idre.ucla.edu/sandbox/tutorials/installing-gdal-for-windows). In my Command Prompt everything works, except the connection to a *.mdb. The error says:ERROR 1: Unable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=PGeo:electricite.mdbIf you have any advice on this, I'm grateful. Of course I'm checking my drivers, but couldn't find any inconsistencies yet.Well, my main problem is to access the GDAL library within FME PythonCreator. How do I import it? I

i have problems to configured. i dont know that name to gdb put in. becasue i conect from Arcmap, only see the folder what i can conect. but the name gdb ¿? what can i do?

I have a workspace that is using an embedded custom transformer. I have made a change to this custom transformer (in the fmx file) and saved it as a new version or I have overwritten it. In this case I normally get a prompt when opening my workspace to update the custom transformer to its latest version. However, I don't always get prompted - sometimes the embedded transformer stays unchanged and I can't see a way to update it to the latest version without removing all instances of it and replacing them all with the latest version (replacing one by one does not work either as the transformer definition is retained until I have removed all instances).Hence my question: How can I update my custom transformer manually to its latest definition which is saved in my shared FME folder? 

Dear Community! A thing which bothers me since a long time and I couldn't find any similar thread in the knowledge center: I have very large workspaces where multiple "things" are done with data.Quite often I have to use the same Feature type (of a reader) multiple times in this workspace at different locations. Is there any way to use the same datasource (feature type) at multiple places in a workspace? Only workaround I see would be to use a feature reader on these "different locations". Problem with this is, that I want to quickly switch data-sources, and using a feature reader you have to remember to change the datasource there also...  So, best way for me would be the ability to "copy" feature types (of a reader). Any alternative way to achieve this? Thx and beste regards from switzerland, Chris

Hi all,I have 20 MBTiles of the same area that I have produced following this post: https://knowledge.safe.com/questions/41760/how-to-convert-tiff-to-mbtiles.html, so every MBTile contains several zoom levels corresponding to the input image (TIFF file).For every MBTile I have used different source files (TIFF file) corresponding to the same area but with different resolutions.I would like to extract the maximum zoom_level of every mbtile generated and merge into a single one.I can do that with a very simple python script using sqlite3 but I would like to reproduce with FME 2018.1 because is one part of a whole process. Until now:1. I can merge several mbtiles into a single one IF the input mbtiles have ONLY ONE zoom level (so no selection is made).2. I can read all mbtiles contained in a directory, select for eac

There's a number of other similar posts out there, but I can't seem to find a solution that works. I'm still trying to build a workflow for this on my end, but I figured I'd post here to see if anyone knows of an easy solution.I have data in a table that looks as follows...IDSecondary ID1ABC1231DEF3451GHJ6782DEF3452XYZ7893VWX5674ABC123 And I'd like to transpose this across a spreadsheet so that it looks as follows...IDSecondary_ID_1 Secondary_ID_2Secondary_ID_31ABC123 DEF345 GHJ678 2DEF345 XYZ789  3VWX567   4ABC123    The problem I'm hitting a wall with is that there may be any number of Secondary_IDs for a given ID...potentially a couple hundred for a single ID. So, I'm looking to have a tabular data set in the end that may have a couple hundred columns, with a single row for each ID. Is this possible? I'm

Since upgrading to FME 2018 (32-bit version), I've been getting intermittent connection errors when using either my database connections or web connections.There are times when I run my workspace without any issues, but subsequent runs may, inconsistently, produce connection errors.If I go into my Database Connections or Web Connections through FME Options, I either get "Error retrieving connections", or it's "unable towhen the Testing the connection the test fails as it's unable to connect (i.e. "Unable to connect to Oracle database, because the database environment could not be initialized".

Is there a generic way to extract the feature count for each feature type in the writer? For example, I would like to capture this information either in the same workspace, or from the log file's Feature Written Summary section. I would like to capture this info for each updated feature type to a central location for review and reporting. Most of our FME processes are running on FME server.

This might rather be a simple task, but so far i have no clue how it works to merge and concatenate joined_list elements. I want to concatenate the two element values into one string and at the end write all the list elements out into one attribute.Result should be {KA:28,KA:12,KA:4}

The issue I am having is that I want to read in only 1 feature per and therefor end up outputting only 1 feature per type without breaking the already established connections. I have a feature reader with 300+ types of features setup/with connections across a massive work space. If I change the parameter in the FeatureReader to "1" for max features to read, it asks me to select a workspace. Each .dxf "workspace" has only a couple features, but combined with the remaining 100's of .dxfs I get all of features I need. So when I select one dxf "workspace" it only provides x amount of features. If I hit "cancel" at this point then all the features in the reader go away. The "PATH" is setup to parse through all of the .dxfs in the folder. Is there a way to change that parameter in the feature reader without breaking the already established connections?    

Just going through the motions of upgrading an FME Cloud instance and I'm looking for a way to migrate the job history into a new instance. I know, however, that this isn't supported with the backup and that some db work is required (https://knowledge.safe.com/articles/816/fme-server-job-history.html) The problem is that I can't seem to access the fmeserver schema.   My work around will be to use the REST API to get the data and create my own job history table but I would rather avoid that if possible. Am I missing something here?

I have hit a wall. I realize that job downloader in FME Server will zip the files but I am in a situation where I must use Job Submitter, but I need the final results to then be zipped for download. The entire problem originates from a need to use custom projections for the shapefiles. Here is the process:read in CADD files and other data from Excel filesProcess the information and create Shapefiles using FeatureWriterRead in the custom projection and write the prj file into the shapefiles using FileCopy writer.This saves all of the shapefiles as individual files. Since I might have 15 shapefiles, at 8 files per shapefile, I end up with over 100 filesto download. I would like to then zip up all of the shapefiles to make one easy download either for each shapefile or, preferable, for the whole batch.Please note - I am using job submitter because the prj file cannot be added to the file created in data download.DGN2GIS_Step2GB_C

I'm having some trouble with the WorkspaceRunner transformer in FME 2018 windows 32 bit.Say Workspace B contains a FeatureReader transformer. In Workspace B, create a published parameter called FileList with a filename (Multiple) and set this as the dataset field in the FeatureReader to read txt files. Set the value of FileList to C:\\temp\\a.txt,C:\\temp\\b.txt. I have no errors running workspace B as is. Using FME 2018, I trigger workspace B using a WorkspaceRunner in Workspace A, I get an error which highlights the paths in the Filename (Multiple) parameter are not valid. It is using the same value as FileList (C:\\temp\\a.txt,C:\\temp\\b.txt) that is used in workspace b published parameter.It seams that the WorkspaceRunner doesn't send through the FileList value correctly in FME 2018. I have examined the log files and can see that in 2012, the Command line arguments are different. See below for differences (notice the qutation marks mis

@takashi I am not getting any output from my OSMDownloader. 0 features are returned. I have tried switching my coordinates to make sure I am placing appropriate values in min/max and x/y. I tried reducing my extent significantly to a .05 difference in height and width. Unfortunately, I still get no features from the OSMDownloader. Any idea as to why? I am relatively new to FME.

Sometimes I really need to use a Group By in a transformer, but the parameter is not available. Is there anyway I can hack it?

I am processing a directory of XML files. I have set the source dataset to just .../*.xmlHowever, I would like to save the results according to the source Filename. How do I set the output filename to be the same as the input filename?

Hi everybody, it seems to be an easy job, but at the end it is taking a lot of time to implement. I have patterns in my oracle database to access and read multiples Excel files, which contains several sheet. When i access to this database, i get the filename, i cannot call directly the Reader for excel passing the name, sheet name and format.  I did some experiment with subroutines (like external calls) but it seems more complicated than expected. How can i read Excel files whose name is in the database without calling another workflow ? which is the logic standing behind this ?

I want to split a line using distances along that line that are from a separate data table: startendcategorylength02.3Cat 22.32.315.1Cat 312.815.126.6Cat 211.526.627.3Cat 50.727.329.9Cat 22.629.931Cat 51.13133.3Cat 22.333.334.3Cat 5134.339.7Cat 35.4 I am probably just tired, but I can't seem to work this out.

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.