Home Page link  

Export stored BMP's (receipts) out of SQL database

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Export stored BMP's (receipts) out of SQL database Justin Janson 09-10-2007
Posted by Justin Janson on September 10, 2007, 1:48 pm
Please log in for more thread options
 Hi,

I'm looking for a possibility to export the stored transactions out of the
database. I know there are several ways to cleanup the database by deleting
old stored transactions (BMP's). Is there a way to export this to an
alternate location? Is it also possible to do this for specific accounts? And
for specific dates?

Regards,
Justin Janson

Posted by Glenn Adams [MVP - Retail Mgmt on September 10, 2007, 11:26 pm
Please log in for more thread options
 Those records are encrypted images and as far as I know MS has never
released any information that would allow them to be used outside the
Journal Viewer.

You could open them one at a time in Journal Viewer and print them to
PDF, but that's about all I can think of...

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.


Justin Janson wrote:
> Hi,
>
> I'm looking for a possibility to export the stored transactions out of the
> database. I know there are several ways to cleanup the database by deleting
> old stored transactions (BMP's). Is there a way to export this to an
> alternate location? Is it also possible to do this for specific accounts? And
> for specific dates?
>
> Regards,
> Justin Janson

Posted by Akber Alwani on September 11, 2007, 1:46 am
Please log in for more thread options
one more thing with respect to my last solution is that you can also develop
small vb program which i did for connecting to other servers. I can help you
out in this. but require info from you.

"Justin Janson" wrote:

> Hi,
>
> I'm looking for a possibility to export the stored transactions out of the
> database. I know there are several ways to cleanup the database by deleting
> old stored transactions (BMP's). Is there a way to export this to an
> alternate location? Is it also possible to do this for specific accounts? And
> for specific dates?
>
> Regards,
> Justin Janson

Similar ThreadsPosted
Error using the Export Database Wizard to export store database in March 8, 2008, 9:02 pm
Problem with HQ Export Database November 28, 2007, 4:10 pm
RMS SQL Stored Procedures January 11, 2008, 7:32 am
Journal Receipts...printing a batch of receipts September 11, 2006, 5:51 pm
Where are the sigcap signatures stored? January 12, 2007, 9:21 pm
Where is the Customer Data stored? August 11, 2007, 1:38 pm
Where is the item lookup and price stored? October 10, 2006, 12:53 pm
Are barcodes stored? List of all tables in SQL? October 13, 2006, 1:07 pm
Calling SQL stored proc from RMS .QRP report December 4, 2006, 10:51 pm
stored procedure writing directly in RMS February 15, 2007, 9:51 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap