Data

I have 2 dynamic writers in which data are coming from 2 readers (SQL Spatial and SQL non-spatial, respectively). Actually the readers are reading from the same database (A, for example) and the writers are writing out to the same database (B, for example). The reason why I have 2 readers is because there are spatial data and non-spatial tables in database A. I have a SQL script that can set ObjectID to Primary Key. It doesn't seem working properly when I put SQL script into the first writer (spatial). Therefore I had to put this SQL script into the second writer (non-spatial) to make it run properly. Any ideas? Thanks 

I have a CSV file where I need to read only the first line (or first column/line combo) of the file. Is there an easy way to do this with a reader? Or am I stuck reading the whole file? I've tried both the CSV reader and Text File reader. In both, I don't see anyway of isolating this first line of text/data. I'm forced to bring the entire table into the workspace. Thanks in advance!-Mark

I am trying to harmonise an average windspeed ShapeFile to INSPIRE GML.In the in EnergyResourcesCoverage application schema there is a RenewableAndWastePotentialCoverage feature type. However, I can't seem to add it as a writer. I only see the option of the RenewableAndWasteResource feature type. Does anybody else have experience with this? Or is there another way to create this INSPIRE GML?

How to create an index for a mongodb collection using a json templater ?Thank you

Is there a way to use FME to pull the stats for ArcGIS server and create a table or publish to a dashboard? I would like to pull these out and publish so management can see usage.

How could i convert oracle spatial data and non spatial to csv and read it again then use fme_feature_type in excel writer .  parameter tha t i did but i found after reader ,missing data ithat i gotand also after writer a few of my data has been written in temp.csv could someone explain me what should i do to convert from roacle to csv to excel writerThanks alot

I'm trying to read Feature Class from our Enterprise Geodatabase and because we have custom class extensions registered on all our our data.    I am not able to set the Reader to bypass the class extensions.  I get this warning in the log  "Unable to read from the table/feature class 'YK_SPATIAL.Buildings'. If 'YK_SPATIAL.Buildings' contains a class extension, make sure it is registered on this computer"  Thanks

I am trying to update 3 fields for all records in a SDE SQL GDB versioned Feature Class (where building id = bulding id). I have seen several posts and help files but am not having success with the reader + attribute manager + writer or the reader + SQL executer + writer combo. Can someone advise on how best to set this up? Many thanks,

Hello, I am a new FME user. im gonna store csv file in one folder daily. (ex. 20180914.csv)If it comes in daily, is there a way to read only today's csv file?Thanks in advanced.

Hi! I've tried looking for a solution for this but can't really get it to work.I have a folder with several PDF files that I just want to merge into one. Ideally I'm looking to specify that folder and then let FME do the job and spit out a Merged.pdf.Is there a simple way to do this? Tried a solution, but several attributes from the original PDF were lost in the translation. I want this to work with multipage input PDFs.I someone has a good solution to this and can give an example .fmw it would be appreciated! Thanks :)

I'm trying to read multiple spreadsheets and write one worksheet from each of them into a single output spreadsheet but am going round in circles...Input data: I have a parent directory with an unknown number( and names) of subfolders. Each subfolder has a spreadsheet, results.xls. Each spreadsheet has, say, 10 worksheets, ws1, ws2...ws10.Output: fme needs to search the parent folder to discover the subfolders. Then, for each subfolder, it needs to read the results.xls spreadsheet. A single spreadsheet needs to be written to disk containing worksheet ws5 from each discovered spreadsheet with each worksheet given the name of the subfolder that they came from.The FME excel reader seems to need to know the name of a spreadsheet in advance, so I used a Path reader to discover the subfolders but passing these to a featureReader doesn't seem to read in the spreadsheets properly.Any help would be appreciated.ThanksMacsmith

Hi all, This should be really simple, but I can't work out what I'm doing wrong in my workspace. Any help appreciated...I need to update a couple of attribute fields in a SDE feature class with values from an Excel table (attributes only, no geometry. Yet.). Using the Excel and 'ESRI Geodatabase (ArcSDE Geodb) readersI'm using the 'FeatureJoiner' transfomer to join the two readers together based on a unique identifier (ESRI Global ID field in the SDE feature class, which the person who created the Excel table also used to capture their new data), then put it through the 'Attribute Manager' transformer so I can map fields between the Attribute Manager and my writer (the columns in the Excel file and SDE feature class have slightly different names, but I know which ones correlate)I'm using the 'ESRI Geodatabase (ArcSDE Geodb) writer, settings:Feature operation: UpdateTable handling: use existing Update spatial columns: NoRow selection: Match column

I am trying to setup a job in FME that reads a CSV file where the filename changes daily. The filename looks like this HHSVENDORS_02242020.txt. The HHSVENDORDS_ is always the same, but then it has the date appended in the format MMDDYYYY. Is there a way to dynamically create/read the input filename on a CSV reader? So when the job runs each evening, it will pull the correct file.

Hello. So I'm currently having an issue with the excel reader and I'm not sure I'm missing something. If I drag and drop or add the dataset to the workspace and configure it, it will read correctly. In this case, I want it to start reading the data from row 6 (1 to 5 are the header) and go from there. This works for the initial file, but if I change the source data to pick up a different file with the exact same format, the settings are somehow reset and it starts reading from row 1, resulting in no attributes or features being read. I've tried updating the reader feature types and changing the Microsoft Excel Parameters for it, and while it works when inspecting the data, when I run it, it goes back to missing. What I need is to be able to feed different datasets into this reader but all with the same format, so there's no need for it to be dynamic. However I can't understand why the parameters only work for the first file it reads, despite it being fine when I

I have been provided with a set of dwgs which have autocad text in it and rotation values expressed in degrees e.g. '96d'. I need to read the value as '96', how do I do this? This is the first time I've seen the rotation units expressed this way. When I translate the dwgs the rotation values do not translate into text or numbers. I'm converting the CAD files into Esri fgdb feature classes and have AutoCAD 2019. 

Does anyone have any idea what this means and how to fix it? PDF2D writer: invalid map<K, T> key It has something to do with fonts when trying to read from a local font directory. If I clear the true type font folder, I don't get the error but the output PDF is not correct. 

Hello,Is it possible to automate the backup of ArcGIS Online feature services and associated relationship class(es) within AGOL with FME?I have a current workflow that backs AGOL data both within AGOL and locally as a file gdb; however, the relationship class is never replicated in either backup. I understand for file gdb's that "Relationship classes cannot be created through FME and must be set up through ArcGIS prior to running the translation." However, I was wondering about the AGOL backup data. Any way to retain that relationship class using FME when backing up (writing to) AGOL?

I have files with raw NMEA AIS messages that I need to decode to a delimited text format. Sample raw messages:\\c:1581638400,n:24896*14\\$ANZDA,000000.00,14,02,2020,00,00*79\\c:1581638400,n:24897*15\\!ANVDM,1,1,,A,15Nh=bP00hqWTC:E<3F<6Ign20Sd,0*1C\\c:1581638401,n:24898*1B\\!ANVDO,1,1,,Y,E1IDWe0:aPQRg`94QRagV0W24W3tkNcA:UujH00000P020,4*09\\c:1581638401,n:24899*1A\\!ANVDM,1,1,,B,15N8ct0P00IWliDE;UJpMOv42<1:,0*2C\\c:1581638401,n:24900*1B\\!ANVDM,1,1,,B,15N3Ib?P01IWiupE<espU?v40D0t,0*6B\\c:1581638401,n:24901*1A\\!ANVDM,1,1,,B,15O0JF?013qWbjPE;VwUKDP00<1C,0*3D\\c:1581638402,n:24902*1A\\!ANVDO,1,1,,A,E1IDWe0:aPQRg`94QRagV0W24W3tkNcA:UujP00000uP20,4*4C When I try to read the NMEA strings as AIS messages, the header isn't recognized by FME as a valid AIS message. The documentation lists the only acceptable message type headers as "!AIVDM" or "!AIVDO". I've been told the messages in my data are valid position reports, and they are correctly encoded wit

Hello Team, Is arc SDE32 bit writer supports with FME Server 64 bit?, We have Arc SDE 10.1 with 32 bit and FME server 64bit with 32 and 64 bit engines installed in the same machine. Is it valid configuration to run a workspace?Thanks...

Hello,I know (hope) that there is probably an easy solution for this. I'm trying to read the XML file using the Feature Paths configuration type but it seems I can't get it right... I have simple xml file like this:<A>    <B>        <ATT1>10</ATT1>        <ATT2>20</ATT2>    </B>    <B>        <ATT1>30</ATT1>        <ATT2>40</ATT2>    </B></A> I want to read it like this:ATT1ATT2 10 20 30 40  Instead, I'm getting this:ATT1 ATT2 10 <missing> <missing> 20 30 <missing> <missing> 40 Can somebody please tell me what setting I have to apply in XML reader. Thanks!Mario 

Hi,I have been using the Microstation DGN Reader for many years. I always make sure to deselect the 'Preserve Curves' option in the Reader Parameters as this then creates extra vertices to preserve the shape of the curve as per the explanation in the Help page:This parameter controls whether or not curve elements will be stroked into lines by adding vertices.When selected, the control points of the curve are connected into a line. This option preserves the original control points and the end slopes. This is primarily used for DGN-to-DGN translations.When deselected, the control points are used to interpolate a linear representation of the curve. It strokes (vectorizes) the curve (that is, it preserves the shape of the curve). Deselecting this checkbox enables the parameter Number of interpolated curve vertices.  However this explanation does not state the interpolation method used for 'vectorizing' the curve. Does anyone know what method is used in FME Desktop 2019.1?

Hi  I ma writing to an exisitng ArcGIS file geodatabse which is set up with subtypes and default attribute values. When i wrtie to table File GDB only the attrbutes specfies with in the workspace a filled in, none of the default values for the other attributes are applied to the features. How do i get the default values to be filled in when i write to the tables, without setting up the values with attribute creator? There over 700 attributes to setup maunally if i cant get the values embeded i nthe fileGDB to write. Or how can i set up the valuies in my workspace with out having to manually type out or cut & paste all 700+?  Thanks in advance Cheers Jacky

I have made a workspace which is used to map geometric errors. My data is stored in the gml-format.In my workspace I have a FeatureReader, which reads GML data. Issues in my source data can be among other things:Consecutive vertices in lines or polygonsToo many coordinates in my point elementsNon-closing polygons (last vertex isn’t the same as the starting vertex)The problem I have with my gml FeatureReader is that these errors are fixed automatically by FME. The consecutive points are removed, the last coordinate of my point element is used and my polygon is closed automatically by adding the first vertex as last coordinate. This is convenient when I want to work with the data without hassle, but in this case I want to know what those issues are so I can correct my source data or report errors.Is there any way to show the errors corrected by the FME reader or prevent the reader by doing so? 

We have a DWG drawing where the arrow heads have been created as a block but the arrow heads are not coming into FME and hence I am not able to output the arrow heads to a PDF.   I have exploded the blocks into entities but still no luck. Is there a way to recreate the arrow heads when outputting to PDF or bringing the data in from the DWG.Attached is a sample drawing to help understand what I am trying to achieve.Any assistance would be appreciated.