421
preachur
Re: Porting an MS-Access database
  • 2006/11/30 14:45

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


The import_users_v1.1.zip works, but I don't think you'll need it if you use this:

http://www.mysql.com/downloads/api-myodbc.html

Just scroll down past the form and choose a mirror to download the program.

The instructions are here:

http://www.itc.virginia.edu/desktop/web/mysql/msaccess.html
Magick can never be restrained, but when freely given is thrice regained!



422
preachur
Re: Porting an MS-Access database
  • 2006/11/30 14:30

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


Wow!!! This will make my job so much easier. Now I can import the data through MS-Access. I imported the mySQL tables and then did one with link tables. WORKS GREAT. I can compare it to the old SQL and make it work. Thank you for asking that question and getting me curious. That opens up a whole new door.
Magick can never be restrained, but when freely given is thrice regained!



423
preachur
Re: Multi Sites Challenge
  • 2006/11/30 14:25

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


THANK YOU.

I just didn't want to mess with it unless I knew it could be done.
Magick can never be restrained, but when freely given is thrice regained!



424
preachur
Re: Porting an MS-Access database
  • 2006/11/30 13:36

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


You CAN sync mySQL with access. Just download the MyODBC ODBC Driver. http://www.mysql.com/downloads/api-myodbc.html
Magick can never be restrained, but when freely given is thrice regained!



425
preachur
Re: Porting an MS-Access database
  • 2006/11/30 13:22

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


Well, if you can find a module to do what you want, you could probably do what I did with a SQL database I imported data from: I opened it in Access, copied everything into Excel sheets, Saved them in CSV files, and then used this script to import them:

http://dev.xoops.org/modules/xfmod/project/?uniconvert

I have just been modifying it as I go. It was made for the user database, but it can be set up to fill in other tables too with a little code modification.

(It also works for user databases quite well, and comes with an example .csv file. If you follow the format it works perfectly.)

For users just edit the database and .CSV info, drop it in your base directory with the .CSV file, and run it.

For other tables just go through and change the tables and structure to suit your needs.

As for syncing with access? I don't know how that would work. Will access do link tables and import mySQL data? I know it will with SQL. I've never tried with mySQL. I have always just used phpMyAdmin to administrate my mySQL databases. Maybe I'll try access sometime. Might make converting structures easier, if it works.
Magick can never be restrained, but when freely given is thrice regained!



426
preachur
Re: Multi Sites Challenge
  • 2006/11/30 13:00

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


So, no one answered yet: multisite hack OR the multix. Do they work? Will one or the other do what I need them to do?
Magick can never be restrained, but when freely given is thrice regained!



427
preachur
Re: Multi Sites Challenge
  • 2006/11/30 8:06

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


That would be cool.... Especially from the main parent site.

I'll be happy if I can just get it set up so they can register and log in to all the sites with one user database. I have 9000+ users to import and then they will be able to log into all 4 of the sites with their original username and password. Once these sites go live there will be 15-20 new users per day and over 60,000 hits per day. I can't wait to see how it handles on XOOPS. The sooner I can get it out of .asp + SQL and into .php and mySQL the better.
Magick can never be restrained, but when freely given is thrice regained!



428
preachur
Re: Developing my own module? Or do it in perl?
  • 2006/11/30 6:25

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


I know of a perl forum system that plugs right into xoops. bbBoard. The module itself is pretty simple. The forum runs on a seperate database and you just configure one file and it plugs it right in. If you want to take a look at the module it might help you with a framework to plug in your own perl mods.

Download it here:
http://myworldexpo.com/ARICMS/bbv2-xoops-module.zip
Magick can never be restrained, but when freely given is thrice regained!



429
preachur
Re: Multi Sites Challenge
  • 2006/11/30 5:19

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


Hi Nekro,

I need to run 4 sites on the same user database. I just need users to be able to register once for all 4 sites.

Preachur
Magick can never be restrained, but when freely given is thrice regained!



430
preachur
Re: Yeah like where in Tarnation?????
  • 2006/11/30 2:24

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


Magick can never be restrained, but when freely given is thrice regained!




TopTop
« 1 ... 40 41 42 (43) 44 45 46 »



Login

Who's Online

74 user(s) are online (44 user(s) are browsing Support Forums)


Members: 0


Guests: 74


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits