Creating and organizing workspaces. How to use Workbench.
Recently active
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).
I have a workbench that has an non-spatial oracle connection. It runs fine on my laptop A. But it does not run on another machine B (a server) as it complains about the TNS connection. So on machine B, I deleted the database connection (FMEOption -> Database Connection) , and tried to recreate it. But the connection test gave me this error: Error: COM.safe.fmeserver.api.FMEServerException: User encryption is specified but can't find key to decrypt.In fact, I can't open any of the other existing connections on Machine B in the FMEOption -> Database Connections. It gives me this error:Unable to retrieve connection "xxx", please check the log file for more detail.We had a similar issue with this Machine B a few months ago, which we fixed by reinstalling FME. But this time, reinstalling FME does not fix the issue. We are at FME Desktop 2017.1.0.Allen
Hi I have a grid index, I want to use the attribution from the index to pull various raster tiles. Currently, I have clipped the index to my area of interest. These are then feeding into my FeatureReader. I have setup the FeatureReader as seen below. Here is where I have the problem, the FeatureReader is writing out the original index and not the rasters I wanted to select (Using the SHEET_NAME from the index). What am I doing wrong? Thanks for the help. B
I have attribute zip code, where all values looks in this form 12345 how can I transform them into this form 123 45?My idea was to split it using StringReplacer where I would replace \\d{5} by \\d{3} \\s \\d{2}, however I don't know how can I create new attribute which base on the old zip code attribute (12345).Are there any other ways to do it?
I wonder what would be the best way to come up with a string of lat/long concatenated from features with a single character value. I'm not sure I described it very well but the pictures should help.The source is a PDF document.My workspacethat ended with this. I tried aggregating on Y but it did not work. I was thinking maybe an Advanced attribute Handling but I don't have a good solution yet.
I am trying to populate a new field with a value from another field. It is not a simple attribute copy. Each record is getting the value from a different field that is specified in another field.For example: I have the table below and I want to populate NEW_FIELD with one of the values of fields FIELD1 through FIELD4 based on what is provided in FIELD_TO_USE. This has to be dynamic (no hard coded TestFilter as I am doing that now).FIELD1FIELD2FIELD3FIELD4FIELD_TO_USENEW_FIELD1234FIELD115678FIELD26ABCDFIELD3CEFGHFIELD4H
How to set preference in FME workbench where one can set precedence: Step 1: (Run first) Data is downloaded successfully using HTTPFetcher, until it is complete the step 2 should not start. Step 2: (Run second) then a reader is used to read the above downloaded data. Currently having issue of step 2 start before step 1 is finished.