Wondering if there is an action the allows you to search data within a excel file. Want to enable folks to enter a state, province, etc. and get search results from a synced excel file.
Anybody? Thank you in advance for any help.
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Nope - no actions.
Can you be more precise about what you are trying to achieve - an example of the data in your file would probably help.
This is more likely to need a php solution - but not with an excel file.
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Thanks David. Want to enable folks visiting the website to type in their state and search for nearby locations where they can buy my clients products. A complete list of locations, sorted by state, would show up in a results field, based on a provided list or spreadsheet.
Hope I’m making sense.
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Here is one method http://www.deltadesign.co/FW6Test/state-picker.html
Could be done with a text field instead of a picker
This uses the Protaculous action and some javascript and could be modified to better suit your needs.
This is taken from an example of Walter’s - and he is the man for anything Javascript
D
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Thank you kindly David. I’ll look into it.
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
At 18:56 -0500 3/12/13, Roman wrote:
Thanks David. Want to enable folks visiting the website to type in
their state and search for nearby locations where they can buy my
clients products. A complete list of locations, sorted by state,
would show up in a results field, based on a provided list or
spreadsheet.Hope I’m making sense.
You may not be able to extract the results data from a proprietary
spreadsheet app’s own format, but it’s not difficult (for a
programmer) to extract the data from a ‘.csv’ file saved from an
spreadsheet app.
I do this on two sites because it’s easier to get the administrator
to upload a csv file than create a plain text document with the same
info in it. The upload triggers a php script that, in one case
creates a simple list of dates in a file that is consulted by a Perl
CGI script to draw a bookings calendar; in the other the data is
loaded into a MySQL database that drives a much more complex
calendar/timetable type of page.
David
–
David Ledger - Freelance Unix Sysadmin in the UK.
email@hidden
www.ivdcs.co.uk
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
On 4 Dec 2013, 12:01 pm, David Ledger wrote:
At 18:56 -0500 3/12/13, Roman wrote:
Thanks David. Want to enable folks visiting the website to type in
their state and search for nearby locations where they can buy my
clients products. A complete list of locations, sorted by state,
would show up in a results field, based on a provided list or
spreadsheet.Hope I’m making sense.
You may not be able to extract the results data from a proprietary
spreadsheet app’s own format, but it’s not difficult (for a
programmer) to extract the data from a ‘.csv’ file saved from an
spreadsheet app.I do this on two sites because it’s easier to get the administrator
to upload a csv file than create a plain text document with the same
info in it. The upload triggers a php script that, in one case
creates a simple list of dates in a file that is consulted by a Perl
CGI script to draw a bookings calendar; in the other the data is
loaded into a MySQL database that drives a much more complex
calendar/timetable type of page.David
David Ledger - Freelance Unix Sysadmin in the UK.
email@hidden
www.ivdcs.co.uk
Thanks again David. Very much appreciate the support.
Question: Being that you’re in the Freeway world, perhaps you or someone you recommend could enable this function for me? Maybe this Walter you spoke of? Of course I’ll compensate for the work. I’m much more art than tech and although I know my way around Freeway, I certainly could use some help for this and future custom tasks.
Thanks again for your help.
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
At 11:08 -0500 6/12/13, Roman wrote:
On 4 Dec 2013, 12:01 pm, David Ledger wrote:
At 18:56 -0500 3/12/13, Roman wrote:
Thanks David. Want to enable folks visiting the website to type in
their state and search for nearby locations where they can buy my
clients products. A complete list of locations, sorted by state,
would show up in a results field, based on a provided list or
spreadsheet.I do this on two sites because it’s easier to get the administrator
to upload a csv file than create a plain text document with the same
info in it. The upload triggers a php script that, in one case
creates a simple list of dates in a file that is consulted by a Perl
CGI script to draw a bookings calendar; in the other the data is
loaded into a MySQL database that drives a much more complex
calendar/timetable type of page.Question: Being that you’re in the Freeway world, perhaps you or
someone you recommend could enable this function for me? Maybe this
Walter you spoke of? Of course I’ll compensate for the work. I’m
much more art than tech and although I know my way around Freeway, I
certainly could use some help for this and future custom tasks.
There is a PHP function to read a file into an array, line by line,
and another to extract a line of cells from a CSV file into an array.
You read the file into the array, and then run through it, line by
line, splitting each line into cells. For each line of cells you have
to work out what sort of line it is. That is the difficult part and
may well mean having an extra column in the s/s that whoever fills it
in has to fill in properly. You end up with something like (in PDL or
an Pseudo Design Language):
for each line in file
if the line is empty
continue (skip to next line)
else if cell x looks like it’s the header row in a way that
can’t match any other line
save away the header info
continue
else if cell y looks like it’s a data cell of type A
save the data into the database, possibly including
some header info
unset “seen type B” flag variable
continue
else if cell z looks like it’s a data cell of type B
save the data info
set a variable to indicate that this line has been seen
continue
else if flag shows that a line of type B has been seen
save the data into the database, possibly including
some other saved info
continue
.
.
.
By using this kind of logic the CSV file can be parsed into the
database. It can be a bit of a slog.
I could do this for you, but I’m on chemotherapy until March, which
limits the amount of time I can think straight. (As far as they can
tell, the cancer has been totally removed, so it’s ‘just in case’
chemo). If you want me to write it for you and are not in a hurry,
then get back to me off list.
David
–
David Ledger - Freelance Unix Sysadmin in the UK.
email@hidden
www.ivdcs.co.uk
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
David,
I’m sorry to hear you were ill and I hope you continue to be cancer free.
Todd
I could do this for you, but I’m on chemotherapy until March, which limits the amount of time I can think straight. (As far as they can tell, the cancer has been totally removed, so it’s ‘just in case’ chemo).
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options