Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Utility to export and/or report from .dbf table 1

Status
Not open for further replies.

CatPlus

Technical User
Jan 30, 2003
236
Hello,

Can you recommend a utility that will allow saving a query and then run that query in the future with filters.

For instance, I would enter an invoice number range and it would print a formatted invoice to file, pdf or e-mail?

The utility would also import a .csv file into the .dbf file

Thanks
Mickey Shekdar
 
Not knowing details, but Dbase tables can be read, written to, and reported on using nearly anything these days.

Do you have Microsoft Access? It has report built right into it, can read text and read / write to dbf files.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
 
Thanks Blorf (ChaZ)!

I am using an accounting package with dBase IV as its back-end engine.

I want to identify a utility that will allow me to:

[a] Import a .CSV file into the .DBF file
Find and replace field values of .DBF files
[c] Export from .DBF to .CSV
[d] Print formatted reports

must have data-entry input... for example:
table:'A', field:'B', find and replace value:'x' to value:'y'... and ideally, a command line input!

[c] must have data-entry input... for example:
export to c:\customer.csv from table:'a', with field:'b' = 'NY'

[d] print a report to (a) file, (b) PDF driver or (c) e-mail invoice with invoice number:'3498'

Is this doable using Access? or is there a utility that does all that you are aware of?

Thanks
Mickey



 
Access will do all of this, with exception to dealing with memo fields.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
 
Hello Blorf (ChaZ)!

Your reply is so very valuable and I appreciate the time you have taken in responding!

Wishing you success!

With season's greetings!
Mickey Shekdar
ms@catplus.com
 
No problem. Glad to help.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
 
Hello again ChaZ,

The database I am using is a flavor of dBASE IV with DBT memo type and MDX index type.

Will ACCESS be suitable for use for my purposes?

Thanks
Mickey Shekdar
ms@catplus.com
 
Sadly, I can not seem to write to a memo type at all with Access, however, the MDX index format is supported.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
 
Hi ChaZ

Appreciate your response...

Since import and/up of records will never include a memo field, do you think I could still use Access?

To explain my post of 06:59 hours today:
[a] Import a .CSV file into the .DBF file
Find and replace field values of .DBF files
[c] Export from .DBF to .CSV
[d] Print formatted reports

EXAMPLE [a]: New Customer is added to the web shopping cart and an order is taken. I will generate 2 files, Customer.csv and Orders.csv. Customer.csv will add or update customer account in table customer.dbf. All items ordered by the customer will be added to Orders.dbf. There are no notes or does it matter if Access cannot write a DBT memo type?

EXAMPLE : Sales Tax in some counties are exempted for a certain period of time during the year. For instance, NY State will charge no sales tax on apparel or shoes valued $110.00 or less between 01/10/2006 and 01/31/2006. I would create a new tax code, say NY0106. All Customers with tax code NY2006 will be changed to NY0106 on 01/10/2006 and changed back to NY2006 on 02/01/2006. Again, no DBT memo type has any impact.

EXAMPLE [c]: I need to export Customer order history, so my filter would read.

Customer:xyz
Order date 10/01/2005 to 12/12/2005

from the Order_h.DBF, I will get all records matching the filetr exported out to the .CSV file

EXAMPLE [d]:
Customer 'xyz' wants a copy of all orders shipped from 07/01/2005 to 09/30/2005.

My filter would read:
Customer :'xyz'
Ship date:07/01/2005 to 09/30/2005 and from Order_h.DBF (header) and Order_i.dbf (items) I reprint all invoices

No memo fields come to play in any of the examples...

Is ACCESS my answer?

Thank you for all the help!

Regards
Mickey Shekdar
ms@catplus.com
 
If you have access already, I would think it is the answer. If you do not, then I would look around first, but yes, I would use Access for this. I am a bit biased though, since I work daily with access and I am farily familiar with it and how to use it.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
 
Hey Chaz:

I thank you very much!

Happy holidays

Mickey Shekdar
ms@catplus.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top