Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PSiGate XML module -- special transaction table


multibeatrecords

Recommended Posts

the ReadMe that comes with the PSiGate_XML_osc module instructs:

 

=====

Run the attached SQL file 'psigate_xml_sql.sql' via a tool like phpMyAdmin

=====

 

I understand this to mean, "install the database archive into your osC database".

 

This .sql archive contains a single table used for logging the XML transactions with PSiGate.

 

This table needs to be imported into the main store catalog database.

 

I'm using MySQL 3.23.58.

 

How do i import the table from this sql file into my mbr_store DB ?

 

ISP says go to PHPmyAdmin to the Query Window, but that import seems to be only for .txt file import.

 

There doesn't seem to be any "sql archive table import from ext file" feature (or similar) in mysql 3.23.58

 

Does "run" mean something else? Do I need to execute the .sql archive?

 

Will I need to import this table to my db from the unix/mysql command line?

 

If so, roughly how?

 

Thoughts? Procedures?

 

I have combed the osC forum to no avail. Please help!

 

Thanks!

Link to comment
Share on other sites

=====

Run the attached SQL file 'psigate_xml_sql.sql' via a tool like phpMyAdmin

=====

 

I'm going to answer myself here for future folks with same question:

 

- get a text editor

- copy the contents of 'psigate_xml_sql.sql'

- log yourself into your shop mysql database (using phpmyadmin) so you can see your list of tables

- choose SQL

- paste in the contents

- hit "Go" button

- table should be created

 

 

 

:blush:

Link to comment
Share on other sites

=====

Run the attached SQL file 'psigate_xml_sql.sql' via a tool like phpMyAdmin

=====

 

I'm going to answer myself here for future folks with same question:

 

- get a text editor

- copy the contents of 'psigate_xml_sql.sql'

- log yourself into your shop mysql database (using phpmyadmin) so you can see your list of tables

- choose SQL

- paste in the contents

- hit "Go" button

- table should be created

 

 

 

:blush:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...