Re: Open File - C# Discussion Boards

Re: How to create a layout with a scroll view at top and three buttons at bottom in Xamarin?

Richard Deeming15-Jul-21 21:02

15-Jul-21 21:02

In WPF, you'd use a DockPanel. As far as I can see, that doesn't exist for Xamarin; but the FlexLayout[^] looks like it should work.

XAML

<FlexLayout Direction="Column">
    <ScrollView FlexLayout.Grow="1">
        ...
    </ScrollView>
    <Grid>
        ...
    </Grid>
</FlexLayout>

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: How to create a layout with a scroll view at top and three buttons at bottom in Xamarin?

Gerry Schmitz16-Jul-21 4:47

Gerry Schmitz

16-Jul-21 4:47

You don't need an outter StackLayout.

Top rows should be * and Auto, in that order.

The button Grid only has 1 row, and you let it default to the first row of the top Grid.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Open File

f6115-Jul-21 5:24

f61

15-Jul-21 5:24

Hi Everyone
I need to open and read this file with c#.net and this is emergency for me, unfortunately I have never worked with this type of file.

the file is at this address:
20200304.ZIP [LINK REMOVED - OriginalGriff]
could you please help me.
Thank you all.

Re: Open File

OriginalGriff15-Jul-21 5:28

OriginalGriff

15-Jul-21 5:28

I removed the link as we have no idea what the file contains, and do not wish to find out.
Posting files to dodgy upload sites and assuming it will be downloaded is not a good idea.

That's a ZIP file: which just means it's a compressed archive, like a "portable folder".

The .NET framework contains classes for opening, reading, and writing them: ZipFile Class (System.IO.Compression) | Microsoft Docs[^] so that should be the first place you start reading.

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Re: Open File

f6115-Jul-21 6:24

f61

15-Jul-21 6:24

No, No .. The I dont want to Opening Zip File I want to open a Tag file , it is dataflex,
Sorry i didn't know it is againts the rule of your web site. but I cant upload file here Frown | :(

what should I do?

Re: Open File

Gerry Schmitz15-Jul-21 6:32

Gerry Schmitz

15-Jul-21 6:32

And you didn't think it important to mention that in the first place? In an "emergency"? Must be the panic. Ok, we'll let it go this time.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Re: Open File

Richard Deeming15-Jul-21 6:38

Richard Deeming

15-Jul-21 6:38

So this is a repost of your previous thread?
.Tag File - C# Discussion Boards[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Open File

Richard Andrew x6415-Jul-21 13:49

Richard Andrew x64

15-Jul-21 13:49

There's no real need to upload the file anywhere, unless you are paying someone to take a look at it and see if they can parse it.

The difficult we do right away...
...the impossible takes slightly longer.

Re: Open File

Pete O'Hanlon17-Jul-21 22:38

Pete O'Hanlon

17-Jul-21 22:38

A Dataflex tag file is simply a line delimited ASCII file. You can read it using File.ReadAllLines.

Advanced TypeScript Programming Projects

Re: Open File

f6118-Jul-21 6:33

f61

18-Jul-21 6:33

Hi Pete O'Hanlon and Thanks.

Yes, I Installed DataFlex Studio 20, and Opened Tag File By it, And also used ReadAllLine by Encoding.ASCII. But Unfortunatley the Output is same :
\0\0\0\0\0\0\0\0\0\u0004 Frown | :(

Need a suggestion

simpledeveloper14-Jul-21 7:47

simpledeveloper

14-Jul-21 7:47

Hi I have a table which has 100s of 1000s of records, in it there is a column Blob which is storing a huge json string.
We got a new Tableau Reports developer, who is saying he is not able to use that Blob column to read some data from it, because he doesn't know how to handle Json in Tableau.

So he wanted me to write a Service to convert that Json string into Excel document, means it would be huge Excel documents in 1000s of numbers, if not in 100s of 1000s, can somebody please suggest me, what solution can I provide him.

I already wrote the Service to Convert but writing into 1000s of Excel files is awful, I am looking for any better approach which can be feasible for both of us. Thanks a lot in advance.

Re: Need a suggestion

OriginalGriff14-Jul-21 8:05

OriginalGriff

14-Jul-21 8:05

Point him at this: JSON File - Tableau[^]

Re: Need a suggestion

simpledeveloper14-Jul-21 14:48

simpledeveloper

14-Jul-21 14:48

He is asking for converting that into XML I will just create an another table out of this Database and convert and post it over there, simple jSon would have been better but he is saying he doesn't know

Re: Need a suggestion

OriginalGriff14-Jul-21 19:03

OriginalGriff

14-Jul-21 19:03

Sounds like he needs to start learning how to do his job ... Sigh | :sigh:

Re: Need a suggestion

simpledeveloper15-Jul-21 22:03

simpledeveloper

15-Jul-21 22:03

But yes I did send him the jSon now we are trying to write a generic SQL Query to read from jSon string instead of conversions, then he wanted me to help him in that I am trying using OpenjSon, do you know any idea how to read through jSon string which has objects embedded within other objects. Any idea you have my friend.

Re: Need a suggestion

Richard Deeming15-Jul-21 22:38

Richard Deeming

15-Jul-21 22:38

If it's Microsoft SQL Server, the documentation is pretty good:
OPENJSON (Transact-SQL) - SQL Server | Microsoft Docs[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Need a suggestion

Gerry Schmitz14-Jul-21 19:11

Gerry Schmitz

14-Jul-21 19:11

Store the data as a CSV text file; Excel opens it as a single sheet workbook.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Re: Need a suggestion

Eddy Vluggen15-Jul-21 9:20

Eddy Vluggen

15-Jul-21 9:20

Here's a suggestion; tell him to learn. JSON isn't complex; it is textbased, human readable, with plenty of tools.

My first was DBaseIV. Would you convert all to DBaseIV format if I told you JSON is too complicated?

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Re: Need a suggestion

Mycroft Holmes15-Jul-21 12:37

Mycroft Holmes

15-Jul-21 12:37

simpledeveloper wrote:
We got a new Tableau Reports developer

Send him back, he does not know how to do the job you hired him for! Calling himself a developer is disingenuous.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

Re: Need a suggestion

simpledeveloper15-Jul-21 21:55

simpledeveloper

15-Jul-21 21:55

No I didn't hire him, I neither have authority to hire him my friend

Re: Need a suggestion

jschell17-Jul-21 10:26

jschell

17-Jul-21 10:26

simpledeveloper wrote:
Hi I have a table which has 100s of 1000s of records

simpledeveloper wrote:
huge json string.

Excel limits.

32k maximum size for a cell
1,048,576 maximum rows
16,384 columns

Excel specifications and limits - Excel[^]

If you already have a 200,000 rows then a reasonable growth estimate would mean your solution would need to support 2,000,000 rows. And that is not going happen in excel.

You didn't define 'huge' nor what is in that json has but see the cell size limit and column limit. Again if you are already pushing those then growth would suggest you will exceed it.

simpledeveloper wrote:
So he wanted me to write a Service to convert that Json string into Excel document,

Is this a one time job? On demand? Once a day? Once a minute? That will impact what is reasonable in terms of how long you your job can take processing this.

simpledeveloper wrote:
convert that Json string into Excel document

Is that the only problem that it is json? Basically the acronym 'ETL' exists for this very thing. So why not do the following
1. Create another database, do not try to do this in the existing one.
2. Create a job that incrementally processes the rows and flattens outs the data into the new database.
3. Then the other person uses that database, with the data nicely parsed out to do what they want.

How to flatten it out? Well if the data is nice and stable then you could just create a table with the columns named appropriately.

If however the json is includes lots of depth and is dynamic then you will need to create a metadata solution such as a table that stores a name, and type, and perhaps another table with values. The types allows you to handle arrays and other embedded types (circular). Keeping in mind that this problem is one you would have needed to deal with an the Excel idea any ways.

This also allows the data to be kept up to date. Then it is up to them, not you, how often to actually pull the data.

c# / wpf/ xaml changing culture (language) at runtime

Maximilien14-Jul-21 2:55

Maximilien

14-Jul-21 2:55

I'm trying to change the language of our application at runtime.

I already have resx files for the different languages.

When I run this at the application startup it works; the translated (German) strings are displayed in the app.

var cultureInfo = CultureInfo.CreateSpecificCulture("de");
Thread.CurrentThread.CurrentCulture = cultureInfo;
Thread.CurrentThread.CurrentUICulture = cultureInfo;
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;

When I try changing the language later on, the language is not updated.

I call the same code in my view with the different language strings (obviously).

var cultureInfo = CultureInfo.CreateSpecificCulture("fr"); // for example if I select french
Thread.CurrentThread.CurrentCulture = cultureInfo;
Thread.CurrentThread.CurrentUICulture = cultureInfo;
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;

From what I can see That should be enough.

Is there something I'm missing ? Is there a call to update the UI I don't know about ?

Thanks.

CI/CD = Continuous Impediment/Continuous Despair

Re: c# / wpf/ xaml changing culture (language) at runtime

Richard Deeming14-Jul-21 3:01

Richard Deeming

14-Jul-21 3:01

How are you displaying the localized strings in your view? And does the problem affect views you haven't displayed yet, or only views that are already open?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: c# / wpf/ xaml changing culture (language) at runtime

Maximilien14-Jul-21 4:38

Maximilien

14-Jul-21 4:38

In XAML, something like this :

<Label Content="{x:Static properties:Resources.General_Settings}" ></Label>

as I said, if I manually set the culture when the application starts the language works.

CI/CD = Continuous Impediment/Continuous Despair

Re: c# / wpf/ xaml changing culture (language) at runtime

Richard Deeming14-Jul-21 4:48

Richard Deeming

14-Jul-21 4:48

As far as I can see, that should use the Thread.CurrentThread.CurrentUICulture to identify the resource file to use.

Are you sure you're running the code to change the language on the UI thread? And that the views weren't previously opened?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.