1. Jorge Humberto Peralta Molina
  2. PowerBuilder
  3. Wednesday, 12 August 2020 16:38 PM UTC

Hola a todos.

 

como puedo cargar archivo que contiene mas de 10,000 registros, a traves de una aplicacion appeon web? es posible? de no ser así, que otra alternativas debería usar para cargar un archivo con mas de 10,000 registros a traves de appeon web.

 

gracias

 

mike S Accepted Answer Pending Moderation
  1. Wednesday, 12 August 2020 22:31 PM UTC
  2. PowerBuilder
  3. # 1
Hola Jorge,
 

you have 2 options:

the first is the eat the elephant approach.  use fileopen and fileread to read in 1 line at a time.  If multiple lines make up a single transaction, then read more lines until you have one transaction.  do your thing and save to the database, then read in the next set of records.  if you add in a yield() you can allow some feedback to the user that it is working.  

the 2nd option is to basically build a service.  Upload the file to your server, then run your PB application either with command line arguments, pooling, or use something like https://topwizprogramming.com/topwizweb.html to run your import objects.  or you can use the c# converter in PB2019 to build it out as a full web service.

 

We use the first approach for customers to import a lot of files (both PS web and client/server).  We will be transitioning to the 2nd option in the future so that a user doesn't have to wait around for it to process.

 

 

Comment
There are no comments made yet.
Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 12 August 2020 17:35 PM UTC
  2. PowerBuilder
  3. # 2

Hola Jorge:

 

¿A qué te refieres con cargar un archivo con 10,000 registros? ¿Intentas subir un archivo csv? o ¿te refieres a cargar un DW con más de 10,000 registros?

 

 

Saludos,

Comment
  1. Jorge Humberto Peralta Molina
  2. Wednesday, 12 August 2020 21:26 PM UTC
Hola Govinda Lopez, exacto. mira en modo window cargo información en formato .csv y estos contienen al rededor de 10 o 15 mil registros que en modo window los carga sin problemas, pero ese mismo aplicativo lo publico a web se demora una eternidad y al final presenta un mensaje de time out.....por eso preguntaba si primero es factible cargar informacion a una dw de tipo csv que contiene 10,000 o incluso mas registros? y si no es posible que otra alternativas tengo para cargar esa información. saludos ojala me puedas ayudar. gracias.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.