Authoring

I have created a crosswalk from multiple shapefiles that a) reads a look up table b)writes the values to a geodatabase and c)populates a field called "DataSource" with the source shapefile names. I have a field called "city" that needs to have city values populated based on the value in the "DataSource" field. My approach was to set a condition statement in the target field properties of the writer using If/Else If/Else statements. Didn't work. Please see screen caps showing parameters and desired outcome.

When reading very large amount of spatial data from a Database within the FeatureReader, the process could take a very long time. Is it possible to pause the reading, while reading within some time intervals?In fact, I have a database locked at night for updating daily changes and I would like to pause the FeatureReader (if currently running) during the night and resume the next morning.In advance thanks.

Hi there, I am trying to digest multiple CSV files from within a certain directory. To do this, I have created a CSV Reader that has a Source CSV folder with the parameter: _"<my file path>\\*.csv"_. I need to remove the processed file from this directory after processing which I would do via python shutdown script by getting the filename that has to be removed (actually - it would be moved into a directory). In the past when I only processed one file, I was able to grab the file location directly from the reader, which is of course now the <filepath>*.csv . I have used an Attribute-Exposer to get the filename- but I haven't figured out how to use it in my shutdown script? Am I missing something obvious here? Is there a way to either: - set a Python variable with the filename (I would be surprised) or - set a publish parameter at run-time? Thanks in advance!

Hi,  I've just run into a curious problem with a conditional expression in the AttributeManager.?  I'm comnparing two dates in the "FME Date" format (%Y%m%d), setting an "expired" value to either "true" or "false" based on the conditional expression: @Value(dt1) > @Value(dt2)  But it seems like the expression is always satisfied, so my output is always "true", regardless of the values involved (and some should definitely yield "false").  As a workaround I added a Tester transformer, with the exact same expression, and that worked as expected.  Has anyone else run into this, or have any insight into why the conditional value errs ?  Cheers

Example: http://playground.fmeserver.com/csharp-request/Shows String body starting with the words "PublishedParameters" is that required?The reason I ask is that there is another download example with an HTML form that takes in simple value pair inputs with out the "PublishedParameters" label or title of the json. String body = "{\\n" + " \\"publishedParameters\\" : [\\n" + " {\\n" + " \\"name\\" : \\"MAXY\\",\\n" + " \\"value\\" : \\"42\\"\\n" + " },\\n" + " {\\n" + 

I'm working on a project for FME Server where a user will be able to pass variables into a URL and get a download of a dataset. One of the requirements that I'm hitting a snag on is how to create a parameter that can be used to name the output file (geodatabase, pdf, or shapefile). Right now it's defaulting to dataset.gdb.TIA,David

Hello,in the picture there are lines and polygons. Both have a code attribute. The idea here is to clip the lines with polygons having the same code! E.g. for polygon 791238(one the left of the picture), lines within yellow block having the same code as this polygon, and they need to be clipped. So I thought the process will be:  for each polygon:      select the lines having the same code as the polygon    clip selected lines with the polygonHow can I do this in FME? Or are there approaches?Thanks!

I have 2 workspaces on our FME Server with the first calling the second using FMEServerJobSubmitter. One of the parameters that the second workspace expects is a password. This is the password to our AGOL account. The parameter is defined as password so it should be hidden. The parameter is also defined as password in the first workspace and the first workspace would pass the parameter to the second workspace via FMEServerJobSubmitter.However, after running, I reviewed the log of the first workspace at the step where it executes FMEServerJobSubmitter, it was logging all parameters being passed to the second workspace and had logged the password value in clear plain text. This allows all users on FME server to be able to see the AGOL password.The log of the second workspace also shows the parameter values, but the password was correctly logged as *** .Please fix this security bug!

I wrote a batch file fme workbench.fmwrobocopy process_folder share_folder /COPYALL /E /IS /NPthat run during approximately two hours and at the end of the translation I'm copying the processed file to another folder that is shared with many users.  The issue that I'm havcing is that the robocopy action starts before fme frees the last translated file.Is there anyway to oblige fme to free all the files before the next action in a batch files? I know that I can add a timeout action but this means that I would have to try several times to determine the good time to be set when calling timeout.

We are currently planning on using Environment Variables to set the output location for Workspaces put through the Job Submitter Service on the server. I was wondering if there is a better way where we can set a parameter within FME Server for the same purpose?

Hello Everyone,I hope someone can assist me with 3 FME Workbenches. Each Workbench does an HTTPCaller that writes to a file (on the local network) then uses that file as a source for the rest of the Workbench.Whenever I run these Workbenches of Server, they run successfully but with 0 features written. I use the exact Workbench and run it from my Desktop, they also run successfully and with the correct number of features written.I would like to figure out why there is a difference, make the necessary changes and then schedule them on the FME Server.Thank you

I have a dataset which needs joining. I need FME to identify which attribute values differ between touching features along the split, preferably producing a single attribute containing a message eg. "These attributes differ: #, #, #, etc". There are hundreds of attributes and I can't think of an easy way to do it.Thanks!

In a Python startup script, I want to access Published parameters (to test whether an Oracle non-spatial Source Dataset connection is to our test or production environment). But the only examples I'm seeing in the documentation are for TCL startup scripts. If anyone has an example of accessing published parameters in a Python startup script that would be very helpful.

Using FME Desktop and Server 2016.1, I created a workspace that uses FMEServerJobSubmitters to start a series of jobs on the FME Server, all depending on the previous job.This process works as designed, even with just 1 engine.But if another process has claimed the engine, the workspace fails with the error that no license is available.I would have expected my job to go to the queue.Has anybody else experienced this behavior of the job submitted via FMEServerJobSubmitter?If so, can this be avoided in any way?

Not sure whether this is a bug or a works-as-designed but I've just noticed this with FME 2016.1I have started with an empty workspace and added 2 Shapefile readers, which I renamed to "OLD" and "NEW" (setting up a simple ChangeDetector demo). I then realised I made a mistake, so I deleted both readers and re-added them. However, on re-adding them, even though they were pointing to different shapefiles as before, the names were automatically set to "OLD" and "NEW".It keeps happening, so if I delete NEW and add another Shape reader it'll be named NEW. If I add a reader for another format it'll get a default name, if I then add another Shape reader it's again named NEW. It kinda looks like the 1st Shape reader in this workspace will be called OLD and the 2nd one NEW.Right now that's totally fine with me for what I want with this demo, but I'm just wondering whether this is how FME is designed to work :)

I can't find anything in the documentation about how how FME Server stores published parameters in scheduled jobs.Are published parameters that are passwords encrypted? Or does FME server store these parameters as clear text behind the password dots? See the screenshot below that shows exactly what I'm talking about:

I am running multiple workspaces that have the same published parameters that are passwords. Is there centralized way to store published parameter passwords that are used by multiple workspaces? I can't find anything in the documentation about how to do this.

I have new data which I need to load into an existing table, but need to check if an ID number exists in the original table. If it does exist in the original table then I need to move that record to a new table and insert the new data into the original table..I hope that makes sense, but what is the best method to check if an id exists and move it.

Since the unveiling of FME 2017 everybody is talking about the classic / Manhattan and curvy connectors but I think there are quite some cities missing in this list. How would you call the connectors in the workspace below?As you can see, you don't need an FME Inspector to visualise data =)I created a little riddle while waiting for the FME World Tour to start. In this album you will find 10 screenshots of workspaces. For you to find the city they where based upon and the statement hidden in the grey squares.P.S.1 Fill in both characters and spacesP.S.2 All cities will be visited by the FME World Tour (Take a look here for a list) P.S.3 You can validate your answer by clicking on 'Details' in the album. And now for the question. Do you agree with the hidden statement? (see last picture in album)UPDATE I am trying to implement a background color based on georeferenced satellite images (printscreens from Google Earth) but I am not completely able to understand how to scale th

Why when I copy and paste readers from two open .fmw files do those readers become misnamed and unusable?  Why does the "enable/disable readers/writers" form not have any visible effect when I uncheck/check the boxes in the form and click okay?

I have 100 tables.In each table, there will be 9 row of records stored with unique ID like { 1,2,3,4,5,6,7,8,9 }Need to log if there is any missing row in those tables with Unique ID.For eg:Below the table, there is missing row 4 and 7. need to find 4 and 7 row.Please advise how to achieve this task.Thanks in advanceVenu

HiAny idea of the best method for using the Arcpy library without changing the interpreter to ESRI?Thanks

I have multiple rasters, which I want to merge. These are scanned maps, in different pieces, georeferenced afterwards. Files are jpg, together with jgw (for georeferencing)I "simply" want to merge them into one file (again, jpg with jgw), so that I have one map, one jpg.Rastermosaicker and rasterbandcombiner are not ideal, as the maps have completely different height, width and rotation.Printscreen of the overlapping maps, after georeferencing in FME data inspector.It looks quiet easy, but I can't solve it :(Result after using the rastermosaicker in FME data inspector.Thanks for giving me some hints here!With kind regards,Ine De Cubber

Can these passwords be extracted from the workbench files? I am concerned from a security standpoint.