Chat Room Article Base Facebook Page Twitter RSS Feed
Welcome, Guest. Please login or register.
Did you miss your activation email?
May 23, 2012, 08:57:47 PM

Login with username, password and session length
Search:     Advanced search
The E-commerce forum, the best place for advice for your Small Business.
12789 Posts in 1519 Topics by 6457 Members
Latest Member: DuCialisFr
* Home Help Search Login Register
+  E-commerce forum
|-+  E-commerce
| |-+  Shopping cart software
| | |-+  Zen cart
| | | |-+  Creating CSV files
« previous next »
Pages: [1] Print
Author Topic: Creating CSV files  (Read 695 times)
teenymunchkins
Liking it Here
***

Karma: 2
Offline Offline

Gender: Female
Posts: 119



WWW
« on: March 17, 2010, 08:30:18 AM »

Hi

I have been asked if I can produce a CSV file when I open up the dropship site.  Was going to have a play this morning but I don't know how to do it ... can someone point me in the right direction?  I have looked in easy populate but there is nothing there that says .csv files  whistle

Thanks  :D

Alison
Logged

sgd
Newbie
*

Karma: 1
Online Online

Gender: Male
Posts: 21


Living and working in Tenerife since 2003


WWW
« Reply #1 on: March 17, 2010, 09:13:57 AM »

If you have your info in an Excel spreadsheet already, I believe you can just use the 'Save As' option from the File Menu (if using Excel 2007 click the Office button and then 'Save As').

In the 'Save As Type' drop down list at the bottom of the dialogue box you can then choose the CSV (Comma Delimited) option.

Then just choose where you want to save it and what you want to call it.

NOTE: Whether you need to do anything other than this for what you need, I am not sure, but I am sure someone else on here will be able to let you know.
Logged

Living and working at The Beach in Tenerife since 2003!
teenymunchkins
Liking it Here
***

Karma: 2
Offline Offline

Gender: Female
Posts: 119



WWW
« Reply #2 on: March 17, 2010, 11:00:38 AM »

If you have your info in an Excel spreadsheet already, I believe you can just use the 'Save As' option from the File Menu (if using Excel 2007 click the Office button and then 'Save As').

In the 'Save As Type' drop down list at the bottom of the dialogue box you can then choose the CSV (Comma Delimited) option.

Then just choose where you want to save it and what you want to call it.

NOTE: Whether you need to do anything other than this for what you need, I am not sure, but I am sure someone else on here will be able to let you know.

Thanks, I didn't see this replyu.

I don't have it in Excel already I'm afraid.  I can see where you can create a .txt file, can I do something with that??

Alison
Logged

teenymunchkins
Liking it Here
***

Karma: 2
Offline Offline

Gender: Female
Posts: 119



WWW
« Reply #3 on: March 17, 2010, 11:02:04 AM »

Oooo think I might have done it!!

I downloaded a completed tab delimited .txt file to excel and saved it as a .csv  :D

Hope it works

Alison
Logged

DeputyDog
Settling In
**

Karma: 0
Offline Offline

Gender: Male
Posts: 33



WWW
« Reply #4 on: March 17, 2010, 11:08:37 AM »

Remember This - If you have downloaded a complete file REMEMBER to delete the line with your cost price or your customers will know what you paid for the items.

 wink
Logged

www.Fancydressdropship.co.uk - Fancy Dress & Clubwear Dropshipper .
Swimwear also available
sgd
Newbie
*

Karma: 1
Online Online

Gender: Male
Posts: 21


Living and working in Tenerife since 2003


WWW
« Reply #5 on: March 17, 2010, 11:47:06 AM »

REMEMBER to delete the line with your cost price

Very good point!
Logged

Living and working at The Beach in Tenerife since 2003!
teenymunchkins
Liking it Here
***

Karma: 2
Offline Offline

Gender: Female
Posts: 119



WWW
« Reply #6 on: March 17, 2010, 12:09:47 PM »

Remember This - If you have downloaded a complete file REMEMBER to delete the line with your cost price or your customers will know what you paid for the items.

 wink

I can't see anywhere that has sort of info but come to think of it, I don't have my cost price on the site anyway  :D
Logged

teenymunchkins
Liking it Here
***

Karma: 2
Offline Offline

Gender: Female
Posts: 119



WWW
« Reply #7 on: March 17, 2010, 12:36:13 PM »

Okay .. I am now having a stupid moment.

I have got my excel file on my computer .. how the bloomin' 'eck do I get into onto my site?

I have added a downloads section via EZpages and wanted to add a link to it in there but I am stumped!!  Please help  :D

Thanks

Logged

scotserve
Guru
Shareholder ;o)
*****

Karma: 36
Offline Offline

Gender: Male
Posts: 820



WWW
« Reply #8 on: March 17, 2010, 02:19:19 PM »

Okay .. I am now having a stupid moment.

I have got my excel file on my computer .. how the bloomin' 'eck do I get into onto my site?

I have added a downloads section via EZpages and wanted to add a link to it in there but I am stumped!!  Please help  :D

Thanks



Upload the file to say /uploads

The then create a link to www.sitename/uploads/csvfilename
Logged

Scotserve - Premium Domain and Hosting services since 1994
Pages: [1] Print 
« previous next »
Jump to:  


Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!
SimplePortal 2.2.2 © 2008-2009