Monthly Archives: January 2011

WebCast: ‘Lightning’ Web-Component for 4D

(English follows below)

WebCast mit Graham Langley zum ‘Lightning’ Web-Component

‘Lightning’ ist eine Web-Componente für 4D v11 und 4D v12. Ein  ideales Werkzeug für alle Einsteiger – und nicht zu verachten für die schnelle Umsetzung einer Web-Anbindung für die eigene Datenbank.

Am Sonntag, dem 06. Feb 2011, 11.00 Uhr präsentiert 4DToday.eu einen WebCast mit Graham Langley – dem Programmierer von ‚Lightning‘. Hier können Sie sich aus erster Hand informieren lassen und im Anschluß an die Demo Fragen stellen.

Vorabinformationen gibt es hier. Die Veranstaltung findet auf englisch statt.

Anmeldung unter webcast@4d-consulting.com.

…and now let‘s try in English:

WebCast with Graham Langley about his web component ‚Lightning’

‘Lightning’ is web component for 4D v11 + 4D v12. A great tool for a quick setup. Just install it into your database and you are (nearly) ready to go.

4DToday.eu proudly presents a web cast together with Graham Langley, the author of ‘Lightning’.

Date & time: Sunday, Febr 06, 11.00 am (GMT+1) on your screen.

Interested?  Just visit Graham’s website.

Register for the webcast here: webcast@4d-consulting.com.


The web cast is here: http://4dtoday.eu/4d-2/lightning-movie/

PagePro 1.0 build 24 available

Peter Bozek, INFORCE Bratislava reports:

PagePro 1.0 build 24 is available for download from PagePro web site.
This build is accompanied by improved example database that
demonstrate some advanced features and first draft of QuickStart
manual with description of PagePro editor.

With previous internal release of build 23 it fixes several issues and
bring improvements:

– fixed bug in registration code
– fixed printing issues on Windows
– improved handling of fill footer

Component
– added ability to set print order of multiple headers / footers
– fixed differences between v11 and v12 component

For full release notes see
http://www.pagepro4d.eu/PagePro_Release_Notes.rtf

PagePro can be downloaded from
http://www.pagepro4d.eu/download.html

Description of main features
http://www.pagepro4d.eu/features.html

Prices and availability
http://www.pagepro4d.eu/prices.html

How to import EXCEL into mySQL

This is a workaround for (mostly) non-programmers, found in a forum for ‘os Commerce’ – but I thought, it might be helpful here, too. 🙂


Original article is at: http://www.aspfree.com/c/a/Database/Converting-Your-Excel-Worksheet-into-a-Working-MySQL-Database/

You can only export one worksheet at a time to your MySQL database.  Your worksheet should be free from images, colors, wrapping text, and fancy fonts.  The first row is considered your Heading row starting in A1.

Steps to import a CSV file created in Excel into a MySQL table for a MySQL database stored on a server (not XAMPP localhost):

1.     Create your Excel file using the EXACT field names as in your MySQL table.  If you are importing into a table with many field names, you may want to EXPORT the table first, open in Excel and save it as your template.  If you are adding new data, make sure you delete any data that might have exported with your field names.  If your table has a Primary Key, it should be the first field listed.  If you have it set to auto_increments, leave it blank in your Excel file.

2.     Save it as a CSV file (SUGGESTION:  you may want to save the Workbook the same name as your table in the same format.  Ex:  products_attributes).

  • Go to File -> save as “CSV (Comma delimited).” If there is a warning that says “Do you want to keep the workbook in this format?” Click “YES” and close the workbook. Click “NO” if there is a warning that asks “Do you want to save the changes made to yourworkbook.csv?”

3.     Then go to http://csv2sql.evandavey.com/. This will convert csv data into MySQL insert statements.

  • Table Name: Type the EXACT table name you are importing to.
  • CSV File: Browse to the location of the CSV file you have saved in the above steps.
  • Mode: “Insert Statements”
    • If you are updating existing data, choose Updating Statement.
  • Primary Key Field (Update Only): leave blank.
  • After all are set, click “GO”
  • Copy the created statement(s).  You can leave off the following: “– Generated by http://csv2sql.com online CSV to SQL converter”

4.     Go to phpMyAdmin >> select your database

5.     Click on the “SQL” tab at the top

6.     Paste your statement(s) in the “Run SQL query/queries…” box

7.     Click “GO”

[amazon_image id=”3836218771″ link=”true” target=”_blank” size=”medium” ]Einstieg in PHP 5.4 und MySQL 5.5: Für Programmieranfänger geeignet (Galileo Computing)[/amazon_image] •  [amazon_image id=”3815828201″ link=”true” target=”_blank” size=”medium” ]Das große Buch: MySQL[/amazon_image] • [amazon_image id=”3826675185″ link=”true” target=”_blank” size=”medium” ]MySQL 5 (bhv Einsteigerseminar)[/amazon_image] • [amazon_image id=”389721525X” link=”true” target=”_blank” size=”medium” ]MySQL kurz & gut[/amazon_image]