The Neat Company Forums

Welcome to The Neat Company Forums Sign in | Join | Help
in Search

Multiple Database Files

Last post 10-09-2007, 9:42 AM by jhardison. 8 replies.
Sort Posts: Previous Next
  •  05-30-2007, 10:50 AM 1322

    Multiple Database Files

    NR should offer multiple database files, instead of just one big file.  I run 2 companies beside my personal info and I would like to keep them in separate files.
    Filed under:
  •  06-16-2007, 10:42 PM 1380 in reply to 1322

    Re: Multiple Database Files

    I support this.  It would be very nice to be able to create a new database at the beginning of each year -- I would archive the previous files onto CD/DVD for later use.  This would also cut down on disk space used.
  •  09-24-2007, 9:56 AM 1904 in reply to 1380

    • Pauls is not online. Last active: 09-24-2007, 9:56 AM Pauls
    • Not Ranked
    • Joined on 09-24-2007
    • New Member

    Re: Multiple Database Files

    I have to agree with you.  After getting up and running I realized that the database is space hungry and after a year or two will be very large.  An archive option would be very useful.
  •  09-26-2007, 11:07 PM 1981 in reply to 1904

    • alornmage is not online. Last active: 03-05-2010, 1:00 AM alornmage
    • Top 10 Contributor
    • Joined on 02-26-2007
    • Greenville, NC
    • MVP

    Re: Multiple Database Files

    I run only one company, but i work for another, so I know how you feel. I got around it this way:

    I have lots of folders for personal expenses, documents, MY company receipts, OTHER company receipts, etc.

    If you're needing to track separate company's expenses, I found this an easy way to do it.

    The downside of this method is that ALL your receipts are together, which makes your NR file larger than you might want it to be at any given time, so I quarterly export all my personal receipts for that past quarter and delete them from the database. I do the same when I finish a project for a customer, relieving the burden of showing all the receipts I don't need to see right now from slowing down my computer. At the end of the year, I just import ALL the NRX files I've exported throughout the year and do all my tax prep at one time.

    This work for you? I have a write-up on here somewhere detailing the process if you would find it helpful.

    PS: Although I would love the quickbooks style method of opening and closing specific companies, I don't see that happening any time soon.



    Regards,

    Tommy Jordan
    3rd & Wayne, IT Services
    www.twnetworx.com
  •  10-05-2007, 10:10 AM 2071 in reply to 1322

    Re: Multiple Database Files

    yes...yes... YES!!!!!

     Multiple database files is a must. Like some others, I keep my pesonal and home business expenses separate. I keep separate logins on my computer so no mail, documents or anything gets mixed up between personal and work. It would REALLY be nice to be able to log into NR under the separate profiles and actually see the related database, not the combined data as it is now....

     Please do this!!!!!

  •  10-05-2007, 3:04 PM 2074 in reply to 2071

    Re: Multiple Database Files

    Again yes...

     Might have to do a petitiononline..... I hear those are very effective (<.03%) Big Smile

  •  10-05-2007, 3:50 PM 2075 in reply to 2074

    Re: Multiple Database Files

    I'm trying out a solution now and will let you know how it works.

     I downloaded Microsoft VirtualPC 2007 (it's free) and created a virtual WinXP machine for each of my user profiles and installed NR in the virtual machine for each also. I set it up so that the NR program starts automatically when I start the virtual PC in a single click. Now I have separate databases for each of my profiles.

     

  •  10-08-2007, 7:17 PM 2106 in reply to 2075

    Re: Multiple Database Files

    Well the VirtualPC 2007 application from Microsoft works GREAT. I'm running Vista but created a virtual WinXP unit and installed the NR program into it. I then copied the virtualPC to each of my profiles. Under each profile I started the virtualPC/neat receipts and imported the data. Works great and is actually faster than running NR directly on the host machine. When you close the virtualPC it actually saves the last state just like doing a suspend mode. If you left NR open in the virtualpc it starts back up in just a second or two. Not the forever time it seems on a normal install....

     There is one little problem with this method though.... Microsoft Virtual PC 2007 does NOT have USB support in it. No way to scan the receipts. DOH!!!!!!

     I found and downloaded Virtualbox which does the same thing but does have USB support. Trying it out now and will provide feedback....

  •  10-09-2007, 9:42 AM 2112 in reply to 2106

    Re: Multiple Database Files

    VirtualBox will run it, and will work with the USB Scanner. However when I tested it on the host OS of Windows Vista x64, the virtual usb driver it installs causes the host system to crash. Just a little fyi for ya.Big Smile

     

    Cheers,

     

     


    -Jonathan Hardison-
View as RSS news feed in XML