Forum Replies Created

Viewing 15 posts - 1 through 15 (of 27 total)
  • Author
    Posts
  • xkat
    Participant
    Post count: 39

    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: 39
    xkat
    Participant
    Post count: 39

    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: 39

    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: 39

    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: 39
    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: 39

    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: 39

    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: 39

    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: 39

    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: 39

    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

    xkat
    Participant
    Post count: 39

    TABBLEs are written to the TAGs collection in OFFICE documents (under INFO > Properties)
    Thus the TAGs remain with the document whether the filename or location changes: through email, for instance.
    {Scenario: you email a document to yourself from your laptop (with TABBLES) to your office computer (with a cloned TABBLES database).}
    When this ‘renamed and/or relocated’ document is opened in TABBLES, you will see the TABBLES have remained, but ONLY THOSE TABBLES that coincide in both machines’ TABBLES database.
    In other words, TAGS in OFFICE documents that are not in your TABBLES database still remain in the document, but a (new) TABBLE is NOT CREATED from the TAG name.
    ! this is as one would expect !

    xkat
    Participant
    Post count: 39

    I think “show a pop-up” is part of auto-tagging

    1) Make a new (or edit an old) Auto-tagging rule
    2) fill out whatever in “When a file is created”
    3) Choose (check) “show a popup which . . . ”
    4) Do Not Choose “put the file in tabbles: ”

    should work

    xkat
    Participant
    Post count: 39

    Thanks, Andrea
    – What is the mechanism, then, to utilize the XML export >>> import
    The format of the EXPORT XML seems to indicate that IMPORT will trigger a routine that actually overwrites the db and reinstates the exported environment.

    True?

    xkat
    Participant
    Post count: 39

    OK – maybe it works now?

    I’ve used SQL Server since version 7, but, still, please regard this ‘answer’ as slightly-educated guess (;

    all should work OK (v.2008 is fine) – assuming the bugs are worked out (don’t install on the first day it comes out) I usually use the most recent version.
    Management Studio gives you a UI to investigate/export/backup the database (I also use MS Access)
    My logic: SQL server is used in many high-end implementations world-wide – the incremental upgrades are often useful, particularly from the Management Studio standpoint, and more and more bugs are killed (unfortunately some get added, too)
    I use, presently, 64bit 2014 Express with Management Studio – what MS Downloads calls
    ( ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe )

    I make sure to use all 64bit MS products on this machine, because there are incompatibilities with mixing Office versions, in some cases, and I value having MS Access on this machine, which allows me to manipulate SQL Server databases in a familiar Office UI type environment.

    Irregular updates to SQL Server are sent out on Windows Update. It is likely that sometime after SQLSvr 2016 comes out, 2014 will get some updates rolled out.
    Personally, I will stick with 2014 in this TABBLES environment for another year, probably.

    hope that helps

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