[Pro] CSV files

Hi,
I have been asked to redesign/build a replacement website for a radio station.
with a CMS. This is not a problem using webyeb, which I regularly use.

Sticking point:
What I need to know is if there is away for client to upload a CSV file that appears on the page visually (not an attachment)
This is what they currently have and want to retain, schedules are created as Excell spreadsheets, saved as CSV files and uploaded to page.

Can this be done using Freeway/webyep? I’ve been trying various methods but no luck yet.

thanks
Phil


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

Not as far as I know, but I have built many of these systems over the years, and it’s a very nice way to coordinate data without the need for a fancy user interface, or to permit bulk updates in a system that also has one.

I can dig up some sample code if you have a mind to try this out. You will need to spend some time with a thick book, get comfortable with a programmer’s text editor like TextMate or SublimeText or TextWrangler (free!), etc.

Walter

On Jul 16, 2013, at 6:12 AM, Phil wrote:

Hi,
I have been asked to redesign/build a replacement website for a radio station.
with a CMS. This is not a problem using webyeb, which I regularly use.

Sticking point:
What I need to know is if there is away for client to upload a CSV file that appears on the page visually (not an attachment)
This is what they currently have and want to retain, schedules are created as Excell spreadsheets, saved as CSV files and uploaded to page.

Can this be done using Freeway/webyep? I’ve been trying various methods but no luck yet.

thanks
Phil


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

Thanks for your reply Walter.
I don’t really have the ‘mind’ to try what you suggest, I know my limits!

Thanks anyway
Phil


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

Well, you can import CSV into Freeway, if you want to go that way. The client would e-mail you the file, and you would follow these steps:

###First Time:

  1. Draw a table on the page, 1 row x number of columns in the CSV file.
  2. Click into the first cell (top-left) so you see a flashing text cursor. From the main menu, choose File / Import and change the import type picker to Comma-delimited. Select your file.
  3. Freeway will magically populate the table with the contents of the file.
  4. Resist the urge to style this data in any way, as this will make it impossible to update later without pain. Instead, post a link here to the page, along with a description of how you would like to modify the bare text. There are simple CSS rules you can create in your page which will allow you to leave the text entirely unstyled, while making it look any way you can imagine in a browser.

###Second+ Time:

  1. Click once on the second row, first column (so you see a blue highlight rectangle in the cell) then shift-click on the bottom-right cell. Press the Delete key twice. The first click should collapse the cells into one another, the second should remove them, leaving only the first row of the table.
  2. Tab through the cells and delete the original content.
  3. Follow steps 2 and 3 above, which will re-populate the table with the newest content.
  4. The styles won’t be affected by this update.

Walter

On Jul 17, 2013, at 10:04 AM, Phil wrote:

Thanks for your reply Walter.
I don’t really have the ‘mind’ to try what you suggest, I know my limits!

Thanks anyway
Phil


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

As an alternative is: export as a csv file. Then open it up using normal text editor copy all the contents
then go to a site like this:

paste the csv content into the top panel and click the button make table.
Finally copy the table code thats been generated into a WebYep Richtext (HTML VIEW) editor area
and save.

If you have already predefined the styles for the table then the table will be styled to suite the design.

max


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

Thanks Walter and Max,
All useful, I shall investigate!

Phil


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