uShop English (U.S.) for 179!

uStorekeeper English (U.S.) for 149!

 Products
       uTest
       uReserve
       uShop
       uStorekeeper
       uGolf
       uDirectory
       uSignIn
 Tech Support
       Support Policy
       Knowledge Base
            uTest
            uReserve
            uShop
            uStorekeeper
            uGolf
            uDirectory
            uSignIn
       Documentation
       Reference Sites
 Legal
       Software Piracy
       Legal Notices
       Privacy Policy
       Licensing
 Miscellaneous
       Reseller Info
       Contact Us
       Site Map
address.csv

Knowledge Base Lobby : uShop Support Conference : General Questions
Dec-16-17 08:12 AM EST
Original Message
address.csv
Author Clark Pearson on 02-20-2002 at 16:02 (EST)
I'm in the process of upgrading from uShop 2.0. I use that version to capture all addresses in a spreadsheet (address.csv). Is there a similar feature in 3.45 that allows me to record a spreadsheet file that captures that same info? Can I capture more info? Like items ordered and order total? Sorry... I just can't find this in the documentation.

Thanks!
Clark
E-MAIL AUTHOR | TABLE OF CONTENTS

Table Of Contents
  RE: address.csv Bill Weiner, 2002-02-20 20:07:16 (1)
            RE: address.csv Clark Pearson, 2002-02-20 21:00:26 (2)
                 RE: address.csv Bill Weiner, 2002-02-21 05:04:21 (3)

Messages In This Discussion
         1. RE: address.csv
        Author Bill Weiner on 02-20-2002 at 20:07 (EST)
Why YES you can! On the uShop 3.x control panel...under GENERAL SETTINGS - MISCELLANEOUS... there are two settings that relate to maintaining customer information and maintaining product information:

Maintain Customer Log: YES/NO
Maintain Inventory Log: YES/NO

If set these fields to YES, the customer and inventory information will be written in the files "ushop-customers.log" and "ushop-inventory.log", respectively.

See section 11.1.6 in the uShop 3.x User's Guide for more information about these data recording options: http://www.uburst.com/uShop/reference/users_guide.html
TABLE OF CONTENTS
                 2. RE: address.csv
                Author Clark Pearson on 02-20-2002 at 21:00 (EST)
Very cool. Did you guys not like the .csv format? I could just click on the file and open it in Excel... I can still open these new ones in Excel, it's just not nearly as slick. (Or am I missing a quick way of opening them without defining the file type and delimiter each time???)

Thanks for the info!
TABLE OF CONTENTS
                         3. RE: address.csv
                        Author Bill Weiner on 02-21-2002 at 05:04 (EST)
It may just be that Excel is not recognizing the ".log" extension. If you want to change the file names to have ".csv" extensions instead of ".log" extensions, then you can change them by modifying the:

$customer_log = $data_directory . "ushop-customers.log";
$inventory_log = $data_directory . "ushop-inventory.log";

....variable settings near the top of the "ushop-lib.pl" script.

That is:

STEP 1: Make a backup of your current "ushop-lib.pl" script... just in case.

STEP 2: Open your "ushop-lib.pl" file with any text editor such as WordPad.

STEP 3: Do a search on the following lines:

$customer_log = $data_directory . "ushop-customers.log";
$inventory_log = $data_directory . "ushop-inventory.log";

STEP 4: Change those lines to:

$customer_log = $data_directory . "ushop-customers.csv";
$inventory_log = $data_directory . "ushop-inventory.csv";

STEP 5: Save the script... as TEXT if your editor asks... and try it out!
TABLE OF CONTENTS

© 2003 Microburst Technologies, Inc.