Data

I am building a workbench that uses Workspace Runner to reproject a lot of MapInfo tables. My question is about the workbench that does the reprojection. All the MapInfo tables have different schemas (different columns). How do I build dynamic readers and writers that work with any column structure (but still specifically MapInfo format)

I am building a workbench that uses Directory and File Pathnames Reader and Workspace Runner to run a translation on a bunch of MapInfo tables.I want to only run the translation on native MapInfo tables. Not image tables, WMS table or links to oracle datasets.I can do this easily enough in MapBasic, where I can use the TableInfo() function to return if a MapInfo table is of type TAB_TYPE_BASE.Is there a similar transformer in FME? I have already looked at exposing attributes, but none of them are helpful

Also read the IFC examples here on the forum but i didnt come to a solution because here is no really example from SHP Multipatch to IFC

I have a Workbench. It has a Esri ArcGIS Online (AGOL) Feature Service Writer. It works perfectly. Workbench was daily running successfully. Now yesterday we upgraded from Version 2019.1 or .2 to Version 2020.2 Now i get errors and the Writer cant find the content of the Group anymore.I dont see anything if i want to choose the Feature Service. Not even Groups. The Writer changed from the two FME Versions because in the new Version at Feature Service the ID gets attached behind. That was not in the old Version. If I use the Esri ArcGIS Online (AGOL) Feature Service Reader i see every Group and everything i should see. If my Collegue uses his Account he can see the Groups and everything in the Writer. I dont. Now the Question is it a FME Problem or ArcGIS Online Problem? With my ArcGIS Online Account and the Groups nothing changed only the FME Version changed and now i cant see any Feature Service and before everything Worked perfectly.

im trying to use a ChangeDetector and routing the Updated section to an AGOL writer with a writer mode of Update. however, i keep getting the following error and im not sure how to fix it. "ArcGIS Online Feature Service Writer: Encountered a feature for feature type 'LiftStationInspection_Weekly_table' that is missing the ID attribute 'OBJECTID'. This attribute is require"

When trying to change the data type in the ArcGIS Online writer, the esriFieldTypeDate(width) is not an option. I want to have this type of field because I want to enable time in my hosted feature service.

Hello, we've been working with a client for a couple months to run business rules against dwgs.One of the requirements is to ensure the System Variables BASE and INSBASE X, Y values are set to 0,0 to help ensure that xRef drawings align correctly with the 'base' or currently opened dwgWe have reviewed the following and don't believe what we are looking for is supported with this option and uncertain if what we are trying to unlock is even possible with current 2018.1 release(http://docs.safe.com/fme/2018.0/html/FME_Desktop_Documentation/FME_ReadersWriters/acad/Drawing-System-Variables.htm) Related AutoDesk Links:UCSBASE CommandUSCBASE VariableINSBASE VariableAutodesk Forum Discussion About Thanks for any insight

Hello, I'm trying to get rotation information of a cell which come from a DGN.I found it for text element but not on cell. In microstation the information is present but not in FME, do you have any idea ? In the help here : https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/dgnstyler.htm it say :OpenCell Rotation Specifies rotation of the cell (in degrees counterclockwise from horizontal). This can be set to any floating-point value between -360.0 to 360.0, or be set to a value taken from an attribute. Format attribute set: igds_cell_rotationBut I haven't this attribute in FME : But here in Microstation you can see the information (50 g = 45 deg)

It seems that the FME translator for Smallworld applies the "unset value" to any field where the value is unset. Is it possible to export a null value instead. We would like to preserve the values as is and not have to try to come up with some convoluted process to deal with it. Only thought I have would be to pick a default value for each field that we know doesn't exist in any of the existing data. We would then have to look for those values after exporting the data from smallworld so we could then again put them back to null. That could be a lot of work for all of the different classes we need to export.

I have a complicated json object that I would like to count the number of elements in one of it's child objects. Given the size and complexity of the original json, I would like to avoid flattening it and using the listElementCounter.

I have worked out that I can use the Fanout feature on both csv and xlsx files, and I need the output as csv files, however outputting to a csv creates separate folders for each file and I need it output to the same file. The second part is that I want the output to start writing on row 2, with each file output to have the same value in cell A1.I know that if i output to excel i get individual files, named based on the attribute I specify, but all the files are in the same folder, which is halfway to what I want.What I cant work out is how to:insert a specified value in cell A1 on every file; andoutput as a csvIs this possible in FME or am i going to have to write a macro for excel that runs through each file, adds the value in cell A1 and then saves the file as a csv?

You can reach me at (613) 447-8306.

I'd also like to be able to analyze and set properties for the feature symbology.

I am converting geodatabase data to JSON and using the HTTPCALLER to upload to an API. The JSON output from FME is adding square brackets[] as the first set of brackets but the API is looking for curly brackets{}. Is there a way for FME to output curly brackets instead of square brackets?The API is also looking for some additional text between the first and second open brackets. Can I insert additional text between the brackets in the JSON output?For example the FME JSON Writer is writing [{json text}] but the API is looking for {site:{json text}} Thanks, David

When converting a 3D model to GLTF (2.0) which has png textures with an alpha band the output looks pretty weird in most viewers. The alpha value in the textures is at the Max (255) so it shouldn't be transparent, however, FME sets the alphamode to 'BLEND'. While I understand the logic in this I think in practice a better default for the alphamode would be 'MASK'. In the image below you can see that the inner cube is rendered even though the outer cube has a texture which has no transparent pixels. In my situation the issue can be solved by simply having jpegs as textures, however, this is often not possible to get.  In other situations, for example billboard trees, you want to have transparency, but in the form of a 'MASK' not a 'BLEND'. I would argue that in 90 % of cases the 'MASK' option would be better than 'BLEND'. I've attached the model for inspection.  Note that this seems to get rendered the same in all the renderers I&

I am having an issue with a specific MapInfo TAB file that when I put it through it's different attribute and geometry filters, it is outputting the wrong size text. The last transformer the file is going through is a DWGStyler where I have a specified height. The strange part that is confusing me with all of this is that the single line text is outputting the correct specified height I have in the DWGStyler, but any multiline text is being outputted as a combined text height. For example I have the height set to be 0.4. The single line text displays as 0.4, a two-line multiline text displays each line with a height of 0.2 thus adding up to the specified 0.4. This to is the same if it three lines of text where it displays as 0.13 for each line. I have tried toggleing the Text Entity Type from multi-Text to Text with the same outcome. Any suggestions would be great. I am more Autodesk than FME. I have AutoCAD Map3D 2014 and am aware that I can import these MapInfo files, but the dat

Hi, I would like to write tagsets for linestrings with display set to 'yes' out to a Microstation DGN file with the bottom-left corner of the tagset being located at the start of the linestring.  When I write the tagset with offset set to 0, some of the tagsets appear at the beginning of the linestring, but some of them appear in seemingly random places. I'm assuming this is related to the radius of the curve of the particular linestring. I have tried following the advice in this article (https://community.safe.com/s/article/writing-microstation-dgn-tags-with-fme) and using a CenterPointExtractor followed by a CoordinateExtractor, followed by an ExpressionEvaluator, but this doesn't put the tagsets in the correct place. I'm wondering if this is because this method only works for polygons and not linestrings? Does anyone know how to calculate the offset of tagsets for linestrings so they are placed at the start of the line? I guess in other words, where does FME put

I worked with one of our interns on developing a pretty simple workbench that queries records from a REST service using a project #, styling the popups and icons, and writes it out to a KML that is then downloaded from FME server using the data download service. I have exposed the attachment from ArcGIS Online and have the process worked out for converting them to base64. The next part that I'm needing help with (why I posted this) is determine the best way to embed the photos in the popup, which are varying content subtypes of image (image/png, image/jpeg, image/jpg, etc). I've attempted (unsuccessfully) to embed the base64 image in html, but it doesn't seem to load. I think the best way would be to save the images in a folder, and somehow reference the local image path in the kml popup... Both the KML and Images would be downloaded through the published data download service.

Hi There,I am using FME to convert data into DWG by using a predefined template. This works fine but has the limitation that I cannot dynamically create layers since they will not match with the template definitions and creating the layers in the workspace has its own disadvantages. I cannot add all possible definitions into the template since the data and therefore the splitsing of the layers is different per conversion. I would appreciate any ideas or other ppl experiences trying to achieve this. Cheers, Itay

I'm working on a project where I need wave models created in MatLab. I have download them but when reading I get rotated coordinates.For some reason, wave models operate with rotated coordinate systems as opposed to conventional ocean models (rlat, rlon). How can I manage to read and rotate this data with FME? 

Hi,I am writing out line geometry with a tagset to a Microstation DGN file. I can't work out how to change the level of the tagset to be different to the level of the line geometry to which it is connected. Is there a way to do this?Thanks,

I want to prepare the mapping from 1 oracle database (11) to another (19). Problem is that the 19-database is not installed yet, and the only way of preparing the migration is from Oracle 11 to a fgdb, which have alle the attributes lower case. Thanks.

Hi, I am using FME Desktop version: FME(R) 2020.1.1.1 (20200817 - Build 20614 - WIN64) Using the SQLExecutor (version 9) against an Oracle Spatial Table, I am running  a SQL statement such as below:select "LINE", "COLOUR" from "SCHEMA"."TABLENAME"  This statement 'runs successfully' when tested but when I expose multiple attributes using the 'Attributes to  Expose' field, this does not work and a single attribute with all the field names concatenated with a comma is being output:  If I expose a single attribute only then the output is correct.  Is this a bug with this version of FME Desktop 2020.1 and or SQLExecutor Version 9, as it does not happen with previous versions of FME Desktop and SQL Executor?Thanks!

I have a google spreadsheet template located on my google drive that I want to make a copy of and move to another folder in Google Drive. The drive connector doesn't allow me to copy or download gsheets. I was able to have a gsheet reader and writer create a copy of the original spreadsheet however the styling isn't preserved... Does anybody have a work around for copying googlesheets and preserving styling?

Hi, In workspace app after I upload data (gdb,shp), I would like to see the fields that can be selected by user? Can anyone suggest any ideas?