Take A Bill Of Material File From A Customer In Xml Format And Import It Into System?
May 13, 2011
I need to take a bill of material file from a customer in xml format and import it into our system. The problem I'm running into is that the terms they use to describe the types of material may vary. So, for example, if they are specifying a piece of threaded rod, they may call it "THREADED ROD", "THREADEDROD", "THRD ROD", "THRD'D ROD" or some other variation. Another example might be rectangular tubing. They might call it "RECTANGULAR TUBING", "RECT TUBING", "RECT TUBE", etc. There will be many types of material besides these two that I need to catch. Once the program determines what the material is it then branches to the appropriate subroutine to do further parsing. I was trying to think of a way to use regex or the "Like" or "Contains" operators to do this. Here is one way I thought of using "Select ... Case" but it isn't very flexible & will only catch hard-coded terms:
Select Case material
Case "THREADED ROD", "THRD ROD" 'etc...
Case "RECTANGULAR TUBE", "RECT TUBE", "RECT TUBING" 'etc...
End Select
View 7 Replies
ADVERTISEMENT
Nov 23, 2009
We had a wierd problem at work.SOmeone at finance tried to import a text file into their system. It complained about the textfile was in unicode format. The file contains scandinavian . Apparently the ERP system that exported the file can only handle unicode.So one of our junior programmers wrote a batch program that line by line converted the unicode file to ascii (you can't choose encoding.ANSI because ANSI is byte array)
The files are rather big, about 3 GB in size.Apparently the system liked ASCII files, but sadly after this processing the and was gone and replaced with ?So, he wrote a new batch program, this time replacing m?nad with m�nad using String.Replace The file was opened using Encoding.Default and saved using Encoding.Ascii.Now the files HAVE AND can be imported. After he explained this to me, I just went . I wish I had some nifty "you should have done this... bla bla its much easier" but I am lost here in the jungle of code pages and encodings. Can someone that has their head screwed on straight enlight us *both* about why we had this problem and how it could be handled without writing the second batch program?
Basically unicode->non unicode (ascii) with the intact. I also noticed that if I use streamreader to read an ansi file with the internal strings will show ? instead.
View 1 Replies
Oct 15, 2009
I have an application that continously records audio for several hours. I want to be able to listen to recorded material but not necessarily in real time. I have tried to just copy the file being recorded to a new file with overwrite and the copy obviously gets done (filesize changes) but when I try to listen to the copied file my player just 'blinks' and nothing more happens. If I however close the recording, the copy also gets playable. My idea is that copying a file in use just creates another file in use. If this is the case how can I close the copied file?
View 1 Replies
Nov 27, 2010
im currently designing a system that enables the user to input a customer record. the customer record is broken down into 11 fields: customer id, title, forename, surname, house no, town, city, county, postal code, contact number, date of registration. Problems - i need to be able to insert the new record into a file and for them to be organized into surname order (for a binary search to work) at this moment it will only sort by first field (which is unnecessary as the customer id number is generated automatically and is all ready created in order). Also, im having trouble with sorting the array that contains all the variables from the text file.
[Code]...
View 3 Replies
Oct 4, 2011
I have the following problem: I select a customer from a dropdownlist and then the gridview should load all items of all orders of that customer. I have the following query:
Dim allorders = From ord In db.Orders
Where ord.CustomerID = Convert.ToInt32(CustomerDropDownList.SelectedValue)
[CODE]..............
I also tried to modify the query as follows:
Dim orderitems = From oi In db.OrderItems
Where oi.OrderNumber = (From From ord In db.Orders
[CODE]...........
But this does not work. I just started using LINQ.
View 5 Replies
Oct 5, 2011
A registeration sys using a Microsoft acres database I have a table named customer info to store customer details when registering and I need coding that will add the following to my table customer I'd , firstname, lastname , phonenumber and user also has to make selection between radio buttons male or female.
View 2 Replies
Jan 5, 2010
I am trying to autocomplete customer surnames direct from the Customer Datatable, using the code below which I got from another thread, but nothing is happening.
[Code]...
View 6 Replies
Mar 16, 2009
With the following imported namespaces in my project :
Imports System.Windows.Forms
Imports System.Reflection
.. I cannot add..
[code].....
View 6 Replies
Apr 6, 2010
how can i put an import export in csv format on my programe i want to send data from my programe to excel
View 4 Replies
Apr 15, 2012
I have a table in ms access. I need it to be imported to the Datagridview in vb 2010 in customized format . The below shown is my access table.
-------------------------------------------------------------
| ID | Names player | Sports |
-------------------------------------------------------------
| 1 | aleksy | rugby |
[code].....
I need the output in desired format as shown in image2. Check the attachment. This should work for any number of records.
View 3 Replies
Feb 14, 2010
iam very keen to learn vb.net 2008 so please suggest me how to access world most and best free of cost reading material available on net for reference.and free best book available for vb.net 2008 on the net. there is any complete source code available for consideration.
View 2 Replies
Apr 9, 2010
How can I get free Materials on VB.NET that explain the basic functions used during programming?.
View 1 Replies
Apr 15, 2012
I have a table in ms access. I need it to be imported to the Datagridview in vb 2010 in customized format . The below shown is my access table.
[Code]...
View 3 Replies
Aug 16, 2011
I dont know how to and ever time i think i do it wont let me import
View 3 Replies
Aug 24, 2009
I currently do all development work in VB.NET 2008, winforms; but within 18 months will be switching to WPF (for better or worse). I have had great success using Matthew MacDonald's "Pro NET 2.0 Windows Forms and Custom Controls in VB 2005" book. This is an excellent reference focused entirely on the development of custom controls in windows forms. ( Many of the controls that I use have to have a very specific UI look and feel, so they end up being custom.
I'm looking for pretty much the exact same thing, except focused on WPF. MacDonald has a new book coming out on WPF in general ,but not on custom controls. Books are my preferred reference material, but any good web references.
View 1 Replies
Jun 12, 2012
is excel Import and export format supported in windos mobile development? because i cannot find it in add reference..
View 1 Replies
Apr 27, 2011
I have a project from college. The project is for a car company showing how much the customer will be required to pay back monthly on the amount of finance they take out. I need to search to edit and delete customers so for example I want the program to say something like " Name of the customer you'd like to delete/edit" then the response would be the name "Mark". I'm using vb.net2005 console application
View 8 Replies
Mar 10, 2012
I'm having some problems with some API calls. I'm trying to return device driver information for a given device in device manager so I can access the available information and display it. I'm using a series of API calls which in turn populates a list with device driver objects associated with that device. The API calls fail. The problem is that I can't find any reference material online for these APIs so I can figure out what's wrong. [code]
View 1 Replies
Jan 26, 2011
I've done some research into this using the MSD website; I have found that my applicaiton saves the Customer Details to the Customer File, but only as (spaces). No data is present in the file.
I'm creating an application that saves Customer data to a file. Once the Data is saved into the file, how would i then get it from the file into a ListView?
[Code]...
View 3 Replies
Apr 16, 2009
I am working on a project inwhich I want same date format in all project forms. I want to use a form for setting/resetting date format for whole project. whenever I will change date format in this settings form, there should be this new date format available in all forms. how can I implement this?
View 8 Replies
Oct 16, 2009
I am trying to develop an application to monitor and keep track of all the prints in the office.I have gone through some of the tutorial and found out system.printing has the functions to do so. But when I tried to import it, it says name space or type specified for system.import doesn't contain any public member or cannot be found.
View 2 Replies
Jan 24, 2010
I'm getting a message when I try to import this namespace that "Namespace or type specified in the Imports System.Windows.Media.Imaging doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined etc..."
View 7 Replies
Jul 15, 2009
I am attempting to read Excel 2003 cell content through a Visual Basic 2008 program. Searching Help for the subject yielded an example Function named XLGetCellValue (ByVal fileName As String, ByVal sheetName As String, Byval addressName As String) As String
This function required the following Iports:
Imports
System.IO.Packaging
Imports System.Xml
Imports System.IO
upon pasting the above three Iports to the Program, Igot the following error message:Warning 1 Namespace or type specified in the Imports 'System.IO.Packaging' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
View 5 Replies
Dec 17, 2009
I can't import the System.DirectoryServices namespace. It doesn't pop up if that little box thing.Why?
View 2 Replies
Jan 4, 2012
I am creating a class that searches a binary file for a specific customer number. I am using a binary search that keeps on slicing the file in half until I find the customer number while is sorted. Once it finds it I am positioning it at the first instance of that Customer number as there can be multiple records with the same Cus Number.
Now here is my question. I now need to loop through this Customers records and do some data base searches. Since I want to make my class as generic as possible what should I pass back to the calling class? An Array with all their records. If I do this I have to loop twice, once in the class and once when it passes the array bac to the original calling class?
[Code]....
View 20 Replies
Jun 2, 2009
I have the following piece of code that contains my message body in an email I'm trying to send via vb.net (through outlook) The code works, but .net is not recognizing the HTML formatting and is giving the error: "XML literals and XML axis properties are not available Please Add references to the System.Xml.dll, System.Xml.Linq.dll, and System.Core.dll assemblies". I try and do this by going to Project --> add referance, but they are not highlighted and I can't select them. Is there any way around this?
[Code]...
View 2 Replies
Jan 27, 2011
it's a log in form and I need to put case-sensitive validation in other words if your Username = Admin then Admin != admin Consider this code block (VB is really unfamiliar for me so break it to me gently ^^) This is after it has matched a record in the database to the parameter passed to the function LogIn()
If dataTable.Rows.Count > 0 Then
'case-sensitive Validation follows
'data in Column ID and Password are placed in variables
[code]....
the asterisk-ed line returns an error (obviously) as strId is not of data type String.I also tried using LIKE but again since strId and strPass are not Strings, all I get is an error.
View 1 Replies
Mar 4, 2009
how can I import the System.ServiceProcess namespace into a WPF project in VB.net (not C#)? The ServiceController object is not in the toolbox in VS2008 and can't see to figure it out. Any ideas? If that particular namespace cannot be imported into WPF projects, could somebody suggest another way of controlling windows services from a WPF application? I know this framework is focused more on multimedia apps, but would really like to switch over some of my tools to WPF.
View 2 Replies
Jan 19, 2012
In Visual Studio 10 - Visual Basic, why can't I import "System.Drawing" when my only reference is "System"? I can import "System.Runtime.InteropServices".To reproduce my problem:
1. Create a New Project in Visual Studio 10 with Visual Basic Class Library template.
2. Add "Imports System.Drawing" and "Imports System.Runtime.InteropServices" at the beginning.
3. Remove all references except "System" in the References pane of the project properties.
Result:Visual Studio cannot find "System.Drawing" but it can find "System.Runtime.InteropServices". "System.Drawing" is fully qualified so the system should be able to find it inside the referenced "System".
Thoughts:It appears "System" and "System.Drawing" are distinct namespaces (or containers?) so why doesn't qualification "." work? Does "." represent something else? "System" is also in "mscorlib" but is that the namespace which is used or is it another?"Microsoft.VisualBasic" is also listed in the imported namespaces but there is not a reference to it. How was it found? Where is the "Imported namespaces" list populated from?I have been looking through it for a while but cannot understand why "System.Drawing" is not imported.
View 4 Replies
Oct 10, 2011
I want give a date from user to string Such as "2011-10-11" and for example my system date format is : dd/mm/YYYY
How can i convert 2011-10-11 To Default System Date Format ( In My Example : 11/10/2011 )
View 1 Replies
