Authoring

Hi all, I have a workbench which returns multi page .Tiff files as xml then outputs back to Tiff. I use the XML Flattener, TextDecoder and RasterReplacer transformers to decode and rasterize the images. I then write to Tif but the writer only returns the first page of the multi page Tif. Any ideas on how to return all of the pages? Below is a screenshot of the process. I'm thinking it could be something to do with the RasterReplacer not populating the tiff_subdataset_name' which delineates a multi page Tiff file.Thanks,Stuart

Hi, I would like to know if the following is possible and how: I have several identical Access backend databases (one for each client, same scheme - different data, several relationships, links and foreign keys). I would like to merge all of them to one MS SQL database and add an identifier for each client data. One time only! How to handle original relationships? Example: InvoiceID and InvoiceLine for each original database. I’m talking about Access DB, but I could convert them all to MSSQL and then merge… All front ends will connect to this database, but each client will be able to see only each own data. Any help? Thanks! Jairo

Hi,Web and Database connections are great but you can create the same name for Web and Database in FME Desktop under options, but when you load it to Server it comes back with duplicate name already existSurely options in Desktop should adhere to the same rulesJust an observationRudy

Is there a notable performance difference between SQL Creator performance vs. Oracle table Reader performance. We have a script that take 3.5 hours to run and are looking for ways to help it along.

This answer probably exists, but still can't find it...I'd like to install custom reader on FME Server (2017.1.1.). Double clicking installs only on FME Desktop.Thank you,

HI! I installed Anaconda on a windows server, for all users, then I followed the set-up in my workspace TOOLS > "FME Options" > Translation >  "Python Interpreter" checked "Use Custom Python Interpreter" and provided the path (C:\ProgramData\Anaconda3\python36.dll)The log then shows : Loaded module 'PythonFactory' from file 'C:\Program Files\FME2016\plugins/PythonFactory.dll' FME API version of module 'PythonFactory' matches current internal version (3.8 20160224) The user-specified Python interpreter `C:\ProgramData\Anaconda3\python36.dll' is version 3.6 (PythonFactory): A Python installation could not be detected. PythonFactory could not initialize A Python installation could not be detected. PythonFactory could not initialize A fatal error has occurred. Check the logfile above for details

Hi,Initially, auto-layout is working well, but suddenly showing the error as shown below...Does anyone came across and identified solution for it...

Reader is a single merged feature type reading 6 tables from an oracle database. Then using a feature type filter to export out the different tables, but the export contains the attributes for all the tables. How do I get the writer to just read the attributes for a particular feature type? Also when I update the feature type filter it removes all the tables and just adds one of the tables

Hi! I have a HTTPCaller transformer in workspace that downloads 80 MB of data in the same feature attribute before failing. Once it fails, FME desktop attempted to write a feature in the log dispaly and display. The data it tried to display is so big such that the FME desktop crashed. Is there a way to still let it write, but truncate the size of each attribute?Thank you!

Hi,I was wondering could any of the python experts help me. I'm trying to write a python shut down script that calls FME Server and passes some parameter values into a workspace to run on Server.I can successfully do the same on Desktop- run a workspace collect information in the shutdown script about featuresRead, featureswritten, timings and so on and kick off a new workspace using these values which records and reports on this.So I was testing could I complete the same task on Server -- I am able to run the workspace on server as part of the shut down script but right now I am just populating all the parameter values with "Test".#Building URL for FME Server# fmeURL='''http://SERVERFME03/fmejobsubmitter/Samples/samplepythonlogging.fmw?DestDataset_XLSXW=C%3A%5CFMESERVER_PRIME2%5Cshutdown%5Ctest_write.xlsx&Written;=test&Read;=test&FeaturesLogged;=TEST&Time;=TEST&maxmemory;=TEST&Status;=TEST&Error;=TEST&Location;=TEST&Workspa

Hi,I'm using FME Desktop 2017 to write features to a feature class in a geodatabase using a dynamic schema definition. The dynamic schema is necessary as I'm using an AttributePivoter transformer. When I selected "Dynamic Schema Definition" in the Feature Type Parameters, FME automatically changed the Feature Class name to the attribute "fme_feature_type". Whenever I try to change anything about this, my workbench doesn't work anymore. Can I change anything about this? It'd be quite useful to assign a name different from fme_feature_type...Any hint is appreciated ;-)

Hi i am converting DWG to FileGDB and using Geometry Filter, while translating "A" Layer is being divided in three parts i.e A_Point, A_line, A_Polygon similarly "B" layer to B_point, B_line etc.I want to change the layer names in writer, I am using Dynamic Writer. Do i need different dynamic writer for each layer or any other option?

If my FME Server port is 8080 and i have created a topic and publication with username "myUser" then what will be the email address to receive email?my server address is myserver.mydomain:8080/fmeserver

Hi! I am writing a translation, and thinking about how to handle an unexpected situation while there is eventually no feature going through a pipe. For example, when a reader or a http call returns nothing, it usually indicates some error or rare situation, such that I may want a email to be sent or some message to be logged.I tried but couldn't find a simple way to do that. Except a way that seems unnecessarily complicated: fire a feature by a Creator, pipe it into the requestor of a FeatureMerger, let the port to be checked connect to the supplier port of FeatureMerger, connect the NotMerged port of the FeatureMerger to the "rare case" handling transformerHowever, this method seems unnecessarily complicated to me if I only want to do simple handling such as writing a log message. Is there easier way?Thank you!

HiI have a workbench that goes like this :Using FME Desktop 2014 (build 14339)I'm using a FeatureReader to extract data (from SDE).I'm using a FeatureReader to extract SCHEMA (attribute name and type) from the data extracted from SDE).The schema is extracted because I need to change an attribute type before writing it to MapInfo (an SDE date attribute is formatted as fme_datetime and for MapInfo I need it to be fme_date).I'm using python to change this and it works perfect.Then I merge the extracted schema to every feature with the FeatureMerger and then output the data in Mapinfo.The real problem is that I now need to change an SDE float attribut to a mapinfo decimal type (fme_decimal(10,5)).FROM SDE : fme_data_type = fme_real64 and native_data_type = doubleTO MAPINFO : the type is FLOATI try to change the fme_data_type and native_data_type to double (fme_decimal(10,5)).In the workbench it's ok, but the mapinfo output is still FLOAT.Any Idea?Thanks!Francis

I am running a workbench to validate overlapping polygons My table structure is versioned spatial tables I have ran the validation workbench against one version, using a published parameter setting the override version. This has been successful for a single version. I want to automate validating a large number of table versions. I have attempted to use the workspace runner to achieve this. In order to change the override version. With the idea that this will run for each table version. I have a tried using a CSV list of the versions and I have tried reading directly from the Oracle version table list. I have been unable to produce an output with test cases, these test cases produce an output when run against an individual version.I think the workspace runner is failing to change the override version published parameter instead running against the SDE.default version for the same amount of versions within the CSV list.I would be greatful for any help or advice, at a bit of

HiI am using FME to transfer data from Oracle to PostGISFor a couple of my tables I don't want to include some fields, however some of the fields to be removed have the same name as fields on other feature types that I want to keep.Can I specify which table to remove the attribute from in the dynamic writer properties?Thanks

In the 'Using Python with FME Server' doc, step 2 asks to run the command python get-pip.py however, the server we are configuring is offline so we get an error 'Failed to establish a new connection'. What are the steps to get get-pip installed?

Hi! I am using a writer to write to a non-version ESRI SDE feature class. For now I pass some parameter to the "Truncate Table" of the writer. When the parameter is "Yes", the writer deletes everything in the feature class before writing new records, as expected.When I tried a situation that the parameter is "Yes" but there is no feature to be written, the feature class is not going to be truncated. This is the behavior I want. However, I couldn't find any documentation about this scenario.Is there any documentation I can use to verify my implementation is ok? I am trying to avoid using undocumented feature as much as possible.Thank you!

Could you please take a look at this:https://knowledge.safe.com/questions/54930/statisticscalculator-bug.htmlMy first reaction is that it's indeed a bug.

user selects one feature class (published parameter) and fme writes to one to six formats(like csv, shape, dgn, acad, xls,mapinfo etc...)in the fmw i am asking formats to write via published parameteroutput_format =dwg,shape, xls  like(comma separated)then i used python prg  to split these values create new attribute for each format(yes)import fmeimport fmeobjectsimport mathdef frq(feature):    my_list = feature.getAttribute('_list{}')    ESRISHAPE=''    XLSXW=''    CSV=''    AUTOCAD_OD=''    AUTOCAD_DWF=''    FILEGDB=''    for item in my_list:        if item=="ESRISHAPE":            ESRISHAPE="YES"        if item=="FILEGDB":            FILEGDB="YES"        if item=="XLSXW":            XLSXW="YES"        if item=="CSV":            CSV="YES"        if item=="AUTOCAD_OD":            AUTOCAD_OD="YES"        if item=="DWF":            AUTOCAD_DWF="YES"    feature.setAttribute("ESRISHAPE", ESRISHAPE)    feature.setAttribute("XLSXW", XLSXW)    feature.setAttribute("CSV", CSV)    feature.setA

I am trying to create a single ini file from multiple database tables. Each table has two columns LCODE,LVALUE.Each table name should become the section heading and the items below them should contain the rows in the format LCODE=LVALUEThere should be a single empty line between the last row of a section and the next section headingThe ini file would look like this:[ARTWORK_MATERIAL] STEEL=PLAIN STEEL ALUMINIUM=UNPAINTED ALUMINIM[ARTWORK_TYPE] SCULPTURE=The artwork is a sculpture MOSAIC=The artwork is a mosaicand so on.Any help would be fantastic.CheersPaul

I am looking for a way to add the previous months name to the filename of an output Excel e.g. Filename_August.xlsx.I have been trying to do this with Python (I am a Python beginner) as a Private Parameter using the following:from datetime import date, timedeltafirst_day_of_this_month = date.today().replace(day=1) last_day_prev_month = first_day_of_this_month –timedelta(days=1) prev_month_name = last_day_prev_month.strftime(“%B”) print prev_month_nameThis works in python but it fails in FME.Any ideas?

Windows 7 / FME Desktop 2017.1.0.0 build 17539FeatureReader with PostGIS. In the FeatureReader, in the (PostGIS) Parameters, in Schemas for Table Listing, the schema "data" is saved as my default. Works like a dream.Every now and then I need to edit a workbench with another schema already configured. Now it comes: when I open the FeatureReader to edit the Feature Types to Read, I get Failed to retrieve feature types. I believe my default PostGIS schema setting is overriding the original configured schema.I wonder if this is how it should work.