Forum Replies Created

Viewing 15 posts - 1 through 15 (of 31 total)
  • Author
    Posts
  • xkat
    Participant
    Post count: 44
    in reply to: New version #16431

    We have just released Tabbles 6, which now supports Microsoft Azure SQL.

    In order to user this new feature, you first need to setup your Azure SQL database in the Azure admin panel. Then from the Tabbles Login window, you can use the Tabbles Azure > Create database to initialize the database in order for Tabbles to use it.

    xkat
    Participant
    Post count: 44

    sounds like pass-through of windows notification

    – might be useful to know (bug), for instance if USB/storage chipset drivers/hardware is inconsistent or failing.

    mtc

    xkat
    Participant
    Post count: 44

    sorry – (3.) not quite sure what you mean: Windows UI, voice control ?

    (4.) – in your image, any tag (up and down the tree) can be ‘clicked’ and thus applied .

    xkat
    Participant
    Post count: 44

    have you upgraded to windows 11 ? It’s possible that OneDrive might be the culprit.

    when i first installed windows 11 (upgrade from win10)  my installation had 2 “Desktop” folders (in fact, after further searching, i had 3 ! ) but, to your question, 1 of those DESKTOPs was actually OneDrive. Windows is trying to get you to sync all your files to the cloud. From the ‘Explorer’ view (the typical Windows file manager) it is not obvious that ‘DeskTop’  is  OneDrive.

    If you have OneDrive (and its root folder is named “Desktop” and you have otherwise not used OneDrive (it is turned OFF, perhaps)  i guess it would be possible that it was empty.

    If there is NO second (or third) Desktop folder in your system, then, i don’t have a clue, sorry.

    xkat
    Participant
    Post count: 44

    Is this because [machineName] is unique (and thus different) when the query is run on each unique machine?
    Maybe this is part of the Network edition, but it might be useful if [organization][name] could over-ride machinename with a ‘switch’ (SEE ALL Machines’ TABBLES) in the Interface, and thus ‘UNION’ [machinename]s in the pertinent queries.

    xkat
    Participant
    Post count: 44
    xkat
    Participant
    Post count: 44

    Hi, Maurizio — thanks for your reply
    That’s why i put all my data on a portable drive with PATH:
    A:\\AARCHIVE\… etc.
    *Note that my test machine is: “DV7” and the TABBLES database lists files from 3 machines, DV7, Giga2500K, BlueTurtle – all files were resident on the same (single disk id) portable drive, merely ‘referred to’ by different drive letters when used separately on different machines, not networked.

    the problem i experience is that the files are listed by different machinename in the TABBLES4 db and cannot be updated in the interface

    
    SELECT [id],[path],[isDir],[machineName],[idTaggable],[idOrganization]
     FROM [tabbles4].[dbo].[file2]
    
    *,A:\AARCHIVE\6\610\Inspection of foods, medicines.mht,*,DV7,*,*
    *,L:\AARCHIVE\6\614\Sanitary Inspection and control.mht,*,Giga2500K,*,*
    

    Procedure using the TABBLES interface:
    Search (Ctrl F) for “food” > several files are listed (with associated tag: Nutirition)
    (File view NORMAL, with tags, folders, thumbnails]

    
                            A:\AARCHIVE\6\610\Inspection of foods, medicines.mht
    (the 'lost' file) "-"   L:\AARCHIVE\6\614\Sanitary Inspection and control.mht 
    

    then: right-click > “Locate in windows explorer” > “Specify current location”,
    and successfully “Files Found:” > “Update the tags to point to . . . ”
    “Info – files were found and . . . ”
    Close interface; repeat search; file still shows previous location “L:\”
    and has not been updated.

    Curiously, right-clicking “Info” when hovering over ‘lost’ filename shows ‘date mod:’ and ‘size:’ are empty, but “Computer: DV7” even though the db always lists machinename: Giga2500K

    please advise

    many thanks

    xkat
    Participant
    Post count: 44

    Does Autotagging work for any condition?
    such as
    when a file is created and the file type is ‘pdf’

    ?

    My auto-tagging isn’t working either, but in the past i have had results using ‘and the file path matches the regular expression’ [you should be able to define a match condition with files having “-07” ]

    xkat
    Participant
    Post count: 44

    Levi – if you keep your OneNote notebooks/sections/pages in your local machine file system, they will tag as expected.
    Unfortunately, OneNote files don’t retain TABBLE ‘tags’ in their extended internal properties (INFO > Properties) like do WORD, EXCEL, etc.

    I keep my ONENOTEs local, and have them ‘synced’ to OneDrive, for instance.

    xkat
    Participant
    Post count: 44
    in reply to: MSSQL resources #11068

    this is a follow-up to my post in another thread: doing most tasks, including tagging, searching, Combining tabbles, etc. uses ~450MB (as Andrea notes) on the SQL Express (2014) side with 1-3% CPU spikes and another 50-250MB for TABBLES itself, with 2-15% spiking CPU utilization.

    This is with only TABBLES db running, although i run a parallel MSAccess db, linked to TABBLES db in SQLServer, that allows me to manipulate relationships and add other objects and properties to TABBLES.

    once again with ~250 tags and maybe 20000 files

    xkat
    Participant
    Post count: 44

    thanks again Andrea – local 2014 server express.
    A typical SSMS query, directly on the database, takes just a few milliseconds, and tracing most stored procedures (initiated through Tabbles UI), such as getDataToComputeSuggested or computeSuggestedTabblesAndCtsofOpenTabbles take between 60-1300ms, but the display of all the tabbles in the quick-open can take over 10 seconds. Certainly this must be a display issue, but it seems it would be ‘optimizable’ somehow. no?

    Also, please can you give me any hints as to why auto-tagging isn’t working (it works on my 2nd machine), but ‘run rules now’ works.

    xkat
    Participant
    Post count: 44

    i have a i5 desktop with AMD HD4850 and an i7 laptop with HD6700M – i hadn’t thought about video. I would guess that most legacy business-level machines have lower performing graphics chips, e.g Intel 3000/4000, etc.
    I do 3D graphics with these machines with good performance?!?
    How can i optimize for tabble display, particularly in ‘Quick-open’ pop-up?

    Also, i emailed you about the loss of auto-tag function. If i “Run rules now”, TABBLES correctly tags all the files previously saved in the auto-tag directories, but it doesn’t ‘tag’ or run “show a popup” at the time the file is added, as the rule commands. This exact same (autotag) setup runs correctly on another machine.

    please advise

    xkat
    Participant
    Post count: 44

    that’s what i assume, after finding this:
    “The way Tabbles uses the db.xml allows you to create a database structure (meaning tabbles and Color groups) that would fit your office, colleagues or friends needs, and sharing it with them. If you are a distributor or an OEM partner, you can create your unique setup and have it distributed with Tabbles.”
    in the Wiki

    xkat
    Participant
    Post count: 44

    sorry for posting such ambiguous message!
    i thought Andrea/Maurizio might (;) understand the (poorly worded) question because of previous communication.
    nonetheless, this is about the shell extension (pop-up) tagging interface.
    What i was trying to describe was the ability to cache the tabble list particularly for initial tagging (tabbling).
    Thus, I expect the Tabble list wouldn’t necessarily be ‘complete’ at all times, except when after a tabble was ‘created’, ‘deleted’, or ‘re-ordered'(change hierarchy), in the main interface.
    I don’t know how much memory this list would require, and it would ‘lazy-update’ whenever resources were available. The cache would be called when the ‘quick-tag’ was invoked.
    btw, caches seem in place at ‘recent tags’ in the pop-up tag interface “Tag” pulldown.

    ciao

    xkat
    Participant
    Post count: 44

    just noticed this post –
    i’ve loaded tabbles on several machines and have had 0 cpu/memory contention issues.
    Right now, i have Tabbles database running on a separate (home network) machine
    and with >40,000 files and >200 Tabbles i’m using <10MB memory and 2-3% CPU cycles: reported in ‘Resource Monitor’ as i manipulate (add, rename, etc.) TABBLES

    . . . the only thing that slows me down is the access to the full list of ‘nested’ tabbles when i “Expand All Children” – i’d guess that much of that is network latency

    hope that helps

Viewing 15 posts - 1 through 15 (of 31 total)