Import from 3.0 standalone in order to get access to database

I have an application that uses FM Pro runtime 3.0. It contains some
information that I need to access and import into any other database
that is easily accessible. Access, MySQL, MSSQL. This application does
not support any export operations but to single pdf files which would
be impossible to use since there are about 6000 records.

is there any tool or other way that can do the job. provide export
functionality from a runtime file to FM-Pro, Access or any other DB?

I am not very familiar with the entire concept of FM runtime.

Thank you

Re: Import from 3.0 standalone in order to get access to database

schrieb im Newsbeitrag
news:1188384601.091708.92600@o80g2000hse.googlegroups.com...
>I have an application that uses FM Pro runtime 3.0. It contains some
> information that I need to access and import into any other database
> that is easily accessible. Access, MySQL, MSSQL. This application does
> not support any export operations but to single pdf files which would
> be impossible to use since there are about 6000 records.
>
> is there any tool or other way that can do the job. provide export
> functionality from a runtime file to FM-Pro, Access or any other DB?
>
> I am not very familiar with the entire concept of FM runtime.
>
> Thank you


Jan,

For a non-Filemaker solution to this problem / if everything else fails: You
could write a batch file/macro (e.g. by using AutoIt
http://www.autoitscript.com/autoit3 ) that catches the content of each and
every field of each and every record with an OCR screenreader (like
"Screenshot" included in FineReader 8
http://www.abbyy.com/finereader8/?param=44782#f8 ) and piecemeal-wise "drop"
all the data somewhere else / into an editable receptacle (Excel, Word, a
database, whatever). It would take some time to catch all the data but the
computer can do that during its nightshift.

---
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
p/o\s/t atsign ohnotekstotaaloh nocom
Leave out: \ / oh no
---
>

Re: Import from 3.0 standalone in order to get access to database

On 29 Aug., 15:37, "Christoph Bouthillier"
wrote:
> schrieb im Newsbeitragnews:1188384601.091708.92600@o80g2000hse.googlegr oups.com...
>
> >I have an application that uses FM Pro runtime 3.0. It contains some
> > information that I need to access and import into any other database
> > that is easily accessible. Access, MySQL, MSSQL. This application does
> > not support any export operations but to single pdf files which would
> > be impossible to use since there are about 6000 records.
>
> > is there any tool or other way that can do the job. provide export
> > functionality from a runtime file to FM-Pro, Access or any other DB?
>
> > I am not very familiar with the entire concept of FM runtime.
>
> > Thank you

Thanks for your quick reply,

>
> Jan,
>
> For a non-Filemaker solution to this problem / if everything else fails: You
> could write a batch file/macro (e.g. by using AutoIthttp://www.autoitscript.com/autoit3) that catches the content of each and
> every field of each and every record with an OCR screenreader (like
> "Screenshot" included in FineReader 8http://www.abbyy.com/finereader8/?param=44782#f8) and piecemeal-wise "drop"
> all the data somewhere else / into an editable receptacle (Excel, Word, a
> database, whatever). It would take some time to catch all the data but the
> computer can do that during its nightshift.
>

this looks a bit, too difficult for my skills. Is there no other way
to reach the data inside the programm?
thanks anyway :)

Jan

Re: Import from 3.0 standalone in order to get access to database

schreef in bericht
news:1188396047.668547.51600@y42g2000hsy.googlegroups.com...
> On 29 Aug., 15:37, "Christoph Bouthillier"
> wrote:
>> schrieb im
>> Newsbeitragnews:1188384601.091708.92600@o80g2000hse.googlegr oups.com...
>>
>> >I have an application that uses FM Pro runtime 3.0. It contains some
>> > information that I need to access and import into any other database
>> > that is easily accessible. Access, MySQL, MSSQL. This application does
>> > not support any export operations but to single pdf files which would
>> > be impossible to use since there are about 6000 records.
>>
>> > is there any tool or other way that can do the job. provide export
>> > functionality from a runtime file to FM-Pro, Access or any other DB?
>>
>> > I am not very familiar with the entire concept of FM runtime.
>>
>> > Thank you
>
> Thanks for your quick reply,
>
>>
>> Jan,
>>
>> For a non-Filemaker solution to this problem / if everything else fails:
>> You
>> could write a batch file/macro (e.g. by using
>> AutoIthttp://www.autoitscript.com/autoit3) that catches the content of
>> each and
>> every field of each and every record with an OCR screenreader (like
>> "Screenshot" included in FineReader
>> 8http://www.abbyy.com/finereader8/?param=44782#f8) and piecemeal-wise
>> "drop"
>> all the data somewhere else / into an editable receptacle (Excel, Word, a
>> database, whatever). It would take some time to catch all the data but
>> the
>> computer can do that during its nightshift.
>>
>
> this looks a bit, too difficult for my skills. Is there no other way
> to reach the data inside the programm?
> thanks anyway :)
>
> Jan
>

IF this solution is not password protected you just have to rename the main
filemaker file (currently *.usr, but I don't remember if this was already
there with V3) into *.fp3. You will then be able to open the file with
filemaker, or convert it to a higher version.

If it is password protected you might try to create an empty table that has
the field you want. PLUS one extra field. Use this extra field to establish
a relationship. Hopefully your file does have an ID or some other field you
might be able to link. Then fill your extra field with the exact ID's that
you neeed and you can import the data you need. This is not guaranteed to
work, but you just might be in luck, I have managed once...

Keep well, Ursus

Re: Import from 3.0 standalone in order to get access to database

jancha...@googlemail.com wrote:
> I have an application that uses FM Pro runtime 3.0. It contains some
> information that I need to access and import into any other database
> that is easily accessible. Access, MySQL, MSSQL. This application does
> not support any export operations but to single pdf files which would
> be impossible to use since there are about 6000 records.
>
> is there any tool or other way that can do the job. provide export
> functionality from a runtime file to FM-Pro, Access or any other DB?
>
> I am not very familiar with the entire concept of FM runtime.
>
> Thank you


Have you tried opening the file in Filemaker? If you have and you
don't have the permissions (password) to access an account that allows
you to export, your best bet may be to contact the original
programmer.

G

Re: Import from 3.0 standalone in order to get access to database

Problem is solved.

I used some password recovery tool to get the account which has export
rights.
all worked out find.

thanks for all your help