Authoring

Hi All,I am getting confused with some issues with published parameters and running schedules via FME Server. I can run the workspace manually via FME server, the published parameters are filled, and it runs no problems. When it runs via a schedule, the published parameters go missing and it fails each time due to the published parameters having no value?Cheers,

I try to create an md5-hashcode in my fme-workbench. The only way I found is to create it with python.Is that right? No other way?Ok, I tried with python, but I got some errors. Can anyone help me?First I created a new attribute where I concatenated all needed attributes and then I used this code in a pythoncaller:import hashlib, os def getHash(feature): mystring = feature.getAttribute('concatenated') # Assumes the default UTF-8 hash_object = hashlib.md5(mystring.encode()) print(hash_object.hexdigest())I hoped that I get back a new attribut called hash_object with the code I want. But I got only errors. ;-(Thanks for your support.

I have a batch process with a Directory and file Path names reader (files are in a different folder depending on county and municipality for example \\xyz\\DATA\\Topo\\N50\\Original\\fylke_kommune\\01_Ostfold\\0101_Halden) and a WorkspaceRunner that calls a worskpace that does a conversion from SOSI (norwegian standard) to shapefiles for all the sosi files (*.sos) into a new directory with subfolders named after the file's county and municipality it belongs to. In the conversion workspace I have the writers destination as fanout expression of the county and municipality that is extracted from the Path being read with a filenamextractor (_dirpath) and a string searcher (_firstmatch) and then a stringreplacer to change the destination path (updated _dirpath). So the files will be generated in a new folder whose naming depends on the County and Municipality that is in the path of the reader (Destination folder: \\xyz\\DATA\\Topo\\Norway_N50\\Converted. The fanout expression for the de

I have created a custom transformer that's linked by default. I decided at some point while I was making changes that one of the changes warranted creating a new "Version", so now I have a custom transformer that has version 1 and version 2.I have since decided that I no longer need version 1 but there doesn't seem to be any way of deleting it as it's embedded inside the .fmx file along with version 2. If I could delete version 1 then I'd rename v2 -> v1.I guess I could edit the .fmx file with a text editor and I'm normally ok with getting my hands dirty doing that but this situation seems a little too risky.

This is probably very simple but what transformer do I use to globally update a field with a standard value. All I want to do is add the number "1" to an integer field in several feature classes within the same file geodatabase. ThanksDave

I am trying to convert shape files with attributes to AutoCAD .dwg files, but when I get the attributes to come across, the geometry is forced to an FME block. I want the geometry to be a polyline, but still maintain the attributes as properties in the cad file.

I want to combine two tables (csv and .xls) into one table and then join to a feature class. The two tables will have the same schema once I process them through a Attribute Manager and then I want to merge them together and write them out to a csv. I don't think the FeatureMerger or Joiner will really work because they need matching values while the records from these two tables are unique. I hope that makes sense and thanks for your help!

I have some data that I read using Single Merged Feature Type (about 40 individual featuretypes). Most of the featuretypes have an attribute "A_num" (numbers). Now I need to create a new attribute "A_txt" with the text-values for those numbers. The text-values are different though for different tables. I have an excel sheet with the following columns: table, attributname (= A_num), value, text-value.So I guess I have to do something like that: Filter the inputdata for individual featuretypes, merge the data for each featuretype with the excelsheet and map the text-values to the new attribute "A-txt".I think, this is quite complicated and there has to be a more elegant way to do it. I have a second excelsheet with all the table names. Maybe I could somehow loop through this, and do the filtering based on the table names? Any other ideas?Thanks in advance.Vera

I have created a FME workbench where it reads files from 5 different sources and writes it excel worksheet. Currently I run this process monthly why going clicking Run in FME. I would like to automate this process where it will run automatically 1st of the new month. Has anyone done something like this, if yes please let me know how to set one up.

Hi , i have table where the name are in two languages and there is another field/ column (sn_grp) with some values calculated only for one language so now i want to calculate that value for other language where the name and ID's are same .

I am using FME Desktop 2016 and I am trying to copy attributes to the feature. Currently when I copy attributes across I get features but no schema.I have tried exposing autocad text_string but I just get an empty field. I have pipe and hydrant data where the attributes are equally as important as the feature itself. I have the text annotation layer but not sure how to get this information to my feature. Any help would be appreciated.

How could we apply a Multiplier to the attributes value , but the multiplayer value is a variable ex : parcels area * factor and factor value is read from DB of excel cell : )

In order to merge (union) multiple solids generated from one single input, I searched on the internet for a solution and found an idea of using the Sampler transformer (with Sampling Rate = 1 and Sampling Type = First N Features) + the CSGBuilder, in a custom transformer with a loop (merging loop), but the Sampler does not work correctly in a recursive loop (features are not sampled in a loop), so the loop become infinite!..If there is any idea to deal with that issue, I will appreaciate it.

Why we choose Only Python not other for scripting in FME?

Good day!I'd like to change data structure from as shown on 1stpicture to structure as shown on 2nd picture.Simply stated i want values replace from first column (Attributes) to attribute name values and second column should be values for these attributes. I think Attributes field on 1st picture will not be stable. Elements will change from time to time.This is a subtotal result from big WB processing result...I tried to use AttributeCreator, but result is not good(.How can i do this?Thanks)

Hi, I tried to generate contour polygons from a point shapefile, here are the steps:1. use 3DForcer to assign one attribute from the shapefile as Z value to make the point 3D;2. use ContourGenerator (attribute LDEN has values in range (-20, 120), I have set the Interval to 5)to get contour LINES, i only use points as input, no breakline is provided;3. Option 1: then use HullAccumulator -> GeometryCoercer to generate the boundary . After this, use Aggregtor to combine the contourlines and the boundary line, then the AreaBuilder to create the contour polygon, this options looks fine; Option 2: after step 2, directly use AreaBuilder to create the polygon, then I found the contour polygons are overlapped. For instance, contour 55 contains the contour polygon 60, 65 and higher. Question 1: why is option 2 generate polygon like this? Why option 1 did the good job?4. followed by option 1 in step 3, those polygons contains no values. So I use OffsetCurveGenerate ->CoordinateExtractor

We run a workbench which calls a second (and further) workbench(s), using the WorkspaceRunner Transformer. The job appears finished with success but in logs we get the message: FME license system failure: FME is not licensed for this machine. Contact your Distributor. Your registration key is x-xxx-xxx-xxx. Program Terminating Translation FAILED.The process fails on calling and running the first of the embedded workbenches. After failure to run the embedded workbench, the 'parent' workspace continues operating, but doesn't call or run the other 2 embedded workbenches, so appears to have been a successful 'job', but isn't. It then throws the licensing error, however, the Server is licensed and the license expire next year. (information from Engines&Licensing;).This is a mission critical task, so we're stuck without it being operational.Thanks,Stefan

I have two tables, ITEM and SITE, where the ITEM values(columns ACTIVE, CHECKED, REPLACE) need to be merged with the SITE columns but if any of the multiple ITEM values is 'Y' it takes precedence over a value of 'N'. I have a solution using a FeatureMerger generating a list and then searching the list three times, once for each column. However, this is an example and actually there are many columns that need to be added in this way. Just wondering if there is a more generic way of processing rather than a chained approach (no Python please). Data in attached spreadsheet.  

We have one engine for our FME Server 2015 which means that jobs execute one at a time and jobs that come along while one job is executing go into the queue. Usually this is not a problem.Recently, however we had a problem with a script that works in FME Desktop but does not always work in FME Server. The script has a Python shutdown script. I'm wondering if FME Server waits until the action of the shutdown script in the first FME script completes before it starts executing the second FME script?Thanks

Hi all,I am reading non spatial tables from a file geodatabase and writing them to an ESRI SDE geodatabase.In the writer feature types I have defined the Feature Dataset that I want the tables to be crated in.But this entry is ignored by the writer and all tables are written without FDS.I does not matter if I create the FDS before writing or not.I am using FME 2016.0.1.1 32 bits and have ArcGis installed.Any help is welcome.Erik Jan

Hi guys,Do you know how I can stop FME to display titles twice when writing out to excel work sheet. Se example below, I just want to display the title in first column and then just add the new month data after the previous month date without the title of the columns.Current_Data_timestamp G03-2016 6.330197Current_Date_timestamp G04-2016 6.742739

Hi there, Is there a way to attach a kml file in a tweet? I know that we can stream a geolocation but would attaching a file possible with FME Desktop?

When running a Datadownload internally - for instance from 32.1.10.32/fmeserver the Email with results contains http://32.1.10.32/fmedatadownload/results/FME_12494A5D_1464079512168_3204.zip When running a Datadownload from another external server to the servers external ip (for instance 82.111.12.101) it serves the Email with result: http://82.111.12.101/fmedatadownload/results/FME_12494A5D_1464079512168_3204.zip When looking at Manage - Administration - Services it gives the correct IP (31.1.10.32) - as they always want to use the internal IP - even though the process gets started through the external IP. I thought the Services tab in the webgui was the parameters used also when generating the e-mails? Any workaround to force the internal adress?

I have a workspace that I can run without error from the workbench, and I have a python script that also has run it in the past without issue. For some reason, now when I run the workspace via the script, it does not produce an error, but the output files it is writing (KMZ) are empty. I've double-checked all the parameters and they seem to be ok. There is an sde reader, which I did change to read a connection file, vs previously I entered in all the connection information. I'm not sure what's going wrong?

I receive data with standard attribute names but some of the attribute names can vary, is there a way of regardless of what the received attribute name is set it to a valueThe table below shows how I might receive data with 1 of 5 different names for LengthSo if attribute name is in received column set to the value in the required column Recievd attribute name Required attribute name LENGTH Length Length Length SEG_LENGTH Length Seg_Length Length Seg_Length Length