Authoring

Is there anyway in FME to create spatial features from data in Microsoft CRM Online?We have various CRM entities, which we'd like to put on the map. Some have addresses, some have UK OS NGR, some even have lat/long values.I've checked the list of FME formats but can't find anything relating to Microsoft CRMSomebody suggested going directly to the SQL Server tables, but this isn't possible as we're using CRM Online, so database connection

Are there are plans to add a Reader and Writer for Dynamics CRM Online, similar to the ones for Salesforce?

Hi all,I just deleted the foldersin my C:\\users\\...\\appdata\\local\\temp directory as a workbench that used to run fine was running into memory issues and I was clearing up space on the drive. However, on starting the workbench again (and also others) I get below error message. Starting an empty workbench works alright.I attempted to restore the deleted folders (named '2' and '4') but apparently they have been permanently deleted off the box.Any ideas?Problem signature:Problem Event Name:APPCRASHApplication Name:fmeworkbench.exeApplication Version:2014.7.12.14433Application Timestamp:54480bb3Fault Module Name:MSVCR100.dllFault Module Version:10.0.40219.325Fault Module Timestamp:4df2be1eException Code:40000015Exception Offset:0008d6fdOS Version:6.1.7601.2.1.0.272.7Locale ID:5129Additional Information 1:0dddAdditional Information 2:0ddd9e71307c79c27

I have downloaded the FuzzyStringCompare transformer and tried to install it. It appear it is already installed yet it is not available to me in a workbench. Are there settings I should be checking. Does this transformer only work with certain versions? I cannot find detailed info how transformers downloaded from the FME Hub work. I am useless with Python scripting so don't want to go down that route for the work I am doing.

I have a lot of named database connections defined in FME Desktop and would like to have them all available on FME Server. Is there an easy way to publish / copy named connections from Desktop to Server? I know that I can publish a workspace and the connections will get copied up but I don't want to have to create a dummy workspace with all of my possible DB connections just to get them published. I'm also hoping not to have to re-create all of the connections manually on Server...

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

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 OffsetC

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