[ic] Nightmare-Please help

[Jeff Obranovich]

Thanks,
This is good information for the next time I dare try to use a spreadsheet,
but my big problem now is that my components won't load.  The files that
were restored from backup never made it to Excel.
I managed to get the site up and running, except for the fact that my
"Area's" were gone.  When I used auto-populate all of my components quit
loading.

Regards,
Jeff

-----Original Message-----
From: interchange-users-admin@icdevgroup.org
[mailto:interchange-users-admin@icdevgroup.org]On Behalf Of D Zhang -
msi
Sent: Wednesday, February 19, 2003 1:09 AM
To: interchange-users@icdevgroup.org
Subject: Re: [ic] Nightmare-Please help


----- Original Message -----
From: "Jeff Obranovich" <webmaster@midwest-entertainment.net>
To: <interchange-users@icdevgroup.org>
Sent: Tuesday, February 18, 2003 11:14 PM
Subject: [ic] Nightmare-Please help


> Background:
>
> running IC 4.9.3
> Cpanel (...I know)
>
> It started as, what I thought to be, a simple thing.  I wanted to download
> my products & inventory tables to an Excel spreadsheet so that I might
make
> several changes at once.  Downloading went fine, editing went fine,
> IMPORTING is where it all began...After several attempts, (various errors
> stating mismatched tables, despite the fact that I was importing the exact
> same file that I just exported) and with the "replace" box checked, I
> managed to import my new file.  However, none of the products that I had
> edited had been replaced.  Not only that, but the format of my NEW
products
> was entirely wrong.  Fortunately, I thought, I had only imported 73 items.
> So, I began to try and delete them from the AdminUI.  But, they refused to
> go!  No matter what I did, every time I "applied changes" they were back.
>
> So, I decided that it was time to download last nights backup from Cpanel
> and replace the products.txt file.  After which, IC went completely down.
> Then I tried restoring the whole products directory from backup.  It still
> didn't work.  Eventually I discovered that the permissions had been
changed
> for the products.txt during backup.  Hooray...The sites back up.  But now,
> my navigation "area's" are gone.  So, I go to the Layout Editor, hit
> auto-populate...there they are, excellent!  Apply changes and......ALL OF
> THE COMPONENTS ON MY PAGES ARE GONE.  The template is still set correctly
> and all the files are there, but none of my components will load.
>
> If anyone can help, it would be greatly appreciated.
>
> Thanks,
>
> Jeff Obranovich
>

Quite possibly it's neither cpanel, nor interchange's fault, but microsoft.

When export txt file form Excel, fields are quoted, leading 0s are deleted
(causes trouble if you handle userdb txt file, or if there is leading 0 in
your sku).

Examing your txt files and see if there are " " around each fields. If so,
you can still use those files.
Do the following;

1   Load them into Access.
    Remanber to select first line as field name,
    specify every field as text.

2  Then, export text file (from Access),

in the first screen, select --Delimited--.

In the second screen,

a    select Tab as delimiter
b    check the box include Fields Name
c.   select {none}   for Text qualifier

and next as usual.

Remember to add leading 0 before export if they were through out by Excel.

Repeat 1 and 2 over every files touched by Excel.

3. upload the files,

4. change permision,

and try again.

Hope this can help.


David
dzhang@msihosting.com
http://www.msihosting.com
Expert -- ecommerce solution, interchange hosting.



_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users