Authoring

Hi, I wonder how i can merge an excelfile with several sheets to an shapefile. The shapefile has the location of stations and in the excelfile I have information aout the stations for each station. i.e each station has its own sheet.I really would lika som help with how i can merge this, please.

I have some road data in ArcGIS SDE database (roads and road signs). Data from the GIS is transmitted to Geo Json with the help of FME. With any changes to the data, I should be able to display the version in the geojson attributes When version changes, the version rises. How can I do that

I'm trying to compare two datasets by looking at the address attribute string used in both datasets and find the fuzzy matching ratios. The read process was fast and read the 350,000 records in dataset 1 and the 14,000 records in dataset 2 in less than a minute. I then sort both lists separately and then use the FuzzyStringCompareFrom2Datasets transformer. I have been running this workspace all day (about 5 hours so far) and it has only output 288 records. Is there a way to speed this up?

Is there anyone who is using FME scheduler to automate SAP jobs? Our company is using SAP ERP software and we want to automate SAP jobs. SAP has its own job scheduler but it lacks many advanced features we are looking for . Like we want the scheduler to run periodic jobs which can ran only on working days with different parameters and dependencies like the next job should start only after finishing the first job ; the second job should run after n +1 days after the first job etc... Some jobs will run on some days but it should have different run date like if it is running tonight , it should populate yesterdays' date as the job date. Can anyone please let me know if FME server has these kind of advanced features to automate jobs?

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&