PDA

View Full Version : Importing woes...

Luke
10-30-06, 08:50 PM
I've always been pretty happy with MIVA 5's "import from flat file" capability. One thing that has always bothered me though is that when I import products with descriptions, some of the descriptions get quoted while others do not. So I end up with an inconsistant format of description in my store. My questions is... has anybody else experienced this? I assume a certain character is the culprit, but is this a problem with the MIVA software, or is there maybe something I can do in excel to fix this issue? Thanks guys.
Vic - WolfPaw Computers
10-30-06, 09:04 PM
The issue is not with Merchant, but with Excel.

Save the file as a csv file and strip out the extra quotes and save, then import.
Maxer
10-31-06, 12:59 AM
Would the same apply to M-IV as well?
Vic - WolfPaw Computers
10-31-06, 01:02 AM
Yes, since its a known issue with Excel, not Merchant.

Would the same apply to M-IV as well?
Maxer
11-10-06, 06:48 PM
The issue is not with Merchant, but with Excel.

Save the file as a csv file and strip out the extra quotes and save, then import.

Import as a cv or save it to a .txt file after saving it to a CV?
Vic - WolfPaw Computers
11-10-06, 07:01 PM
Either way. The format is text, just the delimiter is changing.

Merchant doesn't care if its .txt, .csv, .dat, .prn etc. As long as you tell it what delimiter you are using.

Personally, I prefer the pipe character | over anything else.
Maxer
11-10-06, 07:02 PM
Thanks Vic
Maxer
11-10-06, 07:06 PM
I guess it is the procedure for clearing the quotes that is confusing me.
Vic - WolfPaw Computers
11-10-06, 07:08 PM
Try our knowledge base article on this issue:
http://www.wpcomp.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=6&nav=0
Maxer
11-11-06, 06:02 PM
Awesome Vic. That was clear as a bell...
Thanks you!