Re: [mv] [IC] Import Ascii-MySql via UI

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting Rob Zimmerman (rob@readysite.net):
> 
> So far so good, am converting a MV3.12/DB_File store to an IC4.5.5/MySql 
> store. I took my copied version of a 3.12 products.asc file renamed it to 
> test.txt and ran the Table Import feature from InterChanges admin UI. 
> Appeared to go fine, only it does not show up as a new table in the 
> test_simple database. It does show up as a nice "'variable.add" file under the 
> products directory though. I restarted the catalog.cfg with no errors as well. I 
> am using WebMin as an html gateway to MySql. Dam,shit...F&^%...----see 
> next paragraph.......
> 
> Well I just discovered something, I did this all wrong but I have learned 
> something. It jammed everything that had a "like table field" into the 
> products.sql file as that was highlighted when I imported. Looks like I need to 
> create the table "test.sql" with the correct fields to match my ascii file THEN 
> import to that database. DOH......
> 
> It also appears that the only way to add a new field to the table "products" is 
> to to that through mysql and not interchange correct?

Not the only way. But it is easy in MySQL:

    mysql> alter table products add column somecol char(32);

Then "Apply Changes" (do a reconfig or restart). You should probably
then export the table to the default file to get the text file in sync
with the database.

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.8220 fax 7501 <heins@akopia.com>

Friends don't let friends use Outlook. -- Bob Blaylock
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list