WordPipe not replacing text in headers or footers

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

chris333
Posts: 3
Joined: Thu Dec 25, 2008 12:08 pm

WordPipe not replacing text in headers or footers

Postby chris333 » Thu Dec 25, 2008 12:17 pm

Trying to replace simple text in headers and footers of Word 2007 documents saved in .doc format (NOT .docx).

All other replacements are working fine, but all document headers and footers are untouched. I am using an import file for the search and replace conditions, and have tried both a simple two column CSV file, as well as the template CSV provided with the installation file set. Neither works.

Doesn't work whether or not I force the options to include headers or footers (although since I am using an import file, it throws an error about having to select a row. But if I exit out of the error, the option to include headers and footers stays clicked.) Again, doesn't matter if I do that or not.

Doesn't work if I try it against a single file, or a full set.

I am using the latest version of WordPipe Lite, available as of today, with a clean install.

chris333
Posts: 3
Joined: Thu Dec 25, 2008 12:08 pm

Re: WordPipe not replacing text in headers or footers

Postby chris333 » Fri Dec 26, 2008 5:23 am

Fortunately. I only have about four swap items for headers and footers, so I ran a second job by manually entering in the swaps using the "Use These Values" options, and manually indicating headers and footers. That worked.

Still, not quite sure it didn't work using a CSV.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: WordPipe not replacing text in headers or footers

Postby DataMystic Support » Mon Jan 05, 2009 8:56 am

Hi Chris,

The CSV file MUST include the extra columns, as the default for a 2 column CSV is for the Body only to be searched.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

chris333
Posts: 3
Joined: Thu Dec 25, 2008 12:08 pm

Re: WordPipe not replacing text in headers or footers

Postby chris333 » Sun Jan 11, 2009 2:14 am

Found the problem. In Excel, for the "Search Type" column, I had a formula which added all the options -- when I changed this to a integer (the actual sum presented as a number, not as a formula) the search and replace worked.

Guess my Excel knowledge worked against me that time.

So for future users, DON'T put a formula there, put the actual number!

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: WordPipe not replacing text in headers or footers

Postby DataMystic Support » Tue Jan 13, 2009 11:36 am

Thanks Chris - good point
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “WordPipe, ExcelPipe and PowerPointPipe Support”

Who is online

Users browsing this forum: No registered users and 1 guest