|
Hi Guys,
I need help to write application to constantly check and read xml data saved in specific folder on network and extract data to sql database.
|
|
|
|
|
So, what have you written so far? We don't know what you have done, or what errors your code has encountered, or even what you are stuck on. All you have done is tell us what your application should do.
This space for rent
|
|
|
|
|
import java.io.IOException;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.xml.sax.SAXException;
public class Dom
{
public static void main (String[] args)
{
String badnumber = "MPP";
int badnumberconverted;
try {
badnumberconverted = Integer.parseInt(badnumber);
}catch (NumberFormatException nfEx){
}
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
try {
DocumentBuilder builder = factory.newDocumentBuilder();
Document doc = builder.parse("repeat.xml");
NodeList sampleIDs = doc.getElementsByTagName("Elements");
for(int i=0;i<sampleIDs.getLength();i++){
Node p = sampleIDs.item(i);
if(p.getNodeType() == Node.ELEMENT_NODE){
Element Elements = (Element) p;
String id = Elements.getAttribute("id");
NodeList nameList = Elements.getChildNodes();
for(int j=0;j<nameList.getLength();j++){
Node n = nameList.item(j);
if(n.getNodeType() == Node.ELEMENT_NODE){
Element name = (Element) n;
System.out.println("Elements" + id + ":" + name.getTagName()+ "=" + name.getTextContent());
}
}
}
}
}
catch (ParserConfigurationException e){
e.printStackTrace();
}
catch (SAXException e)
{
e.printStackTrace();
}
catch (IOException e){
e.printStackTrace();
}
}
public static String convert(String val)
{
double d = Double.parseDouble(val);
d = d/1000000;
return Double.toString(d);
}
}
|
|
|
|
|
Hi Peter,
This is what i have done so far. can only read xml data.
|
|
|
|
|
This is the C# forum. That code is Java.
This space for rent
|
|
|
|
|
please don't cross-post - you posted this in java - pick the best forum, stick to it, even if it's not 100%
btw - in c#, you can use 'TopShelf' as the basis for a Service - this might be worthwhile looking at NuGet Gallery | Topshelf.FileSystemWatcher 1.0.0.17
|
|
|
|
|
Suppose a data table can access 2003 such as fields execel file attachments, I want to query the warehouse group by name, bar code, goods, inventory, and then type the serial number, the results of its attachments write queries like? Attachments: http://www.mediafire.com/file/lv73f1usj5yqdk2/STTen.xls
|
|
|
|
|
You seem to have mistaken this for the Database forum. It's not - this is for C# questions. Please address your database questions in the right location.
This space for rent
|
|
|
|
|
I want to design the simply software that can convert the pdf files to the word files.
I use third part softwares to support my code. Third part software is sautinSoft.Pdffocus.
When I running my program, I find out a problem that can't convert the all of essay in pdf files to word files.
Can you tell me why I can't convert the all of essay in pdf files to word files? I have tried to check my program, but I can't find out any bugs in my program. I think it is very easy and simply function.
private void TransferFile(object sender, EventArgs e)
{
try
{
if (FileName.Text != "")
{
//PDFtoWord(FilePathFullName.Text, "Test");
SautinSoft.PdfFocus f = new SautinSoft.PdfFocus();
f.OpenPdf(@"C:\Users\DavidLin\Downloads\db-fund.pdf");
f.ToWord(@"C:\Users\DavidLin\Downloads\test.doc");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
MessageBox.Show("Finally");
}
|
|
|
|
|
Member 12757695 wrote: Can you tell me why I can't convert the all of essay in pdf files to word files?
No, we can't. We simply don't have access to your system, or to the PDF files you are attempting to convert. So even if we wanted to, we couldn't run that code and get the same results you do - which means we can't tell you "do this and it'll fix it".
What I'd suggest is that you start with the authors of your conversion software: SDK to convert PDF to Word, DOCX, RTF, HTML, Excel, Text, XML, Images TIFF for C# and VB.Net[^] - it's a paid for package, so they should provide technical support and will know a lot more about their system than we will. Or possibly, the trial is limited in it's functionality, and you have hit that limit. In which case, you need to buy it to continue using it!
We can't tell - we just can't run your code under the same conditions you can.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
The problem is not with your code since your code doesn't do anything at all with the conversion, other than create an instance of a class that does all the work for you.
You have no choice but to get with the support people of the company that made that library and take up the issue with them.
|
|
|
|
|
We can't help you.
Member 12757695 wrote: Third part software is sautinSoft.Pdffocus.
Ask them they should know.
Patrice
“Everything should be made as simple as possible, but no simpler.” Albert Einstein
|
|
|
|
|
I am trying to return a list from three tables which have been joined using LINQ. At the moment I can only get a list which contains data from one table instead of all three tables.
Below is my code
public List<string> GetProductDetails(string productId)
{
var db = new ProductContext();
IEnumerable<Employee> emps = db.Employees.ToList();
IEnumerable<Project> projs= db.Projects.ToList();
IEnumerable<Product> prods = db.Products.ToList();
var productionDetails = from e in emps
join prj in projs on e.EmployeeID equals prj.ProjectID
join prd in prods on e.EmployeeID equals prd.productID
where prd.productID == Convert.ToInt32(productId)
select new {employee = e.EmployeeName, project = prj.ProjectName , product = prd.ProductName };
return productionDetails.Select(m=>m.EmployeeName).ToList();
}
I would like the list to contain employee, project, and product.
modified 11-Feb-17 1:22am.
|
|
|
|
|
my first worries are :-
public List<string> GetProductDetails(string productId)
and
return productionDetails.Select(m=>m.EmployeeName).ToList();
why ?
I would (because I understand it if I do it this way)
a) define a 'prodDetails' POCO and use that instead of 'string' as the return list type,
b) do a select 'new prodDetails {employee = e.EmployeeName .... instead of using an anonymous type
c) remove the .Select in the return productionDetails clause
|
|
|
|
|
Hi, thank you so much for your response. Your solution would work great in most cases but what if the method is a RESTful WCF service method?
Normally I would return a string or a list of string from a RESTful WCF Service or a RESTful Web API method so that the data can be sent across the web.
If my method needs to return a complex type, how do I modify my method to make it work in a RESTful Service?
modified 11-Feb-17 7:04am.
|
|
|
|
|
put a 'wrapper' around GetProductDetails maybe GetProductDetailsAsJSON and convert the returned list to a JSON encoded string
using Newtonsoft.Json;
and then ....
string productId = string.Empty;
List<prodDetails> productionDetails = GetProductDetails(productId);
string ProductDetailsJSON = Newtonsoft.Json.JsonConvert.SerializeObject(productionDetails);
return ProductDetailsJSON;
[edit] obviously on the other end when the REST package/data is received you have to do something like :-
// assuming you have the REST Data in a string called 'json', pretty dumb, but its only an example
List<proddetails> productionDetails = Newtonsoft.Json.JsonConvert.DeserializeObject<list<proddetails>>(json);
[/edit]
|
|
|
|
|
Liagapi wrote: At the moment I can only get a list which contains data from one table instead of all three tables.
You are already creating one. See the line "select new {employee.."
That would create a new anonymous type, and that would be harder to return 
Liagapi wrote: I would like the list to contain employee, project, and product.
Create a new class that can hold the results, and return a list of that specific class.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Liagapi wrote: IEnumerable<Employee> emps = db.Employees.ToList();
IEnumerable<Project> projs= db.Projects.ToList();
IEnumerable<Product> prods = db.Products.ToList();
Your code is loading the whole of those three tables into memory, before filtering for the specific product. That's going to be horribly inefficient.
Liagapi wrote: string productId
where prd.productID == Convert.ToInt32(productId)
Your code is going to throw an exception if you pass in any string that can't be converted to an integer. Instead, you should change your parameter to be an integer, so that your expectations are obvious to the caller.
Liagapi wrote: public List<string> GetProductDetails
If you want to return something other than a single string for each record, you're going to need to change the return type.
Liagapi wrote: join prj in projs on e.EmployeeID equals prj.ProjectID
join prd in prods on e.EmployeeID equals prd.productID
Those join columns don't look right to me. Double-check how your models are related.
public sealed class ProductDetails
{
public string employee { get; set; }
public string project { get; set; }
public string product { get; set; }
}
...
public List<ProductDetails> GetProductDetails(int productId)
{
using (var db = new ProductContext())
{
var productDetails = from e in db.Employees
join prj in db.Projects on e.EmployeeID equals prj.ProjectID
join prd in prods on e.EmployeeID equals prd.productID
where prd.productID == productId
select new { e.EmployeeName, prj.ProjectName, prd.ProductName };
return productDetails.AsEnumerable().Select(x => new ProductDetails
{
employee = x.EmployeeName,
project = x.ProjectName,
product = x.ProductName
}).ToList();
}
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thank you all for replying. The joins are correct and I was able to get the results I was looking for. I've learned a lot from this exercise and your responses to my post helped tremendously.
modified 12-Feb-17 12:53pm.
|
|
|
|
|
I am trying to implement a virtual trackpad (WPF or WInforms). Problem is that every time I touchdown or touchmove on the screen the mouse cursor goes under my finger. I can programatically move the cursor elsewhere but it becomes a tug-of-war with WIndows.
Any thoughts on resolving this?
Thanks
-----
Jack
|
|
|
|
|
|
I have definately tried those techniques. (i.e. Swallowing the preview and low level mouse hook)
Here is the thing.
Yes,
- I can prevent a click event from occurring in my app by blocking on the preview.
- I can also get the mouse cursor to return to its previewous location on touchup using the low level mouse hook (although I do have to move my mouse to get it to reappear)
But between touchdown and touchup and during touchmove, the cursor turns into a tiny circle under my finger. Which I can try and fight by moving the cursor, but it is a losing battle, I am going against the grain. It almost seems like it is at the OS level rather than my app.
So this link helps but hasn't solved the problem for me. I need to truly decouple touch from not just click events, but the cursor location/pointer shape.
|
|
|
|
|
System.Windows.Input.Mouse.OverrideCursor = Cursors.None;
Set up a mechanism where you "swap cursors" (None and "something") depending on your "trackball mode".
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
Just tried that. No luck.
I even have it in a rapid dispatertimer event handler.
Call
System.Windows.Input.Mouse.OverrideCursor = Cursors.Cross;
repeatedly between touchdown and touchup.
No impact.
|
|
|
|
|
I use Cursors.None to "hide" the cursor (and the previous one when swapping back).
What are you using?
(You just keep setting it to a "Cross" ?!)
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
