doing this using a google sheet you can use an existing field with either image or video and then create additional columns that contain the formual to concatenate the information into what you need for the rich text field. then just map to these new fields. I just put the front and back matter in columns and then the actual link in another. then just combined them together in anotother like so:
=CONCATENATE(A1&B1&C1)
Where A1 is the .embed… "
B1 is the actual embed video link https://youtube.com…
C1 is the ending part of the embed link "—>
Works the same for images. a little more avanced is adding character replacement to allow for multiple " marks side by side:
=CONCATENATE("")
the CHAR(34) is a " mark that google understands.
here is a copy of the example sheet if you would like to see.
However when I try to import this CSV document sitejet doesnt like my sheet and doesn’t allow me to choose the mapped fields I have in the collection. Maybe too many rows or too much data per field. dont know. but that is where I am at with it.
Wow, thanks ! great value here !. I’m not an excel guru. This is something to explore. But that would be awesome if sitejet did add a real csv import procedure for WP posts. We often have clients who already have a wp site and bringing them to the party should be painless. Sitejet ??
yes indeed. if the CSV would also auto create the fields in tandem with the import (based on selecting the column heads and then selecting the column type) that would be fantastic
@Jean_Pierre_Michael - could you maybe send me a file from a WordPress blog via help@sitejet.io to see how this will look and how the data is processed. Happy to look into this. And of course confidentially.
Still having problems with the datacollection. I would like to:
Import a CSV file and let it auto populate the fields (if possible)
Allow to change field types after they are created so I dont have to delete them and recreate them one at a time
Be able to move the field types up and down in the list ( and likewise move them around on the records page)
so far I have not been able to import my records from a particular CSV. it is a very involved sheet with lots of links on it. It trys to import everything to on single field __parsed_extra
also, tried many ways to get the coded version of the image links to show up (instead of loading each image … very heavy) even with rich text and tags it doesnt work (even when I manually input the code).
