Sedang Disiapkan

mySQL data load from a word doc - revised

Hi ,

This one is not quite as easy as the title suggests. I'm a fairly experienced RHCE admin with mysql skills and so far it's beaten me.

I have a typo3 cms with a modified news extension. The data appears as here [url removed, login to view]

I need to load in from 9 word docs about 250 rows consisting of about 60 colums. Of that I guess 25-30 columns will contain non default data. The reason why it's word docs and not spreadsheet is because the docs contain an image which in the database will be represented as an image id

To make things easier there is a phpmyadmin interface. Copying an existing row and attempting to insert shows the required sql query needed. Unfortunately a straight copy returns an error about a null value.

The work then is

* Fixing the error about "field cannot contain a Null value" (I've checked the data and it is non null)

* Converting table docs to csv format

* Loading the data - 250 rows

If you know typo3 and mysql that would be perfect

Thanks

Paul

Kemahiran: MySQL, SQL

Lihat lebih lanjut: word/image, word docs, sql mysql, mysql error, mysql copy, data query, converting image to word, sql query format, rows insert, spreadsheet copy csv, mysql spreadsheet, format doc, spreadsheet insert, query spreadsheet, insert mysql table, data required html, attempting, mysql copy database, word csv, image query, word extension, html data load, word query sql, word table html, phpmyadmin error

Tentang Majikan:
( 12 ulasan ) Southampton, United Kingdom

ID Projek: #1568050

Dianugerahkan kepada:

liuxinran

I can do this.

$80 USD dalam sehari
(15 Ulasan)
4.1

5 pekerja bebas membida secara purata $98 untuk pekerjaan ini

AdamsK

Ready for service sir, thanks.

$60 USD dalam sehari
(31 Ulasan)
5.1
corluk

Ready to start .

$100 USD dalam 5 hari
(8 Ulasan)
4.1
Alexod

I can help you

$200 USD dalam 5 hari
(2 Ulasan)
3.8
fatimah85

ready and have full time to work

$50 USD dalam sehari
(0 Ulasan)
0.0