Authoring

Hi All, I have a customer who is scheduling fme.exe from within Microsoft SSMS - because it has good logging functionality. The fme.exe command is taken from a desktop log file on the server machine. If they run the command in a shell it works, and scheduling with Task Scheduler works, but from inside SSMS as the sql_agent account they get 'FME license system failure: License dependency check failed. This FME suite license is dependent on another license which is not available. Program terminating. Transaction failed. Process exit code 2. The step failed. '. Does anyone have an idea what is the issue? SSMS scheduler has only the one user account available to run jobs, but I assume that could be changed. Thanks.

I am unsure as to why I'm not able to connect to NetSuite via the ODBC connector in FME. I have Windows 10 (64 bit), FME Desktop (2019.2 b 19801 64bit) with the ODBC (64bit) driver installed. I have verified that the connection works in ODBC Source Administrator and also in Excel.  The error I receive in FME is: Error connecting to databaseDatabase Generated Error Information:Database Error Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedDatabase SQL Statement Text:SQL State: IM002Variable Information:ODBC 3.x Reader: Failed to connect to databaseI have verified the data source name matches with the username and password in the reader parameters, but I am unable to connect. Any ideas as to what I could do to get it to connect? 

Hi, I seldom work with rasters so my question is basic, is the canonical way to convert MrSID to MBTiles to read pyramid level 0 from the SID, pass the image through WebMapTiler (with any zoom level filtering you need, or hands-free auto mode) then write to MBTiles with fanout expression @Value(_zoom_level) and feature type Somename_@Value_quadkey)? Thanks.

I've configured the SMTP Publisher to receive emails, but when I send them to FME Server I get undelivered responses.  I looked at the email.log for the FME Server Publishers and I see: "WARN Email received for unknown recipient [email address], so dropped  What does this mean?

Getting back to my little project started here after a brief hiatus... I am having trouble making a file uploaded to the 'Resources' folder using the Javascript API the input for a workbench. Using ...FMEServer.dataUpload( repository, workspace, fileObject, session, callback);I can get the file to be uploaded to here:$(FME_SHAREDRESOURCE_TEMP)/upload/MyFolder/MyWorkspace.fmw/Now, I want to use:FMEServer.runWorkspaceWithData( repository, workspace, params, callback)to process the uploaded file but all attempt to feed in the correct 'params' is failing. The workspace is still going back to the default parameters that it was published with. Currently, I'm trying this:var params = {          { "publishedParameters" : [{ "name" : 'SourceDataset_CSV2', "value" : <resourceFolderPath+inputFileName >},{ "name" : 'DestDataset_JSON', "value" : < ?????>}],  "service" : "fmedatastreaming" };Not sure  what to put for the destination value that I'm trying to capture. Javascript API docume

Hi, I'm inefficient with CSS selector statements - having no HTML authoring background. I want the CSV download links at this site and only the csv download links:https://data.sandiego.gov/datasets/parking-citations/I can get all 'a' tags and the href references no problem but have to test the result ends with '.csv'. Can anyone give me the right selector syntax for the element I'm after? Thanks all.

I have 1 table that has one column called mbipk with a number value and then another column called sales with a number in it. I want to run it against 16 other tables which also have that same mbipk column, I want it to match only the mbripk number and if that matches then I want it to inject a new column called sales_2 and put the sales number from the 1st table into sales_2 into table 2. Is this possible?

I had an issue with a workspace with a disabled junction. I then discovered that disabled junctions won't get grouped in the navigator as disabled transformers and disabled connections do. Is this on purpose or is this something that can be improved? I expected them in the "Disabled Transformers" group. The workaround is to search for "junction" in the workspace search, this will display all junctions and mark the disabled junctions grey. Tested in 2021.1.1.0 (20210730 - Build 21619 - WIN64)

Greetings,I'm running a workspace through FME Python API using FMEWorkspaceRunner, and need to ensure that the 'redirect to fme data inspector' parameter is toggled off prior to running. How can one access this workspace parameter?Thank you,TylerFME 2021.0.0.1Python 3.7

Hello, before writing a Python script, I'd like to know if there is a way to retrieve the lines between a point A and a point B using classic transofrmers?  

Hi authors.FME workspaces are stored in a specific and well-known structure on an FME Server. So finding the path of another workspace is feasiable.I'm wondering whether I can use WorkspaceRunner to submit other workspaces on an FME Server instead of FMEServerJobSubmitter ?Is this completely no-go, or are there benefits, such as running more workspaces within a single job ?It would also simplify building and debugging on desktop.Any insights are appreciated.Cheers

Hi.When you have a workspace with a published parameter of type text, and it has a default (e.g. testing) value, this gets used whenever the value isn't specified in JobSubmitter/WorspaceRunner.If I submit a blank text as a parameter value, this seems to be ignored, and the default value is used instead.Is this WAD ?If I want to overrule a default parameter value with a blank value, how is this achieved ? Cheers

Hey all,I am using the ArcGIS Portal Feature Writer and when I push my edits to a feature service, it overwrites the editor tacking fields (eg. createdby, createddate, modifiedby, lastmodifieddate) with my username and today's date and time of upload, instead of values I have prepopulated. The table sits in a postgres database and I have turned editor tracking off against that table. Is it possible to push data using the FME writer without those values getting automatically populated?

Undefined macro `SourceDataset_FILEGDB_3_FILEGDB_3' dereferenced in file `A:\\...\\...\\FME Worksapces\\wb-xlate-1459541027202_6756'Program TerminatingThis error happened to me today for no identifiable reason. If anyone has encountered this issue or has an idea as to why this could happen I encourage you to share your thoughts here. After this happened two files were created in the folder where I store my work spaces (Not where temp files go).wb-xlate-1459541027202_6756ANDwb-xlate-145865875395_6136A peculiar thing happened to one of my readers and it kept "resetting" to not being set (<Not Set>). So you could not open the containing folder or edit the path. It had no options, but the schema and the reader were still in the workspace.At first I tried rolling back to the very beginning of my work flow history to check if the translation would run when it used to run, but no, I got the same error.The problem can be fixed by copying over the entire workflow into an

I would like to import a select number of tables from Oracle Spatial Object into ESRI geodatabase_SDE (ArcSDE Geodb), where they are given a new table name.I can do this one table at a time, but is there a method where I can batch or loop this process, as I have a large number of tables to process.I have both the required input and 'renamed' output table names in an excel spreadsheet.Please note - I do not want to import the whole database, only a select number of Oracle tables which are then given a new name in SQLserver.

Hi, currently all my zipfile output from my FME Server App using the Data Download Service are being named with "FME_" following by some random numbers. I would like to ask if there is any guide to change the naming of the zipfile, be it through the FME Server UI or configuration files. Thank you. 

Hello FME users,I just wanted to share some information about an update to data types in FME2020, which I don't think has been publicized much. The best demonstration is through a video, but first here's a brief description of the update...Data Type PreservationIn previous versions of FME, attribute data type would not be preserved fully throughout a workspace. For example, a writer could not determine the data type of an attribute added or edited in the workspace.You could prove this by following these steps:Open FME Workbench 2019Add a writer and set the feature type attributes to automaticAdd an AreaCalculator transformer connected to the writerThe result is that _area is added to the writer, as type char(200). The writer was not able to tell that this attribute should be a numeric type. You would often see char(200) fields as a default for unknown types.In FME 2020 this has changed.If you repeated the above step in FME 2020, the result would be a real64 field (or the equiva

I am new to FME and going through the unit "Quickly Create a Conversion Workflow " of "Integrate Your Data with the FME Platform". In that unit, we create a reader to a PostGIS database. My understanding is that what we see on the canvas is just the "feature types" of that database, aka individual tables. I thought that they would all connect to the same "reader" in the background. But when I added two new readers to the canvas (marked 2 and 3 in the image), they created brand-new readers in the navigator. Even in the case of reader 3, which has the exact same parameters as reader 1!Can you please suggest if there's any way to modify the feature type marked 3, to make it use the reader marked 1? When I open the feature type's properties, they are greyed out. The only options I see right now are:keep both readers and maintain "connection parameters" in both, orrecreate that feature type from reader 1 and manually configure it as

Hello, I’m looking for a way to classify (order) the lists within a list attribute. Essentially I need all lists that have a “phase” value of ‘R’ to be on listattribute{0}…all list values that have a “phase” value of ‘Y’ to be stored in listattribute{1}…and all list values that have a “phase” value of ‘B’ to be stored in listattribute{2}.  Using List Sorter, I am able to accomplish this as long as there is a list for all three phases. The data sometime has only 1 or 2 phase values (example: Y and B, but no R). If I sort the lists that only have two phase values, “Phase” = ‘Y’ ends up in listattribute{0}. How do a force a blank list value for ‘R’, so that ‘Y’ still gets stored in listattribute{1} and ‘B’ gets stored in listattribute{2}?.... listattribute{0} could remain blank  These lists need to be structured correctly so that I can run them through an XML Templater and have them placed in the correct spot in the XML. Update - I have attached the workspace and the xml template that cal

See attached images. I'm trying to read a Geotiff of an engineering drawing. When I view it in 3Dpaint the pixel values vary between black, grey and white. But when I read it in FME all the pixel values are either black (0,0,0) or white (255,255,255). I want to sharpen the image by filtering out the grey pixels. But how do I read the file to expose the "grey" pixel values?

I have a gdb with domains with a lot of feature classes and tables. They all have 8 fields that are the same and the remaining fields vary from feature class to feature class. I want to populate those same 8 fields with the same value for all the features but maintain their schemas. I tried doing this with an attribute manager and writing with the template file geodatabase with the attribute definition set as dynamic. I've also tried adding the values to the attribute definition. I know there must be a way, I just can't figure it out! TIA

I need to write to a single excel file with multiple sheets using a template. I've created a template with multiple sheets formatted as I need them but when I write to excel, it will only write one of the sheets and leave the others blank.

import osimport requestsimport jsonimport cv2 directory = r'C:\\boatlaunch'for filename in os.listdir(directory): if filename.endswith(".jpg") or filename.endswith(".jpge") or filename.endswith(".JPG"):  print(os.path.join(directory, filename))  filenamepath=os.path.join(directory, filename)  url = "https://<servername>/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/EnvironmentAffair?createDirectories=false&overwrite=false"  head={   'Authorization': 'fmetoken token=<mytoken>',   'Content-Disposition': 'attachment; filename="test.jpg"',   'Content-Type': 'application/octect-stream',   'Accept': 'application/json'   }  print(head)  filedata = open(filenamepath,'rb')  print(filedata)     res = requests.post(url,data=filedata,headers=head)  print(res.status_code)  print(res.text)  print(res.request.headers)

In the ExcelStyler, it is possible to add a border style to a row.  It gets a value like:version<semicolon>1<semicolon>cell_border_style<semicolon>BORDERSTYLE_THICK<semicolon>cell_border_color<semicolon>0<comma>0<comma>0However, I only want to apply it to the bottom of that row, which is not available in the interface. Does anyone know whether it is a possibility to extend the current formatting value and apply the border style to the bottom only? Maybe something similar to:cell_border_type<semicolon>BOTTOM<semicolon>but then with the right values

We have a custom transformer Updater in FME 2019.0.2.0 which uses a DateTimeStamper to extract the current date and time into an attribute. Geographical location is Denmark.The custom transformer is called at 4 different places in the workspace and the last two are reporting the following message (only shown for custom transformer number 3): 2019-06-26 10:57:43|  50.4|  0.0|WARN  |Updater_3_DateTimeStamper: Failed to parse '20190626105743.717495+02:00' as a datetime value. For FME datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm. For ISO datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm#ISO-8601-Duration-Format2019-06-26 10:57:43|  50.4|  0.0|WARN  |Updater_3_DateTimeStamper: Failed to evaluate expression '@DateTimeCast(20190626105743.717495+02:00,datetime)'.  Result is set to