| Author |
 Topic  |
|
|
Sharon
VP-CART Super User
357 Posts |
 Posted - November 13 2014 : 12:20:41
|
| I am downloading my exported data to Excel but it is an .asp file. I''m sure this used to work & download a csv file. Has something happened here? |
|
|
carfin
VP-CART Expert
United Kingdom
948 Posts |
Posted - November 14 2014 : 10:58:29
|
Hi Sharon,
yes they seem to have changed the format for export in V7. Insead of saving the export file I just open it and then save it as an Excel file on the local machine.
Regards,
Carrol
www.deanston-electrical.co.uk |
 |
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - November 15 2014 : 03:42:11
|
yes me too here, i think that carfin idea is much better and it works for me.
diego. |
|
|
|
Sharon
VP-CART Super User
357 Posts |
Posted - November 17 2014 : 03:48:33
|
Thanks guys but there is a problem with this method.
If this was downloaded as a delimited txt file & then opened in Excel it would treat the data properly, putting each field in a separate single cell.
If you save the asp file as an Excel file you do not have the delimiters coming into play & you end with data being put into merged cells. If you then want to sort this data, you can''t because of the merged cells.
I intended to use this to put product matching into place for over 4,500 products. If I had not noticed the merged cells & used this file to re-import the products I think I would have lost a lot of data.
This is no criticism of your helpful idea, just a warning that an asp file saved as an Excel one will not be the same as a delimited text or csv file. |
Edited by - Sharon on November 17 2014 04:16:07 |
|
|
|
carfin
VP-CART Expert
United Kingdom
948 Posts |
Posted - November 17 2014 : 07:33:34
|
Hi Sharon,
that''s weird, the excel files that I save do have each field in a separate cell and once you edit your data and get rid of the query information in the first few rows, I can save it as a .csv file for uploading without any problems. I''m using Firefox as the browser and MS Excel 2010 to open the export query file.
Regards,
Carrol
www.desnaton-electrical.co.uk
|
|
|
|
Sharon
VP-CART Super User
357 Posts |
Posted - November 17 2014 : 07:50:16
|
Hi Carrol,
I''m using Chrome & Excel 2010. I downloaded the file, opened it (Dreamweaver) & saved it as a .xls file.
It may be my data, as I noticed the split occurred where I have a <br /> in for example the cdescription field. As the file opens without gridlines I didn''t actually notice the merged cells until I tried to sort the data.
It would be easier if the software does as it says & downloads to Excel, like the Export Tables does. I''m sure it used to. I''ve raised this with support & their response was to use Export Tables, which doesn''t have the query functionality. I have now mentioned the problem with the merged cells, so maybe they''ll look at it & get it producing a text file with de-limiters. |
|
|
|
carfin
VP-CART Expert
United Kingdom
948 Posts |
Posted - November 17 2014 : 08:03:39
|
You''re right Sharon. I don''t think I''ve ever exported the extended descriptions of any products (we have logo images, tables and all sorts included in that field) so I just tried and yes, any table or <br /> tags cause problems. Hopefully the tech support guys can put it back the way it was.
Regards,
Carrol |
|
|
|
Sharon
VP-CART Super User
357 Posts |
Posted - November 17 2014 : 08:06:18
|
I''m glad it''s not just me. I could get round it as I''m an advanced Excel user, compared to an amateur with asp, but if the download was the correct file type I wouldn''t need to.
Hopefully support will respond & sort it out for us. |
|
|
|
support
Administrator
4679 Posts |
Posted - November 17 2014 : 22:32:14
|
I have been playing with this feature since seeing this thread and can see a heap of areas where it can be improved.
I have made a list for next version which I will list below. If you have any you can think of to add to this let me know.
1. When you save a query it also saves the fields selected. But these are ignored when you retrieve a query and you instead have to re-the fields to display. Should remember and sue previous selections. It works on the Query export page but not in shopa_editdisplay.asp when you pull up a presaved query.
2. When you do an export only allows export of file as EXCEL and not giving a choice of file formats such as CSV, TEXT or Excel.
3. When exporting file the file name should be the table selected and the date.
4. When you choose to Run Query there is no option on the results page to export.
Should be a button here with a pop up asking what file format wanted and export.
5. When you run a query you cannot go back and modify your query. You basically need to recreate the query after running it each time.
The query field is empty and the table selection is still there but all of the fields are missing.
6. When running query you do not have a choice of how many records are shown
7. Have no option on what field to sort by
8. When you run the query and there are no results the query section still displays. This is how it should be for when we have results so merchant can fine tune results without having to click back button. Query section should be at top of the page and the result below.
More features suggested for this.
9. http://www.vpasp.com/virtprog/vpaspforum/topic.asp?TOPIC_ID=15518
Erik has suggested allowing the default view of shopa_editdisplay.asp be controlled by config options.
10. He has also added some options for the export set up which I think will be valuable additions.
Please review the Forum post above.
11. When exporting records our system MUST be smart enough not to break with line breaks. When exporting the short or long description fields the export file generally breaks as a result of the line breaks.
We need to factor this in so it does not happen.
12. The file exported needs to be in a useable format without needing modification.
Let me know if anything else you can think of for the Query and Export page.
Thanks!
Cam Flanigan
VPASP Support |
|
|
|
Sharon
VP-CART Super User
357 Posts |
Posted - November 18 2014 : 05:15:29
|
If the above is in v8 that will be great.
But............. when will it be out? |
|
|
|
Sharon
VP-CART Super User
357 Posts |
Posted - November 24 2014 : 10:19:09
|
The plot thickens.
IE offers 3 options of what to do with a .xls file.
Chrome just downloads a .asp file.
|
|
|
|
Sharon
VP-CART Super User
357 Posts |
Posted - November 26 2014 : 09:13:30
|
| Support have sorted it. Chrome will now download an Excel .xls file without merged cells. Good stuff :-) |
Edited by - Sharon on November 26 2014 09:13:59 |
|
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - January 09 2015 : 20:10:34
|
sharon, how to solve that issue ? are u able to provide me what their support worked for u?
thx |
|
|
|
Sharon
VP-CART Super User
357 Posts |
Posted - January 12 2015 : 03:39:45
|
Hi Diego,
Support made changes to shopa_query.asp.
Having looked at it & the back-up in WinMerge, I''m not experienced enough to tell exactly what changes they made as there seem to be quite a few differences & none are commented referring to my problem.
I uploaded the latest version of shopa_query.asp to another of my sites & the change worked great there too. I am happy to send you the file, if you are happy to put an email address on a public forum.
Or.......... may be support would care to comment? |
|
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - January 12 2015 : 22:21:24
|
sharon, yes i like you send me to updated file to my work email [email protected] and i will apply to my site.
diego. |
|
|
|
Sharon
VP-CART Super User
357 Posts |
Posted - January 13 2015 : 06:10:15
|
| It''s on it''s way to you Diego. |
|
|
|
Topic |
|
All Forums
Query & Export
New Topic
Printer Friendly
TrustGuard - PCI Security Scanner
