Using readers and writers to extract and load data.
Recently active
Hi, I've set up a workspace that utilizes a SKP feature writer and reader before writing to FBX using a reguler writer. This works perfectly well on desktop, but I'm having trouble adapting it for Server. The workspace stops all features at the feature writer with the log message "Features not written - verify feature type fanout/dynamic settings - (Check that fanout/dynamic feature type attribute exists and has a value)". I've tried many different settings in the writer, also using dynamic schema but nothing seems to work.I've been searching for examples of use of feature writer on FME Server on this forum but have been unable to find any. I would really appreciate some tips, in the meantime I guess I have to split up the workspace into several workspaces and run them with a workspacerunner...
Hello You,Do you think it would be possible to add text on a curved line or a circle?Just like this.
Hi all, I'm using a feature reader to query a feature class stored in portal using a where clause, however i want to capture and handle the event if no records are returned. Currently fme will just stop and no longer progress if nothing is returned. Any ideas on how to resolve this? Cheers
I'm reading a DWG file with the above reader and I'm finding that some features have different values for fme_feature_type and autocad_layer. Example: fme_feature_type = RR ALIGNautocad_layer = 0 From reading the reader description here I assumed that fme_feature_type is created from the AutoCAD layer name which is held in autocad_layer:"In AutoCAD, the layers are used to store collections of logically related entities, attributes, or symbology. In FME, the AutoCAD layer and the type of the feature are treated synonymously, since there is a one-to-one correspondence between FME feature type and AutoCAD layer." Is there a reason why sometimes these two attributes do not correspond or is there a bug? Thanks!(FME Desktop 2019.1.3.1 19643 WIN64)
Encountering issues while reading FGDB from .zip files stored under resource folder:-"Unable to connect to File geodatabase. Please make sure the correct file name was specified..."
Hi, I have a lot of DXF files and want only specific layers from this data. Additionally I have an excel file with all layers I want to filter in one column.How can I use the excel file as kind of a filter for the DXF files? The names of the DXF layer are pretty long and it would take to much time to write them all in a testfilter. Thanks and best regards
In Oracle, i have a column called GEOM of SDO_GEOMETRY type. After running FME, GEOM column containing NULL values it is not getting populated.Could you please help me?
Hello,Trying to create a web connection for Google Sheets in FME desktop 2019.1. The email I'm using for authentication is a shared email address. Getting incorrect password alert returned. I know the password is correct.Is it possible to use a group inbox to create a web connection to Google Sheets? Or does the account need to belong to an individual?Thanks
Bonjour,Dans mon workbench, j'ai plusieurs sortie (Writer) qui doivent toutes s'enregistrer dans le même dossier : j'ai 4 sorties CSV qui fonctionnent sans probléme.Mais j'ai 2 sorties qui ne veulent pas s'écrire, j'ai le message d'erreur suivant :"TEXTLINE Writer: Cannot create dataset: 'C:\\Users\\B09278\\Documents\\2_Projet\\6_DATAPOSTE\\2_Moulinette_integration\\Fichier_integration' of type Directory, expected a dataset of type Regular file"J'ai essayé plusieurs formats de sortie sans succés (CSV, XLS, Txt). Je n'arrive pas à comprendre pourquoi ces fichiers ne s'écrivent pas.Pouvez-vous m'aider?Merci d'avance, ~~~~~~~~~~~~~~~~~~~~~~~~~~Translated: Hello, In my workbench, I have several output (Writer) that must all register in the same folder: I have 4 CSV outputs that work without problem. But I have 2 outputs that do not want to write, I have the following error message: "TEXTLINE Writer: Can not create datas
Hello,I Have an error when I want to use a reader to a Non spatial Hana Database (see image below)I have a user that can only access table IFLOT for readTo you have any idea ?I use FME Desktop 2019Thanks
Good day,I have a working FME Server 2019 environment and would like to use the FME DataExpress app on my phone to access FME Server (and server apps). Our company uses MobileIron to secure Apple-devices and set up tunnels for communication.This way it must be possible - at least theoretically - that the IOS-app can connect to our FME-server that is behind our corporate firewall and NOT part of our DMZ.At the moment, it doesn't work and I made an appointment with our system and network engineers. I think we might open some ports in our firewall. Is there any technical information available about the communication (IP-addresses, UDP, ports, etc.) we need to know in order to configure the firewall.Thanks in advance,Frank van Doorne
Hello everyone,I've got a certain problem that I can't solve for many days. I'm trying to find the overlaying areas between an IFC file and an ACAD one. I explain the idea, the purpose is that I've got 2 readers as entries : one for IFC and one for ACAD. then the we need to find the spatial relation between each objects of the IFC and the zones drawn in ACAD. --That point is OK. Then for the objects which have 2 _related_candidates, I would like to calculate the overlaying area with each zone to keep only the one with the biggest overlaying area. My problem right now is about that second step that I can't solve for the moment. I hope it's clear enough and you'll be able to help me with this matter. Regards,Clem
Hi, I use a polygon > boundsExtractor > OSMDownloader but i get error OSMDownloader_HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'Couldn't resolve host name'OSMDownloader_HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set upOSMDownloader_HTTPCaller (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered. What did I miss?
HI,For test purposes I'm reading from two ESRI FileGDB with a FFS writer (no further transformations).Now I recognized that the FFS writer wrote an additional .fts file. It's binary and larger than the.ffs (e.g. 5MB vs 11kb).What is the meaning of .fts files?thanks, Klaus(FME Server 2017.1)
I already have a lot of 3ds files with textures for building. I'd like generate CityGML LOD3 data from these 3ds files.For LOD3 data generating, I think the first and the biggest problem is how to classify Window, Door and Wall.I think it is possible to crop or edit the window or door in 3D MAX.But I don't know how to assign the properties such as Window, Door and Wall.If you have any idea or experience, please share your experience.
Hi, we have SmallWorld 4.2 and would like to automatically export data to another database using FME server on a daily basis. As stated here, the connection service to FME is started automatically in SmallWorld 5.x, not in previous versions. I need to know if it is possible to automate the start of the connection service. The idea would be for example to start automatically the connection service at 1 AM everyday and then start the export workflow on FME server at 1.05 AM. Is it possible with version 4.2 of Smallworld ?Thanks in advance !
Is there a way to retrieve the URL of documents within sharepoint?
I've been working with Minecraft maps and FME for a while, although I'm struggling to develop a way to use change detection for a batch of 40 Minecraft maps, compared to a single map. My main issue is related to improve processing, because processing Minecraft maps as PointClouds is almost impossible due the large files it generate. How could I use change detection in Minecraft maps in optimized way?
I have osm file for my city, I am using Libosmium to read it, and I'm storing nodes of each way as Vertices of My Graph, and making edges between each 2 adjacent nodes in each way, and calculationg eucledian distance between them, the problem is that : The ways are not connected with each other ! I can't reach my destination from my target, even though there is a route, but there is no node intersect between the ways (No common nodes) so I can't reach my destenation ! What nodes should I add to my Graph, and how to bridge them correctly ? so I can reach my destination from My Node ?
I have a user that requires a non-spatial SQL Server Table provided to them as a Tab Separated CSV file. I have found the CSV writer, but cannot find an option to output as tab separated instead of the Comma Separated.Does anyone know if this is possible?Thanks very much for your time.Cheers
I have two inputs that I'm trying to write to multiple pdfs, one is constant and the other changes with a fanout. But I can't get it to put both inputs on one pdf. I'll try and explain with an example:Input one is a roads dataset, input two is a neighborhood's dataset. I'm using a dataset fanout to produce a pdf for every neighborhood and want the roads to also be on each pdf. I can't seem to combine the two, at the moment I get a pdf for each neighborhood and a separate one for the roads. What am I missing?I'm new to FME, so apologies if this is something really simple that I've missed!Andy
Hello,I am trying to migrate PDFs with the FileCopy writer. I have destination path and file names with lengths from 260 - 300+. They fail, but if I change the path to be shorter they all succeed. Am I mistaken in thinking that FileCopy limited to 256 as its max pathname character count? Is there a way around this? Has anyone else run into this issue?Additional info:FME(R) 2019.0.0.0 (20190328 - Build 19238 - WIN64)Windows 10 Thank you for your advice,Andy
When "Overwrite existing file=No" in a text file writer, new data is appended to the end of the file. But if the file output is gzipped then existing file is overwritten. I am testing:The first output is gzipped and the second one not.If I execute the workspace () several times, the .txt file grows but the .txt.gz not. Any suggestions?
I'm having trouble combining contours onto a geotiff raster prior to draping. Can anyone help me to find a process to get the contours onto the Geotiff, preferably with labels on the contours.I've tried the contour generator and a shape file but having real difficulty projecting the contour data onto the raster successfully.
Hi,I had fme desktop 2018 with a fixed license, then i switched to fme desktop 2019 with a floating license, and now i can't open my old fmw files.Once i try to open an old fmw file it gives me an error : File cannot be opened : user may not have sufficient privileges to read the file. (but i still can lunch fme dekstop).Any ideas ?Thank you,Soukaina