Data

Hello,i have recently moved from windows to mac and i have install a MYSQL server,i have used the data connections many times but when i am connecting i am now getting this areaError connecting to MYSQL database('localhost','sys'): 'Can't initialize character set unknown (path: compiled_in)'a bit of search online seem to say that a config file is not installed by default on a mac OS install, i have created a default one within the MYSQL workbench but i am still getting this error and i am not an expert on SQL by any means! any help would be much appreciated cheersJames

How can I, in workbench, connect to postgis with ssl on? According to this thread it should be possible but I can't find the setting anywhere.

I have a large 3D model in the compression format. For conversion to the b3dm format I use scripts on github. But the output is only one file, and I need to split it into files up to 3 mg in size. If any ready-made solution or you need to write your own scripts?  How to make 3d tile in b3dm format?

I have a workspace in which I create a viewport and then center the model space over specific coordinate, this works great, until I try and twist the viewport, then I only get viewport twist and no centering or scaling of the viewport, is there an attribute order I am not respecting? I really need to focus the viewport and twist it.Here are the transformers I am using to create viewport and calculate twist angle. Here are the attributes I am creating with the attribute creator.  And I am getting center of location in model space units from CenterPointExtractor  This works great to get the viewport centered on a specific location, as soon as I add this I lose the location inside the viewport and all I get is twist angle in the viewport no custom scale or focus on x,y. Anyone have a similar issue? Here is viewport with autocad_viewport_twist_angle set, the rotation of viewport is good, but no focus  And once I remove the twist angle attribute I get this, the viewport is center perfect. H

i have GeoJson file i need to convert it to IMDF to upload it to Apple indoor map program

Hi,I have updated my FME Desktop 2018.1 to FME 2019.0 and my workflow writing excel files based on a template file stop working. I was able to go around missing conditional formatting with few ExcelStylers. However, I am still missing the print layout which I have defined in the template. All required formatting stays in the template sheet, but is not distributed to the sheets written by FME. What have 2019 version changed and how can I use my template file again?

I am trying to a .KMZ file format into my workspace using the GOOGLE KML reader. After I cliced OK, it prompts me with all these Feature Types (AnimatedUpdated, Document, FlyTo,....) I am not sure which to select. I am following the link @ https://knowledge.safe.com/articles/19918/how-to-expose-feature-attributes-from-kml-tag.html to connect the reader to the HTMLToXHTML Converter but I can't get the reader to load the correct file. Thanks for any helps.

Hello, Does FME support Microstation Connect DGN "Item sets"?I have an Item named Roof attached to a cell with a Type attribute of value 1030 - please see image below and attached.Unfortunately, I cannot see it when I preview the data in FME Data Inspector.Does it mean FME does not support "Item Stes"?Please note that "Item Sets" in Microstation Connect are equivalent to DGN v8 "Tags Sets", i.e. tags.I need to be able to read them, i.e. item set values.Please see the DGN attached as well.Your help much appreciated!Many thanks, Magda

HiI am trying to work with the path reader and trying to do the following 2 tasks but struggling to decide the best way to do it and also how.1) The path finder is picking up a geodatabase. At feature reader it picks up 5 feature classes. At generic stage or next step is there anyway for it to pick up a specific feature class? This will mean i can then query the results just for that feature class.2) The output which is the geodatabase changes name on weekly basis. I would like to write out to this geodatabase without having to manually change the file output to the geodatabase. Would this be possible in the same way the path finder is used to find the original directory.Example is below 

Hi, I am very new to FME and I have just created a workflow to transform DWG/DXF files into OBJ files. However, I have noticed that the .mtl file is not generated together with the .obj one. I am using an AttributeManager to do the conversion and, apart from the .mtl not being generated, the .obj looks fine.  Thanks in advance for any help.

New to FME world, interested to discover if apart the conversion capabilities will be possible to automatically regroup items based on their metadata and geometrical properties.As example group all elements that are tagged (in Revit or IFC) as Windows, first floor and have the same number of polygons after the conversion in fbx format.

Hello,I'm new to FME Desktop and since it seems to be a powerful tool for translating files, I wonder if it's possible to convert a .kml file (which include some 3D geometry) to .ifc? I've searched the forum, but I couldn't find anything covering that matter.

I'm using a FeatureWriter to create an Access Database and for the most part I'm very satisfied with the results.However there are some quirks that I don't understand.First, I didn't find anyway to update the created database each time I run the FME. I have to first delete the previous table to be able to generate a new one.Is there a way to automatically update the table with each run of FME?Secondly, in one instance, while FME shows 8 206 610 rows have been generated, only ~4000 have effectively been written in the Access database. I added an inspector before the FeatureWriter, and the inspector shows 8 206 610 rows.Any idea on what happenned? what did I missed?

Hi all, I’m using Google Drive Connector to download a folder contains images to process them later and convert them to points feature class. When I rerun my workbench I got an error from google drive connector said that the destination exists and when I delete this folder my workbench works fine.Is there anyway that I could setup my Google Drive connector to overwrite the existing folder or anyway to delete that folder through the workbench it self before the google drive start download it again? Thanks,Rawan

Hi Everyone, I hope that someone might be able to provide some guidance or suggestions on a task I am attempting with FME. My team is in the process of cleaning up our GIS data, and as part of this clean-up effort I have been asked to determine all of the records (from various attribute fields) that contain 9999 across all feature classes. So for example, Feature class A may have attributes in the 'Material' field with a value of 9999, Feature class B may have Diameter with 9999, Feature class C could have Install Year and Material with 9999, etc.. Is there a simple way to perform this task to search for all 9999 values across all feature classes? I would appreciate any assistance that could be provided! Thank you,Shelley

I have an FME Server Automation, triggered as a schedule, that has these basic steps: Reads binary files from a SFTPS site and writes to staging folder (A)Reads binary files from staging folder (A), decode files, and writes out to staging folder (B)Reads decoded files from the staging folder (B) and writes to a Vertica databaseCleans up on staging folders (A) and (B), ready for next schedule The decoding bit in step (2) takes its file input from a PATH Reader and can take some time to finish, so I run the workspace in parallel against a FME Server queue across 4 engines. My issue is that the Automation moves to step (3) as soon as 1 of the 4 engines becomes available. Step (3) and step (4) are fast and complete before the remaining 3 engines running step (2) complete. This results is 3 files arriving in the staging folder (B) after the Automation has finished. QUESTION: Is there a ”simple” way to make the Automation wait until step (2) has fully completed on all 4 engines, before m

Hi,I have a problem encoding a text file to the correct format. The below images show:1) the *.prj document properties of an outputted Terrascan Project from a Matlab programme:2) the *.prj document properties of an outputted Terrascan Project from an FME Workbench.Only the file at 1 can be loaded directly in to Terrascan.If the file at 2 is "Saved as" in Textpad, the option to change the line ending to "PC" is available as shown below.In doing so, the file will then load in correctly into Terrascan. Please advise where I maybe going wrong.The template workbench as a small selection of the files is below:Any assistance the can be offered would be much appreciated!

the problem when i see data in pgadmin i cant perview data correct . however it is shown in fme inspector fme2019.1

Hello I have a problem,I try to read multiple csv from an URL that changes.An exemple of URL : https://archive.luftdaten.info/2019-11-11/2019-11-11_sds011_sensor_26828.csvhttps://archive.luftdaten.info/2019-11-11/2019-11-11_sds011_sensor_26760.csvI tried to use an HTTPCaller and it works but I don't know how to treat the result. I don't find any transformer that can help me to translate this string "csv" into a list of attribute. If someone can help me it could be great please.  Here are two images of what I get with httpcaller :

Hello, have a excel sheet with more then 20.000 records and only two columns.  I want to divide the two columns into 7 columns: The problem now sits in the PART_COLOR, not every row has a color, see my result: Is there anyone who can help me with this "little" problem? I will explain what my workflow now is:StringSearcher: I search for the string "SET NR001" in the Description column. So I only get this value's instead of all the other ones. (about 90 different parts).AttributeSplitter: split the Description column on every "space" and put them in lists.AttributeManager: create outputs for every list.AttributeCreator: create the different outputs for the different inputs, for the "Name" output I use list5 + list6.  Perhaps I am using the wrong tools, but I am a starting user at FME.

HiI want to convert polygon shp to cad hatch,everything is fine ,except the hatch geometry attribute only have elevation ,the area is missing(we badly need it in production environment). I do some test, find out that may be the area attribute is assosiate with hatch boundary. is there a way I can do to get area attribute wirte in cad hatch in FME workbench?Thanks in advance

Here is the error that I get when the translation fails: "Unexpected execution path. Please contact Safe Software GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures(SortFactory): A fatal error has occurred. Check the logfile above for details. Some error has occurred closing the pipeline factory, see previous warning None of the edits made during the edit session were saved."I'm using the Data Interoperability Extension through ESRI (ArcGIS 10.4.1). I am new to spatial ETL processes, but I followed the FME tutorial on Writing to Relationship Classes so I believe that the workflow is set-up properly. I haven't found much doc on this issue, so I'm reaching out to the experts for help on this.Thanks!!

Hello,I'm trying to create the worspace that I need to publish and automate later in FME Server.There are 2 SDE Datasets, lets say the Set "A" and "B".I have to delete some feature types (that contains also Relationships, Tables etc.) from Set A (also Domains!) and write new (actuel) feature types from set "B" into the Set "A" (of course with the domains). Do you have an idea / model of the workspace? At the beginning I do not try to test this with a .SDE-Reader, but with .GDB.Thanks for all tipps!

I am trying to find out how to route email to FME Server so Publications can pick it up and process accordingly. The problem is that I cannot find anything in any tutorial or piece of documentation. Here's a scenario:We use Office 365 and use email in the form <first.lastname@company.com>I would like to set up a subdomain so email sent to @fme.company.com is routed to the fme server at fme.company.comMy understanding is that an MX record needs to be set up on the firewall. The primary email server receives all email addressed to @company.com. It would then need to know what to do with email addressed to a subdomain, so if an MX record exists, it knows to forward/route to a different SMTP server. If the subdomain is unknown, it would bounce back with an error message to the sender. Hope I'm getting this right and it makes sense.However I'm not sure what else needs to be set up in order to route SMTP traffic to FME Server. Any help would be greatly appreciated, especial

Hello, I have an Excel dataset containing many sheets (feature types), and have to read them in the original order - from left to right shown in the Excel user interface. e.g. Sheet2 -> Sheet4 -> Sheet3 -> Sheet1 in the case shown in this screenshot.As long as I tested so far, FME seems to read the worksheets (feature types) in my desired order, but I'm not sure if it's guaranteed as the implementation of the Excel reader.Could you please confirm that it's guaranteed not only in the current and also in the future?