|
As i mentioned, it is client's own DBMS (DBMS is INF*ACT DB). It is not derived from any other dbms like mainframe, sqlserver and oracle. Just now i got this details from my colleagues.
All this database informations are available inside of these five file format's only.
.hed, .chr, .tad, .inf and .idx
If you want, i will send the sample files to you.. But i don't know how to attach the files with this forum.
Thanks,
Sivakumar.M.
|
|
|
|
|
You basically have two choices:
1. Implement something that understands the binary structure of these files and extract the data out of them.
2. Extract the data out of the DB, and import the data manually.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
As you advised, I have collected some more details about this inf*act db which are given below.
Nielsen Inf*Act db is a SQL db compatible with relational Star schema Data model. It is client's own dbms.
We are receiving the inf*act db datasource from the client in a folder(the folder should be in country code) and this folder contain the files with the formats of .hed,.chr,.idx,.inf and .tad(5 files for each DB).
If the datasource dump has 50 db means, the datasource folder will contain (50dbs*5files for each db) 250 files. We are adding each database through our tool by browsing the file in the format of (.hed ) from this datasource folder.
One important thing is, if we delete any one of the file among those 5 files(.hed,.chr,.idx,.inf and .tad) for a db, the database will not get added in our report template tool.
As i discussed here, the data is available in <b>.inf</b> file. First i have to extract the data from this file. Then only i can import them into ms-access.
So, <b>i want the code in vb.net, that how to extract the data from this file and import them in ms-access.</b>
I think this will help you a lot 
Thanks,
Sivakumar.M
|
|
|
|
|
sivakumar.mariappan wrote: I think this will help you a lot
Nope. I'm not writing your code for you - that's your job. This isn't rentacoder where you get some dumbnut to write code for you, and I don't get paid to do your job for you. Tell you what, put me in touch with your client, and my company will do the work for them directly - we'll even throw in a support contract for them.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
sivakumar.mariappan wrote: As i mentioned, it is client's own DBMS
You didn't mention that.
sivakumar.mariappan wrote: If you want, i will send the sample files to you
No thanks, have you tried it yet?
|
|
|
|
|
No, as i am a beginner of VB.NET, i don't have any idea to find this.
|
|
|
|
|
So what exactly are you asking for? Somebody to decode the format for you? Somebody to write the conversion code? You need to be a lot clearer on what help you are after other than a vague "I'll send you some files".
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
As you advised, I have collected some more details about this inf*act db which are given below.
Nielsen Inf*Act db is a SQL db compatible with relational Star schema Data model.
We are receiving the inf*act db datasource from the client in a folder(the folder should be in country code) and this folder contain the files with the formats of .hed,.chr,.idx,.inf and .tad(5 files for each DB).
If the datasource dump has 50 db means, the datasource folder will contain (50dbs*5files for each db) 250 files. We are adding each database through our tool by browsing the file in the format of (.hed ) from this datasource folder.
One important thing is, if we delete any one of the file among those 5 files(.hed,.chr,.idx,.inf and .tad) for a db, the database will not get added in our report template tool.
As i discussed here, the data is available in .inf file. First i have to extract the data from this file. Then only i can import them into ms-access.
So, i want the code in vb.net, that how to extract the data from this file and import them in ms-access.
I think this will help you a lot
Thanks,
Sivakumar.M
|
|
|
|
|
.hed[^]
You are the only person who knows better abt your problem. Gather some info. and ask questions
|
|
|
|
|
As you advised, I have collected some more details about this inf*act db which are given below.
Nielsen Inf*Act db is a SQL db compatible with relational Star schema Data model.
We are receiving the inf*act db datasource from the client in a folder(the folder should be in country code) and this folder contain the files with the formats of .hed,.chr,.idx,.inf and .tad(5 files for each DB).
If the datasource dump has 50 db means, the datasource folder will contain (50dbs*5files for each db) 250 files. We are adding each database through our tool by browsing the file in the format of (.hed ) from this datasource folder.
One important thing is, if we delete any one of the file among those 5 files(.hed,.chr,.idx,.inf and .tad) for a db, the database will not get added in our report template tool.
As i discussed here, the data is available in <b>.inf</b> file. First i have to extract the data from this file. Then only i can import them into ms-access.
So, <b>i want the code in vb.net, that how to extract the data from this file and import them in ms-access.</b>
I think this will help you a lot
Thanks,
Sivakumar.M
|
|
|
|
|
A mainframe database? How many tables/records are we talking about?
Do you seek advice or a solution?
I are troll
|
|
|
|
|
Eddy Vluggen wrote: Do you seek advice or a solution?
Option number 3. Coded and tested apps.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
I are troll
|
|
|
|
|
As you advised, I have collected some more details about this inf*act db which are given below.
Nielsen Inf*Act db is a SQL db compatible with relational Star schema Data model. It is client's own dbms.
We are receiving the inf*act db datasource from the client in a folder(the folder should be in country code) and this folder contain the files with the formats of .hed,.chr,.idx,.inf and .tad(5 files for each DB).
If the datasource dump has 50 db means, the datasource folder will contain (50dbs*5files for each db) 250 files. We are adding each database through our tool by browsing the file in the format of (.hed ) from this datasource folder.
One important thing is, if we delete any one of the file among those 5 files(.hed,.chr,.idx,.inf and .tad) for a db, the database will not get added in our report template tool.
As i discussed here, the data is available in <b>.inf</b> file. First i have to extract the data from this file. Then only i can import them into ms-access.
So, <b>i want the code in vb.net, that how to extract the data from this file and import them in ms-access.</b>
I think this will help you a lot
Thanks,
Sivakumar.M
|
|
|
|
|
sivakumar.mariappan wrote: i want the code in vb.net, that how to extract the data from this file and import them in ms-access.
You'll need to write it - this isn't a drive-through
First, you'll need to determine the layout of the .inf file, and create a means of reading it into VB. If you need help, you can post an example of the contents of the .inf file here.
Writing the data to an Access database would be the second step.
Good luck
I are troll
|
|
|
|
|
Ask the client whether any kind of connection is available to access the database.
If there are none, ask them to export the content of database to certain format (CSV, XML, flat files)
If they can't, ask the client if it is a known database that your team can understand if you need to get down and dirty to decode the database
If it is not a known database format, ask if they got documentation on the database structures.
If they can't or no document, tell your PM your team is in deep sh*t..
|
|
|
|
|
I had an in process dll developed in Vs2005, which gets registered through an MSI setup, this dll performs the action which it really mean for, but if I install the setup.exe including .Net framework2.0 in it, as to check the Prerequisites while testing in other PC's, these doesn't perform the required operation correctly, after the dll gets registered, what may be the mistake I am doing, can anyone clear this?
|
|
|
|
|
Hi all
I have problems to find information about the attribute [assembly: ...].
As a learner I want to pick up the string in the docu.
The question is, where do I find it in the online docs (the word "assembly" is used in all kinds of context)
Please do not explain me what it does, instead help me to find the docu - because the latter is my problem.
(don'g give me food, I need to know how to bake bread)
best thanks
|
|
|
|
|
|
In addition to what Eddy Vluggen has posted, you can use System.Reflection.Assembly.GetExecutingAssembly().GetCustomAttributes to get all the attributes applied to your current assembly
|
|
|
|
|
|
plz anybody know it to help me.
G.Murugadoss
|
|
|
|
|
Write a client application which returns all the processes of local machine and write a server application which receives that. Now you know the machine names and corresponding processes. I have tried it using .net remoting.
|
|
|
|
|
plz anybody knows it to help me. i'm waiting for ur reply
G.Murugadoss
|
|
|
|
|
Please read this [^]article. Don't be a Code Vampire - try writing it for yourself, and coming back when you have specific problems.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
