Suggestion - Graphic preview mode

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Baboon
Posts: 4
Joined: Fri Feb 29, 2008 7:05 am

Suggestion - Graphic preview mode

Postby Baboon » Fri Feb 29, 2008 7:26 am

I use textpipe to sort out large semicolon separated spreadsheets, and sometimes I wish I had some sort of a graphic preview mode to check if everything is in order and in the right columns after adding filters.

The trial run area gives me some overview, but often I have to process the file and check it in Excel to give me a satisfactory overview and make sure everything is where it should be. This, of course, is because the trial run area does not line up the the semicolon separated columns which makes it time consuming to check for errors and a bit annoying to work with both Textpipe and Excel at the same time as textpipe naturally can't process files that are already being used by Excel.

So my question is: Would it be possible to create some kind of graphic excel-preview mode? I think this would make a lot of mail house workers etc. very happy.

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Mon Mar 03, 2008 11:02 am

Thanks - that sounds like a great idea.

Do you think the following would work:

Trial Output
- text mode
- csv/tab/delimited mode (cells like Excel)
- ebcdic mode
- hex mode?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Baboon
Posts: 4
Joined: Fri Feb 29, 2008 7:05 am

Postby Baboon » Tue Mar 04, 2008 4:46 am

DataMystic Support wrote:Thanks - that sounds like a great idea.

Do you think the following would work:

Trial Output
- text mode
- csv/tab/delimited mode (cells like Excel)
- ebcdic mode
- hex mode?


Sounds very good to me.

That csv/tab/delimited mode would save me from countless annoying "range check errors" and save me hours of work in the long run.

Btw. Thanks for the quick and positive response.

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Tue Mar 04, 2008 8:33 am

Where do the range check errors come from? TextPipe?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Baboon
Posts: 4
Joined: Fri Feb 29, 2008 7:05 am

Postby Baboon » Tue Mar 04, 2008 10:13 pm

DataMystic Support wrote:Where do the range check errors come from? TextPipe?


Yes. But they are caused by me forgetting to close Excel while processing in textpipe. It's easy to forget when you have to switch back and forth between the two programs.

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Wed Mar 05, 2008 7:41 am

Ok - thanks.

I'd like this to be handled better - is this happening because the output CSV file is already open in Excel?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Baboon
Posts: 4
Joined: Fri Feb 29, 2008 7:05 am

Postby Baboon » Thu Mar 06, 2008 8:02 am

DataMystic Support wrote:Ok - thanks.

I'd like this to be handled better - is this happening because the output CSV file is already open in Excel?


Exactly.

DFH
Posts: 644
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Preview for Excel needs to cope with more than 256 columns

Postby DFH » Thu Mar 06, 2008 6:05 pm

If you do implement a preview for Excel CSV, please ensure that it copes with more than 256 columns!

Prior to Office 2007, this was a serious shortcoming for Excel.

TextPipe can cope with unlimited number of CSV columns, I think?

Best regards,
David

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Thu Mar 06, 2008 6:07 pm

Yes - it can! We will make sure of this - thanks for reminding us!
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest