kentico-ericd / kontent-google-sheets-add-on Goto Github PK

Describe the bug
The export is returning content types but all sheets are empty (does not extract content items). I contacted the Kontent.ai support team. they were trying to test it and found out that it says: "'Your input exceeds the limit of 50000 characters in a single cell.'" but I'm positive that none of the items imported to Kontent had that many characters.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Google Sheet'
2. Click on 'Export'
3. Scroll down to '....'
4. See error: it either says "Something went wrong while executing the add-on." or does not show any error

Expected behavior
it should have extracted content as it used to

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS] Windows 10
• Browser [e.g. chrome, safari] Chrome
• Version [e.g. 22] Version 102.0.5005.63

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

When a GAS exception is thrown (like "Exceeded maximum execution time"), the script halts and the import log isn't generated even though some items may have been imported. We should try to catch these exceptions and provide some more information + generate the log if possible

Describe the bug
Configuration not saving in google sheets.

To Reproduce
Steps to reproduce the behavior:

1. Go to google sheets
2. Click on configure
3. Enter API information
4. Click save and never updates the information just sits on a gray save button.

Expected behavior
Should have saved information in configuration. Just sits there not updating anything.

Screenshots

Desktop (please complete the following information):

• OS: Windows 10
• Browser Latest Chrome
• Version 80.0.3987.132

Please include support for Asset field types for import using the google sheet import addon.
The required value would be:
"value": [
{
"id": "6c332099-56fb-46df-95e7-2db2983a1ea3"
}
]

but is not currently supported. I think it would make most sense to just have the import accept a GUID value.

GAS has an execution limit of ~5 minutes. Accessing services (ie reading from a Sheet) are performance intensive and we could save some execution time by possibly caching the data instead of reading cells in a loop.

Or, we could find a way to batch the import somehow.

The way I understand it, the current implementation uses the contents of the "name" column as the codename so that assuming there are no duplicates, name and codename are the same in the imported data.

I am trying to import some strings that have an ID and a value. I'd like to keep the ID as the codename and make name a readable string based on the value.

Having my original ID as the codename will make it easier for deployment tools. The alternative, creating a text field to store the original ID, adds complexity and produces a less-user friendly view of the items in Kentico Kontent

example:
My data:
Key ID: question_433d4259-6294-48ba-bab4-1704793f1a28_help_text
Key value: Diabetes is a lifelong condition that causes a person's blood sugar level to become too high.
There are 2 main types of diabetes:
Type 1 Diabetes
• Usually diagnosed in childhood
• Isn't linked with age or being overweight
• Treated with insulin injections

What I would like to see in Kentico
Codename: question_433d4259-6294-48ba-bab4-1704793f1a28_help_text
Name: _Diabetes is a lifelong condition that causes
User-facing string: Diabetes is a lifelong condition that causes a person's blood sugar level to become too high.
There are 2 main types of diabetes:
Type 1 Diabetes
• Usually diagnosed in childhood
• Isn't linked with age or being overweight
• Treated with insulin injections

Since the key IDs in my original data are unique, they should generate unique codenames but if there was a duplicate codename I would like to see an error rather than a new codename created.

Currently, when using the new(ish) export functionality it exports everything, always. I would like to have the ability to select the content types that I will export. One of our projects is so large that it times out the export feature and i think being able to select which content types we want to export would help that a ton.

It would be really good to see the list of Content Types in alphabetical order when you go to Generate Sheet, as at the moment if you have a lot of Content Types, it's hard to find the one you want. Having them in alphabetical order will really speed up this process.

It may not be possible for all types of data, but we could scan cell values and validate some of the data before the import process runs to avoid errors in importing and the need to re-import.

Most likely, it would be a button on the home card or Import card so that editors can validate as they work on the sheet

For large imports, the results displayed in the small sidebar could be difficult to read. Results could instead be displayed in a separate file/spreadsheet.

Importing subpages is not supported in the current implementation.

The ability to not only support modular_content but also subpages make like much more straightforward when moving content about in projects and seeding initial data sets.

Describe the bug
Basically I'm using the add on, but when trying to retrieve the Content Types from the project, it is not listing them all

Therefore I can't select the one I was to use, it's like it is only listing a limited amount

To Reproduce
Steps to reproduce the behavior:

1. Go to Generate Sheets
2. And you don't see the full list of Content Types

Expected behavior
I would expect all content types to be available to be selected or some form of search to find the type I need

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

Hey Eric! Awesome addon :)

Is your feature request related to a problem? Please describe.
Importing into more complex types with content type snippets does not work.

Describe the solution you'd like
Would like to be able to import all fields including content type snippet fields as fields directly in the google doc.

ex. columns
name | somefield | mycontentsnippet__fieldone | mycontentsnippet__fieldtwo

should import with name as the codename, somefield is a direct field on the content item, then mycontentsnippet_fieldone will populate the fieldone field within the snippet.

Describe alternatives you've considered
Make some special notation to indicate that it is a content type snippet i.e add "cts!" as a prefix to the content type snippet. I am worried that if you just use contentsnippetname__fieldname then if someone accidentally names a field with double underscore it will think it is a snippet and cause issues. Maybe there needs to be a way to detect these. Havent looked into it enough

Column not included in POST to Kontent if it is the first column (e.g. column is post_date instead of name)

Possibly caused by this line