FME Form

Hi, I’m trying to add into a pdf (PDF2D) an image. I have created it as a png with transparent background. However when the pdf is created the background is black. I have tried different things but can’t figure it out how to remove the black background. This is what I’m doing: CreatorRasterReaderRasterGeoreferencerPDFStylerPDFPageFormatterPDF2D Writer  I played with the PDFStyler but it doesn’t change the result. Can somebody guide me? Thanks,

Currently I am moving from FME 2018 to FME 2022, but during the FME Desktop Advanced trailhead training it says that some transformers only have cosmetic changes. I want to know what the main, commonly used transformers which I can advise my team to always upgrade in their workbenches. Thank you in advance

I need to convert: { "keys": [ <ordered list of field names>], "values": [ "<ordered list of field values, matching the keys field order> ]} What is the best way to do this in FME? Input example: see attachment  

Currently we have the following where clause for the database connection which works well: Need to add additional parameter which is [transactiondate]= CONVERT (date, GETDATE()) . Tried the following but no results returned:[PartDate]= CONVERT (date, GETDATE()) AND [transactiondate]= CONVERT (date, GETDATE()).Ran in SQL and for sure there are data based on the above where statement. Please let me know what did i do wrong. Thanks.

Hi! I have a big Workbench which does a slope and aspect calculation on roofs to evaluate the potential of solar panels.  I have solved everything except setting different colours on my faces based on the calculated effect by a colour-range. I want to export the extruded 3D polygons to Cesium ION as Cesium 3D tileset to minimize loading time.  See print screens on my workspace below, i have tried maybe 100 different settings on AppearanceSetter and AppearanceStyler without result the only colour visible in the Inspector is the default grey.

HelloI am converting .gdb files to dwg format and want to add autocad object data from the gdb file.Can you help me to get there?

Does anyone know if it's possible to suppress or otherwise fix the following warning which comes up when writing features to an MS SQL server database? The column in the database is "nvarchar(max)" but FME always flags this warning when the workspace runs, because it uses "nvarchar_max". It's only a warning, but when we then deploy this to FME Server/Flow - we regularly check the job logs and these always show the exclamation icon - so just an annoyance as it's not actually an issue.

We updated our FME server from 2022.0.1 to 2023.0.1, ButWhen I try to convert a FGDB file to another format. I get the error screen as belowWe installed Arcgis pro 2.9.3 already.But it is working fine in FEM server 2022.0.1

When the published workspace is unable to connect to database or ArcGIS services via feature reader, then the translation fails but the FME server job status is success. I would like to know if there is a way that FME server status can be marked as failure when specific condition are not met with in the FME workbench workflow??

Logs: OpenAICompletionsConnector_2 Input Input Collector (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_Input1680804321 Input Splitter (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_ParameterFetcher (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_EmptyNumericValues (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [3]: Starting HTTP upload to 'api.openai.com'. Expected transfer size: 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [3]: HTTP Upload: sent 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [1]: Starting HTTP upload to 'api.openai.com'. Expected transfer size: 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [1]: HTTP Upload: sent 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [2]: Starting HTTP

I am reading in 89 TAB files (geology polygons) doing a bunch of stuff, combining them and writing them out as TAB, GDB & SHP. I'm extracting both HEX and RGB values and adding them as attributes to the datasets to facilitate attribute based styling. The output RGB, HEX values match the input values. Unfortunately, the MapInfo writer(s) are outputting the incorrect colours i.e. mapinfo_brush_background and mapinfo_brush_foreground values. An inspector just before the writer has the correct values, but the final TAB file does not. The strange thing is that when I filter out 3 polygons for testing they output with the correct colours. It just goes wrong with 158,000 polygons. Any ideas?

Hello, We have a situation using SAP HANA Spatial and we would like to be able to access data held in SAP HANA database tables. We know that native reader/writer does this but I understand from customer that in such cases, we will loose guaranty for SAP from provider.Second option is JDBC driver (or it is mandatory for first option???). In conclusion, my question is if there is any other SAP connector already developed (which can connect to client accessing SAP database). Thank you.

HelloAs stated in the title, the left pane takes too much space thus making harder to write / review codes. It basically cannot be resized. Noticed this in FME 2023.0.0.3 and 2023.0.1

I have the excel reader and have imported the data, but I dont know how to split the columns and say something like: (GPT4 Prompt)I have a flashcard with the term {TERM} with the definition {DEFINITION}. I want to convert this flashcard into a multiple choice question. The definition will be the question and the terms with be the answers. You will generate the question and 4 answer choices. The correct answer choice will be prefixed with a '*' character and you will generate the other 3 incorrect answer choices. When generated the incorrect answer choices, make a selection to where the user will not be able to easily use process of elimination to conclude the correct answer. For example: Uppers, stimulants. Legitimate and useful medical applications, but often abused. Example Ritalin for ADHD. Adderall for obesity, ADHD and narcolepsy are called what? *AmphetaminesGPT generated incorrect answer choiceGPT generated incorrect answer choiceGPT generated incorrect answer choice Tha

here's the curl:curl --request POST \\   --url https://api.assetpanda.com/v3/session/token \\   --header 'accept: application/json' \\   --header 'content-type: application/json' \\   --data '{ "email": "username@company.com", "password": "pASSWORD123"}'

Install: WordToPDFWriter Dependencies1 comtypes python package To install this depenency,  start a command prompt as an administrator and execute the following command:  fme.exe python -m pip install comtypes --target "C:\\Users\\<YOURUSERNAME>\\Documents\\FME\\Plugins\\Python"2 Microsoft Word must me installed on your machine. ========================================================Error running on FME server: 119 2023-2-13 15:08:46 | Python Exception <ValueError>: NULL COM pointer access120 2023-2-13 15:08:46 | Traceback (most recent call last):121 2023-2-13 15:08:46 | File "<string>", line 47, in input122 2023-2-13 15:08:46 | File "C:\\Users\\xxx_fme\\Documents\\FME\\Plugins\\Python\\comtypes\\_meta.py", line 13, in _wrap_coclass123 2023-2-13 15:08:46 | result = punk.QueryInterface(itf)124 2023-2-13 15:08:46 | File "C:\\Users\\xxx_fme\\Documents\\FME\\Plugins\\Python\\comtypes\\__init__.py", line 1197, in QueryInterface125 20

Hi community, I've many postgres table in source, with differents structures. I would like to send them in Big Query, with, for each table, the same structure, so I thank to regroup source and regroup target to do that. But, I would like, transform the date format for each postgres field. In fact I know to do that with DateTimeConverter but I've to declare all field one by one. It is possible to do that with "all date fields" ? Thank you for your help.

HiI drew a simple shape with google my map and export it to kml in my browser then i convert it to dwg/dxf with FME quick translator to modify the shape with Autocad, but the original map stretches out and shows a wrong map, it also happens when i convert dwg/dxf files to kml or gpx.how can i fix it?

HI, I get error above when i write to Feature Class in SDE. i have no issue if I write into GDB.( i also attached the log file here).would you let me know what the issue is and how to solve it. Appreciated for your help.

Hi. I'm trying to decode a .zip file sent over mqtt connector. I recieve the message payload attribute with the zipped string and want to decode that string to plain text. I'ts not the mqtt message that is the problem but how to decode this zipped attribute into plain text on the fly inside a workspace?Thanks, Stefan

How do I automatically delete both the parenthesis and the content in them from my reader file? Is String Replacer the transformer to use? If so, can you help me with the code needed to find and replace any () and the numbers inside them with a blank. in other words, I want to delete them. This will probably be easy to a lot of you so I really appreciate your help.

I have a workspace set up to write into an Excel spreadsheet in Sharepoint. I am able to control the cell width in the writer parameters to a designated number.  I also want to set the cell height to auto fit because I have the text set to wrap, but some entries have a lot more text than others. When there's longer text entries some of the text gets hidden until you double click the cell. Is this possible in the FME Excel Writer? If I were to manually do it in Excel this is the step I would take.

View Data > Exercise: Customize Your Viewhttps://safe.my.trailhead.com/content/safe/modules/view-data/exercise-customize-your-viewUsed the geojson as input instead, worked out fine. 

I am very new to FME and have recently learned the basics of the software. I'm starting to apply some of this knowledge to building workflows and was curious the best way to go about reading in 200+ shapefiles to write to single feature class in a file geodatabase. They all have identical schemas so my thought was to read them in by adding the folder they're stored in, using *.shp as the dataset indicator, and using the Single Merged Feature Type option for the Workflow options. Is this the best way to do this?

I have this table of data (as an example)I will be receiving data for each object, and I want to cross check that every attribute (column) that has Yes is provided in the dataset. Please could someone advise me how to go about doing this and which transformers I should be focussing on?I was trying to maybe create a list for each object (but failing at the moment) so am a little stuck. Thank you in advance!