Authoring

How do i convert a small raster to an (aspatial ) long list of numbers (the pixel values with comma separators idealy) without coercing to vector. I want to look at frequency of numbers occuring in the raster, Thanks

Dear FME community.I would like to make a loop with concatenation of values like a hierarchy.The result like that :In this case I can have 1, 2, 3, ... x levels, that's why I don't know how to do that.Thank you for your help.

We are using FME to replicate spatial records between databases. The replication workbench is dynamic and being triggered by Informatica Power Center via async web service call. We have a dedicated engine for Replication because these calls need to stay in order. Does anyone have any best practices on making sure the jobs in the queue do not start running if one fails?

Hi,Currently in FME 2018 it´s possible make loop in not custom transformer? Or only custom transformer yet?

Is it possible when resubmitting a job to use the same job id? Just looking for programmatic way to keep track of if a resubmitted job was successful or not for reconciliation purposes. I don't see anything in the resubmitted job log file about being resubmitted from x previous job or anything like that, but I certainly could be looking in the wrong place / type of log.

Looking for tips to improve performance when selecting rows from a database based on an incoming set of features.  For example, say I have 150 points going into an initiator port on a FeatureReader that then reads 4 tables/features from an Oracle SDE database.  Scenario 1: Spatial Filter is set to "Initiator Intersects Result" While this does greatly improve performance over reading everything from all 4 tables/features, What else can I do to improve performance here? Is there a way to send all of the features at once? OR generate a set of search envelopes to send to the featureReader?  (I tried creating a BoundingBoxAccumulator, but if the points are not close together, this will select too many of the 4 features)  Here is an example of the kind of output in the log file for each of the 150 points that are sent to the FeatureReader (note, I've change the lat/long): Notice - Performing envelope query on the `GEODATABASE_SDE' reader, post-filtering spatial predicate in

Hi everyone I need convert to mobile lidar height for Istanbul... can you help me ?

HiI have an excel with list of feature classes to read, attribute fields (comma delimited) and where clause(ex: myfield = 'Yes' and MyField2='abc')Reading excel, passing to feature reader with where clause is fine, works okMy issue, is how do I - > dynamically write selected features from feature reader to writer > with only attribute fields required (coming from excel in comma delimited texts) [ if not possible at least write all read attributes to write, again shud be dynamic as each input feature class\\att fields will be different.] > pass feature class names built prior to feature readerA work around solution and an example will really help solve my problem.Tried to search similar example, couldn't figure out.Really appreciate your helpThank you all

Hello,I want, after pressing the ''run'' button in FME and before starting the translation that windows cmd to open, to print some text of my choice for a time period I choose, and then close itself and next the translation to start and continue normally till the end Is there any way to that using the startup script in the workspace parameters ?

My workspace relies on some non-standard python libraries, is there a way to either include these in my workspace when I push to FME Server on the FME Cloud, or otherwise install these python modules on the FME Cloud?

Hi,on a project, i'm using a FeatureReader to call different shapefiles, localized in different folders.The purpose is modifying shapefile names to normalize them throw AttributeManager, one for the Schema outpout port and another one for th Generic. Until here, everythnig works.By the way, i'm trying to modify the attributes format which are being created by the writer, for instance varchar(254) -> varchar(5). With dynamic mode, i guess i have to modify the schema values with some ListExploder -> AttributeManager -> ListBuilder.Once these operations are done, the new schema has exactly the same attributes name and lists than the original schema, but the dynamic shapefiles aren't writen..Is there something i'm doing wrong??Thanks for helping!!!

When I create an "ArcGIS Server Feature Service" Reader, set its parameters (Authentification Type: Basic) and load the layer list, I get the Python Exception "Failed to retrieve feature types. Python Exception <ValueError>: No JSON object could be decoded".I have this problem on a computer set up from scratch recently (Windows 10 build 1709) with FME 2017 (x86, build 17725). I tried different "Preferred Python Interpreter" settings in the FME options (Esri ArcGIS Desktop Python (2.7), FME Python 2.7, FME Python 3.4+) but got the same error. I also tried it on another computer with FME 2016 (x64, 16716), FME 2017 (x86, 17725) and FME 2017 (x64, 17725) and got the same result.Is this a known bug in FME? Is there any workaround? Greetings,AndréThe log is:Creating reader for format: Esri ArcGIS Server Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISFEATURES'Loaded Python module `arcgisonlinefeatures' from file `C:\Program Files (x86)\FME_2017_17725\plugins/pyth

I recently had to rebuild a laptop from Windows 7 to Windows 10. I installed FME again (2017.1.2) but on this install I can no longer see the hub transformer options when I type a transformer name on the canvas. I have played with proxy setting, but that makes no difference, and I can browse the hub transformers via the Navigator so it not a firewall issue?

initially i used oracle connection string (username/passwprd@service_name) inside my shutdown python script. Now i created a named connection inside tools -> fme options -> Database connections.Now how can i pass the credential to my python prg?pls help.

HiHaving problems where when we run a workspace pointing at a custom python interpreter (set by system environment variable PYTHONHOME), it uses the specified python interpreter when we run the workspace as my user. When we change to run the workspace as another user (service user running a bat file), then it uses the default python interpreter, not the custom interpreter specified in PYTHONHOME. Any ideas?I've looked at the recent article here , but it doesn't mention whether there are any specific user settings required. @Mark2AtSafe, any thoughts on this?ThanksMary

Hi folks,I am using the Sentinel-2 on AWS format within the FeatureReader transformer to download a Sentinel-2 image for a specific area. With the feature types for 10 meters and 20 meters resolution, I want to perform a radiometric/atmospheric correction with SNAP (Sentinels Application Platform). I tried to use the GeoTIFF writer and exposed all the format attributes but that does not seem to be sufficient to fulfill the required meta data.Can you recommend a specific writer or a workflow to convert the radiance to (corrected) reflection values?Thanks in advance,André

Hello.I'm using the FeatureWriter to create GDB Feature Classes, which will extend into ArcSDE Feature Classes soon. I can't seem to find any details on the Table Parameter options of this transformer in the documentation, however.Under Table>General, there are Feature Operation and Table Handling options. Currently, the options selected in my translations are:Feature Operation: InsertTable Handling: Create if neededand currently the features are added to my target Feature Class every time the translation is run. Which is not particularly my preference right now, but will be in the future. When attempting to use the other options, I receive ArcObjects-related errors and can't completely overwrite the Feature Class. During translation testing it would be ideal to completely overwrite all features every time it is run until which time the translation is completely set up (i.e. delete and reload). If updating the Feature Classes is not possible, it would also be of benefit

I have a set of workspaces on a network disk that are called from a master workspace with workspace runners. But when I copy the master workspace to a different location the paths to the modules become relative to the new master. And thus the link is broken. How can I retain the absolute path?Sincerely,Robin Nilsson

Helle we are looking to extract features based on created date, we created a published parameter ( syn_date) and in the reader where clause we use this expression ( CREATED_DATE>date'2015-02-09 13:00:00') and it's working now when we use the publish parameter to specify the date we used this expression CREATED_DATE>date$(Sync_date) this is not working we inspect the syn_date attribute the value show this ( 20180120000000)and in the publish parameter its shows the right format Any idea how to fix this Thanks GeoDB readerinspectPublished param

I have an attribute with a value of a list of numbers separated by commas. I would like for all the consecutive numbers in the list to get replaced by one dash in between the first and last consecutive number instead of having each number represented. Basically I would like this "1,2,3,4,5,7,9,14,15" to become this "1-5,7,9,14-15".

Hi allI'm trying to test a workspace I've published in FME Cloud as a Job Submitter Service using an HTTP POST to kick it off. I think I’m missing something when trying to deliver the POST.In my workspace I have a Textfile reader to read the JSON delivered in the POST body. All is set up as described in the Safe article 'Send Source Data to FME Server with HTTP POST'.(https://knowledge.safe.com/articles/1295/send-source-data-to-fme-server-with-http-post.html)This is what I’m trying to deliver: { "parameters": { "xmin":"148.88672", "xmax":"149.61182", "ymin":"-29.62122", "ymax":"-29.11378", "email":"john.smith@email.com" }, "available_data":[ { "source":"NSW", "downloadables":{ "DEMs":{ "1 Metre":[ { "file_url":"https://s3-ap-southeast-2.amazonaws.com/nsw/Bunarba_1m.zip&

Hello,unfortunately, I have problem with result from coordinate rounder and following process in changedetector.Example of my situation is below:There are 2 sources of data. One is actual to 2016 (technical map) and second to 2012 (plan of renewal). Plan of renewal was made from technical map in 2012. Now I want to compare these two sources in actual form with coordinates accuracy 0,01 m. I chose this way of processing - first I used coordinate rounder with X,Y precision 2 for both sources. I sent features with rounded coordinates to change detector. Values of coordinates are following:First sourceCoordinate 0: -536260.78633329261, -1226140.6460811181 Coordinate 1: -536258.07004669344, -1226118.8444450819Second source:Coordinate 0: -536260.7862999998, -1226140.6460000016 Coordinate 1: -536258.0700000003, -1226118.8443999998Result is disappointing... In spite of fact that I rounded coordinates to precision 2, change detector said, that coordinates are different, but they arent in real..

Hello there we have a simple WS GeoDb reader and SQL server writer and we are only renaming 2 attributes as shown but the table created on SQL still keep the same name as the reader ignoring the renamer transformeris there any reason why?

I am trying to run an FME workspace on server, I run it through a web interface (a web page). The workspace is meant to produce a JSON string as a result (when the workspace runs successfully) and in order to do this I use the DataStreaming transformation service. When the workspace fails, I would like it to send an email advising of the failure. I have already all the notification and topic setup (using JOBSUBMITTER_ASYNC_FAILURE) and I tested it on the FME sever web interface and it works fine. On FME server I can choose with the dropdown list which service I want to run the workspace with, to receive the email I have to use the JobSbmitter. But if I use the DataStreaming then I won't receive the email if the workspace fails. Similarly, when I call the workspace through a HTTP request if I use this endpoint:https://fmserverhost.fmecloud.com/fmedatastreaming/workspace.fmw?parameters I can get the JSON string on success but no email notification conversely, when I use the other

Hi,I appear to have an issue with a FeatureWriter failing when writing a certain amount of features.I have a list of features which I want to write some dummy data for into a Feature Writer. For each entry in the list I fetch 1 object (using a Sampler) and the relevant schema from PostGIS tables and then use a FeatureJoiner to match the list feature to the object and schema feature. After that I remove the geometry and feature values so each feature in the list has just one empty object. A lot of features, but very little actual data. I then write everything to the FeatureWriter. This works absolutely fine when the list is only about 500 items long, so there doesn't appear to be anything wrong with the process, but when I'm testing lists of about 4000 features the Writer seems to timeout and fail on a random feature.The error messages I'm getting are along the lines of:Geodatabase Error (-2147220987): The user does not have permission to execute the operation.FileGDB Writer