Kirix Support Forums

Import xls table data loss

Please post any help questions, requests or other feedback here.

Import xls table data loss

Postby TillyDoyle on Wed Jul 20, 2011 4:21 am

Every time I import the data from excel I am losing some of data in the invoice numbers column. It appears to drop those that are numeric only but produces alphanumerics fine. The automatic settings go set the column as 'wide character'. :?
TillyDoyle
Registered User
 
Posts: 4
Joined: Wed Jul 20, 2011 4:17 am

Re: Import xls table data loss

Postby Ken on Wed Jul 20, 2011 1:19 pm

Hi there,

Invoice numbers should be "characters", since, for example, you don't want to lose leading 0s or letters. Since Excel is a spreadsheet, rather than a database, it can get a little wonky when it has mixed types within a column (i.e., it doesn't care, but a database does).

What I'd recommend is opening Excel and then saving the file as a CSV. Then, open the CSV in Strata. That will usually do the trick.
Ken Kaczmarek
Kirix Support Team
User avatar
Ken
Kirix Support Team
 
Posts: 147
Joined: Mon Dec 19, 2005 10:36 am

Re: Import xls table data loss

Postby TillyDoyle on Fri Jul 22, 2011 10:07 am

works a treat thanks
TillyDoyle
Registered User
 
Posts: 4
Joined: Wed Jul 20, 2011 4:17 am

Return to Strata Help & Feedback