Importing records into Pages Database from CSV File?

[Maksim]

Have a databse set up on pages.  While we have set up a number of vendors with all of the details, there are also about 400 records that are currently in an excel file that need to be added.

Any way to get that into the database without going through adding them manually?

Thanks!

(would be just text fields, no images)

[opentype]

I have done it, for example to import a list of 1000 emoji records, but of course you can easily break things this way. One faulty entry can make the page/database unusable. 

I set up a couple of test records, downloaded a CSV from phpMyAdmin, recreated my data to fit that CSV, imported a few entries through phpMyAdmin (to check for errors) and then finally imported the whole list. 

Things like “record count per category” won’t be correct after such imports, but that gets corrected once you add or remove any record. 

[Maksim]

7 minutes ago, opentype said:

I have done it, for example to import a list of 1000 emoji records, but of course you can easily break things this way. One faulty entry can make the page/database unusable. 

I set up a couple of test records, downloaded a CSV from phpMyAdmin, recreated my data to fit that CSV, imported a few entries through phpMyAmin (to check for errors) and then finally imported the whole list. 

Things like “record count per category” won’t be correct after such imports, but that gets corrected once you add or remove any record. 

So now am thinking if it is worth it. lol. possibly breaking with all of the fields there.

Btw, bought supergrid. love it... although a question, is it possible to reposition the image as it appears in the hero image? =)

[Maksim]

On 5/11/2017 at 11:54 AM, opentype said:

I have done it, for example to import a list of 1000 emoji records, but of course you can easily break things this way. One faulty entry can make the page/database unusable. 

I set up a couple of test records, downloaded a CSV from phpMyAdmin, recreated my data to fit that CSV, imported a few entries through phpMyAdmin (to check for errors) and then finally imported the whole list. 

Things like “record count per category” won’t be correct after such imports, but that gets corrected once you add or remove any record. 

So correct me if I am wrong, just take the CSV file, format it to the same as the database and upload through phpmyadmin?  Is there any other entries that need to be made elsewhere besides the cms_customdatabase table?

Also, trying to wrap my mind around it.... but fields like record_save, record_updated, record_publishdate, and record_comment have a long digit code.... what do I put in for those or trying to understand it... ie 1494512720  How do I decipher that? lol.

thanks!

[opentype]

Thats a UNIX timestamp.