Transferring Data With XML?
I'm new at this. What would be the best way to transfer data in XML format from sql server A to remote sql server B? We would like to encrypt the data with ssl which we already have installed on our iis server. -- .. http://sf-f.org, weblog and search engine for fans and writers of speculative fiction. ..
spam7238
dotnet.xml
7266 articles. 
0 followers.
0 Replies
1111 Views
Similar Artilces:
CPropertyPage data
How is the data gathered when the last page of a CPropertySheet (wizard mode) class fires the OnWizardFinish button event? The member variables in each page appear to have valid data in them but I cannot figure out how to make use of it when the finish button is clicked. Mark F. wrote: > How is the data gathered when the last page of a CPropertySheet (wizard > mode) class fires the OnWizardFinish button event? The member variables > in each page appear to have valid data in them but I cannot figure out > how to make use of it when the finish button is clicked. The usual wa...
about transfer order
I created a transfer order "TO666", transfer items from store01 to store02, the system automaticly created a TO No."00001_TO666 ". And the strange thing happend: the items in "TO666" is so different with the items in "00001_TO666 ". where is the problem? with a lot of thanks. Try creating another order with the same items, if the problem still exists, most probably you have a problem in the IDs of those items. What HQ does is to map the items in the created order in Store1 to the corresponding items in HQ, then map them again to Store2 and th...
Transfering messages
I want to transfer all my messages from one PC running Vista to another running Win7 which I have Windows Mail running on. However, I have two problems: 1. On transferring some of the transferred folders contain the full message, some only contain what you might call place holders e.g my transferred Inbox has 'From' with a list of 30 or so messages but just shows an envelop and the date and time but no message 2. Is there away to transfer attachments too? -- Ron "Ron O'Brien" <castcall@ntlworld.com> wrote in message news:uBH3g6UjKHA.218...
Filter XML to pass to XSL and import into my control?
I'm still struggling to figure out the big-picture concept of how to go about building a web site menu from an xml file. The XML file contains the full site structure (the site map, so-to-speak). Based on the current page of the site, I want to be able to do the following: get node that pertains to current page get node's siblings get node's parents get node's parents siblings repeat until top node... Pass this filtered XML to an XSLT file import xhtml result into my usercontrol to display on page I asked this yesterday but was a bit too wordy I think. Does the above sound l...
Sorting data question
Hi, I have 200 rows of data in one colum, each row contains a random number but the total column value is 200. I want to sort the data into 4 approximately equal sized blocks (adding up to 50). Just a bit stuck as to where to start the filtering process if there is one that can do this? Cheers Chris ...
Data Load Performance
Running SQL 2008 SP1 I am comparing a data load into a Heap Table and a Clustered Table. The schema from each follows: CREATE TABLE dbo.HeapTable( HeapTable_UID int NOT NULL, Col1 char(25) NOT NULL, Col2 char(100), Col3 char(100), Col4 char(100), Col5 char(100)) CREATE TABLE dbo.ClusteredTable( ClusteredTable_UID int NOT NULL, Col1 char(25) NOT NULL, Col2 char(100), Col3 char(100), Col4 char(100), Col5 char(100), CONSTRAINT IX_ClusteredTable_ClusteredTable_UID_Col1 PRIMARY KEY CLUSTERED (ClusteredTable_UID, Col1) ) CREATE NONCLUSTER...
Import data from Access to Excel containing VB code
Hi! I am trying to import data from an Access database to an Excel spreadsheet. I have imported several queries from Access into Excel already. However the last piece of data that I am wanting to import into Excel has VB code in the query doing a calculation automatically. So when I go to Excel to import that piece of data, those queries that contain the VB code don't even show up as import-able. Is there a way to import these queries from access into my excel worksheet? I am using Access 2003 and running on an XP OS. Is it possible to do it in Excel 2007 if not available in Excel 2003? I...
HR Position Transfers
Is there a way to import a mass amount of position changes in GP HR? We are getting ready to effect changes for our upcoming fiscal year. There are numerous changes to our departments, positions moving from one department to another and some of the departments are altogether new. Is there a tool to import Position Change/Transfers? If not, does anyone know all the tables I would need to hit if I need to import the data? ...
Summing Data based on Its Category
I have a spread sheet that has data on buldings set up in such a way that the rows are different room types and the columns are Floor Type and Sq. Footage. At the bottom of the sheet I have a row that gives total square footage for each floor type of all the rooms combined. Right now I am using the Sum() function but I have to go through and individually select sq footages for the respective floor type. For example if 3 rooms have a cement floor I look down the sq footage column and sum the ones that have "cement" in the floor type column, and same with capret, etc. respec...
Windows Easy Transfer
I am having trouble with Easy Transfer from an XPhome to XPhome installation. Actually it is the same computer after re-installing XP. I ran the Easy Transfer to back up the data onto an external drive. When I run it now on the new build I don't get the "Continue transfer in Progress" option. It does not ask if this is the new or old computer. I haven't used it before so maybe I am not using it as intended. I have user the XP File settings and transfer program for a situation just like this with no problems. Any suggestions? Hu Computer is a basic HP Pavi...
Transferring an order to an invoice...
We are transferring over to GP 10. I have a question about invoicing that I hope someone here can help me with. In GP 8, there was a transfer button on the Sales Order Transaction screen to transfer the order to an invoice. In GP 10, the transfer option is in a pull down menu. Can we make the transfer option a 3rd button on the screen? If someone could let me know, I would appreciate your help greatly! yes you should be able to do that if you wish using a button and a bit of vba code. patrick developer support -- This posting is provided "AS IS" with no warranties, a...
Data Shifting Between Records
Has anyone ever had experience with data moving from one record to another? I have a form in which I'm using the FMS rich text control ("Total Access Memo"). Several times when there has been an error (such as the user unable to print, or other error), the user finds that data in one or two of the rich text fields are actually data that had previously been saved in another record. This has happened two or three times in the past few months. And, while not a frequent problem, it is especially troubling when it happens. I've checked the FMS web site, and haven't seen...
Cut not Copy Appended Data
In this great Macro, created by Micky (MVP), is there a way to cut and paste the data from all the columns instead of copy and paste? I just want all the appended data in Column A". Sub Tony() Application.ScreenUpdating = False LR = ActiveSheet.UsedRange.Rows.Count LC = ActiveSheet.UsedRange.Columns.Count Ind = LR + 1 For C = 2 To LC For R = 1 To LR If Cells(R, C) <> "" Then Cells(Ind, 1) = Cells(R, C) Ind = Ind + 1 End If Next Next Application.ScreenUpdati...
Formatting Cells/Data
Hi, I hope you are doing well. I have a file I downloaded from our AS/400 (OS400 operating system). I open the file as a text file and go thru the wizard for converting the file to excel format. One of the columns/fields is numeric with some neg and pos numbers and some blank cell contents. During the wizard conversion the field is categorized as DOUBLE with no option to change the field. When I finish the wizard I save the file as an Excel workbook. Then I use the autosum option to calculate the total of the field/column; however, it only picks up on the positive #'s. Hence the t...
System does not auto create Transfer In during Inter-store transfe
Hi, my customer running 2 stores and both store having the same interstore transfer option setting. my problem is 1 of the store does not auto generate Transfer In doc 1. store A - Transfer Out Doc store B - auto generate transfer In Doc store A uploaded 2 HQ message to HQ & store B received 2 HQ message. 2. store B - Transfer Out Doc store A - NOTHING GENERATED store B only uploaded 1 HQ message to HQ & store A received 1 HQ message. anyone got ideas how to solved this? Thanks Dennis Did you set the HQ Configuration options to auto gen...
duplicating data
I have 2 excel worksheets, both are in different formats. Both will contain the same data but spread across different parts of the worksheets. if I have filled in the data for 1 worksheet, how can i automate this data to be filled into the other worksheet? In Sheet2 use linking formulas. Sheet2 H1 formula is =Sheet1!A1 For contiguous areas these can be copied by dragging. For non-contiguous areas..........manually enter references. Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 08:13:17 -0700 (PDT), Lynn <moley_cruz@yahoo.com.au> wrote: >I have 2 excel work...
Validating data in a subform against data in main form
I have a main form with a subform. Each form is bound to its own table but are linked through a primary key (customerID). On the main form, I have a customer's date of birth (dob). On the subform, I have the customrer's date of order (doo). Basically, I want to validate that the date of order entered by the user is later than the date of birth. How can I do this? I tried to do it in the subform's BeforeUpdate event but it failed. It didn't seem to recognize dob (customer's date of birth). Perhaps, I was not referring to dob properly. I'm new to ...
Average data/reduction
I have a number of worksheets where each contains two rows of data representing wind speed and direction recorded every 10sec (8636 records per day). I would like to average every 60 records so that each record on a new worksheet (or rows)represents the average wind speed and direction every 10 minutes of the day. I would also like to be able to set up a new data set with only data recorded every 10 minutes (or other time interval) represented. Any help would be much appreciated -- MC In column A of Sheet2 I have some numbers On Sheet3, I want the average of these in groups of 10 I...
Copy Unique data to a different worksheet
Worksheet 1 Date Prod Id Customer Amount 1/2 B123 John Doe 5 1/2 B123 Jane Doe 4 1/3 G456 John Smith 5 1/4 S789 Jane Smith 4 I need a formula, function, or Macro to do the following: resulting in WB 2 Copy unique Prod Id (ex. B123 is listed twice but I only need it displayed once on WB 2 with the amount of both as displayed). This to help track sales of a product quarterly. Result for Worksheet 2 Prod ID Jan Feb Mar B123 9 0 0 G456 5 ...
TRANSFER OUT TO TRANSFER OUT
I HAVE BEEN WORKING WITH RMS FOR OVER A YEAR AND HAVE NEVER SEEN THIS PROBLEM. STORE A MAKES A TRANSFER OUT AND STORE B RECEIVES A COMPUTER TRANSFER IN THE TRANSFER OUT WINDOW INSTEAD OF A TRANSFER IN. IN ADDITION TO THAT THE TRANSFER HAS BEEN CLOSED AT STORE B'S END AUTOMITICALLY AND IT IS EMPTY. AN KNOWLEDGE AS TO WHY THIS HAPPENS THANKS Check HQ Client for errors, or from HQ Manager, view the event log for that store. You'll probably find some errors at Store B on the 401 that created the transfer. I would guess that Store A used a transfer number with more than 14 c...
Data, lookups, and sums
I have an Excel spreadsheet as follows: Column A Dates in dd/mm/yy format Column B Additional data (text) Column C Group of figures (a) Column D Additional data (text) Column E Group of figures (b) In another spreadsheet I have: Row 1 Months going horizontally in mmm-yy format from Feb-04 to Jan-05 Row 2 Sum of figures I would like the sum of figures to be calculated as Group of figures (a) and (b) depending on what the corresponding date is. I thought this would be similar to a lookup table. However, I need to be able to add the sum of the two figures, and I need to ...
Fixed Asset transfer for a New Company
Is selling the Fixed Asset to the new company the best option to make a transfer to a new company? Can you give us a little more detail on what you are needing to accomplish? If two companies are different legal entities there are all kinds of other rules on 'transferring' assets. Is this just a new database or are you doing an intercompany transaction? We can help, we just need a little more explanation. "FA user" wrote: > Is selling the Fixed Asset to the new company the best option to make a > transfer to a new company? ...
Which Transfer In?
A question for you all, which our support company can not answer... If branch 5 receives a transfer from another branch of 64 of item 68209, but the paperwork is missing, and there is no label on the box to say which branch it has come from, is there a quick way of finding the correct Transfer in document? We have tried the Item movement and item movement history reports, but the answer is NO!. Basically, look through all of the transfers in, until you find the correct one. I'm, after a report or a solution which does not involve Store Administrator, as it should be an easy to us...
Activation Transfer
We currently have Publisher installed on our 3 computers. We have a computer we are replacing in our department. I need to know how I deactivate the computer we are replacing and transfer the activation onto the computer we are replacing it with. Thanks. There is no "deactivation". Uninstall it from old computer. Install it on new computer. Select telephone activation if necessary. -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Matt" <Matt@discussions.microsoft.com> wrote in message news:44CF7...
invoke data upload
Is there a way for HQ to request data upload from a store without relying on the schdule? For example, if I needed to see acutual store sales data immediately. Thanks in advance. No, communication is always initiated by HQ Client. The only way for HQ to request an off-schedule connection is to contact someone at the store and ask them to manually connect HQ Client. You would need to create and approve a 401 worksheet at HQ before having the store connect. You could also use remote control software like PC Anywhere (that's just an example, not a recommendation) to connect to t...
How is the data gathered when the last page of a CPropertySheet (wizard mode) class fires the OnWizardFinish button event? The member variables in each page appear to have valid data in them but I cannot figure out how to make use of it when the finish button is clicked. Mark F. wrote: > How is the data gathered when the last page of a CPropertySheet (wizard > mode) class fires the OnWizardFinish button event? The member variables > in each page appear to have valid data in them but I cannot figure out > how to make use of it when the finish button is clicked. The usual wa...
about transfer order
I created a transfer order "TO666", transfer items from store01 to store02, the system automaticly created a TO No."00001_TO666 ". And the strange thing happend: the items in "TO666" is so different with the items in "00001_TO666 ". where is the problem? with a lot of thanks. Try creating another order with the same items, if the problem still exists, most probably you have a problem in the IDs of those items. What HQ does is to map the items in the created order in Store1 to the corresponding items in HQ, then map them again to Store2 and th...
Transfering messages
I want to transfer all my messages from one PC running Vista to another running Win7 which I have Windows Mail running on. However, I have two problems: 1. On transferring some of the transferred folders contain the full message, some only contain what you might call place holders e.g my transferred Inbox has 'From' with a list of 30 or so messages but just shows an envelop and the date and time but no message 2. Is there away to transfer attachments too? -- Ron "Ron O'Brien" <castcall@ntlworld.com> wrote in message news:uBH3g6UjKHA.218...
Filter XML to pass to XSL and import into my control?
I'm still struggling to figure out the big-picture concept of how to go about building a web site menu from an xml file. The XML file contains the full site structure (the site map, so-to-speak). Based on the current page of the site, I want to be able to do the following: get node that pertains to current page get node's siblings get node's parents get node's parents siblings repeat until top node... Pass this filtered XML to an XSLT file import xhtml result into my usercontrol to display on page I asked this yesterday but was a bit too wordy I think. Does the above sound l...
Sorting data question
Hi, I have 200 rows of data in one colum, each row contains a random number but the total column value is 200. I want to sort the data into 4 approximately equal sized blocks (adding up to 50). Just a bit stuck as to where to start the filtering process if there is one that can do this? Cheers Chris ...
Data Load Performance
Running SQL 2008 SP1 I am comparing a data load into a Heap Table and a Clustered Table. The schema from each follows: CREATE TABLE dbo.HeapTable( HeapTable_UID int NOT NULL, Col1 char(25) NOT NULL, Col2 char(100), Col3 char(100), Col4 char(100), Col5 char(100)) CREATE TABLE dbo.ClusteredTable( ClusteredTable_UID int NOT NULL, Col1 char(25) NOT NULL, Col2 char(100), Col3 char(100), Col4 char(100), Col5 char(100), CONSTRAINT IX_ClusteredTable_ClusteredTable_UID_Col1 PRIMARY KEY CLUSTERED (ClusteredTable_UID, Col1) ) CREATE NONCLUSTER...
Import data from Access to Excel containing VB code
Hi! I am trying to import data from an Access database to an Excel spreadsheet. I have imported several queries from Access into Excel already. However the last piece of data that I am wanting to import into Excel has VB code in the query doing a calculation automatically. So when I go to Excel to import that piece of data, those queries that contain the VB code don't even show up as import-able. Is there a way to import these queries from access into my excel worksheet? I am using Access 2003 and running on an XP OS. Is it possible to do it in Excel 2007 if not available in Excel 2003? I...
HR Position Transfers
Is there a way to import a mass amount of position changes in GP HR? We are getting ready to effect changes for our upcoming fiscal year. There are numerous changes to our departments, positions moving from one department to another and some of the departments are altogether new. Is there a tool to import Position Change/Transfers? If not, does anyone know all the tables I would need to hit if I need to import the data? ...
Summing Data based on Its Category
I have a spread sheet that has data on buldings set up in such a way that the rows are different room types and the columns are Floor Type and Sq. Footage. At the bottom of the sheet I have a row that gives total square footage for each floor type of all the rooms combined. Right now I am using the Sum() function but I have to go through and individually select sq footages for the respective floor type. For example if 3 rooms have a cement floor I look down the sq footage column and sum the ones that have "cement" in the floor type column, and same with capret, etc. respec...
Windows Easy Transfer
I am having trouble with Easy Transfer from an XPhome to XPhome installation. Actually it is the same computer after re-installing XP. I ran the Easy Transfer to back up the data onto an external drive. When I run it now on the new build I don't get the "Continue transfer in Progress" option. It does not ask if this is the new or old computer. I haven't used it before so maybe I am not using it as intended. I have user the XP File settings and transfer program for a situation just like this with no problems. Any suggestions? Hu Computer is a basic HP Pavi...
Transferring an order to an invoice...
We are transferring over to GP 10. I have a question about invoicing that I hope someone here can help me with. In GP 8, there was a transfer button on the Sales Order Transaction screen to transfer the order to an invoice. In GP 10, the transfer option is in a pull down menu. Can we make the transfer option a 3rd button on the screen? If someone could let me know, I would appreciate your help greatly! yes you should be able to do that if you wish using a button and a bit of vba code. patrick developer support -- This posting is provided "AS IS" with no warranties, a...
Data Shifting Between Records
Has anyone ever had experience with data moving from one record to another? I have a form in which I'm using the FMS rich text control ("Total Access Memo"). Several times when there has been an error (such as the user unable to print, or other error), the user finds that data in one or two of the rich text fields are actually data that had previously been saved in another record. This has happened two or three times in the past few months. And, while not a frequent problem, it is especially troubling when it happens. I've checked the FMS web site, and haven't seen...
Cut not Copy Appended Data
In this great Macro, created by Micky (MVP), is there a way to cut and paste the data from all the columns instead of copy and paste? I just want all the appended data in Column A". Sub Tony() Application.ScreenUpdating = False LR = ActiveSheet.UsedRange.Rows.Count LC = ActiveSheet.UsedRange.Columns.Count Ind = LR + 1 For C = 2 To LC For R = 1 To LR If Cells(R, C) <> "" Then Cells(Ind, 1) = Cells(R, C) Ind = Ind + 1 End If Next Next Application.ScreenUpdati...
Formatting Cells/Data
Hi, I hope you are doing well. I have a file I downloaded from our AS/400 (OS400 operating system). I open the file as a text file and go thru the wizard for converting the file to excel format. One of the columns/fields is numeric with some neg and pos numbers and some blank cell contents. During the wizard conversion the field is categorized as DOUBLE with no option to change the field. When I finish the wizard I save the file as an Excel workbook. Then I use the autosum option to calculate the total of the field/column; however, it only picks up on the positive #'s. Hence the t...
System does not auto create Transfer In during Inter-store transfe
Hi, my customer running 2 stores and both store having the same interstore transfer option setting. my problem is 1 of the store does not auto generate Transfer In doc 1. store A - Transfer Out Doc store B - auto generate transfer In Doc store A uploaded 2 HQ message to HQ & store B received 2 HQ message. 2. store B - Transfer Out Doc store A - NOTHING GENERATED store B only uploaded 1 HQ message to HQ & store A received 1 HQ message. anyone got ideas how to solved this? Thanks Dennis Did you set the HQ Configuration options to auto gen...
duplicating data
I have 2 excel worksheets, both are in different formats. Both will contain the same data but spread across different parts of the worksheets. if I have filled in the data for 1 worksheet, how can i automate this data to be filled into the other worksheet? In Sheet2 use linking formulas. Sheet2 H1 formula is =Sheet1!A1 For contiguous areas these can be copied by dragging. For non-contiguous areas..........manually enter references. Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 08:13:17 -0700 (PDT), Lynn <moley_cruz@yahoo.com.au> wrote: >I have 2 excel work...
Validating data in a subform against data in main form
I have a main form with a subform. Each form is bound to its own table but are linked through a primary key (customerID). On the main form, I have a customer's date of birth (dob). On the subform, I have the customrer's date of order (doo). Basically, I want to validate that the date of order entered by the user is later than the date of birth. How can I do this? I tried to do it in the subform's BeforeUpdate event but it failed. It didn't seem to recognize dob (customer's date of birth). Perhaps, I was not referring to dob properly. I'm new to ...
Average data/reduction
I have a number of worksheets where each contains two rows of data representing wind speed and direction recorded every 10sec (8636 records per day). I would like to average every 60 records so that each record on a new worksheet (or rows)represents the average wind speed and direction every 10 minutes of the day. I would also like to be able to set up a new data set with only data recorded every 10 minutes (or other time interval) represented. Any help would be much appreciated -- MC In column A of Sheet2 I have some numbers On Sheet3, I want the average of these in groups of 10 I...
Copy Unique data to a different worksheet
Worksheet 1 Date Prod Id Customer Amount 1/2 B123 John Doe 5 1/2 B123 Jane Doe 4 1/3 G456 John Smith 5 1/4 S789 Jane Smith 4 I need a formula, function, or Macro to do the following: resulting in WB 2 Copy unique Prod Id (ex. B123 is listed twice but I only need it displayed once on WB 2 with the amount of both as displayed). This to help track sales of a product quarterly. Result for Worksheet 2 Prod ID Jan Feb Mar B123 9 0 0 G456 5 ...
TRANSFER OUT TO TRANSFER OUT
I HAVE BEEN WORKING WITH RMS FOR OVER A YEAR AND HAVE NEVER SEEN THIS PROBLEM. STORE A MAKES A TRANSFER OUT AND STORE B RECEIVES A COMPUTER TRANSFER IN THE TRANSFER OUT WINDOW INSTEAD OF A TRANSFER IN. IN ADDITION TO THAT THE TRANSFER HAS BEEN CLOSED AT STORE B'S END AUTOMITICALLY AND IT IS EMPTY. AN KNOWLEDGE AS TO WHY THIS HAPPENS THANKS Check HQ Client for errors, or from HQ Manager, view the event log for that store. You'll probably find some errors at Store B on the 401 that created the transfer. I would guess that Store A used a transfer number with more than 14 c...
Data, lookups, and sums
I have an Excel spreadsheet as follows: Column A Dates in dd/mm/yy format Column B Additional data (text) Column C Group of figures (a) Column D Additional data (text) Column E Group of figures (b) In another spreadsheet I have: Row 1 Months going horizontally in mmm-yy format from Feb-04 to Jan-05 Row 2 Sum of figures I would like the sum of figures to be calculated as Group of figures (a) and (b) depending on what the corresponding date is. I thought this would be similar to a lookup table. However, I need to be able to add the sum of the two figures, and I need to ...
Fixed Asset transfer for a New Company
Is selling the Fixed Asset to the new company the best option to make a transfer to a new company? Can you give us a little more detail on what you are needing to accomplish? If two companies are different legal entities there are all kinds of other rules on 'transferring' assets. Is this just a new database or are you doing an intercompany transaction? We can help, we just need a little more explanation. "FA user" wrote: > Is selling the Fixed Asset to the new company the best option to make a > transfer to a new company? ...
Which Transfer In?
A question for you all, which our support company can not answer... If branch 5 receives a transfer from another branch of 64 of item 68209, but the paperwork is missing, and there is no label on the box to say which branch it has come from, is there a quick way of finding the correct Transfer in document? We have tried the Item movement and item movement history reports, but the answer is NO!. Basically, look through all of the transfers in, until you find the correct one. I'm, after a report or a solution which does not involve Store Administrator, as it should be an easy to us...
Activation Transfer
We currently have Publisher installed on our 3 computers. We have a computer we are replacing in our department. I need to know how I deactivate the computer we are replacing and transfer the activation onto the computer we are replacing it with. Thanks. There is no "deactivation". Uninstall it from old computer. Install it on new computer. Select telephone activation if necessary. -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Matt" <Matt@discussions.microsoft.com> wrote in message news:44CF7...
invoke data upload
Is there a way for HQ to request data upload from a store without relying on the schdule? For example, if I needed to see acutual store sales data immediately. Thanks in advance. No, communication is always initiated by HQ Client. The only way for HQ to request an off-schedule connection is to contact someone at the store and ask them to manually connect HQ Client. You would need to create and approve a 401 worksheet at HQ before having the store connect. You could also use remote control software like PC Anywhere (that's just an example, not a recommendation) to connect to t...