Need to change password in xls file.

[sboyd]

I have an infopath form that is published to a SharePoint document
libray. I need to change the password in the xls file. What is the
best way to do this? I didn't want to have to go thru the form and
make new connections. I've tried that and I'm loosing information
between the main submit location and the SharePoint location.

I was under the impression I just can't edit the file in notepad and
resave it without having to do something else.

Thanks

 

[Gavin McKay]

Hello,

You've mentioned "XLS" file, do you mean Excel? I'm not sure what password
you need to change via the form. Is there an Excel file as an attachment
within your form?

Gavin.

 

[sboyd]

I have an infopath form that is published to a SharePoint document
libray.  I need to change the password in the xls file.  What is the
best way to do this?  I didn't want to have to go thru the form and
make new connections.   I've tried that and I'm loosing information
between the main submit location and the SharePoint location.

I was under the impression I just can't edit the file in notepad and
resave it without having to do something else.

Thanks

My mistake. I'm editing the manifest.xsf and I actually got it
figured out yesterday. It took all day but I did with MakeCab and a
long sheet of instructions that were about 1/2 complete. It's easy
after you figue it out the first time.

 

[Gavin McKay]

Glad you got it sorted! If you have any time at all would you mind posting
what you did? I'm assuming the Excel spreadsheet was a part of the InfoPath
template?

Editing InfoPath templates manually is a bit of a black art, and the more
people know about it the better - it's practically a requirement if you want
to do any advanced InfoPath template work!

Thanks!

Gavin.

 

[sboyd]

Glad you got it sorted!  If you have any time at all would you mind posting
what you did?  I'm assuming the Excel spreadsheet was a part of the InfoPath
template?

Editing InfoPath templates manually is a bit of a black art, and the more
people know about it the better - it's practically a requirement if you want
to do any advanced InfoPath template work!

Thanks!

Gavin.
--
InfoPath Knowledge Basehttp://www.infopathkb.com/
2B | !2B






- Show quoted text -

I followed these directions and created my folders just like these so
it would be easier to do. You have to make sure you get all of the
files in your source file or the command line doesn't work. This
didn't have anything to do with an Excel file but the manifest file.
It would seem you could just edit and resave but nothing is that
simple.

Step 1.Save as Source files to a folder say c:\DTF

Step 2 : Go to manifest.xsf and edit it. (using notepad)

Step 3 :

For repacking we use MakeCab.exe located in c:\windows\system32

Step 4 :


In the same folder c:\DTF. Create a txt file called directives.txt
(using notepad) and

Copy this code in the file:
;************************************************************

; MSDN Sample Source Code MakeCAB Directive file example

;************************************************************

.OPTION EXPLICIT

;*****************************************************************

; change the value of the caninet name for example myInfoPath.xsn

;******************************************************************

.Set CabinetNameTemplate=FlightLogForm.XSN

;*************************************************************************************************************

; change the value of the Disk Directory Template value to the
directory you want to store the xsn file into,,

;*************************************************************************************************************

.set DiskDirectoryTemplate="C:\DTF"

.Set Cabinet=on

.Set Compress=on

;*******************************************************

; Just List All the files that are in the extracted folder to be
added in the xsn file

;*******************************************************


"C:\DTF\manifest.xsf"

"C:\DTF\myschema.xsd"

"C:\DTF\schema1.xsd"

"C:\DTF\schema2.xsd"

"C:\DTF\schema.xsd"

"C:\DTF\v_cust_projects_segments3.xsd"

"C:\DTF\v_Flight_Log_Airport2.xsd"

"C:\DTF\v_Flight_Log_Charges_offline.xml"

"C:\DTF\v_customer_main_offline.xml"

"c:\DTF\v_Flight_Log_Engines.xsd"

"C:\DTF\v_Flight_Log_Positions_offline.xml"

"C:\DTF\v_FlightLog_UserList.xsd"

"C:\DTF\script.vbs"

"C:\DTF\v_cust_Projects_Segments_offline.xml"

"C:\DTF\V_Delays2.xsd"

"C:\DTF\v_Flight_Log_Airport3.xsd"

"C:\DTF\v_Flight_Log_EndHobbs1.xsd"

"C:\DTF\v_Flight_Log_Engines_offline.xml"

"C:\DTF\v_FlightLog_Aircraft2.xsd"

"C:\DTF\v_Project_Pay_Hazard1.xsd"

"C:\DTF\Main2.xsl"


"C:\DTF\template.xml"

"c:\DTF\v_Customer_Main1.xsd"

"C:\DTF\V_Delays3.xsd"

"C:\DTF\v_Flight_Log_Charges1.xsd"

"c:\DTF\v_Flight_Log_EndHobbs.xsd"

"C:\DTF\v_Flight_Log_Positions2.xsd"

"C:\DTF\v_FlightLog_Aircraft3.xsd"

"C:\DTF\v_Project_Pay_Hazard.xsd"

"C:\DTF\v_cust_Projects_Segments2.xsd"

"C:\DTF\v_Customer_Main.xsd"

"C:\DTF\V_Delays_offline.xml"

"C:\DTF\v_Flight_Log_Charges.xsd"

"C:\DTF\v_Flight_Log_Engines1.xsd"

"C:\DTF\v_Flight_Log_Positions3.xsd"

"C:\DTF\v_FlightLog_UserList1.xsd"

"C:\DTF\v_Project_Pay_Hazard_offline.xml"

"C:\DTF\CustomPrintStyle.css"

"C:\DTF\sampledata.xml"

"C:\DTF\winter.jpg"

;*********************

; End of the File

;*********************

Step 5 :
In the above file set cabinetnametemplate give the name of the output
file (FlightLogForm.xsn)
In the Set diskdirectorytemplate give the correct output path say c:
\DTF
Make sure all the extracted files are listed here

Step 6:

Save your file. And open the command prompt (CMD).

C:\windows\system32\MakeCab /f c:\DTF\directives.txt

 

[Gavin McKay]

Wow that is certainly not straight-forward! Thankyou for posting that

Gavin.