Thanks @BigBen - solution was forgetting to include 'ignore_index=True'. Now to figure out why my other projects worked without it...

Not so clear about how this works.

Q1: let's say I have an Excel file named MyFile in directly C:MyDir. How do I get the C++ code to find and access this file?

Q2: let's say I have two columns of data to read in the c++ code I am creating. First column cells A1 to A10 and corresponding cells B1 to B10. How do I read this data in my c++ code? I do want to create for example if conditions such as if (A1=5) then (B1=0).

Thanks in advance.

Did you find the root cause of this issue ? It seems to be present since version 15 of Keycloak.

We got the same error, but nothing about the issue in forums or from Keycloak.

Thanks!

Thank you,"minSdk = flutter.minSdkVersion" to "minSdk = 23" work for me too. :)

Its Really Hard To Say about problem

I have the same issue, Did you find a solution ?

I was finally able to deploy DRF (Django Rest Framework) in azure with SQL server database. Following this tutorial by MS .

how did you solve this problem ?

I'm trying to update to VS2022 but I did all the steps up and this error continue:

Severity Code Description Project File Line Suppression State Details Error LNK2019 unresolved external symbol _MainTask referenced in function __Thread@4 UI_SIM C:\EVO_WIN32\jura_evohome_main_app\GUISim.lib(SIM_GUI_App.OBJ)

Do you know how to solve this?

didnt you find any solution ???

Thanks, helped for me as well...

I write a solution in C++.

here is the link: https://khobaib529.medium.com/solving-electrical-circuits-a-graph-based-algorithm-for-resistance-calculations-921575c59946

I created a conversation using conversation memory then asked the llm to summarize the conversation. If you use a vector database to initialize the conversation then assess the memory message chat history

conversation = [
    {"user": "Hey Louise, can you help me with something?"},
    {"ai": "Of course! What do you need help with today?"},
    {"user": "I’m trying to organize a surprise birthday party for my friend. Any ideas?"},
    {"ai": "That sounds fun! What does your friend enjoy? We can brainstorm a theme based on their interests."},
    {"user": "They love the outdoors and hiking. I was thinking of doing something in a park."},
    {"ai": "Great idea! How about a picnic party? You could set up a cozy area with blankets, snacks, and decorations that reflect nature. Maybe even some outdoor games!"},
    {"user": "I love that! What kind of snacks should I include?"},
    {"ai": "Consider packing finger foods that are easy to eat outdoors. Sandwiches, fruit skewers, veggie platters, and some homemade cookies would be perfect. Don’t forget refreshing drinks!"},
    {"user": "Good call! How about decorations? I want it to feel special."},
    {"ai": "You could use biodegradable decorations like paper lanterns, wildflower bouquets, and string lights. A nature-themed cake would also be a nice centerpiece!"},
    {"user": "These are awesome suggestions! How many people should I invite?"},
    {"ai": "It depends on the size of the park area you’ll be using. A smaller group of close friends might make it feel more intimate, while a larger group could bring more energy. What do you think?"},
    {"user": "Maybe around 10-15 people. That feels manageable."},
    {"ai": "Perfect! Just remember to send out the invites soon so everyone can mark their calendars. Do you need help with the invitation wording?"},
    {"user": "Yes, please! I want it to be fun and casual."},
    {"ai": "How about this: “Join us for a surprise outdoor adventure to celebrate [Friend’s Name]’s birthday! Bring your favorite snacks and your love for nature. Let’s make some unforgettable memories!”"},
    {"user": "I love it! Thanks, Louise. You’ve been a huge help."},
    {"ai": "Anytime! Have a blast planning the party, and let me know if you need anything else."}
]

def example_tool(input_text):
    system_prompt = "You are a Louise AI agent. Louise, you will be fair and reasonable in your responses to subjective statements. Logic puzzle the facts or theorize future events or optimize facts providing resulting inferences. Think"
    return f"{system_prompt} Processed input: {input_text}"

# Initialize the LLM
llm = LangChainChatOpenAI(model="gpt-4o-mini", temperature=0, openai_api_key=key)

# Define tools
tools = [
    Tool(
        name="ExampleTool",
        func=example_tool,
        description="A simple tool that processes input text."
    )
]

# Initialize memory
memory = ConversationBufferMemory(memory_key="chat_history", return_messages=True)

# Loop through the conversation and add messages to memory
for message in conversation:
    if "user" in message:
        memory.chat_memory.add_user_message(message["user"])
    elif "ai" in message:
        memory.chat_memory.add_ai_message(message["ai"])

# Initialize the agent with memory
agent = initialize_agent(
    tools,
    llm,
    agent=AgentType.ZERO_SHOT_REACT_DESCRIPTION,
    verbose=True,
    handle_parsing_errors=True,
    memory=memory
)

# Query to recall previous discussion
query = "Tell me in detail about our previous discussion about the party. Louise enumerate the foods that will be served at the party."
response = agent.run(query)

# Print the response
print(response)


print(memory.chat_memory.messages)

download links 32bit and 64 bit -

https://cdn.mysql.com/archives/mysql-8.0/mysql-server_8.0.33-1ubuntu18.04_amd64.deb-bundle.tar

https://cdn.mysql.com/archives/mysql-8.0/mysql-server_8.0.33-1ubuntu18.04_i386.deb-bundle.tar

https://downloads.mysql.com/archives/community/?version=8.0.33

thanks

Ionic provides ion-footer component. https://ionicframework.com/docs/api/footer

with the help of one of my friends here who guided me, I modified the js code like this:

window.onscroll = function () {
    Scroll_Indicator_blog_function()
};

function Scroll_Indicator_blog_function() {
    var winScroll = document.body.scrollTop || document.body.scrollTop;
    var height = document.body.scrollHeight - document.body.clientHeight;
    var scrolled = (winScroll / height) * 100;
    document.getElementById("Scroll_Indicator_blog").style.width = scrolled + "%";
}

.progress-container {
    position: fixed;
    top: 0;

    display: block;
    width: 100%;
    height: 8px;
    background: var(--vesal-background-color7);
    z-index: 9999;
}
.progress-bar {
    height: 100%;
    background: var(--vesal-background-color2);
    box-shadow: 0 5px 10px 0 var(--vesal-boxshadow-color-1);
    width: 0%;
    transition: ease-in-out 0.5s;
}

<div class="progress-container">
    <div class="progress-bar" id="Scroll_Indicator_blog"></div>
</div>

But now I came to a new problem! In the height calculated by this script, the height continues from the highest point of the Mojo account to the bottom of the page, that is, from the top of the header to the bottom of the footer, which is naturally not interesting to show how much of the content has been read by the reader! How can I make it so that the height is only limited to the section in question, that is, for example, it counts the height of the page from the beginning of a section to its end, and does not count the comments section, header and footer? Thanks again for the advice

This also happened to me today as well. How to fix this?

were you able to modify fields via script? I had the same question and your code helped me. I'm trying to modify via mutation, but it doesn't seem to work.

did you get a working solution for this?

I have the same error. The strange thing is that it gives me error now that I recreated the project with git clone. On another pc with the same project and libraries it gives no problem.

Were you able to solve it?

https://github.com/j-oss2023/mysql-dynamic-inventory

I check your solution, but it post following problem: [WARNING]: * Failed to parse ca-dynamic-inventory-sqlserver.yaml with auto plugin: No module named 'pyodbc' [WARNING]: * Failed to parse ca-dynamic-inventory-sqlserver.yaml with yaml plugin: Plugin configuration YAML file, not YAML inventory [WARNING]: * Failed to parse ca-dynamic-inventory-sqlserver.yaml with ini plugin: Invalid host pattern 'plugin:' supplied, ending in ':' is not allowed, this character is reserved to provide a port. [WARNING]: Unable to parse ca-dynamic-inventory-sqlserver.yaml as an inventory source [WARNING]: No inventory was parsed, only implicit localhost is available

Do you have any suggest?

How did you get on using the API? Was this before they put it behind a paywall? If not do you mind me asking what the fees are?

I really appreciate any help you can provide.

I am facing the same issue, I created the NCC, I am able to reach from onprem. yet, when not able to send traffic to the internet, thus I created a VPN tunnel between HUB-SPOKE, and a default route using the tunnel from the spoke and a reverse route to the nodes subnet on the HUB, yet the Traffic is intermittent, return traffic is lost somewhere. I really appreciate to share the best practice, so the solution proposed will be able to assist all possible traffic scenarios (will the DNS-based endpoint solve it) rather than using a mix of NCC+VPN

Thanks,

I am not sure why my previous answer was hidden.

There is a possibility to report the issue in this window. Please send me an ID of the reported issue.

If you are unable to do it, then please create a ticket via YouTrack: https://youtrack.jetbrains.com/newIssue

Thank you!

Answer from @xtermi2 worked for me. i can't upvote so

Access error, Run in admin access and reinstall the base files again.

I am facing similar issue, and when I appended "voip" to the app bundle (e.g., bundleID.voip), the server-side error changed from 500 to 200, indicating success. However, I am still not receiving the VOIP push notifications in my app.

i have the same issue, did you resolve it ?

I can't say anything based on this information. Did you remember to run npm install? Which command are you using to start the application?

Did you find the solution to this problem? The above solution did not work.

The meta comment:

Why is this so muddled? One wonders why bother using submodules at all?

You want a sparkline. Sadly, it's not available in Tensorboard at the moment. See this discussion

I took a peek at the source for requests and found this comment:

https://github.com/psf/requests/blob/23540c93cac97c763fe59e843a08fa2825aa80fd/src/requests/certs.py#L10C1-L12C20

If you are packaging Requests, e.g., for a Linux distribution or a managed environment, you can change the definition of where() to return a separately packaged CA bundle

This is supported by the docs as well: https://requests.readthedocs.io/en/stable/user/advanced/#ca-certificates which states that requests merely relies on the certifi package.

so, you can look at the certifi source and figure out how to monkey patch the where function.

https://github.com/certifi/python-certifi/blob/master/certifi/core.py

I don't see anything in the certifi source that reads from a place other than the pem file packaged with it.

Perhaps you and your client have different versions of python/certfi installed on your systems and aligning them would help?

Thanks, Mark

Any other solution how to make nextjs with next-auth working with laravel sanctum using CSRF cookie based authentication?

How does one get this to work in python code?

int x = (int)Char.GetNumericValue(char)

I have still same problem and putting locale as last paramter in query string did not help, any updates ?

uhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh

enter image description here

enter image description here

change the version you used in the implementation to earlier version - i used 6.0.3 - , if you have the same error you might uses a package that implements the version 6.1.0 -in my case it was "usb-serial-0.5.2" -, so you need to change the version in the package build gradle too, go to your project on android studio => external libraries => Flutter plugins=> the package ,and change the version from dependencies as you did with the build gradle file of your project

How do you find your path, here is simple trick:

1. first step when your archive build is successful then the modal will show where you validate the app.
2. here if the erros comes like Invalid Executable. The executable '***.app/FBSDKCoreKit/FBSDKCoreKit.framework/hermes' contains bitcode. (ID: 37fb02b5-0173-4c01-8d79-88a9cf6a33d8) then you have to do, how you can handle this just do copy this from your error and placed in the below solution

framework_paths = [
      "Pods/FBSDKCoreKit/XCFrameworks/FBSDKCoreKit.xcframework/ios-arm64/FBSDKCoreKit.framework/FBSDKCoreKit",
      "Pods/FBSDKShareKit/XCFrameworks/FBSDKShareKit.xcframework/ios-arm64/FBSDKShareKit.framework/FBSDKShareKit",
      "Pods/FBAEMKit/XCFrameworks/FBAEMKit.xcframework/ios-arm64/FBAEMKit.framework/FBAEMKit",
      "Pods/FBSDKCoreKit_Basics/XCFrameworks/FBSDKCoreKit_Basics.xcframework/ios-arm64/FBSDKCoreKit_Basics.framework/FBSDKCoreKit_Basics",
      "Pods/FBSDKGamingServicesKit/XCFrameworks/FBSDKGamingServicesKit.xcframework/ios-arm64/FBSDKGamingServicesKit.framework/FBSDKGamingServicesKit",
      "Pods/FBSDKLoginKit/XCFrameworks/FBSDKLoginKit.xcframework/ios-arm64/FBSDKLoginKit.framework/FBSDKLoginKit",
    ]

All the lines in framework_paths are errors that come when I try to validate or upload the build. So most people face issue here that they don't know how to find the path of this framework, So you don't need to find it using commands.You can just use this template and if in your case different frameworks causing this bitCode error then just simply replace them. In my case if I receive the error of hermes-engine then what I will do I simply copy this from xcode and replace it

  "Pods/FBSDKCoreKit/XCFrameworks/FBSDKCoreKit.xcframework/ios-arm64/FBSDKCoreKit.framework/FBSDKCoreKit",

  "Pods/hermes-engine/XCFrameworks/hermes-engine.xcframework/ios-arm64/hermes-engine.framework/hermes-engine",

here I replace FBSDKCoreKit ---> hermes-engine
FBSDKCoreKit.xcframework  ---> hermes-engine.xcframework
FBSDKCoreKit.framework  ---> hermes-engine.framework
FBSDKCoreKit  ---> hermes-engine

In this way you can solve this error. So finally what you have to write in pod file

replace this code portion

react_native_post_install(
   installer,
   # Set `mac_catalyst_enabled` to `true` in order to apply patches
   # necessary for Mac Catalyst builds
   :mac_catalyst_enabled => false
 )
 __apply_Xcode_12_5_M1_post_install_workaround(installer)

with--------------------->

bitcode_strip_path = `xcrun --find bitcode_strip`.chop!
    def strip_bitcode_from_framework(bitcode_strip_path, framework_relative_path)
      framework_path = File.join(Dir.pwd, framework_relative_path)
      command = "#{bitcode_strip_path} #{framework_path} -r -o #{framework_path}"
      puts "Stripping bitcode: #{command}"
      system(command)
    end

    framework_paths = [
      "Pods/FBSDKCoreKit/XCFrameworks/FBSDKCoreKit.xcframework/ios-arm64/FBSDKCoreKit.framework/FBSDKCoreKit",
      "Pods/FBSDKShareKit/XCFrameworks/FBSDKShareKit.xcframework/ios-arm64/FBSDKShareKit.framework/FBSDKShareKit",
      "Pods/FBAEMKit/XCFrameworks/FBAEMKit.xcframework/ios-arm64/FBAEMKit.framework/FBAEMKit",
      "Pods/FBSDKCoreKit_Basics/XCFrameworks/FBSDKCoreKit_Basics.xcframework/ios-arm64/FBSDKCoreKit_Basics.framework/FBSDKCoreKit_Basics",
      "Pods/FBSDKGamingServicesKit/XCFrameworks/FBSDKGamingServicesKit.xcframework/ios-arm64/FBSDKGamingServicesKit.framework/FBSDKGamingServicesKit",
      "Pods/FBSDKLoginKit/XCFrameworks/FBSDKLoginKit.xcframework/ios-arm64/FBSDKLoginKit.framework/FBSDKLoginKit",
    ]

    framework_paths.each do |framework_relative_path|
      strip_bitcode_from_framework(bitcode_strip_path, framework_relative_path)
    end
    

Thats it

Resolved in a strange way. I've been experimenting a bit and when I changed the statement

var obj = {TYPE: item.getTitle(), DATE: item.getAllDayStartDate()}

to this:

var obj = {TYPE: item.getTitle(), DATE: (item.getStartTime() + (3 * HOUR))}

I didn't get the (wrong) start time + 3 hours, which would put the event at the correct date. Instead I now get the correct date and time, including the deviation from UTC time as 'GMT+0100'. This is what I originally wanted. Maybe adding an amount of time to the result of item.getStartTime() implicitly converts the result to local time???

Thanks for Bryan Latten. It's work for me

You can get the file/ item versions using the endpoint described at https://aps.autodesk.com/en/docs/data/v2/reference/http/projects-project_id-versions-POST/

You may need to specific the source url. Please refer to this https://github.com/CocoaPods/CocoaPods/issues/12679

I think its from input, make sure input parameter is numbers.

sorry i dont have reputation to comment.

How to do Alexa development by only communicating with my server and not using AWS? Does anyone know? I pay

Have you found a solution for this? I've also done all tweakable configs in Cloudflare, it's still wont work. It works when I'm directly accessing my app via VPS / Traefik, but when its hidden behind Cloudflare nothing happens lol.

There are now some online converters, such as: https://catherinearnould.com/autres/resx/ which worked well for me.

is it possible to define the bucket "le" size somehow per configuration that it do not generate the values by it self?

Something where I can say buckets le of : [0.05, 0.1, 0.3, 0.5, 1, 3, 5, 10, 30]

Seems to be possible in nestJS. But I can't find it for spring boot

Thanks,

Tom

Please,

is there any new update for Outlook 2024/Outlook WEB and .NET 8 ? In new outlook drag and drop function starts like:

private void Form1_DragEnter(object sender, DragEventArgs e)
{
    if (e.Data.GetDataPresent("Chromium Web Custom MIME Data Format"))
        e.Effect = DragDropEffects.Copy;
    else
        e.Effect = DragDropEffects.None;
}

private void Form1_DragDrop(object sender, DragEventArgs e)
{
    if (e.Data.GetDataPresent("Chromium Web Custom MIME Data Format"))
    {
        var data = e.Data.GetData("Chromium Web Custom MIME Data Format");
        if (data is MemoryStream memoryStream)
        {
            var bytes = memoryStream.ToArray();
            var rawText = Encoding.UTF8.GetString(bytes);
            Debug.WriteLine(rawText);
        }
    }
}

But this is not working properly. Please can somebody help mi to get content of email (text, assigned files,...) from copy paste & new Outlook version?

Thank you.

Are you still looking a solution for this?

i am trying to paste a link to see if it works , it does not have anything related to the question - https://youtu.be/3wCnVvdrqy8?si=9aZg06kxh9yN_LmZ

hello please i need the code that used on this rectangular image to use it on my project

I've another issue: when I try " sudo apt update
sudo apt install python3-can " or " pip install python-can "

the strings/words 'apt' and 'install' are counsidered as invalid syntax, how can I deal whith that ?

I update from 0.62.2 to 0.76.1 have same issue so i add includeBuild('../node_modules/react-native-gradle-plugin') in settings.gradle is worked. run yarn why react-native-gradle-plugin if have path is success.

Unfortunately, we are facing the same problem. However, the root cause is that Marten does not support SoftDelete if you are using any kind of AggregateProjection. I found this issue - https://github.com/JasperFx/marten/issues/1992 but it seems to have been closed because it is no longer planned to be solved.

Can you please report these issues using the button in this window? There will appear an id of the issue, you can click on its ID and you will see the link of the report. Can you please provide several links on these reports? Thank you!

Is there a solution yet? I'm having this problem too!

check this link of a tutorial it might be helpful https://youtu.be/i8Xsb3Es04Y

did you figure out to solve this problem?

I have the same problem with the Firefox debugger, that the line numbers of the objects are not displayed. With the Chrome debugger everything is fine. Is there a solution in 2024?

VS Code: v1.95.2 Debugger for Firefox extension: v2.9.11 Code to be debugged: Typescript

Thanks

gfdgdf fsssssssssssss dfdfsfds

I also have a similar problem, I set TenantId value inside the constructor, but migration does not works, Can not creates an instance public TenantDbContext(DbContextOptions<TenantDbContext> options, IMemoryCache memoryCache, IHttpContextData contextData, ICryptography cryptography, IConfiguration configuration, IDbUtilities dbUtilities, ISharedLocalizer sharedLocalizer, SeedStatikReferanslar seedStatikReferanslar, SeedRefTip seedSystemReferanslar, SeedReferanslar seedReferanslar, bool DoNotSeedDB = false) : base(options) { _memoryCache = memoryCache; _contextData = contextData; _seedStatikReferanslar = seedStatikReferanslar; _configuration = configuration; _dbUtilities = dbUtilities; _seedSystemReferanslar = seedSystemReferanslar; _seedReferanslar = seedReferanslar; DoNotSeed = DoNotSeedDB; _cryptography = cryptography; _sharedLocalizer = sharedLocalizer; CurrentSingleDbMode = contextData.SingleDbMode; CurrentTenantId = contextData.TenantId; } i need those two current values for singledatabase tenants and global query, app is working like it should be but migration doesn't , is anyone have any solution ?

have you faced this issue again since last fix? I am facing the same case with you now.

i also have the same problem could you assist me as well

contact xperlet web development company they will help you.

You need to understand scope, in particular where 'height' and 'width' are visible. Understanding Scope and Visibility in C#

use the debugger to identify where code is breaking, but I can say according to you error message it would be error in your mongodb, could you tell me more about error and see which request method you are using.

You can add the for both ndk and abi filters like this shown in screenshort

I'm building an app for my college graduation project.

I need to get users goodreads data with OAuth, and the rating of the books etc.

How can I do that? Can I get a legacy api or an api just for my project, the prof insists that I find a way to do it.

1.You can define _DISABLE_CONSTEXPR_MUTEX_CONSTRUCTOR as an escape hatch.

2.Or update the msvcp140.dll

reference: https://developercommunity.visualstudio.com/t/Visual-Studio-17100-Update-leads-to-Pr/10669759?sort=newest

I want to apply to all classes in my project. Not just OrderModel, Orders. Do you have any idea?

Out of curiosity, what OS are you using?

If it's Windows, is it the "classic" or the new Outlook?

Have you been able to solve this problem? I am also getting the error with same logs here. Please do let me know if anyone found the solution.

I have the same issue for whole day. Did you manage to solve it?

Did you manage to find a fix @Byofuel? I'm having exactly the same issue with firebase version 11.0.1 and @stripe/firestore-stripe-payments version 0.0.6. It also suddenly stopped working without any code changes.

I have same issue. Look like dblink is not table to utilize public IP to make connections. I see this even when using same connection string as psql on console. Workaround is you need to use private ip to connect. I believe this is a bug in AWS, not sure in what though.

Did you manage to set up the PageView event correctly for both web and server-side tracking? I’m curious if you were able to integrate both browser pixel tracking and CAPI without duplicating the events. Could you also share what your code looks like for the custom HTML (page_view event in web GTM) tag with the event_id included? It would be very helpful to see how you implemented it. Thanks

Según mis avanzados conocimientos recomiendo q pruebes a espabilar

@NSRL Can you please share the alternative function that you used? I downgraded my botorch version to 0.10.0 but it didn't work.

I am experiencing the same thing. I also get an error by credentials (under the error by credential chart at the same time as the API method error). Is this purely a google related server issue or is there a problem with my API usage?

https://i.sstatic.net/ixPnitj8.png

Error Message 1 error has occurred Session state protection violation: This may be caused by manual alteration of protected page item P3_TOTAL_AMOUNT. If you are unsure what caused this error, please contact the application administrator for assistance. how can i resolve it?

Good afternoon,

I am not trained in VBA. But I am trying to use it, similar to the request above, to export unique Excel files to a folder for each unique Vendor Code in a data set. I have the data in a Table, Query and a Form.

Bascially, I any section of the above VBA showing "QueryName" and "CustomerName" to match my database. I also added the file path where I want the files placed after the "EXPORT. Lastly, I even made a "MyTempQuery" even though I am not aware of the function.

I tried the above but it is not working. Is there anyone that could walk me through it since I may not know all of the modifications I may need to make to match my database?

Happy to get on a Teams call or anything at this point...

Use Xcodes https://github.com/XcodesOrg/XcodesApp/releases/tag/v2.4.1b30 Download Xcodes app and use whatever Xcode version is required.

I have written a Sparx repository query to obtain "data element lineage". I have a source model in XML and the target is imported from Oracle. We have mapped the source XSDelement(s) to the destination database columns in Sparx using connector_type = 'Information Flow' as the base class and a custom stereotype = 'ETLMapping'. Below is the query/view I am using.

[Near the top of the query you will see a literal package name, 'Workday ETL Mapping'. This package defines the scope for the query; it contains the several diagrams which have the ETL source/target mappings defined.]

The Sparx view definition script follows...

USE [SparxProjects]
GO

/****** Object:  View [dbo].[vSparx_Workday_ETL_Source_Target_Object_Element_Mapping]    Script Date: 11/13/2024 2:26:02 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create    view [dbo].[vSparx_Workday_ETL_Source_Target_Object_Element_Mapping]
as

With cte_workday_etl_package_diagram    as
(select distinct 
    p.Package_ID
    ,p.Name         Package_Name
    ,d.Diagram_ID   
    ,d.Name         Diagram_Name
from t_diagram    d
    inner join t_package p      on (d.Package_ID = p.Package_ID )
where p.Name    = 'Workday ETL Mapping'
)                       

,   cte_workday_etl_package_diagram_object      as
(select     distinct 
    pd.Package_ID                                               
    ,do.Diagram_ID  
    ,do.Object_ID
    ,o.Name         Object_Name
    ,o.Object_Type
    ,o.Stereotype   Object_Stereotype                                               
    ,pd.Package_Name                                
    ,pd.Diagram_Name                        
from t_diagramobjects       do
inner join  cte_workday_etl_package_diagram     pd
        on  (pd.Diagram_ID  =   do.Diagram_ID)
inner join  t_object    o   
        on  (o.Object_ID    =   do.Object_ID)
where
(o.Object_Type  =   'Class'
        and o.Stereotype    in  ('XSDComplexType', 'Table')
)
)       

,   cte_workday_etl_diagram_object_element  as
(select         distinct
                pdo.Object_ID       ETL_Object_ID
                ,pdo.Object_Name    ETL_Object_Name
                ,attr.Name          ETL_Element_Name
                ,attr.ea_guid       ETL_Element_guid    --will be used to join connector end info
                
from        cte_workday_etl_package_diagram_object      pdo
inner join  t_attribute attr    on  (attr.Object_ID =   pdo.Object_ID)
)    

, cte_conn_end_guids    as
(select conn.connector_id
    ,conn.StyleEx
    ,SUBSTRING(conn.StyleEx  
        ,CHARINDEX('{' ,SUBSTRING(conn.StyleEx,1,100))          --start
        ,(CHARINDEX('}', SUBSTRING(conn.StyleEx,1,100))         --right_curly_bracket                       
            -   CHARINDEX('{',SUBSTRING(conn.StyleEx,1,100))    --first left_curly_bracket
            + 1 )                                               --length
    )                       "first_guid_value"  
    ,SUBSTRING(
        conn.StyleEx                                    --expression
        ,CHARINDEX(';' , SUBSTRING(conn.StyleEx,1,100)) + 6                 --start of guid substring
        ,len(conn.StyleEx) - CHARINDEX(';' , SUBSTRING(conn.StyleEx,1,100)) - 7  --length of substring 
    )                       "second_guid_value" 

    ,case 
        when    (SUBSTRING(conn.StyleEx , 1, 2 ) =  'LF'
                and     SUBSTRING(conn.StyleEx , 3, 1 ) =   'S')
        then    'START_CONN_GUID'
        when    (SUBSTRING(conn.StyleEx , 1, 2 ) =  'LF'
                and     SUBSTRING(conn.StyleEx , 3, 1 ) =   'E')
        then    'END_CONN_GUID'
        else    null
    end     "FirstConnEndDirection"

    ,case 
        when    (SUBSTRING(conn.StyleEx 
                        ,CHARINDEX(';' ,conn.StyleEx,1 ) + 1
                        , 2
                        )   =   'LF'                
                and     
                    (SUBSTRING(conn.StyleEx 
                        ,CHARINDEX(';' ,conn.StyleEx,1) + 3
                        , 1
                        )   =   'E'             
                    )
                )
        then    'END_CONN_GUID'
        when    (SUBSTRING(conn.StyleEx 
                        ,CHARINDEX(';' ,conn.StyleEx,1 ) + 1
                        , 2
                        )   =   'LF'                
                and     
                    (SUBSTRING(conn.StyleEx 
                        ,CHARINDEX(';' ,conn.StyleEx,1) + 3
                        , 1
                        )   =   'S'             
                    )
                )
        then    'START_CONN_GUID'
        else    null
    end     "SecondConnEndDirection"

from    dbo.t_connector  conn   
where   conn.StyleEx is not null
    and     conn.Connector_Type =   'InformationFlow' 
    and     conn.Stereotype     =   'ETLMapping'
    and     conn.Start_Object_ID    in (select pdo.object_id  
                from     cte_workday_etl_package_diagram_object pdo)
    and     conn.End_Object_ID      in (select pdo.object_id  
                from     cte_workday_etl_package_diagram_object pdo)
)

, cte_start_conn_elements       as
(   select conn.connector_id
,sattr.Name             Start_Element_Name
,sattr.Type             Start_Element_Type
,sattr.Stereotype       Start_Element_Stereotype
,sattr.ea_guid          Start_Element_guid
,sattr.ID               Start_Element_ID
,sattr.Object_ID        Start_Element_Object_ID
,sattr.Notes            Start_Element_Notes
from cte_conn_end_guids     conn
inner join t_attribute  sattr   on (sattr.ea_guid   =   conn.first_guid_value
                                    and conn.FirstConnEndDirection  =   'START_CONN_GUID'
                                    )
UNION
select conn2.connector_id
,eattr.Name             Start_Element_Name
,eattr.Type             Start_Element_Type
,eattr.Stereotype       Start_Element_Stereotype
,eattr.ea_guid          Start_Element_guid
,eattr.ID               Start_Element_ID
,eattr.Object_ID        Start_Element_Object_ID
,eattr.Notes            Start_Element_Notes
from cte_conn_end_guids     conn2
inner join t_attribute  eattr   on (eattr.ea_guid   =   conn2.second_guid_value
                                    and conn2.SecondConnEndDirection    =   'START_CONN_GUID'   
                                    )
)    
, cte_end_conn_elements     as
(   select conn.connector_id
,eattr.Name             End_Element_Name
,eattr.Type             End_Element_Type
,eattr.Stereotype       End_Element_Stereotype
,eattr.ea_guid          End_Element_guid
,eattr.ID               End_Element_ID
,eattr.Object_ID        End_Element_Object_ID
,eattr.Notes            End_Element_Notes
from cte_conn_end_guids     conn
inner join t_attribute  eattr   on (eattr.ea_guid   =   conn.first_guid_value
                                    and conn.FirstConnEndDirection  =   'END_CONN_GUID'
                                    )
UNION
select conn2.connector_id
,eattr.Name             End_Element_Name
,eattr.Type             End_Element_Type
,eattr.Stereotype       End_Element_Stereotype
,eattr.ea_guid          End_Element_guid
,eattr.ID               End_Element_ID
,eattr.Object_ID        End_Element_Object_ID
,eattr.Notes            End_Element_Notes
from cte_conn_end_guids     conn2
inner join t_attribute  eattr   on (eattr.ea_guid   =   conn2.second_guid_value
                                    and conn2.SecondConnEndDirection    =   'END_CONN_GUID' 
                                    )
)

, cte_workday_etl_connector_objects_elements        as
(select 
spdo.Diagram_ID
,spdo.Diagram_Name
,spdo.Package_ID
,spdo.Package_Name
,seconn.Connector_ID
,spdo.Object_Name           Start_Object_Name
,spdo.Object_Type           Start_Object_Type
,spdo.Object_Stereotype     Start_Object_Stereotype
,seconn.Start_Element_Name
,seconn.Start_Element_Object_ID
,seconn.Start_Element_Type
,seconn.Start_Element_Stereotype
,seconn.Start_Element_guid
,seconn.Start_Element_ID
,seconn.Start_Element_Notes

,epdo.Object_Name           End_Object_Name     
,epdo.Object_Type           End_Object_Type
,epdo.Object_Stereotype     End_Object_Stereotype
,eeconn.End_Element_Name
,eeconn.End_Element_Object_ID
,eeconn.End_Element_Type
,eeconn.End_Element_Stereotype
,eeconn.End_Element_guid
,eeconn.End_Element_ID
,eeconn.End_Element_Notes

from cte_start_conn_elements    seconn
inner join cte_end_conn_elements    eeconn
    on (seconn.Connector_ID =   eeconn.Connector_ID)

inner join  cte_workday_etl_package_diagram_object  spdo
        on  (spdo.Object_ID =   seconn.Start_Element_Object_ID)
inner join  cte_workday_etl_package_diagram_object  epdo
        on  (epdo.Object_ID =   eeconn.End_Element_Object_ID)
)

select  distinct
    s_t_element_mapping.Diagram_ID
    ,s_t_element_mapping.Diagram_Name
    ,s_t_element_mapping.Package_ID
    ,s_t_element_mapping.Package_Name
    ,s_t_element_mapping.Connector_ID
    ,s_t_element_mapping.Start_Object_Name
    ,s_t_element_mapping.Start_Object_Type
    ,s_t_element_mapping.Start_Object_Stereotype
    ,s_t_element_mapping.Start_Element_Name
    ,s_t_element_mapping.Start_Element_Object_ID
    ,s_t_element_mapping.Start_Element_Type
    ,s_t_element_mapping.Start_Element_Stereotype
    ,s_t_element_mapping.Start_Element_guid
    ,s_t_element_mapping.Start_Element_ID
    ,s_t_element_mapping.Start_Element_Notes

    ,s_t_element_mapping.End_Object_Name        
    ,s_t_element_mapping.End_Object_Type
    ,s_t_element_mapping.End_Object_Stereotype
    ,s_t_element_mapping.End_Element_Name
    ,s_t_element_mapping.End_Element_Object_ID
    ,s_t_element_mapping.End_Element_Type
    ,s_t_element_mapping.End_Element_Stereotype
    ,s_t_element_mapping.End_Element_guid
    ,s_t_element_mapping.End_Element_ID
    ,s_t_element_mapping.End_Element_Notes

from    cte_workday_etl_connector_objects_elements    s_t_element_mapping

GO

Thanks to Geert Bellekens at https://sparxsystems.com/forums and https://stackoverflow.com/users/3379653/qwerty-so for their helpful remarks and suggestions.

Reply here with any improvement suggestions or error discoveries. Sorry about the formatting, it parsers fine in SQL.

Best, CCW

CreateFile(A/W) will not work on Windows 98 because, according to the description on MSDN, the minimum client is Windows XP. Maybe you should try using C "fopen" function, for example?

Is there any possibility to return zero instead of null value??

Didn't realize that I could get the result I needed by changing the ChartType from Column to StackedColumn even though I have only one item in the stack...

Also note extracting the folder creates a nested folder with the same name. Be sure to drill into the second folder at the extraction path: bike-data\bike-data to select the leaf folder, to select it, otherwise you may get the same error.

did you manage to make it work? Same here although having instagram_business_* permissions in Advanced Access. The API only returns the username of the owner of the media.

Try upgrading Android Gradle Plugin version to 8.1.0 as mentioned here Firebase Initialization Crash After Updating com.google.gms:google-services to 4.4.0

I'm facing the same issue, but no solution found for now.

same issue can not found the api to upload :((

How many transactions are you using to test performance? Or are you just profiling the Query paths?

@aria_label works and will render to aria-label

SI las copio local false, me cambia el error a Error al conectar a SAP BusinessObjects: Could not load file or assembly 'CrystalDecisions.Enterprise.Framework, Version=14.0.4000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'. El sistema no puede encontrar el archivo especificado.

Im also having trouble with this... Everytime I try to pass a link within the content posted through API, the url goes blank on wordpress, as it had never existed on the content...

any clues, anyone?

Have you tried running it in a different thread?

having the same issue here, did you solve?, if so how.