Author |
Topic |
|
grahamcrackerscomics.com
Starting Member
USA
43 Posts |
Posted - February 07 2008 : 07:51:32
|
Hi - I'm running version 5.5 with a MYSQL database, and I need to export a paticular category into EXCEL so I can manipulate/print some lists off it. The problem I'm running into is that the HTML code in the extended descriptions end up screwing up the .csv file and I don't have even columns like I need. The problem occurs when I export through VP-ASP Product module and when I use PHP to access the datbase directly. Anyone have any suggestions on exporting the data in a 'clean' format that will keep everything in it's proper fields?
thanks
--John Robinson www.grahamcrackerscomics.com |
|
grahamcrackerscomics.com
Starting Member
USA
43 Posts |
Posted - November 03 2008 : 20:45:57
|
Can anyone help with this? I cannot export my products database, and I REALLY need to be able to.
I've tried PHPMYADMIN but it always leaves some fields out.
I've tried the regular EXPORT feature (vp-asp 5.5 mysql) and nothing ever happens. I set permissions for writing a file on the main directory, and still no luck. I've tried pointing it to the other directories d:/inetpub/etc.etc. but perhaps I'm pointing it wrong. Does anyone back up their products database on a regular basis that can be of some help? I was hoping to import the file in excel to do some manual inventory checks...
thanks much
--John Robinson www.grahamcrackerscomics.com |
|
|
carfin
VP-CART Expert
United Kingdom
948 Posts |
Posted - November 06 2008 : 04:17:51
|
Hi,
have you tried using ftp to download your whole database directly to your local machine (inetpub directory)? You can then access it directly to export the tables as necessary. I suppose it depends on the size of your database whether this is an option. Unfortunately I can't be more help because I use an Access db for about 6,000 products and back it up every second day with no problems.
Regards,
Carrol www.deanston-electrical.co.uk |
|
|
grahamcrackerscomics.com
Starting Member
USA
43 Posts |
Posted - November 10 2008 : 11:55:02
|
Thanks for the tip Carroll - I haven't figured out how to ftp into the d:/inetpub directory but will look into that. While I can export SOME records out from VP-ASP 5.5 by using the export feature (smaller categories that only have aprox. 3,000 items export out just fine) - But my largest category (comics) has over 60,000 items and I get an error message every time:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/shopping/shopa_export.asp, line 150
Line 150 on version 5.5 is this:
Sub FormatRecord dim whatever dim fieldvalue Dim Msg Fieldcount=0 msg="" for each whatever in rsTable.fields fieldvalue=whatever.value <-- LINE 150 if isnull(fieldvalue) then Fieldvalue="" end if if Fieldcount=0 and ExportIdField="NO" then else If msg<>"" then msg=msg & exportdelimiter & quote & fieldvalue & quote else msg = quote & fieldvalue & quote end if end if fieldcount=Fieldcount+1 next WriteLine msg end sub
If anyone has any idea why it's failing (too large?) please give a shout back...
thanks
--John Robinson www.grahamcrackerscomics.com |
|
|
|
Topic |
|