Data

I'm probably wrong somewhere  

I have a task where I need to extract data from a database and save it as a csv in SharePoint I had hoped to b able to specified the path to the SharePoint folder in the csv writer, but this does not seem to work.  The error I get is CSV writer: Failed to open file 'HTTP:\\\\projectzone.tnad.tasnetworks.com.au\\business-projects\\iap\\TE\\HVDC Cable Specifications\\SATVUE_99021037_2021_08.csv' for writing. Please ensure that you have sufficient privileges to write this file. If the file already exists, please ensure it is not open in another application I am using FME Server and the FME Server service account has permission to write to this location.

HiI generated a CityGML model in LOD 4 with its respective appearance using AppearanceSetter. I am trying to load the model to Cesium Ion but it loads without appearance. Can anyone help me with some idea to solve this issue.

I have a dwg-file with multiple linetypes (dashed, dash-dot, solid).The Option in PDFStyler allows me to define only one "array" or use a parameter.Is it possible to write multiple "Line Dash Arrays", or ca i put only one in a pdf?Who can help me?

Is there any way to read the smallworld internal features in EDO in GESW 4. X.

It seems straightforward enough using the PointOnRasterValueExtractor. The problem is it is only grabbing one value and putting that in all the points. I am guessing that the secondary files with the tiff may hold that 'value,' but I am unsure. The last screenshot shows the data doing it the slow way through ESRI's geoprocessing tools. Any help would be appreciated.

Dear FME community, Within a workspace that uses a specific view for reading a revit file, we have found that not all feature types that are present within the specified view are read by FME server. On desktop (using the same version and same workspace) it does automatically read all feature types.  At first we tried leaving the 'feature types to read' option empty, which made this difference visible within the log and output files. Secondly we tried adding all possible feature types to read to the reader, however this also did not fix the issue. Does anyone else have a similar problem and a possible solution? Maybe the cache is used differently on desktop vs server?  Added some log images of the feature types read by desktop (6 feature types read) and server (stops at 3th feature type read). server: desktop: Edit: After adding a featureholder after the readers, all feature types are read by both desktop and server.

I'm having a hard time using the WFS XML filter. I surely built a working workbench before so I am sure this worked. The only thing I want is adding a boundingbox in the WFS (2.0.0) request. I open the XML Filter setting and entered:  bbox=48187,407743,148934,408593 The workbench fails. Log:  <ows:ExceptionReport version="2.0.0" xsi:schemaLocation="http://www.opengis.net/ows/1.1 http://geodata.nationaalgeoregister.nl/schemas/ows/1.1.0/owsAll.xsd"><ows:Exception exceptionCode="XML getFeature request SAX parsing error" locator="org.vfny.geoserver.util.requests.readers.XmlRequestReader"><ows:ExceptionText>org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog. Content is not allowed in prolog.</ows:ExceptionText></ows:Exception></ows:ExceptionReport> I look up the URL in the log and there it is: FME prefixed my filter with "FILTER="  FILTER=bbox=48187,407743,148934,408593 When I copy paste the url from the log to

I am new to FME and this is my first post. I am trying to create a workbench that will search through hundreds of windows folders and convert pdf to tiff images. I have tried the ImageRasterizer with no luck. Is this even possible? Thank You

Dear All,  I am trying to write some features in a versioned featureclass. Instead of writing it directly to the SDE.Default,I have created version in ArcGIS and I have set the FME output to write to that version and I have made sure you have Versioning set as your Transaction Type under Advanced settings.I have Run the FME workspace and it has come up with below error message.  I am not sure why this has come up. Please let me know if you are aware of this.  Error message:   An error occurred while attempting to store a row into the table 'ARCFM.Lamp_LV'. The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {}  The Zone of the assembly that failed was: MyComputer log4net:ERROR XmlHierarchyConfigurator: Appender named [MinerEventLogAppender] not found. log4net:ERROR XmlHierarchyConfigurator: Could not create Appender [Log4NetEventLogAppender] of type [log4net.Appender.EventLogAppender]. Reported error follows. System.Security.Securit

Is there a way (or a script) that can turn off AUs when writing to SDE tables? I have tried the solutions from the below question and they didnt work for me:https://knowledge.safe.com/questions/95896/how-to-turn-off-arcfm-auto-updaters-using-pythonca.htmlI am looking to do this because I get an error when writing to the table from FME server but I dont get an error when running from FME Desktop. I am just trying to try any solution I can at this point.Thanks.

I'm really struggling with the string functions in FME at the moment. I have a workbench reading JSON features from an API and I have one attribute where the results are in a list. The JSON extractor results the attributes like this:  ["Medium"] Or if there are multiple values, like so:["Easy","Advanced"] I want the results to be: MediumIntermediate,Easy I want to remove the brackets and quotes using a single transformer and can't figure out the formatting for my life! Currently I have 3 separate "string replacers", each one removing a single character, but there must be a better way...I don't mind using a REGEX expression if someone can figure it out. I'm also open to using a different type of JSON query to extract these values? If there's a way to get the attributes without the brackets and quotes? I also tried using the string pair replacer but I constantly get an error, and I can't seem to format it properly. I wish yo

Hi,I was looking for the way to resolve geodatabase domains from a reader.It took me a while to find this post https://community.safe.com/s/question/0D54Q000080hOcnSAE/how-to-expose-a-file-geodatabase-domainFor me, Updating feature type solved the problem but I'd wish FME would give the user hint that he needs to do this feature type update.Here's the thing in more words :When you add a gdb feature class or table which has fields with domains, if you don't check the option "Resolve domains", the table is added with the codes, and that's all and that's normal.But then if you want the domains and in the parameters you check "Resolve domains", then you need to Update feature type to get the _resolved fields.I think the user should at least be getting a warning that he needs to Update feature type.Cheers,Tim

I am using a Smallworld Edition of FME, version 2017. How do I use it to export internal objects and have it reference back to its world owner.

Hello,FME throws an error when I want to write to a PostgreSQL table that contains a generated column (value calculated from another column). Message: generated columns cannot be used in COPYIs there any way to ignore this column (by clearing the column from the writer, the error still occurs) or work around this problem?Thanks for your help

I have workspaces authored in FME2018 that use informix spatial readers. In 2018 I am able to set a WHERE clause within the FeatureReader. In version 2021.1 I can no longer do this as the WHERE clause option is greyed out.Is this a known bug or intended behaviour?

​I am getting a HTTP status 405 error when I try to generate a GEOPDF using the link http://arcgprdcgy001.network.lan/fme/GenerateGeoPDF/. It says: HTTP method GET is not supported by this URL. The method received in the request-line is known by the origin server but not supported by the target resource.

i want to read an aprx or lyrx file in fme . is it possible?

I have attached the actual workbench below. SO in more detail, what I am trying to do is to output fanned out (by council name) shape files and GDBs to an already existing folder (of the same name as the council name attribute) on a drive somewhere. Is there a way to direct the output data to go into the different council folders when this workbench is run for all councils?The intention is to place this in the server and then schedule it to run on a quarterly basis.any thoughts?thanking you in advance.

I have an excel spreadsheet with 3 columns (featureclass, tag, summary). I want to update the metadata.xml file that corresponding to the featureclass. These xml files are embedded in a column in an sde table gdb_items. I'm able to extract the xml, but I don't know how to add xml elements. I have seen the xmlUpdater which works but only when that tag exists in the xml. Also, the "tag" field in the excel is a list of tags separated by commas. I need to create multiple <keyword> tags, one for each item. Here's my workspace so far. shows the xml without the existing "summary" and "tag" <idPrup> <searchKeys> with child nodes <keyword>, respectively shows xml with those nodes (lines 80 to 86)

I'm trying to convert a DWG with solids to an OBJ mesh.The conversion is good but the OBJ doesn't include the color of the solid ("autocad_color"). I tried GeometryColorSetter but I can't seem to set it up properly.I also tried the AppearanceSetter, following this post: https://community.safe.com/s/question/0D54Q000080he8G/how-to-set-the-color-of-an-ifc-objet-ifcproxy but I can't set it up correctly Could you give me some suggestions on how to setup the transformer GeometryColorSetter (or a better one) so that it takes the "autocad_color" of the geometry and gives the same color to the resulting obj.

Hello everyone! I have a question regarding information security in server applications. Is it possible to perform 2-step verification for apps with sensitive Data? There is of course the access using a username and password that I set. Is it possible to do another step for verification via email, for example?Thanks!

I have a gdb (ESRI) dataset from Locusview which QGIS can read fine but FME Data Inspector (2019) says there is a file missing, but doesn't say which.  The key part of the errors seems to be: "2021-08-26 05:19:36.616 ERROR - Geodatabase Error (-2147024894): The system cannot find the file specified." Log reads as follows: 2021-08-26 05:19:20.981 INFO - FME Data Inspector is starting up...2021-08-26 05:19:29.189 INFO - Loaded module 'fmeprompter' from file 'fmeprompter.dll'2021-08-26 05:19:36.204 INFO - Creating reader for format: Esri Geodatabase (File Geodb Open API)2021-08-26 05:19:36.278 INFO - Trying to find a DYNAMIC plugin for reader named `FILEGDB'2021-08-26 05:19:36.279 WARN - FME Configuration: Maximum of 2000000 feature(s) will be read starting from feature number 12021-08-26 05:19:36.613 INFO - Loaded module 'FILEGDB' from file 'C:\\apps\\FME2019\\plugins/FILEGDB.dll'2021-08-26 05:19:36.614 INFO - FME API version of module &#

Hi, I'm trying to create a workspace to check multiple DWG versions, Iäve tried Real DWG reader and others, but cannot find the attribut that tells me the version. I made a picture below.Select multiple DWGs to readCheck The DWG Version with a testerOutput filename and check if version is 2013 as en excel(or user selected version test check)My issue is mainly finding the version at all and making it into a tester  

Hello,I'm wondering if anyone is actively using I3S files from FME in ArcGIS online. I ran into some issues, where depending on the camera position, some meshes disappear. Like this: https://i.imgur.com/R9PMcj3.gifvIs this maybe because of missing LOD defintions?