I have a 5 column table of data containing some 150 entries.
I would like to put this data into Excel so that I can call it from Freeway.
Is there a way of transferring the table data to an Excel spread sheet?
All attempts so far have failed!
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Do you mean that the data is already within a FW table and you want to get it out into Excel and then back into FW?
Not quite sure of your plan of work here.
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Sorry for any confusion.
The data is in FW and I want to get it from FW into an Excel spread sheet.
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
And then what do you plan to do with it
D
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
The data which was originally collected and written into the FW table is now much more agile and changes frequently.
I understand that I can get FW to access excel data and load Excel pages into FW. So the idea was to hold the data in Excel so that it could be updated easily and be uploaded to FW on a frequent basis, instead of having to adjust and sort the data out in the table in FW.
The bottom line is: Can I get the current FW data held in a table out of FW and into Excel?
I do appreciate your time.
Thanks
D
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
I had a brief poke at this, and the short answer is no. The long
answer is yes, but you have to do a lot of filtering with a text
editor. Start with the published HTML from that page (and do yourself
a favor and make sure that the document is set to More Readable in the
preferences).
Using a Real Text Editor like TextWrangler or TextMate, locate your
table in the code. Delete everything before and after it. Shift the
remaining lines over to the left using the Command left-square-bracket
shortcut.
Delete the <table tag and the closing </table tag. Use find and
replace to delete the opening <tr and closing </tr tags, they should
each be all by themselves on a line.
Now use find and replace. Search for a closing td followed immediately
by an opening td. Your find should look like this (TextWrangler in
GREP mode):
</td><td.*?>
You may need to fiddle with that, I can’t remember if TW needs you to
escape the backslash or not, which is what the backslash immediately
preceding the forward-slash is there for.
Replace with a comma.
Now find and replace all opening td and closing tds that are left
(should only be at the beginning and the end of each line). Clean up
any double-returns or blank lines. When you’re done, you should have
all of your data in comma-separated format, with each line as a row in
your table, and each cell in each row separated from the next by a
comma.
If your data includes commas as normal values, then you have to wrap
each value in a set of double-quotes. You can do this in your search
for close td-open td, just replace with
","
and put a quote at the beginning and end of each line to balance it out.
Finally, save this text file as yourData.csv. Excel and Numbers can
both import CSV files and treat them as a valid data format.
Walter
On Feb 8, 2011, at 2:58 PM, Cos wrote:
The data which was originally collected and written into the FW
table is now much more agile and changes frequently.
I understand that I can get FW to access excel data and load Excel
pages into FW. So the idea was to hold the data in Excel so that it
could be updated easily and be uploaded to FW on a frequent basis,
instead of having to adjust and sort the data out in the table in FW.
The bottom line is: Can I get the current FW data held in a table
out of FW and into Excel?
I do appreciate your time.
Thanks
D
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Yes - but not without some work involving copy/paste, text replacement etc.
Tell me more about how you want/plan to get the data from Excel into FW
D
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Thank you gents,
This all sound rather complicated, so I will shelve the idea for the present. I would like to thank you for your time and help with what I thought may be an easy task! How wrong can one be?
Many thanks
Regards
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
The reason I asked about how you were going to reimport the Excel file was to see if you might not be better setting up this info in a Database on your server.
The HTML to Excel conversion task itself is not that difficult - just probably seems a bit daunting.
If you would like to point us at the online page we can have a look for you - and if it is not that onerous a task we could probably do it for you much quicker than you could do yourself.
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Don’t give up yet - it’s just getting interesting! 
Try the following action;
http://www.freewayactions.com/code/?f=Extract+CSV+data.fwaction
(Click the ‘Download file’ button and install the resulting action in Freeway as normal).
Apply the action to your data table and publish as normal. The action will run through the table structure extracting the data from the table row > table data > p content. When done it will present this to you in a dialog box. Simply copy this CSV text and paste it into Excel or a plain text editor and then import the data into your spreadsheet.
I’ve tested the action on exactly one large-ish data table so if it falls over and dies let me know and I’ll try and fix it for you.
Regards,
Tim.
On 8 Feb 2011, at 22:34, Cos wrote:
Thank you gents,
This all sound rather complicated, so I will shelve the idea for the present. I would like to thank you for your time and help with what I thought may be an easy task! How wrong can one be?
FreewayActions.com - Freeware and commercial actions for Freeway Express & Pro.
…
Protect your mailto links from being harvested by spambots with Anti Spam.
Only available at FreewayActions.com
…
http://www.freewayactions.com
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Very cool Tim - must have too much spare time on your hands - it worked for me apart from some non-breaking spaces and "s that slipped in.
But not really a big issue
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
On 9 Feb 2011, at 01:09, DeltaDave wrote:
Very cool Tim - must have too much spare time on your hands
Only time that I would normally be spending sleeping!
- it worked for me apart from some non-breaking spaces and "s that slipped in.
After I sent it I realised that there is a better way to do this so the data is extracted inside Freeway - no need to publish and Freeway won’t encode any of the content.
If I can’t sleep I may give it a go.
Thanks,
Tim.
FreewayActions.com - Freeware and commercial actions for Freeway Express & Pro.
…
Protect your mailto links from being harvested by spambots with Anti Spam.
Only available at FreewayActions.com
…
http://www.freewayactions.com
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Only time that I would normally be spending sleeping!
I know that feeling - and there are many of us out here that are grateful for a bit of insomnia.
A 10min action for you will undoubtedly save a lot of time for others.
Many thanks
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Tim,
your script works … Almost
here is the source text for the first two rows of one of my tables.
Your script extracted “strong,strong,strong” for the first Row, not
ANIMAL,NUMBER CLIPS,COMMENTS . It got the rest of the rows correct,
e.g. Cats,3,A black cat
I had applied “Bold” to the text in the first row.
LLE
On Feb 8, 2011, at 7:30 PM, Tim Plumb wrote:
Don’t give up yet - it’s just getting interesting!
Try the following action;
http://www.freewayactions.com/code/?f=Extract+CSV+data.fwaction
(Click the ‘Download file’ button and install the resulting action in
Freeway as normal).
Apply the action to your data table and publish as normal. The action
will run through the table structure extracting the data from the
table row > table data > p content. When done it will present this to
you in a dialog box. Simply copy this CSV text and paste it into Excel
or a plain text editor and then import the data into your spreadsheet.
I’ve tested the action on exactly one large-ish data table so if it
falls over and dies let me know and I’ll try and fix it for you.
Regards,
Tim.
On 8 Feb 2011, at 22:34, Cos wrote:
Thank you gents,
This all sound rather complicated, so I will shelve the idea for the
present. I would like to thank you for your time and help with what
I thought may be an easy task! How wrong can one be?
FreewayActions.com - Freeware and commercial actions for Freeway
Express & Pro.
…
Protect your mailto links from being harvested by spambots with Anti
Spam.
Only available at FreewayActions.com
…
http://www.freewayactions.com
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
ANIMAL | NUMBER CLIPS | COMMENTS |
Cats | 3 | A black cat |
Sorry if this has been suggested, I’ve just come to this.
If I want to get tabular matter into Excel, the easiest way is to
highlight it in a browser and copy then simply paste into Excel works a
dream ;~}}
LLE Freeway mailto:email@hidden
9 February 2011 22:34Tim,
your script works … Almosthere is the source text for the first two rows of one of my tables.
Your script extracted “strong,strong,strong” for the first Row, not
ANIMAL,NUMBER CLIPS,COMMENTS . It got the rest of the rows correct,
e.g. Cats,3,A black catI had applied “Bold” to the text in the first row.
LLE
On Feb 8, 2011, at 7:30 PM, Tim Plumb wrote:
Don’t give up yet - it’s just getting interesting!
Try the following action;
http://www.freewayactions.com/code/?f=Extract+CSV+data.fwaction
(Click the ‘Download file’ button and install the resulting action in
Freeway as normal).Apply the action to your data table and publish as normal. The action
will run through the table structure extracting the data from the
table row > table data > p content. When done it will present this to
you in a dialog box. Simply copy this CSV text and paste it into Excel
or a plain text editor and then import the data into your spreadsheet.I’ve tested the action on exactly one large-ish data table so if it
falls over and dies let me know and I’ll try and fix it for you.
Regards,
Tim.On 8 Feb 2011, at 22:34, Cos wrote:
FreewayActions.com - Freeware and commercial actions for Freeway
Express & Pro.
…Protect your mailto links from being harvested by spambots with Anti
Spam.
Only available at FreewayActions.com
…freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/optionsfreewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/optionsTim Plumb mailto:email@hidden
9 February 2011 00:30Don’t give up yet - it’s just getting interesting!
Try the following action;
http://www.freewayactions.com/code/?f=Extract+CSV+data.fwaction
(Click the ‘Download file’ button and install the resulting action in
Freeway as normal).Apply the action to your data table and publish as normal. The action
will run through the table structure extracting the data from the
table row > table data > p content. When done it will present this to
you in a dialog box. Simply copy this CSV text and paste it into Excel
or a plain text editor and then import the data into your spreadsheet.I’ve tested the action on exactly one large-ish data table so if it
falls over and dies let me know and I’ll try and fix it for you.
Regards,
Tim.FreewayActions.com - Freeware and commercial actions for Freeway
Express & Pro.
…
Protect your mailto links from being harvested by spambots with Anti Spam.
Only available at FreewayActions.com
…
http://www.freewayactions.comfreewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/optionsCos mailto:email@hidden
8 February 2011 22:34Thank you gents,
This all sound rather complicated, so I will shelve the idea for the
present. I would like to thank you for your time and help with what I
thought may be an easy task! How wrong can one be?Many thanks
Regards
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options–
Best wishes Peter
–
================================
Peter Tucker, Oxford UK email@hiddenfreewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
ANIMAL
NUMBER CLIPS
COMMENTS
Cats
3
A black cat