rone: (asplode)
[personal profile] rone

Repairing the Contacts Spreadsheet

This should be done every time before publishing

  • Copy the new REVSHARE_CONTACTS_<DATE>.xls to a Windows system

  • Open the file in Excel

  • Save file as a Tab Delimited (*.txt) format (answer "yes" to losing all the formatting- that's the whole point of doing this)

  • Close Excel

  • Re-open Excel

  • Import/open the  REVSHARE_CONTACTS_<DATE>.txt file

  • Save the file as an excel 97-2003 workbook.

This will create a file that should always validate and import correctly

Date: 2010-12-15 12:08 pm (UTC)
From: [identity profile] tinellaq.livejournal.com
I had a problem like that. It turned out that when I told my IDE to add a new directory to SVN, the local copy would end up with depth:none, causing no end of random-seeming trouble down the line. Fix was "svn up --set-depth infinity"

Profile

rone: (Default)
entombed in the shrine of zeroes and ones

December 2022

S M T W T F S
    123
45678910
11121314151617
18192021222324
252627282930 31

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 16th, 2025 02:51 pm
Powered by Dreamwidth Studios