Possibilities with a Text Field

17 messages Options
Embed this post
Permalink
Salman Maidan-3

Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
Hi Experts,
WinXp - FMPA 10

I am trying to copy contents of an MS word document which can contain text,
graphics, and tables, and paste all that into FMP text field. However I see
that graphics don't copy at all and tables only copy the content of the
table but not the outlines. I understand that is because text fields are
purely for text characters. I tried using a container field but too many
difficulties with scroll bar and if I am not mistaken size of file.

My question: is there any way to overcome that and be able to copy all the
content as is. I know FMP is full of good tricks, but I don't know them all.
;-)

Regards
--
Salman Maidan
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Corn Walker

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
On Jun 14, 2009, at 12:30 PM, Salman Maidan wrote:

> I am trying to copy contents of an MS word document which can  
> contain text,
> graphics, and tables, and paste all that into FMP text field.  
> However I see
> that graphics don't copy at all and tables only copy the content of  
> the
> table but not the outlines. I understand that is because text fields  
> are
> purely for text characters. I tried using a container field but too  
> many
> difficulties with scroll bar and if I am not mistaken size of file.
>
> My question: is there any way to overcome that and be able to copy  
> all the
> content as is. I know FMP is full of good tricks, but I don't know  
> them all.
> ;-)

No, there's aren't any tricks where you can actually store the data in  
FMP. On Windows you can embed OLE objects but I'm not sure that's what  
you're trying to achieve.

If you're looking for a way to embed a word processor in FMP then  
you'll need to leverage the web viewer. There are any number of  
javascript based solutions you can choose from. Joe Scarpetta recently  
posted a technique on his blog <http://apphiasolutions.com/blog_index.php 
 > that leverages FileMaker Server. I've been investigating doing the  
same using the Fusion Reactor plugin <http://www.fusionplugins.com/reactor/ 
 >.

In any case, I doubt you're going to find a solution that will let you  
Copy/Paste and retain all of the style and layout and graphics and the  
ability to edit the same.

Cheers,
-corn


Corn Walker
The Proof Group
http://proofgroup.com/

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Salman Maidan-3

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
Thank you corn for clear and definitive answer.

--
Salman Maidan

On Sun, Jun 14, 2009 at 7:52 PM, Corn Walker <[hidden email]> wrote:

> On Jun 14, 2009, at 12:30 PM, Salman Maidan wrote:
>
>  I am trying to copy contents of an MS word document which can contain
>> text,
>> graphics, and tables, and paste all that into FMP text field. However I
>> see
>> that graphics don't copy at all and tables only copy the content of the
>> table but not the outlines. I understand that is because text fields are
>> purely for text characters. I tried using a container field but too many
>> difficulties with scroll bar and if I am not mistaken size of file.
>>
>> My question: is there any way to overcome that and be able to copy all the
>> content as is. I know FMP is full of good tricks, but I don't know them
>> all.
>> ;-)
>>
>
> No, there's aren't any tricks where you can actually store the data in FMP.
> On Windows you can embed OLE objects but I'm not sure that's what you're
> trying to achieve.
>
> If you're looking for a way to embed a word processor in FMP then you'll
> need to leverage the web viewer. There are any number of javascript based
> solutions you can choose from. Joe Scarpetta recently posted a technique on
> his blog <http://apphiasolutions.com/blog_index.php> that leverages
> FileMaker Server. I've been investigating doing the same using the Fusion
> Reactor plugin <http://www.fusionplugins.com/reactor/>.
>
> In any case, I doubt you're going to find a solution that will let you
> Copy/Paste and retain all of the style and layout and graphics and the
> ability to edit the same.
>
> Cheers,
> -corn
>
>
> Corn Walker
> The Proof Group
> http://proofgroup.com/
>
>
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Bob Patin

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
In reply to this post by Salman Maidan-3
You could always save your file as a PDF, which retains the look, if  
not the editability, at least not without Acrobat Pro...


Bob Patin
Longterm Solutions
[hidden email]
615-333-6858
http://www.longtermsolutions.com
Twitter: bobpatin
iChat: bobpatin
AIM: longterm1954
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance & FileMaker TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
Web hosting • PHP • Full email services • Free DNS hosting •  
Colocation • Consulting

On Jun 14, 2009, at 11:30 AM, Salman Maidan wrote:

> Hi Experts,
> WinXp - FMPA 10
>
> I am trying to copy contents of an MS word document which can  
> contain text,
> graphics, and tables, and paste all that into FMP text field.  
> However I see
> that graphics don't copy at all and tables only copy the content of  
> the
> table but not the outlines. I understand that is because text fields  
> are
> purely for text characters. I tried using a container field but too  
> many
> difficulties with scroll bar and if I am not mistaken size of file.
>
> My question: is there any way to overcome that and be able to copy  
> all the
> content as is. I know FMP is full of good tricks, but I don't know  
> them all.
> ;-)
>
> Regards
> --
> Salman Maidan
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Beverly Voth-2

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
In reply to this post by Salman Maidan-3
My question back is why? I mean what is the purpose of getting all  
that? Will you be pushing back out at some point? Why not into a  
container field? And you probably won't get the graphics, but what  
happens if the word document is saved as XML format? Would that get  
your "text"?

--
Beverly Voth
mailto:[hidden email]
tel:(606) 258-7399
--

On Jun 14, 2009, at 12:30 PM, Salman Maidan <[hidden email]> wrote:

> Hi Experts,
> WinXp - FMPA 10
>
> I am trying to copy contents of an MS word document which can  
> contain text,
> graphics, and tables, and paste all that into FMP text field.  
> However I see
> that graphics don't copy at all and tables only copy the content of  
> the
> table but not the outlines. I understand that is because text fields  
> are
> purely for text characters. I tried using a container field but too  
> many
> difficulties with scroll bar and if I am not mistaken size of file.
>
> My question: is there any way to overcome that and be able to copy  
> all the
> content as is. I know FMP is full of good tricks, but I don't know  
> them all.
> ;-)
>
> Regards
> --
> Salman Maidan
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Beverly Voth-2

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
Or save as RTF. IF I recall, graphics are converted to base64. (I  
could be wrong and can't test to confirm.)

Save the word documents as XML and RTF formats and see what "text" you  
get with each.

--
Beverly Voth
mailto:[hidden email]
tel:(606) 258-7399
--

On Jun 14, 2009, at 3:28 PM, Beverly Voth <[hidden email]> wrote:

> My question back is why? I mean what is the purpose of getting all  
> that? Will you be pushing back out at some point? Why not into a  
> container field? And you probably won't get the graphics, but what  
> happens if the word document is saved as XML format? Would that get  
> your "text"?
>
> --
> Beverly Voth
> mailto:[hidden email]
> tel:(606) 258-7399
> --
>
> On Jun 14, 2009, at 12:30 PM, Salman Maidan <[hidden email]>  
> wrote:
>
>> Hi Experts,
>> WinXp - FMPA 10
>>
>> I am trying to copy contents of an MS word document which can  
>> contain text,
>> graphics, and tables, and paste all that into FMP text field.  
>> However I see
>> that graphics don't copy at all and tables only copy the content of  
>> the
>> table but not the outlines. I understand that is because text  
>> fields are
>> purely for text characters. I tried using a container field but too  
>> many
>> difficulties with scroll bar and if I am not mistaken size of file.
>>
>> My question: is there any way to overcome that and be able to copy  
>> all the
>> content as is. I know FMP is full of good tricks, but I don't know  
>> them all.
>> ;-)
>>
>> Regards
>> --
>> Salman Maidan
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Beverly Voth-2

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
In reply to this post by Salman Maidan-3
Ah, Salman, now that helps to see what you want. You'd have to have
"internal links" to the regulations. Perhaps the PDF would be a way to go.
You can (with ADOBE) insert links to portions of a PDF document. Perhaps
then you can preview with OPEN Url [ ]. But you'd need "local" reference to
the document.

If other means, you'd need to break apart the regulations and still need
exteral versions of the document to pull up. Perhaps OLE. Let's see what the
list has to say about this development (your WHY...)
:)

Beverly

On 6/15/09 7:12 AM, "Salman Maidan" <[hidden email]> wrote in whole or
in part:

> I might well be going about this the wrong way, so your WHY question is very
> useful indeed. Basically I have a huge word manual which is full of
> regulations. I simply want to copy each regulation in a record of it own in
> FMP database so it can be referenced easily by presenting the users with a
> list of the regulation numbers in a portal, He/She click a button and open
> the appropriate regulation.
>
> Now if I can leave the regulations in the word doc. and link to them that
> will suite my purpose, however I would want the word document to open at the
> appropriate page and the appropriate regulation, hence my copy and pasting
> them in FMP. BUT if there is an easy way to do this then I am all ears.
>
> Salman
>
>
> On Sun, Jun 14, 2009 at 10:28 PM, Beverly Voth <[hidden email]> wrote:
>
>> My question back is why? I mean what is the purpose of getting all that?
>> Will you be pushing back out at some point? Why not into a container field?
>> And you probably won't get the graphics, but what happens if the word
>> document is saved as XML format? Would that get your "text"?
>>
>> --
>> Beverly Voth
>> mailto:[hidden email]
>> tel:(606) 258-7399
>> --
>>
>>
>> On Jun 14, 2009, at 12:30 PM, Salman Maidan <[hidden email]> wrote:
>>
>>  Hi Experts,
>>> WinXp - FMPA 10
>>>
>>> I am trying to copy contents of an MS word document which can contain
>>> text,
>>> graphics, and tables, and paste all that into FMP text field. However I
>>> see
>>> that graphics don't copy at all and tables only copy the content of the
>>> table but not the outlines. I understand that is because text fields are
>>> purely for text characters. I tried using a container field but too many
>>> difficulties with scroll bar and if I am not mistaken size of file.
>>>
>>> My question: is there any way to overcome that and be able to copy all the
>>> content as is. I know FMP is full of good tricks, but I don't know them
>>> all.
>>> ;-)
>>>
>>> Regards
>>> --
>>> Salman Maidan
>>>
>>
>


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Richard DeShong

RE: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
1) Create a separate pdf for each regulation, with just the piece of the doc
that pertains to the regulation.  Store that in a container field with each
rcd.  File size would be increase by the size of all the pdf's, plus
overhead.  But I would think that this would be fairly static.  Also, as the
reg's change, then only the piece that actually changes would need to be
replaced.  This should also be considered - when it changes, is it easy to
find out what parts actually changed?

2) My other thought was you might be able to create a single pdf and create
"bookmarks".  But then I don't know how to open a pdf and jump directly to a
given bookmark.

--
Richard DeShong, Athletic Study Center, UCBerkeley


-----Original Message-----
From: fmpexperts Beverly Voth

Ah, Salman, now that helps to see what you want. You'd have to have
"internal links" to the regulations. Perhaps the PDF would be a way to go.
You can (with ADOBE) insert links to portions of a PDF document. Perhaps
then you can preview with OPEN Url [ ]. But you'd need "local" reference to
the document.

If other means, you'd need to break apart the regulations and still need
exteral versions of the document to pull up. Perhaps OLE. Let's see what the
list has to say about this development (your WHY...)
:)

Beverly

On 6/15/09 7:12 AM, "Salman Maidan" <[hidden email]> wrote in whole or
in part:

> I might well be going about this the wrong way, so your WHY question is
very
> useful indeed. Basically I have a huge word manual which is full of
> regulations. I simply want to copy each regulation in a record of it own
in
> FMP database so it can be referenced easily by presenting the users with a
> list of the regulation numbers in a portal, He/She click a button and open
> the appropriate regulation.
>
> Now if I can leave the regulations in the word doc. and link to them that
> will suite my purpose, however I would want the word document to open at
the

> appropriate page and the appropriate regulation, hence my copy and pasting
> them in FMP. BUT if there is an easy way to do this then I am all ears.
>
> Salman
>
>
> On Sun, Jun 14, 2009 at 10:28 PM, Beverly Voth <[hidden email]> wrote:
>
>> My question back is why? I mean what is the purpose of getting all that?
>> Will you be pushing back out at some point? Why not into a container
field?

>> And you probably won't get the graphics, but what happens if the word
>> document is saved as XML format? Would that get your "text"?
>>
>> --
>> Beverly Voth
>> mailto:[hidden email]
>> tel:(606) 258-7399
>> --
>>
>>
>> On Jun 14, 2009, at 12:30 PM, Salman Maidan <[hidden email]> wrote:
>>
>>  Hi Experts,
>>> WinXp - FMPA 10
>>>
>>> I am trying to copy contents of an MS word document which can contain
>>> text,
>>> graphics, and tables, and paste all that into FMP text field. However I
>>> see
>>> that graphics don't copy at all and tables only copy the content of the
>>> table but not the outlines. I understand that is because text fields are
>>> purely for text characters. I tried using a container field but too many
>>> difficulties with scroll bar and if I am not mistaken size of file.
>>>
>>> My question: is there any way to overcome that and be able to copy all
the

>>> content as is. I know FMP is full of good tricks, but I don't know them
>>> all.
>>> ;-)
>>>
>>> Regards
>>> --
>>> Salman Maidan
>>>
>>
>


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Pia Oliver

Re: shopping carts

Reply Threaded More More options
Print post
Permalink
In reply to this post by Beverly Voth-2
We need to implement our own shopping cart which stays on our domain.
In the past we have utilized a third party site but can no longer do
so. We use a FileMaker database which has been exported to a text
file and then loaded to a MySQL database feeding a search engine.

I would very much appreciate some suggestions. At the moment I am
thinking that we could use either Zend or OS Cart, and continue to
export the text file from our local FMP db, to the online MySQL.  I
have a little experience of php and MySQL ... not a lot though ...

or should we go with an FMP host and build it in Instant Web
Publishing? I have no experience of this.

We will have only unique items, not 6 widgets and 24 gazimkas, only
one of each, but want to catgorize them, e.g. Western Americana,
Early Books, etc. We need to accept credit cards, either fully
automated so that payment is made online by a cc processor, or the
information is sent securely to us and we process in the store. Would
like to have the ability to store user's info online, so they don't
have to enter address etc every time they buy. Want easy integration
with current website, and would like the design to be CSS driven, if
possible.

Please tell me all the things I have not considered, and pros and
cons, or if I am asking in the wrong forum, I would love a link to an
appropriate one. I have Googled but don't seem to get any real users'
experiences.

thanks,

Pia

--

Randall House (member Antiquarian Booksellers' Association of America
- http://www.ABAA.org )
835 Laguna Street
Santa Barbara, California 93101

(805) 963-1909      fax (805) 963-1650
<http://www.RandallHouseRareBooks.com>

Visa, MC, AmEx, MO, cheques in US funds, institutional billing on request.

Know who your Internet bookseller is! Look for the ABAA membership logo, the
Antiquarian Booksellers' Association of America - now a 50 year
professional organization requiring its members to have a proven
track record of knowledge and experience, and to abide by a written
code of ethics.
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Stephen Knight 800.353.7950

Re: shopping carts

Reply Threaded More More options
Print post
Permalink
Hi Pia,

Check out http://www.fmwebschool.com/dolphincartpro.php I can send you a
list of companies using dolphin cart - and http://www.fmgateway.com offers
hosting for the site for $24.99 a month.

In Kindness
Stephen Knight

----- Original Message -----
From: "Pia Oliver" <[hidden email]>
To: <[hidden email]>
Sent: Monday, June 15, 2009 3:22 PM
Subject: Re: shopping carts


> We need to implement our own shopping cart which stays on our domain. In
> the past we have utilized a third party site but can no longer do so. We
> use a FileMaker database which has been exported to a text file and then
> loaded to a MySQL database feeding a search engine.
>
> I would very much appreciate some suggestions. At the moment I am thinking
> that we could use either Zend or OS Cart, and continue to export the text
> file from our local FMP db, to the online MySQL.  I have a little
> experience of php and MySQL ... not a lot though ...
>
> or should we go with an FMP host and build it in Instant Web Publishing? I
> have no experience of this.
>
> We will have only unique items, not 6 widgets and 24 gazimkas, only one of
> each, but want to catgorize them, e.g. Western Americana, Early Books,
> etc. We need to accept credit cards, either fully automated so that
> payment is made online by a cc processor, or the information is sent
> securely to us and we process in the store. Would like to have the ability
> to store user's info online, so they don't have to enter address etc every
> time they buy. Want easy integration with current website, and would like
> the design to be CSS driven, if possible.
>
> Please tell me all the things I have not considered, and pros and cons, or
> if I am asking in the wrong forum, I would love a link to an appropriate
> one. I have Googled but don't seem to get any real users' experiences.
>
> thanks,
>
> Pia
>
> --
>
> Randall House (member Antiquarian Booksellers' Association of America -
> http://www.ABAA.org )
> 835 Laguna Street
> Santa Barbara, California 93101
>
> (805) 963-1909      fax (805) 963-1650
> <http://www.RandallHouseRareBooks.com>
>
> Visa, MC, AmEx, MO, cheques in US funds, institutional billing on request.
>
> Know who your Internet bookseller is! Look for the ABAA membership logo,
> the
> Antiquarian Booksellers' Association of America - now a 50 year
> professional organization requiring its members to have a proven track
> record of knowledge and experience, and to abide by a written code of
> ethics.
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au 

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Bart Bartholomay

Re: shopping carts

Reply Threaded More More options
Print post
Permalink
Somehow I knew that email was next!  :-)

Bart

Bart Bartholomay
HAB Marketing
3725 8th Lane
Vero Beach, FL 32960
772.299.6352
http://HABMarketing.com



On Jun 15, 2009, at 6:09 PM, Stephen Knight wrote:

Hi Pia,

Check out http://www.fmwebschool.com/dolphincartpro.php I can send you  
a list of companies using dolphin cart - and http://www.fmgateway.com 
offers hosting for the site for $24.99 a month.

In Kindness
Stephen Knight

----- Original Message ----- From: "Pia Oliver" <[hidden email]>
To: <[hidden email]>
Sent: Monday, June 15, 2009 3:22 PM
Subject: Re: shopping carts


> We need to implement our own shopping cart which stays on our  
> domain. In the past we have utilized a third party site but can no  
> longer do so. We use a FileMaker database which has been exported to  
> a text file and then loaded to a MySQL database feeding a search  
> engine.
>
> I would very much appreciate some suggestions. At the moment I am  
> thinking that we could use either Zend or OS Cart, and continue to  
> export the text file from our local FMP db, to the online MySQL.  I  
> have a little experience of php and MySQL ... not a lot though ...
>
> or should we go with an FMP host and build it in Instant Web  
> Publishing? I have no experience of this.
>
> We will have only unique items, not 6 widgets and 24 gazimkas, only  
> one of each, but want to catgorize them, e.g. Western Americana,  
> Early Books, etc. We need to accept credit cards, either fully  
> automated so that payment is made online by a cc processor, or the  
> information is sent securely to us and we process in the store.  
> Would like to have the ability to store user's info online, so they  
> don't have to enter address etc every time they buy. Want easy  
> integration with current website, and would like the design to be  
> CSS driven, if possible.
>
> Please tell me all the things I have not considered, and pros and  
> cons, or if I am asking in the wrong forum, I would love a link to  
> an appropriate one. I have Googled but don't seem to get any real  
> users' experiences.
>
> thanks,
>
> Pia
>
> --
>
> Randall House (member Antiquarian Booksellers' Association of  
> America - http://www.ABAA.org )
> 835 Laguna Street
> Santa Barbara, California 93101
>
> (805) 963-1909      fax (805) 963-1650
> <http://www.RandallHouseRareBooks.com>
>
> Visa, MC, AmEx, MO, cheques in US funds, institutional billing on  
> request.
>
> Know who your Internet bookseller is! Look for the ABAA membership  
> logo, the
> Antiquarian Booksellers' Association of America - now a 50 year  
> professional organization requiring its members to have a proven  
> track record of knowledge and experience, and to abide by a written  
> code of ethics.
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Bob Patin

Re: shopping carts

Reply Threaded More More options
Print post
Permalink
In reply to this post by Pia Oliver
Pia,

I would strongly advise against trying to use Instant Web Publishing.  
Besides the slowness of IWP in general, there are other significant  
arguments against its use for something like this:

1. IWP doesn't always render the same on every browser, so user  
experience might vary in unpredictable ways;
2. Using IWP with a payment gateway is difficult at best; although  
there are ways to make it work, I steer my clients away from it;

Unless you're expecting a huge amount of traffic on your site,  
FileMaker can handle your needs very ably; I've built and host quite a  
few sites that use FileMaker as the backend, and I know there are  
other very capable consultants on the list who have done so as well.  
Stephen Knight's Dolphin Cart is another good option to use.

If you're interested in having someone develop a site for you, I or  
others on the list would be glad to help.

Best,

Bob Patin
Longterm Solutions
[hidden email]
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
AIM: longterm1954
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

On Jun 15, 2009, at 4:22 PM, Pia Oliver wrote:

> We need to implement our own shopping cart which stays on our  
> domain. In the past we have utilized a third party site but can no  
> longer do so. We use a FileMaker database which has been exported to  
> a text file and then loaded to a MySQL database feeding a search  
> engine.
>
> I would very much appreciate some suggestions. At the moment I am  
> thinking that we could use either Zend or OS Cart, and continue to  
> export the text file from our local FMP db, to the online MySQL.  I  
> have a little experience of php and MySQL ... not a lot though ...
>
> or should we go with an FMP host and build it in Instant Web  
> Publishing? I have no experience of this.
>
> We will have only unique items, not 6 widgets and 24 gazimkas, only  
> one of each, but want to catgorize them, e.g. Western Americana,  
> Early Books, etc. We need to accept credit cards, either fully  
> automated so that payment is made online by a cc processor, or the  
> information is sent securely to us and we process in the store.  
> Would like to have the ability to store user's info online, so they  
> don't have to enter address etc every time they buy. Want easy  
> integration with current website, and would like the design to be  
> CSS driven, if possible.
>
> Please tell me all the things I have not considered, and pros and  
> cons, or if I am asking in the wrong forum, I would love a link to  
> an appropriate one. I have Googled but don't seem to get any real  
> users' experiences.
>
> thanks,
>
> Pia
>
> --
>
> Randall House (member Antiquarian Booksellers' Association of  
> America - http://www.ABAA.org )
> 835 Laguna Street
> Santa Barbara, California 93101
>
> (805) 963-1909      fax (805) 963-1650
> <http://www.RandallHouseRareBooks.com>
>
> Visa, MC, AmEx, MO, cheques in US funds, institutional billing on  
> request.
>
> Know who your Internet bookseller is! Look for the ABAA membership  
> logo, the
> Antiquarian Booksellers' Association of America - now a 50 year  
> professional organization requiring its members to have a proven  
> track record of knowledge and experience, and to abide by a written  
> code of ethics.
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
sono-io

Re: shopping carts

Reply Threaded More More options
Print post
Permalink
In reply to this post by Pia Oliver
Hi Pia,

        We use SurfShopPRO with a MySQL backend and then import the orders  
into FMPro using the Actual Technologies ODBC Driver.

http://www.surfshopcart.com/
http://www.actualtechnologies.com/product_opensourcedatabases.php

        This setup works very well for us.  SurfShop is not free like OS  
Commerce, but it's a lot less expense than a hosted FMPro db can be  
and a lot more powerful than Dolphin cart, the last time I checked  
(all are good solutions in their own right).

        SurfShop will do everything you requested, and they even have a FMPro  
db for batch importing complex category/sub-category setups directly  
into the cart.  They wrote that for us, actually, so we could  
automatically export/import all our info with only one click - very  
nice!

Regards,
Ted


On Jun 15, 2009, at 2:22 PM, Pia Oliver wrote:

> We need to implement our own shopping cart which stays on our  
> domain. In the past we have utilized a third party site but can no  
> longer do so. We use a FileMaker database which has been exported to  
> a text file and then loaded to a MySQL database feeding a search  
> engine.
>
> I would very much appreciate some suggestions. At the moment I am  
> thinking that we could use either Zend or OS Cart, and continue to  
> export the text file from our local FMP db, to the online MySQL.  I  
> have a little experience of php and MySQL ... not a lot though ...
>
> or should we go with an FMP host and build it in Instant Web  
> Publishing? I have no experience of this.
>
> We will have only unique items, not 6 widgets and 24 gazimkas, only  
> one of each, but want to catgorize them, e.g. Western Americana,  
> Early Books, etc. We need to accept credit cards, either fully  
> automated so that payment is made online by a cc processor, or the  
> information is sent securely to us and we process in the store.  
> Would like to have the ability to store user's info online, so they  
> don't have to enter address etc every time they buy. Want easy  
> integration with current website, and would like the design to be  
> CSS driven, if possible.
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Nicholas Orr

Re: shopping carts

Reply Threaded More More options
Print post
Permalink
In reply to this post by Pia Oliver
Pia,

We've setup some shopping cart options using Drupal and Ubercart and  
found it to be very useful for this sort of thing, although drupal is  
also a "whole of website" type platform, but could also be used for  
just the shopping cart process.

Let me know if you want any more details.

Cheers,
Nick

On 16/06/2009, at 7:22 AM, Pia Oliver wrote:

> We need to implement our own shopping cart which stays on our  
> domain. In the past we have utilized a third party site but can no  
> longer do so. We use a FileMaker database which has been exported to  
> a text file and then loaded to a MySQL database feeding a search  
> engine.
>
> I would very much appreciate some suggestions. At the moment I am  
> thinking that we could use either Zend or OS Cart, and continue to  
> export the text file from our local FMP db, to the online MySQL.  I  
> have a little experience of php and MySQL ... not a lot though ...
>
> or should we go with an FMP host and build it in Instant Web  
> Publishing? I have no experience of this.
>
> We will have only unique items, not 6 widgets and 24 gazimkas, only  
> one of each, but want to catgorize them, e.g. Western Americana,  
> Early Books, etc. We need to accept credit cards, either fully  
> automated so that payment is made online by a cc processor, or the  
> information is sent securely to us and we process in the store.  
> Would like to have the ability to store user's info online, so they  
> don't have to enter address etc every time they buy. Want easy  
> integration with current website, and would like the design to be  
> CSS driven, if possible.
>
> Please tell me all the things I have not considered, and pros and  
> cons, or if I am asking in the wrong forum, I would love a link to  
> an appropriate one. I have Googled but don't seem to get any real  
> users' experiences.
>
> thanks,
>
> Pia
>
> --
>
> Randall House (member Antiquarian Booksellers' Association of  
> America - http://www.ABAA.org )
> 835 Laguna Street
> Santa Barbara, California 93101
>
> (805) 963-1909      fax (805) 963-1650
> <http://www.RandallHouseRareBooks.com>
>
> Visa, MC, AmEx, MO, cheques in US funds, institutional billing on  
> request.
>
> Know who your Internet bookseller is! Look for the ABAA membership  
> logo, the
> Antiquarian Booksellers' Association of America - now a 50 year  
> professional organization requiring its members to have a proven  
> track record of knowledge and experience, and to abide by a written  
> code of ethics.
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Salman Maidan-3

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
In reply to this post by Richard DeShong
Thanks Richard that is a sound idea, I will implement that or if the
overhead is too much for file size I might keep the text field for the
regulation and have a related table with two container fields which will
house the graphics and table for those records that have them. Thanks  again
to all for their contribution....and still open to suggestions

Regards


On Mon, Jun 15, 2009 at 11:29 PM, Richard DeShong <[hidden email]>wrote:

> 1) Create a separate pdf for each regulation, with just the piece of the
> doc
> that pertains to the regulation.  Store that in a container field with each
> rcd.  File size would be increase by the size of all the pdf's, plus
> overhead.  But I would think that this would be fairly static.  Also, as
> the
> reg's change, then only the piece that actually changes would need to be
> replaced.  This should also be considered - when it changes, is it easy to
> find out what parts actually changed?
>
> 2) My other thought was you might be able to create a single pdf and create
> "bookmarks".  But then I don't know how to open a pdf and jump directly to
> a
> given bookmark.
>
> --
> Richard DeShong, Athletic Study Center, UCBerkeley
>
>
> -----Original Message-----
> From: fmpexperts Beverly Voth
>
> Ah, Salman, now that helps to see what you want. You'd have to have
> "internal links" to the regulations. Perhaps the PDF would be a way to go.
> You can (with ADOBE) insert links to portions of a PDF document. Perhaps
> then you can preview with OPEN Url [ ]. But you'd need "local" reference to
> the document.
>
> If other means, you'd need to break apart the regulations and still need
> exteral versions of the document to pull up. Perhaps OLE. Let's see what
> the
> list has to say about this development (your WHY...)
> :)
>
> Beverly
>
> On 6/15/09 7:12 AM, "Salman Maidan" <[hidden email]> wrote in whole or
> in part:
>
> > I might well be going about this the wrong way, so your WHY question is
> very
> > useful indeed. Basically I have a huge word manual which is full of
> > regulations. I simply want to copy each regulation in a record of it own
> in
> > FMP database so it can be referenced easily by presenting the users with
> a
> > list of the regulation numbers in a portal, He/She click a button and
> open
> > the appropriate regulation.
> >
> > Now if I can leave the regulations in the word doc. and link to them that
> > will suite my purpose, however I would want the word document to open at
> the
> > appropriate page and the appropriate regulation, hence my copy and
> pasting
> > them in FMP. BUT if there is an easy way to do this then I am all ears.
> >
> > Salman
> >
> >
> > On Sun, Jun 14, 2009 at 10:28 PM, Beverly Voth <[hidden email]>
> wrote:
> >
> >> My question back is why? I mean what is the purpose of getting all that?
> >> Will you be pushing back out at some point? Why not into a container
> field?
> >> And you probably won't get the graphics, but what happens if the word
> >> document is saved as XML format? Would that get your "text"?
> >>
> >> --
> >> Beverly Voth
> >> mailto:[hidden email]
> >> tel:(606) 258-7399
> >> --
> >>
> >>
> >> On Jun 14, 2009, at 12:30 PM, Salman Maidan <[hidden email]> wrote:
> >>
> >>  Hi Experts,
> >>> WinXp - FMPA 10
> >>>
> >>> I am trying to copy contents of an MS word document which can contain
> >>> text,
> >>> graphics, and tables, and paste all that into FMP text field. However I
> >>> see
> >>> that graphics don't copy at all and tables only copy the content of the
> >>> table but not the outlines. I understand that is because text fields
> are
> >>> purely for text characters. I tried using a container field but too
> many
> >>> difficulties with scroll bar and if I am not mistaken size of file.
> >>>
> >>> My question: is there any way to overcome that and be able to copy all
> the
> >>> content as is. I know FMP is full of good tricks, but I don't know them
> >>> all.
> >>> ;-)
> >>>
> >>> Regards
> >>> --
> >>> Salman Maidan
> >>>
> >>
> >
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>



--
Salman Maidan
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
James McAlister

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
Though I don't know how to do it, Richard's #2 suggestion sounds like
a good way to go. If you can create a single PDF file from your Word
document with a table of contents (page numbers or reg numbers or
whatever makes sense) and make those "clickable," then the user will
be taken directly to the proper item. I have a number of manuals
created by others where I click on a page number in the table of
contents and am taken directly to that page. This way you might could
avoid FM completely and just deal with a single PDF file.

Just another wild idea FWIW. :)

James
www.james-mc.com



On Tue, Jun 16, 2009 at 9:49 AM, Salman Maidan<[hidden email]> wrote:
> still open to suggestions
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Salman Maidan-3

Re: Possibilities with a Text Field

Reply Threaded More More options
Print post
Permalink
In reply to this post by Beverly Voth-2
Hi,

Thanks you all, I finally managed to solve this one and have it working the
way I want it to, thanks to your input.

For those of you interested in the method, here is a summary of the setup:

Opened the large word document of regulations, add page breaks between
regulations (some can be many pages), print each regulation into its own PDF
document saved with regulation name, keep all in a folder.

In FMP, I used 360Works+Textractor-1.63 Demo to extract text from word into
a text field for the search.

Construct a portal to show all regulation names, clicking one adds the name
to the web viewer syntax including the path to the document and its name,
and walla, the appropriate PDF document is brought up on the web viewer very
nicely.

Now the reason I wanted all this in FMP is the search capability and the
flexibility all round where by I can view a group of regulation or all
regulations, and most of all relate different regulations to each other
because many of the regulations refer you to other regulations (sometimes
multiples) and its hard to do that on paper wheres on screen you can put the
related regulation on different tabs etc, etc.

The reason for PDF is being able to show the regulation with its original
formatting, tables and graphics.

So the background work is FMP, and the front view is PDF through web viewer.

Once again thank you all.

Regards

Salman
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au