Solved

Backup Quickbook data to a web site via FTP

Posted on 2006-07-04
4
644 Views
Last Modified: 2013-11-29
This is somewhat of a two-part question, although the important part is the FTP question.

I want to backup QuickBooks data to a web site (or most likely a passworded sub-folder of the web site).

Can anyone recommend an FTP program where I could put an icon on a desktop, have someone click it, and that program automatically ftp the program from the computer to the web site? (Or another very, very easy way, as the person having to do the backup is not very computer literate at all).

And related to the above, is there any difference between the QuickBooks data file that you work on, and the file created when you go to QuickBooks's menu and click on "back up company."

On the second part, based on my experience, I say it is the same file, but someone else is trying to tell me the files are actually different. And it also matters as to where the FTP program will get the data to transfer and the number of steps the person doing the backup will have to go through.


Thanks,

Jay Banks



0
Comment
Question by:usurper_ii
  • 2
  • 2
4 Comments
 
LVL 2

Author Comment

by:usurper_ii
ID: 17038327
Reading my question, let be be a little clearer:

automatically ftp the program from the computer to the web site?

That part should actually read:

automatically ftp the QuickBooks data file from the computer to the web site?

Sorry.

Usurper_ii
0
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 17038351
I'm not sure the difference between files, but I see problem in backing up either via FTP.

Now, keep in mind that FTP is an UNENCRYPTED protocol and though unlikely, it would be possible for someone to steal the file by sniffing the line.  I would strongly recommend compressing the file with a good encryption/compression program.  At the least, zip it with a password.

Then for the FTP part, you can just write a script and ftp the file with that.  And why make the user do it - setup a scheduled task so it happens automatically.  The built in FTP program is easily scriptable.
0
 
LVL 95

Accepted Solution

by:
Lee W, MVP earned 250 total points
ID: 17038410
Here's a sample script:
-------------------8<--------------------
@echo off
setlocal
Set QuickBooksPath=x:\quickbooks
set mm=%date:~4,2%
set dd=%date:~7,2%
set yyyy=%date:~-4%
set hh=%time:~0,2%
set min=%time:~3,2%
if "%hh%" == " 0" Set hh=0%hh:~-1%
if "%hh%" == " 1" Set hh=0%hh:~-1%
if "%hh%" == " 2" Set hh=0%hh:~-1%
if "%hh%" == " 3" Set hh=0%hh:~-1%
if "%hh%" == " 4" Set hh=0%hh:~-1%
if "%hh%" == " 5" Set hh=0%hh:~-1%
if "%hh%" == " 6" Set hh=0%hh:~-1%
if "%hh%" == " 7" Set hh=0%hh:~-1%
if "%hh%" == " 8" Set hh=0%hh:~-1%
if "%hh%" == " 9" Set hh=0%hh:~-1%
set filename=%yyyy%%mm%%dd%.%hh%%min%.zip
Echo Executing at %time% on %date%  >> %temp%\remote.log
Echo. >> %temp%\remote.log
cd /d %QuickBooksPath%
echo zip -9 "%temp%\%filename%" "MyCompany.QBW" >> %temp%\remote.log
zip -9 "%temp%\%filename%" "MyCompany.QBW" >> %temp%\remote.log 2>>&1
If Exist "%temp%\remote.scr" del "%temp%\remote.scr"
echo username>>"%temp%\remote.scr"
echo password>>"%temp%\remote.scr"
echo cd /path/to/upload/file/to>>"%temp%\remote.scr"
echo lcd %temp%>>"%temp%\remote.scr"
echo bin>>"%temp%\remote.scr"
echo put %filename%>>"%temp%\remote.scr"
echo bye>>"%temp%\remote.scr"
cd /d %temp%
Echo  FTP Started uploading at: %time%
ftp -s:remote.scr ftp.site.com > NUL
Echo FTP Finished uploading at: %time%
If Exist "%filename%" del "%filename%"
gbmail -v -to myemail@MyCompanycorp.com -file %temp%\remote.log -from myotheremail@MyCompanycorp.com -s MyCompany-Remote-Backup -h my.smtp.server
If Exist "%temp%\remote.*" del "%temp%\remote.*"
cd %temp%
endlocal
-------------------8<--------------------
Note: this script would use a command line utility, gbmail, to email you a log of what happened.  In addition, it would use the free InfoZip command line zipping program (which does NOT have encryption abilities) to zip the file.  You should really consider using another program that is scriptable to zip and encrypt the file.
0
 
LVL 2

Author Comment

by:usurper_ii
ID: 17050629
I don't know if it is just me or what, but the first few times I ran this, it acted kind of flaky. The main thing I noticed is that it doesn't seem to log all of the things the script file is telling it to log in the log file.

That being said, however, I did manage to adapt it to a registered version of WinZip with the command line add-on that supports both password protected zip files and encryption from the command line.

Right now, I have the gbmail part commented out, but I downloaded gbmail and will play with that part later.

So far, even though I had to put a lot of time into getting it to work the way I wanted, it does seem to do what I asked for...and I can already think of useful things I can do with this script.

So I must say *thanks* for the help and I will accept your answer.

As a side note, many years ago, back when I used to have a WildCat BBS, I used to have a batch file that could zip files up by date. I lost the script over the years and never could figure out how I did it. I have been doing it now with a little DOS program I found somewhere. I'm happy to have my hands back on script that will do it straight from a batch file without having to call on another program.

Usurper_ii

0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Why APC patch cords are not recommended wirth 10GBase SFP+ Gbics? 6 71
networking details on centos 6.6 4 52
Viber-Only Restriction 6 26
EIGRP STUB 19 41
Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now