Data

I'm trying to figure out how to access the FME_MacroValues['FME_JOB_ID'] system parameter.  I'm trying to link this script to a writers destination. Basically want to include the job ID in the file name of the output. I've attempted this using the code below but am getting the error shown in this log:Starting translation...INCLUDE -- failed to evaluate Python script `def ParamFunc():  import fme  return '\\\\ServerLocation\\logging\\failed_logs\\' + 'failed_load_' + FME_MacroValues['FME_JOB_ID'] + '.xlsx'value = ParamFunc()macroName = 'DestDataset_XLSXW2'if value == None:  return { macroName : '' }else:  return { macroName : str(value) }'Program TerminatingTranslation FAILED.Traceback (most recent call last):  File "<string>", line 5, in MF_Include_1490921734471  File "<string>", line 4, in ParamFuncKeyError: 'FME_JOB_ID'This is the python code:import fmereturn '\\ServerLocation\\logging\\failed_logs\\' + 'failed_load_' + FME_MacroValues['FME_JOB_ID'] + '.xlsx'

I am using an aggregated object to insert a cell using the dgnstyler. The aggregated object has 2 geometries, a point and a line. I need to use the line as a reference for the angle of the cell rotation, but I do not know how to derive an angle for this line. Can someone help me find a way to do this?

I'm using the Esri Geodatabase (ArcSDE Geodb) reader with Feature Read Mode set to Metadata, to read in GEMINI metadata from SDE. I'd like to manipulate certain elements before sending the updated metadata back to the SDE feature class. Using the XMLUpdater I've been able to amend the content for some elements, however I haven't had any success when trying to amend the revision date, as there are three different date strings all with the same XML path: metadata/gmd:GEMINI_Metadata/gmd:identificationInfo/gmd:MD_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:date/md:CI_Date/gmd:date/gco:DateCurrently none of them are getting updated on the output XML. The different date types are differentiated in the gmd:dateType element, e.g: <gmd:dateType> <gmd:CI_DateTypeCode codeList="http://standards.iso.org/ittf/PubliclyAvailableStandards/ISO_19139_Schemas/resources/Codelist/gmxCodelists.xml#CI_DateTypeCode" codeListValue="revision">Rev

Hello, I've searched all available online sources but none appear to have this issue.Very simple task: I've added an Oracle Spatial Reader, connected to desired table and now want to extract x/y but I get this error when running."Error - Cannot have NULL value for 'z coordinate'"I've looked at the table in Oracle developer and indeed the Z values are Null.I'm aware that this table has multiple Spatial columns so I've checked: Handle Multiple Spatial Columns: YesI've tried a SELECT statement to run before translation:SELECT c.GEOM.SDO_POINT.X AS X, c.GEOM.SDO_POINT.Y AS Y,  FROM A.ENTITIES c  WHERE ACCESS_CODE = 'O'I've tried to expose the attributes: oracle_sdo_point.x oracle_sdo_point.y oracle_sdo_point.zIs there a way to force this to 2D rather than looking at the Z values?Any ideas appreciated. 

When loading a 2016.1 Workspace in 2017.0, I saw this in the Translation Log:Workbench: Workspace integrity check during load found one or more readers/writers with configuration issues.Workbench: Backed up current workspace as: X:\\Path\\Folder\\Wibble (backup).fmwWorkbench: Fixed reader/writer configuration issues.How can I find out what was wrong with the Reader/Writers?

Probably a simple solution to this but I can't seem to find it.If I have a generic writer and I want to write out to dwg or dxf how do I enforce it to write to dxf, it defaults to dwg . I have tried lots of things like creating a dummy writer for ACAD or creating an output published parameter with 2 options for the AutoCAD writer with 2 different values-- this works but if I select DWG or DXF I still get a dwg file.I can add a tester which sorts whether the end user selected DWG or DXF and then filters it into an ACAD writer that has the extension hardcoded..but I don't really want to do that when I feel like I have just missed something? Any help would be appreciated

When translating text nodes into Microstation I have found that the linkage is not being created during the translation. Once the dgn is created I must select the text node and edit it before the linkage shows up. This is an issue when I need to project the data into a different coordinate system because the text nodes end up in a different location then everything else. Is there a way to have the linkage created during the translation process?

I simply want to import a drawing from a client which has the DGN extension; into AUTOCAD 2017. It says " DGN must be in version 7 or 8" and closes the dialog with an error. This FME software is far too complex for such a mundane purpose. I can redraw the entire project in less time than it would take to learn software such as this. Does anyone know of a simple tool to convert non supported DGN files to AutoCad 2017?

I have a directory of PDF files scanned in 1996, I have feature dataset linked by PDF filename the with another attribute field with correct document creation date. How can change the PDF filename properties of creation data?

I'm having an issue using the schema mapper to remap the schema of a Oracle 11g database and write thte data into a file geodatabase using FME 2017.0.0.0 Build 17236. I have succesfully mapped the SQL Server version of the same schema and data with no problems. If I set up the Oracle mapping I can get it to map successfully but it will fail to output to the geodatabase and will automatically output to an .ffs file. I can then open up the .ffs file and everything is mapped properly, just not outputting to the right location. Any advice regarding this issue would be much appreciated.

Hi, I'd like to create a inspire GML-file (using the inspire GML writer) without the <gml:boundedBy>-tag. <gml:boundedBy> <gml:Envelope srsName="EPSG:28992" srsDimension="3"> <gml:lowerCorner>96465.102 471796.29 0.00</gml:lowerCorner> <gml:upperCorner>145855.225 563146.105 0.00</gml:upperCorner> </gml:Envelope> </gml:boundedBy>Is there a way to generate such a zipped gml (with the INSPIRE gml writer) without the above text/tag. How do I prevent my workbench from generating this tag. Thanks in advance.Bas Boers

I have a series of workspaces that sync an Oracle Database with an SDE database every hour (ORACLE_SPATIAL and GEODATABASE_SDE Readers > GEODATABASE_SDE Writer). I created several relationship classes in the SDE database (via ArcCatalog), and now my workspace fails to update any of the feature classes that are involved in a relationship class.I am receiving the following error: Error while retrieving an ArcObjects update cursor for the table/feature class 'DBO.EL_SERVICE_POINT'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session}If I delete the relationship classes, the Feature Types update as expected.I tried setting geodb_feature_has_relationships to 'yes' before writing to SDE, but I still received the same error.Also, the Transaction Type on the SDE reader and writer is set to "Versioned Edit Session", as I am updating a versioned SDE databa

Hi All,I need to automate the process of cutting up an image file into approximately into 11,500 separate images.I have my image file. I have my grid shape file that contains attributes that I want to use as my output image file names.I can get image outputs using clipper that are exactly as I expect (correct dimensions etc) but cannot figure out how to name them correctly.I'm convinced that I'm missing something quite simple here.I have been searching through the knowledge center but can't find exactly what I'm looking for.Has anyone had experience with this? I'm using FME Desktop 2015

Hi ,is it possible to set a timeout-Parameter for writing in a Postgis-DB to ensure, that the connection will be closed.

Hello FME's geeks !I am looking for writing outputs as shapefile to a path that is derived from the concatenation of an input parameters, a given string and a timestamp.In other words, the path should look like $(input_parameter1)/$(string)-$(TimeStamp)In my case,The input parameter is a folder given by user (Main_Input_Folder)The string is the basename of an input file given by the user without extention (eg : C:\inputFolder\myfile.shp => basename = myfile)For now, I am able to concatenate the input parameter and the Timestamp (creating a Python scripted private parameter for creating the string) giving something like  $(input_parameter1)/$(TimeStamp) and use it to the "Destination Esri Shapefile Folder" parameter : However, to add the basename, I created another Python scripted private parameter to extract the basename (used code below) but when I try to add it to the "Destination Esri Shapefile Folder" parameter I get this error : Undefined macro `AOI_basebame' dereferenced in fi

Hello, My reader is a MapInfo table and my writer is a PostGIS database. I tested the database and I was able to successfully connect to the database. However, when I run the workbench only 1 record goes through and I get the following error: Error executing SQL command ('select * from "databasename"."tablename" where false limit 0'):'Writer failed in write() callAny idea of what is going wrong?

2017-03-15 19:46:42| 131.8| 0.0|INFORM|ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `bebop', user name `importantuser', password `***'

I'd like to report what I suspect might be a bug with the MySQL data writer. Applies to FME 2015 Workbench.I have a simple workspace consisting of a SQL Server data reader and a MySQL data writer. It reads a MS SQL table with some fields being a BIT data type. This then gets pushed out to a MySQL database (using a drop command first). I observed some problems with this, specifically to do with the BIT datatype. (1) - The MySQL data writer dialog lacks support for BIT type. The nearest type FME can use is TINYINT. See screenshot below. Even if I choose Manual attribute definition, there is no "BIT" datatype in the dropdown list.(2) - You would assume that there shouldn't be any difficulty writing a Bit (1 or 0) to a Tinyint. However FME reports errors during the write process. Even trying various different types: int, smallint, varchar produced same results.Insert failed on table 'lynx_animals'. Error was 'Incorrect integer value: 'Yes' for c

I'm new to FME, and I need to transform a Packbit compressed geotiff file to a LZW compressed geotiff file. I'm using a geotiff reader and a geotiff writer, the later configured to use LZW compression. The output file is still in packbits

I've looked around and I can't seem to find anything that covers the applications of coordinates/ applying a location to a 3D element. The idea being that I can extract a list of points into a csv file then represent the list of coordinates as a 3D element within a DWG/DGN/IFC.Any help would be great thanks.

Please see https://knowledge.safe.com/questions/41408/smtp-relay-not-installed-with-fme-server-2017.htmlSounds like either an error or lacking information.

I am using the latest build of Fme desktop and I am trying to use an autocad block that has dynamic content in it and is not working. If I take the dynamic parts of it out it works just fine. Does anyone know if Fme supports Autocad dynamic blocks?

I am trying the point cloud simplifier on a point cloud with 11 million points, but it is taking a very long time . It hasn't finished yet and it looks like it could take days to finish. Is it possible to speed up the transformer based on the parameter values?