+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Sending data to Capita in Technical; Hi All, I've made an .exe that will send your data to Capita, it's nice and simple too. For anyone ...
  1. #1

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,446
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160

    Sending data to Capita

    Hi All,

    I've made an .exe that will send your data to Capita, it's nice and simple too.

    For anyone worried about security, it backups your database (using dbAttach - keeps Capita happy), zips it, encrypts is (AES-256 - keeps Becta etc happy) which WinZip can open (keeps Capita happy), and then has the option to SFTP to Capita (keeps the Eco people happy) failing that you can burn the zip onto a CD\DVD then post it to Capita. It autogens a secure random password too.

    The msi currently stands at about 1.4MB, the actual .exe is around the 700KB mark. It's a single .exe written entirely in C# it does require .net Framework 2 (I could get rid of the depend bits, but it saves on space and time - plus you need 2 for SIMS anyway).

    It currently backs up SIMS database, FMS database, and DMS folder. I might add the SIMS directory, but I've yet to hear of Capita asking for it.

    The current build as of writing is 0.0.3.

    You can download it from:

    download | Matt40k

    I'm still working on it, so feedback is aways good.

    Regards,

  2. Thanks to matt40k from:

    Oops_my_bad (4th April 2009)

  3. #2

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    Saw that on supportnet earlier, sounds good!

  4. Thanks to Steve_T from:

    matt40k (3rd April 2009)

  5. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,446
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Thanks, I've had a few people ask about security etc and proving what it does.

    For those non-coders, or people without the sourcecode.

    For this example I recommend a closed network (NAT or VM or whatever) you can use any network, it just adds work.

    The msi can be broken down and provide it only have 1 regkey, 1 .exe, 1 mmc. Again, if you're not ok opening msi, you can get software the snapshots your pc before and after running the software.

    As for what the actual exe does,

    Start wireshark (or such), it's also good to have all your HTTP traffic going though a proxy to confirm (it's easier).

    Run the .exe, it'll create a HTTP request to matt40k to confirm it's running the latest version.

    Once you enter your details, if it's SQL, it will create a connection to the MSSQL database then close. Nothing more, you can turn on advance logging on MSSQL to confirm this.

    Finally, once it's got all the information, it'll backup the SQL database (assuming it's been selected) - using DBattach. (with /path etc), then it'll use the Zip library to compress and encrypt using an autogen password. If you haven't selected SFTP, you'll need to copy it to DVD\CD\whatever and send, you can check the security of the ZIP using WinZip\WinRar (I think it supports AES256)\7Zip.

    If SFTP is selected, then (previous versions) would try and auto email Capita will the case ref and autogen password, I've now removed this in 0.0.3. Now it will, like no-SFTP, prompt the user with the autogen password.

    You can confirm the SFTP bit with WireShark (or such).

    Hope that helps.

  6. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,784
    Thank Post
    715
    Thanked 1,439 Times in 1,192 Posts
    Rep Power
    359

    Thumbs up

    Looks like a really good tool.

    My problem is that when we make a backup the zip file is close to a Gig. Sending that via FTP on
    our internet connection always fails.

    We can't even manage 300MB files, so we have to break the zip into ten 100MB chunks.

    It would be nice if we didn't need to do this task so often that we need a tool to make it easier! I've needed to send data 3 times in the last 4-6 weeks.

    Keep up the good work. :O)

  7. Thanks to vikpaw from:

    matt40k (3rd April 2009)

  8. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,446
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Thanks vikpaw, I've been at a few schools with such flaky internet connections. Thus the idea of allow to manually send.

    I'll look at seing if I could split the zip up into multiple chunks as I think that would be much better.

  9. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,784
    Thank Post
    715
    Thanked 1,439 Times in 1,192 Posts
    Rep Power
    359
    My NM uses WinRAR when we need to do that.
    Adding it as an option where you can choose the chunk size would be really handy.

  10. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,446
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Just been working on 0.0.5 today. I've add a few bug fixes. I've also looked a few new features. I did look at splitting the zip into chunks vikpaw, seems pretty straight forward. Not sure if I'll be able to fit it in by 0.0.5 tho.

    Just hope my desktop doesn't give up the ghost!!

  11. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,446
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    bump.

    Just got a new zip library, well I'm demo'ing it. Supports splitting zips, which Winrar\WinZip can open.

    Seems to work quite nice. Just need to find the money to buy a license

  12. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,446
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Bump.

    It's moved over to CodePlex - dbSend - Home

  13. #10

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,250
    Thank Post
    404
    Thanked 630 Times in 575 Posts
    Rep Power
    185
    Quote Originally Posted by matt40k View Post
    Bump.

    It's moved over to CodePlex - dbSend - Home
    Blocked here by EMBC.

  14. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,446
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 27th July 2010, 02:12 PM
  2. Replies: 2
    Last Post: 23rd April 2010, 11:50 AM
  3. Send data to C++ app
    By Jackd in forum Coding
    Replies: 12
    Last Post: 29th August 2008, 02:26 PM
  4. Sending files to Capita via FTP (or not).
    By Heebeejeebee in forum MIS Systems
    Replies: 18
    Last Post: 22nd November 2007, 11:30 AM
  5. Importing data to Active Directory
    By fooby in forum Wireless Networks
    Replies: 3
    Last Post: 16th February 2006, 05:08 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •