Open your Word documentĪction: Start by opening the Microsoft Word document that contains the data you need to convert. I would recommend taking a look at this article on Sending Emails from Automations as it may helpģ.Converting a Word file into an Excel sheet can significantly enhance data analysis and presentation.įollow these steps to ensure a smooth transition, whether you’re working within the Microsoft ecosystem or considering using MS Office alternatives. I also recommend taking a look at this article on change detection using FME for some other options.ģ. I agree with that the ChangeDetector should work for your purposes. Note: working with PDF tables and paragraph text can be difficult so I wouldn't say PDF output would be an advantage.Ģ. I have attached an example workspace which uses a base file where the margins have been narrowed, font size and colour changed in several styles, and the Table Grid table style was modified to have a grey background for the header row in addition to font changes. You can also modify Table Styles to control font and formatting of a table style. You can view the list of table styles by opening a Word file that contains a table created by FME and going to Table Tools > Design tab > Table Styles (see screenshot). For example, you can change margins and modify the look of MS Word Styles in the base file and these changes will be reflected in the output Word document when the base file is used within the MS Word writer. Hi I would recommend using a base file for greater control over formatting in the output Word file. Made significant progress since I posted originally but there is still plenty to improve on. I know it's a lot to ask/hope for, but I'd rather try than just give up. Sample report which was going to be possible with another tool: Sample report as basis for improvement of tables: I plan to add an input field for 1-3 email addresses and use those to define where the reports are sent. I just need to work my way through adding attachments to emails. FME Automation to email the results - I know it will be possible and my FME Server is set up to email.Only just starting on this bit but any inputs from anyone with comparable experience would be appreciated. At each run of the report generation tool, I write the data into a DB table, so that could be used to compare states of the data. Comparing the content of the JSON exports to the last export to see if anything (and preferably what fields) has changed.Is there a way of defining the margins used in the output word file?Īny way of controlling the font in a table and any documentation on what on earth the long list of different sytles actually look like? I would need to be able to produce a report for each of about 200 countries at regular intervals as the content changes (data is to be entered in SharePoint, I read in a JSON file exported from there).ĭoes anyone have experience with making something decent with this styler/writer? I have a rough version with the required content but even after asking Safe on the live chat last night, I couldn't get hold of any samples which I could work with to get nicely formatted output. Formatting a report output in MS Word using the MSWordStyler and including all attributes.Schedule: this bit is fun - need to have it ready to prove it can do it on Monday! No risk, no fun.GIS: The whole lot is also to be visualised in web GIS - but that is sorted :-).Data entered is to be generated into a Word file (Word preferred but I guess PDF might be accepted) and automatically emailed back to the office (if status = submitted and ideally only if any of content has changed since last submit). JSON export from SharePoint is input for reporting (and mapping).Data entered by our offices abroad in SharePoint. So as was suggested on the Safe Live Chat yesterday, I want to see if anyone out there is prepared to help me with various bits. I know FME Server can do the job, I just don't have all the knowledge (or time to hunt for clues) required. Of course this whole issue surfaced at 4.50pm on a Friday. Unfortunately, despite moving heaven and earth in a very short time, it looks like failing at the very last step as the standard reporting tool used in our institution seems to have some kind of bug and can't take the heat. This was set to be revolutionary for a world where hundreds of emails and a parallel universe of excel files are as "digital" as many feel at home with. I'm hoping some of you in confinement have time to help me out in my battle with a major COVID-19 project involving most of our organisation and representations abroad.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |