Working on a JSON Project

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: Working on a JSON Project

Post by sudip »

Hello Rathi,

Thanks a ton. I have a few days to work for my own. Your codes will be helpful for me.
With best regards,
Sudip
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: Working on a JSON Project

Post by sudip »

Hello,
When I am trying to compile, getting a blank error screen and following error.log:
hbmk2: Linking... json.exe
C:/hmg/mingw/bin/../lib/gcc/i686-w64-mingw32/5.3.0/../../../../i686-w64-mingw32/bin/ld.exe: cannot find -lhmgsqlite
collect2.exe: error: ld returned 1 exit status
hbmk2[json]: Error: Running linker. 1
gcc.exe .hbmk/win/mingw/Main.o .hbmk/win/mingw/about.o .hbmk/win/mingw/htmlcreate.o .hbmk/win/mingw/htmlreport.o .hbmk/win/mingw/htmlviewer.o .hbmk/win/mingw/xlexport.o .hbmk/win/mingw/xmlcreate.o .hbmk/win/mingw/_hbmkaut_Main.o C:/HMGProjects/HBJSON3.0/_temp.o -pthread -static-libgcc -static-libstdc++ -static -lpthread -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbmysql -lmysql -lhbfimage -lhbpgsql -lsddmy -lhbvpdf -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lhbodbc -lodbc32 -lhbhpdf -lhbnetio -lxhb -lpng -llibhpdf -lhbzebra -lhmgsqlite -lhbextern -lhbdebug -lhbvmmt -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib -Wl,--end-group -ojson.exe -LC:/hmg/harbour/lib/win/mingw -LC:/hmg/lib

Here is the build.log:
hbmk2: Linking... json.exe
C:/hmg/mingw/bin/../lib/gcc/i686-w64-mingw32/5.3.0/../../../../i686-w64-mingw32/bin/ld.exe: cannot find -lhmgsqlite
collect2.exe: error: ld returned 1 exit status
hbmk2[json]: Error: Running linker. 1
gcc.exe .hbmk/win/mingw/Main.o .hbmk/win/mingw/about.o .hbmk/win/mingw/htmlcreate.o .hbmk/win/mingw/htmlreport.o .hbmk/win/mingw/htmlviewer.o .hbmk/win/mingw/xlexport.o .hbmk/win/mingw/xmlcreate.o .hbmk/win/mingw/_hbmkaut_Main.o C:/HMGProjects/HBJSON3.0/_temp.o -pthread -static-libgcc -static-libstdc++ -static -lpthread -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbmysql -lmysql -lhbfimage -lhbpgsql -lsddmy -lhbvpdf -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lhbodbc -lodbc32 -lhbhpdf -lhbnetio -lxhb -lpng -llibhpdf -lhbzebra -lhmgsqlite -lhbextern -lhbdebug -lhbvmmt -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib -Wl,--end-group -ojson.exe -LC:/hmg/harbour/lib/win/mingw -LC:/hmg/lib

As I'm using HMG after a long time, I couldn't solve it now. Can anyone please help me.

Thanks in advance ;-)
With best regards,
Sudip
RPC
Posts: 281
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF

Re: Working on a JSON Project

Post by RPC »

Hi Rathinagiri
I am trying to use HBJson/UniJsonViewer to convert Json file to Excel file. I am getting following errors.
When I try to convert to Excel(Flattened)
HMG Error UniJason2XL(Flattened).png
HMG Error UniJason2XL(Flattened).png (564.84 KiB) Viewed 2942 times
When I try to convert to Excel(Ref Tables)
HMG Error UniJason2XL(RefTable).png
HMG Error UniJason2XL(RefTable).png (571.84 KiB) Viewed 2942 times
When I try to convert to XML
HMG Error UniJason2XML.png
HMG Error UniJason2XML.png (558.89 KiB) Viewed 2942 times
Finally I tried to compile json.hbp and got following blank screen.
HMG Error HBJason.png
HMG Error HBJason.png (22.95 KiB) Viewed 2942 times
I think Sudip has reported the same blank screen in immediate above post.
Can you please look into it whenever you get time.
Thanks
Rajeev
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Working on a JSON Project

Post by Rathinagiri »

Please give me some sample json file. Let me check up.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
RPC
Posts: 281
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF

Re: Working on a JSON Project

Post by RPC »

Enclosing the json file which I was trying to process.
I have downloaded it from Income tax website as prefilled return.
Attachments
ABGPB3678J.zip
(1.79 KiB) Downloaded 83 times
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Working on a JSON Project

Post by Rathinagiri »

Please update the source with this:
HBJSON3.0.zip
(122.63 KiB) Downloaded 132 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
jayadevu
Posts: 238
Joined: Tue May 19, 2009 7:10 am

Re: Working on a JSON Project

Post by jayadevu »

Hi Rathinagiri,

Thanks for the new Update. Just downloaded the same and compiled. It gives syntax error as seen in the attachement. This is the same json file which you had used in version 2. I had the same difficulty in Version 2 also. Please check.
JsonSyntaxError.PNG
JsonSyntaxError.PNG (35.84 KiB) Viewed 2803 times
]
RPC
Posts: 281
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF

Re: Working on a JSON Project

Post by RPC »

Hi Rathinagiri sir
I am still getting blank screen on compilation as shown in my post earlier.
I am using HMG 3.4.4 my os is win 10 x64
thanks
Post Reply