pricelist export to excel

to ms excel

2005-03-17 00:33

Does anyone have or can anyone write an simple script that list all articlenumbers+name+price in a list to open in Excel.

I need it for an school examination company where I am a trainee now. And my php/sql and english (;P) are very bad.

On this way:
ART NR --- ART NAME --- ART PRICE --- VAT --- IMPORT PRICE -- VAT

or something like this.

Thank in advance.

The Netherlands

Wizzud

2005-03-17 10:45

Start Excel.
File Open products.php
Set Delimited, Start at line 2, file origin depends on where you are but you can experiment if you want
Next
Set the delimiter to Other and specify $
Next
Change the column data format if you want; skip any columns you don't want
Finish

allberto

2005-10-29 07:52

I can't find "Set Delimited" :)
Could u help me? :)

Jonny

2005-11-02 01:31

In Excel ->

Either just open db\products.php and the wizard (which includes the delimit function) will appear.

Or select import from the data menu, and then pick products.php

Jonny

more applause for the dev's

Tata55

2014-04-28 18:19

What is the encoding (or where to set it up)? When importing the CSV file into excell, the encoding is unreadable. Eastern characters are wrongly encoded.

Tata

wewior (OpenSolution)

2014-04-29 07:20

Script works default in UTF-8 so I think you should use UTF-8.

Tata55

2014-04-30 15:20

Well, on the webpage everything works well. But importing the exported CSV file into Excell makes it unreadable because of EE characters. I have tried to change any available encoding. Results are always bad. Under UTF-8 or any other encoding the EE characters are wrong.

Tata

boboo

2014-04-30 19:37

1.Save the exported file as a csv on the local disc
2.Open Excel
3.Import the data using: Data-->Import External Data --> Import Data
4.Select the file type of "csv" and browse to your file
5.In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
6.Set correct Delimiter (comma, semicolon)
7.Select where to import to and Finish

boboo

Tata55

2014-05-02 08:28

Didn't help. I tried all possible encodings for the File_Origin (btw. there is no 65001 UTF there available). And I also tried to use any excel available encoding. Still the texts in exported file are wrong.
The exported file is downloadable here: http://cmsimple.sk/sk_export_2014-04-25.csv
I use iMAC with MS Office 2011. But the problem is the same on Windows machine also in MSO 2007 and 2010

Tata

boboo

2014-05-02 10:30

send me a part of this csv file
boboo(at)kimla.de

boboo

boboo

2014-05-02 11:42

upps, i didn't see the link to the file.
but it works, as i have described
http://www.kimla.de/bilder/opensolution/excel_utf.png

boboo

Tata55

2014-05-03 00:42

Well. As I wrote above, I work with iMAC and there is no "5.In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier) " available. Also, I have found in other forums a hint how to try it. But it seems to be a little complicated:
1. Open the CSV file in TextWrangler, save it as UTF-8 and then import it to Excel.
2. Open the file in Windows notepad, copz it and paste into Excell, then use the function to split the text to columns.

Tata

Tata55

2016-08-29 16:32

Anyway, after some ex/imports I have found another problem in "Price". If the price is >12, the number is exported as datum (e.g. 12.25 is exported as dec.25). How to correct this?