Importing a unix file dump into a PC capable database Post: 25004

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Importing a unix file dump into a PC capable database Post 25004 by DaltonF on Tuesday 23rd of July 2002 12:31:23 PM

07-23-2002

Registered User

Dalton Franklin

OK here's the situation..

One of my larger suppliers is giving me detailed information about the products they sell for my website. This information was submitted to them by the MANUFACTURERS of those products.

There are roughly 200 categories. Each category has a different number of fields, but the maximum number of fields in any category is 80 (all categories have at least one field).

We are going to put this data into a ProductDetails table. In addition to regular product data (SKU, ManufacturerID, etc.), there will be eighty varchar fields named "Field1", "Field2", etc. An XML file will map those fields to the custom field names defined for each category.

We pondered completely normalizing the database by using a one-to-one related table for each category; but that would overcomplicated the parsing and this works fine, I belive.

The records in the dump are NOT sorted by field.

Each record in the same category does NOT have the same number of fields; fields that were not filled out by the manufacturer are not shown at all.

Each record in the same category does NOT use the same field order. (I'm thinking XML will solve this problem if I can get the file into XML)

Please email me at daltonf@simplicitycorp.net, if you don't mind. I would be glad to provide you with detailed information about the file, or a copy of it if you like. I just can't post it here on this discussion board for legal reasons.

Thanks very much and have a great day.

DaltonF

View Public Profile for DaltonF

Find all posts by DaltonF

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

importing database from unix to winnt

i am a unix-super-beginner (swaddled and weaned on windows) and am trying to import a database from a unix directory into winnt. can someone help me or am i a hopeless case?

2. UNIX for Advanced & Expert Users

building flat files in unix and importing them from windows

what is a flat file in unix? i have to import a unix flat files from windows based programme. my question is not to export from unix but only to import from windows only. how to build that flat files? how to create export to windows how to import from windows

3. UNIX for Advanced & Expert Users

writing database tables into a file in unix

I want to collect the database tables(Ex: Emp,Sal,Bonus...etc) in a file & give this file at the command prompt, when prompted for the tables list at command prompt. How can i do that ? Ex:- Import jason/jason1 tables=emp,sal,bonus log=j1.log i want to change this into Ex:- Import...

4. Shell Programming and Scripting

Importing dump file

Hi, I am trying to import 22 .dmp files but facing the problem with the last table file it never ends the import command, only the table is created but the rows of the table don't get imported. This is the problem with only ine table rest 21 tables are being imported properly. Thanks in...

5. Shell Programming and Scripting

getting dump from database by UNIX script

can i make a dump to happen from my script in a databse.and download that dump. I want to schedule a script i cron so that i will make a dump and download that inot my server.

6. UNIX for Dummies Questions & Answers

Import dump to database

Hi... I have dump in unix machine...How can I this import dump to Oracle database? Many thanks in advance.

7. UNIX for Dummies Questions & Answers

Importing R cosine similarity to UNIX?

I really need help in this :( I have a file and would like to calculate the cosine similarity of the values in it... For now I do use R which has an easy function for doing so test <- as.matrix(read.csv(file="file.csv", sep=",", header=FALSE)) result<- cosine(t(test)) I am using unix of...

8. Boot Loaders

Is Unetbootin capable of making any iso file bootable

1)It is a great experience to achieve what I got today. I had downloaded GParted iso file (135 MB size). Now to make a bootable usb of it, I used unetbootin and to surprise I succeded in entering Gparted application and modified my partitions. Earlier I was in a notion that it is used only for...

9. AIX

Issue while importing Oracle Dump File on AIX 5.3

Hi All, I am facing one problem related to importing Oracle Dump file. We have two different version of AIX boxes with oracle (version 10.2.0.4.0) installed. On one AIX box (version 6.1) we are creating oracle dump file (*.dmp) using oracle exp utility and importing it onto another AIX box...

10. UNIX for Advanced & Expert Users

Load a file from UNIX into database

Hi, I want your help to see if there is a way wherein we can load a set of files which are lying in unix server into my database using sql loader. Also the person who will be running sql loader does not have access to unix system. So is there a way i can provide any sql loader script wherein...

LEARN ABOUT DEBIAN

chcat

CHCAT(8)							   User Commands							  CHCAT(8)

NAME

       chcat - change file SELinux security category

SYNOPSIS

       chcat category file...
       chcat -l category user...
       chcat [[+|-]category...]  file...
       chcat -l [[+|-]category...]  user...
       chcat [-d] file...
       chcat -l [-d] user...
       chcat -L [ -l ] [ user ... ]

DESCRIPTION

       Change/Remove the security category for each file or user.

       Use +/- to add/remove categories from a file or user.

       Note:  When  removing  a category you must specify '--' on the command line before using the -Category syntax.  This tells the command that
       you have finished entering options and are now specifying a category name instead.

       -d     delete the category from each FILE/USER.

       -L     list available categories.

       -l     Tells chcat to operate on users instead of files.

SEE ALSO

       chcon(1), selinux(8), semanage(8)

       When operating on files this script wraps the chcon command.

FILES

       /etc/selinux/{SELINUXTYPE}/setrans.conf
       /etc/selinux/{SELINUXTYPE}/seusers

chcat								  September 2005							  CHCAT(8)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

importing database from unix to winnt

Discussion started by: sadiecutie

2. UNIX for Advanced & Expert Users

building flat files in unix and importing them from windows

Discussion started by: tunirayavarapu

3. UNIX for Advanced & Expert Users

writing database tables into a file in unix

Discussion started by: dreams5617

4. Shell Programming and Scripting

Importing dump file

Discussion started by: anushilrai