Consolidation of data
Help. I am a bit lost. I have a hugh list of customer's
from two different databases. The client numbers will be
the same, but the rating will differ. I want to compare
the two and find out what are the conflicts.
Please see example:
A B C
WEXFORD AUTOMOTIVIE 9514111 B
WEXFORD AUTOMOTIVIE 9514111 B+
WILSHIRE HAIRCARE 9512211 C
WILSHIRE HAIRCARE 9512211 C-
What I want is for it to use the client numbers (B) as the
main reference point and then compare column C, if there
is a conflict between the data, I want it to kick the
client number to a seperat...XML Header
I have some XML doc loaded in a C# Web Service.
XmlDocument doc = new XmlDocument();
Code Missing to manipulate header (I would like to replace or manupulate all
Any idea on how to access and manipulate data within the doc header?
> I have some XML doc loaded in a C# Web Service.
> XmlDocument doc = new XmlDocument();
> Code Missing to manipulate header ...Writing data from excel to sql-server
I would like to write the values of A1 and B1 to a SQL-Server table every 10
seconds. How can I do this ?
Svein Olav Steinmo
There's only two ways I know of to do this. 1.) You have
to create a link to the EXCEL sheet in question using MS
SQL Enterprise Manager. Then create a scheduled job to
run an SQL statement to update the SQL table. Note:
Changes to the EXCEL file will update automatically
through SQL link. 2.) Create an Access DB with links to
the respective tables and worksheets. Create a PASS
THROUGH query that updates the SQL table using the EXCEL
data...Importing external data in plain text row format
I have data in the following format:
-------------------Begin Sample Data----------------------
Fernando E. Amuchastegui
Office of the County Attorney
115 S. Andrews Avenue
Fort Lauderdale 33301
Ronald J. Anania
Law Offices of Ronald J. Anania
10910 S W 10th Court
Eric J. Anders
Haley Sinagra Paul & Toland, P.A.
100 SE 3 Avenue
Fort Lauderdale 33394
Hal B. Anderson
Billing Cochran H...Synchronizing and data evaluation
One of our customers found a possible & serious logical problem that
might result banning the offline -functionalities from users.
When users sync data from offline db to online database the data gets
evaluated and the most fresh data by timestamp wins.
Any data inputted online will use timestamp value from 'on save'
-events 'modified on' -field for possible future evaluation. Problem is
that data typed offline will get the evaluation timestamp from "Synced
On" rather than "Modified On".
User 1 modified account "XYZ" yesterday ...Newbie Questions
This must be incredibly easy, but I've poked around in most of the
chart options I can find and haven't been able to see it. I have a
sheet that looks something like:
6/11/05 6/12/05 6/13/05 ...
A 419 431 432 ...
B 145 145 144 ...
I'm charting only the values in the A row, 419, 434, etc. An
appropriate range is shown on the Y axis. I have the X axis formatted
as dates, but I get the dates 1/1, 1/2, etc. How do I tie the X axis
labels to the dates in my data?
Another question: This data will grow indefini...Read XHTML into XML
I need to read/parse XHTML aspx pages and look for certain tokens and
content. How can I use a XmlTextReader for this? If not, any other ideas?
Thanks in advance,
Jose Antonio Reyes wrote:
> I need to read/parse XHTML aspx pages and look for certain tokens and
> content. How can I use a XmlTextReader for this? If not, any other ideas?
If the pages are well-formed XHTML then it is possible to use XmlReader
(in .NET 2.0/3.0) or XmlTextReader (in .NET 1.x) to parse the XHTML
documents. You can also use the other XML APIs .NET provides so using
XPathNavigator and/o...How to invoke the xml editor?
I installed vs2005 on a new xp pro machine, and installed everything
except C++. When I click on a file with a ".xml" extension it is
opened with IE. When I click file/Edit with XML Editor, it opens it
with Notepad. If I click File/Open With and select XML Editor, it
opens it with IE. So, where is the xml editor?
Can it be invoked from withing VS? Where?
* email@example.com wrote in microsoft.public.dotnet.xml:
>I installed vs2005 on a new xp pro machine, and installed everything
>except C++. When I click on a file with a ".xml" extension it is
>opened ...show XML schema and values
I have an XML document that looks like the following:
What I'm aiming to do is to show the data in a report as in the following
The "Field1-3"-elements can have any name, so I'm trying to get a table that
has in one result column the element name, and in the second colum...Company Data Archive
I am looking at the product company data archive from Professional Advantage
and wanted to see if anyone here has used the application and give me their
feedback on it. Thank you
...How do I get a graphy with 2 data sets to have 2 Y axis one for each data set?
How do I get a graphy with 2 data sets to have 2 Y axis one for each
On Jul 20, 5:26 am, libertyforall <r...@royhuff.com> wrote:
> How do I get a graphy with 2 data sets to have 2 Y axis one for each
> data set?
have a look at Jon Peltier's beatiful site, especially:
Have fun, cheers
...Moving a line chart data point revises data table value in Excel '
I recall a capability I used with Excel years ago that enabled me to create a
line chart from a data table, then move the plot points on the chart to
"smooth" the line, and the source data chart value would change with the
corresponding new plotted point.
I'd like to use that capability with Excel 2007 but can't find to activate it.
Any power users know how?
Ed, Microsoft decided that users didn't need that feature. More than
likely, they were tired of support calls asking why the values changed when
one dragged a data point...... No really, they took i...data lable don't appear in chart bars appear without lable
I have created six panel charts work fine but charts in panel don't lables
for bars, value do appears.
...Offline synch using XML web-services
This is a bit long-winded. Can somebody read thru these 2 use cases, and
tell me if it is feasible ? :-
Use Case : Replication before Offline Synch
Scenario 1 : Oracle Server , MSDE client
1. User clicks on 'Go Offline'. System creates a MSDE SQL database in
laptop (client), gets the schemas of the tables in Oracle, creates
corresponding tables in client's MSDE SQL (mapping Oracle datatypes to SQL
2. Offline replication program reads in the tables of the server into a
typed datasets, converts the typed datasets into XML, and stores the XML in
the client. (XML serial...XML Serialization ... how to truncate <?xml...
While xml serializing object how can I truncate <?xml ...?> this line alone?
I need to send the serialized xml data to a web method ... since SOAP
already have <?xml tag there was some confusion
Any help would be greatly appreciated
> While xml serializing object how can I truncate <?xml ...?> this line alone?
Serialize to an XmlWriter created with XmlWriterSettings where you set
OmitXmlDeclaration to true.
Martin Honnen --- MVP XML
...Threads which just read data
I have many threads in my program. I would like to know if it is safe to
allow the threads access to a variable to just read its contents, without
having a synchronizing object ? Could there be problems like memory
corruption etc if I allow it ?
I don't see any reason why it will be unsafe to allow threads to just read
contents, without having a synchronizing object. Please correct me if I'm
On Sat, 25 Oct 2003 19:03:19 +0530, "Vengidi" <firstname.lastname@example.org>
> I have many threads in my program. I would like to know i...Pivot Table: deleted source data
Is it a common practice to delete the source data for a Pivot Table?
Why do the Pivot Table maintain the data after the source is deleted?
I was trying to reverse engineer a Pivot Table that was created in
2009. I kept seeing the source as a Summary sheet but it was not
listed in the spreadsheet. I thought it was hidden and it was not..
So I experimented a little and created a Pivot and deleted the source
and the data stayed in place but kept displaying the source that did
On Jul 19, 12:20=A0pm, Ty <tyrone_...@yahoo.com> wrote:
> Is it a common practice to d...String to xml document
I was hoping someone can help me with a little problem I can't seem to find
any answers to.
I've got a form wich will be posted. On receiving the post I would like to
parse a formvar to a xml document.
The contents of this formvar (string) will be a valid xhtml document.
Can someone give me a startertip (or more :-)) on how to achieve this?
tnx in advance,
James van der Veen
> I was hoping someone can help me with a little problem I can't seem to find
> any answers to.
> I've got a form wich will be posted. On receiving the p...Random data corruption
Subject: Re: Randowm data corruption Money 2002
<email@example.com> Sent: 9/21/2004
I just did what you proposed but the data is still
corrupted (no changes).
What else can I do? I had a computer repair person here
all afternoon running virus scans and there is no virus
in my CPU..
>>I use Money 2002 Deluxe & Business to manage 6 business
>>bank accounts...Beginner of XML
I am a beginner of XML.
I want to group some files together with a xml file. (it includes a text
file, and an image file and a video file)
Can someone show me some guidelines?
...Default data directory?
Money 2004. How do I change the default directory where the Money data is
Thanks for your help. That web page must not be kept very up to date
though. The lead article is "What's new in Money 2003".
"Bob Peel, MVP" <Bob_Peel@kiandra.freeserve.co.uk> wrote in message
> Move the Money file *.mny to wherever you want it and then double click on
> the file name in it's new location. Money will remember where it found it.
> Bob Peel,
> Microsoft MV...Valid xml to read from an xml file?
I'm using vb.net, i get an error at the reader line saying the remote
server can't be found. Is the below even valid?
dim reader as XmlTextReader
reader = new XmlTextReader ("http://www.mysite.com/my.xml")
do while (reader.Read())
'do some action here
XmlTextReader uses System.Net.WebRequest under the covers -- see if you can
figure out how to create a connection that way. Usually there's some proxy
server information missing that you can enable if you use WebRequest
directly, and then pass the result of GetResponse()...Using ontime to plot data automatically
I basically need to instruct excel to automatically plot the cell
value of a given cell, each day at set time.
So the two values would be the cell value and the date.
The cell value on same days may be the same as the previous day.
I thought using Excel's Ontime function may help performing a Macro
that does this periodcially.
In the root module of the workbook I've added:
Private Sub Workbook_Open()13:00:00"), "MyMacro"
On the spreadsheeet that has the value in A1 I've added the following
code to a new module:
Application.OnTime T...Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms,
modules, and logic) used to CRUD the data in the tables.
1) Is there any way to separate the database from the code into separate
files, eg. the db is mydata.mdb and the 'code is in a separate file, eg.
2) Say you have v1.0 of an app and the tables and attributes are populated
with data. You then go and build v2.0 of the app, adding tables and columns
to what already existed in v1.0, and perhaps moving some of the v1.0
attributes into different tables. What is the recommended way to
unload/reloa...Example eConnect XML documents
MSDN says the following:
Installing eConnect schema
When you include the schemas component of the eConnect install, the
installer places schema files in a schemas folder on your computer.
The following schema resources are available:
The install places the .xsd schema files in the directory c:\Program
Files\Microsoft Great Plains\eConnect9\XML Schema\Incoming XSD
Individual Schemas. The files in the directory contain the schema for
each eConnect XML document.
The install places a file named eConnect.xsd that contains the schema
definition for all eConnect XML documents. The install typicall...