Authoring

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

Hi,I'm trying to develop my own FME driver (Reader/Writer). In Reader, feature types are created in readSchema function and users can select some of them to use them in their workbench. But when the user run the workbench, I don't know how in the read function I can know which feature types were selected by user ?

HiI have a controller workspace with some DB paramaters. In it ther is one specific FMESJS amongs the others FMESJS. There are user parameters in the controller for DB user, service and password. The controller passes these to the FMESJS.The tnsnames.ora on the fme server has the proper entries for this service. When I run the controller on the server all FMESJS run OK with the supplied DB params, but this specific one. I got the error ORA-01005: null password given; logon deniedin one of the FeatureReaders in the targer workspace (one invoked by the FMESJS).The log is below1  INFORM  0.0  0.0  2016-05-19 14:17:05  FME 2015.1.0.3 (20150623 - Build 15485 - linux-x64)   2  INFORM  0.0  0.0  2016-05-19 14:17:05  FME_HOME is '/apps/fmeserver/Server/FMEEngineUpgrade.2015.1/'   3  INFORM  0.0  0.0  2016-05-19 14:17:05  FME Engine (floating)   4  INFORM  0.0  0.0  2016-05-19 14:17:05  Permanent License.   5  INFORM  0.0  0.0  2016-05-19 14:17:05  Machine host name is: servername   6  INFORM  

Hi , I'm trying to generate a batch process to convert "n" DGN's to "n" differents GDB's. I know that with the workspaceRunner I could do it , but I don't know how to create different ouputs for any input , Any idea ???. Thanks in advanced for your help.Regards !!

Hello, is it possible to log directly to the windows event log?

Hi, I spent a little bit of time to list many Database Connection under FME Options/ Database Connections. There are now available to me in the workbench as Named Database Connections. I found the .data sqLight database and want to share it accross to save time for other users.When specifying the DefultPath I've got two issues:the select folder button doesn't allow me to select a folder but only a file (same for the shared FME folders)If I specify my new .data file it's not recognised after FME restart.Is there an stable way to share this connectionDatabase on a shared drive and use it as a centralised resource for all users, including FME server? My understanding of all this is that I can see only the named connections of my own personal user. If I edit the user attribute with FME the SQLlight DB .data file I can view all connections.Is there a way to view them all whatever user I am?FME version: 2015.1.2 build 15538Thanks

Hello Guys I have shape file with many district and each one have built area and planed area as value but no geometry to differentiate them we only have the district boundary ,is there a way we could have each area colored according to the their value taking the center of the district as center point same as pie chart.or embed pie chart in the polygonThanks