Hello,

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="" 
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 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...
================================



"Martin Honnen" wrote:

> biz7 wrote:
> > 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/
>