Authoring

Hello,I have a simple dynamic workflow with Shapefile reader and Oracle writer (something like that) where I had a counter to add an ID in a new column "OBJECTID". This works well but my new column is added at the end of the schema. Is there a way to put this as first column?Thank you!Maxime

Hi, I have dataflow where I filter my data by an attribute. This results in 100+ output ports. After that I will perform the exact same transformation for every output port and write the data in a separate file. (Yes, I do need to filter first.) Of course, I can create a custom transformer for my transformation that follows (see screenshot) but I'm wondering if there's a way so I don't need to add the transformer and a writer to my workspace 100 times?Any suggestions?I'm using fme desktop 2016

Hi Friends,two questions :1. We can type the attribute names in this text field, but we cannot pass it like variable or text string(list). How can i pass this published parameter to "Attributes to remove" field to the writer dialog box? 2. If i write to shape and it crosses 2gb size fme gives error. how vcan i split the shape file if it crosses 2gb? (like fme splits v7 dgn file size in V7 writer)Explanation :My fmw has Dynamic reader and writers. I am reading from oracle spatial (every time input tablename changes, user types in table name through published parameter) and writing to any 4 formats.(shp, tab,dgn and acad) here my fmw is dynamic. there are some attribute names that i dont want to write to destination. user types in these attribute names(space delimited). through published parameters. Every time this list changes and different attribute names comes in. In the Dynamic properties, there is a provision called "Attributes to remove". Now I have two ques

Hi,In FME Desktop I can add a Header to know the time spent on each transformers.FME_PROFILE_RESULT_CSV "filepath".How can I do this on a FME Server?

I published a simple workspace to the FME server's Job Submitter service with the Job Completion notification posted to JOBSUBMITTER_ASYNC_JOB_SUCCESS/FAILURE topics. Then I published a second simple workspace (Creator and Logger just for testing) and add it to the subscription to the same topics. I would expect when I run the 1st workspace and at the end of it, the 2nd workspace should be run. But it did not. I can see the 1st workspace was run in the Topic Monitoring, but didn't see the 2nd job to follow up. Did I miss anything? I also tried using a new topic, instead of the out of box JOBSUBMITTER_ASYNC_JOB_SUCCESS/FAILURE topic, but no luck.

Hi,I'm using FME to check the log files of previous runs, testing for errors.I'm now getting notifications of errors in a set of log files, that has been generated by running a workspace via "WorkspaceRunner". The error is bogus, however, so it messes up my overview by cluttering it with false positives.The dependent workspace is called with two parameters: the path of the (xml) file to check, and a path to the desired log file. This log file path contains a dash, so I get this error:BADNEWS: String value `WorkspaceRunner_DanDas: Running FME Workspace xxxxx.fmw with command line:' contains invalid characters and could not be converted into an integer (stfutil.cpp:802)A typical log file name may be: CONTROL ARWOS XML - TV-Inspektioner.logHow can I avoid having FME attempt to do a bogus subtraction in my string value ??Cheers

I have an attribute with integer value called number of folders x for a single feature, and I would like to create X number of features. so I can create c number of sub-folders using filecopy.

Hello Everybody, We have two FME server installed. None of them we cannot accesible from outside server. I need to make it web accesible. Please guide me. Because I want to got the data download or to run a workspace using the generated URL from outside. Thanks

I am trying to connect to our carto database, but are getting HTTP error 404, and also connection refused 443.How do you connect to a Carto Database?I am using out url address: com-luim.geografia.com.au and API key

I frequently use batch scripts to run series of workbenches in cmd.exe. I would really like to see the contents of the 'transaction window' or log file displayed in the cmd.exe window. I know I can look at the logs, but that is an extra step and not as useful.Normally what displays is something like this, which doesn't explain what is happening in the transactions window or log file. I really want to display this stuff in real time (not after the transaction complete): Have I missed something, or is it not possible. Thanks in advance for your help

Hi,I am using the 64bit version of FME 2017.0.  In my workspace I am writing to an Oracle Spatial Database. I have 64 bit versions of Python and Oracle instant_client installed.At the end of the running the workspace after the TRANSLATION SUCCESSFUL message I receive the following error message (repeated 3 times) Traceback (most recent call last):    File "C:\Apps\FME4\/python\fmesite.py", line 6, in <module> from fmeobjects import FMESessionImportError: DLL load failed: %1 is not a valid Win32 application.Any suggestions as to what is causing this?

Hi everyone,I am having trouble with downloading SDF output as a data download service.The workspace itself is really simple:- 1 SDF reader, reading a file containing 10 features;- 1 transformer;- 1 SDF writer, creating a file containing 10 features.  When this process is executed from the FME Server environment as a job submitter service, there is no problem. When the same is executed as a data download service, I can see in the log that 10 features are written. The download link also shows the output .sdf file, but it contains 0 features in data inspector (instead of 10). When we write to e.g. shapefile as a download service, there is no problem.   So, to summarize, it appears to be impossible to use SDF files in a data download service?   I know it has worked before, so I am wondering if anyone had the same problem? Suggestions how to solve this?  Thanks in advance!

Hello,I am trying to authorize a web connection to my Dropbox account on FME Server so that a file can be incrementally uploaded.In the Dropbox Developer portal, I created an app where I got my client id and client secret. As for my Redirect URI, I tried using http since my server is behind my network’s firewall, but it only let me use https. In my FME Server’s Web Connections, I updated my client information to match what my Dropbox app had. When I tried to authorize it, I got an error saying the site could not be reached.Is it because my URI is incorrect, and/or if there are other configurations that need to be done? My colleague mentioned that maybe we have to make the server public. I am not sure. Thanks!

FME Server: 2015.0 bld 15250  Occasionaly when I publish workbenches to FME Sever (which run fine from workbench) I get a failure and upon investigation in the log see this error once or twice:  Creator_CREATED Feature Counter -1 3(TeeFactory): Creator_CREATED Feature Counter -1 3: @LogCount: Cannot save feature. Either function was missing appropriate configuration line or a FFS writer initialization failed The error does not appear to be down to the workbench as sometimes a reboot of fme server, and then republish the workbench sees the error go away without me (apparentely) changing anything in the workbench.  This is fine on our sandpit box, but not so good on production.  Has anyone come accross this issue?  I've had a search of the support docs and didn't spot anything.  We're running server with active directory authentication on.  Any pointers would be much appreciated.  Nick

Hi, I am working in FME 2014. I am trying to create a workspace that will have a reader grab all xls files from one folder (with multiple schemas), re-project the xy coordinates to two new attributes (x, y), and export the data to multiple xls files based on file name and new projection. Before the workspace is run, the user must manipulate the xls files to have columns with original coordinate system and original x and y coordinates. The headings "Original_Coordinate_System" and "SourceX" and "SourceY" are the only common column names between all the excel files. When I run the workspace I get an error saying "Error fetching dynamic schema definitions from reader `XLSXR_1"Attached are two xls worksheets as an example, and two screenshots to show a portion of the script.Would anyone have any suggestions that I could try? Thanks in advance.

I have a template geometry (tree.dae) and like to copy them to different locations. The locations are given with points (x, y, z) including a scale factor as an attribute in a shapefile. My idea was to move the template geometry with "Offsetter" and the parameters from the point geometries. How can I manage that in an FME workbench? I couldn't find a transformer for that until now... Thank you for your feedback.

Hello all, I've been pointed into the direction of FME by someone on Reddit with the below query. Is anyone able to help me achieve this output of multiple KML files with a workflow in FME Desktop...I've been provided with the location of a solar farm to fly over with my drone and a thermal camera. The CAD drawing of the solar farm has been geo-referenced and sliced into a tile layer: http://abovesurveying.s3-website-eu-west-1.amazonaws.com/Spriggs%20Farm%20v2_Thaxted_CAD/{z}/{x}/{y}.pngI have an app on the iPad that controls the drone that will point it north as a constant heading and fly from end to end of the solar panels. This is all achieved by uploading a KML file to the app. At the moment I manually create the KML files with LineString coordinates limited to 1.80 kilometers or 99 waypoints (whichever comes first). This is going to be extremely time consuming. So....I have created three different KML files which are attached:Launch locations. These will be different locat

Hi there,This is a question of a general nature. I understand that parallel processing is making use of the CPU's cores to process certain grouped data. However, since the FME engines are running/licensed each based on the existing cores in the server's CPU; would the processed workspace consume an additional engine? Thanks. Lyes

Hi,I am using FME Desktop 2015.1I have created a Parameter (Choice - Single selection) and populated my pick list with the required values 10,20,30. however, when the parameter is invoked, an 'additional' blank value is also included. Is there a way which I can remove this from the selection options as I do not want someone to make this selection? Admittedly, I could build a series of downstream test to check for the non-value, but if I can avoid having to do this I would prefer to.Thanks in advance.Rob

When using a fanout on a writer and the fme server datadownload service, is it possible to get a zipfile that does not include the top level directory "dataset"?ex. Destination Fanout Directory : $(FME_SERVER_DEST_DIR) Fanout Expression: A\\file will produce a zipfile containing dataset\\A\\file and what I would like is just A\\file 

Good day, I have two tables with records that I want to join together based on the category attribute: 1.table: First attribute is the client, second the category. MAAS CA MAAS IND MAAS SWE BWL CA BWL NO BWL EE  2.table: First attribute is the cell, second the category. CA345985 CA CA290456 CA IND789345 IND SWE563843 SWE EE621984 EE NO893476 NO EE972086 EE IS856145 IS  What I would like to have as a result is to create an excel report per client. The report should only contain the cells whose category matches with the client ones in table 1. e.g. MAAS_report.xls containing: CA345985 CA290456 IND789345 SWE563843 and BWL_report.xls containing: CA345985 CA290456 NO893476 EE972086 This is only a simplified example. I would need to create these reports for hundreds of clients which all should be compared to table 2. Your help is really appreciated.

When I use batch deploy translate some files, then just success one file, and display these message on last lines, and fme version 2015.1.1.0?20150715 - Build15515-win32?.Creating reader for format: CSV (Comma Separated Value)Trying to find a DYNAMIC plugin for reader named `CSV'FME API version of module 'CSV' matches current internal version (3.7 20150407)child killed: segmentation violationFME encountered an error. Please contact

Dear FMEers,We are using the API to submit transformations and get jobs with the result when completed. This works fine but the numFeaturesOutput is always 0 even when features are written. Must be something simple but I can't find how to get this to work.Using FeatureWriters in 2016.1.And how can we put text in the Description Parameter?

hi,We are currently revamping our fme server infrastructure. We're are going from a 2 physical servers on windows with two engines on both to 4 virtual server with one engine on redhat. That's a pretty big change.We would like to compare performance before going to production with that configuration.Is there any benchmark workspace available for this?Thanks for your answers.With kind regards.Vincent.

Hello,In FME Server 2015 when I run any workspace by clicking on "Run Workspace" I get an error 500 and on the screen I see "Unknown result. No log file generated". On the other hand, if I copy the Direct URL, I open it in a browser and I enter user/password then the job is submitted without any error.The Error body looks like:Estado HTTP 500 - java.security.cert.CertificateExpiredException: NotAfter: Mon Mar 20 11:24:02 CET 2017</h1><HR size="1" noshade="noshade"><p><b>type</b> Informe de Excepción</p><p><b>mensaje</b> <u>java.security.cert.CertificateExpiredException: NotAfter: Mon Mar 20 11:24:02 CET 2017</u></p><p><b>descripción</b> <u>El servidor encontró un error interno que hizo que no pudiera rellenar este requerimiento.</u></p><p><b>excepción</b> <pre>javax.net.ssl.SSLHandshakeException: java.security.cert.C