i've found a migraine trigger
Dec. 13th, 2010 12:58 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
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
no subject
Date: 2010-12-13 09:00 pm (UTC)no subject
Date: 2010-12-13 09:08 pm (UTC)no subject
Date: 2010-12-13 09:11 pm (UTC)- Do Hokey Pokey
- Turn Self Around
no subject
Date: 2010-12-14 12:55 am (UTC)Came to find out that, when the client would ask for a webpage redesign, she'd pull up the webpage in IE, ctrl-A, open Word or Excel, shift-insert. And between IE and Office, they would dutifully OLE-encapsulate every object and every script on that page, all of which would look fine, until you saved the document and sent it to someone else.
This became the genesis of some of Huey's Rules for Life, notably:
- If you use Microsoft Excel as a word-processor, I will kill you with your own LCD panel, and
- Do not cut and paste webpages from Internet Explorer into Microsoft Word unless I am sure you know what you are doing. Note: this group does not currently include you, and is unlikely to include you at any point in the future.
no subject
Date: 2010-12-14 01:23 am (UTC)Install this (http://pypi.python.org/pypi/xlrd) and this (http://pypi.python.org/pypi/xlwt), and then use this:
no subject
Date: 2010-12-14 04:01 am (UTC)no subject
Date: 2010-12-14 06:02 am (UTC)no subject
Date: 2010-12-14 02:59 pm (UTC)no subject
Date: 2010-12-14 08:48 pm (UTC)My bete noir is subversion. I make its directories fucked up. No-one else believes this: it's my private curse.
no subject
Date: 2010-12-15 03:24 am (UTC)no subject
Date: 2010-12-15 12:08 pm (UTC)