Importing Rich Text from external system

Question

I have created a portfolio project management system in QuickBase that will combine extensive data from both business teams and IT teams.&nbsp; &nbsp;The business teams do not currently have a project management system.&nbsp; &nbsp;The IT teams currently utilize ServiceNow across our enterprise (but this system is strictly for IT use).&nbsp; &nbsp;I am currently performing a weekly export/import of detail from numerous ServiceNow tables and will want to automate this process later this year.
One significant problem....&nbsp; &nbsp;ServiceNow offers extensive Rich Text options in the (weekly) status report table.&nbsp; &nbsp;Upon export, the text has embedded HTML formatting code which makes the text content virtually unreadable when this text is imported to QuickBase.&nbsp; &nbsp;If I strip out the HTML code (540,000 occcurrences in this one table) the result is slightly better but still difficult to read and not suitable for executive sponsor viewing since all of the formatting has been stripped out.&nbsp; &nbsp;I would like to figure out how to export / import rich text fields from ServiceNow to QuickBase.&nbsp; &nbsp;Hopefully the pre-built integration 'pipes' between ServiceNow and QuickBase may be useful in the future, but my enterprise ServiceNow team has stated that they have numerous priorities and ServiceNow to QuickBase integration will likely be pushed out a year or more.&nbsp; &nbsp;What can I do in the meantime to solve my problem via some export / import process?&nbsp;------------------------------Annetta Coleman------------------------------

justintorrence · Answer

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
------------------------------

markshnier__you · Answer

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
------------------------------

annettacoleman · Answer

Justin - I have no problem exporting / importing the text data without the formatting.&nbsp; &nbsp;Unfortunately once the heavily formatted status reports are stripped of their rich text formatting they are not easy to read.&nbsp; &nbsp;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.&nbsp; &nbsp;
How do I export / import WITH rich text formatting?------------------------------Annetta Coleman------------------------------

ursulallaveria · Answer

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
------------------------------

annettacoleman · Answer

Ursula -&nbsp;The fields in Quick Base are set up as Rich Text and work properly for those (business) users who enter the data there directly.&nbsp; &nbsp;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.&nbsp; &nbsp;Our integration works perfectly for data that uses standard text.&nbsp; &nbsp;
Our problem is with integration from Rich Text fields in ServiceNow that need to be populated to Rich Text fields in QuickBase.&nbsp; 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.&nbsp; &nbsp;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).&nbsp;

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?

&nbsp;

&nbsp;&nbsp;------------------------------Annetta Coleman------------------------------

Forum Discussion

Importing Rich Text from external system

6 Replies