Creating and organizing workspaces. How to use Workbench.
Recently active
I would like to use HTTPCaller to grab the contents of a file from a webserver and store it in an attribute as a binary and then use a FeatureReader type of transformer to parse the binary attribute. I thought I was able to do this before, but I can't figure out how I may have done it.
I am using a FeatureReader to read a data source (e.g. SHP file) and then immediately writing it to postGIS using a FeatureWriter. Because the input is supposed to be agnostic as to the exact data being uploaded, I am using the "single output port" option and outputting the results via the Generic port, which is being directly fed into the FeatureReader.In FME 2017 this worked. In 2018 I am having a problem - the writer only works correctly if the destination table already exists (i.e. with the "Use Existing" option).If I use the "Drop and Create" option in the writer, all I get is the geometry column in the destination table. The other columns don't come across.I saw a forum post where a user was advised to use a dynamic writer and to pass the schema in like this:https://knowledge.safe.com/questions/46483/generic-attribute-from-featurereader.htmlThis works, but has one major annoyance - I lose control of the name of the output table - I have to use th
I'm working on a workflows that will run on my FME Cloud and is started by a REST command. The idea is to develop a database driven pdf creator that generates x amount of pdf pages and bundles them a zip. The setup of my workflow is as follow(or should at least work like this):Step 1: Rest command is send to the cloud with a TaskID and starts the workflow 1.Step 2: Workflow 1 will get the information in our database that is connected to the TaskID. The table that is fetched contains an x amount of PageID's (depending on how many pages is needed) and each PageID contains the information that is needed to set the paper size, geom layers, WMS stuff, graphs and tables, name of the PDF and other information that is needed.Step 3: For each PageID athere is one line submitted to the FMEServerjobsubmitter (in sequence and waits for job to complete) with the information that is needed to start workflow 2 that builds the pdf out of the table that is generated in step 2. For each PagaID a
Hi,I'm fairly new to using the dynamic output, but needed it for converting a set of shape files to SQL Server.The writer has a "Table Qualifier" field, which in static writing designates the target database schema.However, when used in dynamic writing mode, the value entered here is completely ignored, and the tables are all created in the "dbo" schema.Is this WAD og a bug ? And if WAD, is it possible to set the database schema anyway ?CheersLars I.
Hello, I have a list called ''list'' of variable length depending on features. I wanna assign as an attribute to each feature ''list(0) ; list(1) .... list(lenght(list))'' I tried writing a loop on the attribute manager but I didn't know how to use it well Thanks for any possible help :)
I would like to use each polygon of a shapefile sequentially to clip a big raster then coerce that raster clippee to points and do a PointOnAreaOverlayer to get _overlaps for each polygon (in a new field in the polygons shapefile). How would I go about doing that ?
Hia customer has a floating licence for FME Workbench (installed on a PC named sigflower)all the connections from clients are working properly, the access to license file is OK.But they want to launch FME Workbench, from the license server machine sigflower, where it is installedIn this case, FME License Assistant indicates that it's impossible to create a licence file :do you have any idea ?thanx, regards.
Hey I might be missing something here...I cant get the dynamic schema to work on the Map Info Extended Writer. When i try to load this in it says that its cant find the schema and features cant be written..."Cannot find a matching schema named 'STATEWIDE_V_PROPERTY_MP_ADDRESS' in the known set of schemas: 'VMPROP.V_PROPERTY_MP_ADDRESS'. Known schema sources are: 'Schema from Schema Feature, SDE30_2, SDE30_1'. Please verify writer feature type configuration."Shouldnt the matching schema be named to the fme_feature_type not the table name? or does something happen when using a parameter in the table name.The dynamic schema appears to work if i change the value of the table name to "STATEWIDE_@Value(fme_feature_type)" which seems weird.I also cant uncheck the fanout dataset option. It unchecks then i click ok, then i go back in and its checked again.Cheers, James
I am getting this error when using the dynamic Postgis writer error ( PostGIS Writer: Fanout for feature type 'gcenter_Governorates' failed to find feature type template 'gcenter_Governorates')I am Using the FEM 2018 build 18305, as sugested in diffrent artical the issue was solved , in this version , but still it s not working attached a snap of the writer config
@NatalieAtSafe Could you please get somebody from support or development to take a look at this: https://knowledge.safe.com/questions/70983/parallel-processing-doesnt-start.htmlWe're running in to this during a training course, the only noticable difference between his computer and mine is that he's running Windows Pro and has had to re-install everything about a week ago after a failed update.
I intend to use the FME software to create a database in postgis having as reader and writer the postgis. My reader is a line table and my writer will be two multipolygon tables. One of the tables has large polygons (for example the United States of America) and another has smaller polygons (for example the various States of the United States of America). The database I want to create in the end, will be relational type. I can get the final result I want, but to achieve it I have to create and run two separate FME Workbenches, but I plan to be able to achieve the same end result in just one FME Workbench. The reason i need two separate FME Workbenchs is because i do not have primary keys and foreign keys. For this reason, I use the first Workbench to generate primary keys and the second Workbench to copy and populate the foreign keys in the tables so that they can be related through the primary and foreign keys. Can anyone tell me how can I generate primary keys before loading the Feat
Last week I had to reinstall Windows 10 on my laptop and since then Parallel Processing doesn't seem to work in FME. I tried both FME2017.1 (64-bit b17539) and FME2018.0.0.3 (64-bit b18305), but that does not make a difference. Does anyone has a clue?I am on 64-bit Windows 10 Pro for Workstations and the current version is 1803. My machine has an Intel i7-6700HQ processor.
Hi, I am using the Text File writer, and wish to fanout output to files in different folders (where the file name in each folder is cosistent). I have been able to do the opersite (i.e. fanout to uniquley named files in a single folder) using the Advanced>Fanout Datset settings. Short of running from the command line, with a specified output folder parameter, is there any way I can dynamicaly direct Text File outputs to different folders?
Hi,I am trying to run this workspace on fme cloud, it has many engines, why isnt it running against 3 engines in parallel, this seems to be the same whether I run it from desktop or from the cloud directly..Many ThanksOliver
I have a Shutdown Python Script published with a Workspace that when ran successfully renames the Feature Classes in the SourceDataset after the Workspace is complete. This executes successfully in Workbench. However, when I published the same Workspace to FME Server and run it, it just loops the Workspace and never executes the Shutdown Python Script.The only parameter passed is the 'SourceDataset_FILEGDB' and a single value chosen at the start of executing the Workspace.Any thoughts or suggestions would be greatly appreciated. Thank you in advance.
Hi all,I'm using the WMS Reader and I'd like to use an extra parameter in my query. As far as I can see, only the ones in the `map options` can be set (widht, height, format, srs, time, elevation).Is there a way to add an extra parameter, like concatening my KVP to the query?Thank you in advance.Rémi
I'm having a recurring issue where FME Workbench 2018 crashes after 2nd or 3rd attempt to publish to FME Server. I have a whole bunch of workspaces that needed mods and subsequently uploaded to FME Server, but workbench crashes after 2nd or 3rd upload consistently. I also observed that it doesn't matter if it's a new publish or a re-publish, it still causes workbench to crash.If you look at the log in the screenshot it reports that it published successfully, but generally I don't trust it so will re-upload the crashed one just in case the workspace on the server got corrupted.Normally this is not a biggie if doing solitary workspaces, but when you have to upload a couple dozen then it becomes a bit of a pain. I'ts been happening for us on various PCs and as far back as FME 2015 (from memory).Would love to know if others are getting this and a possible solution?Thanks!
I am using FME Desktop & server (2018 ) then I published a tool that will be consumed by a site, but the tool end up with (timeout exceeded) error Any help is appreciated Best Abdullah
Hi, I'm trying to export a tin terrain model to a fmear file. I can't find much information on how to do that and which transformers that I need to use. I have tried different input formats and the only thing that worked was a simple sylinder. That was exported from a vrml file and I could display it the apple fmear app. Is there any information on how to do it? Regards Johan
Hello,I have as an input parameter a list of ids separated by "|".For example: 1|2|4Next I have a directory with some zip files:1.zip, 2.zip, 3,zip., 4,zip, 5,zipAs a result I would like to get only files which have names that are in the input list and have it all zipped to the result.zip file:result.zip --- | |_1.zip |_2.zip |_4.zipI came to the point where I used attribute splitter and I have a list of those Ids but I have no idea what to do next. Can you please help me with that? Thanks!
I need to search a webpage with several links, however I need all the links that have a certain word, how can I do that?
what i'm trying to do is take an array of strings from a python startup script and access it from the rest of the workbench (specifically an sql executor and emailer). what i have so far is made a global variable like so:global users_to_fixusers_to_fix = []then i append strings into that array.and here are my tranformers:here is the PythonCaller:i have gotten this solution from https://knowledge.safe.com/questions/58082/passing-parameters-from-a-python-script-tool-to-a.htmli am getting the following error:Python Exception <TypeError>: Failure to convert list unicode values to native UTF-8 values.Error encountered while calling function `getUsersToFix'f_8(PythonFactory): PythonFactory failed to process featurei'm thinking there must be a better way to do this. because i'm not actually dealing with features, i'm dealing with a list of usernames of our AGOL database.
Hello,I need to set specific order for writers to write because tables are connected with constraints , when one finishes second one starts and after second third starts. How can I do that? And second question, how can I commit changes to Oracle DB or FME does that after writing to DB? I am using Oracle non-spatial writer.
I want to implement an iterative loop in my workbench. For this I have created a simple "While Loop" construct. The pseudo code is as below var i, maxval; i = 1; maxval = 10 while (i < maxval) { i = i + 1; print i; }I created a workbenchTo implement the looping, the red line should be working but FME doesn't take it.Please advise for any workarounds or what I may be missing?
I am taking data from a shapefile and mashing it with a CSV, and the attribute I am having issue with has null, numbers and non-numeric characters/alphabetic values (from the input).The target field in my output is an integer type (uint). I would like to make Null all attributes of that field that are non-numeric (some are purely alphabetic; others have characters like in a date format).I was hoping to use an AttributeManager that I was already utilizing to perform this operation, but I don't know how (or what other transformer would be best).