- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,048 Posts
12,635 Replies

When you subscribe we will email you when there is a new topic in this category

3048 Posts

agelfertContributor

Correct way to override default value in published parameters when running workspace from Javascript API.

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

111

3 years ago

bruceharoldContributor

asked in Authoring

HTMLExtractor help appreciated

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.

Join 2 tables merge data from one column after matching data in another column.

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?

3 years ago

nielsgerritsVIP

asked in Authoring

Disabled Junction not in "Disabled Transformers" group in Navigator.

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)

3 years ago

townestContributor

asked in Authoring

How can one Toggle off 'redirect to fme data inspector' through FME Python API.

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

How to retrieve path from point A to point B (geometry)

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?

4010

3 years ago

lifalin2016Contributor

asked in Authoring

Using WorkspaceRunner on FME Server ?

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

3430

3 years ago

lifalin2016Contributor

asked in Authoring

Default vs explicit blank values in ServerJobSubmitter/WorkspaceRunner ?

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

3 years ago

tiztrainContributor

asked in Authoring

ArcGIS Portal Feature Writer - With Editor Tracking Disabled - Still overwrites

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 'FILE_TYPE' dereferenced in file 'FILE_PATH' error

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

Batch import routine of database tables

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.

Rename zipfile output from Data Download Service

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.

1010

3 years ago

mark2atsafeSafer

asked in Authoring

Attribute Data Type Preservation in FME 2020

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

Why does FME Desktop create duplicate Readers for the same data source with the same connection & parameters?

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

How to classify lists within a list attribute?

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

600

3 years ago

eric_armitageContributor

asked in Authoring

Issue reading Geotiff

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?

240

3 years ago

hannahwh05Contributor

asked in Authoring

How do I update the same field values across multiple schemas within a .gdb?

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

180

3 years ago

mcannalea12Contributor

asked in Authoring

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.

Upload files to resource folders using Rest API. I am getting 415 HTTP error. Below is my python code.

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)

1340

3 years ago

jelleContributor

asked in Authoring

Apply border style only on bottom with ExelStyler

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

180

3 years ago

chauContributor

asked in Authoring

DateTimeStamper: Failed to parse

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

490

3 years ago

erik_janContributor

asked in Authoring

Python Shutdown script not executed

Anybody an idea why this combination would not work?The Shutdown script seems to not executed.Startup scriptdef initializeArcFM(): import win32com.client global app app = win32com.client.Dispatch('Miner.Framework.Dispatch.MMAppInitializeDispatch') runtime = win32com.client.Dispatch('Miner.Framework.Dispatch.MMRuntimeEnvironmentDispatch') app.Initialize(0x5) runtime.RuntimeMode = 0x4 print "ArcFM runtime mode", runtime.RuntimeModedef cleanupArcFM(): global app if app: app.Shutdown del app print "ArcFM shutdown"initializeArcFM()Shutdown script cleanupArcFM()

5111

3 years ago

benvkContributor

asked in Authoring

Help creating dynamic input user parameter drop down list, and then the dynamic output file attributes

I have recently installed FME Server I have been working through some tutorials, and reviewing the examples installed on the server, to see if I can automate some things I currently do manually. The first one I am working through is actually based on one of the tutorials in the server training material (Ex 3.3 here). What I am hoping to achieve is that we can have an FME Server tool that the user can access, select from a list of arcgis online feature layers (things like watermains, property boundaries, etc), then the user can draw a polygon on a map to define the extents, and FME will output this data to the user, including ALL attributes within the selected Feature Layer. Currently I have the attached template, it kind of works, as in it successfully exports the correct spatial data, but for the life of me I cannot work out how to get the attribute data of the selected feature layer to be export to the XLS output file. As previously mentioned, the second thing I am trying to work o

4230

3 years ago

larueContributor

asked in Authoring

Centerline Replacer comes up short.

I am trying to generate centerlines from parallel line pairs which are transformed into bounding boxes, then areas. This works but the centerlines do not extend all the way to the edge of the area/bounding box:There does not seem to be any settings in either bounding box, area builder, or centerline replacer to change this. Am I going to have to add a snapper? Any reason why it does not go to the edge? Thanks,@larue

Folder structure returned in the zip file from FME Servers Data Download Service?

Hallo! I'm trying to set the folders in the zip-file for my data download service, as discribed in this question It works the first time I set the folders. But when I need to do a change in the zip-file order, the value of the 'Path to zip-file' are 'stuck'. Even if I edit them, they go back to the value they were initially set to. How do I get around this? Best regardsKicki M

300

3 years ago

Page 22 / 122

Badge winners

havermhas earned the badge English Speaker
havermhas earned the badge German Speaker
karthikahas earned the badge FME Form Basic Training
karthikahas earned the badge English Speaker
karthikahas earned the badge Welcome Back

Show all badges

30,405: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.