XML error
biz7
in xml. I open the xml in Internet Explorer & then right click/select view
source & it brings up notepad where I edit. Then I import as xml into the
application.
I get an error: " the object is currenly nothing". The code is correct as I
checked it agaist the export. I have imported a few line items & it works.
Some line items give me the error mentioned & some do not.
Can you advise what the cause may be as I mentioned the xml code is correct.
I also noticed that when I open the 1st export (see XML export file below)
it allows me to see it in Internet Explorer as below & I follow the same code
to import. However, please read further...
XML export file:
- <ExportEdits>
- <tblScenarioData>
<Row Key1="ABERD 2008-1A" Key2="" Key3="" Key4="" Key5=""
Attribute="SICMoodyCode" TableName="tblIssuer" AttributeValue="1"
DataType="3" OverWrite="1" Active="1" />
<Row Key1="ABERD 2008-1A" Key2="" Key3="" Key4="" Key5=""
Attribute="SICSPCode" TableName="tblIssuer" AttributeValue="1" DataType="3"
OverWrite="1" Active="1" />
</tblScenarioData>
<tblAdjustedFieldsX />
<tblAmortizationAdjustmentsX />
<tblAssetsX />
<tblAmortizationsX />
<tblCounterInstitutionsX />
<tblCountryX />
<tblDiversityScoreX />
<tblGlobalVariableX />
<tblIssuerX />
<tblLedgerAccountsX />
<tblLendingX />
<tblLiabilityInterestX />
<tblLiabilityOutstandingX />
<tblParticipationsX />
<tblPriorityCategoryX />
<tblPurchasesX />
<tblRatingsX />
<tblSellsX />
<tblSICX />
<tblTableBasedItemsX />
<tblTransactionsX />
<tblWeightedAvgLifeSchdX />
<tblAdjustmentsX />
<tblHolidaysX />
<tblCurrencyX />
<tblAccrualX />
<tblCMPDistributionScheduleX />
<tblUDFData />
</ExportEdits>
-----------
However, when I update the code that results in the error, it will open in
Internet Explorer as :
""The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later. ""
Whitespace is not allowed at this location. Error processing resource
'file:///C:/Documents and Settings/RB/INTERFACE/...
<ExportEdits><tblScenarioData><Row Key1="ABERD 2008-1A" Key2="" Key3=""
Key4="" Key5="" Attribute="SICMoodyC...
================================
Martin Honnen
> I am trying to automate data entry on a work application where the export is
> in xml. I open the xml in Internet Explorer & then right click/select view
> source & it brings up notepad where I edit. Then I import as xml into the
> application.
>
> I get an error: " the object is currenly nothing". The code is correct as I
> checked it agaist the export. I have imported a few line items & it works.
> Some line items give me the error mentioned & some do not.
>
> Can you advise what the cause may be as I mentioned the xml code is correct.
Which application is that where you import the XML? How exactly do you
do that, post the code if "trying to automate" means you are writing
code to do that.
> I also noticed that when I open the 1st export (see XML export file below)
> it allows me to see it in Internet Explorer as below & I follow the same code
> to import. However, please read further...
>
>
> XML export file:
> - <ExportEdits>
> - <tblScenarioData>
The '-' character is not allowed before the root element so it looks as
if you did not post the real XML but rather what IE presents you. You
will need to look at the source of the XML and post that if you think
there is a problem with the XML.
--
Martin Honnen --- MVP XML
http://msmvps.com/blogs/martin_honnen/
biz7
I work with a work Application that is I believe is Microsoft SQL Server
based? It is called Wall Street Office (WSO application).
By the way, there was a reply today to my issue & just want to add that on
the XML export file code example below (in my original message), the
following code with
"-" character was a mistype on the original Microsoft message to you. It
does not reflect in xml code when I import.
- <ExportEdits>
- <tblScenarioData>
Let me give you the steps I use. By the way, I am trying to automate a data
entry process utilizing the WSO application tools, I am “not” trying to write
new xml code, just duplicating code to import more data into the WSO
application :
* In the WSO application, I open the sheet that needs to be exported.
* I manually input 1 line item so that I can get the exact copy of the xml
code format.
* I then select Tools/ Export Edits & export to a directory. The file is xml.
* I right click on xml file & open with notepad.
* I copy/ paste the xml code in Microsoft excel to duplicate the code. In
excel I have a vlookup formula that looks up specific fields from a client
file.
* The client field is linked to the xml specific area that needs to be
populated . I copy / paste special values after the xml code is completed
into another tab in excel. Therefore no formulas are copied.
* I copy/paste in notepad.
* I save the file in xml.
* I select Tools/ Import edits in WSO application. I tested maybe about 15
assets at 1 time to import and it worked (1st export file). The application
populated the information.
However, my goal is to import only once all the data to be populated.
* I tested another range of assets to import at 1 time and received this
error message (2nd export file): "”The object is currently nothing"”.
Do you have any indication what this message could be? Thanks!
I “also” noticed that when I open the 1st export (see XML export file below)
it allows me to see it in Internet Explorer as below. This 1st export
allows the import into WSO application without any messages.
However, please read further after example below.
XML export file example:
<ExportEdits>
<tblScenarioData>
<Row Key1="ABERD 2008-1A" Key2="" Key3="" Key4="" Key5=""
However, when I update the code in the 2nd export file "that results in the
error message", it gives this message in Internet Explorer :
""The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later. ""
Whitespace is not allowed at this location. Error processing resource
'file:///C:/Documents and Settings/RB/INTERFACE/...
<ExportEdits><tblScenarioData><Row Key1="ABERD 2008-1A" Key2="" Key3=""
Key4="" Key5="" Attribute="SICMoodyC...
================================
Peter Flynn
[...]
> Whitespace is not allowed at this location. Error processing resource
> 'file:///C:/Documents and Settings/RB/INTERFACE/...
That's not a valid URI. Try escaping the spaces with %20 or +
///Peter
biz7
Regarding your response, I think it is the whitespace issue, so where does
the
"%20 or + " code go in the xml code I provided originally? I am not really
an xml editor. I open the xml file with notepad & would edit there.
Thank you!
Peter Flynn
> Hi Peter,
>
> Regarding your response, I think it is the whitespace issue, so where does
> the
> "%20 or + " code go in the xml code I provided originally?
It doesn't. Your original code didn't include any URIs.
The error seems to be IE objecting to the fact that you are trying to
open an XML document whose address is 'file:///C:/Documents and
Settings/RB/INTERFACE/... [something which you did not complete here].
Move the whole lot to a new folder called C:\xmltest and do it from
there. It may be the spaces in "Documents and Settings" which is causing
the problem. Make sure that no files or folders have spaces or weird
characters in their names.
> I am not really
> an xml editor. I open the xml file with notepad & would edit there.
Don't. It will only end in tears :-) Get a real XML editor for editing
XML. There are hundreds...
///Peter
biz7
Thank you for the information! Can you please recommend a free download XML
editor? Does Microsoft have one? I know there are alot of XML editors out
there, but would like your expert opinion! Thanks.
biz7
have one? Thanks.