forums.auctionflex.com

Is it possible to get a list of the Reportsour's that define where the custom reports appear in flex like EventCheckOut = Check Out, CO = Consignor Order, Invoice = Invoice.

Could I get an example of how to export images? I'm creating a report very similar to the Auction Export that's already built in though I don't know how to export lot web images in the same directory as the csv file or even export images at all.

I read that FoxPro can use SQL commands like SQLCONNECT(), SELECT, INSERT and so on. Is it possible to run these commands from a custom report to interact to a remote SQL DB? My intentions are only to extract data from flex to another DB never to edit flex's DB. You know like upload inventory listing to our website's DB.

This would help a lot I'm already working on a list variable names, functions and operators for my reference. Thanks guys.

Here are the Repourt Source designations when creating custom reports. These are case-sensitive:
AltBid = Alternate Bid Maintenance
Buyer = Customer Maintenance
BuyerDeposit = Customer Deposit Maintenance
Check = Consignor Check Printing
CO = Consignment Order
COPAY = Consignor Payment Maintenance
Event = Auction Maintenance
EventBid = Clerking Activity Maintenance
EventBuyers = Auction Checkin
EventCheckout = Auction Checkout
EventLot = Auction Lots & Preview
Invoice = Invoice Maintenance
Item = Inventory Maintenance

To export images you just need to combine the relative path in pictures.picture_loc with the path to your images (typically x:\images).
So if pictures.picture_loc says _13B0PB8K1.jpg then the entire path is x:\images\_13B0PB8K1.jpg
if pictures.picture_loc says 1\_13B0PB8K1.jpg
then the full path is x:\images\1\_13B0PB8K1.jpg

So then you just copy (lcImageFileNameWithPath) to (lcDestinationImageFileNameWithPath)

Yes, you can connect to a remote database from within a report for automation purposes.

Thank you so much Brandon.