Data

FME seems to disable linetype generation by default when creating dwgs. Is there any way to enable linetype generation?

Hello,I create the feature class il a gdb automatically every night. I need to fill up the item description in the same time. Thank youBest regards

I'm trying to write postgres data from to a new schema. The table I'm reading has a unique constraint on two columns like this: CREATE TABLE public.real_right(    share_numerator smallint,    share_denominator smallint,    upi character varying(50) COLLATE pg_catalog."default" NOT NULL,    party_id character varying(100) COLLATE pg_catalog."default" NOT NULL,    is_deleted boolean,    CONSTRAINT "PK_REAL_RIGHT" PRIMARY KEY (upi, party_id))WITH (    OIDS = FALSE)TABLESPACE pg_default;If I take a look at the reader it shows me only a primary key at upiWhen I use Table definition: Copy from Reader ...Then the bulk data load fails because of the primary key violation.So the question is: Does the postgres reader supports multiple key constraints?And is there a workaround?thanks in advance

Hello,Some strange thing is going on in fme server. Sometime Web Connection is working and some time getting failed.Product Used :-FME Server 2018.0.1.1 - Build 18312 - win64ArcGIS OnlineSteps I have used to setup communication between FME server and AGOL.1. I have created app in ArcGIS online and taken its Client id , Client Secret & registered my fme server redirect uri there.2. Created my own web service from ESRI ArcGIS online and updated Client id , Client Secret & Redirect Uri ( ).3. Created new Web Connection using above Web Service.Then test it and authorized it. 4. Created new workbench which uses AGOL feature reader and used above web connection to communicate(after checking in desktop upload to FME server with my authorized web connection).5. Re-authorize web connection in FME Server 6. Scheduled Workbench for every 30 minutes. So here is the problem my workbench sometimes work ok and sometimes it is getting failed (error - Python Exception <HTTPError>: 401 Cl

Hi,   I'm trying to write to an ArcGIS SDE database in PostgreSQL. I have:FME Workbench 2018.1 64 bitArcGIS Desktop 10.4.1ArcGIS Desktop 10.4.1 Background Geoprocessing 64 bitArcGIS Pro 2.2 First, I got this error:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {No SDEHOME environment variable set} I solved this by setting the SDEHOME variable to C:\\Program Files\\ArcGIS\\Pro, so that the 64 bit SDE dll's can be found.But now I get:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.} The 64 bit PostgreSQL client dll's are in C:\\Program Files\\ArcGIS\\Pro\\bin, but I'm not sure how to instruct FME to use these.

Hi FME experts,I have a number of text files that looks like this (attached). I would like to extract the numbers and store them into different attributes to process them further.A 468832.92042276752B 7175381.1634021383C 2829D 388What is the best way to approach this? So far, I tried unsuccessfully using attributesplitter, substringextractorI tried wresting with regex For instance, the following expression returns \\((.*)\\,everything in between the first ( and the last , but how can I extract each string separately?Many thanks in advance. !table !version 300 !charset WindowsLatin1Definition Table File "a2.jpg" Type "RASTER" (468832.92042276752,7175381.1634021383) (2829,388) Label "Pt 1", (468991.81894034828,7175225.3923977558) (4127,1684) Label "Pt 2", (468917.96947360213,7175142.166946603) (3520,2370) Label "Pt 3", (468878.98707272188,7175056.807626294) (3195,3063) Label "Pt 4", (468691.66407155019,7175209.7422

From reading one Oracle table I'm inserting entries into two other tables, and they should be farther-son related based on the ID-primekey field.However, I can only insert the farther entry. When inserting the son entry containing the relational ID of the farther, FME says, it's missing (or maybe not committed yet).This must be a common known problem, so can anyone help?

Hello,I am trying to convert several CityGML models to FGDB. While I have been able to convert more than half, by using the same workflow and changing nothing, there are some particular models that the translation fails, without any real explanation from the log, as you can see in the attached figure. I do not create or use any OBJECTID attribute and the Writer's User attributes do not contain it by default. As I said, I am using the same workflow for all models and I have successfully written the rest of them. I realize this is not very enlighting information, but this is what the Log produces.  Any ideas appreciated :) Kind regards,George 

Hi there,I've started to play around with the CAT (column aligned text) reader. Is there a way to specify column definition using another text or csv file instead of hardcoding it in the reader?Any advice would be good.Thanks,W

I'm updating FME server to 2018 and I find no way to get access to all schedules in general. If another user creates a new schedule I need to get in to the security settings to get access. Is there no way to always see all schedules created?

Hi,I have files of xyz format that would want to clipp off the scope of the polygon. The output format should be the same as the input xyz. The problem is that I need help in defining the output file.Formatting (the gap must be between the coordinates and should be one below the other, the precision one - which is also the input file.). Input file.xyz320000.0 5020000.0 1257.8320025.0 5020000.0 1257.1Output file.xyz320050.0 5020000.0 1254.0320075.0 5020000.0 1244.6

How can I create CityGML from shapefile included polygon with z value ? I have tested all suggested method here but not working

I have an input DWG file and I need to make some changes to some layers and write these layers to an empty output file, but with the name of the predefined layers. A good example would be to say that the data in my input file will fill an empty output DWG, this DWG file has only the layers and their names, there is no geometry. How can I do this? Thank´s

I am currently using a fme Cloud-instance without the PostGIS database. I never saved the credentials of the PostGIS database because i have my own dedicated database. This is why i never saved the credentials text file with this information (security risk). You can guess what happened... I changed my mind and would like to test the PostGIS database in my current project as a temp database so i can process intermediate results faster. I know that you cannot redownload the credentials file but is there a way to reset the whole PostGIS database and generate new login information for the database? (superuser for the server itself needs to stay intact) No data is in it so i do not mind that is completely reset.Because you cannot download it again:WARNING: Do not lose this file. Once you have downloaded this file you cannot download it again, and there is no way to retrieve it.https://docs.safe.com/fme_cloud/FME_Cloud/Content/About_Instances/Connect_to_Web_UI.htmhttps://docs.safe.com/fme_c

I am trying to write from a sql database on one server to another sql database on another server. The first feature writer works fine but I am getting an error message"Microsoft SQL Server Non-Spatial Writer: Failed to start database transaction. Provider error `(-2147168237) Cannot start more transactions on this session.'A fatal error has occurred. Check the logfile above for details" with the when the second feature writer tries to write.

I do have an huge point cloud which I have to divide into several tiles with an maximum number of 10000 coordinate per tiles. I try to find an solution by using the Tiler or the PointCloudsplitter Transformer, but there was no way to solve my problem - as fas as I understood the transformers.

Hi,we have just ugraded from FME 2013 to FME 2018.1. Input data of the workspace are xml-files. In the workflow a liste ("Namensliste") is created by using the transformer ListConcatenator. The liste containes names separated by carriage return and new line. In RealDWG-Writer a template DW T is specified, user parameters of the liste are "char" for type and "400" for width.Running the workspace in FME 2018 a new warning is now logged: Truncated extended entity Attribute Value in 'Eigentümer' from 'Eigentümer=Mickey MouseMinnie MouseDagobert Duck….some further names….Donald Duck ' to 'Eigentümer=Mickey MouseMinnie MouseDagobert Duck….some further names….Dona'. Cannot be longer than 255 characters in length I checked the created DWG: despite of the warning all listes are written correctly/completely to the layer "ET". How can I avoid this warning? What about the format parameters in the writer? There are some parameters wi

Hello, I'm trying to set up a workspace where I can ingest an API and send it to Socrata. My background is not technical so when I look at the example FME workspaces and research JSON transformers, I know am not identifying all the necessary transformers that would take the JSON and turn it into a CSV. Attached is my current simple test (the credentials are placeholders and do not work) and I would appreciate any insights or direction. Thank you,  

Dear All, I need to convert basemap data (vegetation,roads,building) available in geodatabase format to citygml format.Kindly advice Regards,K.Jayakumar

As part of an API that i'm using I need to encode a .zip file to base64, but I haven't succeeded to do this using the attribute-, text- or binaryencoder transformers of fme. As an attachment I added the file 'receptors1.zip' that I'm trying to encode to base64 in fme. From a debugging script of the API I know for a fact that the base64 encoding that i'm looking for equals:UEsDBBQAAAAIADVVSkv67CW/DQEAABwDAAAOAAAAcmVjZXB0b3JzMS5yY3CN0l1KxDAQB/B3wTvkBDKfycxpyqLiy+4WFlbU0ztJS5KqD7b8Gyj9MZNJr7d0PV1e08fyvK639Lktp/e35QvSy3pZzvd0vmOEIhyRiEZypEQs4o8PkIRE2TlhNiueRNQVEjwBmasnTG4J9pu2dTAJ5pDzzATZglnpDKk+ustOVMt5oXAZQJrLzlSddpcjPjOu5VB9ZsUx1y65M4lwZyaK2+Y2pnZgdGAyMxqbG0y0BMtjc7Vdstm1Lin4cAxx1XLNjMHA7Nowhe23iw+PcDh3g2mYiLgNUwrWPqWDUvv02eE+ze5GvXg5FxOcXZsLi/7hHA/uUK6NRRl39q/tKSr4dHqYdT+Gn/+K9nF+A1BLAQI/ABQAAAAIADVVSkv67CW/DQEAABwDAAAOACQAAAAAAAAAIAAAAAAAAAByZWNlcHRvcnMxLnJjcAoAIAAAAAAAAQAYAABnoJijQdMBAPB4SNxC0wFgWzSbL0PTAVBLBQYAAAAAAQABAGAAAAA5AQAAAAA=On the website https://ww

I'm writing my output to an Excel spreadsheet, but the file also needs to be written to an XML. I've been provided an XSD schema file and using XML Schema Validation in the writer's parameters with the provided file. I get an error of "no declaration found for element 'xml-tables'. I think I need to declare it in XML Namespace Declarations, but I'm not sure what syntax to use for it. Could you provide any insight, @DeatAtSafe?

I have several types of report text files (start/stop, list of features with errors, ran ok no issues, number of rows, counts). to compare them to find errors and put into excel

Hi, I have a load of traffic camera images in AGOL that i want to update regularly using FME. I realise there are the AGOL feature service tools in FME but images are not feature services though they do have a URL. Is it possible to update images?

I have a file geodatabase, I am filtering various features from this and am writing it to DWG. However, I want to break down this single file geodatabase into multiple DWG tiles. I am currently using a clipper to clip to my new tile boundaries, when I go to write however I cannot name multiple tiles with different names because I also want to name the various layer names dynamically. Is there a way I can name the tile for example write multiple tiles (eg. 1234, 1233, 1235) and name the layers individually as well? I hope this makes sense, please feel free to ask questions if it doesn't. It's hard to explain over the internet. Thanks so much for any help. B