Authoring

How to access all the fme server apps in one go as a list without loginsHi All,Is there a way to access all the fme server apps without logins in one go as a list, especially the apps that are require authentication feature is disabled?  best,Lubna

Hello I've been trying to work with some COVID data from my state in Brazil.Every day the state health department releases a CSV with the data like this where we have a feature for every city and every day with the number from covid( deaths, confirmed cases and recovery cases)I want to create 3 shape file for each situation where the first collum is the city name and all other collumns are the dates, just like these: I was able to do it with AttributeCreator and Exposer but as time goes bye the health department updates the begining of the dates from the CSV( in this example the least date is 23 feb, but now the first day is 04 jan).I know i can use the exposer with all the days of the year but i was trying to

I have a workspace that has 6 published parameters,When I publish this workspace to FME Server the DestDataset_ACAD parameter is missing The parameter is available when I publish a webhook and the webhook runs successfully but the file return from FME Server is named like this.When I change the file extension this file opens in AutoCAD.  I have tried to create a parameter and then link to the writer this also goes missing when I publish to FME Server. Is there a setting I am not seeing somewhere? I am using REAL_DWG writer.

I want to add <Name> together which can be opened and closed in Excel (visual compress), so i can see the different attributes for the same <Name> when opening the label. Does anyone know how we can use this in Excel? In the attachment is an example of how the <Name> value should look like.

Hi guys,  I've been trying to reduce the number of hit's I need to make to a database by building an IN statement and get it all in one go. So far I've been pretty successful - my wait time from the database has been significantly improved!  My process has been to use an Aggregator to collect the Id's into groups of 1000 (limit of features in an in request) - the GroupCounter has been really helpful for creating an ordered attribute to group by.  Now I'm at the point where this Aggregation process is taking quite a bit of time (seconds) because FME is splitting the features tables. I'm trying to figure out a way to build a comma separated list from an column without breaking the feature tables.  Anyone been able to do this or can think of a way that this might work?  CheersMatt

I can group and count attribute values from a table using sqlcreatorselect a.CaseFullRef, count(a.casefullref) as count2from bcapr as ainner join bcinsac as b on a.SystemKey = b.systemkeygroup by a.CaseFullReforder by a.casefullrefThis gives me the required outputBut I need to compare this table with a csv fileI want to group and count the values in the csv file in the same way as the table . How do I group and count the attribute values in the csvfile ? I tried using counter but it just adds a count to each incident of the value .how do I add group by to the counter?

Hi! I'm trying to have FME to output an excelfile and use an attribute as it's filename. Can't get it to work! In the parameters settings for the writer I enter the folder in the "Destination Fanout Directory" and as the Fanout Expression i enter:@Value(ATTRIBUTE THAT I WANT TO USE HERE).xlsxThis gives me one ".xlsx", that does not open, and one file with the correct filename but without a file ending (xlsx). Anyone who can point me in the right direction?Using fme desktop 2020. UPDATE:The error was my own fault. The attribute value contained a : (colon) which a filename can not include. Sort this out and the filename get produced as expected.

Hi!I have 2 workspaces. The first output shp files. The second workspace call the first.I would like to run the first on the second, but not export shp. I have this problem because my first workspace is used for differents uses, so in some cases I have a second workspace and in others cases I have not.I look on the parameters of workspacerunner and featurewriter but I don't find the solution.Thanks

Hello, I would like to be able to call a table in an sde according to the choice of the upstream user. And then retrieve the fields from this table. Is it possible with PythonCaller? Thank you  

I am trying to split a very large csv-file for further processing. I currently read the input, count the features, divide by a set number of max lines, round to integer and use this attribute as a filename to write new files with a feature writer.Somehow, the attribute is calculated correctly but using it as a filename results in a maximum number of 100 files being written. The feature writer then starts overwriting the first file again.Am I missing something?

Hi. I have two datasets. One of them has 25562 records. The other one has 16310 and it contains the values for an attribute that I want to put in the larger dataset. I have tried with AttibuteMerger and Attribute Joiner, but the result is a dataset with only the 16310 records that both datasets share. How can I fill de 16310 records and keep the rest empty on the larger dataset? Thanks!

The project I am working on requires creating kmls after merging ESRI files and Excel spreadsheet data. I am working in Data Interoperability so I don't know how to export a workbench but I have included screen shots below of my data. I found the knowledge base article about how to create folders, subfolders, and groups, https://knowledge.safe.com/articles/221/kml-folders.htmlI inserted the create folders where I thought was appropriate but the only level I get is the Subfolder, the groups don't come into separate categories. Other problems since adding this process to create folders the file name is no longer being saved with the datestamp at the end of the file name. The output is also giving me 3 files, only 1 worksIt names the ParcelLabel folder with the name of the parent folder "ParcelStatus". The names that show up for the f

I am failing to get Workspace Runner working.I have over a thousand MapInfo tables that I want to process. (I am only trying three tables right now)Each table has a single record (a point object).My workspace runner is set up with;Directory and File Pathnames Reader(path filter *.tab)Workspace Runner(Wait for job to complete = YesSource MapInfo tab files = path_windows)But it only processes the first table, although the transformer reports three successesThe workspace that does the work names the output file according to an attribute column, which is different for each table, so it should know to give the three outputs three different names

Hi  Related to this earlier question https://knowledge.safe.com/questions/4957/python-startup-script-to-terminate-workspace.html I want to cleanly terminate the creation of a Private Scripted Python Parameter. Throwing an exception pollutes the log with the script from the exception and confuses the user (and author sometimes!)Then discovered the sys.exit() function and this gives me a better result:import sysval = FME_MacroValues['INPUT_TEST']if val == 'Fail':    print 'You chose {} \nProgram Terminating\nTranslation FAILED.'.format(val)    sys.exit(0)else:    return 'all ok'Could do with a sanity check from resident Python Jedi that have any comments or any detrimental issues for use with FME?*Note only tested on FME Desktop NOT

So i have 2 different fmws to run. One I need to run with FME 2016 32bit. The other needs to run on FME 2016 64bit.  I'd like to create one parrent fmw that will run these two fmws with each separate workspace runner in series. Can I do that? Or should i use SystemCaller and send a proper command for each workspace.

Hello everyone.I am currently working on FME scripts with different fatal cases. So in one FME script, for each fatal case, there is a terminator (sometimes I have like 3 terminators in the same script). Those terminators all have a different termination message.All of my FME command lines are gathered in a batch file, and I also extract the error level (%errorlevel%).I initially thought that when running the batch file, I would be able to extract the different error codes that I set up in the terminators. Instead, I only get code 0 (success) or code -1 (failure).Is it possible to extract the codes I defined from FME Workbench ?I have seen several solutions like sending the code into an email, or using python, but I have to use a batch file to run all my FME command lines. Therefore, I am looking for a solution that would allow me to get the error code after the FME script terminated, in the batch file.  Moreover, I once got e

My current workspace has a prompt for the user to specify a folder that will be copied and uploaded to a few different places. One thing I would also like it to do is copy a .kml file inside this folder to another location. Every time the workspace will be run the user will be selecting a different folder but the .kml inside each folder will be going to the same spot as every other .kml.  Here is my current filecopy writer where $(job_folder) is the user specified folder. I try to set the source dataset as the user parameter but to only "filter" through any .kml's inside: Is this possible?  Thanks!

Hi,I'm using the FeatureWriter to export a bunch of data from an SDE FeatureReader to a shapefile format. While most shapefiles are getting created with no problems, there are a few where the attribute table cannot be read using either ArcMap or ArcCatalog. The ones that cannot be read seem to be the ones where I am using a Tester transformer to select only certain features for export.The image below shows the 3 layers that are having the problems. Other layers also use a Tester, but they also use other Transformers as well.The three that are having the issue are the only ones where there is just one Tester transformer in the 'chain'.Spatially, all the data is there, but it's just the attribute table that cannot be read. This is the error I get in ArcCatalog.

Hello, I think I've found a little bug.Here my version : FME(R) 2019.1.2.0 (20190829 - Build 19630 - WIN64) I'm using a FeatureWriter to write features in a PostgreSQL DB.Here my parameters : In the Attribute tabs, I set the definition to Automatic so the structure is created from datas comming into the FeatureWriter : Now the bug :As I said, I've plugged datas into the FeatureWriter and set the Attribute Definition on Automatic and "voila", my structures are automatically defined.Now, I add an attribute on a feature type that goes into the FeatureWriter (with an AttributeCreator for exemple).The FeatureWriter doesn't ad

I am working on a project for a client where i need to handover workspaces that contain multiple feature readers all with multiple outputs in quite a complex workspace. This is fine as the database location is set in a workspace runner outside of these workspaces. However if the client needs to open the workspace to make any edits, i've found since the 2020 update, if you open a workspace and the FeatureReader cant locate the data source it just drops all output ports into a generic port essentially breaking it. Has anyone else found this or can think of a way to stop this from happening?Additionally since the 2020 update i have found that when you select datasets to read in to a FeatureReader via the 'tick' box selection that it is not keeping the ones already selected and removes them and adds the new selected ones only. My workaround has to actually type the feature type name into the text editor to get it to add an additional feature type.

Hi,When I first created my workbench, the FeatureWriter seemed to create all my shapefiles properly. Featres were coming from an SDE GeoDB through a FeatureReader, and then after some manipulation, exported though the FeaureWriter with no problems.Now when I go to take an existing feature that is already in the FeatureReader, and export a different shapefile through the existing FeatureWriter, all of the attributes end up being CHAR 200. I'm not sure why this is happening.Here is a screen shot of an existing shapefile in the FeatureWriter, where the attributes are correct. If I take the same source feature, and add it to the FeatureWriter and just give it a new export name, the attributes are all messed up.

I am looking for a type of loop or other solution where I can update my input data and perform an analysis. The output will effect the input data and so on. A kind of loop. Is that possible to create in FME? My workbench until now is attached to this post.Currently I am working with a large tabel. The input data looks like the figure shown below:Portal_IDVTG_VWHVan-naar11000.005-60113000.003-40012000.005-60533000.002-20233500.003-40144000.005-60144500.002-202My first step was to use the Aggregator and set GroupBy to Portal_ID. VTG_VWH values are combined using 'sum'. 'Van-naar' is used for the Count attribute. The output:Portal_IDVTG_VWHCount_Van-naar16000.00336500.00248500.002My next step was to extract the row with highest value for VTG_VWH (Portal_ID =4). That needs to be my first output, one row with Portal_ID 4 (Result 1).------------------------------------------------------------------------------------------------------------------

Hi - I am experiencing a strange error when attempting to update the same table twice which I have narrowed down to be a connection lock or something similar. This is a part of my workbench which updates a timestamps table in SQL Server. Incoming to each of these executes effectively at the same time.If I disable either one - I am able to update the table with no issues so I have isolated any configuration of the writers.I have increased timeouts etc. and no luck. Doesn't look to be related to this. These queries only take a sec or so to run but looks like a connection locking issue. I am running SQL Server 2019.Any ideas what could be causing this? Both of the FeatureWriters using the same connection - SQL Server Non-Spatial Writer.ThanksError - 2020-06-08 19:58:07| 2.6|  0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver for SQL Server...2020-06-08 19:58:37| 2.7|

Hi, I have a coordinated call list, with the values below. My problem is this list: I never know the number of elements that can come into it. How can you create a dynamic method of reading this list and already create attributes, such as: latitude1, longitude1, latitude2, longitude2, latitude3, longitude3 .... "coordinate" : {["latitude" : "-23.2229628000","longitude" : "-35.9099781000","latitude" : "-33.2229628000","longitude" : "-25.9099781000","latitude" : "-33.2229628000","longitude" : "-15.9099781000","latitude" : "-33.2229628000","longitude" : "-25.9099781000"]} Thank´s

I have vector polygon files with LOTS of individual cells. Each cell has an allotted weight value, but I would like to group contiguous polygons so that the sum of their combined weights is as close to a target value as possible (simplified example below).  I feel that this likely exists and I just haven't found the correct keyword to find it. TIA