Authoring

Hi. I'm trying to write some data into a table which consists of two foreign keys. As you can see on the attached image, I'm reading from two tables, Equipment and WaterMeterPnt. Equipment contains a field BuildingId which I'm going to add to the table WaterMeterPntBuilding. I'm joining the two tables on an common field. The table WaterMeterPntBuilding contains just two fields which is foreign keys. When I try to run this, I get this error when writing:Microsoft SQL Server Non-Spatial Writer: Failed to create Azure table 'dbo.WaterMeterPntBuilding' because no clustered index or primary key was specified.I'm sure that the values exists in the tables and I'm using the existing table, not creating the table each time. Regards,Torbjørn 

Hi,I designed a process that contains loop in a loop.I have a problem with iterations. I would like iterations to be numbered continuously and in ascending order. Now the process iterates the loops like this: And I want the algorithm to iterate like this: Outer loop:Inner loop:What do I need to change in the algorithm ??

I have an excel with the definition of the Schema Fme-feature type ( table to create) name ( the attribute to creat )this is only sample data, I used the featured reader to read the empty schema use the list explorer to get the data attached in the excel, how could we create the same schema into the DB Note ( the source has no features )   

Hello, I want to add a cus datum transformation. But it is not working.I have created this and saved in the shared folder: DATUM_DEF Pulkovo1942\\DESC_NM "Pulkovo 1942"\\SOURCE "BP"\\ELLIPSOID KRASSOW\\ XFORM_DEF WGS84_Pulkovo1942_Periplus_Test\\DESC_NM "Pulkovo 1942, 7 parameter"\\SRC_DTM WGS84\\TRG_DTM Pulkovo1942\\SOURCE "BP"\\GROUP "PERIPLUS"\\INVERSE Yes\\MAX_ITR 8\\METHOD 7PARAMETER\\DELTA_X -686.10\\DELTA_Y 123.50\\DELTA_Z 574.4\\ROT_X -8.0450\\ROT_Y 23.366\\ROT_Z -10.791\\BWSCALE 2.926\\ COORDINATE_SYSTEM_DEF PULKOV1942_TM\\GROUP "PERIPLUS"\\DESC_NM "Pulkovo1942-PeriPlus"\\SOURCE "BP"\\DT_NAME Pulkovo1942\\PROJ TMAF\\UNIT METER\\PARM1 09\\SCL_RED 1.0\\ORG_LAT 0\\X_OFF 500000\\Y_OFF 0\\ Please, can you help?

Is it possible to find all published workbenches that are using a specific database connection? Nothing is obvious in the UI of FME Server. I've managed to find fme_nc_namedconnections but I've yet to make the jump so i can see connections either in an automation or schedule or details of a workbench. Any help gratefully received......

Hi guys,I recently joined a company and I look after a central system. My system integrates with many other systems to bring in data and host it in this central system.The big issue I found is the way various teams are capturing the data in their specific area and then struggling to deliver the data to my central system.The way they capture the data is through using excel forms or other mechanisms that allow for data entry mistakes. Also, the processes to push into my system is manual from their end.I was hoping to ask on here if you can assist with best practices to help develop and what experiences you had to improve this process:A quick, easy, and sufficient way for data capture to happen by the user who collects the data. Should we look into form entries where it can push into a database or other possibilities? What is the best way to do this?How to monitor data capture and processes (monitoring to see if users have for example submitted data or if they are late). If for example, t

r to Command Line Options.

I have a pythoncaller, that runs the below python, this works OK in FME 2018, but fails in 2020.ERROR |Python Exception <SyntaxError>: invalid syntax (<string>, line 11)FATAL |Factory proxy not initializedI have the python interpreter set to 3.6+So the script works in 2020 if I tag out the last line, so has something changed with the feature.removeAttribute function ?  import fmeobjectsdef removeNulls(feature): attrsin = feature.getAttribute('SRC_ATTRS') attrs = attrsin.split(',') for attr in attrs: val = feature.getAttribute(attr) if val == 'VCP' : feature.setAttribute('attname',attr) if val <> 'VCP' : feature.removeAttribute(attr)

Hi list.I need to run the same master-servant workspace setup med two different and non-conflicting sets of data and setup.I tried it yesterday, and first the master workspace complained about it being in use, and even when that's ok, it fails to run the workspacerunner, as the secondary workspace is also in use ?Does this have something to do with the log file being locked, and if so, is there a way to make this work ?My master only spawns workspacerunner once at a time, since I'm not sure parallel processing of the input datasets will work properly. So it's quite well behaved :-)Cheers.

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 create only the necessary collumns of date.I saw this post (https://knowledge.safe.com/questions/21304/get-the-attributes-names-with-python.html) but how can i use this to create the correct "schema" for my shapefiles?? 

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 folders are the kml_id not the kml_name.Images below, the third folder is structured just like the 2nd one so I did not repeat the image. Ap

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 Server!

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 error code -1073741510, but I have no idea what it means, an