Using readers and writers to extract and load data.
Recently active
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.
I am currently attempting to use the las file reader in FME 2019 on multiple files. Unfortunately, the files are not all the same schema. So, I was wondering if it was possible to read these into a dynamic schema? I have attempted to create a dynamic workspace with the reader and when attempting to choose the feature types to read the following error is received: "SOURCE_READER statement must be of the form 'SOURCE_READER <reader type> [<parm> <value>]*' -- `SOURCE_READER WLAS SCHEMA_MODE FEATURE_SCAN -_ENCODING' is invalid : Row came from between lines 1 and 7 of file C:\\Program Files\\FME\\metafile\\WLAS.fmf Failed to read schema features from dataset <path> using the 'wlas' reader"
I have a distributed MS Access app with linked tables that has grown to big and has too many users. We need to re-write into a web app. There are many tables, queries, forms, reports etc. so I expect this will not be a quick process. I'm interested in any advice offered on this undertaking. As a first step, we are moving the DB to SQL Server. The reports will be converted to a standard reporting technology like Business Objects or Tableau using the SQL Server. We'll use Python or Java for backend DB connectivity. I'm hoping there is an easy way to convert the UI into HTML pages. Several pages in the Access app consist of forms with drop down list boxes, radio buttons, check boxes, etc. Any advice?
Could I ask ,How could I look up in field names in Attribute A in oracle no spatial and extract the row of these field names that what am i looking for.I would like to compare between Excel file as reader and oracle non spatial reader and if some field names in Attributes A is missing in excel file so I would like to extract the missing from oracle non spatial And another case ,compare between excel file and oracle no spatial If It finds one field name in excel file is extra sure so I want to look also for this field Name in oracle and extract the row that include this field But I want to say ,excel file and oracle non spatial have one common attribute and the rest of attributes are totally different but I would like to search for this field name and extract the row that relates to this field and put new data in another sheet has the same attributes as oracle..FME version 2018
When trying to Batch Deploy my simple Geopackage files to AGOL the 'Next' button never gets possible. It wants a path to the files to be written. Is it not possible to use Batch Deploy to upload to AGOL or what am I missing?
When I try to write an ECW file of around 1 GB, I get the following error from the ECW writer:ECW writer: The ECWJP2 SDK only has 200.0 MB of memory allocated to it and this is not enough to compress this dataset. Please set the SDK's memory limit above 203.9 MBThat sounds fair enough. Does anyone know how to allocate more memory?Using FME Desktop 2019.2.
Hi FME'ers,I am having trouble authenticating any OAuth 2.0 web connections with FME Desktop 2018.1 (Build 18528). I am trying to access ArcGIS Online but this problem occurs with any OAuth 2 service. I understand that the issue is with my organisations proxy/firewall but I am trying to diagnose precisely where the failure is occurring. FYI, We use a pac file proxy.In Options > Network Proxy, I have 'Use system proxy settings' checked. I know I can get access to the internet with this setting because I have access to FME Hub and can use HTTPCaller. In Web Connection > Manage Services, I select the new connection I created for AGOL and click Test. The credentials screen appears so I enter my credentials and click Sign In. I then get a Network Error dialog box saying "Failed to obtain refresh token: Error retrieving access token. Check Log Window for more details." In the log file I get the message: "407 Proxy Authentication Required" followed my a w
I have a folder with 92 LAS files, see screenshot with example of one LAS file: .Which transformers and non-default settings are required to make these files into one or more FBX files? A direct reader/writer translation results in an empty FBX file.Any help/suggestions/examples is much appreciated!
I have a webpage that has links at the top of the page. Clicking the link brings you down the page to the relevant info (Name Name). I have extracted and parsed a list from the links, and I am now trying to get the data from each link. any ideas? The Href are the links and the h2 id are where the links bring you to I want all the data until the next h2 id. I keep getting the same data if any... <li><a href="http://www.link.com<a></li><li><a href=" http://www.link2.com </a></li></ul><br/><hr/><h2 id="1">Name Name</h2><p><strong>This is the beginning</strong><br/>DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA </p><p><strong>Description</strong><br/> DATA DATA DATA DATA
How to compare a series of tables across two databases? We use a setup that reads a .csv file that has two columns:- Column 1 is a query in database 1, and- Column 2 is a query in database 2Both queries should return the same and ordered list of values (basically, a list of identifiers) and are fed into an SQLExecutor. Both resulting streams are compared using a FeatureMerger, and the UnmergedRequestor and UnUsedSupplier ports report the features that are not present in both databases. This works nice for relatively small tables. If a table is queried that has more than a million records, performance drops. I solved this performance issue by using database readers. I specified the Number of Records To Fetch At A Time (ORACLE) and the Bulk Read Size (MSSQL) and set them so that 100.000 records are fetched each time. I could work this out using a WorkspaceRunner, however my question is: Where are these parameters on the SQLCreator/SQLExecutor transformers?Parameters available on the SQLE
There is no PointCloud element in the Python API and I can't find any function or factory to do it. Has anyone found a way (apart from parsing the log)?
Will there be an update for FME 2019 to make it compatible with ArcGIS 10.8, or do I need to wait until the release of 2020?
Hi FME Fans,Is there a way to run a .dll file from within FME and also pass data to it?Cheers
I have around 100 cells that located in third attribute (machine ) and I want to change the back ground for cells that has specific name old to blue color,i converted the excel file to csv then write again to excel file in my workspace so If i want to look for names in csv ,so my question does excelstyler has another methid not as excel to look for names in csv file.I tried a lot by excel styler but it does not give me result .and also I want to select input for excel styler as row bcs I found it has only option for attributes ,for column but I want to work on rows to alignment line for each specific row ,FME version 2018.Thanks
I have a DXF file containing many feature types, including points, polylines, polygons, text etc. I want to extract the polylines into a shapefile of polyline geometry, and the points into a points shapefile. I am having a hard time finding the transformer(s) needed to carry out this simple task. Can someone please point me in the right direction? Regards, Ben
Hi all, I found this wonderful piece of informatjon in the description of ArcSDE reader (http://docs.safe.com/fme/html/FME_ReadersWriters/Default.htm#sde30/sde30.htm%3FTocPath%3DFME%20Readers%20and%20Writers%20(formats%20supported%20by%20FME%202014)%7CEsri%20ArcSDE%20Reader%2FWriter%7C_____0): The SDE reader can also perform multi-table join queries, thereby exploiting the full power of the underlying RDBMS. Cool... I wanna do that, and most likely either the ArcSDEQuerier or ArcSDE reader, whichever is most convenient. But I can't seem to wrap my head around the syntax. Composing a valid JOIN statement in SQL should be fairly straightforward, but that doesn't really seem to fit into the concept of WHERE Clause. Or I cant figure it out... Problem description: I have a huge ArcSDE database. I and I want to extract all data from table A, and a subset of information from table B, only extracting those whose ROUTE_ID values match ROUTE_ID in table A. In my head, this should
Hey FMErs! Wondering if anyone here has worked with an Internet Query (.IQY) file downloaded from a sharepoint site before! When I open the link in a web broswer (IE11 in this case) it'll prompt a download for this IQY and it'll resolve into a excel spreadsheet! I want to run a automated process on this file from FME but when I use use a XLS reader or HTTPCaller transformer all I've been getting are error messages or the 'GET' response:(left out some details as its internal)WEB1https://xxxxxSelection={7EB5B6E8-8458-4F92-925E-A3EB593229E7}-{9814593B-164C-4604-A5DD-4CAF07C9FDF7}EditWebPage=Formatting=NonePreFormattedTextToColumns=TrueConsecutiveDelimitersAsOne=TrueSingleBlockTextImport=FalseDisableDateRecognition=FalseDisableRedirections=FalseSharePointApplication=https://xxxxx/_vti_binSharePointListView={9814593B-164C-4604-A5DD-4CAF07C9FDF7}SharePointListName={7EB5B6E8-8458-4F92-925E-A3EB593229E7}RootFolder=Thanks in advanced, Patrick