Authoring

Novice question (my DOS days are very, very far behind me). I am trying to copy files (photo's) from one location to the other using system caller. The problem I encounter is that only the first photo get's copied. I use this line in the systemcaller: F: && cd F:\\folder\\photos\\ && md 10122019location && copy F:\\projects\\2019\\location\\drone\\fotos\\\\DJI_0503.JPG F:\\folder\\photos\\10122019location\\DJI_0503.JPG Of course the photo name changes for every photo I want to copy using @value(photofilename), but it only copies the first photo. How do I copy all? I do not want to copy all photo's in the source folder, else I could use *.JPG.

I am using a pythoncaller to access Zoom API to download unique meeting IDs. The code is:import ssl import http.client import zipfile import fme import fmeobjects # Template Function interface: # When using this function, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter def processFeature(feature):   pass   # Template Class Interface: # When using this class, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter class FeatureProcessor(object):   def __init__(self):     pass   def input(self,feature):     self.pyoutput(feature)   def close(self):     pass   #Setting User Parameters MeetingID = "?????????"   conn.request("GET", "/v2/past_meetings/"+ MeetingID +"/instances", headers=headers)What I would like to do is set MeetingID to feature.getAttribute('SCO_Zoom_Meeting_ID__c') where that is a value returned from a query from my database.  I would appreciate any help. If 

Is there a way to set up a workbench that would loop through an Enterprise SDE database & provide me with a list of layers without adding multiple readers? And also allow me to extract data from at least one of the attribute fields in each layer? How about using python? Thank you in advance.

If a User Parameter ends in a backslash - such as a Windows path, then accessing that value in a PythonCaller results in extra text. Example: if a User Parameter called foldername has the value: frog\\ then using fme.macroValues['foldername'] or FME_MacroValues['foldername'] in a PythonCaller returns:frog GUI OPTIONAL TEXT foldername Folder name:

The task is to migrate data from smallworld and oracle to sql-server.The data contains multiple geometry columns. So I've followed Writing to Database Tables that contain Multiple Geometry ColumnsI managed to insert the records but the geometry trait information is missing.Here is an example of Oracle:And here an example of Smallworld:The FME translation results in sql server:So the traits information is lost.Can I keep the trait information stored in Smallworld as "Text Rotation" or in Oracle called "oracle_orientation" into the sql db?Is there an sql-server equivalent? 

I have a workflow that reads data from one database and puts it in another (postgres).  My question, as an FME newbie, is how can I run another step after the Postgres Writer step - there seems to be no output port on the Writer module. The intent is to wait until the writing is complete, then run a GeoWebCache reseed step (though it could be any other step, really).   

Hi, I have created Excel xlsx files using FME (using a Template and adding values in, for various formulae to use the inputted values to calculate others), and it works really well! My issue is then when I read that xlsx file back through FME, the formula (IF statements mainly) don't pick up the inserted values! I have them formatted as Numbers in both Excel and FME, and the statement is similar to '=IF(AB8=0,"No Maps",AB8)', which works well when opening in Excel, but every value is 'No Maps' for the above cells when opening in FME! Very frustrating! I'm running FME Desktop 2020.2.4, 64 bit. Thanks!

Trying to read from SDE but I get the following error:Unable to read from the table/feature class 'schemaName.tableName'. If 'schemaName.tableName' contains a class extension, make sure it is registered on this computer.Yes, there is a featureclass extension and it is correctly installed on the same machine. Arcmap is showing the parcels ok. The sde backend is postgres and SDE 10.6.1    

Hello, I have a field in a database where KML's are uploaded and stored in Base64. Is there a way to export those and convert them to KML within FME? My end goal was to convert to KML, then covert them to shapefile for a Portal Layer. For example attached is one of the files encoded that I confirmed is a KML by manually decoding it outside of FME. I tried the BinaryDecoder transformer, but I wasn't sure what to do with the result. 

Last week we upgraded FME Server to 2020.1. Since then our Data Streaming and Job Submitter Services as applied via webhooks don't work anymore. The log files indicate some AccessDenied-problems.localhost_access_log: Post call receiveddatastreaming and jobsubmitterservice logs: request received. Fatal error: Service failed: java.nio.file.AccessDeniedException: E:\\FMEServerData\\resources\\system\\temp\\requestdata\\1710266074152417324FME Server runs on a service account with admin rights to all of the server.How to solve this?

I've got a bunch of AGOL Feature Layer (hosted) created with different schemas and I'm combining them into One AGOL Feature Layer (hosted). I can see the AGOL READ is seeing the "Photo Attachments", I can fix schema/attribute variations but "Photo Attachments" are not moving across the New Feature Layer.

I have a fairly complex workspace that does a few different things. Is there a way that I can select a transformer and copy all its dependencies as well? It's able to do a similar thing when we run the left green arrow in feature cache mode. It'd be great to see an ability to select and copy the objects as well if we want to pull it out into a separate workspace.

This morning I stumbled upon the Recorder and Player. After reading the documentation I was really eager to try them out in a workspace for storing temporary files. We also tested the performance by comparing with a FeatureReader / FeatureWriter and we didn't find any big differences when the compression-level of the Recorder was low. However when increasing the compression level, the performance was increasingly worse with the Recorder in comparison with the FeatureWriter. Is the only advantage of the Recorder in stead of the FeatureWriter that it can compress the data? When do you use the one or the other?Thanks for your thoughts!

What should I do if I have an idea for improving FME? Previously I sent these to FME's support team and they filed it in their internal tracking system, but I never knew if others had the same ideas or maybe even some alternative ideas and approaches. I really wish I could see what everyone else thinks. Is there a better way?

Hi I have a table containing 2 columns StartPt and EndPt [see attached]. I would like to find all the connected nodes for each StartPt in the table. For example, the connected nodes for Startpts 107224 and 100561 are: StartPt EndPt107224 100561107224 101420107224 107197107224 107196100561 101420100561 107197100561 107196100561 103058 Any suggestion how this can be achieved in FME. Alternatively, I could look at doing this via a stored procedure. 

I have some difficulty with using Feature Writer and Oracle Spatial in FME version 2020.2. My workbench reads from a Shapefile and then I'm using Feature Writer to write the features into Oracle for which I then want to trigger another process. The format I am using is Oracle Spatial Object. The problem is that the Feature Writer will not write the geometry to the records, so I end up with a table with a blank geometry column. I've carried out some investigations to narrow the source of the problem. If I choose Geopackage (instead of Oracle) the geometry is written. If use the standard Oracle Spatial writer with same connection then the geometry isalso written. What am I doing wrong for the Feature Writer to behave like this or is there a bug? Is there a work around?

I can connect everything up but I get an error when I use either the Column Match or the Where clause options. I am not trying to update the geometry at all just hyperlinks to documents. Thanks ===========================================================================FileGDB Writer: The `LMS_PERMITS_KEY' attribute could not be written. The containing feature has been dropped+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Lands/IPCoROW'Attribute(encoded: UTF-8)  : `DOCLINK' has value `HTTPS://GISAPPS/GIS/LANDS_DOCS/TTLSE/51368,111-63345/120-V1-120-V1-587291 T3NR2W SEC 8.PDF'Attribute(string)      : `Easement_Key' has value `45031'Attribute(encoded: UTF-8)  : `HISTDOC1' has value `HTTPS://GISAPPS/GIS/LANDS_DOCS/EASEMENTS/111DISTRIBUTION/587291 T3NR2W SEC 8.PDF'Attribute(string)      : `filegdb_type' has value `geodb_no_geom'Attribute(string)      : `fme_db_operation' has value `UPDATE'Attribute(st

I want to make an Automation where the flow goes first trough an workspace which reads data from an database. Depending on the feature type it then goes to different Automation Writers. Each of these ports are then connected to its own workspace so it can be run parallel. Eventually they merge back to another workspace which writes back the data to the database. The problem I have now is that thousands of features reach the Automation Writer thus kicking of the next workspace thousands of time. Obviously that is not what I want. What is best practice to collect and group these features and pass them on as one feature. I tried using the Aggregator Transformer and adding the parameters to a list, but it seems that it is not supported by GeoJSON. I use FME Server 2020.2

Simple task of applying attributes from a polygon onto points.Whats faster - Spatial Relator or Point On Area Overlayer?Let me know brains trust.

Has anybody tried reading data from a PI Historian database with FME?I know it has both ODBC and JDBC connection options.If so, could you share some knowledge?Thanks, Erik Jan

I cannot get the ExcelWriter to use the ExcelStyler's formatting. I have found a demo worksheet in another question which works fine. I have deleted the writer and replaced it with my own (I think identical) writer, but it's not working and I have no idea why! I have attached both worksheets. If someone could point out the difference between the two I would be very grateful. I've tried a diff checker against the XML code in the files, but nothing is jumping out at me.

A question about how FME handles multiple spatial columns in the same record in an oracle spatial table. So say I have a table with 2 spatial columns, SHAPE and SHAPE_PT So, Oracle spatial Reader, If i leave it with the Parameter to Handle Multiple Spatial columns to No, when I run it, it will log choosing SHAPE to hold geometry at runtime. If I use a SQLExecutor using Oracle Spatial Object type, and I run it, at runtime, it will log choosing SHAPE_pt to hold geometry at runtime. So 2 questions: 1- if I leave the reader to Handle Multiple Spatial columns to No, can I always be sure it will always pick the SHAPE column and not the SHAPE_PT ? 2 - In the SQLTransfomer, I do not see any option to handle Multiple Spatial Columns, is that option there someplace and I am nto just seeing it? Is there a way to tell it to use one geometry column vs the other ?   

Is there a way to write a tables schema and data type out to a text file?

Hello,I am publishing workspace to Data Download service. I would like to edit the path in the resulting ZIP file, according to this article: https://community.safe.com/s/question/0D54Q000080hM9QSAU/how-can-i-change-the-folder-structure-returned-in-the-zip-file-from-fme-servers-data-download-service?t=1612527866370It works when I upload the workspace from Desktop 2019.1 to Server 2019.1. But it is not working when I upload from Desktop 2020.2.2 to Server 2020.2.2.  In zip there are still "default" paths like CSV_1 or TXT_1 folders. I want there no path, just result files directly inside the zip file. I tried to upload from Desktop 2019.1 to the latest Server, but it did not help.I tried to restart Desktop, put there new writers, delete the workspace manually from the Server and upload it again. But nothing helps. Any advice? Thank you...

Hi : We are trying to use the fmelicensingassistant_cmd utility to check for FME Desktop license counts prior to running some of our scripts that launches (fme.exe). Without doing this pre step, we end up triggering a very unfriendly error when no licenses are available, and users would think the system is broken. From my testing so far, it seems the utility is always returning 1 more license being used than actuals. (as compared to running the LMTOOLS on the licensing server) And, if all licenses are actually in use, the utility will take roughly a minute to respond, at which point it will still, report that all licenses are in use. Neither is desirable and this behavior prevents us from actually determining available licenses. Is there anything I am doing wrong?  By the way the specific license type we are looking at is the Smallworld license.This is the command I'm running:fmelicensingassistant_cmd.exe --query <servername>:27000 Any help appreciated!