[Pro] Html Tables - Importing CSV files

Freeway
1

Does Freeway not like CSV files containing line breaks? Anyone else had a problem with this?

I tried putting a line break in the cell of a google spreadsheet (ctrl+enter). Works in the spreadsheet, but when I import the data to a table it appears to throw everything after the line break into a new cell.

Thanks

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

2

Try replacing the line break with a junk character sequence, like three dollar signs in a row or something, and then replace that again once you have imported the cells. CSV is not really a codified standard per se, there is a lot of room for ambiguity in the practice, and so it stands to reason that there will be multiple interpretations of how to read it.

Walter

On Aug 9, 2014, at 7:19 AM, Tim wrote:

Does Freeway not like CSV files containing line breaks? Anyone else had a problem with this?

I tried putting a line break in the cell of a google spreadsheet (ctrl+enter). Works in the spreadsheet, but when I import the data to a table it appears to throw everything after the line break into a new cell.

Thanks

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

3

Thanks Walter,

Would I then use the find/replace feature to achieve this throughout the entire table? In which case find ‘$$$’ then somehow replace it with a line break or paragraph?

Otherwise I guess I’m just going to have change each cell one at a time.

Is that possible?

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

4

Yes. It’s slightly complicated in that in order to make the “replace” part, you need to copy a return out of another part of your page (there’s no “escape” syntax you can put into the replace field to simulate a real return) and then paste that into the return field. It does work (I have used this to recover from ASCII-Unicode mismatch characters in the past.)

Walter

On Aug 9, 2014, at 10:07 AM, Tim wrote:

Thanks Walter,

Would I then use the find/replace feature to achieve this throughout the entire table? In which case find ‘$$$’ then somehow replace it with a line break or paragraph?

Otherwise I guess I’m just going to have change each cell one at a time.

Is that possible?

Tim

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

5

Thanks. That works for me to, great. But for some reason the space between the first line and the next then becomes huge when I want the next line to be directly underneath.

It’s obviously seeing the return as a new paragraph but for the life of me can’t find where to change the spacing for the table cells. I’m assuming that I need to be making ‘space after’ as ‘0’.

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

6

My apologies. False alarm. Just realised how you can style a table. Still early days, but getting there!

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

7

Thought I got this right but clearly not quite:

http://www.golagos.net/tabletest.html

I’ve set the style for this table as 0 space before and 0 space after paragraph. There is no spacing between the rows in the address column and it looks fine in Page view.

As you can see, when published there are spaces between the lines.

Advice gratefully received.

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

8

Try making a style in your page head, like this:

<style type="text/css">
table.dataTable td p {
  margin:0;
  padding:0;
}
<style>

Currently, you are seeing no spaces around some of the cells’ text, because Freeway adds the .f-fp and .f-lp classes to the first and last paragraphs in any text container, respectively. These remove the margin-top or margin-bottom, depending on which one you use. If both are applied to the same paragraph, then there would be no space on both top and bottom of the paragraph.

The style I wrote here is specific enough to really remove all white space in and around the paragraphs within this table.

Walter

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

9

Thanks Walter. That works a treat.

One thing that has caused problems when I put all the data into the table was that it naturally extended way down the past board. More than anything it makes working on the rest of the page impossible.

I’ve tried reducing the table height (no go) and tried to paste the table into a text and or graphic box, which doesn’t work either.

What the table itself looks like in page view doesn’t bother me so long as it looks ok in preview and through a browser (which it does). Is there a simple fix to this?

Thanks

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

10

Does increasing the size of the Pastebord help you?

David

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

11

Hi David,

As a temporary measure I increased the height of the page to match the height of the table, just so I could see to edit it. I suppose it would have been better to increase the size of the pasteboard.

Looking at my post I think I may have muddied the waters. At the moment the table covers the entire page (in page view). So if I’m looking to put other items on the page such as a banner (and in my case a map) I can’t see where and how to position them as my page is obscured by the table.

Hope that makes better sense.

Thanks.

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

12

My thought is whether there is a way to contain the table within an HTML item/ box so it can be positioned on the page at the same size as the data table. That way I know exactly where the table will appear and can continue to layout the rest of the page unhindered.

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

13

contain the table within an HTML item/ box so it can be positioned on the page at the same size as the data table

Dont think that is possible.

Why not just build your page with an object the same dimensions as your finished Data Table and swop it out when your layout is ready.

Or maybe use an iFrame linked to a separate page where your DataTable is.

D

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

14

Hi Dave

“Why not just build your page with an object the same dimensions as your finished Data Table and swop it out when your layout is ready.”

Now that’s extremely logical. I’ll definitely experiment with that one.

“Or maybe use an iFrame linked to a separate page where your DataTable is.”

Yes I’ve just discovered the iframe action and trying it out at this very moment. I spot one or two issues with it but will only know when I’ve given it some more thought.

Many thanks. Will let you know how it goes.

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

15

The iFrame solution seems to be working fine, just needs a little tinkering.

The problem that I’d not considered is the ‘show ‘n’ rows’ facility. Is there a simple way to disable this feature? Or indeed eliminate it altogether?

I tried one piece of script but is also disabled the universial search which I would like to keep.

Thanks.

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

16

http://www.golagos.net/restaurantfinder.html

Used a crude layout to test iframes and it pretty much does what it says. Got over the ‘show rows’ issue by putting a blank text box over the offending item to conceal it. No problem.

However (please see link) I can’t understand why I have these shadows on the page border.

Any help greatly appreciated.

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

17

I can’t understand why I have these shadows on the page border.

In the iFrame Action settings window have you left the Frame Border at its default of 1?

If you have then change it to 0

D

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

18

I was 99% sure that I’d done that but have must done something daft. Anyway many thanks. It is now set to 0 and looks fine.

Tim

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options