Re: Writing 4D Data into an Excel Template
Ron As Pat said Robs plug-in is the go to solution for anything excel On Thu, Aug 13, 2020 at 8:24 PM Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi Pat, > > > > Thanks for the mail. Yes, I had written to Rob himself for his opinion > too. > > > > I’m quite sure his plugin would be of great help in this project and have > included it as part of the proposal to the client. > > Thanks again. > > > > Regards, > > Ronnie > > Tarawerkz > > > > > > > > > > ** > > 4D Internet Users Group (4D iNUG) > > New Forum: https://discuss.4D.com > > Archive: http://lists.4d.com/archives.html > > Options: https://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > > ** -- * Randy Engle 415.250.9111 randy.en...@gmail.com * ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Writing 4D Data into an Excel Template
Hi Pat, Thanks for the mail. Yes, I had written to Rob himself for his opinion too. I’m quite sure his plugin would be of great help in this project and have included it as part of the proposal to the client. Thanks again. Regards, Ronnie Tarawerkz ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Writing 4D Data into an Excel Template
Ronnie, The go-to Excel creation solution for 4D is Pluggers' XL Plugin: https://www.pluggers.nl/product/xl-plugin/ On Thu, 13 Aug 2020 at 03:16, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi, > > I would like to ask if anyone is aware of a plugin or utility that can > quickly turnaround an export function where data from a 4Dv17.2 database > (Windows Server) > gets written directly into different worksheets inside ONE Excel document > template? > > The 2nd challenge is to identify the row-ID for each record and store it > on other worksheets in the Excel template every time the same record is > referenced. > Say for example, the first worksheet is titled “General” and contains > customer records and the starting row for the first customer record is row > 5. Subsequent worksheets would bear a row-ID column such that reference to > the same customer record would now be populated with “5” as the row-ID. > How can we identify this row-ID whilst populating the spreadsheet with a 4D > data export on the fly? > > Any pointers would be greatly appreciated. Thanks. > > Regards, > Ronnie > Tarawerkz > > > ** > 4D Internet Users Group (4D iNUG) > New Forum: https://discuss.4D.com > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky * ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Writing 4D Data into an Excel Template
Hi, I would like to ask if anyone is aware of a plugin or utility that can quickly turnaround an export function where data from a 4Dv17.2 database (Windows Server) gets written directly into different worksheets inside ONE Excel document template? The 2nd challenge is to identify the row-ID for each record and store it on other worksheets in the Excel template every time the same record is referenced. Say for example, the first worksheet is titled “General” and contains customer records and the starting row for the first customer record is row 5. Subsequent worksheets would bear a row-ID column such that reference to the same customer record would now be populated with “5” as the row-ID. How can we identify this row-ID whilst populating the spreadsheet with a 4D data export on the fly? Any pointers would be greatly appreciated. Thanks. Regards, Ronnie Tarawerkz ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **