Authoring

Hi Community, does anybody know a way to force FeatureWriter to wait for completion of a writing task of a feature type before the next writing is triggered? I'm trying to delete features on a database (Oracle Non Spatial) with constraints on the affected tables. So I must enforce a specific delete order. Currently I use a rather complex mechanism with mutiple FeatureWriter transformers in chain and would like to tie them down into one FetureWriter. If a FeatureWriter could be configured in that way it would also be great to do the action within a single transaction. Is this possible too?

We have an automation that runs and outputs a report result as a HMTL page using the data streaming service. Our testing did not have any issues, but in our production system, it appears if the job is queued, the web client times out, although eventually the job completes on server. If there are not jobs in the queue, or the job is a quick job it completes without error. Does anyone have any ideas on why this is occurring? FME server 2019 with 3 engines.

I want to simply add a folder with 3 subfolders to an S3 bucket. I'm using the S3Connector transformer and it seems you need a file to Upload to an S3 folder to create a folder, whereas, it seems to me that you can't only add a folder w/o having a file to upload it. I tried adding a csv file to each subfolder to setup my folder structure in S3 and that works to get the main folder w/ 3 subfolders each containing an empty csv file. I then added 3 more S3Connector transformers w/ the Delete option to remove the csv files from each subfolder thinking then I would have the desired folder setup without any files in them. This doesn't work because when you delete the only csv file from the subfolder, it also removes subfolder leaving nothing left in S3. Is there a way to create the desired s3 folder structure without adding a file? Or is it possible to delete the file from the subfolder without removing the subfolder?

What is the FME syntax required to assign a <null> value? Inputting <null> seems to return the string '<null>' and not a bonefide <null> (greyed out FME version). Some fields offer <null> in the drop down, but some do not and require the user to input, such as... Thank you. Tyler FME WorkBench 2021.0

Hello, In one field, I want to keep all string values matching the regex: \\d{4}-\\d{2}-\\d{2} and relegate all strings NOT matching that string to: <null> See following image for my attempt where I developed ^(?!\\d{4}-\\d{2}-\\d{2}).* as the negation of \\d{4}-\\d{2}-\\d{2} and set replacement to <null>. This did not work. Any pointers would be greatly appreciated! Tyler

Hi, I am translating a DGN file to File GDB using dynamic schema. In DGN reader, i can see so many extra attributes like attribute.color, attribute.length etc. I want to ignore those attributes in file GDB writer. I am using attribute keeper but it is not working in case of Dynamic Schema, Please guide. Thanks in advance.

The workbench is checking where lines, points and polygons intersect with 2 other datasets (one a polygon dataset, the other a line). The workbench worked when initially built but after saving and coming back it no longer runs with the following message being displayed. Starting translation... Too many recursive macro substitutions -- line currently is: `OS_MASTERMAP_WATER_NETWORK_GML_2_DATASET "$(SourceDataset_OS_MASTERMAP_WATER_NETWORK_GML_2)"' Program Terminating Translation FAILED. I've attached an image of what the workbench is looking to do. Inputs are mid/mif and gz. Outputs are xls and geodatabase. Any idea why this might be happening and how to fix would be greatly appreciated.

I am trying to create a new attribute for each element in a list. The tables below show the desired outcome. Here is an explanation. For every item in the MASTER list I am loading its corresponding detail list and saving it as a parameter. I want to take the corresponding list and transform it to the example below. I could accomplish this with a database view or query, but would like to be able to do it in FME. I can assume that all ITEM_NAME values are known, which means all the possible attributes that I need to add could be added ahead of time if needed. Note that for every record in the master list, it won't have all of the possible ITEM_NAME values. My process right now is very brute force, and I am thinking there may be a transformer I haven't found that does this or a variation of this easily. MASTER ListIDNAME1Bill2Sally DETAIL ListMASTER_IDDETAIL_IDITEM_NAMETYPECOLOR1AShirtLongRed1BPantsJeansBlue2CShirtShortGreen2DPantsDressPurple2EHatBaseballRedTransformed Master List with De

To transform a 3d model into a straight line, need matrices and quaternions? Who has a good method, I hope to explain, thank you

Is there an easy way to remove accents from characters that are contained in an attribute?

The Scaler transformer looks to be the sort of thing I need, but seems to scale the entire feature, rather than just the top face. I seem to remember, years back, a tutorial where 3D features were deconstructed, altered, and re-combined again, so maybe there's a solution that works like that? Thanks.

I'm trying to create a conditional parameter value in a WorkspaceRunner, based on an attribute value. I can do this, as the WorkspaceRunner is allowing me to fill in conditional values for the parameters, however, every time I click OK and reopen my WorkspaceRunner, all these conditional values are reset and again replaced by their hard coded values, as read from the model that the WorkspaceRunner is calling. Is there a reason for this behaviour or is this just a bug? I'm using FME 2018.1 build 18547 WIN64.

Hello, I would like to make an FME Server app which allows the user to download data from Resources folder from FME Server (these files are html files generated by another automation). Now, in my workspace I am using "Directory and Files pathnames" to get the path to all these .html files located in different folders. I am blocked now because I have no idea how to continue my workspace to download the files. Any ideas? Thank you Nicu

So, I'm looking at this question on StackExchange. The user has color blindness and has trouble reading error messages in the FME log, because they are colored red. I've filed an enhancement request and we'll work on adding those to our special color blindness theme. But, in the meantime I was wondering if we could do something else to help. They don't want to have to copy/paste the log to check for errors. So I was thinking perhaps a shutdown python script that automatically extracted error messages? Or even a script that just popped up a dialog saying "there has been an error"? Any thoughts? My Python skills are pretty limited. And yes, I just tweeted recently how I never needed them, because of FME. Ironic (or perhaps moronic) is the word you're looking for! NB: I'll treat it as a challenge and award extra reputation points for really good solutions.

Hi, I created a FME workspace in which I connect to a web service published on AGOL. The service consists of a point feature layer (inventory layer) and a linked table (inspection table), used with the Field Maps application to perform regular inspections. The main objectives are among others: Extract the weekly inspection results in Excel format Archive inspection data as an existing file Geodatabase, but keeping only inspection table results for all subsequent inspections Then truncate the inspection table in AGOL. The first goal has been successfully achieved, unfortunately I am struggling to complete the next steps of copying the data from the inspection table to the File Geodatabase and then truncating the results from the inspection table after the execution of the first step. Could someone show me how to implement the steps to copy data from inspection table to file geodatabase and delete data from table in AGOL? Thank you for your help! Regards,

Attribute Splitter and List Exploder? or is there a better way?

I have a 2016 workspace that I'm upgrading to 2021.2.5. The basic workflow is SQLExecutor -> GeometryReplacer -> Clipper with an AOI -> FileGDB. What comes out of the DB is the geodb_type which helps to determine features get routed either the polyline or annotation feature class. GeometryReplacer is used to convert from WKT so that features can be clipped with the AOI. From SQLExecutor, geodb_type has values (geodb_polyline, geodb_arc, geodb_annotation), but when it comes out of GeometryReplacer, geodb_type values are all missing. So after clipping, everything gets routed to the polyline fc, which will produce this error: "Cannot write a non-linear feature to a polyline feature class." [geometryreplacer_geodb_type.png] My workaround is to use GeometryFilter to route the features + a new AttributeCreator to hard-code geodb_type values to ensure the right features are created in FileGDB, rather than rely on geodb_type values. [geometryfilter.png] I've tried to insert completely new tran

I have a list of codes (over 100) in a CSV and want to use a test for each code in a TestFilter. Is there a way to load them all at the same time rather than cutting and pasting individually?

I have a workbench to process some raster imagery, each image is stand alone in the processing done, so a clear candidate for parallel processing. The workbench now looks like I've set the group by to the image name (all unique), and run in both modes with the following outcomes: 'Process when group changes (Advanced)' - Task Manager shows only only a single FME instance processing, act as blocking, processing all files before it begins writing results. 'Process at End (Blocking)' - Task Manager shows multiple FME instances launched, but only one is doing any work, acts as blocking, processing all files before it begins writing results. Both paths are giving correct results, I have removed any 'group by' within the custom transformer, I'm trying to understand what is going wrong in running in parallel. Thanks!

Is there a way to truncate a list? For example if I have a list of 30 items but only want the first 10 to be kept. I know I could manually create the list with an attribute creator using _list{0}, _list{1}, _list{2}, etc but just wanted to see if there is a transform or more automated way to do something like this. Regards Dean

I've been able to upload files to the root and to an existing path, I'm wondering if FTPCaller while uploading can create a new file path (directory)? sftp://server.com/newpath/file.txt (newpath does not exist on sftp server) ftp://server.com/newdir/file

I have a bunch of statistics that I want to add to a HTML report similar to the image below. Not all columns have the same number of rows nor is each column / row related across the table. So was thinking that if I could create a table and each cell contain a list or similar. Any suggestions would be very much appreciated Thanks Dean

Hi, Is it possible to make a Intersection and set that, work just if the two, or three pologon contains other by 90%. Thanks

I have set up a workspace which reads in an Excel Spreadsheet whose attributes may change everytime that the workspace is run. As this workspace is part of a larger chain of workspaces I would like to be able to run it without having to reload the reader to ensure that the latest attributes and features are being brought through each time. I have tried setting the 'Scan Schema in Dynamic Workflow' parameter, but with no success. Is there something I am missing?

I've successfully made an S3 Web Connection and can write a file to a specific S3 bucket. I'm not seeing how to send the a file to a specific folder within the bucket using the S3Connector transformer settings. See attached screenshot. I have the Request Action set to "Upload." There are input fields for Bucket and Path. I want to upload a file to my bucket "testBucket" and place the file in a subfolder named "Files" that's in a project specific folder named "$(projectName)." In S3 that's testBucket > $(projectName) folder > Files folder > file.png As it is, the Bucket input has to match the S3 bucket name you are uploading to, but it also creates a new folder with your bucket name, and the Path input creates a subfolder within that bucket. In S3 that's testBucket > testBucket folder > $(projectName) folder > file.png. Any suggestions on how to target testBucket > $(projectName) folder > Files folder > file.png?