[topbraid-users] Request garbage collection

2020-08-04 Thread MSV
Hi, We have our daily swp which loads data from various sources into edge. During this time my system memory is filled up and we manually do the request garbage collection. Do we have swp module to do this programatically?? We are using 6.3 version of edge -- You received this message because

Re: [topbraid-users] Request garbage collection

2020-08-04 Thread Richard Cyganiak
> On 4 Aug 2020, at 09:03, MSV wrote: > > We have our daily swp which loads data from various sources into edge. During > this time my system memory is filled up and we manually do the request > garbage collection. > Do we have swp module to do this programatically?? There is no SWP module

Re: [topbraid-users] Request garbage collection

2020-08-04 Thread MSV
thanks richard -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com. To view this discussion on the web visit htt

Re: [topbraid-users] ISSUE: XLSX Importer Fails when columns have no header

2020-08-04 Thread dprice
Hi Tim, You’re doing something that is not supported by EDG out-of-the-box. The EDG SS importers requires headers that are mapped to properties of the selected class into which to map each row. The fact that the import SS by pattern pops up with “Spreadsheet columns” and “Target Property” is a

Re: [topbraid-users] ISSUE: XLSX Importer Fails when columns have no header

2020-08-04 Thread Tim Smith
Hi David, Actually, I don't use EDG for SS import at all. It is too limiting, especially when the need is repetitive. Thus I'm using TBC directly and I would have expected TBC to properly handle spreadsheets with missing column headers. I am writing my own construct queries and will use SWP or

Re: [topbraid-users] ISSUE: XLSX Importer Fails when columns have no header

2020-08-04 Thread dprice
Apologies Tim … I didn’t look closely enough at your screenshots. > On 4 Aug 2020, at 21:30, Tim Smith wrote: > > Hi David, > > Actually, I don't use EDG for SS import at all. It is too limiting, > especially when the need is repetitive. Thus I'm using TBC directly and I > would have expect

Re: [topbraid-users] ISSUE: XLSX Importer Fails when columns have no header

2020-08-04 Thread Irene Polikoff
Importer will always look for some value in each column of the first row and will use it as the column name. If it does not find values in the first row, then it will try to find the next available row with all values. This is to accommodate situations where a first row(s) may be empty. It wil

Re: [topbraid-users] ISSUE: XLSX Importer Fails when columns have no header

2020-08-04 Thread Irene Polikoff
If you are using ‘Semantic Tables’ importer in TBC, it will always look for some value in each column of the first row and will use it as the column name. If it does not find values in the first row, then it will try to find the next available row with all values. This is to accommodate situati

Re: [topbraid-users] ISSUE: XLSX Importer Fails when columns have no header

2020-08-04 Thread Tim Smith
Hi Irene, With that explanation, the performance makes sense. This is certainly an edge case. Unfortunately the spreadsheets are provided by a large automation vendor and are a standard part of their documentation. IMHO, it's rather irresponsible to publish them without proper column headers bu