phphelpdesk-help

[Phphelpdesk-help] converting database files to phphelpdesk

[Russ H. <web...@ps...>]

i have used a windows application for our helpdesk for 2 years now. i am
looking to migrate to phphelpdesk so we can access our helpdesk from
both windows and linux workstations (among other reasons).

the current windows software stores its records in an access database.
is it possible to drop the current database into the mysql database of
phphelpdesk so that we don't lose all the data we have collected over
the past 2 years?

sorry if this question is insane but i really need to find a way to not
lose info as well as migrate to a more scalable solution.

thanks,

-russ

Re: [Phphelpdesk-help] converting database files to phphelpdesk

[Matt G. <ma...@ma...>]

The trick would be mapping the fields in your access database to the fields 
in mysql.  Are you able to do that?  If so, just export the tables into a 
.txt or .csv file, and then import them into mysql.  I do not know how to 
import into mysql, does somebody else?
Matt

At 02:40 AM 2/17/2002 -0600, Russ Haskett wrote:


>i have used a windows application for our helpdesk for 2 years now. i am
>looking to migrate to phphelpdesk so we can access our helpdesk from
>both windows and linux workstations (among other reasons).
>
>the current windows software stores its records in an access database.
>is it possible to drop the current database into the mysql database of
>phphelpdesk so that we don't lose all the data we have collected over
>the past 2 years?
>
>sorry if this question is insane but i really need to find a way to not
>lose info as well as migrate to a more scalable solution.
>
>thanks,
>
>-russ
>
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

Re: [Phphelpdesk-help] converting database files to phphelpdesk

[Russ H. <web...@ps...>]

i don't know how but i can figure it out or possibly talk someone from
my LUG into helping me.I just wanted to know if it wass posssible.it
sounds like it is so i will download, install and start messing with it.
thanks for the quick reply. i really look forward to getting phphelpdesk
up and running.

thanks,

-russ



On Mon, 2002-02-18 at 14:43, Matt Grab wrote:
> The trick would be mapping the fields in your access database to the fields 
> in mysql.  Are you able to do that?  If so, just export the tables into a 
> .txt or .csv file, and then import them into mysql.  I do not know how to 
> import into mysql, does somebody else?
> Matt
> 
> At 02:40 AM 2/17/2002 -0600, Russ Haskett wrote:
> 
> 
> >i have used a windows application for our helpdesk for 2 years now. i am
> >looking to migrate to phphelpdesk so we can access our helpdesk from
> >both windows and linux workstations (among other reasons).
> >
> >the current windows software stores its records in an access database.
> >is it possible to drop the current database into the mysql database of
> >phphelpdesk so that we don't lose all the data we have collected over
> >the past 2 years?
> >
> >sorry if this question is insane but i really need to find a way to not
> >lose info as well as migrate to a more scalable solution.
> >
> >thanks,
> >
> >-russ
> >
> >
> >_______________________________________________
> >Phphelpdesk-help mailing list
> >Php...@li...
> >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
> 
> 
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

Re: [Phphelpdesk-help] converting database files to phphelpdesk

[Joseph R. H. <jo...@ne...>]

There are a couple of options that I can think of:

1)you can do mysqldump phphelpdesk > somefilename.sql

that'll dump the phphelpdesk database into a file for you.  Actually,
this is already done for you in a file that you use during the install
process.

2)you can setup an ODBC connection from your MS Access Box to the MySQL
box and just import the data from Access into the phphelpdesk MySQL
tables.

On Mon, 2002-02-18 at 12:43, Matt Grab wrote:
> The trick would be mapping the fields in your access database to the fiel=
ds=20
> in mysql.  Are you able to do that?  If so, just export the tables into a=
=20
> .txt or .csv file, and then import them into mysql.  I do not know how to=
=20
> import into mysql, does somebody else?
> Matt
>=20
> At 02:40 AM 2/17/2002 -0600, Russ Haskett wrote:
>=20
>=20
> >i have used a windows application for our helpdesk for 2 years now. i am
> >looking to migrate to phphelpdesk so we can access our helpdesk from
> >both windows and linux workstations (among other reasons).
> >
> >the current windows software stores its records in an access database.
> >is it possible to drop the current database into the mysql database of
> >phphelpdesk so that we don't lose all the data we have collected over
> >the past 2 years?
> >
> >sorry if this question is insane but i really need to find a way to not
> >lose info as well as migrate to a more scalable solution.
> >
> >thanks,
> >
> >-russ
> >
> >
> >_______________________________________________
> >Phphelpdesk-help mailing list
> >Php...@li...
> >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
>=20
>=20
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help