RE: [ACFUG Discuss] Re: cfspreadsheet etc. question

[Charlie Arehart]

Thanks for the update, and not to be antagonistic but it's still not clear.
:-) Are you saying you reverted back to CF9? Or stayed on 10 by changing
your datetimeformat references (a new function in CF10, which for most is a
godsend, but was an incompatibility for you)?

Either way, whether on 9 or 10, there are updates that must be done, and if
you (or someone) didn't do them, or may even have done them wrong, that's
still a possible explanation. So we need to know what update you are at. If
you're on CF10, just look at the CF Admin system info page's "update level".
If you're on CF9 or earlier, sadly it's not that simple but I offered a link
below that told how to find out your "real" update level on those releases.

Finally, separate from that, I had proposed that you might want to share
some simple code (a complete, self-contained template) that showed what you
want to work. Maybe one of us would run it and say "yes, it does work as
expected", which would perhaps confirm it's some config issue on your end.
(Even if not updates, perhaps it's something different in your CF Admin, or
application.cfc/cfm). But please do check and report the update level also,
thanks.

As always, just trying to help.

/charlie

 

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jeff Howard
Sent: Sunday, March 16, 2014 7:24 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Re: cfspreadsheet etc. question

 

Yeah, well funny thing about that. I contacted the hosting company (that I
really want to say and dog right now but am refraining) to migrated to a
CF10 server. What was discussed was that they would migrated the site and
let me test before updating the DNS. Unfortunately, that is not how it
worked out and while trying to work on this the entire site went down
because I had a UDF that I've used for years called DateTimeFormat. It is
all over my code and as I'm sure you understand, it didn't work out that
well. So, I did try to update and test but ended up frantically trying to
get the site back up and running.

 

I was following up because I know that what I'm trying to do I did years ago
working for another company and it was fairly simple (though lengthy code).
It was 3rd party UDF but worked. I'm almost wondering if I may need to
create the entire spreadsheet with CF including formulas, etc.

 

On Sun, Mar 16, 2014 at 5:07 PM, Charlie Arehart 
wrote:

Jeff, while you await a reply from anyone, and while you did reply kindly to
my last note, you didn't really answer what I had asked: are you confirming
you have the LATEST UPDATES installed for whatever version of CF you have?
You want to rule that out before assuming it just can't work as you are
trying.

/charlie

 

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jeff Howard
Sent: Sunday, March 16, 2014 1:55 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Re: cfspreadsheet etc. question

 

Still hoping that someone out there has some insight on this. Does anyone
have their own functions for writing to spreadsheets that may not trigger
this error?

 

On Fri, Mar 14, 2014 at 1:04 PM, Jeff Howard  wrote:

I have tried all sorts of workarounds for this issue. I just tried splitting
the excel workbook into two separate workbooks and then combining them in
the last step and I keep getting the same error when trying to add the
second sheet to the workbook.

 

Anyone ever had this issue and know how to resolve it?

 

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator. 


The following information is meant for the website developer for debugging
purposes. 



Error Occurred While Processing Request 




An exception occurred while using action=update. 

 


org.apache.poi.POIXMLException:
org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with
the name '/xl/drawings/drawing2.xml' already exists : Packages shall not
contain equivalent part names and package implementers shall neither create
nor recognize packages with equivalent part names. [M1.12] 


 



Resources: 

*   Enable Robust Exception Information to provide greater detail about
the source of errors. In the Administrator, click Debugging & Logging >
Debug Output Settings, and select the Robust Exception Information option.
*   Check the   ColdFusion
documentation to verify that you are using the correct syntax.
*   Search the   Knowledge Base
to find a solution to your problem.



Browser  

Mozilla/5.0 (Windows NT 6.1; WOW64; rv:27.0) Gecko/20100101 Firefox/27.0


Remote Address  

108.73.189.89


Referrer  

http://dunwoodylabs.com/office/loginForm.cfm


Date/Time  

14-Mar-14 11:58 AM

 

On Thu, Mar 13, 2014 at 11:25 PM, Jeff Howard  wrote:

I'm using CF 9 to try and create a spreadsheet from a template. The
spreadsheet has 2 sheets, 1 that has charts on it, 2 contains the data used
to create the

Re: [ACFUG Discuss] Re: cfspreadsheet etc. question

[Dawn Hoagland]

FWIW - it's been a while - but I had issues using the pure CF
implementation of POI for several things.  I started doing my spreadsheet
manipulation in pure java\POI - and loaded the later, FULL POI in order to
it (using javaloader).

I wish I could give you examples, but it's been a couple of years since
I've messed with it.


On Mon, Mar 17, 2014 at 2:19 PM, Charlie Arehart wrote:

> Thanks for the update, and not to be antagonistic but it's still not
> clear. :-) Are you saying you reverted back to CF9? Or stayed on 10 by
> changing your datetimeformat references (a new function in CF10, which for
> most is a godsend, but was an incompatibility for you)?
>
> Either way, whether on 9 or 10, there are updates that must be done, and
> if you (or someone) didn't do them, or may even have done them wrong,
> that's still a possible explanation. So we need to know what update you are
> at. If you're on CF10, just look at the CF Admin system info page's "update
> level". If you're on CF9 or earlier, sadly it's not that simple but I
> offered a link below that told how to find out your "real" update level on
> those releases.
>
> Finally, separate from that, I had proposed that you might want to share
> some simple code (a complete, self-contained template) that showed what you
> want to work. Maybe one of us would run it and say "yes, it does work as
> expected", which would perhaps confirm it's some config issue on your end.
> (Even if not updates, perhaps it's something different in your CF Admin, or
> application.cfc/cfm). But please do check and report the update level also,
> thanks.
>
> As always, just trying to help.
>
> /charlie
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jeff
> Howard
> *Sent:* Sunday, March 16, 2014 7:24 PM
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] Re: cfspreadsheet etc. question
>
>
>
> Yeah, well funny thing about that. I contacted the hosting company (that I
> really want to say and dog right now but am refraining) to migrated to a
> CF10 server. What was discussed was that they would migrated the site and
> let me test before updating the DNS. Unfortunately, that is not how it
> worked out and while trying to work on this the entire site went down
> because I had a UDF that I've used for years called DateTimeFormat. It is
> all over my code and as I'm sure you understand, it didn't work out that
> well. So, I did try to update and test but ended up frantically trying to
> get the site back up and running.
>
>
>
> I was following up because I know that what I'm trying to do I did years
> ago working for another company and it was fairly simple (though lengthy
> code). It was 3rd party UDF but worked. I'm almost wondering if I may need
> to create the entire spreadsheet with CF including formulas, etc.
>
>
>
> On Sun, Mar 16, 2014 at 5:07 PM, Charlie Arehart 
> wrote:
>
> Jeff, while you await a reply from anyone, and while you did reply kindly
> to my last note, you didn't really answer what I had asked: are you
> confirming you have the LATEST UPDATES installed for whatever version of CF
> you have? You want to rule that out before assuming it just can't work as
> you are trying.
>
> /charlie
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jeff
> Howard
> *Sent:* Sunday, March 16, 2014 1:55 PM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] Re: cfspreadsheet etc. question
>
>
>
> Still hoping that someone out there has some insight on this. Does anyone
> have their own functions for writing to spreadsheets that may not trigger
> this error?
>
>
>
> On Fri, Mar 14, 2014 at 1:04 PM, Jeff Howard  wrote:
>
> I have tried all sorts of workarounds for this issue. I just tried
> splitting the excel workbook into two separate workbooks and then combining
> them in the last step and I keep getting the same error when trying to add
> the second sheet to the workbook.
>
>
>
> Anyone ever had this issue and know how to resolve it?
>
>
>
> The web site you are accessing has experienced an unexpected error.
> Please contact the website administrator.
>
> The following information is meant for the website developer for debugging
> purposes.
>
> Error Occurred While Processing Request
>  An exception occurred while using action=update.
>
>
>
> org.apache.poi.POIXMLException:
> org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with
> the name '/xl/drawings/drawing2.xml' already exists : Packages shall not
> contain equivalent part names and package implementers shall neither create
> nor recognize packages with equivalent part names. [M1.12]
>
>
>
> Resources:
>
>- Enable Robust Exception Information to provide greater detail about
>the source of errors. In the Administrator, click Debugging & Logging >
>Debug Output Settings, and select the Robust Exception Information option.
>- Check the ColdFusion documentation to 
> verify that you are using t

Re: [ACFUG Discuss] Re: cfspreadsheet etc. question

[Jason Delmore]

I think you are reading the whole sheet in when you use CFSPREADSHEET and
essentially setting the pointer to sheet 2 with the second CFSPREADSHEET
line.  So you are trying to overwrite the existing spreadsheet with the
same objects and CF doesn't like that.

Maybe you should try something like this (I haven't touched CFSPREADSHEET
so I could be way off)










 

 








I did CFXL using POI a number of years back.  It's on riaforge.  If nothing
else, looking at the code may give you some inspiration if you decide to
delve into POI.

Best wishes,
Jason


On Mon, Mar 17, 2014 at 8:24 PM, Dawn Hoagland wrote:

> FWIW - it's been a while - but I had issues using the pure CF
> implementation of POI for several things.  I started doing my spreadsheet
> manipulation in pure java\POI - and loaded the later, FULL POI in order to
> it (using javaloader).
>
> I wish I could give you examples, but it's been a couple of years since
> I've messed with it.
>
>
> On Mon, Mar 17, 2014 at 2:19 PM, Charlie Arehart wrote:
>
>> Thanks for the update, and not to be antagonistic but it's still not
>> clear. :-) Are you saying you reverted back to CF9? Or stayed on 10 by
>> changing your datetimeformat references (a new function in CF10, which for
>> most is a godsend, but was an incompatibility for you)?
>>
>> Either way, whether on 9 or 10, there are updates that must be done, and
>> if you (or someone) didn't do them, or may even have done them wrong,
>> that's still a possible explanation. So we need to know what update you are
>> at. If you're on CF10, just look at the CF Admin system info page's "update
>> level". If you're on CF9 or earlier, sadly it's not that simple but I
>> offered a link below that told how to find out your "real" update level on
>> those releases.
>>
>> Finally, separate from that, I had proposed that you might want to share
>> some simple code (a complete, self-contained template) that showed what you
>> want to work. Maybe one of us would run it and say "yes, it does work as
>> expected", which would perhaps confirm it's some config issue on your end.
>> (Even if not updates, perhaps it's something different in your CF Admin, or
>> application.cfc/cfm). But please do check and report the update level also,
>> thanks.
>>
>> As always, just trying to help.
>>
>> /charlie
>>
>>
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jeff
>> Howard
>> *Sent:* Sunday, March 16, 2014 7:24 PM
>> *To:* discussion@acfug.org
>> *Subject:* Re: [ACFUG Discuss] Re: cfspreadsheet etc. question
>>
>>
>>
>> Yeah, well funny thing about that. I contacted the hosting company (that
>> I really want to say and dog right now but am refraining) to migrated to a
>> CF10 server. What was discussed was that they would migrated the site and
>> let me test before updating the DNS. Unfortunately, that is not how it
>> worked out and while trying to work on this the entire site went down
>> because I had a UDF that I've used for years called DateTimeFormat. It is
>> all over my code and as I'm sure you understand, it didn't work out that
>> well. So, I did try to update and test but ended up frantically trying to
>> get the site back up and running.
>>
>>
>>
>> I was following up because I know that what I'm trying to do I did years
>> ago working for another company and it was fairly simple (though lengthy
>> code). It was 3rd party UDF but worked. I'm almost wondering if I may need
>> to create the entire spreadsheet with CF including formulas, etc.
>>
>>
>>
>> On Sun, Mar 16, 2014 at 5:07 PM, Charlie Arehart 
>> wrote:
>>
>> Jeff, while you await a reply from anyone, and while you did reply kindly
>> to my last note, you didn't really answer what I had asked: are you
>> confirming you have the LATEST UPDATES installed for whatever version of CF
>> you have? You want to rule that out before assuming it just can't work as
>> you are trying.
>>
>> /charlie
>>
>>
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jeff
>> Howard
>> *Sent:* Sunday, March 16, 2014 1:55 PM
>> *To:* discussion@acfug.org
>> *Subject:* [ACFUG Discuss] Re: cfspreadsheet etc. question
>>
>>
>>
>> Still hoping that someone out there has some insight on this. Does anyone
>> have their own functions for writing to spreadsheets that may not trigger
>> this error?
>>
>>
>>
>> On Fri, Mar 14, 2014 at 1:04 PM, Jeff Howard  wrote:
>>
>> I have tried all sorts of workarounds for this issue. I just tried
>> splitting the excel workbook into two separate workbooks and then combining
>> them in the last step and I keep getting the same error when trying to add
>> the second sheet to the workbook.
>>
>>
>>
>> Anyone ever had this issue and know how to resolve it?
>>
>>
>>
>> The web site you are accessing has experienced an unexpected error.
>> Please contact the website administrator.
>>
>> The following information is meant for the website developer for
>> debugging purposes.
>>
>> Error Occurred While Processing Request
>>  A