Importing Rich Text from external system
I have created a portfolio project management system in QuickBase that will combine extensive data from both business teams and IT teams. The business teams do not currently have a project manageme...
Forum Discussion
If you can get ahold of the information via CSV, you could import it that way, without formatting.
------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------
------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------
- MarkShnier__You
Qrew Legend
Maybe this is helpful. Use a Pipeline to convert the data to text
https://help.quickbase.com/pipelines/transforming_data.html#Managing_HTML_in_your_pipeline
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ Justin - I have no problem exporting / importing the text data without the formatting. Unfortunately once the heavily formatted status reports are stripped of their rich text formatting they are not easy to read. Think of a heavily bulleted / indented / stylized Power Point executive summary being reduced to a simple text message without bullets, without indentations and without even simple bold font.
How do I export / import WITH rich text formatting?
------------------------------
Annetta Coleman
------------------------------- Could you convert your text fields in Quickbase to Rich Text Fields as well so that they match up? That should re-set the html to display properly?
------------------------------
Ursula Llaveria
------------------------------Ursula -
The fields in Quick Base are set up as Rich Text and work properly for those (business) users who enter the data there directly. We have a large (IT) user group that has asked us to integrate data from ServiceNow to QuickBase so they do not have to enter this type of information twice. Our integration works perfectly for data that uses standard text.Our problem is with integration from Rich Text fields in ServiceNow that need to be populated to Rich Text fields in QuickBase. Since our Enterprise ServiceNow Team frowns upon integrating to ServiceNow directly, we are exporting data out of a ServiceNow Data Warehouse Table via SQL and then importing to QuickBase. The SQL script is dropping the rich text fields as text with embedded HTML rich text code that when imported into QuickBase is unreadable (all of the HTML Rick Text code remains embedded in the string).
- Perhaps there is a better way to extract the rich text fields from ServiceNow?
- Perhaps there is a better way to import the rich text fields into QuickBase?
------------------------------
Annetta Coleman
------------------------------- Perhaps there is a better way to extract the rich text fields from ServiceNow?
