|
infoworkz
Starting Member
USA
8 Posts |
 Posted - November 11 2016 : 20:02:11
|
I am trying to use the export feature in VP-ASP 7 in order to export shipping and order information to an excel file (would prefer csv, but don''t see the option). The objective is to export the data to be imported into the NEW Fedex software so that shipping labels can be generated from approved/completed orders.
Using the "Query & Export" utility, I have created a query to select the order info based on the orders that I want to export and the query window will return results:
SELECT orderid, odate, orderamount, ophone, oshipcost, oshipname, oshipcompany, oshipemail, oshipmethodtype, oshipaddress, oshiptown, oshipzip, oshipstate, oshipcountry FROM orders WHERE paypaltranstype = ''sale'' AND orderid IN (1617, 1616, 1615, 1614)
That query works fine, but I need to also include order information. If I write a query to include product information, I get an error "No table selected or not permitted to view this table" when I run this query or call a view:
SELECT dbo.oitems.orderid, dbo.orders.odate, dbo.orders.orderamount, dbo.orders.ophone, dbo.orders.oshipcost, dbo.orders.oshipname, dbo.orders.oshipcompany, dbo.orders.oshipemail, dbo.orders.oshipmethodtype, dbo.orders.oshipaddress, dbo.orders.oshiptown, dbo.orders.oshipzip, dbo.orders.oshipstate, dbo.orders.oshipcountry, dbo.oitems.numitems, dbo.oitems.unitprice, dbo.oitems.itemname
FROM dbo.oitems INNER JOIN dbo.orders ON dbo.oitems.orderid = dbo.orders.orderid WHERE dbo.orders.paypaltranstype = ''sale'' AND dbo.orders.orderid IN (1617, 1616, 1615, 1614)
Please help! If there are any suggestions for a query that will work, I would be very grateful.
Thanks,
|
|
|
infoworkz
Starting Member
USA
8 Posts |
Posted - November 15 2016 : 19:22:00
|
Hi Cam:
Thanks for your reply. I already see an export section in my VP-ASP 7.0, which I have the deluxe version. Does that mean that I already have the export utility, or the does the export add-on have more advanced export features? Reason that I ask is that I see that there is a "Query & Export" option and "Export Tables" under misc.
Thanks,
Darren |
 |
|
|
infoworkz
Starting Member
USA
8 Posts |
Posted - November 16 2016 : 18:31:22
|
Hi Cam:
Is it possible to just purchase the export utility? My client is not at a place to upgrade to v8 and migrate all of their customizations at this time. $399 just to access a single add-on is a little pricey when they will be upgrading in about 1.5-2 years. When the time comes for the upgrade, we want the $399 to go toward a new version, not 12 months of unneeded support for the old version 7 that is currently working fine. Could you please name a reasonable price for the export utility itself?
Thanks,
Darren |
|
|
All Forums
Shipping Export
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
