|
Managing Miva Merchant with Excel |
|
|
|
Page 1 of 6 Welcome to Your New Friend ... Excel
I'll be honest; I have a love/hate relationship with Excel. While it does some great things and has a lot of power, Microsoft misses a few critical things for people who also work with non-Windows programs.
Miva Merchant cannot import or export directly to the .xls format that Excel uses natively. Merchant uses text files. Unfortunately, the options for exporting text files from Excel stink. You can only output as TAB-delimited or CSV (Comma Separated Values). I prefer to use the | (pipe) character. Why? Because it is not used in 99.99% of your daily data needs. So it makes a great character to use to separate values. Commas and TABs are slightly riskier since they can be used by mistake to shift a set of data. Better to "pipe-up" and use |. But Excel cannot save a custom-delimited file, unlike its big-brother, MS Access.
So what do you do? You need a way to write the output of the spreadsheet the way you want. I finally found the answer on an Excel forum. I give full credit to Earl Kiosterud and major props for his simple and elegant Text Write Program as an easy (and FREE) solution to this oversight on the part of Redmond.
I will explain more about the Text Write Program its role later. First, let's tackle creating your store data.
|
Hosting Articles 