thestakingmachine.com

TSM - Forum

TSM Forum Home     Download TSM     Purchase TSM     Support     TSMapp     Back to Main TSM Site 

It is currently Wed Apr 16, 2014 2:10 pm
Coup Master Advert


All times are UTC [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Importing data
PostPosted: Mon Aug 13, 2007 12:24 pm 
Offline

Joined: Tue Jul 31, 2007 9:38 pm
Posts: 6
I have a csv file that looks like this:

Horse Odds Win/lose
Snoqualmie 2.12 2
FarmerBrown 1.65 1
Caravel 1.69 1

(formatting lost in this thread)

When I import it, it looks like its parsed the data correctly, but when I ask it to update the results grid, the data for the horse and odds goes across, but not the result.

Any ideas what I'm doing wrong?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Aug 13, 2007 1:15 pm 
Offline
Site Admin
User avatar

Joined: Wed Jun 20, 2007 4:16 pm
Posts: 585
Location: London
Paul,

Can i just confirm you are opening the CSV file directly into TSM.
If so, it is probably your headers.
Horse can be anything = Horse
Odds needs to be all lowercase = odds
Win/Lose needs to be all lower case and no spaces or backslash = winlose

A quick and easyway or getting a CSV 'template' is to Save as CSV but with no data in it. This will create a CSV file in the correct format with no data.

Remember when opening CSV files that the CSV file cannot be currently open such as open in Excel. You have to close the file to let TSM have access to it.

When copy/pasting the data from Excel or Works, to TSM , you do not include the headers.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Aug 13, 2007 1:43 pm 
Offline

Joined: Tue Jul 31, 2007 9:38 pm
Posts: 6
That's sorted it. I had the headers the same as in the text in the main window above, which had some capitals and a '/' in it.

Thanks
Paul


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
POWERED_BY