cheesegrits
Support Gopher
Try now.
-- hugh
-- hugh
-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Import CSV
- Thread starter pixelperfectcreative
- Start date
cheesegrits
Support Gopher
Ooops, I forgot to do the "substract 100 years" thing.
Just let me know if the dates look right, bearing in ind the century, and if so I'll do it by hand in place on your phpMyAdmin.
I picked about a dozen rows at random from start to end of the import and compared the CSV with the SQL, and it looks OK to me.
-- hugh
Just let me know if the dates look right, bearing in ind the century, and if so I'll do it by hand in place on your phpMyAdmin.
I picked about a dozen rows at random from start to end of the import and compared the CSV with the SQL, and it looks OK to me.
-- hugh
pixelperfectcreative
Member
Hugh, looks like there are 51,000 records now. There should only be 5,100. Did the import happen 10 times?
pixelperfectcreative
Member
Hi Hugh, wondering if you had a minute to look at this today? Thanks!!!
cheesegrits
Support Gopher
I just imported the file you gave me - the fabrik-2-9-fromexport.csv from your ftp site, and it has 51,487 lines.
If you point me at the right file, I'll do it again.
-- hugh
If you point me at the right file, I'll do it again.
-- hugh
cheesegrits
Support Gopher
And in post #33 on this thread I did say ...
-- hugh
-- hugh
pixelperfectcreative
Member
Jeez. It looks like at line 4383, the list should end. The Last Name field is alphabetical, and you can see it repeat. Could you strip everything AFTER 4383? THANKS!!!!
cheesegrits
Support Gopher
Man oh man, that would have been a WHOLE lot easier if I'd known it was supposed to be only 4.3k lines instead of 50k!
OK, removed the extra lines, and done the "subtract 100 years" from the dates thing. I suspect you may have a few where the date is now 18xx, as the initial date format conversion would have "guessed" at the century to use, 'cos your data only had 2 year digits (REALLY! Who does that since Y2k??). You'll just have to scan through and catch those by hand.
Let me know if it looks ok ...
-- hugh
OK, removed the extra lines, and done the "subtract 100 years" from the dates thing. I suspect you may have a few where the date is now 18xx, as the initial date format conversion would have "guessed" at the century to use, 'cos your data only had 2 year digits (REALLY! Who does that since Y2k??). You'll just have to scan through and catch those by hand.
Let me know if it looks ok ...
-- hugh
cheesegrits
Support Gopher
BTW, you did see this from post #26 ...
It's taken me about 4 hours, all told. Unfortunately, a lot of that was down to just the sheer size of the file, which turned out to be wasted time ... but all I had to work with was what you gave me.
-- hugh
It's taken me about 4 hours, all told. Unfortunately, a lot of that was down to just the sheer size of the file, which turned out to be wasted time ... but all I had to work with was what you gave me.
-- hugh