Authoring

Hello,I have as an input parameter a list of ids separated by "|".For example: 1|2|4Next I have a directory with some zip files:1.zip, 2.zip, 3,zip., 4,zip, 5,zipAs a result I would like to get only files which have names that are in the input list and have it all zipped to the result.zip file:result.zip ---  |  |_1.zip |_2.zip |_4.zipI came to the point where I used attribute splitter and I have a list of those Ids but I have no idea what to do next. Can you please help me with that? Thanks!

I need to search a webpage with several links, however I need all the links that have a certain word, how can I do that?

what i'm trying to do is take an array of strings from a python startup script and access it from the rest of the workbench (specifically an sql executor and emailer). what i have so far is made a global variable like so:global users_to_fixusers_to_fix = []then i append strings into that array.and here are my tranformers:here is the PythonCaller:i have gotten this solution from https://knowledge.safe.com/questions/58082/passing-parameters-from-a-python-script-tool-to-a.htmli am getting

Hello,I need to set specific order for writers to write because tables are connected with constraints , when one finishes second one starts and after second third starts. How can I do that? And second question, how can I commit changes to Oracle DB or FME does that after writing to DB? I am using Oracle non-spatial writer.

I want to implement an iterative loop in my workbench. For this I have created a simple "While Loop" construct. The pseudo code is as below var i, maxval; i = 1; maxval = 10 while (i < maxval) {  i = i + 1;  print i; }I created a workbenchTo implement the looping, the red line should be working but FME doesn't take it.Please advise for any workarounds or what I may be missing?

I am taking data from a shapefile and mashing it with a CSV, and the attribute I am having issue with has null, numbers and non-numeric characters/alphabetic values (from the input).The target field in my output is an integer type (uint). I would like to make Null all attributes of that field that are non-numeric (some are purely alphabetic; others have characters like in a date format).I was hoping to use an AttributeManager that I was already utilizing to perform this operation, but I don't know how (or what other transformer would be best).

I have a workbench that has an non-spatial oracle connection. It runs fine on my laptop A. But it does not run on another machine B (a server) as it complains about the TNS connection. So on machine B, I deleted the database connection (FMEOption -> Database Connection) , and tried to recreate it. But the connection test gave me this error: Error: COM.safe.fmeserver.api.FMEServerException: User encryption is specified but can't find key to decrypt.In fact, I can't open any of the other existing connections on Machine B in the FMEOption -> Database Connections. It gives me this error:Unable to retrieve connection "xxx", please check the log file for more detail.We had a similar issue with this Machine B a few months ago, which we fixed by reinstalling FME. But this time, reinstalling FME does not fix the issue. We are at FME Desktop 2017.1.0.Allen

Hi I have a grid index, I want to use the attribution from the index to pull various raster tiles. Currently, I have clipped the index to my area of interest. These are then feeding into my FeatureReader. I have setup the FeatureReader as seen below. Here is where I have the problem, the FeatureReader is writing out the original index and not the rasters I wanted to select (Using the SHEET_NAME from the index). What am I doing wrong? Thanks for the help. B

I have attribute zip code, where all values looks in this form 12345 how can I transform them into this form 123 45?My idea was to split it using StringReplacer where I would replace \\d{5} by \\d{3} \\s \\d{2}, however I don't know how can I create new attribute which base on the old zip code attribute (12345).Are there any other ways to do it?

I wonder what would be the best way to come up with a string of lat/long concatenated from features with a single character value. I'm not sure I described it very well but the pictures should help.The source is a PDF document.My workspacethat ended with this. I tried aggregating on Y but it did not work. I was thinking maybe an Advanced attribute Handling but I don't have a good solution yet.

I am trying to populate a new field with a value from another field. It is not a simple attribute copy. Each record is getting the value from a different field that is specified in another field.For example: I have the table below and I want to populate NEW_FIELD with one of the values of fields FIELD1 through FIELD4 based on what is provided in FIELD_TO_USE. This has to be dynamic (no hard coded TestFilter as I am doing that now).FIELD1FIELD2FIELD3FIELD4FIELD_TO_USENEW_FIELD1234FIELD115678FIELD26ABCDFIELD3CEFGHFIELD4H

How to set preference in FME workbench where one can set precedence: Step 1: (Run first) Data is downloaded successfully using HTTPFetcher, until it is complete the step 2 should not start. Step 2: (Run second) then a reader is used to read the above downloaded data. Currently having issue of step 2 start before step 1 is finished.

Hello,please, I try to find way how to add a new line to Job result data page - e.g. URL link to data download of job result - check below. Is there any possibility please?Thank You so much!Lubo

I have a number of feature classes read from a geodatabase, each FC written as a sheet in an excel spreadsheet. Using a dynamic reader/writer to do this, dynamic schema from the src geodatabase.I'd like to add long/lat fields to all of the point features and have that in the output excel. The source data schema of course doesn't have this. I've tried adding a long and lat field to the excel file sheets that are relevant, and then using the schema reader to create a schema feature to pull the orig schema + lat/long fields to pass to the dynamic writer. FME doesn't complain but I am not getting long/lot values written out in the final data.I feel like I'm missing something simple if anyone can imagine what that might be!

Hi, I'm using an Excel template file to chart some data that I write to Excel - I've attached some example data and workspace. When I populate the 'data' sheet, I want the chart to update with the latest data. I've tried to achieve this by setting the chart data source to '=data!$A:$D', so it should look at all rows in those columns), but Excel seems to default to =data!$A$1:$D$1. So when I run the workspace the chart is not updated to reflect the data in the 'data' worksheet.Does anyone have any other methods for achieving this? I want the chart data source to use dynamic references rather than fixed, so that whatever amount of data is input to the 'data' worksheet, it is plotted on the chart.Thanks for your hepMary

Hello, We are using HDFS as our file system for some of our files. Can we integrate FME solutions inside HADOOP in the Map-Reduce process? Or there is any other practice to use FME in HADOOP context? Thank you for your time,Kitty

Many of our published workspaces in FME Server share published parameters, like URLs or email addresses. If this information changes with time I have to change the value for this parameters for each and every published workspaces one by one. A way to manage this kind of information is by storing it in a table into a Resources folder and read it from my workspaces using a specific reader. This is ok but I was wondering if there is another option, like defining new FME Server parameters that would be accessed from workspaces and would work like 'global published parameters'.

If I use a BulkAttributeRenamer to remove a prefix on a number of attributes, and the resulting attribute names match some preexisting attributes going through the transformer, which attribute values are kept? Are the preexisting attribute values maintained, or are they overwritten with the values from the renamed attribute?

Is there anything I can do to prevent FME Workbench from consuming CPU when being idle? On my new Core i7 with Windows 7 FME Workbench 2015.1 consumes about 10% CPU after opening an empty workspace and minimizing the application. It's enough to make my laptop fan spin up noticeably and battery drains very quickly. If I run a workspace and FME inspector is left open CPU will go up to 15-20%. After a short while or so the fan speeds up and the sound becomes really annoying. I never experienced this with previous versions of FME.

I have a fairly large workbench that uses quite a bit of processing muscle, so I am limiting which features are processed at one time by using an attribute value (a line reference) exposed as a published parameter i.e each time I run the workspace, I enter a new line reference to be processed. I have about 1500 different line references to process. How can I automate this so that I don't have to manually enter each new line reference?

I seem to have broken the way FileGDB ArcObjects can handle dynamic schemas and I'm not sure what went wrong. If I switch to a FileGDB API, it works.I have the following:PostGIS reader that can pull in more than one feature type at a time. Ex. Powerline, RailwayFileGDB ArcObject writers with a template file that define fields, domain-coded values, subtypes, etc. It also uses fanout to produce the right folder structure. Ex: Transportation/Access.gdb/RailwayUtility Communication/Utility.gdb/PowerlineThe error I'm getting is:ERROR |Unable to find the schema definition 'Railway' for feature with feature type name 'Railway'. Ensure the feature type name is correct and that its schema definition exists in the schema sourceThings I've tried:When I use the FileGDB API writer with as much of the same parameters as the ArcObjects writer, I can get the expected output, but

Hello, I have two set of data (Points and lines).  They have a common attribute X Some of points have a common attribute value (X) with lines How do i can extract those lines ? I tried the feature merger but the translation fails  Thank you.

Hi,I have a polygon layer with x,y,z coordinates.For each polygon, I would like to calculate the mean z-value. For this I use the ListStatisticsCalculator, which works perfectly.The problem is, that some polygons consists of one or more useless z-value (-999, -9999 etc.). I would like to filter out these values (or delete them) before running it through the ListStatisticsCalculator.I have tried the ListElementFilter with Filter Type Numeric Range, but I can't get it to work properly.Any thoughts?Thanks,Stig

Hey,I'm unable to parse a single year value. It says it needs a month and day value. Is there a way to get past this? @TimeZoneSet(@DateTimeParse(@Value(Year),%Y),local)

Hi,Is it possible to sort features by attrbute name? Say I have Excel table with 10 columns, and I need three of them to go to first transformer, and the rest to go to another transformer. Column names are not constant. Or say they named by some order, like Group1tag, Group1kind and so on, how could I filter attributes by a mask 'Group1*'? Thanks,